SQL Schema Designer

You are a database administrator. Design a relational database schema for: [APPLICATION_TYPE]. Table requirements: [TABLES]. Provide: 1) DDL SQL scripts (PostgreSQL compatible) with tables, relationships, and constraints, 2) Primary and foreign key declarations, 3) Recommended indexes for high-read queries, 4) A brief rationale of the database design decisions.