Query

cool-keeper.db — jobs

SQL

CREATE TABLE "jobs"  (
  `id` text PRIMARY KEY NOT NULL,
  `known_error_id` text,
  `error` text NOT NULL,
  `stack` text,
  `repo_url` text NOT NULL,
  `branch` text NOT NULL,
  `pr_url` text,
  `status` text DEFAULT 'pending' NOT NULL,
  `failure_reason` text,
  `triage_action` text,
  `triage_severity` text,
  `triage_reasoning` text,
  `created_at` text DEFAULT (datetime('now')) NOT NULL,
  `updated_at` text DEFAULT (datetime('now')) NOT NULL,
  `org_id` text REFERENCES organizations(id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
known_error_id TEXT ✓ Rename | Drop
error TEXT Rename | Drop
stack TEXT ✓ Rename | Drop
repo_url TEXT Rename | Drop
branch TEXT Rename | Drop
pr_url TEXT ✓ Rename | Drop
status TEXT Rename | Drop
failure_reason TEXT ✓ Rename | Drop
triage_action TEXT ✓ Rename | Drop
triage_severity TEXT ✓ Rename | Drop
triage_reasoning TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop
org_id TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
org_id organizations.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_jobs_status status SQL 
CREATE INDEX `idx_jobs_status`
ON `jobs` (`status`)
Drop
sqlite_autoindex_jobs_1 id ✓ SQL
-- no sql found --
 Drop