The persisted data model of nisaba, 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.
16Tables
328Columns
13Enums
8FK relations
Tables (16)#
id String PKsiglum Stringname StringalternateNames String[]catalogNumber String?material ManuscriptMaterial?scriptType ManuscriptScriptType?scriptDescription String?dimensions Json?folioCount Int?columnCount Int?linesPerColumn Int?contents String?languages String[]writingSystem String?origin String? +29 moreid String PKname Stringdescription String?baseText String?witnesses String[]collationMethod String?config Jsonstatus ProjectStatusprogress FloattotalVariantUnits IntsignificantVariants Intmetadata JsonownerId StringcreatedAt DateTimeupdatedAt DateTimecompletedAt DateTime? +2 moreid String PKcollationProjectId Stringreference StringstartOffset IntendOffset IntbaseReading Stringlemma String?readings Jsonclassification VariantClassification?cause VariantCause?significance IntpreferredReading String?rationale String?evidenceGrade EvidenceGrade?manuscriptId String?notes String? +3 moreFK:
collationProject→CollationProject Cascade · manuscript→Manuscriptid String PKtitle Stringdescription String?version StringcollationProjectId String?text Stringapparatus JsonapparatusFormat ApparatusFormatstatus EditionStatuseditor String?editors Jsonmethodology String?bibliography Jsonmetadata JsonownerId StringcreatedAt DateTime +2 moreFK:
collationProject→CollationProjectid String PKtargetUri StringtargetType StringtargetSelector Json?type AnnotationTypebody StringbodyFormat Stringlanguage String?motivation String?status AnnotationStatuslayerId String?manuscriptId String?tags String[]metadata JsonownerId StringprojectId String? +3 moreFK:
layer→AnnotationLayer · manuscript→Manuscriptid String PKname Stringdescription String?color String?scope String?permissions Jsonmetadata JsonownerId StringcreatedAt DateTimeupdatedAt DateTimeannotations Annotation[]id String PKsourceTradition StringsourceConcept StringsourceLanguage StringsourceReference String?targetTradition StringtargetConcept StringtargetLanguage StringtargetReference String?similarityType SimilarityTypesimilarityScore FloatevidenceGrade EvidenceGradeconsensusLevel ConsensusLevelevidence Jsonbibliography Jsonnotes String? +4 moreid String PKmotifId StringmotifName StringmotifCategory String?tradition StringtextReference Stringpassage String?language String?function String?context String?dating String?evidenceGrade EvidenceGradebibliography Jsonmetadata JsonownerId StringcreatedAt DateTime +1 moreid String PKsourceId StringsourceType StringsourceTradition StringtargetId StringtargetType StringtargetTradition StringinfluenceType Stringdirection Stringstrength FloatevidenceGrade EvidenceGradeconsensusLevel ConsensusLeveldateEarliest Int?dateLatest Int?period String?evidence Json +6 moreid String PKtradition Stringcanon Stringcollection String?bookId StringbookName StringbookAbbreviation String?alternateNames String[]chapterCount Int?verseCount Int?structure Json?canonicalOrder IntoriginalLanguage String?languages String[]versificationScheme String?versificationMap Json? +4 moreid String PKslug String uniqtitle Stringsummary StringprimaryDomain Stringdomains String[]origin Stringstatus Stringvisibility Stringreference Jsonlanguage JsonoriginalLanguage Json?traditions String[]textFormat StringwordCount Inttags String[] +11 moreid String PKmanuscriptId StringscriptClassification String?dateEstimate String?dateEarliest Int?dateLatest Int?dateConfidence EvidenceGrade?region String?features JsonletterForms Jsonabbreviations Jsonligatures JsonhandCount IntrulingPattern String?inkDescription String?decorations Json +9 moreFK:
manuscript→Manuscript Cascadeid String PKmanuscriptId StringanalysisId String?handLabel StringhandDescription String?folioRange String?startFolio String?endFolio String?scriptStyle String?characteristics JsonletterForms JsondateEstimate String?dateConfidence EvidenceGrade?scribeName String?scribeIdentification String?notes String? +3 moreFK:
manuscript→Manuscript Cascade · analysis→PaleographicAnalysisid String PKname Stringdescription String?type ProjectTypestatus ProjectStatusconfig Jsontraditions String[]languages String[]members Jsonprogress Floatmilestones Jsontags String[]metadata JsonownerId StringorganizationId String?createdAt DateTime +2 moreid String PKitemType StringitemId StringitemTitle Stringcollection String?tags String[]readingStatus String?readingProgress Float?notes String?highlights Jsoncitation String?metadata JsonownerId StringcreatedAt DateTimeupdatedAt DateTimeid String PKtargetUri StringtargetTitle StringtargetType Stringposition Json?label String?notes String?color String?folder String?tags String[]sortOrder Intmetadata JsonownerId StringcreatedAt DateTimeupdatedAt DateTimeEnums (13)#
ManuscriptMaterial15 valuesPAPYRUSPARCHMENTVELLUMCLAY_TABLETPAPERSTONEMETALWOODBAMBOOPALM_LEAFSILKBONECERAMICWAX_TABLETOTHERManuscriptScriptType16 valuesUNCIALMINUSCULEMAJUSCULECURSIVESEMI_CURSIVEHIERATICDEMOTICCUNEIFORM_WEDGESQUARE_HEBREWPROTO_HEBREWKUFICNASKHNASTALIQBRAHMIDEVANAGARIOTHERVariantClassification22 valuesORTHOGRAPHICPHONETICMORPHOLOGICALLEXICALSYNTACTICTRANSPOSITIONADDITIONOMISSIONSUBSTITUTIONCONFLATIONHARMONIZATIONHOMOEOTELEUTONHOMOEOARCTONDITTOGRAPHYHAPLOGRAPHYMETATHESISCORRECTIONMARGINAL_NOTEGLOSSINTERPOLATIONLACUNAOTHERVariantCause10 valuesSCRIBAL_ERRORDELIBERATE_CHANGETHEOLOGICAL_MOTIVATIONHARMONIZATIONLITURGICAL_ADAPTATIONSTYLISTIC_IMPROVEMENTCLARIFICATIONCENSORSHIPDAMAGEUNCERTAINApparatusFormat5 valuesPOSITIVENEGATIVEFULLSELECTIVELEIDEN_PLUSAnnotationType13 valuesCOMMENTHIGHLIGHTBOOKMARKTAGCLASSIFICATIONLINKINGDESCRIBINGIDENTIFYINGMODERATINGQUESTIONINGREPLYINGTRANSLATIONTRANSCRIPTIONAnnotationStatus6 valuesACTIVEARCHIVEDDELETEDUNDER_REVIEWAPPROVEDREJECTEDSimilarityType13 valuesTHEMATICLEXICALSTRUCTURALGENEALOGICALTYPOLOGICALMORPHOLOGICALPHONETICSEMANTICSYNTACTICNARRATIVEDOCTRINALRITUALICONOGRAPHICEvidenceGrade7 valuesCERTAINHIGHLY_PROBABLEPROBABLEPOSSIBLEUNCERTAINSPECULATIVEDISPUTEDConsensusLevel7 valuesUNIVERSALSTRONGMAJORITYDIVIDEDMINORITYINDIVIDUALUNKNOWNProjectStatus6 valuesPLANNINGACTIVEON_HOLDCOMPLETEDARCHIVEDCANCELLEDProjectType9 valuesTEXT_EDITIONCOLLATIONTRANSLATIONCOMMENTARYCOMPARATIVE_STUDYPALEOGRAPHIC_ANALYSISCORPUS_BUILDINGLEXICOGRAPHYOTHEREditionStatus7 valuesDRAFTIN_PROGRESSREVIEWPUBLISHEDREVISEDSUPERSEDEDWITHDRAWN