【正文】 Y KEY(PASSAGER_ID,TICKET_ID),CONSTRAINT FK_BUY_PASSAGER_ID FOREIGN KEY(PASSAGER_ID) references PASSAGER(PASSAGER_ID),CONSTRAINT FK_BUY_TICKET_ID FOREIGN KEY(TICKET_ID) references TICKET(TICKET_ID),)。ALTER TABLE BUY_TICKETSADDCONSTRAINT CK_REAL_PAY CHECK(REAL_PAY=0)ALTER TABLE BUY_TICKETSADDCONSTRAINT CK_BUY_TICKETS_LEN CHECK(LEN(PASSAGER_ID)=18)CREATE TABLE REFUND退票表(REFUND_TIME VARCHAR(50),退票時(shí)間PASSAGER_ID VARCHAR(50),旅客身份證號TICKET_ID INT IDENTITY(1,1) NOT NULL,機(jī)票編號CONSTRAINT PK_退旅客機(jī)票 PRIMARY KEY(PASSAGER_ID,TICKET_ID),CONSTRAINT FK_REFUND_PASSAGER_ID FOREIGN KEY(PASSAGER_ID) references PASSAGER(PASSAGER_ID),CONSTRAINT FK_REFUND_TICKET_ID FOREIGN KEY(TICKET_ID) references TICKET(TICKET_ID),)。ALTER TABLE REFUNDADDCONSTRAINT CK_REFND_LEN CHECK(LEN(PASSAGER_ID)=18)CREATE TABLE SELL_TICKETS 售票表(SELL_TIME VARCHAR(50) NOT NULL,賣票時(shí)間TICKET_SUM VARCHAR(50) NOT NULL,收益金額EmployeeNumber VARCHAR(50) NOT NULL,員工號TICKET_ID INT IDENTITY(1,1),機(jī)票編號CONSTRAINT PK_員工機(jī)票 PRIMARY KEY(EmployeeNumber,TICKET_ID),CONSTRAINT FK_SELL_TICKETS_EmployeeNumber FOREIGN KEY(EmployeeNumber)references Clerk(EmployeeNumber),CONSTRAINT FK_SELL_TICKETS_TICKET_ID FOREIGN KEY(TICKET_ID) references TICKET(TICKET_ID),)。ALTER TABLE SELL_TICKETSADDCONSTRAINT CK_TICKET_SUM CHECK(TICKET_SUM=0)INSERT INTO PASSAGERVALUES(39。安靜39。,39。15040319950918000039。,39。1576493548039。,39。女39。,39。老王39。,39。1351476548039。), (39。陳子燁39。,39。15040319930412000139。,39。1576493548139。,39。女39。,39。老陳39。,39。1351476548139。), (39。李文超39。,39。15040319941212000239。,39。1576493548239。,39。女39。,39。老李39。,39。1351476548239。), (39。梁雪松39。,39。15040319941029000339。,39。1576493548339。,39。女39。,39。老梁39。,39。1351476548339。), (39。梁英超39。,39。15040319941030000439。,39。1576493548339。,39。男39。,39。小梁39。,39。1351476548439。), (39。李文博39。,39。15040319940929000539。,39。1576493548339。,39。男39。,39。小李39。,39。1351476548539。), (39。安娜39。,39。15040319941020000639。,39。1576493548339。,39。女39。,39。小王39。,39。1351476548639。) INSERT INTO CAMPANYVALUES(39。公司39。,39。天津航空39。,39。1234567890139。,39。天津39。) INSERT INTO TICKETVALUES(39。航班39。,39。頭等艙39。,39。139。,39。100039。,39。已售39。), (39。航班39。,39。頭等艙39。,39。239。,39。100039。,39。NULL39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。339。,39。50039。,39。已售39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。439。,39。50039。,39。已售39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。539。,39。50039。,39。已售39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。639。,39。50039。,39。已售39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。739。,39。50039。,39。已售39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。839。,39。50039。,39。NULL39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。939。,39。50039。,39。NULL39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。1039。,39。50039。,39。已售39。), (39。航班39。,39。頭等艙39。,39。139。,39。90039。,39。已售39。), (39。航班39。,39。頭等艙39。,39。239。,39。90039。,39。已售39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。339。,39。40039。,39。NULL39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。439。,39。40039。,39。已售39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。539。,39。40039。,39。已售39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。639。,39。40039。,39。NULL39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。739。,39。40039。,39。已售39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。839。,39。40039。,39。已售39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。939。,39。40039。,39。已售39。), (39。航班39。,39。經(jīng)濟(jì)艙39。,39。039。,39。40039。,39。NULL39。)INSERT INTO FIGHTVALUES(39。航班39。,39。呼市39。,39。赤峰39。,39。19：39。,39。20：39。,39。公司39。,39。1039。), (39。航班39。,39。呼市39。,39。赤峰39。,39。9：39。,39。10：39。,39。公司39。,39。1039。) INSERT INTO CrewVALUES(39。乘務(wù)員39。,39。航班39。,39。沉魚39。,39。女39。,39。199592039。,39。1352488125439。,39。公司39。), (39。乘務(wù)員39。,39。航班39。,39。落雁39。,39。女39。,39。1995101039。,39。1352488125539。,39。公司39。), (39。乘務(wù)員39。,39。航班39。,39。閉月39。,39。女39。,39。199592039。,39。1352477125639。,39。公司39。), (39。乘務(wù)員39。,39。航班39。,39。羞花39。,39。女39。,39。199592039。,39。1352588125739。,39。公司39。)INSERT INTO ClerkVALUES(39。售票員39。,39。公司39。,39。才高39。,39。男39。,39。19951139。,39。13524