1. Tables are normalized around users, teams, registry items, versions, tags, collections, and analytics.

2. Foreign keys use cascade or set-null rules based on data ownership and audit needs.

3. Indexes cover common lookup paths for slugs, users, registry state, tags, and activity entities.

4. Schema changes should flow through drizzle-kit migrations and reviewed seed scripts.