호텔
테이블 (7)
hotels
- hotel_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
members
- member_id — BIGINT — 기본 키 — NOT NULL
- id — varchar(50) — NOT NULL
- pwd — varchar(50) — NOT NULL
- grade — varchar(10) — NOT NULL
- point — BIGINT — NOT NULL
points
- point_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → members.member_id — NOT NULL
- point_value — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- point_content — VARCHAR(50) — NOT NULL
reservations
- reservation_id — BIGINT — 기본 키 — NOT NULL
- room_id — BIGINT — 외래 키 → rooms.room_id — NOT NULL
- member_id — BIGINT — 외래 키 → members.member_id — NOT NULL
- check_in — DATETIME — NOT NULL
- check_out — DATETIME — NOT NULL
- reservation_code — VARCHAR(255) — NOT NULL
- reservation_at — DATETIME — NOT NULL
- reservation_status — VARCHAR(10) — NOT NULL
reviews
- review_id — BIGINT — 기본 키 — NOT NULL
- room_id — BIGINT — 외래 키 → rooms.room_id — NOT NULL
- member_id — BIGINT — 외래 키 → members.member_id — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- review_title — VARCHAR(50) — NOT NULL
- review_content — VARCHAR(1000) — NOT NULL
- created_at — DATETIME — NOT NULL
room_status
- room_status_id — INT — 기본 키 — NOT NULL
- room_id — BIGINT — 외래 키 → rooms.room_id — NOT NULL
- status_name — VARCHAR(20) — NOT NULL
- Field
rooms
- room_id — BIGINT — 기본 키 — NOT NULL
- hotel_id — BIGINT — 외래 키 → hotels.hotel_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- capacity — TINYINT — NOT NULL
- floor — TINYINT — NOT NULL
- bathtub_flag — TINYINT(1) — NOT NULL
- view_type — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL