attributeNamestextrequiredThe attributes it carries, separated by commas
Becomes the column attribute_names of signal.
Written at commons/data/models/operations/mod.ts:157
A measurement the platform emits: its name, its kind, its unit and the attributes it carries, so that every emitter and every alert agree on what it is
Model operations. Written in commons/data/models/operations/mod.ts:157. Identified by signalId.
attributeNamestextrequiredThe attributes it carries, separated by commas
Becomes the column attribute_names of signal.
Written at commons/data/models/operations/mod.ts:157
kindcode of signalKindrequiredWhat kind of measurement
Becomes the column kind of signal.
Written at commons/data/models/operations/mod.ts:157
meaningtextrequiredWhat it measures
Becomes the column meaning of signal.
Written at commons/data/models/operations/mod.ts:157
ownertextrequiredWho answers for it
Becomes the column owner of signal.
Written at commons/data/models/operations/mod.ts:157
signalIdidentifierrequiredWhat identifies the signal: its name
Becomes the column signal_id of signal.
Written at commons/data/models/operations/mod.ts:157
unittextrequiredProjects to the table signal with the primary key signal_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
attribute_names | text | false | attribute | signal.attributeNames |
kind | text | false | attribute | signal.kind |
meaning | text | false | attribute | signal.meaning |
owner | text | false | attribute | signal.owner |
signal_id | text | false | attribute | signal.signalId |
unit | text | false | attribute | signal.unit |
CREATE TABLE IF NOT EXISTS "signal" (
"signal_id" VARCHAR NOT NULL PRIMARY KEY,
"kind" VARCHAR NOT NULL,
"unit" VARCHAR NOT NULL,
"attribute_names" VARCHAR NOT NULL,
"meaning" VARCHAR NOT NULL,
"owner" VARCHAR NOT NULL,
CONSTRAINT "signal_kind_ck" CHECK ("kind" IN ('counter', 'gauge', 'histogram', 'event'))
);CREATE TABLE IF NOT EXISTS "signal" (
"signal_id" TEXT NOT NULL PRIMARY KEY,
"kind" TEXT NOT NULL,
"unit" TEXT NOT NULL,
"attribute_names" TEXT NOT NULL,
"meaning" TEXT NOT NULL,
"owner" TEXT NOT NULL,
CONSTRAINT "signal_kind_ck" CHECK ("kind" IN ('counter', 'gauge', 'histogram', 'event'))
);CREATE TABLE IF NOT EXISTS "signal" (
"signal_id" TEXT NOT NULL PRIMARY KEY,
"kind" TEXT NOT NULL,
"unit" TEXT NOT NULL,
"attribute_names" TEXT NOT NULL,
"meaning" TEXT NOT NULL,
"owner" TEXT NOT NULL,
CONSTRAINT "signal_kind_ck" CHECK ("kind" IN ('counter', 'gauge', 'histogram', 'event'))
);Read and written from TypeScript with the types the model gives: import { signal } 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 { signal } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(signal).select((s) => ({ signalId: s.signal.signalId, kind: s.signal.kind })).run(runner);