{"type":"excalidraw","version":2,"source":"https://AwesomeSystemDesign.dev","elements":[{"angle":0,"strokeColor":"#6577aa","backgroundColor":"#eef1fc","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-1"],"frameId":null,"roundness":null,"boundElements":[{"type":"text","id":"shape-1"}],"updated":0,"link":null,"locked":false,"id":"shape-0","type":"rectangle","seed":41,"x":35.999999999999986,"y":32,"width":242.83948,"height":68,"customData":{"revealStep":1}},{"angle":0,"strokeColor":"#394557","backgroundColor":"transparent","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-1"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-1","type":"text","seed":114,"x":55.999999999999986,"y":54.3,"width":202.83948,"height":23.400000000000002,"fontSize":18,"fontFamily":1,"text":"Column | Type | Notes","originalText":"Column | Type | Notes","textAlign":"center","verticalAlign":"middle","containerId":"shape-0","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":1}},{"angle":0,"strokeColor":"#628572","backgroundColor":"#edf5ee","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-2"],"frameId":null,"roundness":null,"boundElements":[{"type":"text","id":"shape-3"}],"updated":0,"link":null,"locked":false,"id":"shape-2","type":"rectangle","seed":187,"x":318.83948,"y":32,"width":390,"height":340.2,"customData":{"revealStep":2}},{"angle":0,"strokeColor":"#394557","backgroundColor":"transparent","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-2"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-3","type":"text","seed":260,"x":338.83948,"y":50,"width":350,"height":304.2,"fontSize":18,"fontFamily":1,"text":"notification_id | UUID\nuser_id | UUID\nchannel | LowCard Str |\npush/email/sms\nstatus | LowCard Str |\nsent/delivered/etc\nprovider | LowCard Str |\napns/fcm/ses/twilio\nevent_time | DateTime64\nlatency_ms | UInt32 | Time from\nqueue→send\nerror_code | Nullable Str\ncampaign_id | Nullable Str","originalText":"notification_id | UUID\nuser_id | UUID\nchannel | LowCard Str |\npush/email/sms\nstatus | LowCard Str |\nsent/delivered/etc\nprovider | LowCard Str |\napns/fcm/ses/twilio\nevent_time | DateTime64\nlatency_ms | UInt32 | Time from\nqueue→send\nerror_code | Nullable Str\ncampaign_id | Nullable Str","textAlign":"center","verticalAlign":"middle","containerId":"shape-2","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":2}},{"angle":0,"strokeColor":"#a68a53","backgroundColor":"#fff7e6","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-3"],"frameId":null,"roundness":null,"boundElements":[{"type":"text","id":"shape-5"}],"updated":0,"link":null,"locked":false,"id":"shape-4","type":"rectangle","seed":333,"x":36,"y":412.2,"width":645.7423000000001,"height":257,"customData":{"revealStep":3}},{"angle":0,"strokeColor":"#394557","backgroundColor":"transparent","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-3"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-5","type":"text","seed":406,"x":56,"y":430.2,"width":605.7423000000001,"height":221,"fontSize":17,"fontFamily":1,"text":"delivery_events (ClickHouse)\n\nPartitioned by: toYYYYMM(event_time)\nOrder by: (channel, notification_id, event_time)\n\nQuery: \"Delivery rate for push in last 24h\"\nSELECT status, count(*)\nFROM delivery_events\nWHERE channel = 'push' AND event_time > now() - INTERVAL 1 DAY\nGROUP BY status","originalText":"delivery_events (ClickHouse)\n\nPartitioned by: toYYYYMM(event_time)\nOrder by: (channel, notification_id, event_time)\n\nQuery: \"Delivery rate for push in last 24h\"\nSELECT status, count(*)\nFROM delivery_events\nWHERE channel = 'push' AND event_time > now() - INTERVAL 1 DAY\nGROUP BY status","textAlign":"left","verticalAlign":"middle","containerId":"shape-4","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":3}}],"appState":{"viewBackgroundColor":"#fbfbf8","gridSize":null},"files":{}}