complain.sql

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

CREATE TABLE [dbo].[complain] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[code] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[media] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
	[cid] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[radate] [datetime] NULL ,
	[fb_sl] [numeric](18, 0) NULL ,
	[fbdate] [datetime] NULL ,
	[comptype] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[description] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[fbdesc] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[status] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[satisfactory] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pmodel] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO