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 (~) | 215 |
| Created | 9/11/2017 09:42:00 |
| Last Modified | 9/11/2017 09:42:02 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ms_car_line_group_id | int | 4 | 10 | 0 | True |
1 - 1 | False |
False |
||||
| ms_car_line_group | varchar | 50 | 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 |
SQL Script
CREATE TABLE dbo.dt_ms_car_line_group (
ms_car_line_group_id int IDENTITY,
ms_car_line_group varchar(50) NULL,
create_date datetime NULL,
create_by int NULL,
modify_date datetime NULL,
modify_by int NULL,
CONSTRAINT PK_dt_ms_car_line_group PRIMARY KEY CLUSTERED (ms_car_line_group_id)
)
ON [PRIMARY]
GO
ms_car_line_group_id int IDENTITY,
ms_car_line_group varchar(50) NULL,
create_date datetime NULL,
create_by int NULL,
modify_date datetime NULL,
modify_by int NULL,
CONSTRAINT PK_dt_ms_car_line_group PRIMARY KEY CLUSTERED (ms_car_line_group_id)
)
ON [PRIMARY]
GO
Depends On
No items found
Used By
13- dbo.dt_ms_car_line
- dbo.vw_ms_car_line
- dbo.vw_ms_car_line_group
- dbo.MG_MS_CAR_LINE_ADD
- dbo.MG_MS_CAR_LINE_EDIT
- dbo.MG_MS_CAR_LINE_GROUP_ADD
- dbo.MG_MS_CAR_LINE_GROUP_DELETE
- dbo.MG_MS_CAR_LINE_GROUP_EDIT
- dbo.MG_MS_FIND_CAR_LINE_GROUP
- dbo.MG_MS_ITEM_FINAL_AVG_CREATE
- dbo.MG_MS_ITEM_FINAL_AVG_CREATE_BACKUP
- dbo.MS_MS_ITEM_FINAL_AVG_REPORT_ALL
- dbo.MS_MS_ITEM_FINAL_AVG_REPORT_ALL_BACKUP