NJC__Documentation::DB

dbo.dt_ms_production_retur_h_status

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 9/11/2017 09:42:01
Last Modified 9/11/2017 09:42:03

Columns

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

True

1 - 1

False

False

ms_production_retur_id bigint 8 19 0

False

False

False

status_production_retur_id int 4 10 0

False

False

False

status_info varchar 1000 0 0

False

False

False

create_date datetime 8 23 3

False

False

False

create_by int 4 10 0

False

False

False

Indexes

Key Name Columns Unique Type Description
PK_dt_ms_production_retur_h_status ms_production_retur_h_status_id

True

SQL Script

CREATE TABLE dbo.dt_ms_production_retur_h_status (
  ms_production_retur_h_status_id bigint IDENTITY,
  ms_production_retur_id bigint NULL,
  status_production_retur_id int NULL,
  status_info varchar(1000) NULL,
  create_date datetime NULL,
  create_by int NULL,
  CONSTRAINT PK_dt_ms_production_retur_h_status PRIMARY KEY CLUSTERED (ms_production_retur_h_status_id)
)
ON [PRIMARY]
GO

Depends On

No items found