ㅇㅇㅇ
Tables (7)
CreditRefundHistory
- credit_refund_id — BIGINT
- wallet_charge_history_id — BIGINT — NOT NULL
- wallet_transaction_id — BIGINT — Foreign key → WalletTransaction.wallet_transaction_id — NOT NULL
- refund_amount — DECIMAL(15,2) — NOT NULL
- refund_credit — INT — NOT NULL
- balance_before — DECIMAL(15,2) — NOT NULL
- balance_after — DECIMAL(15,2) — NOT NULL
- refund_reason — VARCHAR(255)
- refund_status — ENUM( 'REQUESTED', 'APPROVED', 'REJECTED', 'COMPLETED' ) — NOT NULL
- refunded_at — DATETIME
- created_at — DATETIME
- INDEX — idx_credit_refund_status
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', 'REFUNDED' ) — NOT NULL
- paid_amount — DECIMAL(15,2) — 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
- old_rating_score — TINYINT
- new_rating_score — TINYINT — NOT NULL
- 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' )
- /* — 사용
- /* — 임시
- /* — 낙관적
- last_changed_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
WalletTransaction
- wallet_transaction_id — BIGINT
- wallet_id — BIGINT — Foreign key → Wallet.wallet_id — NOT NULL
- transaction_type — ENUM( 'CHARGE', 'PAYMENT', 'REFUND', 'ADJUST', 'LOCK', 'UNLOCK' ) — NOT NULL
- transaction_status — ENUM( 'PENDING', 'COMPLETED', 'FAILED', 'CANCELLED' )
- /* — 연결된
- related_id — BIGINT
- amount — DECIMAL(15,2) — NOT NULL
- balance_before — DECIMAL(15,2) — NOT NULL
- balance_after — DECIMAL(15,2) — NOT NULL
- description — VARCHAR(255)
- created_at — DATETIME
- INDEX — idx_wallet_transaction_wallet
- INDEX — idx_wallet_transaction_related