dataContractIdidentifierrequiredWhat identifies the contract: its dataset and version
Becomes the column data_contract_id of data_contract.
Written at commons/data/models/contract/mod.ts:59
What a dataset promises to those who read it, in one version: its owner, its status and the dates between which the version holds; its fields are the fields of the contract
Model contract. Written in commons/data/models/contract/mod.ts:56. Identified by dataContractId.
dataContractIdidentifierrequiredWhat identifies the contract: its dataset and version
Becomes the column data_contract_id of data_contract.
Written at commons/data/models/contract/mod.ts:59
datasettextrequiredThe dataset it is of
Becomes the column dataset of data_contract.
Written at commons/data/models/contract/mod.ts:60
ownertextrequiredWho answers for it
Becomes the column owner of data_contract.
Written at commons/data/models/contract/mod.ts:63
statuscode of contractStatusrequiredWhere it is
Becomes the column status of data_contract.
Written at commons/data/models/contract/mod.ts:62
validFrominstantrequiredFrom when it holds
Becomes the column valid_from of data_contract.
Written at commons/data/models/contract/mod.ts:64
validToinstantoptionalUntil when it holds, where it ends
Becomes the column valid_to of data_contract.
Written at commons/data/models/contract/mod.ts:65
versiontextrequiredThe version of the contract, as major.minor.patch
Becomes the column version of data_contract.
Written at commons/data/models/contract/mod.ts:61
Projects to the table data_contract with the primary key data_contract_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
data_contract_id | text | false | attribute | dataContract.dataContractId |
dataset | text | false | attribute | dataContract.dataset |
owner | text | false | attribute | dataContract.owner |
status | text | false | attribute | dataContract.status |
valid_from | timestamp | false | attribute | dataContract.validFrom |
valid_to | timestamp | true | attribute | dataContract.validTo |
version | text | false | attribute | dataContract.version |
CREATE TABLE IF NOT EXISTS "data_contract" (
"data_contract_id" VARCHAR NOT NULL PRIMARY KEY,
"dataset" VARCHAR NOT NULL,
"version" VARCHAR NOT NULL,
"status" VARCHAR NOT NULL,
"owner" VARCHAR NOT NULL,
"valid_from" TIMESTAMPTZ NOT NULL,
"valid_to" TIMESTAMPTZ,
CONSTRAINT "data_contract_dataset_version_uq" UNIQUE ("dataset", "version"),
CONSTRAINT "data_contract_status_ck" CHECK ("status" IN ('draft', 'active', 'deprecated', 'retired'))
);CREATE TABLE IF NOT EXISTS "data_contract" (
"data_contract_id" TEXT NOT NULL PRIMARY KEY,
"dataset" TEXT NOT NULL,
"version" TEXT NOT NULL,
"status" TEXT NOT NULL,
"owner" TEXT NOT NULL,
"valid_from" TIMESTAMPTZ NOT NULL,
"valid_to" TIMESTAMPTZ,
CONSTRAINT "data_contract_dataset_version_uq" UNIQUE ("dataset", "version"),
CONSTRAINT "data_contract_status_ck" CHECK ("status" IN ('draft', 'active', 'deprecated', 'retired'))
);CREATE TABLE IF NOT EXISTS "data_contract" (
"data_contract_id" TEXT NOT NULL PRIMARY KEY,
"dataset" TEXT NOT NULL,
"version" TEXT NOT NULL,
"status" TEXT NOT NULL,
"owner" TEXT NOT NULL,
"valid_from" TEXT NOT NULL,
"valid_to" TEXT,
CONSTRAINT "data_contract_dataset_version_uq" UNIQUE ("dataset", "version"),
CONSTRAINT "data_contract_status_ck" CHECK ("status" IN ('draft', 'active', 'deprecated', 'retired'))
);Read and written from TypeScript with the types the model gives: import { dataContract } from "@intellectual-frontiers/data/sql/typed/models". Generated in commons/data/sql/typed/models/contract.auto.ts: do not edit.
import { from } from "@intellectual-frontiers/data/sql/typed";
import { dataContract } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(dataContract).select((s) => ({ dataContractId: s.dataContract.dataContractId, dataset: s.dataContract.dataset })).run(runner);