MapfableRead-only diagram
View
Show route
Motion

Messages play in saved order; spacing is not measured time.

Commerce · Customer, checkout & catalogueCommerce · Customer, checkout & catalogueA relational design for customer accounts, checkout, products and inventory. Business domains keep related tables together; keys and endpoint symbols explain how records connect.Database relationships · Endpoint labels show how many records may relate. Relationships are not runtime traffic.AccountsCheckoutCatalogueLine itemsplaced byplaced bypayment forpayment forbelongs tobelongs toreferencesreferencesstock ofstock ofCustomersCustomersPKiduuidUKemailvarchar(255)display_namevarchar(120)created_attimestampOrdersOrdersPKiduuidFKcustomer_iduuidstatusorder_statustotal_amountnumeric(12,2)currencychar(3)placed_attimestampPaymentsPaymentsPKiduuidFKorder_iduuidmethodvarchar(32)amountnumeric(12,2)paid_attimestampnullableUKexternal_refvarchar(64)InventoryInventoryPKiduuidFKproduct_iduuidwarehouse_codevarchar(16)quantityintegerreserved_quantityintegerupdated_attimestampProductsProductsPKiduuidUKskuvarchar(64)namevarchar(160)pricenumeric(12,2)activebooleancreated_attimestampOrder itemsOrder itemsPKiduuidFKorder_iduuidFKproduct_iduuidquantityintegerunit_pricenumeric(12,2)discount_amountnumeric(12,2)PKPrimary keyFKForeign keyUKUnique keyOneManyOptionalRead-only snapshot · Sources describe their recorded context.
Whole diagram