IF Commons GitHub

lineageEdge

concept

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.

Governance: attributes

fromDatasettextrequired

The dataset it is made from

Becomes the column from_dataset of lineage_edge.

Written at commons/data/models/proof/mod.ts:106

lineageEdgeIdidentifierrequired

What identifies the edge

Becomes the column lineage_edge_id of lineage_edge.

Written at commons/data/models/proof/mod.ts:106

toDatasettextrequired

The dataset that is made

Becomes the column to_dataset of lineage_edge.

Written at commons/data/models/proof/mod.ts:106

viatextrequired

The transform or workload that makes it

Becomes the column via of lineage_edge.

Written at commons/data/models/proof/mod.ts:106

Logical: the table

Projects to the table lineage_edge with the primary key lineage_edge_id.

ColumnTypeNullRoleFrom
from_datasettextfalseattributelineageEdge.fromDataset
lineage_edge_idtextfalseattributelineageEdge.lineageEdgeId
to_datasettextfalseattributelineageEdge.toDataset
viatextfalseattributelineageEdge.via

Physical: SQL

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

Physical: the typed table

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

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