호텔예약 시스템
테이블 (4)
Hotels
- hotel_id (Key) — 기본 키 — NOT NULL
- name (Field2) — VARCHAR
Reservation
- reservation_id (Key) — BIGINT — 기본 키 — NOT NULL
- reservation_code (Field) — TINYINT
- user_id (Field2)
- room_id (Field3)
- check_in_date (Field4)
- check_out_date (Field5)
- guest_count (Field6)
- status (Field7)
- Field8
- Field9
Rooms
- room_id (Key) — BIGINT — 기본 키 — NOT NULL
- name (Field2) — VARCHAR
- capacity (Field3) — TINYINT
- floor (Field4) — TINYINT
- bathtub_flag (Field5) — TINYINT
- view_type (Field6) — TINYINT
- created_at (Field) — DATETIME
- hotel_id (Key2) — 외래 키 → Hotels.hotel_id — NOT NULL
Users
- user_id (Key) — BIGINT — 기본 키 — NOT NULL
- email (Field) — VARCHAR
- password (Field2) — VARCHAR
- name (Field3) — VARCHAR
- created_at (Field4) — DATETIME