The persisted data model of yemaya, generated from its schema.prisma — every table (Prisma model + its Postgres @@map name), its columns, the enums it defines, and the foreign-key edges that wire them together.
38Tables
496Columns
21Enums
45FK relations
Tables (38)#
id String PKemail String uniqemailVerified DateTime?passwordHash String?firstName String?lastName String?displayName String?avatarUrl String?bio String?locale Stringtimezone Stringstatus UserStatuslastLoginAt DateTime?createdAt DateTimeupdatedAt DateTimedeletedAt DateTime? +9 moreFK:
ownedProjects→Project · assets→Assetid String PKuserId String uniqtheme StringcompactMode BooleannotifyEmail BooleannotifyInApp BooleanautoSave BooleanautoSaveInterval Intpreferences JsoncreatedAt DateTimeupdatedAt DateTimeFK:
user→User Cascadeid String PKuserId Stringtype Stringprovider StringproviderAccountId StringrefreshToken String?accessToken String?expiresAt Int?tokenType String?scope String?idToken String?sessionState String?createdAt DateTimeupdatedAt DateTimeFK:
user→User Cascadeid String PKuserId Stringtoken String uniqexpiresAt DateTimeipAddress String?userAgent String?createdAt DateTimeupdatedAt DateTimeFK:
user→User Cascadeid String PKuserId Stringname StringkeyHash String uniqkeyPrefix Stringscopes String[]lastUsedAt DateTime?expiresAt DateTime?createdAt DateTimeupdatedAt DateTimeFK:
user→User Cascadeid String PKname Stringslug String uniqdescription String?logoUrl String?website String?plan OrganizationPlansettings JsoncreatedAt DateTimeupdatedAt DateTimedeletedAt DateTime?members OrganizationMember[]teams Team[]projects Project[]invitations OrganizationInvitation[]subscription Subscription?id String PKorganizationId StringuserId Stringrole OrganizationRolejoinedAt DateTimeupdatedAt DateTimeFK:
organization→Organization Cascade · user→User Cascadeid String PKorganizationId Stringemail Stringrole OrganizationRoletoken String uniqexpiresAt DateTimeacceptedAt DateTime?createdAt DateTimeupdatedAt DateTimeFK:
organization→Organization Cascadeid String PKorganizationId Stringname Stringslug Stringdescription String?color String?iconUrl String?settings JsoncreatedAt DateTimeupdatedAt DateTimedeletedAt DateTime?members TeamMember[]projects TeamProject[]FK:
organization→Organization Cascadeid String PKteamId StringuserId Stringrole TeamRolejoinedAt DateTimeupdatedAt DateTimeFK:
team→Team Cascadeid String PKteamId StringprojectId Stringaccess ProjectAccesscreatedAt DateTimeupdatedAt DateTimeFK:
team→Team Cascade · project→Project Cascadeid String PKname Stringslug Stringdescription String?thumbnailUrl String?type ProjectTypestatus ProjectStatusvisibility VisibilityorganizationId String?ownerId Stringsettings Jsonmetadata JsoncreatedAt DateTimeupdatedAt DateTimedeletedAt DateTime?hathorWorldId String? +8 moreFK:
organization→Organization SetNull · owner→Userid String PKprojectId StringuserId Stringrole ProjectRoleinvitedBy String?joinedAt DateTimeupdatedAt DateTimeFK:
project→Project Cascade · user→User Cascadeid String PKprojectId StringtagId StringcreatedAt DateTimeFK:
project→Project Cascade · tag→Tag Cascadeid String PKprojectId StringfolderId String?creatorId Stringname Stringdescription String?type AssetTypestatus AssetStatusmimeType String?fileSize BigInt?storageKey StringstorageUrl String?thumbnailUrl String?previewUrl String?metadata Jsonversion Int +9 moreFK:
project→Project Cascade · folder→Folder SetNull · creator→Userid String PKassetId StringtagId StringcreatedAt DateTimeFK:
asset→Asset Cascade · tag→Tag Cascadeid String PKassetId Stringcontext StringentityId StringcreatedAt DateTimeFK:
asset→Asset Cascadeid String PKprojectId StringparentId String?name Stringcolor String?icon String?sortOrder IntcreatedAt DateTimeupdatedAt DateTimedeletedAt DateTime?assets Asset[]FK:
project→Project Cascade · parent→Folder SetNull · children→Folderid String PKorganizationId String?name Stringslug Stringcolor String?description String?createdAt DateTimeupdatedAt DateTimeassets AssetTag[]projects ProjectTag[]id String PKassetId String?authorId StringparentId String?content Stringresolved Booleanpinned Booleanmetadata JsoncreatedAt DateTimeupdatedAt DateTimedeletedAt DateTime?FK:
asset→Asset Cascade · author→User · parent→Comment SetNull · replies→Commentid String PKprojectId String?userId Stringtype ActivityTypeaction StringentityId String?details JsonipAddress String?createdAt DateTimeFK:
project→Project SetNull · user→Userid String PKuserId Stringtype NotificationTypetitle Stringmessage String?link String?metadata Jsonread BooleanreadAt DateTime?createdAt DateTimeFK:
user→User Cascadeid String PKslug String uniqtitle Stringsummary StringprimaryDomain Stringdomains String[]origin Stringstatus Stringvisibility Stringkind StringmembershipMode StringitemCount IntprogressPercent Float?coverImageUrl String?lastOpenedAt DateTime?lastPublishedAt DateTime? +9 moreid String PKincidentKey String uniqslug String uniqtitle Stringsummary Stringdescription String?primaryDomain Stringdomains String[]category Stringseverity Stringstatus Stringqueue StringblastRadius Stringsource JsoncustomerImpact JsondeclaredById String? +23 moreid String PKcaseKey String uniqslug String uniqtitle Stringsummary Stringdescription String?primaryDomain Stringdomains String[]kind Stringcategory Stringstatus Stringpriority Stringchannel Stringqueue Stringrequester JsonopenedById String? +11 moreid String PKorganizationId String?projectId String?name Stringurl Stringsecret String?events String[]headers Jsonenabled BooleanretryCount IntretryDelay IntlastTriggeredAt DateTime?createdAt DateTimeupdatedAt DateTimedeliveries WebhookDelivery[]id String PKwebhookId Stringevent Stringpayload Jsonstatus WebhookDeliveryStatusstatusCode Int?response String?errorMessage String?attempts IntnextRetryAt DateTime?deliveredAt DateTime?createdAt DateTimeFK:
webhook→Webhook Cascadeid String PKorganizationId String uniqplan SubscriptionPlanstatus SubscriptionStatusstripeCustomerId String? uniqstripeSubId String? uniqcurrentPeriodStart DateTime?currentPeriodEnd DateTime?cancelAtPeriodEnd BooleantrialEndsAt DateTime?metadata JsoncreatedAt DateTimeupdatedAt DateTimeinvoices Invoice[]usageRecords UsageRecord[]credits CreditBalance?FK:
organization→Organization Cascadeid String PKsubscriptionId StringstripeInvoiceId String? uniqnumber String?status InvoiceStatusamount Intcurrency StringperiodStart DateTime?periodEnd DateTime?paidAt DateTime?dueDate DateTime?pdf String?metadata JsoncreatedAt DateTimeupdatedAt DateTimelineItems InvoiceLineItem[]FK:
subscription→Subscription Cascadeid String PKinvoiceId Stringdescription Stringquantity IntunitAmount Intamount IntcreatedAt DateTimeFK:
invoice→Invoice Cascadeid String PKsubscriptionId Stringmetric Stringquantity Inttimestamp DateTimemetadata JsonFK:
subscription→Subscription Cascadeid String PKsubscriptionId String uniqbalance Intcurrency StringupdatedAt DateTimetransactions CreditTransaction[]FK:
subscription→Subscription Cascadeid String PKcreditBalanceId Stringtype CreditTransactionTypeamount Intdescription String?referenceId String?metadata JsoncreatedAt DateTimeFK:
creditBalance→CreditBalance Cascadeid String PKslug String uniqname StringshortDescription String?description String?category PluginCategoryiconUrl String?coverUrl String?authorName StringauthorUrl String?repositoryUrl String?documentationUrl String?supportUrl String?license String?pricing PluginPricingprice Int? +14 moreid String PKpluginId Stringversion Stringchangelog String?minAppVersion String?maxAppVersion String?downloadUrl Stringchecksum String?fileSize Int?published BooleancreatedAt DateTimeupdatedAt DateTimeFK:
plugin→Plugin Cascadeid String PKpluginId StringorganizationId String?projectId String?userId String?version Stringenabled Booleansettings JsoninstalledAt DateTimeupdatedAt DateTimeFK:
plugin→Plugin Cascadeid String PKpluginId StringuserId Stringrating Inttitle String?content String?helpful Intverified BooleancreatedAt DateTimeupdatedAt DateTimedeletedAt DateTime?FK:
plugin→Plugin Cascadeid String PKorganizationId String?userId String?action StringentityType String?entityId String?oldValues Json?newValues Json?ipAddress String?userAgent String?metadata JsoncreatedAt DateTimeEnums (21)#
UserStatus4 valuesACTIVEINACTIVESUSPENDEDPENDING_VERIFICATIONOrganizationPlan4 valuesFREESTARTERPROFESSIONALENTERPRISEOrganizationRole4 valuesOWNERADMINMEMBERVIEWERTeamRole2 valuesLEADMEMBERProjectAccess3 valuesVIEWEDITADMINProjectType7 valuesFILMGAMEANIMATIONCOMMERCIALMUSIC_VIDEODOCUMENTARYOTHERProjectStatus5 valuesDRAFTACTIVEREVIEWCOMPLETEDARCHIVEDVisibility4 valuesPRIVATETEAMORGANIZATIONPUBLICProjectRole5 valuesOWNERADMINEDITORCONTRIBUTORVIEWERAssetType15 valuesIMAGEVIDEOAUDIOMODEL_3DDOCUMENTSCRIPTSTORYBOARDCHARACTER_DESIGNENVIRONMENT_DESIGNANIMATIONVFXMATERIALTEXTUREFONTOTHERAssetStatus6 valuesDRAFTPROCESSINGREVIEWAPPROVEDREJECTEDARCHIVEDActivityType6 valuesPROJECTASSETUSERTEAMORGANIZATIONSYSTEMNotificationType7 valuesMENTIONCOMMENTINVITATIONASSIGNMENTAPPROVALSYSTEMALERTWebhookDeliveryStatus4 valuesPENDINGSUCCESSFAILEDRETRYINGSubscriptionPlan4 valuesFREESTARTERPROFESSIONALENTERPRISESubscriptionStatus5 valuesACTIVEPAST_DUECANCELLEDTRIALINGPAUSEDInvoiceStatus5 valuesDRAFTOPENPAIDVOIDUNCOLLECTIBLECreditTransactionType6 valuesPURCHASEUSAGEREFUNDBONUSADJUSTMENTEXPIRATIONPluginCategory9 valuesGENERATIONEDITINGEXPORTINTEGRATIONUTILITYCOLLABORATIONANALYTICSAUTOMATIONOTHERPluginPricing4 valuesFREEPAIDFREEMIUMSUBSCRIPTIONPluginStatus6 valuesPENDINGAPPROVEDREJECTEDPUBLISHEDDEPRECATEDREMOVED