USE [tirtanadi_ism_2] GO /****** Object: Table [dbo].[_rekap_kwit] Script Date: 3/23/2019 5:34:55 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[_rekap_kwit]( [_rekapkwitidinc] [bigint] IDENTITY(1,1) NOT NULL, [kocab] [varchar](2) NULL, [bulan] [varchar](2) NULL, [tahun] [varchar](4) NULL, [jumlah_input] [bigint] NULL, [jumlah_verifikasi] [bigint] NULL, [jumlah_diterima] [bigint] NULL, [jumlah_ditolak] [bigint] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[_rekap_kwit_tarif] Script Date: 3/23/2019 5:34:55 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[_rekap_kwit_tarif]( [_rekap_kwit_tarifinc] [bigint] IDENTITY(1,1) NOT NULL, [kocab] [varchar](2) NULL, [nm_tarif] [varchar](50) NULL, [kubikasi] [bigint] NULL, [jlh_rek] [bigint] NULL, [harga] [money] NULL, [ret_limbah] [money] NULL, [angsbersih] [money] NULL, [angsmeter] [money] NULL, [materai] [money] NULL, [biaya_adm] [money] NULL, [biaya_tetap] [money] NULL, [tagihan] [money] NULL, [bulan] [varchar](2) NULL, [tahun] [varchar](4) NULL, CONSTRAINT [PK__rekap_kwit_tarif] PRIMARY KEY CLUSTERED ( [_rekap_kwit_tarifinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[_rekap_kwit_tarif_wilayah] Script Date: 3/23/2019 5:34:55 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[_rekap_kwit_tarif_wilayah]( [_rekap_kwit_tarif_wilayahinc] [bigint] IDENTITY(1,1) NOT NULL, [kocab] [varchar](2) NULL, [kd_wly] [varchar](2) NULL, [bulan] [varchar](2) NULL, [tahun] [varchar](4) NULL, [nm_tarif] [varchar](50) NULL, [kubikasi] [bigint] NULL, [jlh_rek] [bigint] NULL, [harga] [money] NULL, [ret_limbah] [money] NULL, [angsbersih] [money] NULL, [angsmeter] [money] NULL, [materai] [money] NULL, [biaya_adm] [money] NULL, [biaya_tetap] [money] NULL, [tagihan] [money] NULL, CONSTRAINT [PK__rekap_kwit_tarif_wilayah] PRIMARY KEY CLUSTERED ( [_rekap_kwit_tarif_wilayahinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[akses_fitur] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[akses_fitur]( [aksesfituridinc] [int] IDENTITY(1,1) NOT NULL, [useridinc] [bigint] NOT NULL, [fituridinc] [int] NOT NULL, CONSTRAINT [PK_akses_fitur] PRIMARY KEY CLUSTERED ( [aksesfituridinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[akses_sub_fitur] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[akses_sub_fitur]( [aksessubfituridinc] [int] IDENTITY(1,1) NOT NULL, [useridinc] [bigint] NOT NULL, [subfituridinc] [int] NOT NULL, CONSTRAINT [PK_akses_sub_fitur] PRIMARY KEY CLUSTERED ( [aksessubfituridinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[angsab] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[angsab]( [angsabidinc] [bigint] IDENTITY(1,1) NOT NULL, [npa] [varchar](10) NULL, [biaya] [money] NULL, [dp] [money] NULL, [cicilan] [money] NULL, [angsuran] [smallint] NULL, [tgl_00] [datetime] NULL, [bulan] [varchar](2) NULL, [tahun] [varchar](2) NULL, [ke] [varchar](2) NULL, [kodeab] [varchar](2) NULL, [tgl_lunas] [datetime] NULL, [hs] [varchar](50) NULL, CONSTRAINT [PK_angsab] PRIMARY KEY CLUSTERED ( [angsabidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[angsal] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[angsal]( [angsalidinc] [bigint] IDENTITY(1,1) NOT NULL, [npal] [varchar](10) NULL, [kocab] [varchar](2) NULL, [biaya] [money] NULL, [dp] [money] NULL, [cicilan] [money] NULL, [angsuran] [smallint] NULL, [tgl_00] [datetime] NULL, [bulan] [varchar](2) NULL, [tahun] [varchar](2) NULL, [ke] [varchar](2) NULL, [kodeal] [varchar](50) NULL, [tgl_lunas] [datetime] NULL, [hs] [varchar](50) NULL, CONSTRAINT [PK_angsal] PRIMARY KEY CLUSTERED ( [angsalidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[angsurmtr] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[angsurmtr]( [angsurmtridinc] [int] IDENTITY(1,1) NOT NULL, [npa] [varchar](10) NULL, [biaya] [money] NULL, [dp] [money] NULL, [cicilan] [money] NULL, [angsuran] [int] NULL, [mulairekbln] [varchar](2) NULL, [mulairekthn] [varchar](2) NULL, [ke] [int] NOT NULL, [kode] [varchar](50) NULL, [tgl_lunas] [datetime] NULL, CONSTRAINT [PK_angsurmtr] PRIMARY KEY CLUSTERED ( [angsurmtridinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[angsurmtr] SET (LOCK_ESCALATION = DISABLE) GO /****** Object: Table [dbo].[backup] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[backup]( [backupidinc] [bigint] IDENTITY(1,1) NOT NULL, [keterangan_backup] [text] NOT NULL, [tgl_backup] [datetime] NOT NULL, [lokasi_file] [text] NOT NULL, CONSTRAINT [PK_backup] PRIMARY KEY CLUSTERED ( [backupidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[buku] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[buku]( [bukuidinc] [bigint] IDENTITY(1,1) NOT NULL, [kocab] [varchar](2) NULL, [no_buku] [varchar](6) NULL, [total_pelanggan] [int] NULL, CONSTRAINT [PK_buku] PRIMARY KEY CLUSTERED ( [bukuidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[cabang] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[cabang]( [cabangidinc] [int] IDENTITY(1,1) NOT NULL, [kd_cab] [varchar](2) NOT NULL, [nm_cab] [varchar](50) NULL, [nm_kacab] [varchar](50) NULL, [jab_kacab] [varchar](50) NULL, [nm_kasi1] [varchar](50) NULL, [jab_kasi1] [varchar](50) NULL, [nm_kasi2] [varchar](50) NULL, [jab_kasi2] [varchar](50) NULL, [alamat] [text] NULL, [jenis_tarif] [varchar](50) NULL, [rumus_catat_meter] [text] NULL, CONSTRAINT [PK_setup] PRIMARY KEY CLUSTERED ( [cabangidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[custom] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[custom]( [customidinc] [bigint] IDENTITY(1,1) NOT NULL, [kd_wly] [varchar](2) NOT NULL, [kd_jln] [varchar](2) NOT NULL, [kd_ctm] [varchar](4) NOT NULL, [kocab] [varchar](2) NOT NULL, [npal] [varchar](10) NULL, [noreg] [varchar](50) NULL, [no_buku] [varchar](6) NULL, [hal_buku] [varchar](4) NULL, [na_ctm] [varchar](255) NOT NULL, [no_rmh] [varchar](50) NULL, [status] [int] NULL, [tarif] [varchar](4) NULL, [ketstatus] [text] NULL, [type_mtr] [varchar](1) NULL, [kd_byr] [varchar](2) NULL, [kd_tagih] [varchar](2) NULL, [trblth] [varchar](12) NULL, [trf_al] [varchar](1) NULL, [luas] [float] NULL, [no_telp] [varchar](14) NULL, [kd_klastarif] [varchar](3) NULL, [psb] [varchar](2) NULL, [kabu] [varchar](50) NULL, [keca] [varchar](50) NULL, [kelu] [varchar](50) NULL, [jenis_meter] [varchar](50) NULL, [l2t2] [varchar](20) NULL, [no_meter] [varchar](50) NULL, [tanggal_pasang] [datetime] NULL, [stand_pasang] [bigint] NULL, [tanggal_angkat] [datetime] NULL, [stand_angkat] [bigint] NULL, [keterangan_stand_angkat] [text] NULL, [ukuran_meter] [varchar](50) NULL, [stand_terakhir] [bigint] NULL, [stand_bulan_terakhir] [varchar](2) NULL, [stand_tahun_terakhir] [varchar](4) NULL, [stand_terakhir_kc] [bigint] NULL, [stand_bulan_terakhir_kc] [varchar](2) NULL, [stand_tahun_terakhir_kc] [varchar](4) NULL, [keterangan_no_rumah] [text] NULL, [keterangan_lokasi_meter] [text] NULL, [revisi_npa] [int] NULL, [no_hp] [varchar](50) NULL, [email] [varchar](255) NULL, [useridinc] [bigint] NULL, [riwayat_npa] [text] NULL, CONSTRAINT [PK_custom] PRIMARY KEY CLUSTERED ( [kd_wly] ASC, [kd_jln] ASC, [kd_ctm] ASC, [kocab] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [tirtanadi_ism_2_custom]([kocab]) ) ON [tirtanadi_ism_2_custom]([kocab]) GO ALTER TABLE [dbo].[custom] SET (LOCK_ESCALATION = DISABLE) GO /****** Object: Table [dbo].[custom_mem] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[custom_mem] ( [customidinc] [bigint] IDENTITY(1,1) NOT NULL, [kd_wly] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [kd_jln] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [kd_ctm] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [kocab] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [npal] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [noreg] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [no_buku] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [hal_buku] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [na_ctm] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [no_rmh] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [status] [int] NULL, [tarif] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ketstatus] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [type_mtr] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [kd_byr] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [kd_tagih] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [trblth] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [trf_al] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [luas] [float] NULL, [no_telp] [varchar](14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [kd_klastarif] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [psb] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [kabu] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [keca] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [kelu] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [jenis_meter] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [l2t2] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [no_meter] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [tanggal_pasang] [datetime] NULL, [stand_pasang] [bigint] NULL, [tanggal_angkat] [datetime] NULL, [stand_angkat] [bigint] NULL, [keterangan_stand_angkat] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ukuran_meter] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [stand_terakhir] [bigint] NULL, [stand_bulan_terakhir] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [stand_tahun_terakhir] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [stand_terakhir_kc] [bigint] NULL, [stand_bulan_terakhir_kc] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [stand_tahun_terakhir_kc] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [keterangan_no_rumah] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [keterangan_lokasi_meter] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [revisi_npa] [int] NULL, [no_hp] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [email] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [useridinc] [bigint] NULL, [riwayat_npa] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [custom_id] UNIQUE NONCLUSTERED ( [customidinc] ASC ), CONSTRAINT [custom_primary] UNIQUE NONCLUSTERED ( [kocab] ASC, [kd_wly] ASC, [kd_jln] ASC, [kd_ctm] ASC ), CONSTRAINT [PK_custom_2] PRIMARY KEY NONCLUSTERED ( [kd_wly] ASC, [kd_jln] ASC, [kd_ctm] ASC, [kocab] ASC ) )WITH ( MEMORY_OPTIMIZED = ON , DURABILITY = SCHEMA_AND_DATA ) GO /****** Object: Table [dbo].[dapel] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[dapel]( [dapelidinc] [bigint] IDENTITY(1,1) NOT NULL, [kocab] [varchar](2) NULL, [kd_wly] [varchar](2) NULL, [kd_jln] [varchar](2) NULL, [kd_ctm] [varchar](4) NULL, [no_meter] [varchar](10) NULL, [jenis_mtr] [varchar](11) NULL, [ukuran] [varchar](7) NULL, CONSTRAINT [PK_dapel] PRIMARY KEY CLUSTERED ( [dapelidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[fitur] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[fitur]( [fituridinc] [int] IDENTITY(1,1) NOT NULL, [nama] [nvarchar](255) NOT NULL, [link] [nvarchar](255) NULL, CONSTRAINT [PK_fitur] PRIMARY KEY CLUSTERED ( [fituridinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[history_meter] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[history_meter]( [historymeteridinc] [bigint] IDENTITY(1,1) NOT NULL, [npa] [varchar](50) NULL, [nama] [varchar](50) NULL, [jenis_mtr] [varchar](50) NULL, [no_meter] [varchar](50) NULL, [tgl_psg] [datetime] NULL, [s_psg] [int] NULL, [t_angkat] [datetime] NULL, [s_angkat] [int] NULL, [ket] [varchar](50) NULL, [ukuran] [varchar](50) NULL, [kocab] [varchar](50) NULL, [tarif] [varchar](50) NULL, [no_buku] [varchar](50) NULL, CONSTRAINT [PK__history___3214EC2715502E78] PRIMARY KEY CLUSTERED ( [historymeteridinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[jadwal] Script Date: 3/23/2019 5:34:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[jadwal]( [jadwalidinc] [bigint] IDENTITY(1,1) NOT NULL, [tgl] [date] NULL, [sampai_tgl] [date] NULL, [bulan_catat] [varchar](2) NULL, [tahun_catat] [varchar](4) NULL, [kocab] [varchar](2) NULL, [kd_wly] [varchar](2) NULL, [kd_jln] [varchar](2) NULL, [no_buku] [varchar](10) NULL, [useridinc] [int] NULL, [jlh_hari_catat_bulan_ini] [int] NULL, [jlh_hari_catat_bulan_lalu] [int] NULL, [tgl_catat_bulan_sebelumnya] [date] NULL, [boleh_catat_lewat_tgl] [int] NULL, [boleh_upload_lewat_tgl] [int] NULL, [boleh_upload_sampai_tgl] [varchar](20) NULL, [boleh_catat_sampai_tgl] [varchar](20) NULL, [tglawal] [varchar](50) NULL, [tglakhir] [varchar](50) NULL, [tekanan] [varchar](50) NULL, [validasi_buku] [varchar](50) NULL, [kirim_ke_pusat] [varchar](50) NULL, CONSTRAINT [PK_jadwal] PRIMARY KEY CLUSTERED ( [jadwalidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[jadwal] SET (LOCK_ESCALATION = DISABLE) GO /****** Object: Table [dbo].[jalan] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[jalan]( [jalanidinc] [int] IDENTITY(1,1) NOT NULL, [kocab] [varchar](2) NULL, [kd_jln] [varchar](2) NOT NULL, [kd_wly] [varchar](2) NULL, [nama_jalan] [text] NULL, [jenis_jalan] [int] NULL, [nama_jalan_2] [text] NULL, CONSTRAINT [PK_jalan] PRIMARY KEY CLUSTERED ( [jalanidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[klstrf] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[klstrf]( [klstrfidinc] [bigint] IDENTITY(1,1) NOT NULL, [tarif] [varchar](1) NULL, [kd_klastarif] [varchar](3) NULL, [ket_klastarif] [varchar](35) NULL, CONSTRAINT [PK_klstrf] PRIMARY KEY CLUSTERED ( [klstrfidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[kwit] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[kwit]( [kwitidinc] [bigint] IDENTITY(1,1) NOT NULL, [kd_wly] [varchar](2) NOT NULL, [kd_jln] [varchar](2) NOT NULL, [kocab] [varchar](2) NOT NULL, [npa] [varchar](10) NOT NULL, [noreg] [varchar](50) NULL, [npal] [varchar](50) NULL, [no_buku] [varchar](6) NULL, [hal_buku] [varchar](6) NULL, [na_ctm] [varchar](255) NULL, [alamat] [text] NULL, [no_rmh] [varchar](255) NULL, [bulan] [varchar](2) NOT NULL, [tahun] [varchar](2) NOT NULL, [angspsb] [bigint] NULL, [jangspsb] [bigint] NULL, [angsal] [bigint] NULL, [jangsal] [bigint] NULL, [retrial] [money] NULL, [m3sblm] [bigint] NULL, [m3sblm_kc] [bigint] NULL, [staw] [bigint] NULL, [staw_kc] [bigint] NULL, [stakh] [bigint] NULL, [stakh_kc] [bigint] NULL, [sttsr] [bigint] NULL, [sttsr_kc] [bigint] NULL, [jlhrpair] [money] NULL, [nm_tarif] [varchar](255) NULL, [materai] [money] NULL, [angspdl] [int] NULL, [jangspdl] [money] NULL, [j_adm] [money] NULL, [type_mtr] [varchar](50) NULL, [kndmtr] [nvarchar](1) NULL, [r_meter] [money] NULL, [b_cetak] [money] NULL, [level_1] [money] NULL, [level_2] [money] NULL, [level_3] [money] NULL, [level_4] [money] NULL, [tglctk] [datetime] NULL, [mtr_gnt] [bigint] NULL, [tglbyr] [datetime] NULL, [kdjual] [varchar](1) NULL, [kode] [varchar](8) NULL, [ket_klastarif] [varchar](35) NULL, [luas] [float] NULL, [kd_alasannol] [varchar](2) NULL, [alasannol] [varchar](100) NULL, [kd_alasannol_kc] [varchar](2) NULL, [alasannol_kc] [text] NULL, [kd_alasan_taksir] [varchar](2) NULL, [alasantaksir] [varchar](100) NULL, [kd_alasantaksir_kc] [varchar](2) NULL, [alasantaksir_kc] [text] NULL, [kd_alasankecil] [varchar](2) NULL, [alasankecil] [text] NULL, [kd_alasankecil_kc] [varchar](2) NULL, [alasankecil_kc] [text] NULL, [stakhold] [bigint] NULL, [kdformula] [nvarchar](2) NULL, [sttsrold] [bigint] NULL, [mtr_gntold] [bigint] NULL, [tekanan] [nvarchar](4) NULL, [tglawal] [varchar](50) NULL, [tglakhir] [varchar](50) NULL, [ket] [nvarchar](3) NULL, [angmtr] [int] NULL, [jangmtr] [money] NULL, [ujl] [nvarchar](50) NULL, [foto_meteran] [text] NULL, [foto_rumah] [text] NULL, [foto_meteran_kc] [text] NULL, [jenis_meteran] [varchar](50) NULL, [verifikasi] [varchar](50) NULL, [keterangan_verifikasi] [text] NULL, [penggunaan] [bigint] NULL, [history_meter_id] [bigint] NULL, [tgl_jam_catat] [datetime] NULL, [sumber_catat] [varchar](255) NULL, [useridinc_pencatat] [bigint] NULL, [tgl_jam_update] [datetime] NULL, [useridinc_update] [bigint] NULL, [tgl_verifikasi] [datetime] NULL, [useridinc_verifikasi] [bigint] NULL, [keterangan_input] [text] NULL, [latitude] [float] NULL, [longitude] [float] NULL, [lokasi_catat] [text] NULL, [mtr_gnt_kc] [bigint] NULL, [tgl_jam_upload] [varchar](20) NULL, [riwayat_npa] [text] NULL, [stand_rev] [bigint] NULL, [stand_kc_rev] [bigint] NULL, [stand_rev_tgltime] [datetime] NULL, [stand_kc_rev_tgltime] [datetime] NULL, [stand_rev_useridinc] [bigint] NULL, [stand_kc_rev_useridinc] [bigint] NULL, [stand_rev_alasan] [text] NULL, [stand_kc_rev_alasan] [bigint] NULL, CONSTRAINT [PK_Kwit_2] PRIMARY KEY CLUSTERED ( [kd_wly] ASC, [kd_jln] ASC, [kocab] ASC, [npa] ASC, [bulan] ASC, [tahun] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [kwit_kocab]([kocab]) ) ON [kwit_kocab]([kocab]) GO ALTER TABLE [dbo].[kwit] SET (LOCK_ESCALATION = DISABLE) GO /****** Object: Table [dbo].[kwit_mem] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[kwit_mem] ( [kwitidinc] [bigint] IDENTITY(1,1) NOT NULL, [kd_wly] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [kd_jln] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [kocab] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [npa] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [noreg] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [npal] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [no_buku] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [hal_buku] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [na_ctm] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [alamat] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [no_rmh] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [bulan] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [tahun] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [angspsb] [bigint] NULL, [jangspsb] [bigint] NULL, [angsal] [bigint] NULL, [jangsal] [bigint] NULL, [retrial] [money] NULL, [m3sblm] [bigint] NULL, [m3sblm_kc] [bigint] NULL, [staw] [bigint] NULL, [staw_kc] [bigint] NULL, [stakh] [bigint] NULL, [stakh_kc] [bigint] NULL, [sttsr] [bigint] NULL, [sttsr_kc] [bigint] NULL, [jlhrpair] [money] NULL, [nm_tarif] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [materai] [money] NULL, [angspdl] [int] NULL, [jangspdl] [money] NULL, [j_adm] [money] NULL, [type_mtr] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [kndmtr] [nvarchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [r_meter] [money] NULL, [b_cetak] [money] NULL, [level_1] [money] NULL, [level_2] [money] NULL, [level_3] [money] NULL, [level_4] [money] NULL, [tglctk] [datetime] NULL, [mtr_gnt] [bigint] NULL, [tglbyr] [datetime] NULL, [kdjual] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [kode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ket_klastarif] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [luas] [float] NULL, [kd_alasannol] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [alasannol] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [kd_alasannol_kc] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [alasannol_kc] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [kd_alasan_taksir] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [alasantaksir] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [kd_alasantaksir_kc] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [alasantaksir_kc] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [kd_alasankecil] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [alasankecil] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [kd_alasankecil_kc] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [alasankecil_kc] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [stakhold] [bigint] NULL, [kdformula] [nvarchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [sttsrold] [bigint] NULL, [mtr_gntold] [bigint] NULL, [tekanan] [nvarchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [tglawal] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [tglakhir] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ket] [nvarchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [angmtr] [int] NULL, [jangmtr] [money] NULL, [ujl] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [foto_meteran] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [foto_rumah] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [foto_meteran_kc] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [jenis_meteran] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [verifikasi] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [keterangan_verifikasi] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [penggunaan] [bigint] NULL, [history_meter_id] [bigint] NULL, [tgl_jam_catat] [datetime] NULL, [sumber_catat] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [useridinc_pencatat] [bigint] NULL, [tgl_jam_update] [datetime] NULL, [useridinc_update] [bigint] NULL, [tgl_verifikasi] [datetime] NULL, [useridinc_verifikasi] [bigint] NULL, [keterangan_input] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [latitude] [float] NULL, [longitude] [float] NULL, [lokasi_catat] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [mtr_gnt_kc] [bigint] NULL, [tgl_jam_upload] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [riwayat_npa] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [stand_rev] [bigint] NULL, [stand_kc_rev] [bigint] NULL, [stand_rev_tgltime] [datetime] NULL, [stand_kc_rev_tgltime] [datetime] NULL, [stand_rev_useridinc] [bigint] NULL, [stand_kc_rev_useridinc] [bigint] NULL, [stand_rev_alasan] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [stand_kc_rev_alasan] [bigint] NULL, CONSTRAINT [kwit_kwitidinc] UNIQUE NONCLUSTERED ( [kwitidinc] ASC ), CONSTRAINT [PK_Kwit_3] PRIMARY KEY NONCLUSTERED ( [kd_wly] ASC, [kd_jln] ASC, [kocab] ASC, [npa] ASC, [bulan] ASC, [tahun] ASC ), CONSTRAINT [pri_key_kwit] UNIQUE NONCLUSTERED ( [kocab] ASC, [kd_wly] ASC, [kd_jln] ASC, [npa] ASC, [bulan] ASC, [tahun] ASC ) )WITH ( MEMORY_OPTIMIZED = ON , DURABILITY = SCHEMA_AND_DATA ) GO /****** Object: Table [dbo].[kwit_old] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[kwit_old]( [kwitidinc] [bigint] IDENTITY(1,1) NOT NULL, [kd_wly] [varchar](2) NOT NULL, [kd_jln] [varchar](2) NOT NULL, [kocab] [varchar](2) NOT NULL, [npa] [varchar](10) NOT NULL, [noreg] [varchar](50) NULL, [npal] [varchar](50) NULL, [no_buku] [varchar](6) NULL, [hal_buku] [varchar](6) NULL, [na_ctm] [varchar](255) NULL, [alamat] [text] NULL, [no_rmh] [varchar](255) NULL, [bulan] [varchar](2) NOT NULL, [tahun] [varchar](2) NOT NULL, [angspsb] [bigint] NULL, [jangspsb] [bigint] NULL, [angsal] [bigint] NULL, [jangsal] [bigint] NULL, [retrial] [money] NULL, [m3sblm] [bigint] NULL, [m3sblm_kc] [bigint] NULL, [staw] [bigint] NULL, [staw_kc] [bigint] NULL, [stakh] [bigint] NULL, [stakh_kc] [bigint] NULL, [sttsr] [bigint] NULL, [sttsr_kc] [bigint] NULL, [jlhrpair] [money] NULL, [nm_tarif] [varchar](255) NULL, [materai] [money] NULL, [angspdl] [int] NULL, [jangspdl] [money] NULL, [j_adm] [money] NULL, [type_mtr] [varchar](50) NULL, [kndmtr] [nvarchar](1) NULL, [r_meter] [money] NULL, [b_cetak] [money] NULL, [level_1] [money] NULL, [level_2] [money] NULL, [level_3] [money] NULL, [level_4] [money] NULL, [tglctk] [datetime] NULL, [mtr_gnt] [bigint] NULL, [tglbyr] [datetime] NULL, [kdjual] [varchar](1) NULL, [kode] [varchar](8) NULL, [ket_klastarif] [varchar](35) NULL, [luas] [float] NULL, [kd_alasannol] [varchar](2) NULL, [alasannol] [varchar](100) NULL, [kd_alasannol_kc] [varchar](2) NULL, [alasannol_kc] [text] NULL, [kd_alasan_taksir] [varchar](2) NULL, [alasantaksir] [varchar](100) NULL, [kd_alasantaksir_kc] [varchar](2) NULL, [alasantaksir_kc] [text] NULL, [kd_alasankecil] [varchar](2) NULL, [alasankecil] [text] NULL, [kd_alasankecil_kc] [varchar](2) NULL, [alasankecil_kc] [text] NULL, [stakhold] [bigint] NULL, [kdformula] [nvarchar](2) NULL, [sttsrold] [bigint] NULL, [mtr_gntold] [bigint] NULL, [tekanan] [nvarchar](4) NULL, [tglawal] [varchar](50) NULL, [tglakhir] [varchar](50) NULL, [ket] [nvarchar](3) NULL, [angmtr] [int] NULL, [jangmtr] [money] NULL, [ujl] [nvarchar](50) NULL, [foto_meteran] [text] NULL, [foto_rumah] [text] NULL, [foto_meteran_kc] [text] NULL, [jenis_meteran] [varchar](50) NULL, [verifikasi] [varchar](50) NULL, [keterangan_verifikasi] [text] NULL, [penggunaan] [bigint] NULL, [history_meter_id] [bigint] NULL, [tgl_jam_catat] [datetime] NULL, [sumber_catat] [varchar](255) NULL, [useridinc_pencatat] [bigint] NULL, [tgl_jam_update] [datetime] NULL, [useridinc_update] [bigint] NULL, [tgl_verifikasi] [datetime] NULL, [useridinc_verifikasi] [bigint] NULL, [keterangan_input] [text] NULL, [latitude] [float] NULL, [longitude] [float] NULL, [lokasi_catat] [text] NULL, [mtr_gnt_kc] [bigint] NULL, [tgl_jam_upload] [varchar](20) NULL, [riwayat_npa] [text] NULL, [stand_rev] [bigint] NULL, [stand_kc_rev] [bigint] NULL, [stand_rev_tgltime] [datetime] NULL, [stand_kc_rev_tgltime] [datetime] NULL, [stand_rev_useridinc] [bigint] NULL, [stand_kc_rev_useridinc] [bigint] NULL, [stand_rev_alasan] [text] NULL, [stand_kc_rev_alasan] [bigint] NULL, CONSTRAINT [PK_Kwit] PRIMARY KEY CLUSTERED ( [kd_wly] ASC, [kd_jln] ASC, [kocab] ASC, [npa] ASC, [bulan] ASC, [tahun] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [tahun]([tahun]) ) ON [tahun]([tahun]) GO ALTER TABLE [dbo].[kwit_old] SET (LOCK_ESCALATION = DISABLE) GO /****** Object: Table [dbo].[level_user] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[level_user]( [leveluseridinc] [int] IDENTITY(1,1) NOT NULL, [level_user] [nvarchar](255) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[log] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[log]( [logidinc] [bigint] IDENTITY(1,1) NOT NULL, [tgl] [varchar](255) NULL, [jam] [varchar](255) NULL, [userid] [varchar](255) NULL, [kocab] [varchar](255) NULL, [kd_wly] [varchar](255) NULL, [kd_jln] [varchar](255) NULL, [kd_ctm] [varchar](255) NULL, [npal] [varchar](255) NULL, [stand_0] [varchar](255) NULL, [stand_1] [varchar](255) NULL, [tarif_0] [varchar](255) NULL, [tarif_1] [varchar](255) NULL, [nama_0] [varchar](255) NULL, [nama_1] [varchar](255) NULL, [ket] [varchar](255) NULL, [kode] [varchar](255) NULL, [npa_0] [varchar](50) NULL, [npa_1] [varchar](50) NULL, [status_0] [varchar](2) NULL, [status_1] [varchar](2) NULL, CONSTRAINT [PK_log] PRIMARY KEY CLUSTERED ( [logidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[mdmsl] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mdmsl]( [KD_CABANG] [nvarchar](255) NULL, [KD_WILAYAH] [nvarchar](255) NULL, [KD_JALAN] [nvarchar](255) NULL, [KD_KELASJALAN] [float] NULL, [NM_JALAN] [nvarchar](255) NULL, [KD_KEL] [nvarchar](255) NULL, [KD_KEC] [nvarchar](255) NULL, [KD_KAB] [nvarchar](255) NULL, [KD_PROP] [nvarchar](255) NULL, [CRT_USERID] [nvarchar](255) NULL, [CRT_TGL] [nvarchar](255) NULL, [APV_USERID] [nvarchar](255) NULL, [APV_TGL] [nvarchar](255) NULL, [UPD_USERID] [nvarchar](255) NULL, [UPD_TGL] [nvarchar](255) NULL, [PARENT_JALAN] [nvarchar](255) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[meter] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[meter]( [meteridinc] [bigint] IDENTITY(1,1) NOT NULL, [type_mtr] [varchar](1) NULL, [nm_meter] [varchar](15) NULL, [kode_mtr] [varchar](1) NULL, [r_meter] [float] NULL, CONSTRAINT [PK_meter] PRIMARY KEY CLUSTERED ( [meteridinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[produksi_air] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[produksi_air]( [produksiairinc] [bigint] IDENTITY(1,1) NOT NULL, [penggunaan_air] [bigint] NOT NULL, [bulan] [varchar](2) NOT NULL, [tahun] [int] NOT NULL, [kocab] [varchar](2) NOT NULL, [kd_wly] [varchar](2) NOT NULL, CONSTRAINT [PK_produksi_air] PRIMARY KEY CLUSTERED ( [produksiairinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[rkabupaten] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[rkabupaten]( [rkabupatenidinc] [bigint] IDENTITY(1,1) NOT NULL, [kd_prop] [varchar](2) NULL, [kd_kab] [varchar](2) NULL, [kabupaten] [varchar](255) NULL, CONSTRAINT [PK_rkabupaten] PRIMARY KEY CLUSTERED ( [rkabupatenidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[rkecamatan] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[rkecamatan]( [rkecamatanidinc] [bigint] IDENTITY(1,1) NOT NULL, [kd_prop] [varchar](2) NULL, [kd_kab] [varchar](2) NULL, [kd_kec] [varchar](4) NULL, [kecamatan] [varchar](255) NULL, CONSTRAINT [PK_rkecamatan] PRIMARY KEY CLUSTERED ( [rkecamatanidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[rkelurahan] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[rkelurahan]( [rkelurahanidinc] [bigint] IDENTITY(1,1) NOT NULL, [kd_prop] [varchar](2) NULL, [kd_kab] [varchar](2) NULL, [kd_kec] [varchar](4) NULL, [kd_kel] [varchar](4) NULL, [kelurahan] [varchar](255) NULL, [kd_wly] [varchar](2) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[rprovinsi] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[rprovinsi]( [rprovinsiidinc] [bigint] IDENTITY(1,1) NOT NULL, [kd_prop] [varchar](2) NULL, [nm_prop] [varchar](255) NULL, CONSTRAINT [PK_rprovinsi] PRIMARY KEY CLUSTERED ( [rprovinsiidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[setting] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[setting]( [settingincid] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](255) NOT NULL, [value] [text] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[sinkronisasi_ppob] Script Date: 3/23/2019 5:34:57 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[sinkronisasi_ppob]( [sinkronisasi_ppob_idinc] [int] IDENTITY(1,1) NOT NULL, [tgl_jam] [datetime] NULL, [jumlah_data] [int] NULL, [status] [varchar](50) NULL, [kocab] [varchar](2) NULL, [no_buku] [varchar](6) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[status_kirim_data] Script Date: 3/23/2019 5:34:58 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[status_kirim_data]( [statuskirimdatainc] [bigint] IDENTITY(1,1) NOT NULL, [kocab] [varchar](2) NOT NULL, [no_buku] [varchar](5) NOT NULL, [bulan] [varchar](2) NOT NULL, [tahun] [varchar](4) NOT NULL, [kd_wly] [varchar](2) NOT NULL, [dikirim_pada] [datetime] NULL, [tgl_baca_awal] [date] NULL, [tgl_baca_akhir] [date] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[sub_fitur] Script Date: 3/23/2019 5:34:58 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[sub_fitur]( [subfituridinc] [int] IDENTITY(1,1) NOT NULL, [nama] [varchar](255) NULL, [fituridinc] [int] NULL, [link] [text] NULL, CONSTRAINT [PK_sub_fitur] PRIMARY KEY CLUSTERED ( [subfituridinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[surat] Script Date: 3/23/2019 5:34:58 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[surat]( [suratidinc] [bigint] IDENTITY(1,1) NOT NULL, [kocab] [varchar](2) NULL, [kd_wly] [varchar](2) NULL, [kd_jln] [varchar](2) NULL, [kd_ctm] [varchar](4) NULL, [nomor] [text] NULL, [tglsuratcab] [varchar](50) NULL, [tglsuratplg] [varchar](50) NULL, [prihalplg] [text] NULL, [kdprihal] [text] NULL, [isisurat1] [text] NULL, [isisurat2] [text] NULL, [isisurat3] [text] NULL, [biaya1] [money] NULL, [biaya2] [money] NULL, [biaya3] [money] NULL, [biaya4] [money] NULL, [biaya5] [money] NULL, [biaya6] [money] NULL, [biaya7] [money] NULL, [biaya8] [money] NULL, CONSTRAINT [PK_surat] PRIMARY KEY CLUSTERED ( [suratidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[tarif] Script Date: 3/23/2019 5:34:58 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tarif]( [tarifidinc] [bigint] IDENTITY(1,1) NOT NULL, [kocab] [varchar](2) NULL, [tarif] [varchar](1) NOT NULL, [nm_tarif] [varchar](4) NOT NULL, [ket_tarif] [text] NULL, [kode_mtr] [varchar](1) NULL, [prog1] [float] NULL, [prog2] [float] NULL, [prog3] [float] NULL, [prog4] [float] NULL, [retrial1] [float] NULL, [retrial2] [float] NULL, [ket1] [smallint] NULL, [ket2] [smallint] NULL, [ket3] [smallint] NULL, [ket4] [smallint] NULL, [j_adm] [float] NULL, [r_meter] [float] NULL, [b_cetak] [float] NULL, [warna] [nvarchar](25) NULL, [warna1] [nvarchar](25) NULL, [l2t2] [money] NULL, CONSTRAINT [PK_tarif] PRIMARY KEY CLUSTERED ( [tarifidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[template_fitur] Script Date: 3/23/2019 5:34:58 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[template_fitur]( [tempfituridinc] [bigint] IDENTITY(1,1) NOT NULL, [fituridinc] [int] NULL, [leveluseridinc] [int] NULL, CONSTRAINT [PK_template_fitur] PRIMARY KEY CLUSTERED ( [tempfituridinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[template_subfitur] Script Date: 3/23/2019 5:34:58 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[template_subfitur]( [tempsubfitur] [bigint] IDENTITY(1,1) NOT NULL, [subfituridinc] [int] NULL, [leveluseridinc] [int] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tempsubfitur] Script Date: 3/23/2019 5:34:58 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tempsubfitur]( [tempsubfitur] [bigint] IDENTITY(1,1) NOT NULL, [subfituridinc] [int] NULL, [leveluseridinc] [int] NULL, CONSTRAINT [PK_tempsubfitur] PRIMARY KEY CLUSTERED ( [tempsubfitur] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[trans] Script Date: 3/23/2019 5:34:58 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[trans]( [transidinc] [bigint] IDENTITY(1,1) NOT NULL, [kocab] [varchar](2) NULL, [kd_wly] [varchar](2) NULL, [kd_jln] [varchar](2) NULL, [kd_ctm] [varchar](4) NULL, [npal] [varchar](10) NULL, [bulan] [varchar](2) NULL, [tahun] [text] NULL, [m_thyl] [float] NULL, [m_bl1] [float] NULL, [m_bl2] [float] NULL, [m_bl3] [float] NULL, [m_bl4] [float] NULL, [m_bl5] [float] NULL, [m_bl6] [float] NULL, [m_bl7] [float] NULL, [m_bl8] [float] NULL, [m_bl9] [float] NULL, [m_bl10] [float] NULL, [m_bl11] [float] NULL, [m_bl12] [float] NULL, [mg_bl1] [float] NULL, [mg_bl2] [float] NULL, [mg_bl3] [float] NULL, [mg_bl4] [float] NULL, [mg_bl5] [float] NULL, [mg_bl6] [float] NULL, [mg_bl7] [float] NULL, [mg_bl8] [float] NULL, [mg_bl9] [float] NULL, [mg_bl10] [float] NULL, [mg_bl11] [float] NULL, [mg_bl12] [float] NULL, [nama_op] [varchar](50) NULL, CONSTRAINT [PK_trans] PRIMARY KEY CLUSTERED ( [transidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[user] Script Date: 3/23/2019 5:34:58 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[user]( [useridinc] [bigint] IDENTITY(1,1) NOT NULL, [nama] [varchar](255) NULL, [jabatan] [varchar](255) NULL, [hakakses] [int] NULL, [userid] [varchar](50) NOT NULL, [password] [varchar](255) NULL, [token] [varchar](255) NULL, [kocab] [varchar](2) NULL, CONSTRAINT [PK_user] PRIMARY KEY CLUSTERED ( [useridinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[wilayah] Script Date: 3/23/2019 5:34:58 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[wilayah]( [wilayahidinc] [int] IDENTITY(1,1) NOT NULL, [kocab] [varchar](2) NOT NULL, [kd_wly] [varchar](2) NOT NULL, [nama_wilayah] [text] NOT NULL, [ket_wilayah] [text] NULL, CONSTRAINT [PK_wilayah] PRIMARY KEY CLUSTERED ( [wilayahidinc] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[_rekap_kwit] ADD CONSTRAINT [DF__rekap_kwit_jumlah_input] DEFAULT ((0)) FOR [jumlah_input] GO ALTER TABLE [dbo].[_rekap_kwit] ADD CONSTRAINT [DF__rekap_kwit_jumlah_verifikasi] DEFAULT ((0)) FOR [jumlah_verifikasi] GO ALTER TABLE [dbo].[_rekap_kwit] ADD CONSTRAINT [DF__rekap_kwit_jumlah_diterima] DEFAULT ((0)) FOR [jumlah_diterima] GO ALTER TABLE [dbo].[_rekap_kwit] ADD CONSTRAINT [DF__rekap_kwit_jumlah_ditolak] DEFAULT ((0)) FOR [jumlah_ditolak] GO ALTER TABLE [dbo].[_rekap_kwit_tarif] ADD CONSTRAINT [DF__rekap_kwit_tarif_kubikasi] DEFAULT ((0)) FOR [kubikasi] GO ALTER TABLE [dbo].[_rekap_kwit_tarif] ADD CONSTRAINT [DF__rekap_kwit_tarif_jlh_rek] DEFAULT ((0)) FOR [jlh_rek] GO ALTER TABLE [dbo].[_rekap_kwit_tarif] ADD CONSTRAINT [DF__rekap_kwit_tarif_harga] DEFAULT ((0)) FOR [harga] GO ALTER TABLE [dbo].[_rekap_kwit_tarif] ADD CONSTRAINT [DF__rekap_kwit_tarif_ret_limbah] DEFAULT ((0)) FOR [ret_limbah] GO ALTER TABLE [dbo].[_rekap_kwit_tarif] ADD CONSTRAINT [DF__rekap_kwit_tarif_angsbersih] DEFAULT ((0)) FOR [angsbersih] GO ALTER TABLE [dbo].[_rekap_kwit_tarif] ADD CONSTRAINT [DF__rekap_kwit_tarif_angsmeter] DEFAULT ((0)) FOR [angsmeter] GO ALTER TABLE [dbo].[_rekap_kwit_tarif] ADD CONSTRAINT [DF__rekap_kwit_tarif_materai] DEFAULT ((0)) FOR [materai] GO ALTER TABLE [dbo].[_rekap_kwit_tarif] ADD CONSTRAINT [DF__rekap_kwit_tarif_biaya_adm] DEFAULT ((0)) FOR [biaya_adm] GO ALTER TABLE [dbo].[_rekap_kwit_tarif] ADD CONSTRAINT [DF__rekap_kwit_tarif_biaya_tetap] DEFAULT ((0)) FOR [biaya_tetap] GO ALTER TABLE [dbo].[_rekap_kwit_tarif] ADD CONSTRAINT [DF__rekap_kwit_tarif_tagihan] DEFAULT ((0)) FOR [tagihan] GO ALTER TABLE [dbo].[_rekap_kwit_tarif] ADD CONSTRAINT [DF__rekap_kwit_tarif_bulan] DEFAULT ((0)) FOR [bulan] GO ALTER TABLE [dbo].[_rekap_kwit_tarif] ADD CONSTRAINT [DF__rekap_kwit_tarif_tahun] DEFAULT ((0)) FOR [tahun] GO ALTER TABLE [dbo].[_rekap_kwit_tarif_wilayah] ADD CONSTRAINT [DF__rekap_kwit_tarif_wilayah_kubikasi] DEFAULT ((0)) FOR [kubikasi] GO ALTER TABLE [dbo].[_rekap_kwit_tarif_wilayah] ADD CONSTRAINT [DF__rekap_kwit_tarif_wilayah_jlh_rek] DEFAULT ((0)) FOR [jlh_rek] GO ALTER TABLE [dbo].[_rekap_kwit_tarif_wilayah] ADD CONSTRAINT [DF__rekap_kwit_tarif_wilayah_harga] DEFAULT ((0.0)) FOR [harga] GO ALTER TABLE [dbo].[_rekap_kwit_tarif_wilayah] ADD CONSTRAINT [DF__rekap_kwit_tarif_wilayah_ret_limbah] DEFAULT ((0.0)) FOR [ret_limbah] GO ALTER TABLE [dbo].[_rekap_kwit_tarif_wilayah] ADD CONSTRAINT [DF__rekap_kwit_tarif_wilayah_angsbersih] DEFAULT ((0.0)) FOR [angsbersih] GO ALTER TABLE [dbo].[_rekap_kwit_tarif_wilayah] ADD CONSTRAINT [DF__rekap_kwit_tarif_wilayah_angsmeter] DEFAULT ((0.0)) FOR [angsmeter] GO ALTER TABLE [dbo].[_rekap_kwit_tarif_wilayah] ADD CONSTRAINT [DF__rekap_kwit_tarif_wilayah_materai] DEFAULT ((0.0)) FOR [materai] GO ALTER TABLE [dbo].[_rekap_kwit_tarif_wilayah] ADD CONSTRAINT [DF__rekap_kwit_tarif_wilayah_biaya_adm] DEFAULT ((0.0)) FOR [biaya_adm] GO ALTER TABLE [dbo].[_rekap_kwit_tarif_wilayah] ADD CONSTRAINT [DF__rekap_kwit_tarif_wilayah_biaya_tetap] DEFAULT ((0.0)) FOR [biaya_tetap] GO ALTER TABLE [dbo].[_rekap_kwit_tarif_wilayah] ADD CONSTRAINT [DF__rekap_kwit_tarif_wilayah_tagihan] DEFAULT ((0.0)) FOR [tagihan] GO ALTER TABLE [dbo].[akses_fitur] ADD CONSTRAINT [DF_akses_fitur_useridinc] DEFAULT ((0)) FOR [useridinc] GO ALTER TABLE [dbo].[akses_fitur] ADD CONSTRAINT [DF_akses_fitur_fituridinc] DEFAULT ((0)) FOR [fituridinc] GO ALTER TABLE [dbo].[akses_sub_fitur] ADD CONSTRAINT [DF_akses_sub_fitur_useridinc] DEFAULT ((0)) FOR [useridinc] GO ALTER TABLE [dbo].[akses_sub_fitur] ADD CONSTRAINT [DF_akses_sub_fitur_subfituridinc] DEFAULT ((0)) FOR [subfituridinc] GO ALTER TABLE [dbo].[angsab] ADD CONSTRAINT [DF__angsab__biaya__14270015] DEFAULT ((0)) FOR [biaya] GO ALTER TABLE [dbo].[angsab] ADD CONSTRAINT [DF__angsab__dp__151B244E] DEFAULT ((0)) FOR [dp] GO ALTER TABLE [dbo].[angsab] ADD CONSTRAINT [DF__angsab__cicilan__160F4887] DEFAULT ((0)) FOR [cicilan] GO ALTER TABLE [dbo].[angsab] ADD CONSTRAINT [DF__angsab__angsuran__17036CC0] DEFAULT ((0)) FOR [angsuran] GO ALTER TABLE [dbo].[angsab] ADD CONSTRAINT [DF__angsab__hs__17F790F9] DEFAULT ('-') FOR [hs] GO ALTER TABLE [dbo].[angsal] ADD CONSTRAINT [DF__angsal__biaya__18EBB532] DEFAULT ((0)) FOR [biaya] GO ALTER TABLE [dbo].[angsal] ADD CONSTRAINT [DF__angsal__dp__19DFD96B] DEFAULT ((0)) FOR [dp] GO ALTER TABLE [dbo].[angsal] ADD CONSTRAINT [DF__angsal__cicilan__1AD3FDA4] DEFAULT ((0)) FOR [cicilan] GO ALTER TABLE [dbo].[angsal] ADD CONSTRAINT [DF__angsal__angsuran__1BC821DD] DEFAULT ((0)) FOR [angsuran] GO ALTER TABLE [dbo].[angsurmtr] ADD CONSTRAINT [DF__angsurmtr__biaya__2B3F6F97] DEFAULT ((0)) FOR [biaya] GO ALTER TABLE [dbo].[angsurmtr] ADD CONSTRAINT [DF__angsurmtr__dp__2C3393D0] DEFAULT ((0)) FOR [dp] GO ALTER TABLE [dbo].[angsurmtr] ADD CONSTRAINT [DF__angsurmtr__cicil__2D27B809] DEFAULT ((0)) FOR [cicilan] GO ALTER TABLE [dbo].[angsurmtr] ADD CONSTRAINT [DF_angsurmtr_angsuran] DEFAULT ((0)) FOR [angsuran] GO ALTER TABLE [dbo].[angsurmtr] ADD CONSTRAINT [DF_angsurmtr_mulairekbln] DEFAULT ((0)) FOR [mulairekbln] GO ALTER TABLE [dbo].[angsurmtr] ADD CONSTRAINT [DF_angsurmtr_mulairekthn] DEFAULT ((0)) FOR [mulairekthn] GO ALTER TABLE [dbo].[angsurmtr] ADD CONSTRAINT [DF_angsurmtr_ke] DEFAULT ((0)) FOR [ke] GO ALTER TABLE [dbo].[buku] ADD CONSTRAINT [DF_buku_total_pelanggan] DEFAULT ((0)) FOR [total_pelanggan] GO ALTER TABLE [dbo].[cabang] ADD CONSTRAINT [DF_cabang_rumus_catat_meter] DEFAULT ('01') FOR [rumus_catat_meter] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_status] DEFAULT ((0)) FOR [status] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_kd_byr] DEFAULT ((0)) FOR [kd_byr] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_kd_tagih] DEFAULT ((0)) FOR [kd_tagih] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF__custom__luas__2E1BDC42] DEFAULT ((0)) FOR [luas] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_jenis_meter] DEFAULT ('single') FOR [jenis_meter] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_l2t2] DEFAULT ('tidak') FOR [l2t2] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_stand_pasang] DEFAULT ((0)) FOR [stand_pasang] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_stand_angkat] DEFAULT ((0)) FOR [stand_angkat] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_stand_terakhir] DEFAULT ((0)) FOR [stand_terakhir] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_stand_bulan_terakhir] DEFAULT ((0)) FOR [stand_bulan_terakhir] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_stand_tahun_terakhir] DEFAULT ((0)) FOR [stand_tahun_terakhir] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_stand_terakhir_kc] DEFAULT ((0)) FOR [stand_terakhir_kc] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_stand_bulan_terakhir_kc] DEFAULT ((0)) FOR [stand_bulan_terakhir_kc] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_stand_tahun_terakhir_kc] DEFAULT ((0)) FOR [stand_tahun_terakhir_kc] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_revisi_npa] DEFAULT ((0)) FOR [revisi_npa] GO ALTER TABLE [dbo].[custom] ADD CONSTRAINT [DF_custom_useridinc] DEFAULT ((0)) FOR [useridinc] GO ALTER TABLE [dbo].[history_meter] ADD CONSTRAINT [DF_history_meter_s_psg] DEFAULT ((0)) FOR [s_psg] GO ALTER TABLE [dbo].[history_meter] ADD CONSTRAINT [DF_history_meter_s_angkat] DEFAULT ((0)) FOR [s_angkat] GO ALTER TABLE [dbo].[jadwal] ADD CONSTRAINT [DF_jadwal_useridinc] DEFAULT ((0)) FOR [useridinc] GO ALTER TABLE [dbo].[jadwal] ADD CONSTRAINT [DF_jadwal_jlh_hari_catat_bulan_ini] DEFAULT ((0)) FOR [jlh_hari_catat_bulan_ini] GO ALTER TABLE [dbo].[jadwal] ADD CONSTRAINT [DF_jadwal_jlh_hari_catat_bulan_lalu] DEFAULT ((0)) FOR [jlh_hari_catat_bulan_lalu] GO ALTER TABLE [dbo].[jadwal] ADD CONSTRAINT [DF_jadwal_boleh_catat_lewat_tgl] DEFAULT ((0)) FOR [boleh_catat_lewat_tgl] GO ALTER TABLE [dbo].[jadwal] ADD CONSTRAINT [DF_jadwal_boleh_upload_lewat_tgl] DEFAULT ((0)) FOR [boleh_upload_lewat_tgl] GO ALTER TABLE [dbo].[jadwal] ADD CONSTRAINT [DF_jadwal_boleh_upload_sampai_tgl] DEFAULT (((0)-(0))-(0)) FOR [boleh_upload_sampai_tgl] GO ALTER TABLE [dbo].[jadwal] ADD CONSTRAINT [DF_jadwal_boleh_catat_sampai_tgl] DEFAULT (((0)-(0))-(0)) FOR [boleh_catat_sampai_tgl] GO ALTER TABLE [dbo].[jalan] ADD CONSTRAINT [DF_jalan_jenis_jalan] DEFAULT ((1)) FOR [jenis_jalan] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_angspsb] DEFAULT ((0)) FOR [angspsb] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__Jangspsb__7A672E12] DEFAULT ((0)) FOR [jangspsb] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_angsal] DEFAULT ((0)) FOR [angsal] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__Jangsal__7B5B524B] DEFAULT ((0)) FOR [jangsal] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__Retrial__7C4F7684] DEFAULT ((0)) FOR [retrial] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__m3sblm__7D439ABD] DEFAULT ((0)) FOR [m3sblm] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_m3sblm_kc] DEFAULT ((0)) FOR [m3sblm_kc] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__Staw__7E37BEF6] DEFAULT ((0)) FOR [staw] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_staw_kc] DEFAULT ((0)) FOR [staw_kc] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__Stakh__7F2BE32F] DEFAULT ((0)) FOR [stakh] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_stakh_kc] DEFAULT ((0)) FOR [stakh_kc] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__Sttsr__00200768] DEFAULT ((0)) FOR [sttsr] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_sttsr_kc] DEFAULT ((0)) FOR [sttsr_kc] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__Jlhrpair__01142BA1] DEFAULT ((0)) FOR [jlhrpair] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_nm_tarif] DEFAULT ((0)) FOR [nm_tarif] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__Materai__02084FDA] DEFAULT ((0)) FOR [materai] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_angspdl] DEFAULT ((0)) FOR [angspdl] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__Jangspdl__02FC7413] DEFAULT ((0)) FOR [jangspdl] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__J_adm__03F0984C] DEFAULT ((0)) FOR [j_adm] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__R_meter__04E4BC85] DEFAULT ((0)) FOR [r_meter] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__b_cetak__05D8E0BE] DEFAULT ((0)) FOR [b_cetak] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__level_1__06CD04F7] DEFAULT ((0)) FOR [level_1] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__level_2__07C12930] DEFAULT ((0)) FOR [level_2] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__level_3__08B54D69] DEFAULT ((0)) FOR [level_3] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__level_4__09A971A2] DEFAULT ((0)) FOR [level_4] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_mtr_gnt] DEFAULT ((0)) FOR [mtr_gnt] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__luas__0B91BA14] DEFAULT ((0)) FOR [luas] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__stakhold__0C85DE4D] DEFAULT ((0)) FOR [stakhold] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__sttsrold__0D7A0286] DEFAULT ((0)) FOR [sttsrold] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__mtr_gntold__0E6E26BF] DEFAULT ((0)) FOR [mtr_gntold] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__jangmtr__0F624AF8] DEFAULT ((0)) FOR [jangmtr] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__ujl__10566F31] DEFAULT ((0)) FOR [ujl] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_penggunaan] DEFAULT ((0)) FOR [penggunaan] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__history_me__403A8C7D] DEFAULT ('0') FOR [history_meter_id] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_sumber_catat] DEFAULT ('web') FOR [sumber_catat] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_useridinc_pencatat] DEFAULT ((0)) FOR [useridinc_pencatat] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_useridinc_update] DEFAULT ((0)) FOR [useridinc_update] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_useridinc_verifikasi] DEFAULT ((0)) FOR [useridinc_verifikasi] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_latitude] DEFAULT ((0)) FOR [latitude] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF_kwit2_longitude] DEFAULT ((0)) FOR [longitude] GO ALTER TABLE [dbo].[kwit] ADD CONSTRAINT [DF__kwit2__mtr_gnt_kc__762C88DA] DEFAULT ((0)) FOR [mtr_gnt_kc] GO ALTER TABLE [dbo].[kwit] ADD DEFAULT ((0)) FOR [stand_rev] GO ALTER TABLE [dbo].[kwit] ADD DEFAULT ((0)) FOR [stand_kc_rev] GO ALTER TABLE [dbo].[kwit] ADD DEFAULT ((0)) FOR [stand_rev_useridinc] GO ALTER TABLE [dbo].[kwit] ADD DEFAULT ((0)) FOR [stand_kc_rev_useridinc] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_angspsb] DEFAULT ((0)) FOR [angspsb] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__Jangspsb__7A672E12] DEFAULT ((0)) FOR [jangspsb] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_angsal] DEFAULT ((0)) FOR [angsal] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__Jangsal__7B5B524B] DEFAULT ((0)) FOR [jangsal] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__Retrial__7C4F7684] DEFAULT ((0)) FOR [retrial] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__m3sblm__7D439ABD] DEFAULT ((0)) FOR [m3sblm] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_m3sblm_kc] DEFAULT ((0)) FOR [m3sblm_kc] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__Staw__7E37BEF6] DEFAULT ((0)) FOR [staw] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_staw_kc] DEFAULT ((0)) FOR [staw_kc] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__Stakh__7F2BE32F] DEFAULT ((0)) FOR [stakh] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_stakh_kc] DEFAULT ((0)) FOR [stakh_kc] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__Sttsr__00200768] DEFAULT ((0)) FOR [sttsr] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_sttsr_kc] DEFAULT ((0)) FOR [sttsr_kc] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__Jlhrpair__01142BA1] DEFAULT ((0)) FOR [jlhrpair] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_nm_tarif] DEFAULT ((0)) FOR [nm_tarif] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__Materai__02084FDA] DEFAULT ((0)) FOR [materai] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_angspdl] DEFAULT ((0)) FOR [angspdl] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__Jangspdl__02FC7413] DEFAULT ((0)) FOR [jangspdl] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__J_adm__03F0984C] DEFAULT ((0)) FOR [j_adm] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__R_meter__04E4BC85] DEFAULT ((0)) FOR [r_meter] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__b_cetak__05D8E0BE] DEFAULT ((0)) FOR [b_cetak] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__level_1__06CD04F7] DEFAULT ((0)) FOR [level_1] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__level_2__07C12930] DEFAULT ((0)) FOR [level_2] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__level_3__08B54D69] DEFAULT ((0)) FOR [level_3] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__level_4__09A971A2] DEFAULT ((0)) FOR [level_4] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_mtr_gnt] DEFAULT ((0)) FOR [mtr_gnt] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__luas__0B91BA14] DEFAULT ((0)) FOR [luas] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__stakhold__0C85DE4D] DEFAULT ((0)) FOR [stakhold] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__sttsrold__0D7A0286] DEFAULT ((0)) FOR [sttsrold] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__mtr_gntold__0E6E26BF] DEFAULT ((0)) FOR [mtr_gntold] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__jangmtr__0F624AF8] DEFAULT ((0)) FOR [jangmtr] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__Kwit__ujl__10566F31] DEFAULT ((0)) FOR [ujl] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_penggunaan] DEFAULT ((0)) FOR [penggunaan] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__kwit__history_me__403A8C7D] DEFAULT ('0') FOR [history_meter_id] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_sumber_catat] DEFAULT ('web') FOR [sumber_catat] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_useridinc_pencatat] DEFAULT ((0)) FOR [useridinc_pencatat] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_useridinc_update] DEFAULT ((0)) FOR [useridinc_update] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_useridinc_verifikasi] DEFAULT ((0)) FOR [useridinc_verifikasi] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_latitude] DEFAULT ((0)) FOR [latitude] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF_kwit_longitude] DEFAULT ((0)) FOR [longitude] GO ALTER TABLE [dbo].[kwit_old] ADD CONSTRAINT [DF__kwit__mtr_gnt_kc__762C88DA] DEFAULT ((0)) FOR [mtr_gnt_kc] GO ALTER TABLE [dbo].[kwit_old] ADD DEFAULT ((0)) FOR [stand_rev] GO ALTER TABLE [dbo].[kwit_old] ADD DEFAULT ((0)) FOR [stand_kc_rev] GO ALTER TABLE [dbo].[kwit_old] ADD DEFAULT ((0)) FOR [stand_rev_useridinc] GO ALTER TABLE [dbo].[kwit_old] ADD DEFAULT ((0)) FOR [stand_kc_rev_useridinc] GO ALTER TABLE [dbo].[log] ADD CONSTRAINT [DF__log__stand_0__395884C4] DEFAULT ((0)) FOR [stand_0] GO ALTER TABLE [dbo].[log] ADD CONSTRAINT [DF__log__stand_1__3A4CA8FD] DEFAULT ((0)) FOR [stand_1] GO ALTER TABLE [dbo].[meter] ADD CONSTRAINT [DF__meter__KODE_MTR__4E88ABD4] DEFAULT ('') FOR [kode_mtr] GO ALTER TABLE [dbo].[meter] ADD CONSTRAINT [DF_meter_r_meter] DEFAULT ((0.0)) FOR [r_meter] GO ALTER TABLE [dbo].[produksi_air] ADD CONSTRAINT [DF_produksi_air_penggunaan_air] DEFAULT ((0)) FOR [penggunaan_air] GO ALTER TABLE [dbo].[sinkronisasi_ppob] ADD CONSTRAINT [DF_sinkronisasi_ppob_jumlah_data] DEFAULT ((0)) FOR [jumlah_data] GO ALTER TABLE [dbo].[sinkronisasi_ppob] ADD CONSTRAINT [DF_sinkronisasi_ppob_status] DEFAULT ('success') FOR [status] GO ALTER TABLE [dbo].[sub_fitur] ADD CONSTRAINT [DF_sub_fitur_fituridinc] DEFAULT ((0)) FOR [fituridinc] GO ALTER TABLE [dbo].[surat] ADD CONSTRAINT [DF__surat__biaya1__7849DB76] DEFAULT ((0)) FOR [biaya1] GO ALTER TABLE [dbo].[surat] ADD CONSTRAINT [DF__surat__biaya2__793DFFAF] DEFAULT ((0)) FOR [biaya2] GO ALTER TABLE [dbo].[surat] ADD CONSTRAINT [DF__surat__biaya3__7A3223E8] DEFAULT ((0)) FOR [biaya3] GO ALTER TABLE [dbo].[surat] ADD CONSTRAINT [DF__surat__biaya4__7B264821] DEFAULT ((0)) FOR [biaya4] GO ALTER TABLE [dbo].[surat] ADD CONSTRAINT [DF__surat__biaya5__7C1A6C5A] DEFAULT ((0)) FOR [biaya5] GO ALTER TABLE [dbo].[surat] ADD CONSTRAINT [DF__surat__biaya6__7D0E9093] DEFAULT ((0)) FOR [biaya6] GO ALTER TABLE [dbo].[surat] ADD CONSTRAINT [DF__surat__biaya7__7E02B4CC] DEFAULT ((0)) FOR [biaya7] GO ALTER TABLE [dbo].[surat] ADD CONSTRAINT [DF__surat__biaya8__7EF6D905] DEFAULT ((0)) FOR [biaya8] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF__tarif__prog1__46E78A0C] DEFAULT ((0)) FOR [prog1] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF__tarif__prog2__47DBAE45] DEFAULT ((0)) FOR [prog2] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF__tarif__prog3__48CFD27E] DEFAULT ((0)) FOR [prog3] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF__tarif__prog4__49C3F6B7] DEFAULT ((0)) FOR [prog4] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF_tarif_retrial1] DEFAULT ((0.0)) FOR [retrial1] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF_tarif_retrial2] DEFAULT ((0.0)) FOR [retrial2] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF__tarif__ket1__4AB81AF0] DEFAULT ((0)) FOR [ket1] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF__tarif__ket2__4BAC3F29] DEFAULT ((0)) FOR [ket2] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF__tarif__ket3__4CA06362] DEFAULT ((0)) FOR [ket3] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF__tarif__ket4__4D94879B] DEFAULT ((0)) FOR [ket4] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF__tarif__j_adm__4E88ABD4] DEFAULT ((0)) FOR [j_adm] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF__tarif__r_meter__4F7CD00D] DEFAULT ((0)) FOR [r_meter] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF__tarif__b_cetak__5070F446] DEFAULT ((0)) FOR [b_cetak] GO ALTER TABLE [dbo].[tarif] ADD CONSTRAINT [DF_tarif_l2t2] DEFAULT ((0)) FOR [l2t2] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__m_thyl__6AEFE058] DEFAULT ((0)) FOR [m_thyl] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__m_bl1__6BE40491] DEFAULT ((0)) FOR [m_bl1] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__m_bl2__6CD828CA] DEFAULT ((0)) FOR [m_bl2] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__m_bl3__6DCC4D03] DEFAULT ((0)) FOR [m_bl3] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__m_bl4__6EC0713C] DEFAULT ((0)) FOR [m_bl4] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__m_bl5__6FB49575] DEFAULT ((0)) FOR [m_bl5] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__m_bl6__70A8B9AE] DEFAULT ((0)) FOR [m_bl6] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__m_bl7__719CDDE7] DEFAULT ((0)) FOR [m_bl7] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__m_bl8__72910220] DEFAULT ((0)) FOR [m_bl8] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__m_bl9__73852659] DEFAULT ((0)) FOR [m_bl9] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__m_bl10__74794A92] DEFAULT ((0)) FOR [m_bl10] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__m_bl11__756D6ECB] DEFAULT ((0)) FOR [m_bl11] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__m_bl12__76619304] DEFAULT ((0)) FOR [m_bl12] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__mg_bl1__7755B73D] DEFAULT ((0)) FOR [mg_bl1] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__mg_bl2__7849DB76] DEFAULT ((0)) FOR [mg_bl2] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__mg_bl3__793DFFAF] DEFAULT ((0)) FOR [mg_bl3] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__mg_bl4__7A3223E8] DEFAULT ((0)) FOR [mg_bl4] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__mg_bl5__7B264821] DEFAULT ((0)) FOR [mg_bl5] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__mg_bl6__7C1A6C5A] DEFAULT ((0)) FOR [mg_bl6] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__mg_bl7__7D0E9093] DEFAULT ((0)) FOR [mg_bl7] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__mg_bl8__7E02B4CC] DEFAULT ((0)) FOR [mg_bl8] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__mg_bl9__7EF6D905] DEFAULT ((0)) FOR [mg_bl9] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__mg_bl10__7FEAFD3E] DEFAULT ((0)) FOR [mg_bl10] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__mg_bl11__00DF2177] DEFAULT ((0)) FOR [mg_bl11] GO ALTER TABLE [dbo].[trans] ADD CONSTRAINT [DF__trans__mg_bl12__01D345B0] DEFAULT ((0)) FOR [mg_bl12] GO ALTER TABLE [dbo].[user] ADD CONSTRAINT [DF_user_hakakses] DEFAULT ((0)) FOR [hakakses] GO ALTER TABLE [dbo].[akses_fitur] WITH CHECK ADD CONSTRAINT [FK_akses_fitur_fitur] FOREIGN KEY([fituridinc]) REFERENCES [dbo].[fitur] ([fituridinc]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[akses_fitur] CHECK CONSTRAINT [FK_akses_fitur_fitur] GO ALTER TABLE [dbo].[akses_fitur] WITH CHECK ADD CONSTRAINT [FK_akses_fitur_user] FOREIGN KEY([useridinc]) REFERENCES [dbo].[user] ([useridinc]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[akses_fitur] CHECK CONSTRAINT [FK_akses_fitur_user] GO ALTER TABLE [dbo].[akses_sub_fitur] WITH CHECK ADD CONSTRAINT [FK_akses_sub_fitur_sub_fitur] FOREIGN KEY([subfituridinc]) REFERENCES [dbo].[sub_fitur] ([subfituridinc]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[akses_sub_fitur] CHECK CONSTRAINT [FK_akses_sub_fitur_sub_fitur] GO ALTER TABLE [dbo].[akses_sub_fitur] WITH CHECK ADD CONSTRAINT [FK_akses_sub_fitur_user] FOREIGN KEY([useridinc]) REFERENCES [dbo].[user] ([useridinc]) GO ALTER TABLE [dbo].[akses_sub_fitur] CHECK CONSTRAINT [FK_akses_sub_fitur_user] GO ALTER TABLE [dbo].[fitur] WITH CHECK ADD CONSTRAINT [FK_fitur_fitur] FOREIGN KEY([fituridinc]) REFERENCES [dbo].[fitur] ([fituridinc]) GO ALTER TABLE [dbo].[fitur] CHECK CONSTRAINT [FK_fitur_fitur] GO ALTER TABLE [dbo].[angsal] WITH CHECK ADD CONSTRAINT [SSMA_CC$angsal$npal$disallow_zero_length] CHECK ((len([npal])>(0))) GO ALTER TABLE [dbo].[angsal] CHECK CONSTRAINT [SSMA_CC$angsal$npal$disallow_zero_length] GO ALTER TABLE [dbo].[cabang] WITH NOCHECK ADD CONSTRAINT [SSMA_CC$setup$KD_CAB$disallow_zero_length] CHECK ((len([KD_CAB])>(0))) GO ALTER TABLE [dbo].[cabang] CHECK CONSTRAINT [SSMA_CC$setup$KD_CAB$disallow_zero_length] GO ALTER TABLE [dbo].[cabang] WITH NOCHECK ADD CONSTRAINT [SSMA_CC$setup$NM_CAB$disallow_zero_length] CHECK ((len([NM_CAB])>(0))) GO ALTER TABLE [dbo].[cabang] CHECK CONSTRAINT [SSMA_CC$setup$NM_CAB$disallow_zero_length] GO ALTER TABLE [dbo].[meter] WITH NOCHECK ADD CONSTRAINT [SSMA_CC$meter$TYPE_MTR$disallow_zero_length] CHECK ((len([TYPE_MTR])>(0))) GO ALTER TABLE [dbo].[meter] CHECK CONSTRAINT [SSMA_CC$meter$TYPE_MTR$disallow_zero_length] GO ALTER TABLE [dbo].[tarif] WITH NOCHECK ADD CONSTRAINT [SSMA_CC$tarif$nm_tarif$disallow_zero_length] CHECK ((len([nm_tarif])>(0))) GO ALTER TABLE [dbo].[tarif] CHECK CONSTRAINT [SSMA_CC$tarif$nm_tarif$disallow_zero_length] GO ALTER TABLE [dbo].[tarif] WITH NOCHECK ADD CONSTRAINT [SSMA_CC$tarif$tarif$disallow_zero_length] CHECK ((len([tarif])>(0))) GO ALTER TABLE [dbo].[tarif] CHECK CONSTRAINT [SSMA_CC$tarif$tarif$disallow_zero_length] GO ALTER TABLE [dbo].[user] WITH NOCHECK ADD CONSTRAINT [SSMA_CC$user$HakAkses$disallow_zero_length] CHECK ((len([HakAkses])>(0))) GO ALTER TABLE [dbo].[user] CHECK CONSTRAINT [SSMA_CC$user$HakAkses$disallow_zero_length] GO ALTER TABLE [dbo].[user] WITH NOCHECK ADD CONSTRAINT [SSMA_CC$user$Jabatan$disallow_zero_length] CHECK ((len([Jabatan])>(0))) GO ALTER TABLE [dbo].[user] CHECK CONSTRAINT [SSMA_CC$user$Jabatan$disallow_zero_length] GO ALTER TABLE [dbo].[user] WITH NOCHECK ADD CONSTRAINT [SSMA_CC$user$Nama$disallow_zero_length] CHECK ((len([Nama])>(0))) GO ALTER TABLE [dbo].[user] CHECK CONSTRAINT [SSMA_CC$user$Nama$disallow_zero_length] GO ALTER TABLE [dbo].[user] WITH NOCHECK ADD CONSTRAINT [SSMA_CC$user$Password$disallow_zero_length] CHECK ((len([Password])>(0))) GO ALTER TABLE [dbo].[user] CHECK CONSTRAINT [SSMA_CC$user$Password$disallow_zero_length] GO ALTER TABLE [dbo].[user] WITH NOCHECK ADD CONSTRAINT [SSMA_CC$user$UserID$disallow_zero_length] CHECK ((len([UserID])>(0))) GO ALTER TABLE [dbo].[user] CHECK CONSTRAINT [SSMA_CC$user$UserID$disallow_zero_length] GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsab].[npa]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsab', @level2type=N'COLUMN',@level2name=N'npa' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsab].[biaya]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsab', @level2type=N'COLUMN',@level2name=N'biaya' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsab].[dp]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsab', @level2type=N'COLUMN',@level2name=N'dp' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsab].[cicilan]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsab', @level2type=N'COLUMN',@level2name=N'cicilan' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsab].[angsuran]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsab', @level2type=N'COLUMN',@level2name=N'angsuran' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsab].[tgl_00]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsab', @level2type=N'COLUMN',@level2name=N'tgl_00' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsab].[bulan]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsab', @level2type=N'COLUMN',@level2name=N'bulan' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsab].[tahun]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsab', @level2type=N'COLUMN',@level2name=N'tahun' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsab].[ke]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsab', @level2type=N'COLUMN',@level2name=N'ke' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsab].[kodeab]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsab', @level2type=N'COLUMN',@level2name=N'kodeab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsab].[tgl_lunas]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsab', @level2type=N'COLUMN',@level2name=N'tgl_lunas' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsab].[hs]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsab', @level2type=N'COLUMN',@level2name=N'hs' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsab]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal].[npal]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal', @level2type=N'COLUMN',@level2name=N'npal' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal].[kocab]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal', @level2type=N'COLUMN',@level2name=N'kocab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal].[biaya]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal', @level2type=N'COLUMN',@level2name=N'biaya' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal].[dp]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal', @level2type=N'COLUMN',@level2name=N'dp' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal].[cicilan]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal', @level2type=N'COLUMN',@level2name=N'cicilan' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal].[angsuran]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal', @level2type=N'COLUMN',@level2name=N'angsuran' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal].[tgl_00]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal', @level2type=N'COLUMN',@level2name=N'tgl_00' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal].[bulan]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal', @level2type=N'COLUMN',@level2name=N'bulan' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal].[tahun]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal', @level2type=N'COLUMN',@level2name=N'tahun' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal].[ke]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal', @level2type=N'COLUMN',@level2name=N'ke' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal].[kodeal]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal', @level2type=N'COLUMN',@level2name=N'kodeal' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal].[tgl_lunas]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal', @level2type=N'COLUMN',@level2name=N'tgl_lunas' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal].[hs]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal', @level2type=N'COLUMN',@level2name=N'hs' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsal]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsal' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsurmtr].[npa]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsurmtr', @level2type=N'COLUMN',@level2name=N'npa' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsurmtr].[biaya]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsurmtr', @level2type=N'COLUMN',@level2name=N'biaya' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsurmtr].[dp]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsurmtr', @level2type=N'COLUMN',@level2name=N'dp' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsurmtr].[cicilan]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsurmtr', @level2type=N'COLUMN',@level2name=N'cicilan' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsurmtr].[angsuran]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsurmtr', @level2type=N'COLUMN',@level2name=N'angsuran' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsurmtr].[mulairekbln]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsurmtr', @level2type=N'COLUMN',@level2name=N'mulairekbln' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsurmtr].[mulairekthn]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsurmtr', @level2type=N'COLUMN',@level2name=N'mulairekthn' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsurmtr].[ke]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsurmtr', @level2type=N'COLUMN',@level2name=N'ke' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsurmtr].[kode]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsurmtr', @level2type=N'COLUMN',@level2name=N'kode' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsurmtr].[tgl_lunas]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsurmtr', @level2type=N'COLUMN',@level2name=N'tgl_lunas' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[angsurmtr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'angsurmtr' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[buku].[kocab]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'buku', @level2type=N'COLUMN',@level2name=N'kocab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[buku].[no_buku]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'buku', @level2type=N'COLUMN',@level2name=N'no_buku' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[buku]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'buku' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[setup].[KD_CAB]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cabang', @level2type=N'COLUMN',@level2name=N'kd_cab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[setup].[NM_CAB]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cabang', @level2type=N'COLUMN',@level2name=N'nm_cab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[setup].[NM_KACAB]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cabang', @level2type=N'COLUMN',@level2name=N'nm_kacab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[setup].[JAB_KACAB]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cabang', @level2type=N'COLUMN',@level2name=N'jab_kacab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[setup].[NM_KASI1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cabang', @level2type=N'COLUMN',@level2name=N'nm_kasi1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[setup].[JAB_KASI1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cabang', @level2type=N'COLUMN',@level2name=N'jab_kasi1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[setup].[NM_KASI2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cabang', @level2type=N'COLUMN',@level2name=N'nm_kasi2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[setup].[JAB_KASI2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cabang', @level2type=N'COLUMN',@level2name=N'jab_kasi2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[setup].[ALAMAT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cabang', @level2type=N'COLUMN',@level2name=N'alamat' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[setup]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cabang' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[kd_wly]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'kd_wly' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[kd_jln]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'kd_jln' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[kd_ctm]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'kd_ctm' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[kocab]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'kocab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[npal]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'npal' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[noreg]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'noreg' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[no_buku]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'no_buku' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[hal_buku]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'hal_buku' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[na_ctm]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'na_ctm' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[no_rmh]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'no_rmh' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[status]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'status' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[tarif]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'tarif' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[ketstatus]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'ketstatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[type_mtr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'type_mtr' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[kd_byr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'kd_byr' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[kd_tagih]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'kd_tagih' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[trblth]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'trblth' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[trf_al]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'trf_al' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[luas]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'luas' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[no_telp]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'no_telp' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[Kd_klastarif]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'kd_klastarif' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[psb]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'psb' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[kabu]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'kabu' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[keca]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'keca' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom].[kelu]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom', @level2type=N'COLUMN',@level2name=N'kelu' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[custom]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'custom' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[dapel].[kd_wly]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dapel', @level2type=N'COLUMN',@level2name=N'kd_wly' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[dapel].[kd_jln]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dapel', @level2type=N'COLUMN',@level2name=N'kd_jln' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[dapel].[kd_ctm]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dapel', @level2type=N'COLUMN',@level2name=N'kd_ctm' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[dapel].[no_meter]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dapel', @level2type=N'COLUMN',@level2name=N'no_meter' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[dapel].[jenis_mtr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dapel', @level2type=N'COLUMN',@level2name=N'jenis_mtr' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[dapel].[ukuran]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dapel', @level2type=N'COLUMN',@level2name=N'ukuran' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[dapel]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dapel' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[Klstrf].[tarif]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'klstrf', @level2type=N'COLUMN',@level2name=N'tarif' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[Klstrf].[Kd_klastarif]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'klstrf', @level2type=N'COLUMN',@level2name=N'kd_klastarif' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[Klstrf].[Ket_klastarif]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'klstrf', @level2type=N'COLUMN',@level2name=N'ket_klastarif' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[Klstrf]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'klstrf' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Wilayah]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'kd_wly' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Jalan]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'kd_jln' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[kocab]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'kocab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Npa]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'npa' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Noreg]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'noreg' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Npal]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'npal' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[No_buku]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'no_buku' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Hal_buku]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'hal_buku' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Na_ctm]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'na_ctm' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Alamat]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'alamat' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[No_Rmh]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'no_rmh' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Bulan]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'bulan' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Tahun]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'tahun' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Angspsb]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'angspsb' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Jangspsb]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'jangspsb' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Angsal]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'angsal' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Jangsal]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'jangsal' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Retrial]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'retrial' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[m3sblm]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'm3sblm' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Staw]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'staw' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Stakh]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'stakh' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Sttsr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'sttsr' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Jlhrpair]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'jlhrpair' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[nm_tarif]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'nm_tarif' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Materai]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'materai' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Angspdl]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'angspdl' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Jangspdl]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'jangspdl' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[J_adm]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'j_adm' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[type_mtr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'type_mtr' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[kndmtr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'kndmtr' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[R_meter]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'r_meter' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[b_cetak]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'b_cetak' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[level_1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'level_1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[level_2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'level_2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[level_3]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'level_3' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[level_4]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'level_4' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Tglctk]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'tglctk' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Mtr_gnt]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'mtr_gnt' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Tglbyr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'tglbyr' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Kdjual]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'kdjual' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Kode]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'kode' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[Ket_klastarif]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'ket_klastarif' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[luas]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'luas' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[alasannol]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'alasannol' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[alasantaksir]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'alasantaksir' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[stakhold]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'stakhold' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[kdformula]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'kdformula' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[sttsrold]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'sttsrold' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[mtr_gntold]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'mtr_gntold' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[tekanan]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'tekanan' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[tglawal]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'tglawal' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[tglakhir]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'tglakhir' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[ket]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'ket' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[angmtr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'angmtr' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[jangmtr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'jangmtr' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit].[ujl]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old', @level2type=N'COLUMN',@level2name=N'ujl' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'buku0.[Kwit]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'kwit_old' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[Tgl]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'tgl' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[Jam]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'jam' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[UserID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'userid' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[kocab]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'kocab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[kd_wly]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'kd_wly' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[kd_jln]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'kd_jln' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[kd_ctm]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'kd_ctm' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[npal]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'npal' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[stand_0]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'stand_0' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[stand_1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'stand_1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[tarif_0]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'tarif_0' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[tarif_1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'tarif_1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[nama_0]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'nama_0' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[nama_1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'nama_1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[ket]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'ket' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log].[Kode]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log', @level2type=N'COLUMN',@level2name=N'kode' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[log]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'log' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[meter].[TYPE_MTR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'meter', @level2type=N'COLUMN',@level2name=N'type_mtr' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[meter].[NM_METER]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'meter', @level2type=N'COLUMN',@level2name=N'nm_meter' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[meter].[KODE_MTR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'meter', @level2type=N'COLUMN',@level2name=N'kode_mtr' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[meter].[R_METER]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'meter', @level2type=N'COLUMN',@level2name=N'r_meter' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[meter]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'meter' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[kocab]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'kocab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[kd_wly]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'kd_wly' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[kd_jln]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'kd_jln' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[kd_ctm]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'kd_ctm' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[nomor]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'nomor' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[tglsuratcab]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'tglsuratcab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[tglsuratplg]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'tglsuratplg' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[prihalplg]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'prihalplg' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[kdprihal]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'kdprihal' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[isisurat1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'isisurat1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[isisurat2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'isisurat2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[isisurat3]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'isisurat3' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[biaya1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'biaya1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[biaya2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'biaya2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[biaya3]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'biaya3' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[biaya4]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'biaya4' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[biaya5]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'biaya5' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[biaya6]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'biaya6' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[biaya7]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'biaya7' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat].[biaya8]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat', @level2type=N'COLUMN',@level2name=N'biaya8' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[surat]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'surat' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[tarif]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'tarif' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[nm_tarif]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'nm_tarif' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[ket_tarif]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'ket_tarif' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[kode_mtr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'kode_mtr' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[prog1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'prog1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[prog2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'prog2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[prog3]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'prog3' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[prog4]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'prog4' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[ket1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'ket1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[ket2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'ket2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[ket3]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'ket3' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[ket4]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'ket4' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[j_adm]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'j_adm' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[r_meter]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'r_meter' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[b_cetak]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'b_cetak' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[warna]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'warna' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif].[warna1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif', @level2type=N'COLUMN',@level2name=N'warna1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[tarif]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tarif' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[kocab]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'kocab' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[kd_wly]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'kd_wly' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[kd_jln]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'kd_jln' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[kd_ctm]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'kd_ctm' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[npal]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'npal' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[bulan]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'bulan' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[tahun]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'tahun' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[m_thyl]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'm_thyl' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[m_bl1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'm_bl1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[m_bl2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'm_bl2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[m_bl3]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'm_bl3' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[m_bl4]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'm_bl4' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[m_bl5]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'm_bl5' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[m_bl6]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'm_bl6' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[m_bl7]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'm_bl7' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[m_bl8]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'm_bl8' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[m_bl9]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'm_bl9' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[m_bl10]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'm_bl10' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[m_bl11]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'm_bl11' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[m_bl12]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'm_bl12' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[mg_bl1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'mg_bl1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[mg_bl2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'mg_bl2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[mg_bl3]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'mg_bl3' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[mg_bl4]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'mg_bl4' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[mg_bl5]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'mg_bl5' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[mg_bl6]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'mg_bl6' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[mg_bl7]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'mg_bl7' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[mg_bl8]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'mg_bl8' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[mg_bl9]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'mg_bl9' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[mg_bl10]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'mg_bl10' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[mg_bl11]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'mg_bl11' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[mg_bl12]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'mg_bl12' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans].[nama_op]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans', @level2type=N'COLUMN',@level2name=N'nama_op' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[trans]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trans' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[user].[Nama]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'user', @level2type=N'COLUMN',@level2name=N'nama' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[user].[Jabatan]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'user', @level2type=N'COLUMN',@level2name=N'jabatan' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[user].[HakAkses]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'user', @level2type=N'COLUMN',@level2name=N'hakakses' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[user].[UserID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'user', @level2type=N'COLUMN',@level2name=N'userid' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[user].[Password]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'user', @level2type=N'COLUMN',@level2name=N'password' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'custom0.[user]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'user' GO