Спроектировать схему базы данных
Планирует таблицы, связи и индексы для приложения.
Коды «slash»: код / технологии
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.