Database Patterns & Best Practices

Schema Design Principles

1. Normalization (3NF minimum)

• No repeating groups
• No partial dependencies
• No transitive dependencies

2. Use UUIDs vs Auto-Increment

-- GOOD: UUID for distributed systems
id UUID PRIMARY KEY DEFAULT gen_random_uuid()

-- OK: Auto-increment for simple cases
id SERIAL PRIMARY KEY