IF Commons GitHub

issueEngine

concept

An engine an issue is about

Model issues. Written in commons/data/models/issues/mod.ts:114. Identified by issueEngineId.

Governance: attributes

enginetextrequired

The engine, as a dialect is named

Becomes the column engine of issue_engine.

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

issueEngineIdidentifierrequired

What identifies the an engine an issue is about

Becomes the column issue_engine_id of issue_engine.

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

Governance: relationships

issueone

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

Logical: the table

Projects to the table issue_engine with the primary key issue_engine_id.

ColumnTypeNullRoleFrom
enginetextfalseattributeissueEngine.engine
issue_engine_idtextfalseattributeissueEngine.issueEngineId
issue_idtextfalsereferenceissueEngine.issue

Physical: SQL

CREATE TABLE IF NOT EXISTS "issue_engine" (
    "issue_engine_id" VARCHAR NOT NULL PRIMARY KEY,
    "engine" VARCHAR NOT NULL,
    "issue_id" VARCHAR NOT NULL,
    CONSTRAINT "issue_engine_issue_id_fk" FOREIGN KEY ("issue_id") REFERENCES "issue" ("issue_id"),
    CONSTRAINT "issue_engine_issue_id_engine_uq" UNIQUE ("issue_id", "engine")
);

Physical: the typed table

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

const rows = await from(issueEngine).select((s) => ({ issueEngineId: s.issueEngine.issueEngineId, engine: s.issueEngine.engine })).run(runner);

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