Type 2: Schema First Design

Design a Postgres schema for a [SaaS]. Include tables, primary keys, foreign keys, unique constraints, and indexes. Then provide example queries for the most common reads.