NJC__Documentation::DB

dbo.tbl_uploadbahanpenolong_bc27

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 8/12/2017 13:09:42
Last Modified 8/12/2017 13:09:42

Columns

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

True

SQL Script

CREATE TABLE dbo.tbl_uploadbahanpenolong_bc27 (
  id_upload_bp_bc27_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,
  PRIMARY KEY CLUSTERED (id_upload_bp_bc27_upload) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found