Schema and data-model notes: tenant-leading composite keys, forced row-level security, and indexing conventions.
Start here: the big picture in plain words