hotel management
Tables (16)
Card-Company Table (CopyOfUntitled4)
- Front_Card_num (Key) — VARCHAR(4) — Primary key — NOT NULL
- Card_num (Key2) — VARCHAR(20) — Foreign key — NOT NULL
- Card_Company (Field) — VARCHAR(45)
Card_Table (Untitled4)
- Card_num (Key) — VARCHAR(20) — Primary key — NOT NULL
- Card_CVC (Field) — INT
- Card_Validty (Field2) — DATE
- Card_PW (Field3) — INT
Customer_Table (Untitled3)
- Customer_ID (손님 ID) — INT — Primary key — NOT NULL
- Inform_ID (Key) — INT — Foreign key → Information_Table.Inform_ID — NOT NULL
- Membership_ID (membership id) — INT — Foreign key → Membership_Table.Membership_ID — NOT NULL
- Card_num (Key2) — VARCHAR(20) — Foreign key → Card_Table.Card_num — NOT NULL
- Login_ID (로그인아이디) — INT
- Login_PW (로그인비밀번호) — INT
- Point (포인트) — INT
Facilities (CopyOfUntitled42)
- Facility_ID (Key) — INT — Primary key — NOT NULL
- Hotel_ID (호텔 ID) — INT — Foreign key → Hotel_Table.Hotel_ID — NOT NULL
- Facility_Type (Field) — INT
Hotel_Address_Table (\)
- Zip (우편번호) — VARCHAR(15) — Primary key — NOT NULL
- Street_Number (도로번호) — INT
- Street_Name (도로명) — VARCHAR(45)
- city (호텔 도시) — VARCHAR(15)
- State (주) — VARCHAR(15)
Hotel_Table (/)
- Hotel_ID (호텔 ID) — INT — Primary key — NOT NULL
- Zip (우편번호) — VARCHAR(15) — Foreign key → Hotel_Address_Table.Zip — NOT NULL
- Hotel_Name (호텔 이름) — VARCHAR(20)
- Hotel_Tel (호텔 전화번호) — VARCHAR(45)
Inform_Address_Table (CopyOfUntitled22)
- Zip (우편) — VARCHAR(15) — Primary key — NOT NULL
- Street_Number (도로번호) — INT
- Street_Name (도로명) — VARCHAR(45)
- City (도시) — VARCHAR(15)
- State (주) — VARCHAR(15)
Information_Table (.)
- Inform_ID (Key) — INT — Primary key — NOT NULL
- Zip (우편) — VARCHAR(15) — Foreign key → Inform_Address_Table.Zip — NOT NULL
- First_Name (이름) — VARCHAR(45)
- Last_Name (성) — VARCHAR(45)
- E-Mail (이메일) — VARCHAR(45)
- Fax (팩스) — VARCHAR(45)
- Birthday (생년월일) — Date
- Nationality (국적) — VARCHAR(45)
- Phone_Number (Field) — VARCHAR(45)
Membership_Table (CopyOfUntitled3)
- Membership_ID (membership id) — INT — Primary key — NOT NULL
- RANK (멤버십등급) — VARCHAR(20)
- Accumulation Rate (적립률) — INT
- Discount Rate (할인율) — INT
- Price (가격) — INT
Order_Table (CopyOfUntitled2)
- Order_id (주문 번호) — INT — Primary key — NOT NULL
- Reservation_ID (Key) — INT — Foreign key → Reservation.Reservation_ID — NOT NULL
- Cleaning (청소요청) — BOOLEAN
- Bed (침대추가) — INT
- Pillow (베개) — INT
- Breakfast (아침식사) — BOOLEAN
- Order_time (주문시간) — TIME
Parking Lot (CopyOfCopyOfUntitled42)
- Parking_lot_ID (Key) — INT — Primary key — NOT NULL
- Facility_ID (Key2) — INT — Foreign key → Facilities.Facility_ID — NOT NULL
- Parking_Area (Field) — INT
- Statue (Field2) — TEXT
- Car_Num (Field3) — INT
- Parking_Time (Field4) — TIME
Reservation (CopyOfUntitled)
- Reservation_ID (Key) — INT — Primary key — NOT NULL
- Room_ID (방 ID) — INT — Foreign key → Room_Table.Room_ID — NOT NULL
- Customer_ID (손님 ID) — INT — Foreign key → Customer_Table.Customer_ID — NOT NULL
- RoomTypeID (방 유형 ID) — INT — Foreign key → Room_Table.RoomTypeID — NOT NULL
- Check-in (Field) — DATE
- Check-Out (Field2) — Date
- Adult (Field3) — INT
- Child (Field4) — INT
- PayDate (Field5) — cc
- PayType (Field6) — asdasd
- Price (Field7) — INT
Restaurant (CopyOfCopyOfCopyOfUntitled42)
- Restaurant_ID (Key) — INT — Primary key — NOT NULL
- Facility_ID (Key2) — INT — Foreign key → Facilities.Facility_ID — NOT NULL
- Restaurant_Name (Field) — VARCHAR(20)
- OPEN_TIME (Field2) — TIME
- CLOSE_TIME (Field3) — TIME
- COURSE (Field4) — TEXT
- PRICE (Field5) — INT
Room_Table (Untitled2)
- Room_ID (방 ID) — INT — Primary key — NOT NULL
- RoomTypeID (방 유형 ID) — INT — Foreign key → Room_Type_Table.RoomTypeID — NOT NULL
- Room_Statue (방 상태) — Text
- Room.Tel. (방 내선번호) — VARCHAR(45)
Room_Type_Table (룸 유형)
- RoomTypeID (방 유형 ID) — INT — Primary key — NOT NULL
- RoomType (방 유형) — VARCHAR(20)
- Beds (침대) — INT
- Pillow (베개) — INT
- Size (크기) — INT
- Price (가격) — Price
Staff_Table (Untitled)
- Staff_ID (Key) — INT — Primary key — NOT NULL
- Inform_ID (Key2) — INT — Foreign key → Information_Table.Inform_ID — NOT NULL
- Password (Field) — INT
- Salary (Field2) — INT
- regDate (Field3) — Date
- isWorking (Field4) — Boolean
- Statue (Field5) — Text