Data model

"FR_COLLECTIVE_AGREEMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "ccn_code": VARCHAR 
  "employer_unions": ARRAY 
  "is_extended": BOOLEAN 
  "staff_categories": ARRAY 
  "sub_activities": ARRAY 
  "territories": ARRAY 
}
"CONSTRAINT_SCOPE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "contract_type": ARRAY 
  "min_seniority_month": INTEGER 
  "region": ARRAY 
  "salary_band": ARRAY 
  "staff_category": ARRAY 
}
"GUARANTEE_CONSTRAINT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "constraint_scope_id": UUID 
  "country": VARCHAR(2) 
  "eligibility_items_refs": ARRAY 
  "expression_type": VARCHAR(255) 
  "guarantee_refs": ARRAY 
  "location_in_reference_document": VARCHAR 
  "name": VARCHAR 
  "product_type": VARCHAR 
  "reference_document": VARCHAR 
  "reference_text": VARCHAR 
  "source_ref": VARCHAR 
  "source_type": VARCHAR 
}
"GUARANTEE_CONSTRAINT_PARAMETER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "constraint_type": VARCHAR(255) 
  "guarantee_constraint_id": UUID 
  "parameter_type": VARCHAR(255) 
  "value": VARCHAR 
}
"MISC_PRODUCT_CONSTRAINT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "constraint_description": VARCHAR 
  "constraint_scope_id": UUID 
  "constraint_type": VARCHAR 
  "country": VARCHAR(2) 
  "location_in_reference_document": VARCHAR 
  "name": VARCHAR 
  "product_type": VARCHAR 
  "reference_document": VARCHAR 
  "reference_text": VARCHAR 
  "source_ref": VARCHAR 
  "source_type": VARCHAR 
}
"PARTICIPATION_CONSTRAINT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "constraint_scope_id": UUID 
  "country": VARCHAR(2) 
  "enrollment_type": VARCHAR(255) 
  "location_in_reference_document": VARCHAR 
  "min_participation": FLOAT 
  "name": VARCHAR 
  "product_type": VARCHAR 
  "reference_document": VARCHAR 
  "reference_text": VARCHAR 
  "source_ref": VARCHAR 
  "source_type": VARCHAR 
}
"CONSTRAINT_SCOPE"."id" -> "GUARANTEE_CONSTRAINT"."constraint_scope_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"GUARANTEE_CONSTRAINT"."id" -> "GUARANTEE_CONSTRAINT_PARAMETER"."guarantee_constraint_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CONSTRAINT_SCOPE"."id" -> "MISC_PRODUCT_CONSTRAINT"."constraint_scope_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CONSTRAINT_SCOPE"."id" -> "PARTICIPATION_CONSTRAINT"."constraint_scope_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}

Hold "Alt" / "Option" to enable pan & zoom