【正文】 /長(zhǎng)度約束Order_item _id訂單項(xiàng)編號(hào)BigintPKflight_id航班編號(hào)Varchar(20)NNpassenger_id乘客編號(hào)IntNN FKcabin_class_id艙位編號(hào)intNN FKseats_order訂座序號(hào)intNNTicket_price機(jī)票價(jià)格doubleNNappend_tax1機(jī)場(chǎng)建設(shè)費(fèi)doubleNNappend_tax2燃油稅doubleNNotal_pricet總價(jià)double,NNorder_id所屬訂單編號(hào)BIGINT1機(jī)票表（ticket）表21：機(jī)票表字段名字段描述字段類(lèi)型約束條件ticket_id機(jī)票編號(hào) 毫秒BIGINTPKflight_num航班號(hào)varchar(10)NN FKroute_id 航線(xiàn)編號(hào)intNNdeparture_datetime起飛時(shí)間datetimeNNarrival_datatime到達(dá)時(shí)間datetimeNNpsg_name乘客姓名varchar(40)NNpsg_id_number乘客證件號(hào)碼varchar(40)NNcabin_class艙位等級(jí) 39。具體數(shù)據(jù)庫(kù)表結(jié)構(gòu)如下表：表3：數(shù)據(jù)庫(kù)表清單編號(hào)表名描述01Permission權(quán)限表02Role角色表03province省份表04City城市表05Branch營(yíng)業(yè)網(wǎng)點(diǎn)表06User用戶(hù)表07membership會(huì)員表08Passenger乘客表09Airport機(jī)場(chǎng)表10Route航線(xiàn)表11Cabin_Class艙位等級(jí)表12Plane_Model機(jī)型表13Flight_Schedule航班計(jì)劃表14Flight航班表15member_stage會(huì)員里程表16Ticket_Order機(jī)票訂單表17Order_item訂單項(xiàng)18Ticket機(jī)票表19Business_record營(yíng)業(yè)記錄表 數(shù)據(jù)庫(kù)表具體結(jié)構(gòu)權(quán)限表，描述合法用戶(hù)所具有的操作權(quán)限（permission）表4：權(quán)限表字段名字段描述類(lèi)型/長(zhǎng)度約束permission_id權(quán)限編號(hào)IntPKpermission_name權(quán)限名稱(chēng)Varchar（20）UN，NNpermission_code權(quán)限編碼IntUN，NNpermission_describe權(quán)限描述varchar(100)角色表，描述合法用戶(hù)的角色（role）表5：角色表字段名字段描述類(lèi)型/長(zhǎng)度約束role_id角色編號(hào)IntPKrole_name角色名稱(chēng)Varchar（20）UN，NNrole_permission_code權(quán)限編碼IntNNrole_describe角色描述Varchar(200)省份表（province）表6：省份表字段名字段描述類(lèi)型/長(zhǎng)度約束province_id省份編號(hào)IntPKprovince _name省份名稱(chēng)varchar（20）NN，UNprovince_simple_name省份簡(jiǎn)稱(chēng)varchar（10）NN ，UN province_spell_name省份拼音varchar（20）NN城市表（city）表7：城市表字段名字段描述類(lèi)型/長(zhǎng)度約束city_id城市編號(hào)IntPKcity _name城市名稱(chēng)varchar（20）NN UNprovince_id所屬省份IntFKcity_spell_name城市拼音varchar（20）NN網(wǎng)點(diǎn)表（Branch）表8：網(wǎng)點(diǎn)表字段名字段描述類(lèi)型/長(zhǎng)度約束branch_id網(wǎng)點(diǎn)編號(hào)intPKbranch_name網(wǎng)點(diǎn)名稱(chēng)varchar(200)NNprovince_id網(wǎng)點(diǎn)所屬省份intNN FKcity_id網(wǎng)點(diǎn)所在城市intFKbranch_telephon網(wǎng)點(diǎn)電話(huà)varchar(50)branch_faxfaxvarchar(20)branch_address網(wǎng)點(diǎn)地址varchar(200)branch_manager_id網(wǎng)點(diǎn)經(jīng)理編號(hào)intbranch_type網(wǎng)點(diǎn)類(lèi)型char(1)NNbranch_state網(wǎng)點(diǎn)狀態(tài)char(1)NN用戶(hù)表，描述本系統(tǒng)的合法用戶(hù)（user）表9：用戶(hù)表字段名字段描述類(lèi)型/長(zhǎng)度約束user_id用戶(hù)編號(hào)IntPKuser_login_name用戶(hù)帳號(hào)Varchar（20）UN，NNuser_password用戶(hù)密碼CHAR（32）user_name用戶(hù)真實(shí)姓名Varchar（20）NNuser_Permission_code用戶(hù)權(quán)限編碼IntNNuser_state用戶(hù)狀態(tài)Char(1)NNrole_name用戶(hù)角色名Varchar(20)FKuser_type用戶(hù)類(lèi)型Char(1)NNbranch_id用戶(hù)所屬營(yíng)業(yè)網(wǎng)點(diǎn)編號(hào)intFKuser_describe用戶(hù)描述Varchar(200)user_telephone用戶(hù)聯(lián)系電話(huà)Varchar(20)user_address用戶(hù)地址Varchar(200)user_zip用戶(hù)郵編Varchar(20)user_用戶(hù)郵箱Varchar(100)user_creation_date用戶(hù)創(chuàng)建時(shí)間DatetimeNNuser_last_login_Date最后一次登錄時(shí)間DatetimeNNuser_total_login_times累計(jì)登錄次數(shù)IntNNuser_total_login_seconds累計(jì)登錄時(shí)長(zhǎng)intNNref_pags_id關(guān)聯(lián)乘客IDVarchar(200)ref_mebe_id關(guān)聯(lián)會(huì)員編號(hào)IDInt會(huì)員表（membership）表10：會(huì)員表字段名字段描述類(lèi)型/長(zhǎng)度約束memb_id會(huì)員編號(hào)IntPKmemb_card_num會(huì)員卡號(hào)varchar（20）UN，NNmemb_password會(huì)員密碼char(32)memb_lastname_ch會(huì)員姓（中文）varchar（20）NNmemb_firstname_ch會(huì)員名（中文）varchar（20）NNmemb_lastname_sp會(huì)員姓（拼音）varchar（20）NNmemb_firstname_sp會(huì)員名（拼音）varchar（20）NNmemb_gender會(huì)員性別Char(1)NNmemb_birthday會(huì)員生日DateNNmemb_certif_type證件類(lèi)型varchar（20）NNmemb_ certif_num證件號(hào)碼varchar（40）NNmemb_telephone1會(huì)員移動(dòng)電話(huà)varchar（20）memb_telephone2 會(huì)員固定電話(huà)varchar（20）memb_address會(huì)員地址Varchar(100)NNprovince_id會(huì)員省份IntNN，F(xiàn)Kcity_id會(huì)員城市IntNN，F(xiàn)Kmemb_zip會(huì)員郵編Varchar(20)memb_reg_date會(huì)員注冊(cè)日期DateNNmemb_會(huì)員郵箱varchar(100)NNmemb_rank會(huì)員等級(jí)varchar(10）memb_account_stage會(huì)員累計(jì)航段Intmemb_account_mileage會(huì)員累計(jì)里程Intmemb_flight_mileage會(huì)員航段里程Intmemb_available_stage當(dāng)前有效航段Intmemb_available_mileage當(dāng)前有效里程Intmemb_invalidation_stage至本年底前過(guò)期航段Intmemb_invalidation_mileage至本年底前過(guò)期里程Doublememb_award_mileage會(huì)員獎(jiǎng)勵(lì)里程Intmemb_partner_mileage會(huì)員合作伙伴里程Intmemb_consume_mileage會(huì)員消費(fèi)里程Intmemb_promotion_mileage會(huì)員促銷(xiāo)里程Int乘客表（passenger）表11：乘客表字段名字段描述類(lèi)型/長(zhǎng)度約束psg_id乘客編號(hào)IntPKpsg_name乘客姓名varchar（20）NNpsg_certif_type乘客證件類(lèi)型varchar（20）NN psg_ certif_num乘客證件號(hào)碼varchar（40）NNpsg_telephone1乘客電話(huà)varchar（20）memb_id關(guān)聯(lián)會(huì)員編號(hào)FK機(jī)場(chǎng)表(airport)表12：機(jī)場(chǎng)表字段名字段描述類(lèi)型/長(zhǎng)度約束airport_id機(jī)場(chǎng)編號(hào)IntPKairport_name機(jī)場(chǎng)名稱(chēng)varchar(20)province_id機(jī)場(chǎng)省份IntFKcity_id機(jī)場(chǎng)城市intFKairport_full_name機(jī)場(chǎng)全名varchar(20)NNairport_code機(jī)場(chǎng)代碼(三字碼)char（3）NN UNdeparture_routes_num出發(fā)航線(xiàn)條數(shù)Intarrival_routes_num到達(dá)航線(xiàn)條數(shù)Intairport_grand機(jī)場(chǎng)等級(jí)char(2)departure_flight_num_per_week每周離港航班數(shù)Intarrival_flight_num_per_week每周到港航班數(shù)Int航線(xiàn)表，用來(lái)描述兩個(gè)機(jī)場(chǎng)間的一條直達(dá)通航航線(xiàn)（Route）表13：航線(xiàn)表字段名字段描述類(lèi)型/長(zhǎng)度約束route_id航線(xiàn)編號(hào)Int