freepeople性欧美熟妇, 色戒完整版无删减158分钟hd, 无码精品国产vα在线观看DVD, 丰满少妇伦精品无码专区在线观看,艾栗栗与纹身男宾馆3p50分钟,国产AV片在线观看,黑人与美女高潮,18岁女RAPPERDISSSUBS,国产手机在机看影片

正文內(nèi)容

基于android手機(jī)平臺(tái)的3g航空訂票系統(tǒng)(編輯修改稿)

2024-07-19 18:10 本頁面
 

【文章內(nèi)容簡(jiǎn)介】 N網(wǎng)點(diǎn)表(Branch)表8:網(wǎng)點(diǎn)表字段名字段描述類型/長度約束branch_id網(wǎng)點(diǎn)編號(hào)intPKbranch_name網(wǎng)點(diǎn)名稱varchar(200)NNprovince_id網(wǎng)點(diǎn)所屬省份intNN FKcity_id網(wǎng)點(diǎn)所在城市intFKbranch_telephon網(wǎng)點(diǎn)電話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)類型char(1)NNbranch_state網(wǎng)點(diǎn)狀態(tài)char(1)NN用戶表,描述本系統(tǒng)的合法用戶(user)表9:用戶表字段名字段描述類型/長度約束user_id用戶編號(hào)IntPKuser_login_name用戶帳號(hào)Varchar(20)UN,NNuser_password用戶密碼CHAR(32)user_name用戶真實(shí)姓名Varchar(20)NNuser_Permission_code用戶權(quán)限編碼IntNNuser_state用戶狀態(tài)Char(1)NNrole_name用戶角色名Varchar(20)FKuser_type用戶類型Char(1)NNbranch_id用戶所屬營業(yè)網(wǎng)點(diǎn)編號(hào)intFKuser_describe用戶描述Varchar(200)user_telephone用戶聯(lián)系電話Varchar(20)user_address用戶地址Varchar(200)user_zip用戶郵編Varchar(20)user_用戶郵箱Varchar(100)user_creation_date用戶創(chuàng)建時(shí)間DatetimeNNuser_last_login_Date最后一次登錄時(shí)間DatetimeNNuser_total_login_times累計(jì)登錄次數(shù)IntNNuser_total_login_seconds累計(jì)登錄時(shí)長intNNref_pags_id關(guān)聯(lián)乘客IDVarchar(200)ref_mebe_id關(guān)聯(lián)會(huì)員編號(hào)IDInt會(huì)員表(membership)表10:會(huì)員表字段名字段描述類型/長度約束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證件類型varchar(20)NNmemb_ certif_num證件號(hào)碼varchar(40)NNmemb_telephone1會(huì)員移動(dòng)電話varchar(20)memb_telephone2 會(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至本年底前過期航段Intmemb_invalidation_mileage至本年底前過期里程Doublememb_award_mileage會(huì)員獎(jiǎng)勵(lì)里程Intmemb_partner_mileage會(huì)員合作伙伴里程Intmemb_consume_mileage會(huì)員消費(fèi)里程Intmemb_promotion_mileage會(huì)員促銷里程Int乘客表(passenger)表11:乘客表字段名字段描述類型/長度約束psg_id乘客編號(hào)IntPKpsg_name乘客姓名varchar(20)NNpsg_certif_type乘客證件類型varchar(20)NN psg_ certif_num乘客證件號(hào)碼varchar(40)NNpsg_telephone1乘客電話varchar(20)memb_id關(guān)聯(lián)會(huì)員編號(hào)FK機(jī)場(chǎng)表(airport)表12:機(jī)場(chǎng)表字段名字段描述類型/長度約束airport_id機(jī)場(chǎng)編號(hào)IntPKairport_name機(jī)場(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ā)航線條數(shù)Intarrival_routes_num到達(dá)航線條數(shù)Intairport_grand機(jī)場(chǎng)等級(jí)char(2)departure_flight_num_per_week每周離港航班數(shù)Intarrival_flight_num_per_week每周到港航班數(shù)Int航線表,用來描述兩個(gè)機(jī)場(chǎng)間的一條直達(dá)通航航線(Route)表13:航線表字段名字段描述類型/長度約束route_id航線編號(hào)IntPKfrom_airport_id航線出發(fā)機(jī)場(chǎng)intFK UNto_airport_id航線到達(dá)機(jī)場(chǎng)IntFK UNroute_distance航線距離IntNNroute_base_price航線基準(zhǔn)價(jià)格=航線距離*doublereturn_route_id返程航線編號(hào)intflight_num_per_week該航線每周航班數(shù)Int1艙位等級(jí)表(cabin_class)表14:艙位等級(jí)表字段名字段描述字段類型約束條件cabin_class_id艙位等級(jí)編號(hào)intPK ,AUTO_INCREMENTcabin_class_name艙位等級(jí)名稱varchar(40)NN 、UNcabin_class_char艙位等級(jí)字符39。Y39。,X39。,B39。,39。F39。,39。C39。,char(1)NN 、UNrefund_charge退票手續(xù)費(fèi)規(guī)定double NNlimit_condition限制條件‘TGZ’ 代表:可退,可改期,可簽轉(zhuǎn)char(3)NNcabin_discount艙位折扣doubleNNcabin_class_type艙位類型:39。F39。,39。C39。,39。Y39。char(1)NNmileage_factor里程積累系數(shù)doubleNN1飛機(jī)表(plane)表15:飛機(jī)表字段名字段描述字段類型約束條件PlaneId飛機(jī)編號(hào)IntPK AUTO_INCREMENTnum,飛機(jī)機(jī)身編號(hào)Varchar(10)NN 、UNModel飛機(jī)機(jī)型Varchar(40)NNManufacturer飛機(jī)制造廠商Varchar(40)Continue_voyage最大續(xù)航里程Intf_cabin_sets頭等艙座位數(shù)IntNNb_cabin_sets公務(wù)艙座位數(shù)IntNNe_cabin_sets經(jīng)濟(jì)艙座位數(shù)IntNNSeats_set_pic座位布圖片位置Varchar(200)1航班計(jì)劃表(Flight_Plan)表16:航班計(jì)劃表字段名字段描述類型/長度約束fp_id航班計(jì)劃編號(hào)intPKflight_num航班編號(hào)varchar(10)NN UNfp_start_date航班計(jì)劃開始日期dateNNfp_end_date航班計(jì)劃結(jié)束日期dateNNroute_id執(zhí)行航線編號(hào)IntFKfp_departure_time起飛時(shí)刻varchar(10)NNfp_arrival_time到達(dá)時(shí)刻varchar(10)NNfp_scheduler航班班期IntNNfp_base_price航班基準(zhǔn)票價(jià), 在航線基準(zhǔn)票價(jià)基礎(chǔ)上上下25%浮動(dòng)doubleNN1航班表 (flight)表17:航班表字段名字段描述字段類型約束條件flight_id航班編號(hào)varchar(20)PKflight_num航班號(hào)varchar(10)NNfl_departure_date航班起飛時(shí)間datetimeNNfl_arrival_date航班到達(dá)時(shí)間datetimeNNroute_id執(zhí)行航線編號(hào)intFKplane_id執(zhí)行飛機(jī)編號(hào)intFKf_seats_remain頭等艙剩余座位數(shù)intNNb_seats_remain公務(wù)艙剩余座位intNNe_seats_remain經(jīng)濟(jì)艙剩余座位intNNcurrent_classes當(dāng)前可選艙位代碼:39。F,Y,B,C,Q,U39。varchar(60)NNcurrent_discount
點(diǎn)擊復(fù)制文檔內(nèi)容
畢業(yè)設(shè)計(jì)相關(guān)推薦
文庫吧 www.dybbs8.com
備案圖片鄂ICP備17016276號(hào)-1