hydra public.jobsets

gistfile1.txt

                                                      Table "public.jobsets"
┌──────────────────┬─────────┬───────────┬──────────┬─────────────────────────────────────┬──────────┬──────────────┬─────────────┐
│      Column      │  Type   │ Collation │ Nullable │               Default               │ Storage  │ Stats target │ Description │
╞══════════════════╪═════════╪═══════════╪══════════╪═════════════════════════════════════╪══════════╪══════════════╪═════════════╡
│ name             │ text    │           │ not null │                                     │ extended │              │             │
│ id               │ integer │           │ not null │ nextval('jobsets_id_seq'::regclass) │ plain    │              │             │
│ project          │ text    │           │ not null │                                     │ extended │              │             │
│ description      │ text    │           │          │                                     │ extended │              │             │
│ nixexprinput     │ text    │           │          │                                     │ extended │              │             │
│ nixexprpath      │ text    │           │          │                                     │ extended │              │             │
│ errormsg         │ text    │           │          │                                     │ extended │              │             │
│ errortime        │ integer │           │          │                                     │ plain    │              │             │
│ lastcheckedtime  │ integer │           │          │                                     │ plain    │              │             │
│ triggertime      │ integer │           │          │                                     │ plain    │              │             │
│ enabled          │ integer │           │ not null │ 1                                   │ plain    │              │             │
│ enableemail      │ integer │           │ not null │ 1                                   │ plain    │              │             │
│ hidden           │ integer │           │ not null │ 0                                   │ plain    │              │             │
│ emailoverride    │ text    │           │ not null │                                     │ extended │              │             │
│ keepnr           │ integer │           │ not null │ 3                                   │ plain    │              │             │
│ checkinterval    │ integer │           │ not null │ 300                                 │ plain    │              │             │
│ schedulingshares │ integer │           │ not null │ 100                                 │ plain    │              │             │
│ fetcherrormsg    │ text    │           │          │                                     │ extended │              │             │
│ forceeval        │ boolean │           │          │                                     │ plain    │              │             │
│ starttime        │ integer │           │          │                                     │ plain    │              │             │
│ type             │ integer │           │ not null │ 0                                   │ plain    │              │             │
│ flake            │ text    │           │          │                                     │ extended │              │             │
└──────────────────┴─────────┴───────────┴──────────┴─────────────────────────────────────┴──────────┴──────────────┴─────────────┘
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_jobset_fkey" 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_jobset_fkey" FOREIGN KEY (project, jobset) REFERENCES jobsets(project, name) ON UPDATE CASCADE
    TABLE "jobsetevals" CONSTRAINT "jobsetevals_project_jobset_fkey" FOREIGN KEY (project, jobset) REFERENCES jobsets(project, name) ON UPDATE CASCADE ON DELETE CASCADE
    TABLE "jobsetinputs" CONSTRAINT "jobsetinputs_project_jobset_fkey" FOREIGN KEY (project, jobset) REFERENCES jobsets(project, name) ON UPDATE CASCADE ON DELETE CASCADE
    TABLE "jobsetrenames" CONSTRAINT "jobsetrenames_project_to__fkey" FOREIGN KEY (project, to_) REFERENCES jobsets(project, name) ON UPDATE CASCADE ON DELETE CASCADE
    TABLE "starredjobs" CONSTRAINT "starredjobs_project_jobset_fkey" FOREIGN KEY (project, jobset) REFERENCES jobsets(project, name) ON UPDATE CASCADE ON DELETE CASCADE
Triggers:
    jobsetsadded AFTER INSERT ON jobsets FOR EACH STATEMENT EXECUTE FUNCTION 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 FUNCTION notifyjobsetschedulin>
    jobsetsdeleted AFTER DELETE ON jobsets FOR EACH STATEMENT EXECUTE FUNCTION notifyjobsetsdeleted()
    jobsetshareschanged AFTER UPDATE ON jobsets FOR EACH ROW WHEN (old.schedulingshares <> new.schedulingshares) EXECUTE FUNCTION notifyjobsetshareschanged()
Access method: heap