🏗️ Factorwise Project — Prisma Schema

Welcome 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.

📚 Table of Contents

• 📌 Project Overview
• 🛠️ Tech Stack
• 📂 Project Structure
• 🚀 Getting Started
• 🧭 Development Workflow
• ⚡ Common Commands
• 🔒 Important Notes
• 📄 License

📌 Project Overview

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

🛠️ Tech Stack

• Prisma ORM — Database modeling & migrations
• TypeScript — Type-safe schema and client code
• MySQL — Primary database engine
• Node.js / NestJS — For backend integration

📂 Project Structure

• 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.

🚀 Getting Started

npm install


npx prisma generate


npx prisma db push

Built and maintained with ❤️ by the Factorwise Development Team.