ㅡㅡㅡ
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