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)