Data model

"BATCH_ENTRY_TEMPLATE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "country": VARCHAR 
  "event_config": VARCHAR 
  "format_config": VARCHAR 
  "name": VARCHAR 
  "owner": VARCHAR 
  "priority": INTEGER 
}
"BATCH_ENTRY_FILE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "country": VARCHAR 
  "creator": VARCHAR 
  "original_uploaded_filename": VARCHAR 
  "template_id": UUID 
  "uri": VARCHAR 
}
"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}
  "country": VARCHAR 
  "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 
  "searchable": BOOLEAN 
  "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 
}
"TURING_REFERENTIAL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "code": VARCHAR 
  "country": VARCHAR 
  "referential_name": VARCHAR 
  "slug": VARCHAR 
}
"BATCH_ENTRY_TEMPLATE"."id" -> "BATCH_ENTRY_FILE"."template_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
Hold "Alt" / "Option" to enable pan & zoom