【正文】
int not null, CCount int not null, CName nvarchar(20) not null, DID int not null, constraint PK_SCLASS primary key (CID))/*==============================================================*//* : S_StuInfo *//*==============================================================*/create table S_StuInfo ( SName nvarchar(20) not null, CID int not null, Sno varchar(20) not null, SCardID varchar(20) not null, SBirth smalldatetime null, SAddress nvarchar(50) null, SMembership nvarchar(10) not null, SState nchar(10) not null, SClassID int null, SIsReg bit null, SIsSkip int null, SAward ntext null, SCost bit null, SPwd nvarchar(50) null, constraint PK_S_STUINFO primary key (Sno))/*==============================================================*//* : Teacher *//*==============================================================*/create table Teacher ( TID int not null, TName nvarchar(20) null, TPost varchar(20) null, TDep int null, constraint PK_TEACHER primary key (TID))/*==============================================================*//* : Parents *//*==============================================================*/create table Parents(Sno varchar(20) not null,ParentsName varchar(20) not null