exam
Tables (5)
Hotels (Untitled2)
- hotel_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100)
PointDetails (Untitled4)
- point_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT
- amout (amount) — INT
- point_policyp (oint_policy) — TINYINT
- expire_date — DATETIME
- reservation_id — BIGINT
- review_id — BIGINT
Reservations (Untitled3)
- reservation_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → Rooms.room_id — NOT NULL
- user_id — BIGINT
- check_in_date — LOCALDATE
- check_out_date — LOCALDATE
- reservation_num — INT
- canceled — TINYINT(1)
- Field
Reviews (Untitled5)
- review_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT
- contentc (ontent) — VARCHAR(500)
- review_image_url — VARCHAR(500)
- public_review — TINYINT(1)
Rooms (Untitled)
- room_id — BIGINT — Primary key — NOT NULL
- hotel_id — BIGINT — Foreign key → Hotels.hotel_id — NOT NULL
- name — VARCHAR(100)
- capacity — TINYINT
- floor — TINYINT
- bathtub_flag — TINYINT(1)
- view_type — TINYINT
- off_season_price — INT
- season_price — INT
- room_image_url — VARCHAR(500)
- created_at — DATETIME