Description
Properties
| Name | Value |
|---|---|
| Collation | |
| File Group | |
| Filestream File Group | |
| Is Partitioned | False |
| Partitioned Column | |
| Partition Scheme | |
| File Groups | |
| Filestream Partition Scheme | |
| Filestream File Groups | |
| Heap | False |
| Full Text Catalog | |
| Full Text | |
| Compression | NONE |
| Row Count (~) | 0 |
| Created | 9/11/2017 09:42:01 |
| Last Modified | 9/11/2017 09:42:03 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ID | bigint | 8 | 19 | 0 | True |
1 - 1 | False |
False |
|||
| ID_ORI | bigint | 8 | 19 | 0 | False |
False |
False |
|||||
| mode_source | int | 4 | 10 | 0 | False |
False |
False |
|||||
| id_source | bigint | 8 | 19 | 0 | False |
False |
False |
|||||
| FLAG_URL_DOKUMEN | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| KODE_JENIS_DOKUMEN | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| NOMOR_DOKUMEN | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| SERI_DOKUMEN | bigint | 8 | 19 | 0 | False |
False |
False |
|||||
| TANGGAL_DOKUMEN | datetime2 | 8 | 27 | 7 | False |
False |
False |
|||||
| TIPE_DOKUMEN | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| URL_DOKUMEN | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
|
ID_HEADER | bigint | 8 | 19 | 0 | False |
False |
False |
||||
| ID_HEADER_ORI | bigint | 8 | 19 | 0 | False |
False |
False |
|||||
| create_date | datetime | 8 | 23 | 3 | False |
(getdate()) | False |
False |
||||
| create_by | int | 4 | 10 | 0 | False |
False |
False |
|||||
| modify_date | datetime | 8 | 23 | 3 | False |
False |
False |
|||||
| modify_by | int | 4 | 10 | 0 | False |
False |
False |
Indexes
| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
|
|
PK_tpb_out_dokumen | ID | True |
Foreign Keys
| Name | Columns | Description |
|---|---|---|
| FK_tpb_out_dokumen_tpb_out_header | ID_HEADER |
SQL Script
CREATE TABLE dbo.dt_ms_tpb_out_dokumen (
ID bigint IDENTITY,
ID_ORI bigint NULL,
mode_source int NULL,
id_source bigint NULL,
FLAG_URL_DOKUMEN varchar(255) NULL,
KODE_JENIS_DOKUMEN varchar(255) NULL,
NOMOR_DOKUMEN varchar(255) NULL,
SERI_DOKUMEN bigint NULL,
TANGGAL_DOKUMEN datetime2 NULL,
TIPE_DOKUMEN varchar(255) NULL,
URL_DOKUMEN varchar(255) NULL,
ID_HEADER bigint NULL,
ID_HEADER_ORI bigint NULL,
create_date datetime NULL CONSTRAINT DF_tpb_out_dokumen_create_date DEFAULT (getdate()),
create_by int NULL,
modify_date datetime NULL,
modify_by int NULL,
CONSTRAINT PK_tpb_out_dokumen PRIMARY KEY CLUSTERED (ID) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
ALTER TABLE dbo.dt_ms_tpb_out_dokumen WITH NOCHECK
ADD CONSTRAINT FK_tpb_out_dokumen_tpb_out_header FOREIGN KEY (ID_HEADER) REFERENCES dbo.dt_ms_tpb_out_header (ID_HEADER) NOT FOR REPLICATION
GO
ALTER TABLE dbo.dt_ms_tpb_out_dokumen
NOCHECK CONSTRAINT FK_tpb_out_dokumen_tpb_out_header
GO
ID bigint IDENTITY,
ID_ORI bigint NULL,
mode_source int NULL,
id_source bigint NULL,
FLAG_URL_DOKUMEN varchar(255) NULL,
KODE_JENIS_DOKUMEN varchar(255) NULL,
NOMOR_DOKUMEN varchar(255) NULL,
SERI_DOKUMEN bigint NULL,
TANGGAL_DOKUMEN datetime2 NULL,
TIPE_DOKUMEN varchar(255) NULL,
URL_DOKUMEN varchar(255) NULL,
ID_HEADER bigint NULL,
ID_HEADER_ORI bigint NULL,
create_date datetime NULL CONSTRAINT DF_tpb_out_dokumen_create_date DEFAULT (getdate()),
create_by int NULL,
modify_date datetime NULL,
modify_by int NULL,
CONSTRAINT PK_tpb_out_dokumen PRIMARY KEY CLUSTERED (ID) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
ALTER TABLE dbo.dt_ms_tpb_out_dokumen WITH NOCHECK
ADD CONSTRAINT FK_tpb_out_dokumen_tpb_out_header FOREIGN KEY (ID_HEADER) REFERENCES dbo.dt_ms_tpb_out_header (ID_HEADER) NOT FOR REPLICATION
GO
ALTER TABLE dbo.dt_ms_tpb_out_dokumen
NOCHECK CONSTRAINT FK_tpb_out_dokumen_tpb_out_header
GO