ㅇㅇㅇ

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