dbo.dt_ms_memo_detail

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 (~)	27241
Created	9/11/2017 09:42:00
Last Modified	7/17/2020 10:03:27

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
	ms_memo_detail_supply_id	bigint	8	19	0	True	1 - 1	False	False
	ms_memo_detail_id	bigint	8	19	0	False		False	False
	supply_id_source_header	bigint	8	19	0	False		False	False
2	supply_mode_source	int	4	10	0	False		False	False
	supply_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_memo_detail_supply_2020_07_0001	supply_mode_source	False
ix_dt_ms_memo_detail_supply_2020_07_0002	ms_memo_detail_id, supply_mode_source	False
NonClusteredIndex-20200717-100302	supply_id_source	False
NonClusteredIndex-20200717-100311	supply_id_source_header	False
NonClusteredIndex-20200717-100321	quantity	False
PK_dt_ms_memo_detail_supply	ms_memo_detail_supply_id	True

Foreign Keys

Name	Columns	Description
FK_dt_ms_memo_detail_supply_dt_ms_item_in_detail	ms_in_item_detail_id
FK_dt_ms_memo_detail_supply_dt_ms_item_out_detail	ms_item_out_detail_id
FK_dt_ms_memo_detail_supply_dt_ms_memo_detail	ms_memo_detail_id

SQL Script

CREATE TABLE dbo.dt_ms_memo_detail_supply (
  ms_memo_detail_supply_id bigint IDENTITY,
  ms_memo_detail_id bigint NULL,
  supply_id_source_header bigint NULL,
  supply_mode_source int NULL,
  supply_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_memo_detail_supply PRIMARY KEY CLUSTERED (ms_memo_detail_supply_id)
)
ON [PRIMARY]
GO

CREATE INDEX ix_dt_ms_memo_detail_supply_2020_07_0001
  ON dbo.dt_ms_memo_detail_supply (supply_mode_source)
  INCLUDE (ms_memo_detail_id, supply_id_source, quantity)
  ON [PRIMARY]
GO

CREATE INDEX ix_dt_ms_memo_detail_supply_2020_07_0002
  ON dbo.dt_ms_memo_detail_supply (ms_memo_detail_id, supply_mode_source)
  INCLUDE (supply_id_source, quantity)
  ON [PRIMARY]
GO

CREATE INDEX [NonClusteredIndex-20200717-100302]
  ON dbo.dt_ms_memo_detail_supply (supply_id_source)
  ON [PRIMARY]
GO

CREATE INDEX [NonClusteredIndex-20200717-100311]
  ON dbo.dt_ms_memo_detail_supply (supply_id_source_header)
  ON [PRIMARY]
GO

CREATE INDEX [NonClusteredIndex-20200717-100321]
  ON dbo.dt_ms_memo_detail_supply (quantity)
  ON [PRIMARY]
GO

ALTER TABLE dbo.dt_ms_memo_detail_supply WITH NOCHECK
  ADD CONSTRAINT FK_dt_ms_memo_detail_supply_dt_ms_item_in_detail FOREIGN KEY (supply_id_source) REFERENCES dbo.dt_ms_item_in_detail (ms_in_item_detail_id) NOT FOR REPLICATION
GO

ALTER TABLE dbo.dt_ms_memo_detail_supply
  NOCHECK CONSTRAINT FK_dt_ms_memo_detail_supply_dt_ms_item_in_detail
GO

ALTER TABLE dbo.dt_ms_memo_detail_supply WITH NOCHECK
  ADD CONSTRAINT FK_dt_ms_memo_detail_supply_dt_ms_item_out_detail FOREIGN KEY (supply_id_source) REFERENCES dbo.dt_ms_item_out_detail (ms_item_out_detail_id) NOT FOR REPLICATION
GO

ALTER TABLE dbo.dt_ms_memo_detail_supply
  NOCHECK CONSTRAINT FK_dt_ms_memo_detail_supply_dt_ms_item_out_detail
GO

ALTER TABLE dbo.dt_ms_memo_detail_supply WITH NOCHECK
  ADD CONSTRAINT FK_dt_ms_memo_detail_supply_dt_ms_memo_detail FOREIGN KEY (ms_memo_detail_id) REFERENCES dbo.dt_ms_memo_detail (ms_memo_detail_id) NOT FOR REPLICATION
GO

ALTER TABLE dbo.dt_ms_memo_detail_supply
  NOCHECK CONSTRAINT FK_dt_ms_memo_detail_supply_dt_ms_memo_detail
GO

dbo.dt_ms_memo_detail_supply