CallFromAI-AI
Tables (10)
agent_goals
- id — BIGINT — Primary key — NOT NULL
- character_id — BIGINT — Foreign key → characters.character_id
- goal_type — VARCHAR(255)
- description — TEXT
- priority — INT
- status — VARCHAR(255)
- created_at — DATETIME(6)
agent_life_events
- id — BIGINT — Primary key — NOT NULL
- character_id — BIGINT — Foreign key → characters.character_id
- event_date — DATE
- time_context — VARCHAR(255)
- summary — TEXT
- detail — TEXT
- emotion — VARCHAR(255)
- created_at — DATETIME(6)
agent_self_state_logs
- id — BIGINT — Primary key — NOT NULL
- previous_hurt — DOUBLE
- next_hurt — DOUBLE
- previous_trust — DOUBLE
- next_trust — DOUBLE
- previous_anger — DOUBLE
- next_anger — DOUBLE
- previous_insecurity — DOUBLE
- next_insecurity — DOUBLE
- event_type — VARCHAR(255)
- severity — DOUBLE
- delta_reason — TEXT
- created_at — DATETIME(6)
- id (id2) — BIGINT — Foreign key → characters.character_id — NOT NULL
agent_self_states
- id — BIGINT — Primary key — NOT NULL
- version — BIGINT
- character_id — BIGINT — Foreign key → characters.character_id — NOT NULL
- affection — DOUBLE
- trust — DOUBLE
- hurt — DOUBLE
- anger — DOUBLE
- insecurity — DOUBLE
- disappointment — DOUBLE
- emotional_distance — DOUBLE
- last_emotion — VARCHAR(255)
- last_significant_event — VARCHAR(255)
- updated_at — DATETIME(6)
agent_world_states
- id — BIGINT — Primary key — NOT NULL
- character_id — BIGINT — Foreign key → characters.character_id
- current_activity — VARCHAR(255)
- location — VARCHAR(255)
- time_context — VARCHAR(255)
- mood — VARCHAR(255)
- energy — INT
- stress — INT
- loneliness — INT
- pending_thought — TEXT
- last_updated_at — DATETIME(6)
character_examples
- id — BIGINT — Primary key — NOT NULL
- character_id — BIGINT — Foreign key → characters.character_id
- event_type — VARCHAR(255) — AgentEventType enum
- relationship_temperature — VARCHAR(255) — RelationshipTemperature enum
- relationship_stage — VARCHAR(255)
- min_temperature_score — INT
- max_temperature_score — INT
- romance_style_band — VARCHAR(255) — RomanceStyleBand enum
- user_example — TEXT
- assistant_example — TEXT
- tone_tag — VARCHAR(255)
- priority — INT
- active — BIT
character_preferences
- id — BIGINT — Primary key — NOT NULL
- character_id — BIGINT — Foreign key → characters.character_id
- preference_key — VARCHAR(255)
- preference_value — TEXT
- source — VARCHAR(255)
- confidence — DOUBLE
- stability — VARCHAR(255)
- created_from_message — TEXT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
characters
- character_id — BIGINT — Primary key — NOT NULL
- userid — BIGINT — Foreign key → users.userid — NOT NULL
conversation_events
- id — BIGINT — Primary key — NOT NULL
- character_id — BIGINT — Foreign key → characters.character_id
- event_type — VARCHAR(255)
- summary — TEXT
- agent_reaction — TEXT
- importance — DOUBLE
- created_at — DATETIME(6)
users
- userid — BIGINT — Primary key — NOT NULL