hotel_database

Tables (4)

bookings (Untitled4)

  • id (booking_id) — UUID — Primary key — NOT NULL
  • fk (room_id) — UUID — Foreign key → rooms.id — NOT NULL
  • fk (branch_id) — UUID — Foreign key → rooms.fk — NOT NULL — hotel unique id
  • fk (customer_id) — UUID — Foreign key → customers.id — NOT NULL
  • 고객수 (number_of_guests) — INT
  • 예약날짜 (reservation_date) — DATE
  • 예정도착일 (planned_arrival_date) — DATE
  • 예정퇴실일 (planned_departure_date) — DATE
  • 실제도착일 (actual_arrival_date) — DATE
  • 실제퇴실일 (actual_departure_date) — DATE
  • 선급금 (deposit) — INT
  • 지불방법 (payment_method) — VARCHAR(50)

customers (Untitled3)

  • id (customer_id) — UUID — Primary key — NOT NULL
  • 고객이름 (customer_name) — VARCHAR(50)
  • 고객주소 (address) — VARCHAR(50)
  • 고객전화번호 (phone_number) — VARCHAR(50)

hotels (Untitled)

  • id (branch_id) — UUID — Primary key — NOT NULL — hotel unique id
  • 호텔이름 (branch_name) — VARCHAR(50)
  • 호텔주소 (address) — VARCHAR(50)
  • 호텔도시 (city) — VARCHAR(50)

rooms (Untitled2)

  • id (room_id) — UUID — Primary key — NOT NULL
  • fk (branch_id) — UUID — Foreign key → hotels.id — NOT NULL — hotel unique id
  • 방이름 (room_name) — VARCHAR(50)
  • 방타입 (room_type) — VARCHAR(50)