SQL

CREATE TABLE "chat_hub_session_tools"  (
  "sessionId" varchar NOT NULL,
  "toolId" varchar NOT NULL,
  CONSTRAINT "FK_e649bf1295f4ed8d4299ed290f9" FOREIGN KEY ("sessionId") REFERENCES "chat_hub_sessions" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_6596a328affd8d4967ffb303eee" FOREIGN KEY ("toolId") REFERENCES "chat_hub_tools" ("id") ON DELETE CASCADE,
  PRIMARY KEY ("sessionId", "toolId")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
sessionId varchar Rename | Drop
toolId varchar Rename | Drop

Foreign Keys

Column Destination
toolId chat_hub_tools.id
sessionId chat_hub_sessions.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_chat_hub_session_tools_1
  • sessionId
  • toolId
SQL
-- no sql found --
Drop