구독 결제 시스템

테이블 (4)

credits

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • total_credits — INT — NOT NULL
  • remaining_credits — INT — NOT NULL
  • last_updated — TIMESTAMP

subscriptions

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • plan — ENUM('A', 'B', 'C') — NOT NULL
  • status — ENUM('ACTIVE', 'CANCELLED')
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL

transactions

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • amount — INT — NOT NULL
  • type — ENUM('DAILY_CREDIT', 'SUBSCRIPTION', 'USAGE') — NOT NULL
  • feature — ENUM('CHAT_RECOMMENDATION', 'AUTO_PLACEMENT', 'OTHER', 'SYSTEM') — NOT NULL
  • created_at — TIMESTAMP

users

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP