repair_action.sql

来自「POWERBUILDER+SQLSERVER数据库应用系统开发与实力源码 客户」· SQL 代码 · 共 28 行

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