Supabase: Schema Design

Guidelines for database tables, columns, and relationships with custom ID generation, naming conventions, and multi-tenancy patterns.

Custom ID Generation

Always use generate_id('prefix') for primary keys (not UUID):

id TEXT PRIMARY KEY DEFAULT generate_id('prj')  -- ✅ Custom ID
id UUID PRIMARY KEY DEFAULT gen_random_uuid()   -- ❌ Never UUID

Common prefixes: org, prj, mem, wel, rp, pfl

Naming Conventions

All identifiers: snake_case