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