OpenVaultDB database

Shipping

Synthetic Northwind companion with healthy11038 and blocked baseline requests11045 and11062; future recovery examples remain separate, with the11062 replay pending.

Explore SQLite in DataTug Explore the database site Read-only API pending Server directory

Published collections

10 read-only collections

9 declared foreign-key relationships. Names and keys preserve the source database schema. The database site includes the complete native schema, including views.

Explore complete schema and exports ↗

Explore SQLite in DataTug

Known limits.

Editing needs exactly one primary-key column. Every table here has one.
Views are not listed: the local SQLite browser shows the 10 tables only, not the 2 views. The schema pages on this site list them.
A table opens with its first 100 rows. There is no paging yet.

Published recordsets

Read-only collections

10 collections

table

requests

6 columns · 8 rows

request_idTEXT · PK · nullableorder_idINTEGERshipper_idINTEGERmessage_idTEXTcorrelation_idTEXTcreated_atTEXT

table

publications

4 columns · 8 rows

publication_idTEXT · PK · nullablerequest_idTEXTmessage_idTEXTacknowledged_atTEXT

References requests.request_id

table

receipts

4 columns · 7 rows

receipt_idTEXT · PK · nullablerequest_idTEXTmessage_idTEXTreceived_atTEXT

References requests.request_id

table

configurations

2 columns · 1 rows

revisionINTEGER · PK · nullablepublished_atTEXT

table

partners

2 columns · 2 rows

partner_idTEXT · PK · nullableenabledINTEGER

table

routes

6 columns · 4 rows

route_idTEXT · PK · nullablerevisionINTEGERshipper_idINTEGERpartner_idTEXTvalid_fromTEXTvalid_untilTEXT · nullable

References partners.partner_id, configurations.revision

table

attempts

6 columns · 8 rows

attempt_idTEXT · PK · nullablerequest_idTEXTattempt_noINTEGERconfig_revisionINTEGERstarted_atTEXTstateTEXT

References configurations.revision, requests.request_id

table

events

11 columns · 29 rows

event_idTEXT · PK · nullableattempt_idTEXTsequenceINTEGERkindTEXToccurred_atTEXTclock_domainTEXTprecision_msINTEGERartifactTEXTbyte_startINTEGERbyte_endINTEGERartifact_sha256TEXT

References attempts.attempt_id

table

assignments

5 columns · 1 rows

assignment_idTEXT · PK · nullableattempt_idTEXTpartner_idTEXTaccepted_atTEXTdeduplication_keyTEXT

References partners.partner_id, attempts.attempt_id

table

workspace_state

3 columns · 1 rows

generationTEXT · PK · nullablecurrent_configINTEGERbusiness_clockTEXT

Provenance

Published data

Source: https://github.com/datatug/datatug-demo-project at cb841345e88d01229857b2bdb51cc07f4ef4bec7.

Source licence: CC0-1.0. Model licence: CC0-1.0. Meaning licence: CC0-1.0.

Published by DemoDB; provider repository ↗.

Public synthetic training companion to Northwind; no real shipment or partner call is represented. The sha256 identifies the generated SQLite fixture at data-source/base.sqlite; recipe inputs are identified separately by the provider manifest.

Semantic references

Published models

ModelSpec: modelspec://github.com/demo-db/shipping/0.1.0 ↗ · HCL source ↗

MeaningGraph: meaning://github.com/demo-db/shipping ↗

Browse model and meaning files ↗