NJC__Documentation::DB

dbo.tbl_inventory_control

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 6/19/2020 22:58:49
Last Modified 6/19/2020 22:58:49

Columns

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

True

1 - 1

False

False

tgl date 3 10 0

False

False

False

amount decimal 13 24 2

False

False

False

jenis varchar 50 0 0

False

False

False

title varchar 50 0 0

False

False

False

periode varchar 50 0 0

False

False

False

SQL Script

CREATE TABLE dbo.tbl_inventory_control (
  id_inventory_control bigint IDENTITY,
  tgl date NULL,
  amount decimal(24, 2) NULL,
  jenis varchar(50) NULL,
  title varchar(50) NULL,
  periode varchar(50) NULL
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found