基于數(shù)據(jù)庫的酒店管理系統(tǒng)課程設計-全文預覽
【正文】 customer ( Cname char(25) null, Csex char(12) null, Cid char(20) not null, Cphone char(12) null, constraint PK_CUSTOMER primary key nonclustered (Cid))go/*=========================================================*//* Table: customer2 *//*=========================================================*/create table customer2 ( Cname char(25) null, Csex char(12) null, Cid2 char(20) not null, Cphone char(12) null, constraint PK_CUSTOMER2 primary key nonclustered (Cid2))go/*=========================================================*//* Table: reserve *//*=======================================================*/create table reserve ( Cid char(20) not null, Rnum char(10) not null, Ctime datetime null, Cdays char(4) null, Csftd char(4) null, constraint PK_RESERVE primary key (Cid, Rnum))go/*=========================================================*//* Table: restaurant *//*=========================================================*/create table restaurant ( Astyle char(20) null, Aposition char(30) null, Ataste char(12) null, Aname char(15) not null, constraint PK_RESTAURANT primary key nonclustered (Aname))go/*=========================================================*//* Table: room *//*=========================================================*/create table room ( Rstyle char(80) null, Rzt char(20) null, Rposition char(30) null, Rnum char(10) not null, Rprice numeric(20) null, constraint PK_ROOM primary key nonclustered (Rnum))go/*=========================================================*//* Table: staff *//*=========================================================*/create table staff ( Sname char(8)
環(huán)評公示相關推薦
鄂ICP備17016276號-1