ㄴㄴㄴㄴ
Tables (8)
Hotel (호텔)
- 호텔 식별자 (hotel_id) — bigint — Primary key — NOT NULL
- 제목 (title) — varchar(255)
- 호텔점수 (hotelScore)
- 호텔주소 (address)
- 좌표 x (location_x)
- 좌표 y (location_y)
- 호텔 서비스 (service)
- 카테고리 (category)
- wish_list_id — bigint — Foreign key → wish_list.wish_list_id — NOT NULL
hotelImage (호텔 이미지)
- image_id — bigint — Primary key — NOT NULL
- image — varchar(255)
- title — varchar(255)
- 호텔 식별자 (hotel_id) — bigint — Foreign key → Hotel.호텔 식별자 — NOT NULL
- review_id — bigint — Foreign key → review.review_id — NOT NULL
member
- member_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- email — varchar(255) — NOT NULL
- image — varchar(255)
- name — varchar(255) — NOT NULL
- password — varchar(255)
- provider — varchar(255)
- roles
member_roles
- roles — varchar(255)
- member_id — bigint — Foreign key → member.member_id — NOT NULL
reservation
- reservation_id — bigint — Primary key — NOT NULL
- checkin — date
- checkout — date
- adult — integer
- child — integer
- price — bigint
- status — bit
- reservation_date — varchar(255)
- member_id — bigint — Foreign key → member.member_id — NOT NULL
- room_id — bigint — Foreign key → room.room_id — NOT NULL
review
- review_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- content — varchar(255) — NOT NULL
- score — integer — NOT NULL
- hotelImage (image_id) — bigint
- member_id — bigint — Foreign key → member.member_id — NOT NULL
- 호텔 식별자 (hotel_id) — bigint — Foreign key → Hotel.호텔 식별자 — NOT NULL
room
- room_id — bigint — Primary key — NOT NULL
- head_count — int
- room_type — varchar(255)
- quantity — int
- price — int
- 호텔 식별자 (hotel_id) — bigint — Foreign key → Hotel.호텔 식별자 — NOT NULL
wish_list
- wish_list_id — bigint — Primary key — NOT NULL
- hotel_id — bigint
- member_id — bigint — Foreign key → member.member_id — NOT NULL