IF Commons GitHub

runtimeEnvironment

concept

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.

Governance: attributes

holdsRealDatabooleanrequired

Whether it holds real data

Becomes the column holds_real_data of runtime_environment.

Written at commons/data/models/operations/mod.ts:112

kindcode of environmentKindrequired

What it is for

Becomes the column kind of runtime_environment.

Written at commons/data/models/operations/mod.ts:112

nametextrequired

Its name

Becomes the column name of runtime_environment.

Written at commons/data/models/operations/mod.ts:176

ownertextrequired

Who answers for it

Becomes the column owner of runtime_environment.

Written at commons/data/models/operations/mod.ts:112

runtimeEnvironmentIdidentifierrequired

What identifies the environment

Becomes the column runtime_environment_id of runtime_environment.

Written at commons/data/models/operations/mod.ts:112

Logical: the table

Projects to the table runtime_environment with the primary key runtime_environment_id.

ColumnTypeNullRoleFrom
holds_real_databooleanfalseattributeruntimeEnvironment.holdsRealData
kindtextfalseattributeruntimeEnvironment.kind
nametextfalseattributeruntimeEnvironment.name
ownertextfalseattributeruntimeEnvironment.owner
runtime_environment_idtextfalseattributeruntimeEnvironment.runtimeEnvironmentId

Physical: SQL

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

Physical: the typed table

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

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