Pop-up Clinic Check-in Table
Also known as: Time-Travel Table with Partial Updates
Pop-up Clinic Check-in Table A time-travel table for tracking patient check-ins. Fields are stored as "key:value" pairs separated by commas. - insert(ts, rowId, fields): Insert new row - update(ts, rowId, fields): Partial update (merge fields) - delete(ts, rowId): Delete row at timestamp - get(ts, rowId): Get current row at timestamp - getAt(ts, rowId): Time-travel query - selectAt(ts, filter): Select rows matching filter at timestamp
You're building a check-in system where records can be queried at any point in time—even after updates or deletions. The challenge is handling partial updates and soft deletes while keeping history intact. Interviewers use this to see if you can model temporal state cleanly.
Meet Coco
Coco is an AI study partner, not a person. She listens while you explain your code, asks what a line does and never hands you the fix. Sign in free to type with Coco, up to a daily limit, and to talk with her for one hour. After that, talking comes with the $79 pack. Anyone can open the editor and run their code.
Each locked part opens in the editor once the part before it passes.