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