수익화

테이블 (3)

유저 결제 정보 (user_detail)

  • userId (user_id) — bigint — 기본 키 — NOT NULL
  • userType (user_type) — varchar(255)
  • bankName (bank_name) — varchar(255)
  • accountNumber (account_number) — varchar(255)
  • createdAt (created_at) — timestamp(6)
  • updatedAt (updated_at) — timestamp(6)

적립금 인출 로그 테이블 (withdraw_log)

  • ID (id) — int — 기본 키 — NOT NULL
  • userId (user_id) — bigint
  • point — int
  • state — enum('request', 'reject', 'approve', 'done')
  • createdAt (created_at) — timestamp(6)
  • updatedAt (updated_at) — timestamp(6)

쿠팡 포스트백 (purchase_log)

  • ID (id) — int — 기본 키 — NOT NULL
  • orderId (order_id) — bigint
  • contentId (content_id) — bigint
  • purchaseCancel (purchase_cancel) — enum('purchase', 'cancel')
  • jsonData (json_data) — text
  • createdAt (created_at) — timestamp(6)