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