创建表

--create database Book

--use Book

----创建表

--create table book

--(

-- isbn int,

-- title nvarchar,

-- autnor nvarchar,

-- price float,

-- pubdate datetime,

-- isabord bit,

-- cover image

--)

--go

--drop database Book

---drop database Myschool

create table category

(

categoryId int not null primary key identity(1,1),

categoryname nvarchar(50) not null unique

--unique,主键，不允许重复，唯一

--primary key 自增长

)

create database Student

create table book

(

bookId int not null primary key identity(1,1),

title nvarchar(50) not null,

pubdate datetime default(getdate()),--发布时间，默认值，getdate(),当前时间

bookState bit check (bookState='true' or bookState='false'),--bool,check约束

categoryid int foreign key references category(categoryId)--外键约束

)

create table grade

(

gradeid int not null primary key identity(1,1),

gradename nvarchar(50) not null unique,

gradestate bit default('true')

)

create table students

(

studentid int not null primary key identity(1,1),

studentname nvarchar(50) not null unique,

studentgender bit check (studentgender='true' or studentgender='false') default ('true'),

studentbirthday int foreign key references grade(gradeid)

)

create table Result

(

studentId int,

Scoreid int,

value float,

constraint Pk_stuidscoid primary key clustered(studentId,Scoreid)--联合主键

)

create table Score

(

Scoreid int not null primary key identity(1,1),

scorename nvarchar(50) not null unique,

gradeid int foreign key references grade(gradeid)

)