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