writer_v2

Tables (23)

ai_analysis

  • id — UUID
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • work_id — UUID — Foreign key → work.id — NOT NULL
  • episode_id — UUID — Foreign key → episode.id — NOT NULL
  • setting_conflicts — TEXT
  • tone_conflicts — TEXT
  • new_items — TEXT
  • tokens_used — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

ai_prompt_template

  • id — UUID
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • prompt_template — TEXT — NOT NULL
  • model — VARCHAR(50) — NOT NULL
  • max_tokens — INTEGER — NOT NULL
  • token_cost — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

audit_log

  • id — UUID
  • writer_id — UUID — Foreign key → writer.id
  • action — VARCHAR(100) — NOT NULL
  • ip_address — VARCHAR(50)
  • user_agent — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL

character

  • id — UUID
  • work_id — UUID — Foreign key → work.id — NOT NULL
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • profile_image_url — TEXT
  • gender — VARCHAR(20) — NOT NULL
  • age — VARCHAR(100) — NOT NULL
  • appearance — TEXT — NOT NULL
  • mbti — VARCHAR(10)
  • personality — TEXT
  • content — TEXT
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

character_custom_field

  • id — UUID
  • character_id — UUID — Foreign key → character.id — NOT NULL
  • field_name — VARCHAR(100) — NOT NULL
  • field_value — TEXT
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

character_tag

  • id — UUID
  • character_id — UUID — Foreign key → character.id — NOT NULL
  • world_note_id — UUID — Foreign key → world_note.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

episode

  • id — UUID
  • work_id — UUID — Foreign key → work.id — NOT NULL
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • parent_id — UUID — Foreign key → episode.id
  • title — VARCHAR(200) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • content — TEXT
  • word_count — INTEGER — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

export

  • id — UUID
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • work_id — UUID — Foreign key → work.id — NOT NULL
  • format — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • file_url — VARCHAR(500)
  • expires_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

foreshadow

  • id — UUID
  • work_id — UUID — Foreign key → work.id — NOT NULL
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • importance — VARCHAR(10) — NOT NULL
  • content — TEXT
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

foreshadow_link

  • id — UUID
  • foreshadow_id — UUID — Foreign key → foreshadow.id — NOT NULL
  • link_type — VARCHAR(20) — NOT NULL
  • episode_id — UUID — Foreign key → episode.id
  • plot_id — UUID — Foreign key → plot.id
  • context_memo — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • CHECK — (episode_id IS NOT NULL OR plot_id IS NOT NULL) — NOT NULL

idea_archive

  • id — UUID
  • work_id — UUID — Foreign key → work.id — NOT NULL
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • content — TEXT — NOT NULL
  • tag — VARCHAR(20)
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

notification

  • id — UUID
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • message — TEXT
  • is_read — BOOLEAN — NOT NULL
  • expires_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

payment

  • id — UUID
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • order_id — VARCHAR(100) — NOT NULL
  • payment_key — VARCHAR(200)
  • amount — INTEGER — NOT NULL
  • token_qty — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • method — VARCHAR(20)
  • approved_at — TIMESTAMP
  • failure_reason — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

payment_event

  • id — UUID
  • event_id — VARCHAR(100) — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • payload — JSONB — NOT NULL
  • processed_at — TIMESTAMP — NOT NULL

plan

  • id — UUID
  • work_id — UUID — Foreign key → work.id — NOT NULL
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • slogan — TEXT
  • genres — JSONB
  • moods — JSONB
  • target_audience — VARCHAR(200)
  • content — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

plot

  • id — UUID
  • work_id — UUID — Foreign key → work.id — NOT NULL
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • parent_id — UUID — Foreign key → plot.id
  • title — VARCHAR(200) — NOT NULL
  • status — VARCHAR(20)
  • content — TEXT
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

plot_episode_link

  • id — UUID
  • plot_id — UUID — Foreign key → plot.id — NOT NULL
  • episode_id — UUID — Foreign key → episode.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

subscription

  • id — UUID
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • customer_key — VARCHAR(100) — NOT NULL
  • billing_key — VARCHAR(200) — NOT NULL
  • plan — VARCHAR(50) — NOT NULL
  • monthly_tokens — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • next_billing_at — TIMESTAMP — NOT NULL
  • last_payment_at — TIMESTAMP
  • retry_count — INTEGER — NOT NULL
  • cancelled_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

token_transaction

  • id — UUID
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • amount — INTEGER — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • reason — VARCHAR(100)
  • reference_id — UUID
  • expires_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

token_wallet

  • writer_id — UUID — Foreign key → writer.id
  • balance — INTEGER — NOT NULL
  • total_charged — INTEGER — NOT NULL
  • total_used — INTEGER — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

work

  • id — UUID
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • author_name — VARCHAR(100)
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

world_note

  • id — UUID
  • work_id — UUID — Foreign key → work.id — NOT NULL
  • writer_id — UUID — Foreign key → writer.id — NOT NULL
  • parent_id — UUID — Foreign key → world_note.id
  • name — VARCHAR(200) — NOT NULL
  • content — TEXT
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

writer

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • nickname — VARCHAR(100)
  • profile_image_url — TEXT
  • role — VARCHAR(20) — NOT NULL
  • oauth_provider — VARCHAR(50)
  • oauth_id — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP