賓館客房管理系統(tǒng)--數(shù)據(jù)庫課程設(shè)計(編輯修改稿)
2025-02-12 14:24 本頁面
【文章內(nèi)容簡介】 ocreate table roominfo /*創(chuàng)建數(shù)據(jù)表roominfo*/(rid char(6) not null, rstyle varchar(10), kfzt char(2) not null)gocreate table liveorder /*創(chuàng)建數(shù)據(jù)表liveorder*/(lno varchar(36) not null, rid char(6) not null, rstyle varchar(10), btime datetime not null, o char(10), ame varchar(10) not null, etime datetime, ono varchar(36), lzt char(4) )gocreate table bill /*創(chuàng)建數(shù)據(jù)表bill*/(bno varchar(36) not null, rid char(6) not null, ame varchar(10), cust money, btime datetime, etime datetime, remarks varchar(40)) gocreate table roomsp /*創(chuàng)建數(shù)據(jù)表roomsp*/(rstyle varchar(10) not null, rprice money)gocreate table hordform /*創(chuàng)建數(shù)據(jù)表hordform*/(ono varchar(36) not null, ame varchar(10) not null, csex char(2), cid char(18), rid char(6) not null, rstyle varchar(10), arrivetime datetime, o char(10) not null, dingname varchar(10), livetime char(10), dingph char(15) not null, ozt char(4))gocreate table hliveorder /*創(chuàng)建數(shù)據(jù)表hliveorder*/(lno varchar(36) not null, rid char(6) not null, rstyle varchar(10), btime datetime not null, o char(10), ame varchar(10) not null, etime datetime, ono varchar(36), lzt char(4) )goinsert into cusinfo values(39。mao39。,39。zcl39。,39。33022719880506007139。,39。n39。)insert into cusinfo values(39。qxb39。,39。zyy39。,39。33022719860307002239。,39。n39。)goinsert into roominfo values(39。201039。,39。s39。,39。n39。)insert into roominfo values(39。220139。,39。s39。,39。n39。)insert into roominfo values(39。230139。,39。s39。,39。n39。) insert into roominfo values(39。301039。,39。s39。,39。y39。) insert into roominfo values(39。301239。,39。s39。,39。n39。)insert into roominfo values(39。301539。,39。s39。,39。n39。)insert into roominfo values(39。421039。,39。d39。,39。n39。)insert into roominfo values(39。411039。,39。d39。,39。n39。)insert into roominfo values(39。401039。,39。d39。,39。n39。)insert into roominfo values(39。522039。,39。d39。,39。n39。)insert into roominfo values(39。521039。,39。d39。,39。n39。)insert into roominfo values(39。520139。,39。d39。,39。n39。)goinsert into roomsp values(39。s39。,200)insert into roomsp values(39。d3
黨政相關(guān)相關(guān)推薦
鄂ICP備17016276號-1