nngdevops/techschoo ? reverse-engineered prompt

Build me the backend database for a school management app called TechSchoo.

I want the system to handle the main school workflows, especially attendance, fees, marks, and platform access for different tenants or schools. Set it up so the data is protected properly, users only see what they are allowed to see, and the system fails closed if someone is not authorized. I also want the database logic to be reliable, so things like duplicate requests, rollbacks, and audit logging are handled cleanly.

Use the existing SQL based structure if it helps, and make sure the setup works end to end with sample seed data and tests I can run to verify the happy path, unauthorized access, cross tenant isolation, and idempotency. If you need to, look up current docs online for any Supabase or PostgreSQL details. After building it, leave the project in a state where I can run the scripts and understand how the core school engines fit together.