Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create entity relationship diagram of content #15

Open
patcon opened this issue Jun 1, 2022 · 1 comment
Open

Create entity relationship diagram of content #15

patcon opened this issue Jun 1, 2022 · 1 comment

Comments

@patcon
Copy link
Member

patcon commented Jun 1, 2022

We can using mermaid rendering on github:
https://mermaid-js.github.io/mermaid/#/entityRelationshipDiagram

erDiagram
    CAR ||--o{ NAMED-DRIVER : allows
    CAR {
        string registrationNumber
        string make
        string model
    }
    PERSON ||--o{ NAMED-DRIVER : is
    PERSON {
        string firstName
        string lastName
        int age
    }
Loading

Created like so:

```mermaid
erDiagram
    CAR ||--o{ NAMED-DRIVER : allows
    CAR {
        string registrationNumber
        string make
        string model
    }
    PERSON ||--o{ NAMED-DRIVER : is
    PERSON {
        string firstName
        string lastName
        int age
    }
```
@patcon
Copy link
Member Author

patcon commented Jun 1, 2022

erDiagram
CASE ||--o{ MISSING-PERSON : has
CASE ||--o{ UNIDENTIFIED-REMAINS : has
CASE {
    int reference
    string description
    string type
    string url
    stringArray images
}

MISSING-PERSON {
    string fullName
    stringArray aliases
    date dateMissing "Missing since"
    int birthYear "Year of birth"
    int ageMissing "Age at disappearance"
    string gender
    string bioGroup
    string eyeColour
    string hair
    string teeth
    int height
    int weight
    string build
    string complexion
    stringArray scars "Descriptions of scar(s)"
    stringArray piercings "Descriptions of piercing(s)"
    stringArray tattoos "Descriptions of tattoo(s)"
    stringArray marks "Description of identifying mark(s)"
    string jacket
    string socks
    string shirt
    string shoes
    string hat
    string sweater
    string pants
}

UNIDENTIFIED-REMAINS {
    date dateDiscovered
    int ageLower
    int ageUpper
    string gender
    string bioGroup
    string eyeColour
    string hair
    string teeth
    int height
    int weight
    string build
    string complexion
    stringArray scars "Descriptions of scar(s)"
    stringArray piercings "Descriptions of piercing(s)"
    stringArray tattoos "Descriptions of tattoo(s)"
    stringArray marks "Description of identifying mark(s)"
    string jacket
    string socks
    string shirt
    string shoes
    string hat
    string sweater
    string pants
}
Loading

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant