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 (~) | 2 |
| 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 |
|||||
| KESESUAIAN_DOKUMEN | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| KETERANGAN | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| KODE_STUFFING | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| KODE_TIPE_KONTAINER | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| KODE_UKURAN_KONTAINER | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| FLAG_GATE_IN | varchar | 1 | 0 | 0 | False |
False |
False |
|||||
| FLAG_GATE_OUT | varchar | 1 | 0 | 0 | False |
False |
False |
|||||
| NO_POLISI | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| NOMOR_KONTAINER | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| NOMOR_SEGEL | varchar | 255 | 0 | 0 | False |
False |
False |
|||||
| SERI_KONTAINER | bigint | 8 | 19 | 0 | False |
False |
False |
|||||
| WAKTU_GATE_IN | datetime2 | 8 | 27 | 7 | False |
False |
False |
|||||
| WAKTU_GATE_OUT | datetime2 | 8 | 27 | 7 | False |
False |
False |
|||||
|
ID_HEADER | bigint | 8 | 19 | 0 | False |
False |
False |
||||
| ID_HEADER_ORI | bigint | 8 | 19 | 0 | False |
False |
False |
|||||
| is_get | bit | 1 | 1 | 0 | False |
False |
False |
|||||
| mode_edit_id | int | 4 | 10 | 0 | False |
False |
False |
|||||
| mode_source | int | 4 | 10 | 0 | False |
False |
False |
|||||
| id_source | 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_in_kontainer | ID | True |
Foreign Keys
| Name | Columns | Description |
|---|---|---|
| FK_tpb_in_kontainer_tpb_in_header | ID_HEADER |
SQL Script
CREATE TABLE dbo.dt_ms_tpb_in_kontainer (
ID bigint IDENTITY,
ID_ORI bigint NULL,
KESESUAIAN_DOKUMEN varchar(255) NULL,
KETERANGAN varchar(255) NULL,
KODE_STUFFING varchar(255) NULL,
KODE_TIPE_KONTAINER varchar(255) NULL,
KODE_UKURAN_KONTAINER varchar(255) NULL,
FLAG_GATE_IN varchar(1) NULL,
FLAG_GATE_OUT varchar(1) NULL,
NO_POLISI varchar(255) NULL,
NOMOR_KONTAINER varchar(255) NULL,
NOMOR_SEGEL varchar(255) NULL,
SERI_KONTAINER bigint NULL,
WAKTU_GATE_IN datetime2 NULL,
WAKTU_GATE_OUT datetime2 NULL,
ID_HEADER bigint NULL,
ID_HEADER_ORI bigint NULL,
is_get bit NULL,
mode_edit_id int NULL,
mode_source int NULL,
id_source bigint NULL,
create_date datetime NULL CONSTRAINT DF_tpb_in_kontainer_create_date DEFAULT (getdate()),
create_by int NULL,
modify_date datetime NULL,
modify_by int NULL,
CONSTRAINT PK_tpb_in_kontainer PRIMARY KEY CLUSTERED (ID) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
ALTER TABLE dbo.dt_ms_tpb_in_kontainer WITH NOCHECK
ADD CONSTRAINT FK_tpb_in_kontainer_tpb_in_header FOREIGN KEY (ID_HEADER) REFERENCES dbo.dt_ms_tpb_in_header (ID_HEADER) NOT FOR REPLICATION
GO
ALTER TABLE dbo.dt_ms_tpb_in_kontainer
NOCHECK CONSTRAINT FK_tpb_in_kontainer_tpb_in_header
GO
ID bigint IDENTITY,
ID_ORI bigint NULL,
KESESUAIAN_DOKUMEN varchar(255) NULL,
KETERANGAN varchar(255) NULL,
KODE_STUFFING varchar(255) NULL,
KODE_TIPE_KONTAINER varchar(255) NULL,
KODE_UKURAN_KONTAINER varchar(255) NULL,
FLAG_GATE_IN varchar(1) NULL,
FLAG_GATE_OUT varchar(1) NULL,
NO_POLISI varchar(255) NULL,
NOMOR_KONTAINER varchar(255) NULL,
NOMOR_SEGEL varchar(255) NULL,
SERI_KONTAINER bigint NULL,
WAKTU_GATE_IN datetime2 NULL,
WAKTU_GATE_OUT datetime2 NULL,
ID_HEADER bigint NULL,
ID_HEADER_ORI bigint NULL,
is_get bit NULL,
mode_edit_id int NULL,
mode_source int NULL,
id_source bigint NULL,
create_date datetime NULL CONSTRAINT DF_tpb_in_kontainer_create_date DEFAULT (getdate()),
create_by int NULL,
modify_date datetime NULL,
modify_by int NULL,
CONSTRAINT PK_tpb_in_kontainer PRIMARY KEY CLUSTERED (ID) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
ALTER TABLE dbo.dt_ms_tpb_in_kontainer WITH NOCHECK
ADD CONSTRAINT FK_tpb_in_kontainer_tpb_in_header FOREIGN KEY (ID_HEADER) REFERENCES dbo.dt_ms_tpb_in_header (ID_HEADER) NOT FOR REPLICATION
GO
ALTER TABLE dbo.dt_ms_tpb_in_kontainer
NOCHECK CONSTRAINT FK_tpb_in_kontainer_tpb_in_header
GO