appliesToAllbooleanrequiredWhether it is about every engine; where not, the engines are listed
Becomes the column applies_to_all of issue.
Written at commons/data/models/issues/mod.ts:91
One known weakness of a library or a module, as the code of the repository says it
Model issues. Written in commons/data/models/issues/mod.ts:75. Identified by issueId.
appliesToAllbooleanrequiredWhether it is about every engine; where not, the engines are listed
Becomes the column applies_to_all of issue.
Written at commons/data/models/issues/mod.ts:91
contentHashtextrequiredA hash of what the code says of it, so that a change is seen
Becomes the column content_hash of issue.
Written at commons/data/models/issues/mod.ts:93
duplicateOfintegeroptionalThe number of the issue it duplicates
Becomes the column duplicate_of of issue.
Written at commons/data/models/issues/mod.ts:90
issueIdidentifierrequiredWhat identifies the issue: its scope and number
Becomes the column issue_id of issue.
Written at commons/data/models/issues/mod.ts:78
numberintegerrequiredIts number within the scope
Becomes the column number of issue.
Written at commons/data/models/issues/mod.ts:80
presencecode of issuePresencerequiredWhether the code still has it
Becomes the column presence of issue.
Written at commons/data/models/issues/mod.ts:94
prioritycode of issuePriorityrequiredWhen it is to be done
Becomes the column priority of issue.
Written at commons/data/models/issues/mod.ts:85
raisedtextrequiredThe day it was raised
Becomes the column raised of issue.
Written at commons/data/models/issues/mod.ts:92
scopetextrequiredThe library or module it is of, by its path
Becomes the column scope of issue.
Written at commons/data/models/issues/mod.ts:79
severitycode of issueSeverityrequiredsizecode of issueSizerequiredHow much work the fix is
Becomes the column size of issue.
Written at commons/data/models/issues/mod.ts:86
slugtextrequiredIts name in words joined by hyphens
Becomes the column slug of issue.
Written at commons/data/models/issues/mod.ts:81
statusKindcode of issueStatusKindrequiredstatusProoftextoptionalWhat shows it is done, for one that is fixed
Becomes the column status_proof of issue.
Written at commons/data/models/issues/mod.ts:89
statusReasontextoptionalWhy, for a status that needs a reason
Becomes the column status_reason of issue.
Written at commons/data/models/issues/mod.ts:88
summarytextrequiredWhat is wrong and why it matters
Becomes the column summary of issue.
Written at commons/data/models/issues/mod.ts:83
syncedAtinstantrequiredWhen a synchronisation last wrote it
Becomes the column synced_at of issue.
Written at commons/data/models/issues/mod.ts:95
titletextrequiredWhat it is, in a line
Becomes the column title of issue.
Written at commons/data/models/issues/mod.ts:82
Projects to the table issue with the primary key issue_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
applies_to_all | boolean | false | attribute | issue.appliesToAll |
content_hash | text | false | attribute | issue.contentHash |
duplicate_of | integer | true | attribute | issue.duplicateOf |
issue_id | text | false | attribute | issue.issueId |
number | integer | false | attribute | issue.number |
presence | text | false | attribute | issue.presence |
priority | text | false | attribute | issue.priority |
raised | text | false | attribute | issue.raised |
scope | text | false | attribute | issue.scope |
severity | text | false | attribute | issue.severity |
size | text | false | attribute | issue.size |
slug | text | false | attribute | issue.slug |
status_kind | text | false | attribute | issue.statusKind |
status_proof | text | true | attribute | issue.statusProof |
status_reason | text | true | attribute | issue.statusReason |
summary | text | false | attribute | issue.summary |
synced_at | timestamp | false | attribute | issue.syncedAt |
title | text | false | attribute | issue.title |
CREATE TABLE IF NOT EXISTS "issue" (
"issue_id" VARCHAR NOT NULL PRIMARY KEY,
"scope" VARCHAR NOT NULL,
"number" INTEGER NOT NULL,
"slug" VARCHAR NOT NULL,
"title" VARCHAR NOT NULL,
"summary" VARCHAR NOT NULL,
"severity" VARCHAR NOT NULL,
"priority" VARCHAR NOT NULL,
"size" VARCHAR NOT NULL,
"status_kind" VARCHAR NOT NULL,
"status_reason" VARCHAR,
"status_proof" VARCHAR,
"duplicate_of" INTEGER,
"applies_to_all" BOOLEAN NOT NULL,
"raised" VARCHAR NOT NULL,
"content_hash" VARCHAR NOT NULL,
"presence" VARCHAR NOT NULL,
"synced_at" TIMESTAMPTZ NOT NULL,
CONSTRAINT "issue_scope_number_uq" UNIQUE ("scope", "number"),
CONSTRAINT "issue_severity_ck" CHECK ("severity" IN ('critical', 'high', 'medium', 'low')),
CONSTRAINT "issue_priority_ck" CHECK ("priority" IN ('p_1', 'p_2', 'p_3')),
CONSTRAINT "issue_size_ck" CHECK ("size" IN ('xs', 's', 'm', 'l', 'xl')),
CONSTRAINT "issue_status_kind_ck" CHECK ("status_kind" IN ('open', 'in_progress', 'fixed', 'wont_fix', 'not_a_defect', 'duplicate', 'deferred')),
CONSTRAINT "issue_presence_ck" CHECK ("presence" IN ('present', 'withdrawn'))
);CREATE TABLE IF NOT EXISTS "issue" (
"issue_id" TEXT NOT NULL PRIMARY KEY,
"scope" TEXT NOT NULL,
"number" INTEGER NOT NULL,
"slug" TEXT NOT NULL,
"title" TEXT NOT NULL,
"summary" TEXT NOT NULL,
"severity" TEXT NOT NULL,
"priority" TEXT NOT NULL,
"size" TEXT NOT NULL,
"status_kind" TEXT NOT NULL,
"status_reason" TEXT,
"status_proof" TEXT,
"duplicate_of" INTEGER,
"applies_to_all" BOOLEAN NOT NULL,
"raised" TEXT NOT NULL,
"content_hash" TEXT NOT NULL,
"presence" TEXT NOT NULL,
"synced_at" TIMESTAMPTZ NOT NULL,
CONSTRAINT "issue_scope_number_uq" UNIQUE ("scope", "number"),
CONSTRAINT "issue_severity_ck" CHECK ("severity" IN ('critical', 'high', 'medium', 'low')),
CONSTRAINT "issue_priority_ck" CHECK ("priority" IN ('p_1', 'p_2', 'p_3')),
CONSTRAINT "issue_size_ck" CHECK ("size" IN ('xs', 's', 'm', 'l', 'xl')),
CONSTRAINT "issue_status_kind_ck" CHECK ("status_kind" IN ('open', 'in_progress', 'fixed', 'wont_fix', 'not_a_defect', 'duplicate', 'deferred')),
CONSTRAINT "issue_presence_ck" CHECK ("presence" IN ('present', 'withdrawn'))
);CREATE TABLE IF NOT EXISTS "issue" (
"issue_id" TEXT NOT NULL PRIMARY KEY,
"scope" TEXT NOT NULL,
"number" INTEGER NOT NULL,
"slug" TEXT NOT NULL,
"title" TEXT NOT NULL,
"summary" TEXT NOT NULL,
"severity" TEXT NOT NULL,
"priority" TEXT NOT NULL,
"size" TEXT NOT NULL,
"status_kind" TEXT NOT NULL,
"status_reason" TEXT,
"status_proof" TEXT,
"duplicate_of" INTEGER,
"applies_to_all" INTEGER NOT NULL,
"raised" TEXT NOT NULL,
"content_hash" TEXT NOT NULL,
"presence" TEXT NOT NULL,
"synced_at" TEXT NOT NULL,
CONSTRAINT "issue_scope_number_uq" UNIQUE ("scope", "number"),
CONSTRAINT "issue_severity_ck" CHECK ("severity" IN ('critical', 'high', 'medium', 'low')),
CONSTRAINT "issue_priority_ck" CHECK ("priority" IN ('p_1', 'p_2', 'p_3')),
CONSTRAINT "issue_size_ck" CHECK ("size" IN ('xs', 's', 'm', 'l', 'xl')),
CONSTRAINT "issue_status_kind_ck" CHECK ("status_kind" IN ('open', 'in_progress', 'fixed', 'wont_fix', 'not_a_defect', 'duplicate', 'deferred')),
CONSTRAINT "issue_presence_ck" CHECK ("presence" IN ('present', 'withdrawn'))
);Read and written from TypeScript with the types the model gives: import { issue } 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 { issue } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(issue).select((s) => ({ issueId: s.issue.issueId, scope: s.issue.scope })).run(runner);