enginetextrequiredThe engine, as a dialect is named
Becomes the column engine of issue_engine.
Written at commons/data/models/issues/mod.ts:114
An engine an issue is about
Model issues. Written in commons/data/models/issues/mod.ts:114. Identified by issueEngineId.
enginetextrequiredThe engine, as a dialect is named
Becomes the column engine of issue_engine.
Written at commons/data/models/issues/mod.ts:114
issueEngineIdidentifierrequiredWhat 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
issueoneThe issue it is of To issue. Written at commons/data/models/issues/mod.ts:114
Projects to the table issue_engine with the primary key issue_engine_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
engine | text | false | attribute | issueEngine.engine |
issue_engine_id | text | false | attribute | issueEngine.issueEngineId |
issue_id | text | false | reference | issueEngine.issue |
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")
);CREATE TABLE IF NOT EXISTS "issue_engine" (
"issue_engine_id" TEXT NOT NULL PRIMARY KEY,
"engine" TEXT NOT NULL,
"issue_id" TEXT 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")
);CREATE TABLE IF NOT EXISTS "issue_engine" (
"issue_engine_id" TEXT NOT NULL PRIMARY KEY,
"engine" TEXT NOT NULL,
"issue_id" TEXT 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")
);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);