-- T_WORKINFO_TEMPLATE 工作信息模板
IF OBJECT_ID(
'T_WORKINFO_TEMPLATE'
)
IS
NOT
NULL
DROP
TABLE
T_WORKINFO_TEMPLATE
GO
CREATE
TABLE
T_WORKINFO_TEMPLATE
(
WORKINFO_TEMPLATE_ID
CHAR
(36)
PRIMARY
KEY
,
-- 主键
COMPONENTREFERENCE
VARCHAR
(400),
-- 相关设备
ITEMNAME
VARCHAR
(200),
--
ITEMCONTENT
VARCHAR
(2000),
-- 保养内容
PERIOD
NUMERIC
(9,2),
-- 预检周期
PERIODICAL
VARCHAR
(10),
-- 周期的单位,数据取T_PERIODICAL
REMARK
VARCHAR
(4000),
-- 备注
CLASS
VARCHAR
(20)
-- 类别
)
ON
[
PRIMARY
]
GO
exec
sp_addextendedproperty N
'MS_Description'
, N
'主键'
, N
'user'
, N
'dbo'
, N
'table'
, N
'T_WORKINFO_TEMPLATE'
, N
'column'
, N
'WORKINFO_TEMPLATE_ID'
exec
sp_addextendedproperty N
'MS_Description'
, N
'相关设备'
, N
'user'
, N
'dbo'
, N
'table'
, N
'T_WORKINFO_TEMPLATE'
, N
'column'
, N
'COMPONENTREFERENCE'
exec
sp_addextendedproperty N
'MS_Description'
, N
'保养项目'
, N
'user'
, N
'dbo'
, N
'table'
, N
'T_WORKINFO_TEMPLATE'
, N
'column'
, N
'ITEMNAME'
exec
sp_addextendedproperty N
'MS_Description'
, N
'保养内容'
, N
'user'
, N
'dbo'
, N
'table'
, N
'T_WORKINFO_TEMPLATE'
, N
'column'
, N
'ITEMCONTENT'
exec
sp_addextendedproperty N
'MS_Description'
, N
'预检周期'
, N
'user'
, N
'dbo'
, N
'table'
, N
'T_WORKINFO_TEMPLATE'
, N
'column'
, N
'PERIOD'
exec
sp_addextendedproperty N
'MS_Description'
, N
'周期的单位,数据取T_PERIODICAL'
, N
'user'
, N
'dbo'
, N
'table'
, N
'T_WORKINFO_TEMPLATE'
, N
'column'
, N
'PERIODICAL'
exec
sp_addextendedproperty N
'MS_Description'
, N
'备注'
, N
'user'
, N
'dbo'
, N
'table'
, N
'T_WORKINFO_TEMPLATE'
, N
'column'
, N
'REMARK'
GO
摘自:http://bbs.csdn.net/topics/340184487