ㅡㅡㅡ

Tables (9)

CreditPaymentHistory

  • credit_payment_id — BIGINT
  • payment_id — BIGINT — Foreign key → Payment.payment_id
  • credit_wallet_id — BIGINT — Foreign key → CreditWallet.credit_wallet_id
  • credit_price_id — BIGINT — Foreign key → CreditPrice.credit_price_id
  • credit_amount — INT
  • price — DECIMAL(15,2)
  • bonus_amount — INT
  • payment_method — VARCHAR(30)
  • transaction_id — VARCHAR(100)
  • approved_at — DATETIME

CreditPrice

  • credit_price_id — BIGINT
  • product_name — VARCHAR(100)
  • credit_amount — INT
  • price — DECIMAL(15,2)
  • currency — VARCHAR(10)
  • is_active — CHAR(1)
  • display_order — INT
  • created_at — DATETIME
  • updated_at — DATETIME

CreditRefundHistory

  • credit_refund_id — BIGINT
  • payment_id — BIGINT — Foreign key → Payment.payment_id
  • credit_payment_id — BIGINT — Foreign key → CreditPaymentHistory.credit_payment_id
  • credit_wallet_id — BIGINT — Foreign key → CreditWallet.credit_wallet_id
  • refund_amount — DECIMAL(15,2)
  • refund_reason — VARCHAR(255)
  • status — ENUM( 'REQUESTED', 'APPROVED', 'REJECTED', 'COMPLETED' )
  • refunded_at — DATETIME
  • transaction_id — VARCHAR(100)

CreditWallet

  • credit_wallet_id — BIGINT
  • customer_id — BIGINT — Foreign key → Customer.customer_id
  • balance — DECIMAL(15,2)
  • currency — VARCHAR(10)
  • created_at — DATETIME
  • updated_at — DATETIME

Customer

  • customer_id — BIGINT
  • name — VARCHAR(100)
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • phone — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME

MemberInfo

  • member_info_id — BIGINT
  • customer_id — BIGINT — Foreign key → Customer.customer_id
  • nick_name — VARCHAR(100)
  • birth_date — DATE
  • gender — CHAR(1)
  • created_at — DATETIME
  • updated_at — DATETIME

Payment

  • payment_id — BIGINT
  • customer_id — BIGINT — Foreign key → Customer.customer_id
  • status — ENUM( 'PENDING', 'PAID', 'FAILED', 'CANCELLED', 'REFUNDED' )
  • currency — VARCHAR(10)
  • paid_amount — DECIMAL(15,2)
  • created_at — DATETIME
  • updated_at — DATETIME

RatingHistory

  • rating_history_id — BIGINT
  • rating_score — TINYINT
  • changed_at — DATETIME
  • changed_by — BIGINT — Foreign key → Customer.customer_id

ReviewDetail

  • review_detail_id — BIGINT
  • view_count — INT
  • like_count — INT
  • comment_count — INT
  • created_at — DATETIME
  • updated_at — DATETIME