SQL

CREATE TABLE agent_skills  (
  agent_id TEXT NOT NULL,
  skill_id TEXT NOT NULL,
  PRIMARY KEY (agent_id, skill_id),
  FOREIGN KEY (agent_id) REFERENCES agents(id) ON DELETE CASCADE,
  FOREIGN KEY (skill_id) REFERENCES skills(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
agent_id TEXT ✓ Rename | Drop
skill_id TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
skill_id skills.id
agent_id agents.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_agent_skills_1
  • agent_id
  • skill_id
 ✓ SQL
-- no sql found --
 Drop