drizzle--prisma-orm-architectlisted

# Drizzle & Prisma ORM Architect ## 1. System Architecture & Prerequisites This skill covers end-to-end PostgreSQL schema design and ORM layer implementation using **Prisma** and **Drizzle ORM** side-by-side on the same e-commerce domain model. The architecture enforces: - **1:1** User → UserProfile - **1:N** Category → Products, User → Orders, User → Reviews, Order → OrderItems - **M:N** Product ↔ Category via Prisma implicit many-to-many and Drizzle manual junction table - **Soft-delete** via `deletedAt` column with automatic filtering middleware - **Composite indexes** for high-throughput query patterns **Prerequisites:** - Node.js ≥ 18 - PostgreSQL 14+ - `prisma` CLI (`npm i -D prisma`) - `drizzle-kit` CLI (`npm i -D drizzle-kit`) - `drizzle-orm` runtime (`npm i drizzle-orm`) ## 2. Input/Output Data Contracts **Input — Environment Variables:** ```json { "$schema": "http://json-schema.org/draft-07/schema#", "type": "object", "required": ["DATABASE_URL"], "properties": { "DATABASE_URL": { "type": "string", "description": "PostgreSQL connection string", "pattern": "^postgresql://" } } } ``` **Output Artifacts:** | Path | Description | |---|---| | `prisma/schema.prisma` | Prisma schema definition | | `prisma/migrations/` | Auto-generated Prisma migration SQL | | `src/drizzle/schema.ts` | Drizzle table definitions | | `src/drizzle/migrations/` | Auto-generated Drizzle migration SQL | | `drizzle.config.ts` | Drizzle Kit configuratio