hotel
Tables (5)
hotels
- hotel_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
reservation
- reserve_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- hotel_id — BIGINT — Foreign key → hotels.hotel_id — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- check_in — DATETIME
- check_out — DATETIME
- people — TINYINT
review
- reviw_id (Key) — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- Field (detail) — VARCHAR(255)
rooms
- room_id — BIGINT — Primary key — NOT NULL
- hotel_id — BIGINT — Foreign key → 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
user
- user_id — BIGINT — Primary key — NOT NULL
- password — VARVHAR(100)
- point — TINYINT