Gaji
Tables (22)
base_scenarios
- id — UUID
- novel_id — UUID — NOT NULL
- chapter_id — UUID
- passage_id — UUID
- base_story — VARCHAR(100) — NOT NULL
- metadata — JSONB
- is_verified — BOOLEAN
- creator_id — UUID
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
character_appearances
- id — UUID
- passage_id — UUID — NOT NULL
- character_id — UUID — NOT NULL
- mention_type — VARCHAR(50) — NOT NULL
- internal_monologue — ))
- mention_count — INTEGER
- context_snippet — TEXT
- sentiment — VARCHAR(20)
- emotional_state — VARCHAR(50)
- created_at — TIMESTAMP
- UNIQUE(passage_id, — character_id,
characters
- id — UUID
- novel_id — UUID — NOT NULL
- name — VARCHAR(200) — NOT NULL
- aliases — JSONB
- role — VARCHAR(50)
- description — TEXT
- first_appearance_chapter_id — UUID
- personality_traits — JSONB
- relationships — JSONB
- embedding_vector — vector(1536)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- UNIQUE(novel_id, — name)
conversation_emotions
- id — UUID
- conversation_id — UUID — NOT NULL
- message_id — UUID — NOT NULL
- character_name — VARCHAR(100) — NOT NULL
- primary_emotion — VARCHAR(50) — NOT NULL
- conflicted — ))
- emotion_intensity — DECIMAL(3,2) — NOT NULL
- emotion_details — JSONB
- analyzed_at — TIMESTAMP
conversation_likes
- user_id — UUID — Primary key — NOT NULL
- conversation_id — UUID — Primary key — NOT NULL
- created_at — TIMESTAMP
conversation_memos
- user_id — UUID — Primary key — NOT NULL
- conversation_id — UUID — Primary key — NOT NULL
- memo_text — VARCHAR(1000) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
conversation_message_links
- conversation_id — UUID — Primary key — NOT NULL
- message_id — UUID — Primary key — NOT NULL
- sequence_number — INTEGER — NOT NULL
conversations
- id — UUID
- parent_conversation_id — UUID
- scenario_type — VARCHAR(20) — NOT NULL
- root_scenario_id — UUID
- leaf_scenario_id — UUID
- user_id — UUID — NOT NULL
- title — VARCHAR(200)
- like_count — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
events
- id — UUID
- novel_id — UUID — NOT NULL
- passage_id — UUID
- event_type — VARCHAR(50)
- turning_point — ))
- title — VARCHAR(300) — NOT NULL
- description — TEXT — NOT NULL
- involved_character_ids — JSONB
- location_id — UUID
- significance_score — DECIMAL(3,2)
- chronological_order — INTEGER
- created_at — TIMESTAMP
leaf_user_scenarios
- id — UUID
- root_scenario_id — UUID — NOT NULL
- user_id — UUID — NOT NULL
- custom_parameters — JSONB — NOT NULL
- quality_score — DECIMAL(3,2)
- is_private — BOOLEAN
- conversation_count — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
llm_analysis_metadata
- id — UUID
- novel_id — UUID — NOT NULL
- analysis_type — VARCHAR(50) — NOT NULL
- narrative_arc_detection — ))
- llm_model — VARCHAR(100) — NOT NULL
- llm_temperature — DECIMAL(3,2)
- prompt_template_version — VARCHAR(50)
- tokens_used — INTEGER
- input_tokens — INTEGER
- output_tokens — INTEGER
- cost_usd — DECIMAL(10,4)
- status — VARCHAR(50) — NOT NULL
- failed — ))
- error_message — TEXT
- started_at — TIMESTAMP
- completed_at — TIMESTAMP
- progress_percentage — INTEGER
- processed_passages — INTEGER
- total_passages — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
location_appearances
- id — UUID
- passage_id — UUID — NOT NULL
- location_id — UUID — NOT NULL
- is_primary_setting — BOOLEAN
- context_snippet — TEXT
- created_at — TIMESTAMP
- UNIQUE(passage_id, — location_id)
locations
- id — UUID
- novel_id — UUID — NOT NULL
- name — VARCHAR(200) — NOT NULL
- type — VARCHAR(50)
- description — TEXT
- first_appearance_chapter_id — UUID
- parent_location_id — UUID
- significance — VARCHAR(50)
- created_at — TIMESTAMP
- UNIQUE(novel_id, — name)
messages
- id — UUID
- role — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
narrative_arcs
- id — UUID
- novel_id — UUID — NOT NULL
- arc_type — VARCHAR(50)
- title — VARCHAR(300) — NOT NULL
- description — TEXT
- start_chapter_id — UUID
- end_chapter_id — UUID
- involved_character_ids — JSONB
- key_event_ids — JSONB
- resolution_status — VARCHAR(50)
- created_at — TIMESTAMP
novel_chapters
- id — UUID
- novel_id — UUID — NOT NULL
- chapter_number — INTEGER — NOT NULL
- title — VARCHAR(300)
- content_text — TEXT — NOT NULL
- word_count — INTEGER — NOT NULL
- character_count — INTEGER — NOT NULL
- summary — TEXT
- created_at — TIMESTAMP
- UNIQUE(novel_id, — chapter_number)
novel_passages
- id — UUID
- chapter_id — UUID — NOT NULL
- sequence_order — INTEGER — NOT NULL
- content_text — TEXT — NOT NULL
- start_char_offset — INTEGER — NOT NULL
- end_char_offset — INTEGER — NOT NULL
- word_count — INTEGER — NOT NULL
- passage_type — VARCHAR(50) — NOT NULL
- mixed — ))
- embedding_vector — vector(1536)
- embedding_model — VARCHAR(100)
- created_at — TIMESTAMP
- UNIQUE(chapter_id, — sequence_order)
novels
- id — UUID
- title — VARCHAR(300) — NOT NULL
- author — VARCHAR(200) — NOT NULL
- original_language — VARCHAR(50)
- era — VARCHAR(100)
- genre — VARCHAR(100)
- full_text_s3_path — VARCHAR(500)
- total_word_count — INTEGER
- publication_year — INTEGER
- isbn — VARCHAR(20)
- cover_image_url — VARCHAR(500)
- description — TEXT
- is_verified — BOOLEAN
- creator_id — UUID
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
root_user_scenarios
- id — UUID
- base_scenario_id — UUID — NOT NULL
- user_id — UUID — NOT NULL
- scenario_type — VARCHAR(50) — NOT NULL
- SETTING_MODIFICATION — ))
- custom_parameters — JSONB — NOT NULL
- quality_score — DECIMAL(3,2)
- is_private — BOOLEAN
- fork_count — INTEGER
- conversation_count — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
themes
- id — UUID
- novel_id — UUID — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- related_passages — JSONB
- prominence_score — DECIMAL(3,2)
- created_at — TIMESTAMP
- UNIQUE(novel_id, — name)
user_follows
- follower_id — UUID — Primary key — NOT NULL
- following_id — UUID — Primary key — NOT NULL
- created_at — TIMESTAMP
users
- id — UUID
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- bio — TEXT
- avatar_url — VARCHAR(500)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP