ringleImplement

Tables (9)

active_storage_attachments

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • record_type — VARCHAR(255) — NOT NULL
  • record_id — BIGINT — NOT NULL
  • blob_id — BIGINT — Foreign key → active_storage_blobs.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

active_storage_blobs

  • id — BIGINT — Primary key — NOT NULL
  • filename — VARCHAR(255) — NOT NULL
  • content_type — VARCHAR(255)
  • metadata — TEXT
  • service_name — VARCHAR(255) — NOT NULL
  • byte_size — BIGINT — NOT NULL
  • checksum — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

cached_speeches

  • id — BIGINT — Primary key — NOT NULL
  • content_digest — VARCHAR(255) — NOT NULL
  • text — TEXT — NOT NULL
  • voice — VARCHAR(50) — NOT NULL
  • model — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

conversation_sessions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • scenario — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

conversation_turns

  • id — BIGINT — Primary key — NOT NULL
  • conversation_session_id — BIGINT — Foreign key → conversation_sessions.id — NOT NULL
  • speaker — VARCHAR(10) — NOT NULL
  • english — TEXT — NOT NULL
  • korean — TEXT
  • word_count — INTEGER — NOT NULL
  • position — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

memberships

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • plan_id — BIGINT — Foreign key → plans.id
  • features — VARCHAR(255) — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • source — VARCHAR(20) — NOT NULL
  • paused_remaining_seconds — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

payments

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • plan_id — BIGINT — Foreign key → plans.id — NOT NULL
  • membership_id — BIGINT — Foreign key → memberships.id
  • amount — INTEGER — NOT NULL
  • currency — VARCHAR(3) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • pg_transaction_id — VARCHAR(255)
  • idempotency_key — VARCHAR(255)
  • refunded_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

plans

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • price — INTEGER — NOT NULL
  • original_price — INTEGER
  • currency — VARCHAR(3) — NOT NULL
  • duration_days — INTEGER — NOT NULL
  • features — VARCHAR(255) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • popular — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • suspended_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL