Data model

"CLAIMS_GUARANTEE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "country": VARCHAR(255) 
  "name": VARCHAR 
  "short_code": VARCHAR 
}
"INTERNAL_CARE_TYPE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "country": VARCHAR(255) 
  "is_secondary": BOOLEAN 
  "name": VARCHAR 
  "short_code": VARCHAR 
}
"INTERNAL_CARE_TYPE_GROUP" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "country": VARCHAR(255) 
  "short_code": VARCHAR 
}
"INTERNAL_CARE_TYPE_TO_CLAIMS_GUARANTEE_MAPPING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "claims_guarantee_short_code": VARCHAR 
  "country": VARCHAR(255) 
  "end_date": DATE 
  "internal_care_type_short_code": VARCHAR 
  "start_date": DATE 
}
"INTERNAL_CARE_TYPE_TO_CLAIMS_GUARANTEE_MAPPING_FILTER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "filter_type": VARCHAR(255) 
  "internal_care_type_to_claims_guarantee_mapping_id": UUID 
  "value": ARRAY 
}
"INTERNAL_CARE_TYPE_TO_INTERNAL_CARE_TYPE_GROUP" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "country": VARCHAR(255) 
  "end_date": DATE 
  "internal_care_type_group_short_code": VARCHAR 
  "internal_care_type_short_code": VARCHAR 
  "start_date": DATE 
}
"CLAIMS_GUARANTEE"."short_code" -> "INTERNAL_CARE_TYPE_TO_CLAIMS_GUARANTEE_MAPPING"."claims_guarantee_short_code": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INTERNAL_CARE_TYPE"."short_code" -> "INTERNAL_CARE_TYPE_TO_CLAIMS_GUARANTEE_MAPPING"."internal_care_type_short_code": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INTERNAL_CARE_TYPE"."country" -> "INTERNAL_CARE_TYPE_TO_CLAIMS_GUARANTEE_MAPPING"."country": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CLAIMS_GUARANTEE"."country" -> "INTERNAL_CARE_TYPE_TO_CLAIMS_GUARANTEE_MAPPING"."country": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INTERNAL_CARE_TYPE_TO_CLAIMS_GUARANTEE_MAPPING"."id" -> "INTERNAL_CARE_TYPE_TO_CLAIMS_GUARANTEE_MAPPING_FILTER"."internal_care_type_to_claims_guarantee_mapping_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INTERNAL_CARE_TYPE_GROUP"."country" -> "INTERNAL_CARE_TYPE_TO_INTERNAL_CARE_TYPE_GROUP"."country": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INTERNAL_CARE_TYPE"."country" -> "INTERNAL_CARE_TYPE_TO_INTERNAL_CARE_TYPE_GROUP"."country": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INTERNAL_CARE_TYPE"."short_code" -> "INTERNAL_CARE_TYPE_TO_INTERNAL_CARE_TYPE_GROUP"."internal_care_type_short_code": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INTERNAL_CARE_TYPE_GROUP"."short_code" -> "INTERNAL_CARE_TYPE_TO_INTERNAL_CARE_TYPE_GROUP"."internal_care_type_group_short_code": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
Hold "Alt" / "Option" to enable pan & zoom