The persisted data model of bellona, 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.
11Tables
199Columns
14Enums
4FK relations
Tables (11)#
id String PKprojectId Stringstatus BuildStatuspriority JobPriorityprogress InttargetPlatforms Platform[]optimizationLevel OptimizationLevelincludeDebugSymbols BooleancompressionLevel CompressionLevelincremental BooleanassetIds String[]errorMessage String?errorCode String?retryCount IntmaxRetries IntworkerId String? +14 moreid String PKbuildId Stringname Stringplatform Platformpath Stringsize BigIntchecksum StringstorageBucket StringstorageKey StringmimeType String?metadata JsoncreatedAt DateTimeexpiresAt DateTime?deletedAt DateTime?FK:
build→Build Cascadeid String PKbuildId Stringlevel LogLevelmessage Stringdetails Json?source String?step String?timestamp DateTimeFK:
build→Build Cascadeid String PKprojectId StringbuildId String?status ExportStatusprogress Intformat ExportFormattargetEngine EngineType?includeSource Booleancompression CompressionLevelassetIds String[]downloadUrl String?size BigInt?checksum String?storageBucket String?storageKey String?errorMessage String? +10 moreFK:
build→Build SetNullid String PKprojectId Stringengine EngineTypeengineVersion Stringmodules String[]plugins String[]platforms Platform[]outputPath StringtemplateId String?includeAssets BooleanassetIds String[]settings Jsonstatus BuildStatuserrorMessage String?fileCount Int?totalSize BigInt? +10 moreid String PKprojectId Stringengine EngineTypeengineVersion String?status ConnectionStatushostname String?port Int?pid Int?sessionToken String?lastSyncAt DateTime?syncDirection SyncDirection?syncedAssetCount IntuserId StringorganizationId String?metadata JsoncreatedAt DateTime +6 moreid String PKsessionId StringassetId StringassetPath String?localVersion StringremoteVersion StringlocalChecksum String?remoteChecksum String?resolution String?resolvedAt DateTime?resolvedBy String?createdAt DateTimeupdatedAt DateTimeFK:
session→BridgeSession Cascadeid String PKname Stringhostname StringjobTypes JobType[]platforms Platform[]engines EngineType[]concurrency Intstatus WorkerStatuscurrentJobId String?lastHeartbeat DateTime?totalJobsProcessed IntsuccessfulJobs IntfailedJobs IntaverageJobDuration Float?version String?metadata Json +2 moreid String PKprojectId StringassetId Stringname Stringtype AssetTypepath Stringsize BigIntchecksum Stringtags String[]metadata JsonengineData JsoncreatedAt DateTimeupdatedAt DateTimelastAccessedAt DateTime?id String PKname Stringdescription String?platforms Platform[]engines EngineType[]optimizationLevel OptimizationLevelincludeDebugSymbols BooleancompressionLevel CompressionLevelsettings JsonisActive BooleanisDefault BooleanorganizationId String?createdBy StringcreatedAt DateTimeupdatedAt DateTimeid String PKaction StringentityType StringentityId StringpreviousState Json?newState Json?changes Json?userId String?ipAddress String?userAgent String?requestId String?metadata JsoncreatedAt DateTimeEnums (14)#
BuildStatus6 valuesPENDINGQUEUEDRUNNINGCOMPLETEDFAILEDCANCELLEDJobPriority4 valuesLOWNORMALHIGHCRITICALPlatform9 valuesWINDOWSMACOSLINUXIOSANDROIDWEBGLPLAYSTATIONXBOXSWITCHEngineType5 valuesUNITYUNREALGODOTBLENDERWEBExportFormat5 valuesZIPTAR_GZUNITYPACKAGEUASSETGODOT_PCKExportStatus5 valuesPENDINGPROCESSINGCOMPLETEDFAILEDEXPIREDOptimizationLevel3 valuesNONEBASICFULLCompressionLevel3 valuesLOWMEDIUMHIGHLogLevel4 valuesDEBUGINFOWARNINGERRORConnectionStatus4 valuesCONNECTEDDISCONNECTEDSYNCINGERRORSyncDirection3 valuesPUSHPULLBIDIRECTIONALAssetType9 valuesTEXTUREMODELAUDIOANIMATIONMATERIALPREFABSCRIPTCONFIGOTHERJobType4 valuesASSET_BAKEVALIDATEENGINE_PROJECT_GENERATEEXPORT_PACKAGEWorkerStatus6 valuesIDLEBUSYPAUSEDSTOPPINGSTOPPEDOFFLINE