dbo.tbl_data_supplier

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 (~)	217
Created	5/3/2017 11:46:19
Last Modified	5/3/2017 11:46:22

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
id	bigint	8	19	True	1 - 1	False	False
supplier_code	varchar	10	0	True		False	False
supplier_name	varchar	50	0	False		False	False
supplier_address	varchar	170	0	False		False	False
supplier_address1	varchar	170	0	False		False	False
supplier_country	varchar	2	0	False		False	False
base_price	varchar	10	0	False		False	False
copper_base_reff	varchar	50	0	False		False	False
subgct	varchar	50	0	False		False	False
subcode_as400	varchar	50	0	False		False	False
NPWP	varchar	50	0	False		False	False
NOIJIN	varchar	50	0	False		False	False
NOKONTRAK	varchar	50	0	False		False	False
TGLIJIN	date	3	10	False		False	False
TGLKONTRAK	date	3	10	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_data_supplier	id, supplier_code	True

SQL Script

CREATE TABLE dbo.tbl_data_supplier (
  id bigint IDENTITY,
  supplier_code varchar(10) NOT NULL,
  supplier_name varchar(50) NULL,
  supplier_address varchar(170) NULL,
  supplier_address1 varchar(170) NULL,
  supplier_country varchar(2) NULL,
  base_price varchar(10) NULL,
  copper_base_reff varchar(50) NULL,
  subgct varchar(50) NULL,
  subcode_as400 varchar(50) NULL,
  NPWP varchar(50) NULL,
  NOIJIN varchar(50) NULL,
  NOKONTRAK varchar(50) NULL,
  TGLIJIN date NULL,
  TGLKONTRAK date NULL,
  CONSTRAINT PK_tbl_data_supplier PRIMARY KEY CLUSTERED (id, supplier_code) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found