Query

app.db — voice_agent_instance_...

SQL

CREATE TABLE voice_agent_instance_connections  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  voice_agent_config_id INTEGER NOT NULL,
  instance_id INTEGER NOT NULL,
  created_at TEXT NOT NULL,
  FOREIGN KEY (voice_agent_config_id) REFERENCES voice_agent_configs(id) ON DELETE CASCADE,
  FOREIGN KEY (instance_id) REFERENCES evolution_instances(id) ON DELETE CASCADE,
  UNIQUE(voice_agent_config_id, instance_id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
voice_agent_config_id INTEGER Rename | Drop
instance_id INTEGER Rename | Drop
created_at TEXT Rename | Drop

Foreign Keys

Column Destination
instance_id evolution_instances.id
voice_agent_config_id voice_agent_configs.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_voice_agent_instance_connections_1
  • voice_agent_config_id
  • instance_id
 ✓ SQL
-- no sql found --
 Drop