캠핑가자
테이블 (28)
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_unavailable
- id — BIGINT — 기본 키 — NOT NULL
- camp_zone_id — BIGINT — 외래 키 → camp_zone.id — NOT NULL
- date — DATE — NOT NULL
- reason — VARCHAR(200)
- created_at — DATETIME — NOT NULL
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 — 외래 키 — 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 — 외래 키 — 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
zone_price
- id — BIGINT — 기본 키 — NOT NULL
- camp_zone_id — BIGINT — 외래 키 → camp_zone.id — NOT NULL
- season_type — ENUM('PEAK','OFF_PEAK','WEEKEND','WEEKDAY') — NOT NULL
- price — INT — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL