Skip to content

Instantly share code, notes, and snippets.

@petecheslock
Last active July 22, 2024 14:50
Show Gist options
  • Save petecheslock/e629158295a9b4d9dc31953e9a98efff to your computer and use it in GitHub Desktop.
Save petecheslock/e629158295a9b4d9dc31953e9a98efff to your computer and use it in GitHub Desktop.
erDiagram
  APPLICATION {
    int id
    string name
    string description
    string external_id
    datetime created_at
    datetime updated_at
  }
  
  ASSESSMENT_DEFINITION {
    int id
    string name
    string description
    datetime created_at
  }
  
  ASSESSMENT_RATING {
    int id
    int assessment_definition_id
    int entity_id
    string entity_kind
    int rating
    datetime last_updated_at
  }
  
  CHANGE_LOG {
    int id
    string user_id
    string message
    datetime timestamp
    string parent_id
  }
  
  LOGICAL_FLOW {
    int id
    int source_entity_id
    int target_entity_id
    string description
  }
  
  APPLICATION ||--o{ ASSESSMENT_RATING : has
  ASSESSMENT_DEFINITION ||--o{ ASSESSMENT_RATING : defines
  APPLICATION ||--o{ CHANGE_LOG : has
  APPLICATION ||--o{ LOGICAL_FLOW : participates
  ASSESSMENT_DEFINITION ||--o{ CHANGE_LOG : referenced_by
  LOGICAL_FLOW ||--o{ CHANGE_LOG : part_of
Loading
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment