fromDatasettextrequiredThe dataset it is made from
Becomes the column from_dataset of lineage_edge.
Written at commons/data/models/proof/mod.ts:106
A dataset that another is made from, by which transform, so that what a change reaches and what a figure came from can both be found
Model proof. Written in commons/data/models/proof/mod.ts:106. Identified by lineageEdgeId.
fromDatasettextrequiredThe dataset it is made from
Becomes the column from_dataset of lineage_edge.
Written at commons/data/models/proof/mod.ts:106
lineageEdgeIdidentifierrequiredWhat identifies the edge
Becomes the column lineage_edge_id of lineage_edge.
Written at commons/data/models/proof/mod.ts:106
toDatasettextrequiredThe dataset that is made
Becomes the column to_dataset of lineage_edge.
Written at commons/data/models/proof/mod.ts:106
viatextrequiredThe transform or workload that makes it
Becomes the column via of lineage_edge.
Written at commons/data/models/proof/mod.ts:106
Projects to the table lineage_edge with the primary key lineage_edge_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
from_dataset | text | false | attribute | lineageEdge.fromDataset |
lineage_edge_id | text | false | attribute | lineageEdge.lineageEdgeId |
to_dataset | text | false | attribute | lineageEdge.toDataset |
via | text | false | attribute | lineageEdge.via |
CREATE TABLE IF NOT EXISTS "lineage_edge" (
"lineage_edge_id" VARCHAR NOT NULL PRIMARY KEY,
"from_dataset" VARCHAR NOT NULL,
"to_dataset" VARCHAR NOT NULL,
"via" VARCHAR NOT NULL,
CONSTRAINT "lineage_edge_from_dataset_to_dataset_via_uq" UNIQUE ("from_dataset", "to_dataset", "via")
);CREATE TABLE IF NOT EXISTS "lineage_edge" (
"lineage_edge_id" TEXT NOT NULL PRIMARY KEY,
"from_dataset" TEXT NOT NULL,
"to_dataset" TEXT NOT NULL,
"via" TEXT NOT NULL,
CONSTRAINT "lineage_edge_from_dataset_to_dataset_via_uq" UNIQUE ("from_dataset", "to_dataset", "via")
);CREATE TABLE IF NOT EXISTS "lineage_edge" (
"lineage_edge_id" TEXT NOT NULL PRIMARY KEY,
"from_dataset" TEXT NOT NULL,
"to_dataset" TEXT NOT NULL,
"via" TEXT NOT NULL,
CONSTRAINT "lineage_edge_from_dataset_to_dataset_via_uq" UNIQUE ("from_dataset", "to_dataset", "via")
);Read and written from TypeScript with the types the model gives: import { lineageEdge } from "@intellectual-frontiers/data/sql/typed/models". Generated in commons/data/sql/typed/models/proof.auto.ts: do not edit.
import { from } from "@intellectual-frontiers/data/sql/typed";
import { lineageEdge } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(lineageEdge).select((s) => ({ lineageEdgeId: s.lineageEdge.lineageEdgeId, fromDataset: s.lineageEdge.fromDataset })).run(runner);