Database Models and Schema

Details

The database foundation is set. Employee, Team, Tenant, Tool, Message, Thread, Skill, Duty, and all supporting models are defined with proper relationships, indexes, and constraints. Every model enforces tenant isolation at the database level. Migrations are reversible and additive. The schema is ready for everything we are building on top.

What changed

• Core models: Employee, Team, Tenant, Tool, Message, Thread
• Tenant isolation enforced at the database level
• Reversible and additive migration strategy
• Optimized indexes for common query patterns