【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了repair_action.sql相关资料,希望对各位网友有所帮助!
CREATE TABLE [dbo].[repair_action] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[code] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[src] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[dutybr] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[reportdate] [datetime] NULL ,
[repairdate] [datetime] NULL ,
[cb_sl] [numeric](18, 0) NULL ,
[rp_sl] [numeric](18, 0) NULL ,
[rmethod] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[servicetype] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[chgtype] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[transmethod] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[transfee] [decimal](18, 2) NULL ,
[ctransfee] [decimal](18, 2) NULL ,
[comfee] [decimal](18, 2) NULL ,
[reportfault] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[realfault] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[faulttype] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[status] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[cbdate] [datetime] NULL ,
[comment] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[satifactory] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[cid] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[pmodel] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO