Design a database schema
Plans tables, relations and indexes for an application.
Claude 'slash codes': Coding / Tech
Design a database schema for [APPLICATION]. Database: [POSTGRES, MYSQL OR OTHER]. The main things it must store: [ENTITIES]. Give the tables with columns, types, keys and constraints, the relations between them, and the indexes for these common queries: [QUERIES]. Explain any denormalisation. Then give the CREATE TABLE statements.