DDL with: correct types (bigint identity, timestamptz, jsonb vs columns),

NOT NULL defaults, CHECK constraints, unique constraints, foreign keys with ON DELETE strategy, and indexes (B-tree/GIN/partial/expression) mapped to specific query patterns. Add created_at/updated_at/deleted_at conventions.