Database Design - PostgreSQL 17 + Supabase for laneweaverTMS

When to Use This Skill

Use when:

• Designing new database tables and schemas
• Creating database migrations
• Planning table relationships and foreign keys
• Defining indexes for query optimization
• Creating database constraints and validation rules
• Implementing audit trails and soft deletes
• Writing database functions and triggers
• Designing views for calculated data
• Setting up row-level security (RLS) policies
• Implementing polymorphic relationships

Primary Keys & IDs

UUID Pattern (Standard for All Tables)