DB_51aspx/数据库文档/火车售票管理系统.txt

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

create table Operators 
(OPERID varchar(50) primary key not null, 
OPERNAME varchar(50) not null, 
OPERIMG varchar(50) not null,
    PSW varchar(50) not null, //密码 
DOTSCODE varchar(50) not null, 
ROLECODE varchar(50) not null,
DESCRIPT varchar(50)  null,
foreign key (DOTSCODE) references TicketDots(DOTSCODE) on delete cascade,
foreign key (ROLECODE) references Role(ROLECODE) on delete cascade

);
create table Role
(ROLECODE varchar(50) primary key not null,
 ROLENAME varchar(50) not null,
 DESCRIPT varchar(50) not null
);

create table TicketDots
(DOTSCODE varchar(50) primary key not null,
 DOTSNAME varchar(50) not null,
 DOTSCALL varchar(50) not null,
 DESCRIPT varchar(50) not null
);
create table TicketType
(TTCODE varchar(50) primary key not null,
 TTNAME varchar(50) not null,
 TLENGTH varchar(50) not null,
 DESCRIPT varchar(50)  null
);
 create table TicketMain
(
 RKTCODE varchar(50) primary key not null,
 TTCODE varchar(50) not null,
 QZ varchar(50) not null,
 STARTCODE varchar(50) not null,
 TicketNUM int not null,
 ENDCODE varchar(50) not null,
 DOTSCODE varchar(50) not null,
 TRAINCODE varchar(50) not null,
 SSTATION varchar(50) not null,
 ASTATION varchar(50) not null,
 STIME    datetime not null,
 ATIME    datetime not null,
 PPRICE   decimal  not null,
 TPRICE   decimal not null,
 STAUS varchar(50) not null,
 RKTIME datetime not null,
 FFTIME datetime not null,
 TPTIME datetime not null,
 SELLTIME datetime not null,
 DESCRIPT varchar(50)  null,
foreign key (DOTSCODE) references TicketDots(DOTSCODE),
foreign key (TTCODE) references TicketType(TTCODE),
foreign key (TRAINCODE) references TrainNum(TRAINCODE)
);

create table TrainNum
(
  TRAINCODE varchar(50) primary key not null,