NJC__Documentation::DB

dbo.tbl_uploadalatkantor_out

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 (~) 10
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_uploadak_out_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__DA312AF462F9D3D7 id_uploadak_out_upload

True

SQL Script

CREATE TABLE dbo.tbl_uploadalatkantor_out (
  id_uploadak_out_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_uploadak_out_upload)
)
ON [PRIMARY]
GO

Depends On

No items found