erd2

Tables (11)

COMMENT

  • comment_id — BIGINT — Primary key — NOT NULL — 부모 댓글 ID (대댓글용, 자기참조)
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • parent_id — BIGINT — 댓글 내용
  • content — TEXT — NOT NULL — 댓글 깊이 (0: 댓글, 1: 대댓글)
  • depth — INT — NOT NULL
  • updated_at — DATETIME — NOT NULL

MEMBER

  • member_id — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • member_type — TINYINT — NOT NULL — 1:일반유저, 2:가맹점주
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

PAYMENT

  • payment_id — BIGINT — Primary key — NOT NULL
  • reservation_id — BIGINT — Foreign key → RESERVATION.reservation_id — NOT NULL
  • amount — INT — NOT NULL
  • payment_method — TINYINT — 1:카카오페이, 2:토스페이먼츠
  • payment_key — VARCHAR(255) — 토스페이먼츠
  • order_id — VARCHAR(255) — 토스페이먼츠
  • payment_status — VARCHAR(20) — NOT NULL — 결제완료/취소/실패
  • paid_at — DATETIME

PLACE

  • place_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id
  • region_id — BIGINT — Foreign key → REGION.region_id — NOT NULL
  • place_type — TINYINT — NOT NULL — 1:숙박, 2:맛집, 3:관광지, 4:여행지
  • registration_type — TINYINT — 1:관리자 직접등록, 2:TourAPI 연동
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • address — VARCHAR(255)
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • is_closed — BOOLEAN — NOT NULL — 마감 처리 여부
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

PLACE_IMAGE

  • image_id — BIGINT — Primary key — NOT NULL
  • place_id — BIGINT — Foreign key → PLACE.place_id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

POST

  • post_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • place_id — BIGINT — Foreign key → PLACE.place_id — 후기글일 때만 값 존재
  • post_type — VARCHAR(20) — NOT NULL — 일반/후기/모집
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

POST_IMAGE

  • image_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → POST.post_id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

REGION

  • region_id — BIGINT — Primary key — NOT NULL
  • region_name — VARCHAR(50) — NOT NULL
  • parent_region_id — BIGINT — Foreign key → REGION.region_id

RESERVATION

  • reservation_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • place_id — BIGINT — Foreign key → PLACE.place_id — NOT NULL
  • visitor_name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • visit_date — DATE — NOT NULL
  • headcount — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — 대기중/확정/취소/완료
  • created_at — DATETIME — NOT NULL

SOCIAL_ACCOUNT

  • social_account_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL — GOOGLE, KAKAO, NAVER
  • provider_user_id — VARCHAR(255) — NOT NULL — 소셜 서비스 측 고유 ID
  • created_at — DATETIME — NOT NULL

WISHLIST

  • wishlist_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • place_id — BIGINT — Foreign key → PLACE.place_id — NOT NULL
  • created_at — DATETIME — NOT NULL