Prisma project

This project contains our Postgres database schema, seed, and PrismaClient accessor.

Purpose

Putting these things in an NPM package allows us to reuse database accessor methods across our multiple backend services

Updating the schema

1. First, make your required changes in schema.prisma
2. Then, run npx prisma migrate dev --name {migration-name}
3. When you're ready, publish the changes to NPM following the steps below

Updating the NPM package

1. Make your desired changes in the prisma folder
2. Run npm version patch (or any of {newversion} | major | minor | patch | premajor | preminor | prepatch | prerelease | from-git) to up the version number accordingly
3. Run npm publish to publish the changes

Seeding your database

Run npx prisma migrate reset

Entity Relationship Diagram (ERD)

View file src/ERD.svg. This updates every time npx prisma migrate dev runs or when running npx prisma generate.