Model structure

Dataset, LemmaIdgloss, Gloss

erDiagram
    Dataset {
        CharField name
        BooleanField is_public
        TextField description
        TextField conditions_of_use
        TextField copyright
        TextField reference
        CharField acronym
    }
    SignLanguage {
        CharField name
        TextField description
    }
    LemmaIdgloss {
        *none* *none*
    }
    Gloss {
        BooleanField archived
        BooleanField bsltf
        BooleanField asltf
        CharField aslgloss
        *etc* *etc*
    }
    "Morpheme(Gloss)" {
        FieldChoiceForeignKey mrpType
    }
    Dialect {
        CharField name
        TextField description
    }
    Language {
        CharField name
        CharField language_code_2char
        CharField language_code_3char
        TextField description
    }
    LemmaIdglossTranslation {
        CharField text
    }
    Handshape {
        IntegerField machine_value
        CharField name
        ColorField field_color
    }
    
    
    Dataset ||--o{ LemmaIdgloss : ""
    Dataset }o--o{ Language : translation_language
    Dataset }o--o| Language : default_language
    Dataset ||--o{ SignLanguage : ""
    
    LemmaIdgloss ||--o{ Gloss : ""
    LemmaIdgloss ||--o{ LemmaIdglossTranslation : ""
    Language ||--o{ LemmaIdglossTranslation : ""
    
    SignLanguage ||--o{ Dialect : ""
    Dialect }o--o{ Gloss : ""
    SignLanguage }o--o{ Gloss : ""
    
    Gloss }o--|| Handshape : domhndsh
    Gloss }o--|| Handshape : subhndsh
    Gloss }o--|| Handshape : final_domhndsh
    Gloss }o--|| Handshape : final_subhndsh
    Gloss }o--o{ "Morpheme(Gloss)" : morphemePart

Loading

Gloss and Sense

erDiagram
    Gloss {
        BooleanField archived
        BooleanField bsltf
        BooleanField asltf
        CharField aslgloss
        *etc* *etc*
    }
    Language {
        CharField name
        CharField language_code_2char
        CharField language_code_3char
        TextField description
    }
    Sense {
        *none* *none*
    }
    GlossSense {
        IntegerField order
    }
    SenseTranslation {
        *none* *none*
    }
    ExampleSentence {
        FieldChoiceForeignKey sentenceType
        BooleanField negative
    }
    SenseExamplesentence {
        IntegerField order
    }
    Translation {
        IntegerField index
        IntegerField orderIndex
    }
    ExampleSentenceTranslation {
        TextField text
    }
    Keyword {
        CharField text
    }    
    
    SenseTranslation }o--o{ Translation : ""
    Translation }o--|| Gloss : "gloss"
    Translation }o--|| Keyword : "translation"
    Translation }o--|| Language : "language"    
    GlossSense }o--|| Gloss : "gloss"
    GlossSense }o--|| Sense : "sense"
    Sense }o--o{ SenseTranslation : ""
    Sense }o--o| SenseExamplesentence : ""
    SenseExamplesentence |o--o{ ExampleSentence : ""
    SenseTranslation }o--|| Language : "language"
    ExampleSentenceTranslation }o--|| ExampleSentence : "examplesentence"
    Language ||--o{ ExampleSentenceTranslation : ""

Loading

AnnotatedSentence

erDiagram
    Gloss {
        BooleanField archived
        BooleanField bsltf
        BooleanField asltf
        CharField aslgloss
        etc etc
    }
    AnnotatedGloss {
        BooleanField isRepresentative
        FloatField starttime
        FloatField endtime
    }
    AnnotatedSentence {
        *none* *none*
    }
    AnnotatedSentenceTranslation {
        TextField text
    }
    AnnotatedSentenceContext {
        TextField text
    }
    AnnotatedSentenceSource {
        CharField name
        TextField source
        TextField url
    }
    AnnotatedVideo {
        FileField videofile
        FileField eaffile
        URLField url
    }
    Language {
        CharField name
        CharField language_code_2char
        CharField language_code_3char
        TextField description
    }
    
    Dataset ||--o{ LemmaIdgloss : ""
    LemmaIdgloss ||--o{ Gloss : ""
    Gloss ||--o{ AnnotatedGloss : ""
    AnnotatedGloss }o--|| AnnotatedSentence : ""
    
    Language ||--o{ AnnotatedSentenceTranslation : ""
    Language ||--o{ AnnotatedSentenceContext : ""
    
    AnnotatedSentenceTranslation }o--|| AnnotatedSentence : ""
    AnnotatedSentenceContext }o--|| AnnotatedSentence : ""
    AnnotatedVideo ||--|| AnnotatedSentence : ""
    AnnotatedVideo }o--o| AnnotatedSentenceSource : ""
    Dataset ||--o{ AnnotatedSentenceSource : ""

Loading