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