IF Commons GitHub

decision

concept

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.

Governance: attributes

consequencestextoptional

What follows from it

Becomes the column consequences of decision.

Written at commons/data/models/operations/mod.ts:83

contexttextrequired

What made it necessary

Becomes the column context of decision.

Written at commons/data/models/operations/mod.ts:81

decidedAtinstantoptional

When

Becomes the column decided_at of decision.

Written at commons/data/models/operations/mod.ts:86

decidedBytextoptional

Who decided

Becomes the column decided_by of decision.

Written at commons/data/models/operations/mod.ts:85

decisionIdidentifierrequired

What identifies the decision

Becomes the column decision_id of decision.

Written at commons/data/models/operations/mod.ts:79

outcometextrequired

What was decided

Becomes the column outcome of decision.

Written at commons/data/models/operations/mod.ts:82

statuscode of decisionStatusrequired

Where it is

Becomes the column status of decision.

Written at commons/data/models/operations/mod.ts:84

titletextrequired

What was decided, in a line

Becomes the column title of decision.

Written at commons/data/models/operations/mod.ts:80

Governance: relationships

supersedesoptional

The decision this one replaced To decision. Written at commons/data/models/operations/mod.ts:76

Logical: the table

Projects to the table decision with the primary key decision_id.

ColumnTypeNullRoleFrom
consequencestexttrueattributedecision.consequences
contexttextfalseattributedecision.context
decided_attimestamptrueattributedecision.decidedAt
decided_bytexttrueattributedecision.decidedBy
decision_idtextfalseattributedecision.decisionId
outcometextfalseattributedecision.outcome
statustextfalseattributedecision.status
supersedes_decision_idtexttruereferencedecision.supersedes
titletextfalseattributedecision.title

Physical: SQL

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'))
);

Physical: the typed table

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);

Titles, headings, exports, tables, columns and requirements. Esc closes.