ㅇㅇ
테이블 (6)
객실 (rooms)
- room_id — BIGINT — 기본 키 — NOT NULL
- hotel_id — BIGINT — 외래 키 → 호텔.hotel_id — NOT NULL
- 객실명 (name) — VARCHAR(100) — NOT NULL
- 숙박인원 (capacity) — TINYINT — NOT NULL
- 층 (floor) — TINYINT — NOT NULL
- 욕조존재여부 (bathtub_flag) — Boolean — NOT NULL
- 전망 (view_type) — TINYINT — NOT NULL
- 예약날짜 (created_at) — DATETIME — NOT NULL
- INDEX — `fk_Rooms_hotels_idx`
고객 (customers)
- customer_id — BIGINT — 기본 키 — NOT NULL
- username (name) — VARCHAR(100) — NOT NULL
- password — VARCHAR(255)
- email — VARCHAR(150) — NOT NULL
- phone — VARCHAR(15) — NOT NULL
리뷰 (reviews)
- review_id — BIGINT — 기본 키 — NOT NULL
- customer_id — BIGINT — 외래 키 → 고객.customer_id — NOT NULL
- room_id — BIGINT — NOT NULL
- rating — TINYINT — NOT NULL
- comment — TEXT
- created_at — DATETIME — NOT NULL
예약 (reservations)
- reservation_id — BIGINT — 기본 키 — NOT NULL
- customer_id — BIGINT — 외래 키 → 고객.customer_id — NOT NULL
- room_id — BIGINT — NOT NULL
- check_in — DATE — NOT NULL
- check_out — DATE — NOT NULL
- created_at — DATETIME — NOT NULL
포인트 (points)
- point_id — BIGINT — 기본 키 — NOT NULL
- customer_id — BIGINT — 외래 키 → 고객.customer_id — NOT NULL
- points — INT — NOT NULL
- created_at — DATETIME — NOT NULL
호텔 (hotels)
- hotel_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL