【正文】 values(39。G2010072239。,39。王敏39。, 39。F39。,39。南昌市八一大道88號(hào)39。,39。1520720513439。,
39。36103419900328279139。)insert guide values(39。G2011052339。,39。李志強(qiáng)39。,39。M39。, 39。南昌市陽明路63號(hào)39。, 39。1336710524339。,
39。36102219870328128939。)go/*線路信息表*/print 39。create line39。gocreate table line( lineNo1 char(9) not null primary key /*路線編號(hào)*/ check(lineNo1 like 39。[L][AZ][AZ][09][09][09][09][09][09]39。), startime varchar(40) default39。每天39。 null, /*出發(fā)時(shí)間*/ start varchar(40) not null, /*出發(fā)地*/ distination varchar(40) not null, /*目的地*/ )go/*線路（line）數(shù)據(jù)：*/insert line values(39。LNB00000139。,39。每天39。,39。南昌39。,39。北京39。)insert line values(39。LNS00000239。,39。每天39。,39。南昌39。,39。上海39。)insert line values(39。LNF00000339。,39。每天39。,39。南昌39。,39。福州39。)insert line values(39。LNT00000439。,39。每天39。,39。南昌39。,39。天津39。)insert line values(39。LNH00000539。,39。每天39。,39。南昌39。,39。海南39。)insert line values(39。LSB00000639。,39。每天39。,39。上海39。,39。北京39。)insert line values(39。LSF00000739。,39。每天39。,39。上海39。,39。福州39。)insert line values(39。LSD00000839。,39。每天39。,39。上海39。,39。大理39。)insert line values(39。LBS00000939。,39。每天39。,39。北京39。,39。上海39。)go/*景點(diǎn)信息表*/print 39。create scenery39。gocreate table scenery( sceNo char(9) not null primary key, /*景點(diǎn)編號(hào)*/ check(sceNo like 39。[S][09][09][09][09][09][09][09][09]39。), scename varchar(20) not null, /*景點(diǎn)名稱*/ bushours char(20) not null, /*營(yíng)業(yè)時(shí)間*/ ticketprice int null, /*票價(jià)*/ discount varchar(40) null , /*優(yōu)惠措施*/ attention varchar(40) null /*注意事項(xiàng)*/ )go/*景點(diǎn)（scenery ）數(shù)據(jù)：*/ insert scenery values(39。S0000000139。,39。故宮39。,39。8點(diǎn)到22點(diǎn)39。,50,39。憑學(xué)生證享受半價(jià)優(yōu)惠，10歲以下兒童免費(fèi)39。,39。保持景點(diǎn)衛(wèi)生,不能故意毀壞景點(diǎn)設(shè)施39。)insert scenery values(39。S0000000239。,39。天安門39。,39。8點(diǎn)到22點(diǎn)39。, 0,null, 39。保持景點(diǎn)衛(wèi)生，不能故意毀壞景點(diǎn)設(shè)施39。)insert scenery values(39。S0000000339。,39。長(zhǎng)城39。, 39。8點(diǎn)到22點(diǎn)39。, 0,null, 39。不要在城墻上亂寫亂畫39。)insert scenery values(39。S0000000439。,39。廈門大學(xué)39。,39。8點(diǎn)到22點(diǎn)39。, 0,null, 39。不要亂扔垃圾39。)insert scenery values(39。S0000000539。,39。大小洞天39。,39。8點(diǎn)到22點(diǎn)39。, 100,39。憑學(xué)生證享受半價(jià)優(yōu)惠，10歲以下兒童免費(fèi)39。, 39。不要亂扔垃圾39。)insert scenery values(39。S0000000639。,39。大東海39。,39。8點(diǎn)到22點(diǎn)39。, 100,39。憑學(xué)生證享受半價(jià)優(yōu)惠，10歲
以下兒童免費(fèi)39。,39。不要亂扔垃圾39。)go/*線路方案表*/print 39。create lineProject39。gocreate table lineProject( PNo char(3) not null primary key, /*線路方案編號(hào)*/ check(PNo like 39。[09][09][09]39。), lineNo1 char(9) not null , /*線路編號(hào)*/ PName varchar(20) not null, /*方案類型名稱*/ Pprice int not null, /* 價(jià)格*/ vehicle Varchar(10) null, /*交通方式*/ quantity int default39。3039。 not null /*總票數(shù)*/ constraint lineProjectFK1 foreign key(lineNo1) references line(lineNo1))go/*線路方案（lineProject）數(shù)據(jù)：*/ insert lineProject values(39。00139。,39。LNB00000139。,39。豪華團(tuán)39。,6000,39。雙飛39。,30)insert lineProject values(39。00239。,39。LNB00000139。,39。經(jīng)濟(jì)團(tuán)39。,3000,39。汽車大巴39。,30)insert lineProject values(39。00339。,39。LSF00000739。,39。經(jīng)濟(jì)團(tuán)39。,3000,39。汽車大巴39。,30)insert lineProject values(39。00439。,39。LNT000004 39。,39。軟臥標(biāo)準(zhǔn)團(tuán)39。,2500,39?；疖?9。,30)insert lineProject values(39。00539。,39。LNH00000539。,39。硬座標(biāo)準(zhǔn)團(tuán)39。,500,39。火車39。,30)insert lineProject values(39。00639。,39。LBS00000939。,39。硬臥標(biāo)準(zhǔn)團(tuán)39。,1000,39?；疖?9。,30)insert lineProject values(39。00739。,39。LNS00000239。,39。豪華團(tuán)39。,3800,39。雙飛39。,30)go/*預(yù)訂主表*/print 39。create orderMaster39。gocreate table orderMaster( orderNo char(9) not null primary key,/*預(yù)訂編號(hào)*/ check(orderNo like 39。[O][09][09][09][09][09][09][09][09]39。), lineNo1 char(9) not null, /*線路編號(hào)*/ PNo char(3) not null, /*方案編號(hào)*/ orderDate datetime not null, /*預(yù)訂日期*/ startDate datetime not null, /*出發(fā)日期*/ constraint orderMasterFK1 foreign key(lineNo1) references line(lineNo1), constraint orderMasterFK2 foreign key(PNo) references lineproject(PNo) )go/*預(yù)訂主表（ordermaster）數(shù)據(jù)：*/insert orderMaster values(39。O0000000139。,39。LNB00000139。,39。00139。,39。2011072039。,39。2011072539。)insert orderMaster values(39。O0000000239。,39。LNB00000139。,39。00239。,39。2011072139。,39。2011072539。) insert orderMaster values(39。O0000000339。,39。LSF00000739。,39。00339。,39。2011073039。,39。2011080139。) insert orderMaster values(39。O0000000439。,39。LNH00000539。,39。00539。,39。2011080139。,39。2011080239。)go/*預(yù)訂明細(xì)表*/print 39。create orderdetail39。gocreate table orderdetail( orderNo char(9) not null primary key,/*預(yù)訂編號(hào)*/ check(orderNo like 39。[O][09][09][09][09][09][09][09][09]39。), pasNo char(9) not null, /*旅客編號(hào)*/ price int not null, /*單價(jià)*/ constraint orderdetailFK foreign key(pasNo) references passenger(pasNo), ) go/*預(yù)訂明細(xì)表（orderdetail）數(shù)據(jù)：*/insert orderdetail values(39。O0000000139。,39。P2011071039。,3000)insert orderdetail values(39。O0000000239。,39。P2011072039。,6000) insert orderdetail values(39。O0000000339。,39。P2011072139。,800)insert orderdetail values(39。O0000000439。,39。P2011072239。,2500) go/*出行主表*/print 39。create travelMaster39。gocreate table travelMaster( traNo char(9) not null primary key,/*出行編號(hào)*/ check(traNo li