toss_payments

Tables (7)

audit_logs

  • id — uuid
  • user_id — uuid
  • table_name — varchar(255)
  • record_id — uuid
  • action — enum(CREATE,UPDATE,DELETE)
  • before — text
  • after — text
  • created_at — datetime

billing_cards

  • id — uuid
  • user_id — uuid — DynamoDB UUID
  • customer_key — uuid
  • authenticated_at — datetime
  • billing_key — varchar(255)
  • card_company — varchar(255)
  • card_number — varchar(255)
  • is_primary — boolean
  • deleted_at — datetime
  • created_at — datetime

payment_failures

  • id — uuid
  • user_id — uuid
  • billing_card_id — uuid
  • error_message — text
  • retry_count — int
  • last_attempt_at — datetime
  • created_at — datetime

payment_histories

  • id — uuid
  • user_id — uuid
  • billing_card_id — uuid
  • periodic_plan_id — uuid
  • toss_payment_id — uuid — Foreign key → toss_payments.id
  • payment_datetime — datetime
  • subscription_expiration_datetime — datetime
  • created_at — datetime

periodic_payment_plans

  • id — uuid
  • title — varchar(255)
  • monthly_amount — int
  • total_amount — int
  • days — int
  • order_name — varchar(255)
  • created_at — datetime
  • updated_at — datetime

recurring_subscribers

  • id — uuid
  • user_id — uuid
  • recent_payment_history_id — uuid — Foreign key → payment_histories.id
  • subscription_start_datetime — datetime
  • subscription_expiration_datetime — datetime
  • is_recurring_billing_enabled — boolean
  • created_at — datetime
  • updated_at — datetime

toss_payments

  • id — uuid
  • user_id — uuid — Foreign key → toss_payments.order_name
  • payment_key — varchar(255)
  • order_id — varchar(255)
  • order_name — varchar(255)
  • method — varchar(255)
  • status — varchar(255)
  • approved_at — datetime
  • amount — int
  • created_at — datetime