SQL
CREATE TABLE "agent_channel_status" (
"agentId" varchar(36) NOT NULL,
"integrationType" varchar(64) NOT NULL,
"credentialId" varchar(36) NOT NULL,
"hostId" varchar(128) NOT NULL,
"status" varchar(16) NOT NULL,
"errorMessage" text,
"attempts" integer NOT NULL DEFAULT (0),
"backoffUntil" datetime(3),
"expiresAt" datetime(3),
"createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
"updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
CONSTRAINT "CHK_agent_channel_status_status" CHECK ("status" IN ('connected', 'error')),
CONSTRAINT "FK_7a723e6aad04d88057dea6a21f4" FOREIGN KEY ("agentId") REFERENCES "agents" ("id") ON DELETE CASCADE,
PRIMARY KEY ("agentId", "integrationType", "credentialId", "hostId")
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
agentId |
varchar(36) |
✓ | Rename | Drop | |
integrationType |
varchar(64) |
✓ | Rename | Drop | |
credentialId |
varchar(36) |
✓ | Rename | Drop | |
hostId |
varchar(128) |
✓ | Rename | Drop | |
status |
varchar(16) |
Rename | Drop | ||
errorMessage |
TEXT |
✓ | Rename | Drop | |
attempts |
INTEGER |
Rename | Drop | ||
backoffUntil |
datetime(3) |
✓ | Rename | Drop | |
expiresAt |
datetime(3) |
✓ | Rename | Drop | |
createdAt |
datetime(3) |
Rename | Drop | ||
updatedAt |
datetime(3) |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
agentId |
agents.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| IDX_a7c67724df9ef3d12f6da773c1 |
expiresAt
|
SQL | Drop | |
| IDX_c75ec632fe0b5b1905edb9cd7f |
hostId
|
SQL | Drop | |
| sqlite_autoindex_agent_channel_status_1 |
|
✓ | SQL | Drop |