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