//自增加主键
create table PLUS_SMS
(
s_id int IDENTITY(1,1) Primary Key,
beginTime DateTime not null,
endTime DateTime not null,
senderCode varchar(20) not null,
cpCode varchar(20) not null,
content varchar(500) not null,
isGot bit not null
)
//另一种自增加主键
create table PLUS_SMS
(
s_id int IDENTITY(1,1),
beginTime DateTime not null,
endTime DateTime not null,
senderCode varchar(20) not null,
cpCode varchar(20) not null,
content varchar(500) not null,
isGot bit not null,
constraint pk_plus_sms primary key(userId)
)
//双主键
CREATE TABLE CommonCode_table
(
codeType varchar(20) not null, /*代码类型*/
codeName varchar(20) not null, /*代码名称*/
codeValue varchar(100) not null, /*代码值*/
constraint pk_commoncode primary key(codeType, codeName)
)
//外键1
create table PLUS_NUMBER
(
n_id int identity(1,1),
number varchar(20) not null,
s_id int not null,
constraint pk_plus_number primary key(n_id),
constraint fk_plus_sid foreign key(s_id)
references PLUS_SMS(s_id)
)
//外键2
create table PLUS_NUMBER
(
n_id int identity(1,1) Primary Key,
number varchar(20) not null,
s_id int not null foreign key references PLUS_SMS(s_id),
)
//CHECK约束
create table Users
(
UserID varchar(15) not null Primary Key, //主键
UserPassword varchar(30) not null, //varchar与char相比,char不满时会用空格填充,varchar则不会
Role varchar(25) not null constraint checkrole CHECK (Role in ('Saler', 'Administrator','SuperAdministrator'))
//CHECK约束
)