questionnaire.sql
上传用户:apbaoyuan
上传日期:2021-02-12
资源大小:1015k
文件大小:1k
- create table dbo.Questions (
- QuestionID int identity,
- Question varchar(500) not null,
- IsVisable int not null default 0,
- Date varchar(50) null,
- IsOpen int null default 1,
- constraint PK_QUESTIONS primary key clustered (QuestionID)
- )
- create table dbo.Items (
- ItemID int identity,
- QuestionID int not null,
- Item varchar(500) not null,
- ItemCount bigint not null default 0,
- constraint PK_ITEMS primary key clustered (ItemID)
- )
- create table dbo.Admins (
- Admname varchar(50) not null,
- Admpwd varchar(50) not null,
- constraint PK_ADMIN primary key clustered (Admname)
- )