NJC__Documentation::DB

dbo.tbl_upload_bc25_scrap_fg

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 1/14/2016 01:39:34
Last Modified 11/18/2016 22:50:23

Columns

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

tipe varchar 50 0 0

False

False

False

filepath varchar 500 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_upload_scrap_fg id_upload_scrap_fg

True

SQL Script

CREATE TABLE dbo.tbl_upload_bc25_scrap_fg (
  id_upload_scrap_fg bigint IDENTITY,
  date_upload datetime NULL,
  filename varchar(300) NULL,
  tipe varchar(50) NULL,
  filepath varchar(500) 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_upload_scrap_fg PRIMARY KEY CLUSTERED (id_upload_scrap_fg) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found