issueLinkIdidentifierrequiredWhat identifies the link
Becomes the column issue_link_id of issue_link.
Written at commons/data/models/issues/mod.ts:122
How an issue is related to another of its scope
Model issues. Written in commons/data/models/issues/mod.ts:122. Identified by issueLinkId.
issueLinkIdidentifierrequiredWhat identifies the link
Becomes the column issue_link_id of issue_link.
Written at commons/data/models/issues/mod.ts:122
kindcode of issueLinkKindrequiredHow they are related
Becomes the column kind of issue_link.
Written at commons/data/models/issues/mod.ts:122
issueoneThe issue To issue. Written at commons/data/models/issues/mod.ts:122
targetoneThe issue it is related to To issue. Written at commons/data/models/issues/mod.ts:122
Projects to the table issue_link with the primary key issue_link_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
issue_id | text | false | reference | issueLink.issue |
issue_link_id | text | false | attribute | issueLink.issueLinkId |
kind | text | false | attribute | issueLink.kind |
target_issue_id | text | false | reference | issueLink.target |
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'))
);CREATE TABLE IF NOT EXISTS "issue_link" (
"issue_link_id" TEXT NOT NULL PRIMARY KEY,
"kind" TEXT NOT NULL,
"issue_id" TEXT NOT NULL,
"target_issue_id" TEXT 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'))
);CREATE TABLE IF NOT EXISTS "issue_link" (
"issue_link_id" TEXT NOT NULL PRIMARY KEY,
"kind" TEXT NOT NULL,
"issue_id" TEXT NOT NULL,
"target_issue_id" TEXT 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'))
);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);