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