Skip to content

Instantly share code, notes, and snippets.

@gijs
Created August 2, 2022 09:57
Show Gist options
  • Save gijs/edc0d24ef2456fdab9ccee71831de2b6 to your computer and use it in GitHub Desktop.
Save gijs/edc0d24ef2456fdab9ccee71831de2b6 to your computer and use it in GitHub Desktop.
erDiagram
    ORGANISATION {
      string id
      string name
      string description
    }

    USER {
      string id
      string email
    }

    PROJECT {
      string id
      string title
      string description
      bool published
    }

    COLLECTION {
      string id
      string title
      string description
    }

    LAYER {
      string id
      string title
      string description
    }

    DATASOURCE {
      string id
      string title
      string description
    }

    ANNOTATION {
      string id
      string title
      string description
    }

    EVENT {
      string id
      string title
      string description
    }

    SCENARIO {
      string id
      string title
      string description
    }

    RASTERLAYER {
      string id
      string title
      string description
    }

    ASSET {
      string id
      string title
      string description
    }

    ORGANISATION |o--o{ USER : hasmany
    ORGANISATION |o--o{ PROJECT : hasmany
    USER |o--o{ PROJECT : hasMany
    PROJECT |o--o{ COLLECTION : hasMany
    COLLECTION |o--o{ LAYER : hasMany
    LAYER |o--o{ LAYER : hasMany
    LAYER |o--o{ DATASOURCE : hasMany
    DATASOURCE |o--o{ ANNOTATION : hasMany
    DATASOURCE |o--o{ RASTERLAYER : hasMany
    DATASOURCE |o--o{ SCENARIO : hasMany
    DATASOURCE |o--o{ EVENT : hasMany
    DATASOURCE |o--o{ ASSET : hasMany
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment