The aescolab showcase gets its backend. Global catalogs (61 Biomarkers, three packages, 58 fictional Partner Practices and German postcode centroids) are readable signed out. Patient health data lives in the personal Organization: Result Sets stay invisible until the lab releases them, enforced by row-level security. Practice search works by postcode and radius, availability is computed in Europe/Berlin across the daylight-saving switch, and two patients racing for one slot get one booking and one conflict. The admin pipeline moves a Lab Order one step at a time and, at results_ready, releases the results, writes the plan and a Result Notice; admins see metadata only.
The seed loads everything fictional, idempotently and relative to the run, with exactly two sign-in accounts. DEMO_MODE enables the demo controls.