Data model

"subscription"."HEALTHY_BENEFITS_SIGNED_BUNDLE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "documents_metadata": JSONB 
  "requester_first_name": TEXT 
  "requester_last_name": TEXT 
  "requester_ref": VARCHAR 
  "signature_id": VARCHAR(255) 
  "signature_request_all_signed_at": DATETIME 
  "signature_request_all_signed_event": JSONB 
  "signature_request_id": VARCHAR(255) 
  "signature_step": VARCHAR(255) 
  "signer": JSONB 
  "subscription_id": UUID 
  "uri": VARCHAR(2083) 
}
"subscription"."HEALTHY_BENEFITS_SIGNED_DOCUMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "document_key": VARCHAR(255) 
  "document_metadata": JSONB 
  "signed_at": DATETIME 
  "signed_bundle_id": UUID 
  "type": VARCHAR(255) 
  "uploader_id": UUID 
  "uri": VARCHAR(2083) 
}
"subscription"."PAYLOAD" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "price": INTEGER 
  "transfer_history_ref": VARCHAR 
}
"affiliation"."ENROLLMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "benefit_type": VARCHAR 
  "end_date": DATE 
  "is_cancelled": BOOLEAN 
  "profile_ref": VARCHAR 
  "start_date": DATE 
  "subscription_ref": VARCHAR 
  "transfer_history_ref": VARCHAR 
}
"affiliation"."TEMPORARY_LEAVE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "end_date": DATE 
  "enrollment_id": UUID 
  "is_cancelled": BOOLEAN 
  "start_date": DATE 
}
"subscription"."POPULATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "entity_ref": VARCHAR 
  "name": VARCHAR 
}
"subscription"."BENEFIT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "allowance": INTEGER 
  "payload_id": UUID 
  "population_id": UUID 
  "type_ref": VARCHAR 
}
"pricing"."DISCOUNT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "end_month": DATE 
  "price": INTEGER 
  "reason": VARCHAR 
  "start_month": DATE 
  "subscription_id": UUID 
}
"subscription"."HEALTHY_BENEFITS_SIGNED_BUNDLE"."id" -> "subscription"."HEALTHY_BENEFITS_SIGNED_DOCUMENT"."signed_bundle_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"subscription"."POPULATION"."id" -> "subscription"."BENEFIT"."population_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"subscription"."PAYLOAD"."id" -> "subscription"."BENEFIT"."payload_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}

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