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)