The persisted data model of sophia, 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.
21Tables
593Columns
16Enums
17FK relations
Tables (21)#
id String PKtitle StringoriginalTitle String?type DocumentTypegenre DocumentGenre?status DocumentStatusauthor String?authors Jsoneditor String?translator String?publisher String?publicationPlace String?publicationYear Int?edition String?volume String?issue String? +55 moreid String PKdocumentId Stringindex Inttype ChunkTypetext StringstartOffset IntendOffset IntpageNumber Int?sectionTitle String?sectionIndex Int?paragraphIndex Int?tokenCount Int?charCount Int?embeddingModel String?embeddingDimension Int?embeddingVector Bytes? +12 moreFK:
document→Document Cascade · citationSources→Citationid String PKdocumentId StringchunkId String?citedText StringcitationStyle CitationStyleformattedCitation String?startOffset Int?endOffset Int?pageNumber Int?sourceTitle String?sourceAuthor String?sourceYear Int?sourceUrl String?sourceIdentifier String?confidence FloatverificationStatus VerificationStatus +15 moreFK:
document→Document Cascade · sourceChunk→DocumentChunkid String PKtype EntityTypename StringoriginalName String?aliases String[]description String?summary String?language Stringproperties Jsontradition String?traditions String[]category String?tags String[]labels String[]confidence EntityConfidenceverificationStatus VerificationStatus +20 moreFK:
outgoingRelations→Relation · incomingRelations→Relationid String PKentityId StringdocumentId StringchunkId String?startOffset IntendOffset Inttext StringcontextBefore String?contextAfter String?confidence Floatverified BooleancreatedAt DateTimeFK:
entity→Entity Cascade · document→Document Cascade · chunk→DocumentChunkid String PKtype RelationTypecustomType String?sourceId StringtargetId Stringweight Floatbidirectional Booleanproperties Jsonconfidence FloatverificationStatus VerificationStatusverifiedAt DateTime?verifiedBy String?evidenceDocumentId String?evidenceChunkId String?evidenceText String?evidenceType String? +10 moreFK:
source→Entity Cascade · target→Entity Cascadeid String PKname Stringslug Stringdescription String?summary String?category KnowledgePackCategorystatus KnowledgePackStatusvisibility KnowledgePackVisibilitytraditions String[]timePeriod String?regions String[]topics String[]tags String[]coverage Jsonversion StringpreviousVersionId String? +33 moreid String PKpackId StringdocumentId Stringorder Intnotes String?createdAt DateTimeFK:
pack→KnowledgePack Cascade · document→Document Cascadeid String PKpackId StringentityId Stringimportance Floatnotes String?createdAt DateTimeFK:
pack→KnowledgePack Cascade · entity→Entity Cascadeid String PKpackId StringuserId StringcreatedAt DateTimeFK:
pack→KnowledgePack Cascadeid String PKslug String uniqtitle Stringsummary StringprimaryDomain Stringdomains String[]origin Stringstatus Stringvisibility Stringtype StringcredibilityTier StringcredibilityScore Float?authorityScore Float?language String?originalLanguage String?originalTitle String? +25 moreid String PKslug String uniqname Stringsummary StringprimaryDomain Stringdomains String[]origin Stringstatus Stringvisibility Stringcategory Stringcomplexity Stringtags String[]lastPublishedAt DateTime?definition Stringdescription String?traditions String[] +6 moreid String PKslug String uniqtitle Stringsummary StringprimaryDomain Stringdomains String[]origin Stringstatus Stringvisibility Stringkind Stringmethodology String?preferredView StringitemCount IntlastOpenedAt DateTime?lastPublishedAt DateTime?tags String[] +12 moreid String PKslug String uniqtitle Stringsummary Stringdescription String?primaryDomain Stringdomains String[]kind Stringstatus Stringsubject Jsonclaims Jsonsources Jsonexcerpts Jsoncitations JsonretrievalTrace Jsonrationale Json +9 moreid String PKslug String uniqtitle Stringsummary StringprimaryDomain Stringdomains String[]kind Stringstatus Stringformat Stringlanguage Stringlocale StringanswerBody StringanswerHtml String?query JsongroundingSummary JsongroundingState String +18 moreid String PKslug String uniqprimaryDomain Stringdomains String[]status Stringsubject Jsonsource JsonexcerptKind Stringstance StringisDirectQuote Booleansnippet String?label Stringformat Jsonlocation Jsonscores Jsonverification Json +14 moreid String PKslug String uniqtitle Stringsummary StringprimaryDomain Stringdomains String[]status StringverificationStatus Stringsubject Jsonsteps Jsongaps JsoncoverageScore FloatconfidenceScore FloatoriginatingQueryId String?evidencePackId String?groundedAnswerId String? +5 moreid String PKslug String uniqtitle Stringsummary Stringdescription String?version StringsourceSetHash StringprimaryDomain Stringdomains String[]scope Jsonorigin Stringstatus Stringvisibility Stringkind Stringitems JsonselectionCriteria Json +16 moreid String PKslug String uniqtitle Stringsubtitle String?summary Stringabstract String?primaryDomain Stringdomains String[]kind Stringaudience Stringformat Stringstatus Stringvisibility Stringlanguage Stringlocale Stringsections Json +26 moreid String PKstatus IngestionJobStatusprogress IntcurrentStage String?sourceType SourceTypesourceUri StringsourceCredentials Json?documentId String?config JsonextractionConfig Json?enrichmentConfig Json?chunkingConfig Json?priority IntworkerId String?queueName String?retryCount Int +20 moreFK:
document→Documentid String PKaction StringentityType StringentityId StringpreviousState Json?newState Json?changes Json?userId String?ipAddress String?userAgent String?requestId String?metadata JsoncreatedAt DateTimeEnums (16)#
DocumentType14 valuesBOOKARTICLETHESISMANUSCRIPTSCRIPTURECOMMENTARYESSAYLETTERSPEECHTRANSLATIONANTHOLOGYENCYCLOPEDIADICTIONARYOTHERDocumentStatus10 valuesDRAFTINGESTINGEXTRACTINGENRICHINGCHUNKINGINDEXINGPUBLISHEDARCHIVEDFAILEDDELETEDDocumentGenre14 valuesRELIGIOUSPHILOSOPHICALHISTORICALSCHOLARLYPRACTICALDEVOTIONALCOMMENTARYNARRATIVEPOETRYLITURGICALLEGALBIOGRAPHICALINSTRUCTIONALOTHERRightsStatus4 valuesPUBLIC_DOMAINCREATIVE_COMMONSRESTRICTEDUNKNOWNChunkType6 valuesPARAGRAPHSENTENCESECTIONPAGESEMANTICCUSTOMCitationStyle6 valuesCHICAGOMLAAPAHARVARDTURABIANCUSTOMVerificationStatus5 valuesVERIFIEDREVIEWEDUNVERIFIEDDISPUTEDPENDINGEntityType15 valuesTRADITIONTEXTCONCEPTPRACTICEFIGUREPLACESCHOOLDOCTRINEEVENTTERMSYMBOLRITUALARTIFACTORGANIZATIONCUSTOMEntityConfidence5 valuesCERTAINPROBABLEPOSSIBLEUNCERTAININFERREDRelationType27 valuesTAUGHTSTUDIED_WITHINFLUENCEDWROTEEDITEDTRANSLATEDFOUNDEDMEMBER_OFBELONGS_TOLIVED_INBORN_INDIED_INLOCATED_INPRECEDEDSUCCEEDEDCONTEMPORARY_WITHREFERENCESQUOTESCITESRELATED_TOSIMILAR_TOOPPOSITE_OFDERIVED_FROMPART_OFRelationDirection3 valuesOUTGOINGINCOMINGBOTHKnowledgePackStatus5 valuesDRAFTREVIEWPUBLISHEDARCHIVEDDEPRECATEDKnowledgePackVisibility4 valuesPRIVATETEAMORGANIZATIONPUBLICKnowledgePackCategory8 valuesTRADITIONPERIODTOPICFIGURETEXTREGIONPRACTICECUSTOMIngestionJobStatus10 valuesPENDINGQUEUEDFETCHINGEXTRACTINGENRICHINGCHUNKINGINDEXINGCOMPLETEDFAILEDCANCELLEDSourceType6 valuesFILEURLAPIDATABASESTREAMARCHIVE