纵横天下旅游网数据库设计

1、纵横天下旅游网数据库设计管理员表(admin)列名描述数据类型admin_id标记idintadmin_name管理员账号varcharadmin_password管理员密码varcharadmin_degree管理员分类varchararea_id所属线路地区idint线路地区表(area)列名描述数据类型area_id线路地区idintarea_name地区名称varchararea_nameid所属种类idint公告表(bulletin)列名描述数据类型bulletin_id公告idintbulletin_title公告标题varcharbulletin_message公告内容varch

2、artime发布时间datetime线路种类表(category)列名描述数据类型category_id种类idintcategory_name线路种类varchararea_nameid种类编号=idint商品大类表(dalei)列名描述数据类型dalei_id商品大类idIntdaleiname大类名称varchar网站调查表(diaocha)列名描述数据类型wangluo网络bigintbaozhi报纸bigintpengyou朋友介绍bigintqita其他bigint资料下载表(down_data)列名描述数据类型data_id资料idintdata_title资料标题varchar

3、data_message资料内容varchardata_upath文件路径varcharuptime上传时间datetimeother1预留1varcharOther2预留2varcharOther3预留3varchar手册下载表(down_ handbook)列名描述数据类型handbook_id手册idinthandbook_title手册标题varcharhandbook_message手册内容varcharhandbook_upath文件路径varcharuptime上传时间datetimeOther2预留2varcharOther3预留3varcharOther4预留4varchar

4、Other5预留5varchar地图下载表(down_map)列名描述数据类型map_id地图idintmap_title地图标题varcharmap_message地图内容varcharmap_upath文件路径varcharuptime上传时间datetimeother1预留1varcharOther2预留2varcharOther3预留3varchar图片下载表(down_pic)列名描述数据类型pic_id图片idintpic _title图片标题varcharpic _message图片内容varcharpic _upath文件路径varcharuptime上传时间datetimeo

5、ther1预留1varcharOther2预留2varcharOther3预留3varchar广告效劳表(ggfw)列名描述数据类型ididintimage图片路径varcharbig图片大小varcharprice价格varchar商品表(goods)列名描述数据类型id商品idintgoodname商品名称varchargoodnum商品数量intgoodprice商品价格网站floatgoodxinghao商品型号varchargoodInfo商品介绍varchargoodimage图片路径varcharistuijian受否推荐varchardel审核标记intother预留varch

6、arguid小类idintdalei_id大类idintP_id供给商idintgoodprice2供给/本钱价格floatgoodprice3加盟价格floatgoodprice4代理价格floatpayfor1是否付款intpayfor2是否付款intgoodstime发布时间datetime商品小类表(goods_leibie)列名描述数据类型guid商品小类idIntleibie小类名称varchardalei_id大类idint酒店表(hotel)列名描述数据类型Hotel_id酒店idintHotel_name酒店名称varcharHotel_address酒店地址varcharH

7、otel_tel酒店 varcharHotel_roomnum客房数varcharHotel_endtime结账时间varcharHotel_replenish补充说明varcharHotel_price单人间(网站)varcharHotel_price2高级间varcharHotel_price3行政间varcharHotel_price4双套间varcharHotel_price5复式套间varcharHotel_price6标准间varcharHotel_price7商务间varcharHotel_price8套间varcharHotel_price9组合套间varcharHotel_p

8、rice10会议室varcharHotel_gyprice单人间(供给商)varcharHotel_gyprice2高级间varcharHotel_gyprice3行政间varcharHotel_gyprice4双套间varcharHotel_gyprice5复式套间varcharHotel_gyprice6标准间varcharHotel_gyprice7商务间varcharHotel_gyprice8套间varcharHotel_gyprce9组合套间varcharHotel_gyprice10会议室varcharHotel_dlprice单人间(代理商)varcharHotel_dlpri

9、ce2高级间varcharHotel_dlprice3行政间varcharHotel_dlprice4双套间varcharHotel_dlprice5复式套间varcharHotel_dlprice6标准间varcharHotel_dlprice7商务间varcharHotel_dlprice8套间varcharHotel_dlprce9组合套间varcharHotel_dlprice10会议室varcharhotel_degree星级varcharhotel_time时间datetimehotel_deltag审核标记inthotel_pic酒店图片varcharP_id供给商idintes

10、tablishmentname酒店设施varcharHotel_dl2price单人间(加盟商)varcharHotel_dl2price2高级间varcharHotel_dl2price3行政间varcharHotel_dl2price4双套间varcharHotel_dl2price5复式套间varcharHotel_dl2price6标准间varcharHotel_dl2price7商务间varcharHotel_dl2price8套间varcharHotel_dl2price9组合套间varcharHotel_dl2price10会议室varcharpayfor1是否付款intPayf

11、or2是否付款intsheng预留varcharshi预留varchartophotel是否推荐varchar广告位表(images)列名描述数据类型id位置idintimage团片路径varcharlink连接地址varchar线路表(lines)列名描述数据类型line_id线路idintline_name线路名称varcharline_day线路天数intline_plane行程安排varcharline_deltag审核标记intline_time发布时间datetimeline_tese景点介绍varcharline_jingdianpic景点图片varchararea_id地区id

12、intcategory_id种类idintP_id供给商idintp_id2代理idintprice_deltag财务审核标记intmotorcade_id预留intticket_id预留intpayfor1是否付款intPayfor2是否付款intctxz参团须知textOther3预留charOther4预留charOther5预留charOther6预留char利群报名处表(lqbmc)列名描述数据类型id报名处idintname报名处名称varcharaddress地址varchartel varchar新闻表(news)列名描述数据类型news_id新闻idintnews_title

13、新闻标题varcharnews_message新闻内容textnews_addtime发布时间datetimenew_pic图片路径varcharOther1预留charOther2预留charOther3预留charOther4预留char酒店订单表(orderhote)列名描述数据类型orderhote_id酒店订单编号inth_id酒店idintname入住客人姓名varcharkefangleixing客房类型varcharjianshu预定间数varcharrenshu1人数(成人)varcharrenshu2人数(儿童)varcharriqi入住日期varchardaodashij

14、ian预计到达时间varcharbaoliushijian保存时间varcharlianxiren联系人varcharcardid身份证varchartel联系 varcharemail邮件varchargettime预定时间datetimeorderhotel_deltag审核标记intshenhetime审核时间datetimeprice预定价格floatP_id2代理idintpayfor付款方式varcharyuliu3预留charorder_number订单号varcharydday预定天数varchargyprice供给价格floatpayfortype申请付款状态intpayfo

15、rtime付款时间datetimewangzhanprice网站定价float线路订单表(orderline)列名描述数据类型orderline_id订单idintline_id线路idintlump_id团队idintu_id游客idintrenshuadult报名人数成intrenshusenfant儿童intpayfor支付方式varcharordertime生成时间datetimeorder_deltag审核标记intdegree身份intshenhetime审核时间datetimehuzhaohao护照号varcharhuzhaoriqi签发日期varcharqianfadi签发地v

16、archarchushengdi出生地varcharguoji国家varcharxing英文姓varcharming英文名varcharxingbie性别varcharcsny出生年月varcharp_id2代理idintchenger成人/儿童varcharbaoxian1保险/意外险varcharbaoxian2保险/空险varcharbaoxian3保险/境外险varcharbaoxian1price意外险价格varcharbaoxian2price空险价格varcharbaoxian3price境外险价格varcharorder_number订单号varcharprice预定价格flo

17、atu_degree是否导游intwangzhanprice网站价格floatgyprice供给价格float供给商、代理商.表provider列名描述数据类型P_id供给商idintP_loginname登陆账号varcharP_password登陆密码varcharP_compname企业全称 varcharP_compregistertime企业注册时间datetimeP_compaddress企业所在地varcharP_compcy企业性质 varcharP_bondname联系人 varcharP_bondtel联系 varcharP_email电子邮件 varcharP_xiang

18、mu工程varcharP_answer密码问题 varcharP_question密码答案 varcharP_degree身份intP_shenhe审核标记intP_registertime注册时间 datetimep_kaihuhang开户银行varcharp_zhanghao银行账号varcharp_chikaren持卡人姓名varcharp_khhgsname开户行公司名称varcharp_grkahao个人卡号varcharp_grkaihuhang个人开户行varcharOther4预留字段varcharOther5预留字段varcharOther6预留字段varcharOther7

19、预留字段varcharOther8预留字段varcharOther9预留字段varcharOther10预留字段varchar城市表(tab_city)列名描述数据类型city_id城市idintcity_name城市名称varchar推荐酒店表(top_hotel)列名描述数据类型top_hotelid推荐酒店idint推荐线路(top_line)列名描述数据类型top_lineid推荐线路idinttop_time时间datetime旅游团表(tourlump)列名描述数据类型lump_id团idintline_id线路idintlump_number团号varcharlump_outda

20、y出发时间varcharlump_stopday报名截止时间datetimelump_start出发地datetimelump_count剩余名额intydrs总人数intgyprice1供给成人价格floatgyprice2供给儿童价格floatdlprice1代理成人价格floatdlprice2代理儿童价格floatdl2price1加盟成人价格floatdl2price2加盟儿童价格floatprice1网站成人价格floatprice2网站儿童价格floatlump_deltag审核标记intcategory_id地区idintarea_id种类idintlump_time团生成时间

21、datetimep_id供给商idintotherprice1境外杂费(成人)floatotherprice2境外杂费(儿童)floatqitaprice1其它杂费varcharqitaprice2其它杂费varcharhangban航班varcharqitaprice3其它杂费varcharqitaprice4其它杂费varcharqitaprice5其它杂费varcharqitaprice6其它杂费varcharqitaprice7其它杂费varcharqitaprice8其它杂费varcharqitaprice9其它杂费varchar qitaprice10其它杂费varcharqita

22、price11其它杂费varcharqitaprice12其它杂费varcharqitaprice13其它杂费varcharqitaprice14其它杂费varcharqitaprice15其它杂费varcharqitaprice16其它杂费varcharqitaprice17其它杂费varcharqitaprice18其它杂费varcharqitaprice19其它杂费varcharqitaprice20其它杂费varcharqitaprice21其它杂费varcharqitaprice22其它杂费varchargypricesum应付供给价格floatpricesum网站销售价格float

23、payfortime申请付款时间datetimepayfortype申请付款状态intjinglirun净利润float商品订单表(usermoneyinfo)列名描述数据类型goodorder_id商品订单idusername订购人jiner金额useraddress地址goodname商品名称goodnum商品数量tel shenhe审核payfor付款shenhetime审核时间ordertime订单生成时间degree身份payfangshi付款方式sffp是否要发票gongsitaitou公司台头querenfangshi确认方式P_id供给商idorder_number订单号gyprice供给价格payfortime申请付款时间payfortype申请付款状态签证国家表(visa)列名描述数据类型visa_id签证国家idintvisa_guojia签证国家varchar签证种类表(visalei)列名描述数据类型visa