inhaeven-erd
Tables (20)
activity (Untitled5)
- id (pk) — long — Primary key — NOT NULL
- host_id (fk(user.id)) — long — Foreign key → user.Key — NOT NULL
- name (체험 이름) — String
- type (유형) — enum(FOOD, CULTURE, ...)
- activity_description (체험 설명) — Text
- host_description (호스트 설명) — Varchar(500)
- max_people (최대인원) — Int
- location (체험 위치(만나는 장소)) — String
- price_per_person (1인당 가격) — Int
- duration_minutes (소요 시간(분)) — Int
- is_liked (메인 유저 좋아요 여부) — boolean
- is_badapass (바다패스 적용 여부) — boolean
- badapass_discount_rate (바다패스 할인율) — int
activity_file (체험 사진)
- id (pk) — long — Primary key — NOT NULL
- order (사진 순서) — int
- url (사진 url) — String
- activity_id (체험 id) — long — Foreign key → activity.id — NOT NULL
activity_reservation (Untitled15)
- id (pk) — long — Primary key — NOT NULL
- guest_id (fk) — long — Foreign key → user.Key — NOT NULL
- activity_session_id (fk3) — long — Foreign key → activity_session.id — NOT NULL
- guest_count (예약인원) — Int
- created_at (예약일) — Timestamp
activity_reserved_date (Untitled3)
- id (pk) — long — Primary key — NOT NULL
- reservation_id (fk) — long — Foreign key → activity_reservation.id — NOT NULL
- activity_id (fk2) — long — Foreign key → activity.id — NOT NULL
- reserved_date (예약된날짜) — Date
activity_review (체험 리뷰)
- id (pk) — long — Primary key — NOT NULL
- created_at (방문 일시) — LocalDateTime
- rate (별점) — int
- content (내용) — String
- host_comment (사장님 댓글) — String
- host_comment_created_at (사장님 댓글 작성 일시) — LocalDateTime
- reviewer_id (fk) — long — Foreign key → user.Key — NOT NULL
- activity_id (fk2) — long — Foreign key → activity.id — NOT NULL
activity_review_file (체험 리뷰 사진)
- id (pk) — long — Primary key — NOT NULL
- order (사진 순서) — int
- url (사진 url) — String
- activity_review_id (fk) — long — Foreign key → activity_review.id — NOT NULL
activity_session (Untitled)
- id (pk) — long — Primary key — NOT NULL
- activity_id (fk) — long — Foreign key → activity.id — NOT NULL
- start_time (시작시간) — Datetime
- is_active (예약 가능 여부)
banner (Untitled9)
- id (pk) — long — Primary key — NOT NULL
- cover (커버 사진 url) — String
- order (배너 순서) — int
- linked_url (외부 링크 url) — String
community (커뮤니티)
- id (pk) — long — Primary key — NOT NULL
- name (작성사 이름) — String
- title (게시글 제목) — String
- content (게시글 내용) — String
- created_at (등록 일시) — LocalDateTime
- like_count (좋아요 개수) — int
- comment_count (댓글 개수) — int
- is_liked (메인 유저 좋아요 여부) — boolean
- url (사진url) — String
community_comment (커뮤니티 댓글)
- id (pk) — long — Primary key — NOT NULL
- name (작성자 이름) — String
- content (댓글 내용) — String
- created_at (등록 일시) — LocalDateTime
- profile_image (작성자 프로필 사진) — String
- community_id (fk) — long — Foreign key → community.id — NOT NULL
location (Untitled11)
- id (pk) — long — Primary key — NOT NULL
- name (지역 이름) — String
- address (지역 주소) — String
product (판매 상품)
- id (pk) — long — Primary key — NOT NULL
- name (상품 이름) — String
- discount (할인률) — int
- price (가격) — int
- location (생산지) — String
- delievery (배송 정보) — String
- photo (상품 사진 url) — String
room (객실)
- id (pk) — long — Primary key — NOT NULL
- name (객실 이름) — String
- options (옵션) — String
- max_people (최대 인원) — int
- beds (침대 갯수) — int
- inner_rooms (방 개수) — int
- image (객실 이미지) — String
- stay_id (fk) — long — Foreign key → stay.id — NOT NULL
- is_active (예약 가능 여부) — Boolean — Foreign key → room.id — NOT NULL
stay (숙소)
- id (pk) — long — Primary key — NOT NULL
- name (숙소 이름) — String
- location (숙소 위치) — String
- content (숙소 설명) — String
- price (숙박 최소 가격) — int
- host_id (fk(user_id)) — long — Foreign key → user.Key — NOT NULL
- is_liked (메인 유저 좋아요 여부) — boolean
- is_badapass (바다패스 적용 여부(할인 대상 숙소)) — boolean
- badapass_discount_rate (바다패스 할인율) — int
- type (숙박 종류) — enum(게하/한옥, 독채)
stay_file (숙소 사진)
- id (pk) — long — Primary key — NOT NULL
- order (사진 순서) — int
- url (사진 url) — String
- stay_id (fk) — long — Foreign key → stay.id — NOT NULL
stay_reservation (Untitled14)
- id (pk) — long — Primary key — NOT NULL
- guest_id (fk) — long — Foreign key → user.Key — NOT NULL
- room_id (fk2) — long — Foreign key → room.id — NOT NULL
- check_in (체크인날짜) — Date
- check_out (체크아웃날짜) — Date
- guest_countd (예약인원) — Int
- created_at (예약일) — Timestamp
stay_reserved_date (Untitled2)
- id (pk) — long — Primary key — NOT NULL
- reservation_id (fk) — long — Foreign key → stay_reservation.id — NOT NULL
- room_id (fk2) — long — Foreign key → room.id — NOT NULL
- reserved_date (예약된날짜) — Date
stay_review (숙소 리뷰)
- id (pk) — long — Primary key — NOT NULL
- reviewer_id (리뷰 작성자 id) — long — Foreign key → user.Key — NOT NULL
- stay_id (숙소 id) — long — Foreign key → stay.id — NOT NULL
- created_at (방문 일시) — LocalDateTime
- rate (별점) — int
- content (내용) — String
- host_comment (사장님 댓글) — String
- host_comment_created_at (사장님 댓글 작성 일시) — LocalDateTime
stay_review_file (숙소 리뷰 사진)
- id (pk) — long — Primary key — NOT NULL
- order (사진 순서) — int
- url (사진 url) — String
- stay_review_id (fk) — long — Foreign key → stay_review.id — NOT NULL
user (사용자)
- Key (pk) — long — Primary key — NOT NULL
- name (사용자이름) — String
- email (이메일(로그인Id)) — String
- profile_image (프로필사진) — String
- role (사용자 역할) — Eunm(GUEST, HOST)