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)