【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,complain.sql,希望对大家有所帮助!
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