ServerDatabase
Overview
Database layer for the CRM — Prisma clients, schemas, and database utilities.
@repo/crm-db provides the database layer for Selegic CRM, including Prisma clients and schemas.
Package Structure
packages/crm/db/
├── src/
│ ├── index.ts # Main exports
│ ├── prisma/ # Generated Prisma clients
│ │ ├── core/ # Core (global) database client
│ │ └── org/ # Organization-scoped client
│ ├── seed/ # Database seeding scripts
│ └── config/ # Prisma configuration
├── prisma/
│ ├── schema.prisma # Core schema
│ └── org.prisma # Organization schema
└── package.jsonExports
| Export | Description |
|---|---|
. | Base Prisma client |
./prisma-client | Core client for global operations |
Database Types
Core Database
Global data shared across all organizations:
- Users, Sessions, AuthAccounts
- Organizations, Members
- API Keys, Invitations
Organization Database
Per-tenant data (in separate schemas):
- Dynamic Entities and Fields
- Custom Records
- Flow Definitions and Runs
Key Scripts
| Script | Purpose |
|---|---|
db:core:push | Push core schema to database |
db:core:generate | Generate Prisma client |
db:org:push | Push org schema to database |
db:core:studio | Open Prisma Studio |
Quick Navigation
- Schema Overview — Database models and relationships
- Client Usage — How to use Prisma clients
- Migrations — Managing database migrations