exam01_hotel
Tables (8)
hotels
- hotel_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
point_log
- point_log (point_id) — BIGINT — Primary key — NOT NULL
- point_description — VARCHAR(50) — NOT NULL — ex)회원가입 축하
- point_usage — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- user_no — BIGINT — Foreign key → user.user_no — NOT NULL
reservation
- reservation_id — BIGINT — Primary key — NOT NULL
- check_in_date — DATETIME
- check_out_date — DATETIME
- num_of_people — TINYINT
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- user_no — BIGINT — Foreign key → user.user_no — NOT NULL
- hotel_id — BIGINT — Foreign key → rooms.hotel_id — NOT NULL
review
- review_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- hotel_id — BIGINT — Foreign key → rooms.hotel_id — NOT NULL
- review_content — VARCHAR(255)
- review_score (reivew_score) — INT
review_image
- review_id — BIGINT — Foreign key → review.review_id — NOT NULL
- room_id — BIGINT — Foreign key → review.room_id — NOT NULL
- hotel_id — BIGINT — Foreign key → review.hotel_id — NOT NULL
- file_path — 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
- INDEX — `fk_Rooms_hotels_idx`
- INDEX1 — `uk_hotel_roomname`
- peak_price — BIGINT
- non_peak_price — BIGINT
rooms_image
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- hotel_id — BIGINT — Foreign key → rooms.hotel_id — NOT NULL
- file_path — VARCHAR(255)
user
- user_no — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(50)
- user_password — VARCHAR(255)
- user_role — TINYINT