IF Commons GitHub

issueLink

concept

How an issue is related to another of its scope

Model issues. Written in commons/data/models/issues/mod.ts:122. Identified by issueLinkId.

Governance: attributes

issueLinkIdidentifierrequired

What identifies the link

Becomes the column issue_link_id of issue_link.

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

kindcode of issueLinkKindrequired

How they are related

Becomes the column kind of issue_link.

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

Governance: relationships

issueone

The issue To issue. Written at commons/data/models/issues/mod.ts:122

targetone

The issue it is related to To issue. Written at commons/data/models/issues/mod.ts:122

Logical: the table

Projects to the table issue_link with the primary key issue_link_id.

ColumnTypeNullRoleFrom
issue_idtextfalsereferenceissueLink.issue
issue_link_idtextfalseattributeissueLink.issueLinkId
kindtextfalseattributeissueLink.kind
target_issue_idtextfalsereferenceissueLink.target

Physical: SQL

CREATE TABLE IF NOT EXISTS "issue_link" (
    "issue_link_id" VARCHAR NOT NULL PRIMARY KEY,
    "kind" VARCHAR NOT NULL,
    "issue_id" VARCHAR NOT NULL,
    "target_issue_id" VARCHAR NOT NULL,
    CONSTRAINT "issue_link_issue_id_fk" FOREIGN KEY ("issue_id") REFERENCES "issue" ("issue_id"),
    CONSTRAINT "issue_link_target_issue_id_fk" FOREIGN KEY ("target_issue_id") REFERENCES "issue" ("issue_id"),
    CONSTRAINT "issue_link_kind_ck" CHECK ("kind" IN ('blocks', 'relates', 'caused_by'))
);

Physical: the typed table

Read and written from TypeScript with the types the model gives: import { issueLink } 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 { issueLink } from "@intellectual-frontiers/data/sql/typed/models";

const rows = await from(issueLink).select((s) => ({ issueLinkId: s.issueLink.issueLinkId, kind: s.issueLink.kind })).run(runner);

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