Data model

"MANUAL_ENTRY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "country": VARCHAR 
  "entity_id": UUID 
  "entity_type": VARCHAR 
  "known_at": DATETIME 
  "new_property_value": VARCHAR 
  "previous_property_value": VARCHAR 
  "property_definition_id": UUID 
}
"TURING_EXTERNAL_ID_ROUTING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "entity_type": VARCHAR 
  "most_complete_id": VARCHAR 
  "partial_id": VARCHAR 
}
"TURING_ORGANIZATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "country": VARCHAR 
}
"TURING_PRACTITIONER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "country": VARCHAR 
}
"TURING_PRACTITIONER_ROLE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "organization_id": UUID 
  "practitioner_id": UUID 
}
"TURING_PROPERTY_DEFINITION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "country": VARCHAR 
  "description": VARCHAR 
  "entity_type": VARCHAR 
  "is_required": BOOLEAN 
  "name": VARCHAR 
  "owner": VARCHAR 
  "schema": JSON 
  "scope": VARCHAR 
  "value_type": VARCHAR 
}
"TURING_PROPERTY_STATE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "country": VARCHAR 
  "definition_id": UUID 
  "definition_name": VARCHAR 
  "definition_value_type": VARCHAR 
  "entity_id": UUID 
  "entity_type": VARCHAR 
  "imported_at": DATETIME 
  "property_value": JSONB 
  "source_names": ARRAY 
  "valid_from": DATETIME 
  "valid_to": DATETIME 
}

Hold "Alt" / "Option" to enable pan & zoom