{ "type": "excalidraw", "version": 2, "source": "https://excalidraw.com", "elements": [ { "id": "r1803110565", "type": "rectangle", "x": 20, "y": 70, "width": 1460, "height": 660, "angle": 0, "strokeColor": "#dddddd", "backgroundColor": "#fafafa", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 178034167, "versionNonce": 1841246965, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1183718698", "type": "text", "x": 32, "y": 76, "width": 396.00000000000006, "height": 15.0, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1281830446, "versionNonce": 792687988, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "PostgreSQL \u2014 one shared schema (V1__init_schema.sql, Flyway)", "fontSize": 12, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "PostgreSQL \u2014 one shared schema (V1__init_schema.sql, Flyway)", "lineHeight": 1.25, "baseline": 12 }, { "id": "r56666809", "type": "rectangle", "x": 300, "y": 90, "width": 260, "height": 120, "angle": 0, "strokeColor": "#999999", "backgroundColor": "#ffffff", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 1252080340, "versionNonce": 1219759553, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1855011034", "type": "text", "x": 310, "y": 98, "width": 192.50000000000003, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1634827046, "versionNonce": 1467009423, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "customers (shared kernel)", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "customers (shared kernel)", "lineHeight": 1.25, "baseline": 14 }, { "id": "t1075971827", "type": "text", "x": 310, "y": 118, "width": 40, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1016107385, "versionNonce": 1529771793, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "id PK", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "id PK", "lineHeight": 1.25, "baseline": 11 }, { "id": "t1685985907", "type": "text", "x": 310, "y": 133, "width": 139.15, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 477974747, "versionNonce": 1725725570, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "name, email, created_at", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "name, email, created_at", "lineHeight": 1.25, "baseline": 11 }, { "id": "r1114863672", "type": "rectangle", "x": 900, "y": 90, "width": 260, "height": 120, "angle": 0, "strokeColor": "#111111", "backgroundColor": "#ffffff", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 1562969134, "versionNonce": 1928078084, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1622774871", "type": "text", "x": 910, "y": 98, "width": 115.50000000000001, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 563085547, "versionNonce": 1180925147, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "inventory_items", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "inventory_items", "lineHeight": 1.25, "baseline": 14 }, { "id": "t695623307", "type": "text", "x": 910, "y": 118, "width": 40, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1043133401, "versionNonce": 1731504055, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "id PK", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "id PK", "lineHeight": 1.25, "baseline": 11 }, { "id": "t1889621865", "type": "text", "x": 910, "y": 133, "width": 133.10000000000002, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1010376655, "versionNonce": 447555091, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "sku, name, price_cents", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "sku, name, price_cents", "lineHeight": 1.25, "baseline": 11 }, { "id": "t565488608", "type": "text", "x": 910, "y": 148, "width": 169.4, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 595344190, "versionNonce": 910143239, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "quantity_on_hand, updated_at", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "quantity_on_hand, updated_at", "lineHeight": 1.25, "baseline": 11 }, { "id": "r1492103684", "type": "rectangle", "x": 40, "y": 330, "width": 220, "height": 150, "angle": 0, "strokeColor": "#111111", "backgroundColor": "#ffffff", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 1605488630, "versionNonce": 560270754, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1960819870", "type": "text", "x": 50, "y": 338, "width": 46.2, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 161257433, "versionNonce": 1233149133, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "orders", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "orders", "lineHeight": 1.25, "baseline": 14 }, { "id": "t433004186", "type": "text", "x": 50, "y": 358, "width": 40, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 441160119, "versionNonce": 1538331160, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "id PK", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "id PK", "lineHeight": 1.25, "baseline": 11 }, { "id": "t413443033", "type": "text", "x": 50, "y": 373, "width": 84.7, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 654018971, "versionNonce": 1428434710, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "customer_id FK", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "customer_id FK", "lineHeight": 1.25, "baseline": 11 }, { "id": "t1882000241", "type": "text", "x": 50, "y": 388, "width": 223.85000000000002, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 692213761, "versionNonce": 120640565, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "status, total_cents, shipping_address", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "status, total_cents, shipping_address", "lineHeight": 1.25, "baseline": 11 }, { "id": "r1112373759", "type": "rectangle", "x": 280, "y": 330, "width": 220, "height": 150, "angle": 0, "strokeColor": "#111111", "backgroundColor": "#ffffff", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 678109027, "versionNonce": 1994719133, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t358092003", "type": "text", "x": 290, "y": 338, "width": 84.7, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1743598554, "versionNonce": 378925713, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "order_items", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "order_items", "lineHeight": 1.25, "baseline": 14 }, { "id": "t443875759", "type": "text", "x": 290, "y": 358, "width": 40, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 745336739, "versionNonce": 469109436, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "id PK", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "id PK", "lineHeight": 1.25, "baseline": 11 }, { "id": "t236032110", "type": "text", "x": 290, "y": 373, "width": 199.65, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 791124169, "versionNonce": 901931234, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "order_id FK, inventory_item_id FK", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "order_id FK, inventory_item_id FK", "lineHeight": 1.25, "baseline": 11 }, { "id": "t1467256278", "type": "text", "x": 290, "y": 388, "width": 157.3, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 695156475, "versionNonce": 1232060517, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "quantity, unit_price_cents", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "quantity, unit_price_cents", "lineHeight": 1.25, "baseline": 11 }, { "id": "r106025527", "type": "rectangle", "x": 520, "y": 330, "width": 220, "height": 150, "angle": 0, "strokeColor": "#111111", "backgroundColor": "#ffffff", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 438064093, "versionNonce": 336628937, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1065950434", "type": "text", "x": 530, "y": 338, "width": 61.60000000000001, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 475897974, "versionNonce": 1022836285, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "payments", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "payments", "lineHeight": 1.25, "baseline": 14 }, { "id": "t223678198", "type": "text", "x": 530, "y": 358, "width": 40, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 192927177, "versionNonce": 697771595, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "id PK", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "id PK", "lineHeight": 1.25, "baseline": 11 }, { "id": "t350031375", "type": "text", "x": 530, "y": 373, "width": 66.55000000000001, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1262864019, "versionNonce": 152462949, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "order_id FK", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "order_id FK", "lineHeight": 1.25, "baseline": 11 }, { "id": "t1607296043", "type": "text", "x": 530, "y": 388, "width": 169.4, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1050378279, "versionNonce": 1130646593, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "amount_cents, method, status", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "amount_cents, method, status", "lineHeight": 1.25, "baseline": 11 }, { "id": "r441934563", "type": "rectangle", "x": 760, "y": 330, "width": 220, "height": 150, "angle": 0, "strokeColor": "#111111", "backgroundColor": "#ffffff", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 972679000, "versionNonce": 1376204266, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1070517807", "type": "text", "x": 770, "y": 338, "width": 69.30000000000001, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 604301834, "versionNonce": 1431306282, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "shipments", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "shipments", "lineHeight": 1.25, "baseline": 14 }, { "id": "t1455204728", "type": "text", "x": 770, "y": 358, "width": 40, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 179039009, "versionNonce": 1516560472, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "id PK", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "id PK", "lineHeight": 1.25, "baseline": 11 }, { "id": "t477499851", "type": "text", "x": 770, "y": 373, "width": 66.55000000000001, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 292475689, "versionNonce": 740932617, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "order_id FK", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "order_id FK", "lineHeight": 1.25, "baseline": 11 }, { "id": "t742433352", "type": "text", "x": 770, "y": 388, "width": 90.75000000000001, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1640211000, "versionNonce": 740623770, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "address, status", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "address, status", "lineHeight": 1.25, "baseline": 11 }, { "id": "r1827735658", "type": "rectangle", "x": 1000, "y": 330, "width": 220, "height": 150, "angle": 0, "strokeColor": "#111111", "backgroundColor": "#ffffff", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 1680274866, "versionNonce": 478342784, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1843293154", "type": "text", "x": 1010, "y": 338, "width": 100.10000000000001, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1916791904, "versionNonce": 159664678, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "notifications", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "notifications", "lineHeight": 1.25, "baseline": 14 }, { "id": "t53515934", "type": "text", "x": 1010, "y": 358, "width": 40, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 337264630, "versionNonce": 299226043, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "id PK", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "id PK", "lineHeight": 1.25, "baseline": 11 }, { "id": "t1333301197", "type": "text", "x": 1010, "y": 373, "width": 229.9, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 332210983, "versionNonce": 1338018767, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "customer_id FK, order_id FK (nullable)", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "customer_id FK, order_id FK (nullable)", "lineHeight": 1.25, "baseline": 11 }, { "id": "t1243663932", "type": "text", "x": 1010, "y": 388, "width": 96.80000000000001, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 340445175, "versionNonce": 93393228, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "channel, message", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "channel, message", "lineHeight": 1.25, "baseline": 11 }, { "id": "r1660620236", "type": "rectangle", "x": 1240, "y": 330, "width": 220, "height": 150, "angle": 0, "strokeColor": "#111111", "backgroundColor": "#ffffff", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 3 }, "seed": 1312925873, "versionNonce": 116009625, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false }, { "id": "t1450153759", "type": "text", "x": 1250, "y": 338, "width": 53.900000000000006, "height": 17.5, "angle": 0, "strokeColor": "#111111", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1807809687, "versionNonce": 788192346, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "reviews", "fontSize": 14, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "reviews", "lineHeight": 1.25, "baseline": 14 }, { "id": "t428816057", "type": "text", "x": 1250, "y": 358, "width": 40, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 75236617, "versionNonce": 1764403378, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "id PK", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "id PK", "lineHeight": 1.25, "baseline": 11 }, { "id": "t1922965060", "type": "text", "x": 1250, "y": 373, "width": 217.8, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1118923358, "versionNonce": 467550520, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "customer_id FK, inventory_item_id FK", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "customer_id FK, inventory_item_id FK", "lineHeight": 1.25, "baseline": 11 }, { "id": "t1804003788", "type": "text", "x": 1250, "y": 388, "width": 90.75000000000001, "height": 13.75, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 185613676, "versionNonce": 1231342935, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "rating, comment", "fontSize": 11, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "rating, comment", "lineHeight": 1.25, "baseline": 11 }, { "id": "a1339451851", "type": "arrow", "x": 280.0, "y": 405.0, "width": 20.0, "height": 0.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 334157964, "versionNonce": 469328218, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ -20.0, 0.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1372389495", "type": "arrow", "x": 630.0, "y": 480, "width": 0.0, "height": 30, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1805041757, "versionNonce": 561481699, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, 30 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1112913250", "type": "arrow", "x": 630.0, "y": 510, "width": 425.0, "height": 0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1565763229, "versionNonce": 1779038100, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ -425.0, 0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1157096859", "type": "arrow", "x": 205.0, "y": 510, "width": 0.0, "height": 30, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 899872554, "versionNonce": 1318169248, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, -30 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1022710192", "type": "arrow", "x": 870.0, "y": 480, "width": 0.0, "height": 30, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1216209365, "versionNonce": 1739710962, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, 30 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1809207335", "type": "arrow", "x": 870.0, "y": 510, "width": 665.0, "height": 0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 312947572, "versionNonce": 319218785, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ -665.0, 0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a209159010", "type": "arrow", "x": 205.0, "y": 510, "width": 0.0, "height": 30, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1364493202, "versionNonce": 1902451833, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, -30 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1512982457", "type": "arrow", "x": 1110.0, "y": 480, "width": 0.0, "height": 30, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 485158349, "versionNonce": 1453909189, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, 30 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a797950170", "type": "arrow", "x": 1110.0, "y": 510, "width": 905.0, "height": 0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1596970757, "versionNonce": 1761656044, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ -905.0, 0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1513755536", "type": "arrow", "x": 205.0, "y": 510, "width": 0.0, "height": 30, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1052587463, "versionNonce": 790599659, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, -30 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a977158593", "type": "arrow", "x": 150.0, "y": 330, "width": 0.0, "height": 60.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1243932182, "versionNonce": 1980585533, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, -60.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a145598285", "type": "arrow", "x": 150.0, "y": 270.0, "width": 280.0, "height": 0.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 576414191, "versionNonce": 861363872, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 280.0, 0.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1654778007", "type": "arrow", "x": 430.0, "y": 270.0, "width": 0.0, "height": 60.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 461320810, "versionNonce": 1441582673, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, -60.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a474629164", "type": "arrow", "x": 390.0, "y": 330, "width": 0.0, "height": 60.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1012416190, "versionNonce": 1869680344, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, -60.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1294474096", "type": "arrow", "x": 390.0, "y": 270.0, "width": 640.0, "height": 0.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1708713730, "versionNonce": 1027575934, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 640.0, 0.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1758439967", "type": "arrow", "x": 1030.0, "y": 270.0, "width": 0.0, "height": 60.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1852051267, "versionNonce": 1816405582, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, -60.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a978958819", "type": "arrow", "x": 1110.0, "y": 330, "width": 0.0, "height": 60.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 957380695, "versionNonce": 143344514, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, -60.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1701900742", "type": "arrow", "x": 1110.0, "y": 270.0, "width": 680.0, "height": 0.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 892008100, "versionNonce": 356047037, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ -680.0, 0.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1749999440", "type": "arrow", "x": 430.0, "y": 270.0, "width": 0.0, "height": 60.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1532819475, "versionNonce": 1759662389, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, -60.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1557139334", "type": "arrow", "x": 1350.0, "y": 330, "width": 0.0, "height": 60.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 730366716, "versionNonce": 795092816, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, -60.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1175203301", "type": "arrow", "x": 1350.0, "y": 270.0, "width": 920.0, "height": 0.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 894505008, "versionNonce": 1165699614, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ -920.0, 0.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1188614328", "type": "arrow", "x": 430.0, "y": 270.0, "width": 0.0, "height": 60.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1743066870, "versionNonce": 367705713, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, -60.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a1311351747", "type": "arrow", "x": 1350.0, "y": 330, "width": 0.0, "height": 60.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 928221824, "versionNonce": 475571712, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, -60.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a231051650", "type": "arrow", "x": 1350.0, "y": 270.0, "width": 320.0, "height": 0.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1023468641, "versionNonce": 501463217, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ -320.0, 0.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "a923522298", "type": "arrow", "x": 1030.0, "y": 270.0, "width": 0.0, "height": 60.0, "angle": 0, "strokeColor": "#2f5f3d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 2, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": { "type": 2 }, "seed": 1420755189, "versionNonce": 745533499, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "points": [ [ 0, 0 ], [ 0.0, -60.0 ] ], "lastCommittedPoint": null, "startBinding": null, "endBinding": null, "startArrowhead": null, "endArrowhead": "arrow" }, { "id": "t1992815908", "type": "text", "x": 750.0, "y": 22, "width": 832.1500000000001, "height": 21.25, "angle": 0, "strokeColor": "#1d1d1d", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1617254325, "versionNonce": 1545205797, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "ch.08 \u2014 Shared schema: eight tables, one Postgres schema, nine cross-context foreign keys", "fontSize": 17, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "ch.08 \u2014 Shared schema: eight tables, one Postgres schema, nine cross-context foreign keys", "lineHeight": 1.25, "baseline": 17 }, { "id": "t860956367", "type": "text", "x": 750.0, "y": 46, "width": 898.1500000000001, "height": 14.375, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 1307188426, "versionNonce": 1843967005, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "SMELL[ch.18] (SMELLS.md #1): every FK below crosses a bounded-context ownership boundary, enforced only because everything shares one database", "fontSize": 11.5, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "SMELL[ch.18] (SMELLS.md #1): every FK below crosses a bounded-context ownership boundary, enforced only because everything shares one database", "lineHeight": 1.25, "baseline": 11.5 }, { "id": "t738545890", "type": "text", "x": 40, "y": 734, "width": 802.725, "height": 13.125, "angle": 0, "strokeColor": "#555555", "backgroundColor": "transparent", "fillStyle": "solid", "strokeWidth": 1, "strokeStyle": "solid", "roughness": 1, "opacity": 100, "groupIds": [], "frameId": null, "roundness": null, "seed": 749470119, "versionNonce": 360346295, "isDeleted": false, "boundElements": [], "updated": 1, "link": null, "locked": false, "text": "Sourced from examples/00-monolith/.../db/migration/V1__init_schema.sql (reference/monolith-before) and SMELLS.md smell #1. Reused in ch.18.", "fontSize": 10.5, "fontFamily": 1, "textAlign": "left", "verticalAlign": "top", "containerId": null, "originalText": "Sourced from examples/00-monolith/.../db/migration/V1__init_schema.sql (reference/monolith-before) and SMELLS.md smell #1. Reused in ch.18.", "lineHeight": 1.25, "baseline": 10.5 } ], "appState": { "viewBackgroundColor": "#ffffff", "gridSize": null }, "files": {} }