Database schema where applicable.
I'd like to discuss this to get a sense of how you guys interpret relationships between data. I'm particularly curious about the following relationships specifically (please forgive me if I'm misusing terms; I'm trying to keep the terms consistent with what I recall you mentioning), but the more schema the merrier here:
- Realms -> Clients
- Institutions -> Realms -- particularly in how I seem to recall this being at a yearly level, but I get the sense you have some clients with multiple "cycle runs" a year.
- Applicants -> Realms
- Applications -> Realms
- Applications -> Applicants
This is specifically regarding client's security requirements of data transmission and storage compliance.