manifestCountintegerrequiredHow many entities the sender says it sent
Becomes the column manifest_count of manifest.
Written at commons/data/models/flow/mod.ts:167
What a sender says a batch holds: the count to be accounted for, from which every stage and every loss is reconciled
Model flow. Written in commons/data/models/flow/mod.ts:167. Identified by manifestId.
manifestCountintegerrequiredHow many entities the sender says it sent
Becomes the column manifest_count of manifest.
Written at commons/data/models/flow/mod.ts:167
manifestIdidentifierrequiredWhat identifies the batch
Becomes the column manifest_id of manifest.
Written at commons/data/models/flow/mod.ts:167
periodtextoptionalThe period it covers
Becomes the column period of manifest.
Written at commons/data/models/flow/mod.ts:167
sourcetextrequiredloadoneThe load that carried it To load. Written at commons/data/models/flow/mod.ts:167
Projects to the table manifest with the primary key manifest_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
load_id | text | false | reference | manifest.load |
manifest_count | integer | false | attribute | manifest.manifestCount |
manifest_id | text | false | attribute | manifest.manifestId |
period | text | true | attribute | manifest.period |
source | text | false | attribute | manifest.source |
CREATE TABLE IF NOT EXISTS "manifest" (
"manifest_id" VARCHAR NOT NULL PRIMARY KEY,
"source" VARCHAR NOT NULL,
"period" VARCHAR,
"manifest_count" INTEGER NOT NULL,
"load_id" VARCHAR NOT NULL,
CONSTRAINT "manifest_load_id_fk" FOREIGN KEY ("load_id") REFERENCES "load" ("load_id")
);CREATE TABLE IF NOT EXISTS "manifest" (
"manifest_id" TEXT NOT NULL PRIMARY KEY,
"source" TEXT NOT NULL,
"period" TEXT,
"manifest_count" INTEGER NOT NULL,
"load_id" TEXT NOT NULL,
CONSTRAINT "manifest_load_id_fk" FOREIGN KEY ("load_id") REFERENCES "load" ("load_id")
);CREATE TABLE IF NOT EXISTS "manifest" (
"manifest_id" TEXT NOT NULL PRIMARY KEY,
"source" TEXT NOT NULL,
"period" TEXT,
"manifest_count" INTEGER NOT NULL,
"load_id" TEXT NOT NULL,
CONSTRAINT "manifest_load_id_fk" FOREIGN KEY ("load_id") REFERENCES "load" ("load_id")
);Read and written from TypeScript with the types the model gives: import { manifest } from "@intellectual-frontiers/data/sql/typed/models". Generated in commons/data/sql/typed/models/flow.auto.ts: do not edit.
import { from } from "@intellectual-frontiers/data/sql/typed";
import { manifest } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(manifest).select((s) => ({ manifestId: s.manifest.manifestId, source: s.manifest.source })).run(runner);