IF Commons GitHub

issueGoal

concept

A goal an issue is held against

Model issues. Written in commons/data/models/issues/mod.ts:112. Identified by issueGoalId.

Governance: attributes

goalcode of issueGoalrequired

The goal

Becomes the column goal of issue_goal.

Written at commons/data/models/issues/mod.ts:112

issueGoalIdidentifierrequired

What 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

issueone

The 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.

ColumnTypeNullRoleFrom
goaltextfalseattributeissueGoal.goal
issue_goal_idtextfalseattributeissueGoal.issueGoalId
issue_idtextfalsereferenceissueGoal.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'))
);

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

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