NJC__Documentation::DB

dbo.dt_ms_type_prosses

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 (~) 5
Created 9/11/2017 09:42:02
Last Modified 9/11/2017 09:42:02

Columns

Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
ms_type_prosses_id int 4 10 0

True

1 - 1

False

False

ms_type_prosses_name varchar 50 0 0

False

False

False

is_readonly bit 1 1 0

False

False

False

create_date datetime 8 23 3

False

False

False

create_by int 4 10 0

False

False

False

modify_date datetime 8 23 3

False

False

False

modify_by int 4 10 0

False

False

False

Indexes

Key Name Columns Unique Type Description
PK_dt_ms_car_line_prosses ms_type_prosses_id

True

SQL Script

CREATE TABLE dbo.dt_ms_type_prosses (
  ms_type_prosses_id int IDENTITY,
  ms_type_prosses_name varchar(50) NULL,
  is_readonly bit NULL,
  create_date datetime NULL,
  create_by int NULL,
  modify_date datetime NULL,
  modify_by int NULL,
  CONSTRAINT PK_dt_ms_car_line_prosses PRIMARY KEY CLUSTERED (ms_type_prosses_id)
)
ON [PRIMARY]
GO

Depends On

No items found