contentSha256textrequiredThe SHA-256 of its content, as first delivered
Becomes the column content_sha_256 of delivery.
Written at commons/data/models/flow/mod.ts:143
A message as it first arrived, with the hash of its content and how many times it has been delivered: the intake that makes a redelivery safe
Model flow. Written in commons/data/models/flow/mod.ts:137. Identified by deliveryId.
contentSha256textrequiredThe SHA-256 of its content, as first delivered
Becomes the column content_sha_256 of delivery.
Written at commons/data/models/flow/mod.ts:143
deliveryCountintegerrequiredHow many times the same content has been delivered
Becomes the column delivery_count of delivery.
Written at commons/data/models/flow/mod.ts:144
deliveryIdidentifierrequiredWhat identifies the message: its tenant and the id its sender gave it
Becomes the column delivery_id of delivery.
Written at commons/data/models/flow/mod.ts:140
firstSeeninstantrequiredWhen it was first seen
Becomes the column first_seen of delivery.
Written at commons/data/models/flow/mod.ts:145
senderMessageIdtextrequiredThe id the sender gave it
Becomes the column sender_message_id of delivery.
Written at commons/data/models/flow/mod.ts:142
tenanttextrequiredfirstLoadoneThe load of its first delivery To load. Written at commons/data/models/flow/mod.ts:137
Projects to the table delivery with the primary key delivery_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
content_sha_256 | text | false | attribute | delivery.contentSha256 |
delivery_count | integer | false | attribute | delivery.deliveryCount |
delivery_id | text | false | attribute | delivery.deliveryId |
first_load_load_id | text | false | reference | delivery.firstLoad |
first_seen | timestamp | false | attribute | delivery.firstSeen |
sender_message_id | text | false | attribute | delivery.senderMessageId |
tenant | text | false | attribute | delivery.tenant |
CREATE TABLE IF NOT EXISTS "delivery" (
"delivery_id" VARCHAR NOT NULL PRIMARY KEY,
"tenant" VARCHAR NOT NULL,
"sender_message_id" VARCHAR NOT NULL,
"content_sha_256" VARCHAR NOT NULL,
"delivery_count" INTEGER NOT NULL,
"first_seen" TIMESTAMPTZ NOT NULL,
"first_load_load_id" VARCHAR NOT NULL,
CONSTRAINT "delivery_first_load_load_id_fk" FOREIGN KEY ("first_load_load_id") REFERENCES "load" ("load_id"),
CONSTRAINT "delivery_tenant_sender_message_id_uq" UNIQUE ("tenant", "sender_message_id")
);CREATE TABLE IF NOT EXISTS "delivery" (
"delivery_id" TEXT NOT NULL PRIMARY KEY,
"tenant" TEXT NOT NULL,
"sender_message_id" TEXT NOT NULL,
"content_sha_256" TEXT NOT NULL,
"delivery_count" INTEGER NOT NULL,
"first_seen" TIMESTAMPTZ NOT NULL,
"first_load_load_id" TEXT NOT NULL,
CONSTRAINT "delivery_first_load_load_id_fk" FOREIGN KEY ("first_load_load_id") REFERENCES "load" ("load_id"),
CONSTRAINT "delivery_tenant_sender_message_id_uq" UNIQUE ("tenant", "sender_message_id")
);CREATE TABLE IF NOT EXISTS "delivery" (
"delivery_id" TEXT NOT NULL PRIMARY KEY,
"tenant" TEXT NOT NULL,
"sender_message_id" TEXT NOT NULL,
"content_sha_256" TEXT NOT NULL,
"delivery_count" INTEGER NOT NULL,
"first_seen" TEXT NOT NULL,
"first_load_load_id" TEXT NOT NULL,
CONSTRAINT "delivery_first_load_load_id_fk" FOREIGN KEY ("first_load_load_id") REFERENCES "load" ("load_id"),
CONSTRAINT "delivery_tenant_sender_message_id_uq" UNIQUE ("tenant", "sender_message_id")
);Read and written from TypeScript with the types the model gives: import { delivery } 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 { delivery } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(delivery).select((s) => ({ deliveryId: s.delivery.deliveryId, tenant: s.delivery.tenant })).run(runner);