NJC__Documentation::DB

dbo.dt_ms_tpb_out_bahan_baku_dokumen

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:01

Columns

Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
ID bigint 8 19 0

True

False

False

ID_ORI bigint 8 19 0

False

False

False

KODE_ASAL_BAHAN_BAKU bigint 8 19 0

False

False

False

SERI_DOKUMEN bigint 8 19 0

False

False

False

ID_BAHAN_BAKU bigint 8 19 0

False

False

False

ID_BARANG bigint 8 19 0

False

False

False

ID_HEADER bigint 8 19 0

False

False

False

Indexes

Key Name Columns Unique Type Description
PK_tpb_out_bahan_baku_dokumen ID

True

SQL Script

CREATE TABLE dbo.dt_ms_tpb_out_bahan_baku_dokumen (
  ID bigint NOT NULL,
  ID_ORI bigint NULL,
  KODE_ASAL_BAHAN_BAKU bigint NULL,
  SERI_DOKUMEN bigint NULL,
  ID_BAHAN_BAKU bigint NULL,
  ID_BARANG bigint NULL,
  ID_HEADER bigint NULL,
  CONSTRAINT PK_tpb_out_bahan_baku_dokumen PRIMARY KEY CLUSTERED (ID) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found