Data Model

Overview

• Parsed entities: 15
• Source: prisma/schema.prisma

ActivityLog

• Kind: model
• Summary: 17 fields
• id: String
• userId: String
• user: User
• teamId: String?
• team: Team?
• categoryId: String
• category: Category
• projectId: String
• project: Project
• localDate: String

AuditLog

• Kind: model
• Summary: 11 fields
• id: String
• userId: String?
• user: User?
• teamId: String?
• team: Team?
• action: String
• targetType: String?
• targetId: String?
• metadata: Json?
• ipAddress: String?

Category

• Kind: model
• Summary: 8 fields
• id: String
• userId: String
• user: User
• name: String
• createdAt: DateTime
• updatedAt: DateTime
• logs: ActivityLog[]
• plans: DailyPlanAllocation[]

DailyNarrative

• Kind: model
• Summary: 10 fields
• id: String
• userId: String
• user: User
• teamId: String?
• team: Team?
• localDate: String
• content: String
• model: String
• createdAt: DateTime
• updatedAt: DateTime

DailyPlanAllocation

• Kind: model
• Summary: 14 fields
• id: String
• userId: String
• user: User
• teamId: String?
• team: Team?
• localDate: String
• dimension: PlanDimension
• categoryId: String?
• category: Category?
• projectId: String?

ExportFormat

• Kind: enum
• Summary: 2 values
• CSV
• PDF

ExportFrequency

• Kind: enum
• Summary: 3 values
• DAILY
• WEEKLY
• MONTHLY

ExportScope

• Kind: enum
• Summary: 2 values
• PERSONAL
• TEAM

PlanDimension

• Kind: enum
• Summary: 2 values
• CATEGORY
• PROJECT

Project

• Kind: model
• Summary: 10 fields
• id: String
• userId: String
• user: User
• name: String
• color: String
• isActive: Boolean
• createdAt: DateTime
• updatedAt: DateTime
• logs: ActivityLog[]
• plans: DailyPlanAllocation[]

ScheduledExport

• Kind: model
• Summary: 14 fields
• id: String
• userId: String
• user: User
• teamId: String?
• team: Team?
• frequency: ExportFrequency
• format: ExportFormat
• scope: ExportScope
• targetPath: String
• isActive: Boolean

Team

• Kind: model
• Summary: 10 fields
• id: String
• name: String
• createdAt: DateTime
• updatedAt: DateTime
• members: TeamMember[]
• logs: ActivityLog[]
• plans: DailyPlanAllocation[]
• scheduledExports: ScheduledExport[]
• narratives: DailyNarrative[]
• auditLogs: AuditLog[]

TeamMember

• Kind: model
• Summary: 8 fields
• id: String
• teamId: String
• team: Team
• userId: String
• user: User
• role: TeamRole
• createdAt: DateTime
• updatedAt: DateTime

TeamRole

• Kind: enum
• Summary: 3 values
• OWNER
• ADMIN
• MEMBER

User

• Kind: model
• Summary: 14 fields
• id: String
• email: String
• passwordHash: String
• displayName: String?
• createdAt: DateTime
• updatedAt: DateTime
• categories: Category[]
• projects: Project[]
• logs: ActivityLog[]
• teamMember: TeamMember?