中信酒店管理系統(tǒng)需求

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