數(shù)據(jù)庫設(shè)計說明書(新)-資料下載頁
2025-08-04 00:08本頁面
【正文】 )預(yù)定：create table Rserve(RNO int,Rtime datetime default getdate(),rRmark char(8) default 39。沒有入住39。,Ltime int default 1 check(Ltime 0),RID char(8) not null foreign key references room(RID) unique,primary key(rid))入?。篶reate table LiveIn(cID char(21) not null foreign key references client(cid),Ltimes int default 1,Lwhile datetime default getdate(),Rid char(8) primary key foreign key references room(rid))前臺：create table Sever(SNO char(8) primary key,SPassword char(6) not null,Spost char(8),Sname char(6))房間：create table Room(RID char(8) primary key,Rstate char(6) default 39。否39。,Rprice money not null, Rtell char(12),Ctype char(8) not null) 視圖的創(chuàng)建SELECT , , , , FROM INNER JOIN ON = INNER JOIN ON = 觸發(fā)器的創(chuàng)建 存儲過程的創(chuàng)建 其他內(nèi)容的創(chuàng)建 12
黨政相關(guān)相關(guān)推薦
鄂ICP備17016276號-1