dbo.dt_ms_report_car_line

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 (~)	11
Created	9/11/2017 09:42:01
Last Modified	9/13/2017 15:24:06

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
ms_report_car_line_sum_id	int	4	10	0	True	1 - 1	False	False
ms_report_car_line_sum_name	varchar	255	0	0	False		False	False
ms_report_car_line_sum_color	varchar	16	0	0	False		False	False
show_on_report	bit	1	1	0	False		False	False
order_column	int	4	10	0	False		False	False
code_sheet	varchar	10	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

Indexes

Key	Name	Columns	Unique	Type	Description
	IX_dt_ms_report_car_line_sum	ms_report_car_line_sum_name	True
	PK_dt_ms_report_car_line_sum	ms_report_car_line_sum_id	True

SQL Script

CREATE TABLE dbo.dt_ms_report_car_line_sum (
  ms_report_car_line_sum_id int IDENTITY,
  ms_report_car_line_sum_name varchar(255) NULL,
  ms_report_car_line_sum_color varchar(16) NULL,
  show_on_report bit NULL,
  order_column int NULL,
  code_sheet varchar(10) NULL,
  create_date datetime NULL,
  create_by int NULL,
  modify_date datetime NULL,
  modify_by int NULL,
  CONSTRAINT PK_dt_ms_report_car_line_sum PRIMARY KEY CLUSTERED (ms_report_car_line_sum_id),
  CONSTRAINT IX_dt_ms_report_car_line_sum UNIQUE (ms_report_car_line_sum_name)
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.dt_ms_report_car_line_sum