Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns,...