Database Design
Database Design documents how AeThex data should be modeled, related, secured, and evolved across the platform.
Design goals
Data models should support identity, organizations, projects, permissions, and auditability.
AeThex data should be designed around durable platform concepts instead of temporary UI screens. The core model starts with users and identities, then expands into organizations, teams, projects, permissions, integrations, and operational records.
Core entities
- Users and Profiles
- Passport identities and Linked-Accounts
- Organizations and Teams
- Projects and project resources
- Permissions and roles
- Events, audit logs, and integration records
Design rules
- Prefer stable IDs over display names.
- Track ownership and organization context explicitly.
- Keep permission checks close to protected data.
- Store audit fields for important state changes.
- Version schemas and migrations with clear rollback notes.