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