Your clinic gets its own database
Not a shared table with a column for your clinic's name. Each clinic on Solace has a separate database, and the boundary between two clinics is the database itself rather than a filter somebody has to remember to write correctly.
This is the single most important thing on this page. Most multi-tenant systems keep everybody's patients in one table and rely on the code being right every single time.