mongleERD

Tables (14)

ai_generation_logs

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • task_type — VARCHAR(50) — NOT NULL
  • model_name — VARCHAR(100) — NOT NULL
  • prompt_version — VARCHAR(50)
  • input_tokens — INT — NOT NULL
  • output_tokens — INT — NOT NULL
  • cached_input_tokens — INT — NOT NULL
  • actual_cost — DECIMAL(12, 8) — NOT NULL
  • baseline_model — VARCHAR(100) — NOT NULL
  • baseline_cost — DECIMAL(12, 8) — NOT NULL
  • latency_ms — BIGINT
  • success — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

bridge_narratives

  • id — BIGINT — Primary key — NOT NULL
  • dream_connection_id — BIGINT — Foreign key → dream_connections.id — NOT NULL
  • content — TEXT — NOT NULL
  • generation_status — VARCHAR(30) — NOT NULL
  • model_name — VARCHAR(100)
  • prompt_version — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

dream_artworks

  • id — BIGINT — Primary key — NOT NULL
  • dream_id — BIGINT — Foreign key → dreams.id — NOT NULL
  • image_url — VARCHAR(1000)
  • style — VARCHAR(100)
  • mood — VARCHAR(100)
  • prompt — TEXT
  • generation_status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL

dream_connections

  • id — BIGINT — Primary key — NOT NULL
  • dream_world_id — BIGINT — Foreign key → dream_worlds.id — NOT NULL
  • source_dream_id — BIGINT — Foreign key → dreams.id — NOT NULL
  • target_dream_id — BIGINT — Foreign key → dreams.id — NOT NULL
  • created_at — DATETIME — NOT NULL

dream_entities

  • id — BIGINT — Primary key — NOT NULL
  • dream_id — BIGINT — Foreign key → dreams.id — NOT NULL
  • entity_type — VARCHAR(30) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

dream_narratives

  • id — BIGINT — Primary key — NOT NULL
  • dream_id — BIGINT — Foreign key → dreams.id — NOT NULL
  • content — TEXT — NOT NULL
  • generation_status — VARCHAR(30) — NOT NULL
  • model_name — VARCHAR(100)
  • prompt_version — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

dream_scene_entities

  • dream_scene_id — BIGINT — Foreign key → dream_scenes.id — NOT NULL
  • dream_entity_id — BIGINT — Foreign key → dream_entities.id — NOT NULL

dream_scenes

  • id — BIGINT — Primary key — NOT NULL
  • dream_id — BIGINT — Foreign key → dreams.id — NOT NULL
  • sequence_no — INT — NOT NULL
  • content — TEXT — NOT NULL
  • is_disconnected_from_previous — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

dream_world_dreams

  • dream_world_id — BIGINT — Foreign key → dream_worlds.id — NOT NULL
  • dream_id — BIGINT — Foreign key → dreams.id — NOT NULL
  • sequence_no — INT
  • added_at — DATETIME — NOT NULL

dream_worlds

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

dreams

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • original_text — TEXT — NOT NULL
  • dreamed_at — DATE
  • representative_emotion — VARCHAR(50)
  • analysis_status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

world_entities

  • id — BIGINT — Primary key — NOT NULL
  • dream_world_id — BIGINT — Foreign key → dream_worlds.id — NOT NULL
  • entity_type — VARCHAR(30) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

world_entity_mappings

  • id — BIGINT — Primary key — NOT NULL
  • world_entity_id — BIGINT — Foreign key → world_entities.id — NOT NULL
  • dream_entity_id — BIGINT — Foreign key → dream_entities.id — NOT NULL
  • confidence — DECIMAL(5,4)
  • mapping_source — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL