hotel-exam
Tables (9)
hotels
- 호텔ID (hotel_id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — VARCHAR(100)
points
- Key (point_id) — BIGINT — Primary key — NOT NULL
- 유저ID (user_id) — BIGINT — Foreign key → users.유저ID — NOT NULL
- 예약ID (reservation_id) — BIGINT — Foreign key → reservation.예약ID — NOT NULL
- Key (review_id) — BIGINT — Foreign key → reviews.Key — NOT NULL
- Field (point) — INT — NOT NULL
- Field2 (expire_date) — DATETIME
- Field (created_at) — DATETIME — NOT NULL
- Field (type) — VARCHAR(20) — NOT NULL
reservation
- 예약ID (reservation_id) — BIGINT — Primary key — NOT NULL
- 유저ID (user_id) — BIGINT — Foreign key → users.유저ID — NOT NULL
- 객실 ID (room_id) — BIGINT — Foreign key → rooms.객실 ID — NOT NULL
- Field (check_in_date) — DATETIME — NOT NULL
- Field (check_out_date) — DATETIME — NOT NULL
- Field2 (people_count) — INT — NOT NULL
- Field3 (status) — VARCHAR(20) — NOT NULL
- Field (reservation_code) — VARCHAR(20) — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
review_images
- Key (image_id) — BIGINT — Primary key — NOT NULL
- Key (review_id) — BIGINT — Foreign key → reviews.Key — NOT NULL
- Field (image_url) — VARCHAR(500) — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
reviews
- Key (review_id) — BIGINT — Primary key — NOT NULL
- 유저ID (user_id) — BIGINT — Foreign key → users.유저ID — NOT NULL
- 객실 ID (room_id) — BIGINT — Foreign key → rooms.객실 ID — NOT NULL
- Field (content) — VARCHAR(500) — NOT NULL
- Field2 (visible_flag) — BOOLEAN
- Field3 (created_at) — DATETIME — NOT NULL
room_images
- Key (image_id) — BIGINT — Primary key — NOT NULL
- 객실 ID (room_id) — BIGINT — Foreign key → rooms.객실 ID — NOT NULL
- Field (image_url) — VARCHAR(500) — NOT NULL
- Field (sort_order) — INT — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
rooms
- 객실 ID (room_id) — BIGINT — Primary key — NOT NULL
- 호텔ID (hotel_id) — BIGINT — Foreign key → hotels.호텔ID — NOT NULL
- 이름 (name) — VARCHAR(100) — NOT NULL
- 숙박인원 (capacity) — TINYINT — NOT NULL
- 층 (floor) — TINYINT — NOT NULL
- 욕조 (bathtub_flag) — TINYINT — NOT NULL
- 전망 (VIEW_TYPE) — TINYINT — NOT NULL
- 생성시간 (created_at) — DATETIME — NOT NULL
season_prices
- Key (season_price_id) — BIGINT — Primary key — NOT NULL
- 객실 ID (room_id) — BIGINT — Foreign key → rooms.객실 ID — NOT NULL
- Field (season_type) — VARCHAR(20) — NOT NULL
- Field (price) — INT — NOT NULL
- Field (week_day) — TINYINT — NOT NULL
users
- 유저ID (user_id) — BIGINT — Primary key — NOT NULL
- 이메일 (email) — VARCHAR(100) — NOT NULL
- 비밀번호 (password) — VARCHAR(100) — NOT NULL
- 이름 (name) — VARCHAR(50) — NOT NULL
- 생성시간 (created_at) — DATETIME — NOT NULL