NJC__Documentation::DB

dbo.dt_interface_module_bc_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 (~) 3
Created 10/8/2016 12:25:27
Last Modified 11/18/2016 23:33:50

Columns

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

True

1 - 1

False

False

interface_module_bc_id bigint 8 19 0

False

False

False

status_interface_module_bc_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

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_interface_module_bc_h_status interface_module_bc_h_status_id

True

SQL Script

CREATE TABLE dbo.dt_interface_module_bc_h_status (
  interface_module_bc_h_status_id bigint IDENTITY,
  interface_module_bc_id bigint NULL,
  status_interface_module_bc_id int NULL,
  status_info varchar(1000) NULL,
  create_date datetime NULL,
  create_by int NULL,
  modify_date datetime NULL,
  modify_by int NULL,
  CONSTRAINT PK_dt_interface_module_bc_h_status PRIMARY KEY CLUSTERED (interface_module_bc_h_status_id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found