 Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory : /home/gositeme/domains/lavocat.quebec/public_html/prisma/ |
generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "mysql"
url = env("DATABASE_URL")
}
// Production-specific models and configurations
// This schema extends the main schema with production optimizations
model User {
id String @id @default(cuid())
email String @unique
name String?
password String
role String @default("USER")
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
resetPasswordToken String?
resetPasswordTokenExpiry DateTime?
reminders String?
username String? @unique
profilePicture String?
bio String?
title String?
specialization String?
barNumber String?
yearsOfExperience Int?
education String?
certifications String?
officeLocation String?
workPhone String?
linkedinUrl String?
websiteUrl String?
availability String?
timezone String?
pronouns String?
isProfilePublic Boolean @default(false)
lastActive DateTime?
hourlyRate Float?
proBono Boolean @default(false)
boldnessRating Float?
transparencyRating Float?
winRate Float?
totalCases Int @default(0)
wonCases Int @default(0)
lostCases Int @default(0)
averageRating Float?
isVerified Boolean @default(false)
xpPoints Int @default(0)
level Int @default(1)
currentStreak Int @default(0)
totalBadges Int @default(0)
reviewsWritten Int @default(0)
forumPosts Int @default(0)
helpedOthers Int @default(0)
totalEndorsements Int @default(0)
profileViews Int @default(0)
observationHours Float @default(0)
reformProposals Int @default(0)
wisdomScore Float @default(0)
civicEngagement Float @default(0)
accountBalance Float @default(0.0)
isPaymentVerified Boolean @default(false)
donationTotal Float @default(0.0)
subscriptionTier String?
subscriptionExpiry DateTime?
theme String @default("light")
gender String?
phone String?
address String?
emergencyContact String?
emergencyPhone String?
dateOfBirth DateTime?
occupation String?
language String @default("en")
notifications Boolean @default(true)
lawFirmId String?
isActive Boolean @default(true)
status String @default("ACTIVE")
experience Int?
rating Float?
profile UserProfile?
businessProfiles BusinessProfile[] @relation("BusinessProfileMembers")
ownedBusinessProfiles BusinessProfile[] @relation("BusinessProfileOwner")
chatParticipants ChatParticipant[]
createdChatRooms ChatRoom[] @relation("CreatedChatRooms")
sentDirectMessages DirectMessage[] @relation("SentDirectMessages")
receivedDirectMessages DirectMessage[] @relation("ReceivedDirectMessages")
documents Document[] @relation("UserDocuments")
messages Message[]
MessageReaction MessageReaction[]
adminChats PrivateChat[] @relation("AdminChats")
privateChats PrivateChat[]
privateMessages PrivateMessage[]
createdRegistrations Registration[] @relation("CreatedRegistrations")
registrations Registration[]
sessions Session[]
themeProfiles ThemeProfile[]
analyticsEvents AnalyticsTracking[]
automationRules AutomationRule[]
impersonationSessions ImpersonationSession[] @relation("OriginalUserImpersonationSessions")
impersonatedSessions ImpersonationSession[] @relation("ImpersonatedUserImpersonationSessions")
legalCases LegalCase[] @relation("CreatedCases")
assignedCases LegalCase[] @relation("AssignedCases")
caseUpdates CaseUpdate[]
lawFirm LawFirm? @relation(fields: [lawFirmId], references: [id])
lawyerRatings LawyerRating[] @relation("RatedLawyer")
receivedRatings LawyerRating[] @relation("RatedBy")
caseOffers CaseOffer[]
userBadges UserBadge[]
achievements UserAchievement[]
donations Donation[]
payments Payment[]
escrowAccounts EscrowAccount[]
escrowReleases EscrowRelease[]
transactions Transaction[]
paymentRefunds PaymentRefund[]
financialSummaries FinancialSummary[]
courseEnrollments CourseEnrollment[]
mentorSessions MentorSession[]
lawResources LawResource[]
userDegrees UserDegree[]
degreeCeremonies DegreeCeremony[]
brotherhoodMentorships BrotherhoodMentorship[] @relation("Mentor")
receivedMentorships BrotherhoodMentorship[] @relation("Mentee")
mentorshipSessions MentorshipSession[]
lodgeMemberships LodgeMembership[]
caseSupports CaseSupport[]
clientLawyerRelationships ClientLawyerRelationship[] @relation("Client")
lawyerClientRelationships ClientLawyerRelationship[] @relation("Lawyer")
relationshipMilestones RelationshipMilestone[]
lawyerStats LawyerStats?
clientTestimonials ClientTestimonial[]
userSubscriptions UserSubscription[]
consultationBookings ConsultationBooking[] @relation("ClientBookings")
lawyerBookings ConsultationBooking[] @relation("LawyerBookings")
tasks Task[]
calendarEvents CalendarEvent[]
documentCollaborations DocumentCollaboration[]
clientPortals ClientPortal[]
notifications Notification[]
automationTasks AutomationTask[]
automationLogs AutomationLog[]
retainerAgreements RetainerAgreement[]
caseCompetitionParticipants CaseCompetitionParticipant[]
caseBids CaseBid[]
assistantProfile AssistantProfile?
clerkProfile ClerkProfile?
caseComments CaseComment[]
commentAttachments CommentAttachment[]
commentLikes CommentLike[]
commentReactions CommentReaction[]
commentReports CommentReport[]
lawyerRequests LawyerRequest[]
caseChatMessages CaseChatMessage[]
friendships Friendship[] @relation("UserFriendships")
receivedFriendships Friendship[] @relation("FriendOf")
searchAnalytics SearchAnalytics[]
endorsements Endorsement[] @relation("EndorsedBy")
receivedEndorsements Endorsement[] @relation("EndorsedUser")
userLevelHistory UserLevelHistory[]
reviews Review[] @relation("ReviewedBy")
receivedReviews Review[] @relation("ReviewedUser")
forumPosts ForumPost[]
testimonials Testimonial[]
userFollows UserFollow[] @relation("Following")
followers UserFollow[] @relation("FollowedBy")
@@index([email])
@@index([role])
@@index([isVerified])
@@index([isActive])
@@index([createdAt])
}
// Include other models as needed for production
// This is a simplified version - you may want to include all models from your main schema