DB
Tables (9)
Customer Information (customer)
- Customer ID (customer_id) — int(10) — Primary key — NOT NULL
- Reservation ID (reservation_id) — int(10)
- Grade (grade) — char(1)
- First Name (first_name) — varchar(20)
- Last Name (last_name) — varchar(20)
- Nationality (nationality) — varchar(20)
- Street Number (street_number) — varchar(20)
- Street Name (street_name) — varchar(20)
- City (city) — varchar(20)
- State (state) — varchar(20)
- Zip Code (zip_code) — varchar(20)
- Birthday (date_of_birth) — date
- Temperature (temperature) — int(2)
- Age (age) — int(3)
Customer's Phone (customer_phone)
- Customer ID (customer_id) — int(10) — Primary key — NOT NULL
- Phone Number (phone_number) — int(11) — Primary key — NOT NULL
Employee (employee)
- Employee ID (employee_id) — int(10) — Primary key — NOT NULL
- First Name (first_name) — varchar(20)
- Last Name (last_name) — varchar(20)
- Job (job) — varchar(20)
- Rank (rank) — char(1)
- Working Date (working_day) — datetime
- Work OnTime (work_on_time) — datetime
- Work Off Time (work_off_time) — datetime
Employee's Phone Number (employee_phone)
- Employee ID (employee_id) — int(10) — Primary key — NOT NULL
- Key — int(11) — Primary key — NOT NULL
Front Desk (front)
- Work ID (work_id) — int(10) — Primary key — NOT NULL
- Employee ID (employee_id) — int(10)
- Reservation ID (reservation_id) — int(10)
- Start Time (time_start) — datetime
- End Time (time_end) — datetime
- Memo (memo) — varchar(100)
Housekeeping (work_id)
- Work ID (work_id) — int(10) — Primary key — NOT NULL
- Employee ID (employee_id) — int(10)
- Room ID (room_id) — int(4)
- Start Time (time_start) — datetime
- End Time (time_end) — datetime
- Memo (memo) — varchar(100)
Reservation Information (reservation)
- Reservation ID (reservation_id) — int(10) — Primary key — NOT NULL
- Reservation Date (reservation_date) — date
- Check In (check_in) — datetime
- Check Out (check_out) — datetime
- Payment (payment) — varchar(10)
- Smoker (smoker) — int(1)
- Extra Bed (extra_bed) — int(1)
- Breakfast (breakfast) — int(1)
- Morning Call (morningcall) — datetime
- Mini Bar Charge (minibar_charge) — int(100000000)
- Car Number (car_number) — varchar(8)
Room (room)
- Room Number (room_id) — int(4) — Primary key — NOT NULL
- Reservation ID (reservation_id) — int(10)
- Room View (room_view) — varchar(6)
- Notification (notification) — int(1)
- Floor (floor) — int(2)
- Occupied (is_occupied) — int(1)
Room Type (room_type)
- Room ID (room_id) — int(4) — Primary key — NOT NULL
- Room Type (room_type) — varchar(10)
- Capacity (max_capacity) — int(2)
- Smoking (smoke_allowed) — int(1)
- Extra Bed (extra_bed_allowed) — int(1)