holdsRealDatabooleanrequiredWhether it holds real data
Becomes the column holds_real_data of runtime_environment.
Written at commons/data/models/operations/mod.ts:112
An environment a release is promoted through, what it is for, whether it holds real data and who answers for it
Model operations. Written in commons/data/models/operations/mod.ts:112. Identified by runtimeEnvironmentId.
holdsRealDatabooleanrequiredWhether it holds real data
Becomes the column holds_real_data of runtime_environment.
Written at commons/data/models/operations/mod.ts:112
kindcode of environmentKindrequiredWhat it is for
Becomes the column kind of runtime_environment.
Written at commons/data/models/operations/mod.ts:112
nametextrequiredIts name
Becomes the column name of runtime_environment.
Written at commons/data/models/operations/mod.ts:176
ownertextrequiredWho answers for it
Becomes the column owner of runtime_environment.
Written at commons/data/models/operations/mod.ts:112
runtimeEnvironmentIdidentifierrequiredWhat identifies the environment
Becomes the column runtime_environment_id of runtime_environment.
Written at commons/data/models/operations/mod.ts:112
Projects to the table runtime_environment with the primary key runtime_environment_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
holds_real_data | boolean | false | attribute | runtimeEnvironment.holdsRealData |
kind | text | false | attribute | runtimeEnvironment.kind |
name | text | false | attribute | runtimeEnvironment.name |
owner | text | false | attribute | runtimeEnvironment.owner |
runtime_environment_id | text | false | attribute | runtimeEnvironment.runtimeEnvironmentId |
CREATE TABLE IF NOT EXISTS "runtime_environment" (
"runtime_environment_id" VARCHAR NOT NULL PRIMARY KEY,
"name" VARCHAR NOT NULL,
"kind" VARCHAR NOT NULL,
"holds_real_data" BOOLEAN NOT NULL,
"owner" VARCHAR NOT NULL,
CONSTRAINT "runtime_environment_name_uq" UNIQUE ("name"),
CONSTRAINT "runtime_environment_kind_ck" CHECK ("kind" IN ('development', 'test', 'staging', 'production'))
);CREATE TABLE IF NOT EXISTS "runtime_environment" (
"runtime_environment_id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"kind" TEXT NOT NULL,
"holds_real_data" BOOLEAN NOT NULL,
"owner" TEXT NOT NULL,
CONSTRAINT "runtime_environment_name_uq" UNIQUE ("name"),
CONSTRAINT "runtime_environment_kind_ck" CHECK ("kind" IN ('development', 'test', 'staging', 'production'))
);CREATE TABLE IF NOT EXISTS "runtime_environment" (
"runtime_environment_id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"kind" TEXT NOT NULL,
"holds_real_data" INTEGER NOT NULL,
"owner" TEXT NOT NULL,
CONSTRAINT "runtime_environment_name_uq" UNIQUE ("name"),
CONSTRAINT "runtime_environment_kind_ck" CHECK ("kind" IN ('development', 'test', 'staging', 'production'))
);Read and written from TypeScript with the types the model gives: import { runtimeEnvironment } from "@intellectual-frontiers/data/sql/typed/models". Generated in commons/data/sql/typed/models/operations.auto.ts: do not edit.
import { from } from "@intellectual-frontiers/data/sql/typed";
import { runtimeEnvironment } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(runtimeEnvironment).select((s) => ({ runtimeEnvironmentId: s.runtimeEnvironment.runtimeEnvironmentId, name: s.runtimeEnvironment.name })).run(runner);