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 (~) | 11540143 |
| Created | 4/27/2013 13:45:16 |
| Last Modified | 9/11/2017 17:15:02 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
id_vgi_dtl | bigint | 8 | 19 | 0 | True |
1 - 1 | False |
False |
|||
|
id_vgi_hdr | bigint | 8 | 19 | 0 | False |
False |
False |
||||
|
|
issue_no | varchar | 50 | 0 | 0 | False |
False |
False |
||||
| vgi_date | datetime | 8 | 23 | 3 | False |
False |
False |
|||||
| r1 | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| r2 | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
|
|
part_number | varchar | 50 | 0 | 0 | False |
False |
False |
||||
| qty | float | 8 | 53 | 0 | False |
False |
False |
Indexes
| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
| ix_auto_tbl_vgi_dtl_20161019_0001 | vgi_date | False |
|||
| ix_auto_tbl_vgi_dtl_20161019_0002 | vgi_date | False |
|||
| IX_tbl_vgi_dtl_I | issue_no | False |
|||
| IX_tbl_vgi_dtl_II | part_number | False |
|||
| IX_tbl_vgi_dtl_III | id_vgi_hdr | False |
|||
|
|
PK_tbl_vgi | id_vgi_dtl | True |
||
|
|
tbl_vgi_uq | id_vgi_dtl | True |
Foreign Keys
| Name | Columns | Description |
|---|---|---|
| FK_tbl_vgi_dtl_tbl_vgi_hdr | id_vgi_hdr |
SQL Script
CREATE TABLE dbo.tbl_vgi_dtl (
id_vgi_dtl bigint IDENTITY,
id_vgi_hdr bigint NULL,
issue_no varchar(50) NULL,
vgi_date datetime NULL,
r1 varchar(50) NULL,
r2 varchar(50) NULL,
part_number varchar(50) NULL,
qty float NULL,
CONSTRAINT PK_tbl_vgi PRIMARY KEY CLUSTERED (id_vgi_dtl) WITH (FILLFACTOR = 80),
CONSTRAINT tbl_vgi_uq UNIQUE (id_vgi_dtl) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
CREATE INDEX ix_auto_tbl_vgi_dtl_20161019_0001
ON dbo.tbl_vgi_dtl (vgi_date)
INCLUDE (id_vgi_dtl, part_number)
WITH (FILLFACTOR = 80)
ON [PRIMARY]
GO
CREATE INDEX ix_auto_tbl_vgi_dtl_20161019_0002
ON dbo.tbl_vgi_dtl (vgi_date)
INCLUDE (id_vgi_dtl, id_vgi_hdr, r1, r2, part_number, qty)
WITH (FILLFACTOR = 80)
ON [PRIMARY]
GO
CREATE INDEX IX_tbl_vgi_dtl_I
ON dbo.tbl_vgi_dtl (issue_no)
INCLUDE (id_vgi_dtl, id_vgi_hdr, vgi_date, r1, r2, part_number, qty)
ON [PRIMARY]
GO
CREATE INDEX IX_tbl_vgi_dtl_II
ON dbo.tbl_vgi_dtl (part_number)
INCLUDE (id_vgi_dtl, id_vgi_hdr, issue_no, vgi_date, r1, r2, qty)
ON [PRIMARY]
GO
CREATE INDEX IX_tbl_vgi_dtl_III
ON dbo.tbl_vgi_dtl (id_vgi_hdr)
INCLUDE (id_vgi_dtl, issue_no, vgi_date, r1, r2, part_number, qty)
ON [PRIMARY]
GO
ALTER TABLE dbo.tbl_vgi_dtl WITH NOCHECK
ADD CONSTRAINT FK_tbl_vgi_dtl_tbl_vgi_hdr FOREIGN KEY (id_vgi_hdr) REFERENCES dbo.tbl_vgi_hdr (id_vgi_hdr) NOT FOR REPLICATION
GO
ALTER TABLE dbo.tbl_vgi_dtl
NOCHECK CONSTRAINT FK_tbl_vgi_dtl_tbl_vgi_hdr
GO
id_vgi_dtl bigint IDENTITY,
id_vgi_hdr bigint NULL,
issue_no varchar(50) NULL,
vgi_date datetime NULL,
r1 varchar(50) NULL,
r2 varchar(50) NULL,
part_number varchar(50) NULL,
qty float NULL,
CONSTRAINT PK_tbl_vgi PRIMARY KEY CLUSTERED (id_vgi_dtl) WITH (FILLFACTOR = 80),
CONSTRAINT tbl_vgi_uq UNIQUE (id_vgi_dtl) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
CREATE INDEX ix_auto_tbl_vgi_dtl_20161019_0001
ON dbo.tbl_vgi_dtl (vgi_date)
INCLUDE (id_vgi_dtl, part_number)
WITH (FILLFACTOR = 80)
ON [PRIMARY]
GO
CREATE INDEX ix_auto_tbl_vgi_dtl_20161019_0002
ON dbo.tbl_vgi_dtl (vgi_date)
INCLUDE (id_vgi_dtl, id_vgi_hdr, r1, r2, part_number, qty)
WITH (FILLFACTOR = 80)
ON [PRIMARY]
GO
CREATE INDEX IX_tbl_vgi_dtl_I
ON dbo.tbl_vgi_dtl (issue_no)
INCLUDE (id_vgi_dtl, id_vgi_hdr, vgi_date, r1, r2, part_number, qty)
ON [PRIMARY]
GO
CREATE INDEX IX_tbl_vgi_dtl_II
ON dbo.tbl_vgi_dtl (part_number)
INCLUDE (id_vgi_dtl, id_vgi_hdr, issue_no, vgi_date, r1, r2, qty)
ON [PRIMARY]
GO
CREATE INDEX IX_tbl_vgi_dtl_III
ON dbo.tbl_vgi_dtl (id_vgi_hdr)
INCLUDE (id_vgi_dtl, issue_no, vgi_date, r1, r2, part_number, qty)
ON [PRIMARY]
GO
ALTER TABLE dbo.tbl_vgi_dtl WITH NOCHECK
ADD CONSTRAINT FK_tbl_vgi_dtl_tbl_vgi_hdr FOREIGN KEY (id_vgi_hdr) REFERENCES dbo.tbl_vgi_hdr (id_vgi_hdr) NOT FOR REPLICATION
GO
ALTER TABLE dbo.tbl_vgi_dtl
NOCHECK CONSTRAINT FK_tbl_vgi_dtl_tbl_vgi_hdr
GO