캠핑가자

테이블 (26)

camp_image

  • id — BIGINT — 기본 키 — NOT NULL
  • camp_site_id — BIGINT — 외래 키 → camp_site.id — NOT NULL
  • url — VARCHAR(500) — NOT NULL
  • is_main — TINYINT(1) — NOT NULL
  • order_num — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

camp_site

  • id — BIGINT — 기본 키 — NOT NULL
  • host_id — BIGINT — 외래 키 → host.id
  • gocamping_id — VARCHAR(50)
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • address — VARCHAR(200) — NOT NULL
  • region — VARCHAR(50) — NOT NULL
  • city — VARCHAR(50)
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • tel — VARCHAR(20)
  • homepage — VARCHAR(200)
  • check_in_time — TIME — NOT NULL
  • check_out_time — TIME — NOT NULL
  • camp_type — ENUM('NORMAL','CARAVAN','GLAMPING','AUTO') — NOT NULL
  • status — ENUM('PENDING','APPROVED','REJECTED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

camp_zone

  • id — BIGINT — 기본 키 — NOT NULL
  • camp_site_id — BIGINT — 외래 키 → camp_site.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • max_capacity — INT — NOT NULL
  • base_price — INT — NOT NULL
  • zone_type — ENUM('TENT','CARAVAN','GLAMPING','AUTO') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

chat_message

  • id — BIGINT — 기본 키 — NOT NULL
  • chat_room_id — BIGINT — 외래 키 → chat_room.id — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

chat_room

  • id — BIGINT — 기본 키 — NOT NULL
  • type — ENUM('PRIVATE','LIVE') — NOT NULL
  • camp_site_id — BIGINT — 외래 키 → camp_site.id
  • created_at — DATETIME — NOT NULL

chat_room_member

  • id — BIGINT — 기본 키 — NOT NULL
  • chat_room_id — BIGINT — 외래 키 → chat_room.id — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • created_at — DATETIME — NOT NULL

feed

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • camp_site_id — BIGINT — 외래 키 → camp_site.id
  • content — TEXT — NOT NULL
  • visibility — ENUM('PUBLIC','PRIVATE') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

feed_comment

  • id — BIGINT — 기본 키 — NOT NULL
  • feed_id — BIGINT — 외래 키 → feed.id — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

feed_comment_like

  • id — BIGINT — 기본 키 — NOT NULL
  • feed_comment_id — BIGINT — 외래 키 → feed_comment.id — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • created_at — DATETIME — NOT NULL

feed_image

  • id — BIGINT — 기본 키 — NOT NULL
  • feed_id — BIGINT — 외래 키 → feed.id — NOT NULL
  • url — VARCHAR(500) — NOT NULL
  • order_num — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

feed_like

  • id — BIGINT — 기본 키 — NOT NULL
  • feed_id — BIGINT — 외래 키 → feed.id — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • created_at — DATETIME — NOT NULL

host

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • account_bank — VARCHAR(20) — NOT NULL
  • account_number — VARCHAR(30) — NOT NULL
  • account_holder — VARCHAR(20) — NOT NULL
  • status — ENUM('PENDING','APPROVED','REJECTED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

inquiry

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • answer — TEXT
  • status — ENUM('PENDING','ANSWERED') — NOT NULL
  • answered_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notice

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notification

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • type — ENUM('RESERVATION_CONFIRMED','RESERVATION_CANCELLED','TIMEDEAL','CHAT','TAG') — NOT NULL
  • message — VARCHAR(500) — NOT NULL
  • is_read — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

payment

  • id — BIGINT — 기본 키 — NOT NULL
  • reservation_id — BIGINT — 외래 키 → reservation.id — NOT NULL
  • amount — INT — NOT NULL
  • payment_method — VARCHAR(50)
  • payment_key — VARCHAR(200)
  • status — ENUM('PENDING','COMPLETED','CANCELLED','FAILED') — NOT NULL
  • paid_at — DATETIME
  • cancelled_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

report

  • id — BIGINT — 기본 키 — NOT NULL
  • reporter_id — BIGINT — 외래 키 → user.id — NOT NULL
  • target_type — ENUM('FEED','FEED_COMMENT','REVIEW') — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reason — VARCHAR(500) — NOT NULL
  • status — ENUM('PENDING','PROCESSED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

reservation

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • camp_zone_id — BIGINT — 외래 키 → camp_zone.id — NOT NULL
  • time_deal_id — BIGINT — 외래 키 → time_deal.id
  • check_in_date — DATE — NOT NULL
  • check_out_date — DATE — NOT NULL
  • guest_count — INT — NOT NULL
  • total_price — INT — NOT NULL
  • status — ENUM('PENDING','CONFIRMED','CANCELLED','COMPLETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

review

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • camp_site_id — BIGINT — 외래 키 → camp_site.id — NOT NULL
  • reservation_id — BIGINT — 외래 키 → reservation.id — NOT NULL
  • rating — TINYINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

review_like

  • id — BIGINT — 기본 키 — NOT NULL
  • review_id — BIGINT — 외래 키 → review.id — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • created_at — DATETIME — NOT NULL

review_reply

  • id — BIGINT — 기본 키 — NOT NULL
  • review_id — BIGINT — 외래 키 → review.id — NOT NULL
  • host_id — BIGINT — 외래 키 → host.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

settlement

  • id — BIGINT — 기본 키 — NOT NULL
  • host_id — BIGINT — 외래 키 → host.id — NOT NULL
  • reservation_id — BIGINT — 외래 키 → reservation.id — NOT NULL
  • amount — INT — NOT NULL
  • commission_rate — DECIMAL(5,2) — NOT NULL
  • commission_amount — INT — NOT NULL
  • settled_amount — INT — NOT NULL
  • status — ENUM('PENDING','COMPLETED') — NOT NULL
  • settled_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

time_deal

  • id — BIGINT — 기본 키 — NOT NULL
  • camp_zone_id — BIGINT — 외래 키 → camp_zone.id — NOT NULL
  • host_id — BIGINT — 외래 키 → host.id — NOT NULL
  • check_in_date — DATE — NOT NULL
  • check_out_date — DATE — NOT NULL
  • original_price — INT — NOT NULL
  • discount_price — INT — NOT NULL
  • quantity — INT — NOT NULL
  • remaining_quantity — INT — NOT NULL
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • status — ENUM('ACTIVE','ENDED','CANCELLED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user

  • id — BIGINT — 기본 키 — NOT NULL — 유저 고유 식별자
  • email — VARCHAR(100) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • profile_image — VARCHAR(500)
  • role — ENUM('MEMBER','HOST','ADMIN') — NOT NULL
  • provider — ENUM('KAKAO','NAVER','GOOGLE') — NOT NULL
  • provider_id — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

wishlist

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • camp_site_id — BIGINT — 외래 키 → camp_site.id — NOT NULL
  • created_at — DATETIME — NOT NULL

zone_calendar_price

  • id — BIGINT — 기본 키 — NOT NULL
  • camp_zone_id — BIGINT — 외래 키 → camp_zone.id — NOT NULL
  • date — DATE — NOT NULL
  • price — INT — NOT NULL
  • is_available — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL