issueEvidenceIdidentifierrequiredWhat identifies the a piece of evidence of an issue
Becomes the column issue_evidence_id of issue_evidence.
Written at commons/data/models/issues/mod.ts:116
A piece of evidence of an issue
Model issues. Written in commons/data/models/issues/mod.ts:116. Identified by issueEvidenceId.
issueEvidenceIdidentifierrequiredWhat identifies the a piece of evidence of an issue
Becomes the column issue_evidence_id of issue_evidence.
Written at commons/data/models/issues/mod.ts:116
kindcode of issueEvidenceKindrequiredpositionintegerrequiredIts place among the evidence
Becomes the column position of issue_evidence.
Written at commons/data/models/issues/mod.ts:117
referencetextrequiredA sha, a test's file and title, a specification, a place in a file or a review
Becomes the column reference of issue_evidence.
Written at commons/data/models/issues/mod.ts:119
issueoneThe issue it is of To issue. Written at commons/data/models/issues/mod.ts:116
Projects to the table issue_evidence with the primary key issue_evidence_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
issue_evidence_id | text | false | attribute | issueEvidence.issueEvidenceId |
issue_id | text | false | reference | issueEvidence.issue |
kind | text | false | attribute | issueEvidence.kind |
position | integer | false | attribute | issueEvidence.position |
reference | text | false | attribute | issueEvidence.reference |
CREATE TABLE IF NOT EXISTS "issue_evidence" (
"issue_evidence_id" VARCHAR NOT NULL PRIMARY KEY,
"position" INTEGER NOT NULL,
"kind" VARCHAR NOT NULL,
"reference" VARCHAR NOT NULL,
"issue_id" VARCHAR NOT NULL,
CONSTRAINT "issue_evidence_issue_id_fk" FOREIGN KEY ("issue_id") REFERENCES "issue" ("issue_id"),
CONSTRAINT "issue_evidence_kind_ck" CHECK ("kind" IN ('commit', 'test', 'spec', 'file', 'review'))
);CREATE TABLE IF NOT EXISTS "issue_evidence" (
"issue_evidence_id" TEXT NOT NULL PRIMARY KEY,
"position" INTEGER NOT NULL,
"kind" TEXT NOT NULL,
"reference" TEXT NOT NULL,
"issue_id" TEXT NOT NULL,
CONSTRAINT "issue_evidence_issue_id_fk" FOREIGN KEY ("issue_id") REFERENCES "issue" ("issue_id"),
CONSTRAINT "issue_evidence_kind_ck" CHECK ("kind" IN ('commit', 'test', 'spec', 'file', 'review'))
);CREATE TABLE IF NOT EXISTS "issue_evidence" (
"issue_evidence_id" TEXT NOT NULL PRIMARY KEY,
"position" INTEGER NOT NULL,
"kind" TEXT NOT NULL,
"reference" TEXT NOT NULL,
"issue_id" TEXT NOT NULL,
CONSTRAINT "issue_evidence_issue_id_fk" FOREIGN KEY ("issue_id") REFERENCES "issue" ("issue_id"),
CONSTRAINT "issue_evidence_kind_ck" CHECK ("kind" IN ('commit', 'test', 'spec', 'file', 'review'))
);Read and written from TypeScript with the types the model gives: import { issueEvidence } 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 { issueEvidence } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(issueEvidence).select((s) => ({ issueEvidenceId: s.issueEvidence.issueEvidenceId, position: s.issueEvidence.position })).run(runner);