classificationtextrequiredHow sensitive it is
Becomes the column classification of data_copy.
Written at commons/data/models/operations/mod.ts:103
A copy of a dataset in a place, with why it exists, who answers for it and when it was last refreshed: what makes the copies of the data known and not only the original
Model operations. Written in commons/data/models/operations/mod.ts:103. Identified by dataCopyId.
classificationtextrequiredHow sensitive it is
Becomes the column classification of data_copy.
Written at commons/data/models/operations/mod.ts:103
dataCopyIdidentifierrequiredWhat identifies the copy
Becomes the column data_copy_id of data_copy.
Written at commons/data/models/operations/mod.ts:103
datasettextrequiredThe dataset it is a copy of
Becomes the column dataset of data_copy.
Written at commons/data/models/operations/mod.ts:103
locationtextrequiredWhere it is
Becomes the column location of data_copy.
Written at commons/data/models/operations/mod.ts:103
ownertextoptionalWho answers for it
Becomes the column owner of data_copy.
Written at commons/data/models/operations/mod.ts:103
purposetextrequiredWhy it exists
Becomes the column purpose of data_copy.
Written at commons/data/models/operations/mod.ts:103
refreshedAtinstantoptionalWhen it was last refreshed
Becomes the column refreshed_at of data_copy.
Written at commons/data/models/operations/mod.ts:103
Projects to the table data_copy with the primary key data_copy_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
classification | text | false | attribute | dataCopy.classification |
data_copy_id | text | false | attribute | dataCopy.dataCopyId |
dataset | text | false | attribute | dataCopy.dataset |
location | text | false | attribute | dataCopy.location |
owner | text | true | attribute | dataCopy.owner |
purpose | text | false | attribute | dataCopy.purpose |
refreshed_at | timestamp | true | attribute | dataCopy.refreshedAt |
CREATE TABLE IF NOT EXISTS "data_copy" (
"data_copy_id" VARCHAR NOT NULL PRIMARY KEY,
"dataset" VARCHAR NOT NULL,
"location" VARCHAR NOT NULL,
"purpose" VARCHAR NOT NULL,
"owner" VARCHAR,
"classification" VARCHAR NOT NULL,
"refreshed_at" TIMESTAMPTZ
);CREATE TABLE IF NOT EXISTS "data_copy" (
"data_copy_id" TEXT NOT NULL PRIMARY KEY,
"dataset" TEXT NOT NULL,
"location" TEXT NOT NULL,
"purpose" TEXT NOT NULL,
"owner" TEXT,
"classification" TEXT NOT NULL,
"refreshed_at" TIMESTAMPTZ
);CREATE TABLE IF NOT EXISTS "data_copy" (
"data_copy_id" TEXT NOT NULL PRIMARY KEY,
"dataset" TEXT NOT NULL,
"location" TEXT NOT NULL,
"purpose" TEXT NOT NULL,
"owner" TEXT,
"classification" TEXT NOT NULL,
"refreshed_at" TEXT
);Read and written from TypeScript with the types the model gives: import { dataCopy } 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 { dataCopy } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(dataCopy).select((s) => ({ dataCopyId: s.dataCopy.dataCopyId, dataset: s.dataCopy.dataset })).run(runner);