🏠 Overview › 🧩 Components ›🧩 Database Schema

Database Schema

Component Detail

Data Layer high complexity backend
0
Dependencies
0
Dependents
49
Entities
0
Integrations

Description

Defines the complete relational database schema for all application tables managed via Supabase migrations stored in /supabase/migrations under version control. Includes Row Level Security (RLS) policies per table enforcing role-based data access at the database level using auth.uid() and custom JWT claims for GDPR compliance.

Feature: Supabase Backend Core

database-schema

Responsibilities

  • Define all table structures, constraints, and indexes as versioned SQL migrations
  • Implement RLS policies per table tied to auth.uid() and custom JWT role/org claims
  • Enforce referential integrity across users, organizations, activities, and all related tables
  • Manage schema evolution with forward-only migration files under version control

Interfaces

migrate()
rollback(version)
getPolicyDefinitions(table)
validateRLSCoverage()
generateTypescriptTypes()
seedTestData()
resetSchema()
diffMigrations()

Related Data Entities (49)

Data entities managed by this component

Accessibility Preferences 14 fields configuration Activity 22 fields core Activity Document 14 fields core Activity Log 12 fields audit Activity Type 14 fields configuration Assignment 21 fields core Assignment Dispatch 11 fields audit Assignment Read Receipt 7 fields audit Authentication Session 18 fields audit Bufdir Report 19 fields derived Bulk Registration 16 fields core Certification 17 fields core Certification Renewal 10 fields audit Contact 20 fields core Contact Note 11 fields core Course 21 fields core Course Enrollment 17 fields core Delegation Grant 8 fields audit Driver Honorarium 19 fields core Encrypted Document 21 fields core Event 20 fields core Event Participant 11 fields core Expense Item 17 fields core Impact Summary 19 fields derived Integration Config 20 fields configuration Local Association 13 fields core Member Recruitment 15 fields core Mentor Pairing 16 fields core NDA Agreement 16 fields core National Association 12 fields core Notification 15 fields core Organization 14 fields core Organization Label 7 fields configuration Peer Mentor 15 fields core Peer Mentor Availability 11 fields core Peer Mentor Location 12 fields core Power of Attorney Document 24 fields core Push Notification Config 11 fields configuration Receipt 13 fields core Region 10 fields core Reimbursement Approval 17 fields core Report Period 14 fields configuration Sync Log 23 fields audit Theme Config 6 fields configuration Travel Expense Report 17 fields core User 17 fields core User Organization Membership 13 fields core User Role 15 fields core Workshop Participant 12 fields core