consequencestextoptionalWhat follows from it
Becomes the column consequences of decision.
Written at commons/data/models/operations/mod.ts:83
A decision that shaped the platform, with its context, what was decided and what follows from it, so that a later person finds out why and not only what
Model operations. Written in commons/data/models/operations/mod.ts:76. Identified by decisionId.
consequencestextoptionalWhat follows from it
Becomes the column consequences of decision.
Written at commons/data/models/operations/mod.ts:83
contexttextrequiredWhat made it necessary
Becomes the column context of decision.
Written at commons/data/models/operations/mod.ts:81
decidedAtinstantoptionaldecidedBytextoptionalWho decided
Becomes the column decided_by of decision.
Written at commons/data/models/operations/mod.ts:85
decisionIdidentifierrequiredWhat identifies the decision
Becomes the column decision_id of decision.
Written at commons/data/models/operations/mod.ts:79
outcometextrequiredWhat was decided
Becomes the column outcome of decision.
Written at commons/data/models/operations/mod.ts:82
statuscode of decisionStatusrequiredWhere it is
Becomes the column status of decision.
Written at commons/data/models/operations/mod.ts:84
titletextrequiredWhat was decided, in a line
Becomes the column title of decision.
Written at commons/data/models/operations/mod.ts:80
supersedesoptionalThe decision this one replaced To decision. Written at commons/data/models/operations/mod.ts:76
Projects to the table decision with the primary key decision_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
consequences | text | true | attribute | decision.consequences |
context | text | false | attribute | decision.context |
decided_at | timestamp | true | attribute | decision.decidedAt |
decided_by | text | true | attribute | decision.decidedBy |
decision_id | text | false | attribute | decision.decisionId |
outcome | text | false | attribute | decision.outcome |
status | text | false | attribute | decision.status |
supersedes_decision_id | text | true | reference | decision.supersedes |
title | text | false | attribute | decision.title |
CREATE TABLE IF NOT EXISTS "decision" (
"decision_id" VARCHAR NOT NULL PRIMARY KEY,
"title" VARCHAR NOT NULL,
"context" VARCHAR NOT NULL,
"outcome" VARCHAR NOT NULL,
"consequences" VARCHAR,
"status" VARCHAR NOT NULL,
"decided_by" VARCHAR,
"decided_at" TIMESTAMPTZ,
"supersedes_decision_id" VARCHAR,
CONSTRAINT "decision_supersedes_decision_id_fk" FOREIGN KEY ("supersedes_decision_id") REFERENCES "decision" ("decision_id"),
CONSTRAINT "decision_status_ck" CHECK ("status" IN ('proposed', 'accepted', 'rejected', 'superseded'))
);CREATE TABLE IF NOT EXISTS "decision" (
"decision_id" TEXT NOT NULL PRIMARY KEY,
"title" TEXT NOT NULL,
"context" TEXT NOT NULL,
"outcome" TEXT NOT NULL,
"consequences" TEXT,
"status" TEXT NOT NULL,
"decided_by" TEXT,
"decided_at" TIMESTAMPTZ,
"supersedes_decision_id" TEXT,
CONSTRAINT "decision_supersedes_decision_id_fk" FOREIGN KEY ("supersedes_decision_id") REFERENCES "decision" ("decision_id"),
CONSTRAINT "decision_status_ck" CHECK ("status" IN ('proposed', 'accepted', 'rejected', 'superseded'))
);CREATE TABLE IF NOT EXISTS "decision" (
"decision_id" TEXT NOT NULL PRIMARY KEY,
"title" TEXT NOT NULL,
"context" TEXT NOT NULL,
"outcome" TEXT NOT NULL,
"consequences" TEXT,
"status" TEXT NOT NULL,
"decided_by" TEXT,
"decided_at" TEXT,
"supersedes_decision_id" TEXT,
CONSTRAINT "decision_supersedes_decision_id_fk" FOREIGN KEY ("supersedes_decision_id") REFERENCES "decision" ("decision_id"),
CONSTRAINT "decision_status_ck" CHECK ("status" IN ('proposed', 'accepted', 'rejected', 'superseded'))
);Read and written from TypeScript with the types the model gives: import { decision } from "@intellectual-frontiers/data/sql/typed/models". Generated in commons/data/sql/typed/models/operations.auto.ts: do not edit.
import { from } from "@intellectual-frontiers/data/sql/typed";
import { decision } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(decision).select((s) => ({ decisionId: s.decision.decisionId, title: s.decision.title })).run(runner);