goalcode of issueGoalrequiredissueGoal
conceptA goal an issue is held against
Model issues. Written in commons/data/models/issues/mod.ts:112. Identified by issueGoalId.
Governance: attributes
issueGoalIdidentifierrequiredWhat identifies the a goal an issue is held against
Becomes the column issue_goal_id of issue_goal.
Written at commons/data/models/issues/mod.ts:112
Governance: relationships
issueoneThe issue it is of To issue. Written at commons/data/models/issues/mod.ts:112
Logical: the table
Projects to the table issue_goal with the primary key issue_goal_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
goal | text | false | attribute | issueGoal.goal |
issue_goal_id | text | false | attribute | issueGoal.issueGoalId |
issue_id | text | false | reference | issueGoal.issue |
Physical: SQL
CREATE TABLE IF NOT EXISTS "issue_goal" (
"issue_goal_id" VARCHAR NOT NULL PRIMARY KEY,
"goal" VARCHAR NOT NULL,
"issue_id" VARCHAR NOT NULL,
CONSTRAINT "issue_goal_issue_id_fk" FOREIGN KEY ("issue_id") REFERENCES "issue" ("issue_id"),
CONSTRAINT "issue_goal_issue_id_goal_uq" UNIQUE ("issue_id", "goal"),
CONSTRAINT "issue_goal_goal_ck" CHECK ("goal" IN ('g_1', 'g_2', 'g_3', 'g_4', 'g_5', 'g_6', 'g_7', 'g_8'))
);CREATE TABLE IF NOT EXISTS "issue_goal" (
"issue_goal_id" TEXT NOT NULL PRIMARY KEY,
"goal" TEXT NOT NULL,
"issue_id" TEXT NOT NULL,
CONSTRAINT "issue_goal_issue_id_fk" FOREIGN KEY ("issue_id") REFERENCES "issue" ("issue_id"),
CONSTRAINT "issue_goal_issue_id_goal_uq" UNIQUE ("issue_id", "goal"),
CONSTRAINT "issue_goal_goal_ck" CHECK ("goal" IN ('g_1', 'g_2', 'g_3', 'g_4', 'g_5', 'g_6', 'g_7', 'g_8'))
);CREATE TABLE IF NOT EXISTS "issue_goal" (
"issue_goal_id" TEXT NOT NULL PRIMARY KEY,
"goal" TEXT NOT NULL,
"issue_id" TEXT NOT NULL,
CONSTRAINT "issue_goal_issue_id_fk" FOREIGN KEY ("issue_id") REFERENCES "issue" ("issue_id"),
CONSTRAINT "issue_goal_issue_id_goal_uq" UNIQUE ("issue_id", "goal"),
CONSTRAINT "issue_goal_goal_ck" CHECK ("goal" IN ('g_1', 'g_2', 'g_3', 'g_4', 'g_5', 'g_6', 'g_7', 'g_8'))
);Physical: the typed table
Read and written from TypeScript with the types the model gives: import { issueGoal } from "@intellectual-frontiers/data/sql/typed/models". Generated in commons/data/sql/typed/models/issues.auto.ts: do not edit.
import { from } from "@intellectual-frontiers/data/sql/typed";
import { issueGoal } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(issueGoal).select((s) => ({ issueGoalId: s.issueGoal.issueGoalId, goal: s.issueGoal.goal })).run(runner);