Database

Copymodel School {
  id           String  @id @default(cuid())
  name         String
  domain       String  @unique          // e.g. "kingfahad"
  preferredLanguage String @default("ar")
  logoUrl      String?
  address      String?
  phoneNumber  String?
  email        String?
  timezone     String  @default("Africa/Khartoum")
  schoolType   String?                  // private, public, international, technical, special
  schoolLevel  String?                  // primary, secondary, both
  curriculum   String?                  // @map column: timetable-structure slug ("us-standard"); curriculum CODE (US/SD/GB/IB-DP) is inferred at runtime, not stored
  planType     String  @default("basic")
  maxStudents  Int     @default(100)
  maxTeachers  Int     @default(10)
  isActive     Boolean @default(true)
}

Copy// correct — always include schoolId
await db.student.findMany({ where: { schoolId } })
 
// wrong — leaks data across tenants
await db.student.findMany()

Copymodel SubscriptionTier {
  id           String   @id @default(cuid())
  name         String   // basic, premium, enterprise
  monthlyPrice Int      // cents
  annualPrice  Int      // cents
  maxStudents  Int
  features     String[]
  isActive     Boolean  @default(true)
 
  subscriptions Subscription[]
  discounts     Discount[]
}
 
model Discount {
  id          String   @id @default(cuid())
  schoolId    String
  tierId      String
  code        String   @unique
  type        String   // percentage, fixed
  value       Int
  validFrom   DateTime
  validUntil  DateTime
  maxUses     Int?
  currentUses Int      @default(0)
 
  school           School           @relation(fields: [schoolId], references: [id])
  subscriptionTier SubscriptionTier @relation(fields: [tierId], references: [id])
}

Copymodel LegalConsent {
  id              String    @id @default(cuid())
  schoolId        String
  userId          String
  documentType    String    // terms, privacy, data-processing
  documentVersion String
  consentType     String    // explicit, implicit, parental
  ipAddress       String?
  userAgent       String?
  consentedAt     DateTime  @default(now())
  revokedAt       DateTime?
 
  @@unique([schoolId, userId, documentType, documentVersion])
}
 
model LegalDocument {
  id               String    @id @default(cuid())
  schoolId         String
  type             String    // terms, privacy, data-processing
  version          String
  content          String    @db.Text
  effectiveFrom    DateTime
  effectiveUntil   DateTime?
  isActive         Boolean   @default(true)
  requiresExplicit Boolean   @default(true)
}
 
model ComplianceLog {
  id        String   @id @default(cuid())
  schoolId  String
  eventType String
  eventData Json
  userId    String?
  timestamp DateTime @default(now())
}

Copymodel Announcement {
  title String?
  body  String? @db.Text
  lang  String  @default("ar")
}
 
model Translation {
  id             String   @id @default(cuid())
  schoolId       String
  sourceText     String   @db.Text
  sourceLanguage String                       // "ar" or "en"
  targetLanguage String                       // "ar" or "en"
  translatedText String   @db.Text
  provider       String   @default("google")
  hitCount       Int      @default(0)
  lastAccessedAt DateTime @default(now())
 
  @@unique([schoolId, sourceText, sourceLanguage, targetLanguage])
  @@index([schoolId, sourceLanguage, targetLanguage])
  @@index([lastAccessedAt])
}

Copyimport { getText } from "@/components/translation/display"
 
// Stored in Arabic, viewing in English → translates and caches
const title = await getText("مرحبا", "ar", "en", schoolId)
 
// Same language → returns directly, no API call
const title = await getText("مرحبا", "ar", "ar", schoolId)

CopyCREATE INDEX idx_students_school_id   ON students(school_id);
CREATE INDEX idx_teachers_school_id   ON teachers(school_id);
CREATE INDEX idx_classes_school_id    ON classes(school_id);
CREATE INDEX idx_attendance_school_id ON attendance(school_id);

CopyDATABASE_URL="postgresql://username:password@host:port/database"
DEFAULT_SCHOOL_DOMAIN="demo"
ALLOW_SCHOOL_SIGNUP="true"
BASIC_MAX_STUDENTS=100
PREMIUM_MAX_STUDENTS=500
ENTERPRISE_MAX_STUDENTS=2000

Copypnpm prisma generate                       # Regenerate client
pnpm prisma migrate dev --name <name>      # LOCAL only — creates + applies a migration
pnpm db:seed:single <name>                 # Seed one module — never `pnpm db:seed`

Copy# The FOLDER, not prisma/schema.prisma. prisma.config.ts loads models from prisma/, so
# pointing at the lone datasource file yields an EMPTY datamodel — and the diff then claims
# 719 dropped foreign keys and 328 dropped tables. That is an artifact of the argument, not
# drift. Real drift is a couple of dozen lines.
pnpm prisma migrate diff --from-url "$PROD_DATABASE_URL" --to-schema-datamodel prisma --script