dbo.dt_ms_item_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 (~)	74895
Created	9/11/2017 09:42:00
Last Modified	7/17/2020 10:07:06

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
	ms_item_out_detail_id	bigint	8	19	0	True	1 - 1	False	False
2	ms_in_item_detail_id	bigint	8	19	0	True		False	False
2	mode_source	int	4	10	0	False		False	False
	id_source_header	bigint	8	19	0	False		False	False
2	id_source	bigint	8	19	0	False		False	False
	quantity	decimal	17	38	4	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

Name	Columns	Unique
ix_dt_ms_item_out_detail_2018_02_27_001	mode_source, id_source	False
ix_dt_ms_item_out_detail_2018_02_27_002	ms_in_item_detail_id	False
ix_dt_ms_item_out_detail_2020_07_0001	id_source	False
NonClusteredIndex-20200717-100631	id_source_header	False
NonClusteredIndex-20200717-100649	ms_in_item_detail_id	False
NonClusteredIndex-20200717-100701	mode_source	False
PK_dt_ms_car_line_out_detail_lst_supply	ms_item_out_detail_id	True

Foreign Keys

Name	Columns	Description
FK_dt_ms_item_out_detail_dt_ms_car_line_out_detail	ms_car_line_out_detail_id
FK_dt_ms_item_out_detail_dt_ms_item_in_detail	ms_in_item_detail_id

SQL Script

CREATE TABLE dbo.dt_ms_item_out_detail (
  ms_item_out_detail_id bigint IDENTITY,
  ms_in_item_detail_id bigint NOT NULL,
  mode_source int NULL,
  id_source_header bigint NULL,
  id_source bigint NULL,
  quantity decimal(38, 4) NULL,
  create_date datetime NULL,
  create_by int NULL,
  modify_date datetime NULL,
  modify_by int NULL,
  CONSTRAINT PK_dt_ms_car_line_out_detail_lst_supply PRIMARY KEY CLUSTERED (ms_item_out_detail_id)
)
ON [PRIMARY]
GO

CREATE INDEX ix_dt_ms_item_out_detail_2018_02_27_001
  ON dbo.dt_ms_item_out_detail (mode_source, id_source)
  INCLUDE (ms_item_out_detail_id, ms_in_item_detail_id, quantity)
  ON [PRIMARY]
GO

CREATE INDEX ix_dt_ms_item_out_detail_2018_02_27_002
  ON dbo.dt_ms_item_out_detail (ms_in_item_detail_id)
  ON [PRIMARY]
GO

CREATE INDEX ix_dt_ms_item_out_detail_2020_07_0001
  ON dbo.dt_ms_item_out_detail (id_source)
  INCLUDE (ms_in_item_detail_id, quantity)
  ON [PRIMARY]
GO

CREATE INDEX [NonClusteredIndex-20200717-100631]
  ON dbo.dt_ms_item_out_detail (id_source_header)
  ON [PRIMARY]
GO

CREATE INDEX [NonClusteredIndex-20200717-100649]
  ON dbo.dt_ms_item_out_detail (ms_in_item_detail_id)
  ON [PRIMARY]
GO

CREATE INDEX [NonClusteredIndex-20200717-100701]
  ON dbo.dt_ms_item_out_detail (mode_source)
  ON [PRIMARY]
GO

ALTER TABLE dbo.dt_ms_item_out_detail WITH NOCHECK
  ADD CONSTRAINT FK_dt_ms_item_out_detail_dt_ms_car_line_out_detail FOREIGN KEY (id_source) REFERENCES dbo.dt_ms_car_line_out_detail (ms_car_line_out_detail_id) NOT FOR REPLICATION
GO

ALTER TABLE dbo.dt_ms_item_out_detail
  NOCHECK CONSTRAINT FK_dt_ms_item_out_detail_dt_ms_car_line_out_detail
GO

ALTER TABLE dbo.dt_ms_item_out_detail WITH NOCHECK
  ADD CONSTRAINT FK_dt_ms_item_out_detail_dt_ms_item_in_detail FOREIGN KEY (ms_in_item_detail_id) REFERENCES dbo.dt_ms_item_in_detail (ms_in_item_detail_id) NOT FOR REPLICATION
GO

ALTER TABLE dbo.dt_ms_item_out_detail
  NOCHECK CONSTRAINT FK_dt_ms_item_out_detail_dt_ms_item_in_detail
GO

dbo.dt_ms_item_out_detail