CREATE TABLE agent_labels_catalog (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL CHECK(length(name) BETWEEN 1 AND 64),
  name_key TEXT NOT NULL UNIQUE,
  color TEXT,
  created_at TEXT NOT NULL
);
CREATE TABLE agent_labels (
  agent_id TEXT NOT NULL REFERENCES agents(id) ON DELETE CASCADE,
  label_id TEXT NOT NULL REFERENCES agent_labels_catalog(id) ON DELETE CASCADE,
  PRIMARY KEY(agent_id,label_id)
);
CREATE INDEX idx_agent_labels_label ON agent_labels(label_id,agent_id);