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