Data model

"GUARANTEE_CATALOG_CATEGORY" {
  shape: sql_table
  "id": VARCHAR {constraint: primary_key}
  "country": VARCHAR 
  "display_name": VARCHAR 
  "rank": INTEGER 
}
"GUARANTEE_CATALOG_BUNDLE" {
  shape: sql_table
  "id": VARCHAR {constraint: primary_key}
  "category_id": VARCHAR 
  "country": VARCHAR 
  "display_name": VARCHAR 
  "is_optional": BOOLEAN 
  "rank": INTEGER 
}
"GUARANTEE_CATALOG_BUNDLE_CHOICE_GUARANTEE" {
  shape: sql_table
  "bundle_choice_id": VARCHAR {constraint: primary_key}
  "guarantee_id": VARCHAR {constraint: primary_key}
}
"GUARANTEE_CATALOG_BUNDLE_CHOICE" {
  shape: sql_table
  "id": VARCHAR {constraint: primary_key}
  "bundle_id": VARCHAR 
  "country": VARCHAR 
  "display_name": VARCHAR 
  "is_default": BOOLEAN 
  "premiumness": INTEGER 
  "status": VARCHAR(255) 
}
"GUARANTEE_CATALOG_GUARANTEE" {
  shape: sql_table
  "id": VARCHAR {constraint: primary_key}
  "country": VARCHAR 
  "display_name": VARCHAR 
  "guarantee_metadata": JSONB 
  "rank": INTEGER 
  "tax_bracket_tag": VARCHAR 
}
"GUARANTEE_CATALOG_GUARANTEE_ELIGIBILITY_ITEM" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "business_identifier": VARCHAR 
  "country": VARCHAR 
  "display_name": VARCHAR 
  "guarantee_id": VARCHAR 
  "is_optional": BOOLEAN 
}
"GUARANTEE_CATALOG_GUARANTEE_EXPRESSION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "country": VARCHAR 
  "guarantee_id": VARCHAR 
  "is_default": BOOLEAN 
  "pricer_extra_parameter_type": VARCHAR(255) 
  "pricer_main_parameter_type": VARCHAR(255) 
  "status": VARCHAR(255) 
  "type": VARCHAR(255) 
}
"GUARANTEE_CATALOG_CATEGORY_PARAMETER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "business_max": FLOAT 
  "business_min": FLOAT 
  "category_id": VARCHAR 
  "constant_value": VARCHAR 
  "country": VARCHAR 
  "fiscal_max": FLOAT 
  "is_aggregated_limit": BOOLEAN 
  "pricer_max": INTEGER 
  "pricer_min": INTEGER 
  "pricer_step": INTEGER 
  "source": VARCHAR 
  "type": VARCHAR 
}
"GUARANTEE_CATALOG_BUNDLE_CHOICE_PARAMETER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "bundle_choice_id": VARCHAR 
  "business_max": FLOAT 
  "business_min": FLOAT 
  "constant_value": VARCHAR 
  "country": VARCHAR 
  "fiscal_max": FLOAT 
  "is_aggregated_limit": BOOLEAN 
  "pricer_max": INTEGER 
  "pricer_min": INTEGER 
  "pricer_step": INTEGER 
  "source": VARCHAR 
  "type": VARCHAR 
}
"GUARANTEE_CATALOG_GUARANTEE_EXPRESSION_PARAMETER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "business_max": FLOAT 
  "business_min": FLOAT 
  "constant_value": VARCHAR 
  "country": VARCHAR 
  "expression_id": UUID 
  "fiscal_max": FLOAT 
  "pricer_max": INTEGER 
  "pricer_min": INTEGER 
  "pricer_step": INTEGER 
  "source": VARCHAR 
  "type": VARCHAR 
}
"GUARANTEE_CATALOG_CATEGORY"."id" -> "GUARANTEE_CATALOG_BUNDLE"."category_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"GUARANTEE_CATALOG_GUARANTEE"."id" -> "GUARANTEE_CATALOG_BUNDLE_CHOICE_GUARANTEE"."guarantee_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"GUARANTEE_CATALOG_BUNDLE_CHOICE"."id" -> "GUARANTEE_CATALOG_BUNDLE_CHOICE_GUARANTEE"."bundle_choice_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"GUARANTEE_CATALOG_BUNDLE"."id" -> "GUARANTEE_CATALOG_BUNDLE_CHOICE"."bundle_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"GUARANTEE_CATALOG_GUARANTEE"."id" -> "GUARANTEE_CATALOG_GUARANTEE_ELIGIBILITY_ITEM"."guarantee_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"GUARANTEE_CATALOG_GUARANTEE"."id" -> "GUARANTEE_CATALOG_GUARANTEE_EXPRESSION"."guarantee_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"GUARANTEE_CATALOG_CATEGORY"."id" -> "GUARANTEE_CATALOG_CATEGORY_PARAMETER"."category_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"GUARANTEE_CATALOG_BUNDLE_CHOICE"."id" -> "GUARANTEE_CATALOG_BUNDLE_CHOICE_PARAMETER"."bundle_choice_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"GUARANTEE_CATALOG_GUARANTEE_EXPRESSION"."id" -> "GUARANTEE_CATALOG_GUARANTEE_EXPRESSION_PARAMETER"."expression_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
Hold "Alt" / "Option" to enable pan & zoom