dbo.tbl_bom

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 (~)	4498257
Created	11/2/2016 16:12:55
Last Modified	8/12/2017 17:35:57

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
	id_bom	bigint	8	19	0	True	1 - 1	False	False
3	ASSY_CODE	varchar	50	0	0	False		False	False
	ASSY_NO	varchar	50	0	0	False		False	False
2	PART_NO	varchar	50	0	0	False		False	False
	PARTNO2	varchar	50	0	0	False		False	False
	QTY	decimal	9	18	4	False		False	False
	FLAG	varchar	50	0	0	False		False	False
	STATUS	varchar	50	0	0	False		False	False
	status_bom	varchar	50	0	0	False		False	False
	id_part_number	bigint	8	19	0	False		False	False

Indexes

Name	Columns	Unique
ix_auto_tbl_bom_dtl_20161008_0001	ASSY_CODE	False
ix_auto_tbl_bom_dtl_20161019_0001	PART_NO	False
IX_tbl_bom_dtl	ASSY_CODE, PARTNO2	False
IX_tbl_bom_dtl_I	ASSY_NO	False
IX_tbl_bom_dtl_II	ASSY_CODE	False
IX_tbl_bom_dtl_III	PART_NO	False
PK_tbl_bom	id_bom	True

SQL Script

CREATE TABLE dbo.tbl_bom_dtl (
  id_bom bigint IDENTITY,
  ASSY_CODE varchar(50) NULL,
  ASSY_NO varchar(50) NULL,
  PART_NO varchar(50) NULL,
  PARTNO2 varchar(50) NULL,
  QTY decimal(18, 4) NULL,
  FLAG varchar(50) NULL,
  STATUS varchar(50) NULL,
  status_bom varchar(50) NULL,
  id_part_number bigint NULL,
  CONSTRAINT PK_tbl_bom PRIMARY KEY CLUSTERED (id_bom) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bom_dtl_20161008_0001
  ON dbo.tbl_bom_dtl (ASSY_CODE)
  INCLUDE (PART_NO, QTY)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bom_dtl_20161019_0001
  ON dbo.tbl_bom_dtl (PART_NO)
  INCLUDE (ASSY_CODE, QTY)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX IX_tbl_bom_dtl
  ON dbo.tbl_bom_dtl (ASSY_CODE, PARTNO2)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX IX_tbl_bom_dtl_I
  ON dbo.tbl_bom_dtl (ASSY_NO)
  INCLUDE (id_bom, ASSY_CODE, PART_NO, PARTNO2, QTY, FLAG, STATUS, status_bom, id_part_number)
  ON [PRIMARY]
GO

CREATE INDEX IX_tbl_bom_dtl_II
  ON dbo.tbl_bom_dtl (ASSY_CODE)
  INCLUDE (id_bom, ASSY_NO, PART_NO, PARTNO2, QTY, FLAG, STATUS, status_bom, id_part_number)
  ON [PRIMARY]
GO

CREATE INDEX IX_tbl_bom_dtl_III
  ON dbo.tbl_bom_dtl (PART_NO)
  INCLUDE (id_bom, ASSY_CODE, ASSY_NO, PARTNO2, QTY, FLAG, STATUS, status_bom, id_part_number)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_bom_dtl