Tellus EHS Data Model

Comprehensive documentation of the Tellus platform database schema and data architecture.

Sections

• Overview - High-level data model overview
• ChemIQ Schema - Chemical inventory and SDS tables
• AdminHQ Schema - Admin, users, and roles tables
• RBAC - Role-based access control implementation
• Entitlements - Subscription and entitlement system

Key Concepts

Multi-Tenancy

All data is scoped by company_id with row-level security (RLS) enforced at the database level.

Module System

Modules can be enabled/disabled per company type and subscription plan.

Audit Trail

All critical tables maintain audit trails for compliance and debugging.