Table "public.jobsets" Column | Type | Modifiers ------------------+---------+------------------------------------------------------ name | text | not null id | integer | not null default nextval('jobsets_id_seq'::regclass) project | text | not null description | text | nixexprinput | text | nixexprpath | text | errormsg | text | errortime | integer | lastcheckedtime | integer | triggertime | integer | enabled | integer | not null default 1 enableemail | integer | not null default 1 hidden | integer | not null default 0 emailoverride | text | not null keepnr | integer | not null default 3 checkinterval | integer | not null default 300 schedulingshares | integer | not null default 100 fetcherrormsg | text | forceeval | boolean | starttime | integer | type | integer | not null default 0 flake | text | Indexes: "jobsets_pkey" PRIMARY KEY, btree (project, name) "jobsets_id_unique" UNIQUE CONSTRAINT, btree (id) Check constraints: "jobsets_check" CHECK ((type = 0) = (nixexprinput IS NOT NULL AND nixexprpath IS NOT NULL)) "jobsets_check1" CHECK ((type = 1) = (flake IS NOT NULL)) "jobsets_schedulingshares_check" CHECK (schedulingshares > 0) Foreign-key constraints: "jobsets_project_fkey" FOREIGN KEY (project) REFERENCES projects(name) ON UPDATE CASCADE ON DELETE CASCADE Referenced by: TABLE "buildmetrics" CONSTRAINT "buildmetrics_project_fkey1" FOREIGN KEY (project, jobset) REFERENCES jobsets(project, name) ON UPDATE CASCADE TABLE "builds" CONSTRAINT "builds_jobset_id_fkey" FOREIGN KEY (jobset_id) REFERENCES jobsets(id) ON DELETE CASCADE TABLE "builds" CONSTRAINT "builds_project_fkey1" FOREIGN KEY (project, jobset) REFERENCES jobsets(project, name) ON UPDATE CASCADE TABLE "jobsetevals" CONSTRAINT "jobsetevals_jobset_id_fkey" FOREIGN KEY (jobset_id) REFERENCES jobsets(id) ON DELETE CASCADE TABLE "jobsetinputs" CONSTRAINT "jobsetinputs_project_fkey" FOREIGN KEY (project, jobset) REFERENCES jobsets(project, name) ON UPDATE CASCADE ON DELETE CASCADE TABLE "jobsetrenames" CONSTRAINT "jobsetrenames_project_fkey1" FOREIGN KEY (project, to_) REFERENCES jobsets(project, name) ON UPDATE CASCADE ON DELETE CASCADE TABLE "starredjobs" CONSTRAINT "starredjobs_project_fkey1" FOREIGN KEY (project, jobset) REFERENCES jobsets(project, name) ON UPDATE CASCADE ON DELETE CASCADE Triggers: jobsetsadded AFTER INSERT ON jobsets FOR EACH STATEMENT EXECUTE PROCEDURE notifyjobsetsadded() jobsetschedulingchanged AFTER UPDATE ON jobsets FOR EACH ROW WHEN (old.triggertime IS DISTINCT FROM new.triggertime AND new.triggertime IS NOT NULL OR old.checkinterval <> new.checkinterval OR old.enabled <> new.enabled) EXECUTE PROCEDURE notifyjobsetschedulingchanged() jobsetsdeleted AFTER DELETE ON jobsets FOR EACH STATEMENT EXECUTE PROCEDURE notifyjobsetsdeleted() jobsetshareschanged AFTER UPDATE ON jobsets FOR EACH ROW WHEN (old.schedulingshares <> new.schedulingshares) EXECUTE PROCEDURE notifyjobsetshareschanged()