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