Data Model

Core Tenancy Tables

• organizations: workspace container (department/service unit).
• users: identity records.
• memberships: role assignment per organization.
• sessions: server-side auth sessions.

Execution Tables

• projects and tasks: portfolio and execution records.
• teams and spaces: accountability and physical context.
• item_comments and item_watchers: collaboration state.

Operations Tables

• equipment_assets: machine lifecycle and maintenance status.
• consumables: stock quantities with location and owner.
• meeting_agendas / meeting_items: recurring meetings and decisions.
• onboarding_templates / onboarding_assignments: role-based onboarding.

Governance + Audit

• audit_log: data and interface change history.
• email_messages: notification delivery history.
• deleted_at pattern on key entities for restore/purge workflow.