Data model
"ES_HEALTH_DEMOGRAPHICS_MODEL_ENTRY" {
shape: sql_table
"id": UUID {constraint: primary_key}
"average_age_is_known": BOOLEAN
"average_age_population_input": FLOAT
"average_age_primary": FLOAT
"child_participation": INTEGER
"child_ratio": FLOAT
"male_ratio": FLOAT
"partner_participation": INTEGER
"partner_ratio": FLOAT
"pricer_version": VARCHAR(255)
"primary_participation": INTEGER
}
"BUILDER_PRODUCT_MAPPING" {
shape: sql_table
"id": UUID {constraint: primary_key}
"builder_product_id": INTEGER
"builder_product_version_id": INTEGER
"builder_product_version_number": INTEGER
"competitor_product_ref": VARCHAR
"competitor_product_template_ref": VARCHAR
"input_metrics": JSONB
"insurance_plan_id": UUID
"is_frozen": BOOLEAN
"output_metrics": JSONB
"read_from_insurance_plan": BOOLEAN
}
"COVERAGE_RULE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"bundle_choice_ref": VARCHAR
"eligibility_items_refs": ARRAY
"expression_type": VARCHAR(255)
"guarantee_ref": VARCHAR
"insurance_coverage_id": UUID
"parameters": JSONB
}
"ELIGIBILITY_FUNCTION" {
shape: sql_table
"id": UUID {constraint: primary_key}
"check_sets": JSONB
"display_name": VARCHAR
"user_input_names": ARRAY
}
"INSURANCE_COVERAGE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"aggregated_limit_parameters": JSONB
"custom_data": JSONB
"index": INTEGER
"insurance_plan_id": UUID
"propagated_parameters": JSONB
"selected_categories": ARRAY
"service_type": VARCHAR
}
"INSURANCE_OUTPUT_METRICS" {
shape: sql_table
"id": UUID {constraint: primary_key}
"enrollment_group_expected_cost_of_claims": NUMERIC
"enrollment_group_membership_fees": NUMERIC
"enrollment_group_premium": NUMERIC
"enrollment_group_pricer_pure_premiums": NUMERIC
"enrollment_group_profit": NUMERIC
"enrollment_group_revenue": NUMERIC
"insurance_plan_id": UUID
"insurance_plan_module_id": UUID
"number_of_enrollment_groups": NUMERIC
"number_of_members_per_enrollment_group": NUMERIC
}
"INSURANCE_PLAN" {
shape: sql_table
"id": UUID {constraint: primary_key}
"account_ref": VARCHAR
"allow_above_business_max": BOOLEAN
"allow_above_pricer_max": BOOLEAN
"builder_scenario_id": UUID
"business_id": VARCHAR
"country": VARCHAR(255)
"creator_ref": VARCHAR
"custom_data": JSONB
"display_name": VARCHAR
"duplicated_from_insurance_plan_id": UUID
"eligibility_function_id": UUID
"insurer_name": VARCHAR
"is_template": BOOLEAN
"origin": VARCHAR(255)
"plan_type": VARCHAR(255)
"pricer_version": VARCHAR
"segment": VARCHAR
"tags": ARRAY
"target_type": VARCHAR(255)
"template_plan_id": UUID
"turing_product_change_id": UUID
}
"INSURANCE_PLAN_LEGACY_SOURCE_MAPPING" {
shape: sql_table
"id": UUID {constraint: primary_key}
"insurance_plan_id": UUID
"legacy_plan_source_ref": VARCHAR(255)
"plan_type": VARCHAR(255)
}
"INSURANCE_PLAN_MODULE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"coverage_id": UUID
"eligibility_function_id": UUID
"eligibility_lost_fallback_module_ids": ARRAY
"full_month_billing": BOOLEAN
"insurance_plan_id": UUID
"membership_fee_flat": INTEGER
"membership_fee_ratio": NUMERIC
"price_segment_id": UUID
"relative_pricing_module_id": UUID
"target_loss_ratio": NUMERIC
}
"INSURANCE_PLAN_TARGET" {
shape: sql_table
"id": UUID {constraint: primary_key}
"custom_data": JSONB
"display_name": VARCHAR
"insurance_plan_id": UUID
"number_of_primaries": INTEGER
"prospect_ref": VARCHAR
}
"INSURANCE_PRICE_COMPONENT" {
shape: sql_table
"id": UUID {constraint: primary_key}
"component_type": VARCHAR
"contribution_type": VARCHAR(255)
"equivalent_price_absolute": NUMERIC
"insurance_price_rule_id": UUID
"max_price_absolute": NUMERIC
"min_price_absolute": NUMERIC
"payee": VARCHAR
"payor": VARCHAR
"price_absolute": NUMERIC
"salary_rate": NUMERIC
"salary_type": VARCHAR
"tax_rate": NUMERIC
}
"INSURANCE_PRICE_RULE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"custom_data": JSONB
"insurance_plan_module_id": UUID
"price_structure_component_id": UUID
}
"INSURANCE_PRICE_SEGMENT" {
shape: sql_table
"id": UUID {constraint: primary_key}
"insurance_plan_id": UUID
"type": VARCHAR
}
"INSURANCE_PRICING_RAW_OUTPUT" {
shape: sql_table
"id": UUID {constraint: primary_key}
"computed_demographics": JSONB
"insurance_plan_module_id": UUID
"raw_output_per_coverage_rule": JSONB
"total_original_pure_premiums": JSONB
}
"MODULE_CONSTRAINT" {
shape: sql_table
"id": UUID {constraint: primary_key}
"insurance_plan_id": UUID
"is_retroactive": BOOLEAN
"name": VARCHAR
"payload": JSONB
"type": VARCHAR(255)
}
"PARTICIPATION_RULE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"insurance_plan_module_id": UUID
"max_participation_absolute": INTEGER
"participation_absolute": INTEGER
"participation_ratio": NUMERIC
"price_component_type": VARCHAR
"price_structure_component_id": UUID
}
"PAST_RESULTS_CORRECTION_FACTOR" {
shape: sql_table
"id": UUID {constraint: primary_key}
"corrected_level_ref": VARCHAR
"corrected_level_type": VARCHAR(255)
"correction_factor": NUMERIC
"insurance_plan_module_id": UUID
}
"PRICE_STRUCTURE_COMPONENT" {
shape: sql_table
"id": UUID {constraint: primary_key}
"coefficient": NUMERIC
"insurance_plan_module_id": UUID
"member_max_age_in_months": INTEGER
"member_max_rank_inclusive": INTEGER
"member_max_status_tenure_in_months": INTEGER
"member_min_age_in_months": INTEGER
"member_min_rank_inclusive": INTEGER
"member_min_status_tenure_in_months": INTEGER
"membership_types": ARRAY
}
"builder"."DRAFT_COVERAGE_RULE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"bundle_choice_ref": VARCHAR
"eligibility_items_refs": ARRAY
"expression_type": VARCHAR(255)
"guarantee_ref": VARCHAR
"insurance_coverage_id": UUID
"parameters": JSONB
}
"builder"."DRAFT_INSURANCE_COVERAGE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"aggregated_limit_parameters": JSONB
"custom_data": JSONB
"index": INTEGER
"insurance_plan_id": UUID
"propagated_parameters": JSONB
"selected_categories": ARRAY
"service_type": VARCHAR
}
"builder"."DRAFT_INSURANCE_OUTPUT_METRICS" {
shape: sql_table
"id": UUID {constraint: primary_key}
"enrollment_group_expected_cost_of_claims": NUMERIC
"enrollment_group_membership_fees": NUMERIC
"enrollment_group_premium": NUMERIC
"enrollment_group_pricer_pure_premiums": NUMERIC
"enrollment_group_profit": NUMERIC
"enrollment_group_revenue": NUMERIC
"insurance_plan_id": UUID
"insurance_plan_module_id": UUID
"number_of_enrollment_groups": NUMERIC
"number_of_members_per_enrollment_group": NUMERIC
}
"builder"."DRAFT_INSURANCE_PLAN" {
shape: sql_table
"id": UUID {constraint: primary_key}
"account_ref": VARCHAR
"allow_above_business_max": BOOLEAN
"allow_above_pricer_max": BOOLEAN
"builder_scenario_id": UUID
"business_id": VARCHAR
"country": VARCHAR(255)
"creator_ref": VARCHAR
"custom_data": JSONB
"display_name": VARCHAR
"duplicated_from_insurance_plan_id": UUID
"insurer_name": VARCHAR
"is_template": BOOLEAN
"origin": VARCHAR(255)
"plan_type": VARCHAR(255)
"pricer_version": VARCHAR
"segment": VARCHAR
"tags": ARRAY
"target_type": VARCHAR(255)
"template_plan_id": UUID
"turing_product_change_id": UUID
}
"builder"."DRAFT_INSURANCE_PLAN_MODULE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"coverage_id": UUID
"full_month_billing": BOOLEAN
"insurance_plan_id": UUID
"membership_fee_flat": INTEGER
"membership_fee_ratio": NUMERIC
"price_segment_id": UUID
"relative_pricing_module_id": UUID
"target_loss_ratio": NUMERIC
}
"builder"."DRAFT_INSURANCE_PLAN_TARGET" {
shape: sql_table
"id": UUID {constraint: primary_key}
"custom_data": JSONB
"display_name": VARCHAR
"insurance_plan_id": UUID
"number_of_primaries": INTEGER
"prospect_ref": VARCHAR
}
"builder"."DRAFT_INSURANCE_PRICE_COMPONENT" {
shape: sql_table
"id": UUID {constraint: primary_key}
"component_type": VARCHAR
"contribution_type": VARCHAR(255)
"equivalent_price_absolute": NUMERIC
"insurance_price_rule_id": UUID
"max_price_absolute": NUMERIC
"min_price_absolute": NUMERIC
"payee": VARCHAR
"payor": VARCHAR
"price_absolute": NUMERIC
"salary_rate": NUMERIC
"salary_type": VARCHAR
"tax_rate": NUMERIC
}
"builder"."DRAFT_INSURANCE_PRICE_RULE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"custom_data": JSONB
"insurance_plan_module_id": UUID
"price_structure_component_id": UUID
}
"builder"."DRAFT_INSURANCE_PRICE_SEGMENT" {
shape: sql_table
"id": UUID {constraint: primary_key}
"insurance_plan_id": UUID
"type": VARCHAR
}
"builder"."DRAFT_INSURANCE_PRICING_RAW_OUTPUT" {
shape: sql_table
"id": UUID {constraint: primary_key}
"computed_demographics": JSONB
"insurance_plan_module_id": UUID
"raw_output_per_coverage_rule": JSONB
"total_original_pure_premiums": JSONB
}
"builder"."DRAFT_PARTICIPATION_RULE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"insurance_plan_module_id": UUID
"max_participation_absolute": INTEGER
"participation_absolute": INTEGER
"participation_ratio": NUMERIC
"price_component_type": VARCHAR
"price_structure_component_id": UUID
}
"builder"."DRAFT_PAST_RESULTS_CORRECTION_FACTOR" {
shape: sql_table
"id": UUID {constraint: primary_key}
"corrected_level_ref": VARCHAR
"corrected_level_type": VARCHAR(255)
"correction_factor": NUMERIC
"insurance_plan_module_id": UUID
}
"builder"."DRAFT_PRICE_STRUCTURE_COMPONENT" {
shape: sql_table
"id": UUID {constraint: primary_key}
"coefficient": NUMERIC
"insurance_plan_module_id": UUID
"member_max_age_in_months": INTEGER
"member_max_rank_inclusive": INTEGER
"member_max_status_tenure_in_months": INTEGER
"member_min_age_in_months": INTEGER
"member_min_rank_inclusive": INTEGER
"member_min_status_tenure_in_months": INTEGER
"membership_types": ARRAY
}
"pricer"."MANUAL_DEMOGRAPHICS" {
shape: sql_table
"id": UUID {constraint: primary_key}
"average_age": FLOAT
"child_ratio": FLOAT
"country": VARCHAR(2)
"first_child_ratio": FLOAT
"first_two_children_ratio": FLOAT
"male_ratio": FLOAT
"non_paying_ratio": FLOAT
"number_of_primaries": INTEGER
"option_taker_ratio": FLOAT
"origin": VARCHAR(255)
"partner_ratio": FLOAT
"prospect_ref": VARCHAR(36)
"single_ratio": FLOAT
"target_population_ratios": JSONB
"version": INTEGER
}
"pricer"."PRICER_CATEGORY_PURE_PREMIUM_COEFFICIENT" {
shape: sql_table
"id": UUID {constraint: primary_key}
"category_id": TEXT
"category_pure_premium": INTEGER
"child_coefficient": FLOAT
"main_level": INTEGER
"main_parameter": TEXT
"partner_coefficient": FLOAT
"plan_type": TEXT
"pricer_version": TEXT
"primary_coefficient": FLOAT
}
"pricer"."PRICER_GUARANTEE_PURE_PREMIUMS" {
shape: sql_table
"id": UUID {constraint: primary_key}
"average_age": INTEGER
"child_pure_premium": FLOAT
"country_specific_input": TEXT
"extra_level": INTEGER
"extra_parameter": TEXT
"family_primary_price_ratio": DECIMAL
"guarantee_expression_type": TEXT
"guarantee_id": TEXT
"industry": TEXT
"location": TEXT
"main_level": INTEGER
"main_parameter": TEXT
"male_ratio": INTEGER
"partner_primary_price_ratio": DECIMAL
"partner_pure_premium": FLOAT
"plan_type": TEXT
"pricer_version": TEXT
"primary_pure_premium": FLOAT
"target_population": TEXT
}
"pricer"."TARGET_MARGIN_MAPPING" {
shape: sql_table
"id": UUID {constraint: primary_key}
"bucket": VARCHAR(255)
"key": VARCHAR(255)
"plan_type": TEXT
"target_margin_ratio": FLOAT
"target_profit_per_member": FLOAT
"type": VARCHAR(255)
}
"pricer"."TURING_FULL_MONTH_BILLING_MODEL" {
shape: sql_table
"id": UUID {constraint: primary_key}
"full_month_billing_ratio": FLOAT
"industry": VARCHAR(255)
"plan_type": TEXT
"pricer_version": VARCHAR(255)
}
"pricer"."TURING_GUARANTEE_COVERAGE_RATE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"extra_level": INTEGER
"extra_parameter": TEXT
"full_cost_total": FLOAT
"guarantee_expression_type": TEXT
"guarantee_id": TEXT
"industry": TEXT
"is_benchmark": BOOLEAN
"location": TEXT
"main_level": INTEGER
"main_parameter": TEXT
"n_care_events": INTEGER
"out_of_pocket_total": FLOAT
}
"INSURANCE_COVERAGE"."id" -> "COVERAGE_RULE"."insurance_coverage_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"INSURANCE_PLAN"."id" -> "INSURANCE_COVERAGE"."insurance_plan_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"INSURANCE_PLAN_MODULE"."id" -> "INSURANCE_OUTPUT_METRICS"."insurance_plan_module_id": {
source-arrowhead.shape: cf-one
target-arrowhead.shape: cf-many
}
"INSURANCE_PLAN"."id" -> "INSURANCE_OUTPUT_METRICS"."insurance_plan_id": {
source-arrowhead.shape: cf-one
target-arrowhead.shape: cf-many
}
"ELIGIBILITY_FUNCTION"."id" -> "INSURANCE_PLAN"."eligibility_function_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-one-required
}
"INSURANCE_PRICE_SEGMENT"."id" -> "INSURANCE_PLAN_MODULE"."price_segment_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"INSURANCE_PLAN"."id" -> "INSURANCE_PLAN_MODULE"."insurance_plan_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"INSURANCE_COVERAGE"."id" -> "INSURANCE_PLAN_MODULE"."coverage_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"ELIGIBILITY_FUNCTION"."id" -> "INSURANCE_PLAN_MODULE"."eligibility_function_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-one-required
}
"INSURANCE_PLAN_MODULE"."id" -> "INSURANCE_PLAN_MODULE"."relative_pricing_module_id": {
source-arrowhead.shape: cf-one
target-arrowhead.shape: cf-many
}
"INSURANCE_PLAN"."id" -> "INSURANCE_PLAN_TARGET"."insurance_plan_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"INSURANCE_PRICE_RULE"."id" -> "INSURANCE_PRICE_COMPONENT"."insurance_price_rule_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"INSURANCE_PLAN_MODULE"."id" -> "INSURANCE_PRICE_RULE"."insurance_plan_module_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"PRICE_STRUCTURE_COMPONENT"."id" -> "INSURANCE_PRICE_RULE"."price_structure_component_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"INSURANCE_PLAN"."id" -> "INSURANCE_PRICE_SEGMENT"."insurance_plan_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"INSURANCE_PLAN_MODULE"."id" -> "INSURANCE_PRICING_RAW_OUTPUT"."insurance_plan_module_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"INSURANCE_PLAN"."id" -> "MODULE_CONSTRAINT"."insurance_plan_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"PRICE_STRUCTURE_COMPONENT"."id" -> "PARTICIPATION_RULE"."price_structure_component_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"INSURANCE_PLAN_MODULE"."id" -> "PARTICIPATION_RULE"."insurance_plan_module_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"INSURANCE_PLAN_MODULE"."id" -> "PAST_RESULTS_CORRECTION_FACTOR"."insurance_plan_module_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"INSURANCE_PLAN_MODULE"."id" -> "PRICE_STRUCTURE_COMPONENT"."insurance_plan_module_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_COVERAGE"."id" -> "builder"."DRAFT_COVERAGE_RULE"."insurance_coverage_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PLAN"."id" -> "builder"."DRAFT_INSURANCE_COVERAGE"."insurance_plan_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PLAN_MODULE"."id" -> "builder"."DRAFT_INSURANCE_OUTPUT_METRICS"."insurance_plan_module_id": {
source-arrowhead.shape: cf-one
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PLAN"."id" -> "builder"."DRAFT_INSURANCE_OUTPUT_METRICS"."insurance_plan_id": {
source-arrowhead.shape: cf-one
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_COVERAGE"."id" -> "builder"."DRAFT_INSURANCE_PLAN_MODULE"."coverage_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PLAN"."id" -> "builder"."DRAFT_INSURANCE_PLAN_MODULE"."insurance_plan_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PRICE_SEGMENT"."id" -> "builder"."DRAFT_INSURANCE_PLAN_MODULE"."price_segment_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PLAN_MODULE"."id" -> "builder"."DRAFT_INSURANCE_PLAN_MODULE"."relative_pricing_module_id": {
source-arrowhead.shape: cf-one
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PLAN"."id" -> "builder"."DRAFT_INSURANCE_PLAN_TARGET"."insurance_plan_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PRICE_RULE"."id" -> "builder"."DRAFT_INSURANCE_PRICE_COMPONENT"."insurance_price_rule_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PLAN_MODULE"."id" -> "builder"."DRAFT_INSURANCE_PRICE_RULE"."insurance_plan_module_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_PRICE_STRUCTURE_COMPONENT"."id" -> "builder"."DRAFT_INSURANCE_PRICE_RULE"."price_structure_component_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PLAN"."id" -> "builder"."DRAFT_INSURANCE_PRICE_SEGMENT"."insurance_plan_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PLAN_MODULE"."id" -> "builder"."DRAFT_INSURANCE_PRICING_RAW_OUTPUT"."insurance_plan_module_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_PRICE_STRUCTURE_COMPONENT"."id" -> "builder"."DRAFT_PARTICIPATION_RULE"."price_structure_component_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PLAN_MODULE"."id" -> "builder"."DRAFT_PARTICIPATION_RULE"."insurance_plan_module_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PLAN_MODULE"."id" -> "builder"."DRAFT_PAST_RESULTS_CORRECTION_FACTOR"."insurance_plan_module_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"builder"."DRAFT_INSURANCE_PLAN_MODULE"."id" -> "builder"."DRAFT_PRICE_STRUCTURE_COMPONENT"."insurance_plan_module_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
Hold "Alt" / "Option" to enable pan & zoom