Shared Prisma schema and generated client for Factor Wise projects
npm install @factor-wise/prisma-schemaWelcome to the Factorwise Project Schema Repository.
This repository contains the official Prisma schema, migrations, and related setup for the Factorwise backend system. It is designed specifically for Factorwise and must not be reused or modified for any other projects.
> ⚠️ Important:
> This is a private schema. Usage of this schema outside of the Factorwise environment is strictly prohibited.
---
- 📌 Project Overview
- 🛠️ Tech Stack
- 📂 Project Structure
- 🚀 Getting Started
- 🧭 Development Workflow
- ⚡ Common Commands
- 🔒 Important Notes
- 📄 License
---
This schema serves as the single source of truth for the Factorwise backend database.
It defines the models, relations, enums, and constraints required for all services interacting with the Factorwise data layer.
- ✅ Centralized schema for all DB models
- ✅ Managed migrations with Prisma
- ✅ Enums and mappings aligned with business logic
- ✅ Designed for multi-tenant setups using Prisma Client
---
- Prisma ORM — Database modeling & migrations
- TypeScript — Type-safe schema and client code
- MySQL — Primary database engine
- Node.js / NestJS — For backend integration
---
- prisma/schema.prisma → Core database models and enums for Factorwise.
- migrations/ → Auto-generated by Prisma when pushing changes.
- package.json → Used for managing versioning and publishing the schema internally.
- README.md → Project documentation.
---
``bash
npm install
npx prisma generate
npx prisma db push
``
---
_Built and maintained with ❤️ by the Factorwise Development Team._