77
Tables (5)
Member
- member_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20)
- nick_name — VARCHAR(100)
- birth_date — DATE
- gender — ENUM( 'M', 'F', 'OTHER' )
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_member_email
Payment
- payment_id — BIGINT
- wallet_id — BIGINT — Foreign key → Wallet.wallet_id — NOT NULL
- payment_method — ENUM( 'CARD', 'BANK', 'KAKAO_PAY', 'NAVER_PAY', 'PAYPAL' ) — NOT NULL
- status — ENUM( 'PENDING', 'PAID', 'FAILED', 'CANCELLED', 'PARTIAL_REFUNDED', 'REFUNDED' ) — NOT NULL
- /* — 실제 — NOT NULL
- payment_provider — VARCHAR(50)
- external_transaction_id — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_payment_wallet
- INDEX — idx_payment_status
RatingHistory
- rating_history_id — BIGINT
- review_id — BIGINT — Foreign key → Review.review_id — NOT NULL
- changed_by_member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- change_type — ENUM( 'CREATE', 'UPDATE', 'DELETE' ) — NOT NULL
- old_rating_score — TINYINT
- new_rating_score — TINYINT
- changed_at — DATETIME
- INDEX — idx_rating_history_review
Review
- review_id — BIGINT
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- /* — 구매
- /* — 인증된
- view_count — INT
- like_count — INT
- comment_count — INT
- rating_score — TINYINT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_review_member
- INDEX — idx_review_verified
Wallet
- wallet_id — BIGINT
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- wallet_status — ENUM( 'ACTIVE', 'LOCKED', 'SUSPENDED' )
- /* — 사용 — NOT NULL
- /* — 잠금된 — NOT NULL
- /* — 낙관적 — NOT NULL
- last_changed_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME