PostgreSQL Schema Design

Design a PostgreSQL database schema for the following requirements:

Domain: {{DomainDescription}}

Please include:
1. Table Definitions with primary keys, foreign keys, proper data types
2. Indexes for performance
3. Row Level Security (RLS) policies
4. Timestamps (created_at, updated_at, deleted_at)

Output format: SQL CREATE statements with comments explaining design decisions.