NJC__Documentation::DB

dbo.tpb_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

True

Full Text Catalog
Full Text
Compression NONE
Row Count (~) 0
Created 8/14/2017 16:45:08
Last Modified 8/14/2017 16:45:08

Columns

Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
ID 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

SQL Script

CREATE TABLE dbo.tpb_dokumen (
  ID 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
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found