IF Commons GitHub

issueEvidence

concept

A piece of evidence of an issue

Model issues. Written in commons/data/models/issues/mod.ts:116. Identified by issueEvidenceId.

Governance: attributes

issueEvidenceIdidentifierrequired

What 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 issueEvidenceKindrequired

What kind

Becomes the column kind of issue_evidence.

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

positionintegerrequired

Its place among the evidence

Becomes the column position of issue_evidence.

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

referencetextrequired

A 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

Governance: relationships

issueone

The issue it is of To issue. Written at commons/data/models/issues/mod.ts:116

Logical: the table

Projects to the table issue_evidence with the primary key issue_evidence_id.

ColumnTypeNullRoleFrom
issue_evidence_idtextfalseattributeissueEvidence.issueEvidenceId
issue_idtextfalsereferenceissueEvidence.issue
kindtextfalseattributeissueEvidence.kind
positionintegerfalseattributeissueEvidence.position
referencetextfalseattributeissueEvidence.reference

Physical: SQL

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

Physical: the typed table

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

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