酒店管理系統(tǒng)項(xiàng)目組長：項(xiàng)目組員:______撰寫日期：2012-04-22系統(tǒng)ER圖系統(tǒng)關(guān)聯(lián)圖物理模型圖數(shù)據(jù)庫表用戶表(user）數(shù)據(jù)項(xiàng)名稱參數(shù)數(shù)據(jù)類型用戶idUser_idNumber用戶編號(hào)User_codeNumber用戶姓名User_nameVarchar（20)用戶密碼User_passwordVarchar(10）用戶備注User_commentVarchar（200）酒水零食（food）數(shù)據(jù)項(xiàng)名稱參數(shù)數(shù)據(jù)類型副食品idFood_idNumber編號(hào)Food_codeNumber副食品名稱Food_nameVarchar（20）副食品價(jià)格Food_priceNumber副食品種類Food_kindsVarchar(20）酒水零食賬單表（food_bill)數(shù)據(jù)項(xiàng)名稱參數(shù)數(shù)據(jù)類型副食品賬單idFood_bill_idNumber副食品idFood_bill_idNumber賓客idFood_check_in_idNumber副食品消費(fèi)數(shù)量Food_bill_cost_numberNumber副食品消費(fèi)金額Food_bill_costNumber副食品消費(fèi)時(shí)間Food_bill_dateDate預(yù)定餐飲（general_cost）數(shù)據(jù)項(xiàng)名稱參數(shù)數(shù)據(jù)類型普通消費(fèi)idgeneral_cost_idNumber賓客姓名general_cost_nameVarchar（20)賓客電話general_cost_telVarchar（20)押金general_cost_cashNumber預(yù)定時(shí)間general_cost_dateDate預(yù)定到達(dá)時(shí)間general_cost_arr_dateDate預(yù)定餐飲狀態(tài)Book_stateNumber菜單（menu）數(shù)據(jù)項(xiàng)名稱參數(shù)數(shù)據(jù)類型食品idMenu_idNumber食品編號(hào)Menu_codeNumber食品名稱Menu_nameVarchar(20）食品價(jià)格Menu_priceNumber食品賬單表（menu_bill)數(shù)據(jù)項(xiàng)名稱參數(shù)數(shù)據(jù)類型食品賬單idMenu_bill_idNumber食品idMenu_bill_idNumber賓客idMenu_bill_cus_idNumber食品消費(fèi)數(shù)量Menu_bill_cost_numberNumber食品消費(fèi)金額Menu_bill_costNumber食品消費(fèi)時(shí)間Menu_bill_dateDate客房（room）數(shù)據(jù)項(xiàng)名稱參數(shù)數(shù)據(jù)類型客房idRoom_idNumber客房編號(hào)RoomcodeNumber客房等級(jí)Room_gradeNumber客房價(jià)格Room_priceNumber客房狀態(tài)RoomstateNumber客房備注Room_commentVarchar（200）賓客表（customer）數(shù)據(jù)項(xiàng)名稱參數(shù)數(shù)據(jù)類型賓客idCustomer_idNumber姓名Customer_nameVarchar（20)性別Customer_genderChar（2）身份證號(hào)Customer_codeVarchar（18)電話Customer_telVarchar（20)會(huì)員表（member)數(shù)據(jù)項(xiàng)名稱參數(shù)數(shù)據(jù)類型會(huì)員idMember_idNumber會(huì)員等級(jí)idMember_grade_idNumber姓名Member_nameVarchar（20)性別Member_genderChar(2)身份證號(hào)Member_codeVarchar（18)生日Member_birthdayDate聯(lián)系電話Member_telVarchar（20)會(huì)員等級(jí)(menber_grade）數(shù)據(jù)項(xiàng)名稱參數(shù)數(shù)據(jù)類型會(huì)員等級(jí)idGrade_idNumber會(huì)員等級(jí)Member_gradeNumber會(huì)員折扣Menber_countNumber（4,2)預(yù)定房間(Book_room)數(shù)據(jù)項(xiàng)名稱參數(shù)數(shù)據(jù)類型預(yù)房idBook_idNumber客房idBroom_idNumber賓客idBcustomer_idNumber押金B(yǎng)_cashNumber預(yù)定時(shí)間B_dateDate預(yù)定天數(shù)B_lastNumber預(yù)定到達(dá)時(shí)間Book_arr_dateDate預(yù)房狀態(tài)Book_stateNumber住宿表(Check_in)數(shù)據(jù)項(xiàng)名稱參數(shù)數(shù)據(jù)類型住宿idCheck_in_idNumber房間idCheck_in_room_idNumber賓客idCheckin_custom