hotel
Tables (9)
hotels
- hotel_id — BIGINT — Primary key — NOT NULL
- name — BIGINT — NOT NULL
member
- member_id — VARCHAR(100) — Primary key — NOT NULL
- password — VARCHAR(100) — NOT NULL
pointHistory
- point_id — BIGINT — Primary key — NOT NULL
- member_id — VARCHAR(100) — Foreign key → member.member_id — NOT NULL
- points — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
pricing
- pricing_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- price — BIGINT — NOT NULL
reservation
- reservation_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- member_id — VARCHAR(100) — Foreign key → rooms.member_id — NOT NULL
- check_in_date — DATETIME — NOT NULL
- check_out_date — DATETIME — NOT NULL
- number_of_people — BIGINT — NOT NULL
- reservation_code — VARCHAR(100) — NOT NULL
- status (Field) — VARCHAR(100) — NOT NULL
review
- review_id — BIGINT — Primary key — NOT NULL
- member_id — VARCHAR(100) — Foreign key → member.member_id — NOT NULL
- reservation_id — BIGINT — Foreign key → reservation.reservation_id — NOT NULL
- content — VARCHAR(100)
- created_at — VARCHAR(100) — NOT NULL
reviewImage
- review_image_id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → review.review_id — NOT NULL
- image_url — VARCHAR(100)
roomImage
- image_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- image_url — VARCHAR(100)
rooms
- room_id — BIGINT — Primary key — NOT NULL
- hotel_id — BIGINT — Foreign key → hotels.hotel_id — NOT NULL
- member_id — VARCHAR(100) — Foreign key → member.member_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