exam
Tables (15)
Hotels
- 호텔 식별번호 (hotel_id) — BIGINT — Primary key — NOT NULL
- 호텔 이름 (name) — VARCHAR(100)
Images
- image_id — BIGINT — Primary key — NOT NULL
- path — VARCHAR(255)
Reservations
- reservation_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → Untitled.user_id — NOT NULL
- room_id — BIGINT — Foreign key → Rooms.room_id — NOT NULL
- Field (check_in_at) — DATE
- Field (check_out_at) — DATE
- Field (number_of_people) — TINYINT
- Field (created_at) — DATETIME
- Field (status) — TINYINT
Reviews
- review_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → Untitled.user_id — NOT NULL
- 호텔 식별번호 (hotel_id) — BIGINT — Foreign key → Hotels.호텔 식별번호 — NOT NULL
- exposure — TINYINT(1)
- content — TEXT
- Field (created_at) — DATETIME
Rooms
- room_id — BIGINT — Primary key — NOT NULL
- 호텔 식별번호 (hotel_id) — BIGINT — Foreign key → Hotels.호텔 식별번호 — NOT NULL
- Field (name) — VARCHAR(100)
- Field (capacity) — TINYINT
- Field (floor) — TINYINT
- Field (bathtub_flag) — TINYINT(1)
- Field (view_type) — TINYINT
- Field (created_at) — DATETIME
- Field (status) — TINYINT(1)
- Field (smoke) — TINYINT(1)
- Field (bath_type) — TINYINT
- Field
Untitled (Users)
- user_id — BIGINT — Primary key — NOT NULL
- Key (role_id) — TINYINT — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(50)
- Field (phone) — CHAR(11)
- Field (loginId) — VARCHAR(50)
- Field2 (password) — VARCHAR(60)
Untitled (Roles)
- Key (role_id) — TINYINT — Primary key — NOT NULL
- Field (name) — VARCHAR(20)
Untitled (room_image)
- image_id — BIGINT — Foreign key → Images.image_id — NOT NULL
- room_id — BIGINT — Foreign key → Rooms.room_id — NOT NULL
Untitled (peak_season)
- Key (peak_season_id) — BIGINT — Primary key — NOT NULL
- Key (day_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (price) — INT
Untitled (low_season)
- Key (low_season_id) — BIGINT — Primary key — NOT NULL
- Key (day_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (price) — INT
Untitled (day)
- Key (day_id) — BIGINT — Primary key — NOT NULL
- Field (name) — CAHR(3)
Untitled (low_season_fee)
- Key (low_season_fee_id) — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → Rooms.room_id — NOT NULL
- Key (low_season_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (peak_season_fee)
- Key (peak_season_fee_id) — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → Rooms.room_id — NOT NULL
- Key (peak_season_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
points
- point_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → Untitled.user_id — NOT NULL
- reservation_id — BINARY(16) — Foreign key → Reservations.reservation_id — NOT NULL
- point — INT
- created_at — DATETIME
review_images (review_image)
- review_id — BIGINT — Foreign key → Reviews.review_id — NOT NULL
- image_id — BIGINT — Foreign key → Images.image_id — NOT NULL