NJC__Documentation::DB

dbo.tbl_uploadfg_in

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 (~) 739
Created 3/25/2013 01:32:25
Last Modified 11/18/2016 22:54:54

Columns

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

True

1 - 1

False

False

date_upload datetime 8 23 3

False

False

False

filename varchar 300 0 0

False

False

False

filepath varchar 500 0 0

False

False

False

tipe varchar 10 0 0

False

False

False

status_upload varchar 50 0 0

False

False

False

create_date datetime 8 23 3

False

False

False

create_by varchar 50 0 0

False

False

False

update_date datetime 8 23 3

False

False

False

update_by varchar 50 0 0

False

False

False

Indexes

Key Name Columns Unique Type Description
PK_tbl_uploadfg_in id_fgin_upload

True

SQL Script

CREATE TABLE dbo.tbl_uploadfg_in (
  id_fgin_upload bigint IDENTITY,
  date_upload datetime NULL,
  filename varchar(300) NULL,
  filepath varchar(500) NULL,
  tipe varchar(10) NULL,
  status_upload varchar(50) NULL,
  create_date datetime NULL,
  create_by varchar(50) NULL,
  update_date datetime NULL,
  update_by varchar(50) NULL,
  CONSTRAINT PK_tbl_uploadfg_in PRIMARY KEY CLUSTERED (id_fgin_upload) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found