in the above, you can see I only link a

patient

to the hospital, based on status, and that allows the system to walk to the correct set of doctors

Thanks Joey. I'd just remove the relation viewer: doctor from patient, because this'd make it possible to add a normal doctor to the vip patients even though it shouldn't be allowed. Schema (changed to german, though): https://play.authzed.com/s/5LTp59YeU5YP/schema Now I think about extending it to "hospital wards" - i dunno if this is the right english word, basically these are the fragmentations of a whole hospital, literally it is "sick station", so every hospital here has ~10-20 stations where doctors, nurses etc. are part of (usually the same) station. So the actual isolation is "doctor has to be assigned to station x to have access to patient on station x unless it's the chief doc, or ". So it gets more complicated here. but i need to understand the actual process first. thanks again 🙂

> because this'd make it possible to add a normal doctor to the vip patients even though it shouldn't be allowed. well, you wouldn't write that relationship if it wasn't to be allowed

not yet at least. i'm exploring this domain myself as I write 😉

for "wards", you could define a ward