Data model

"reimbursement_blocker"."REIMBURSEMENT_BLOCKER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "block_from": DATE 
  "block_to": DATE 
  "country": VARCHAR(255) 
  "ended_at": DATETIME 
  "entity_identifier": VARCHAR 
  "entity_identifier_type": VARCHAR(255) 
  "reason": VARCHAR(255) 
  "started_at": DATETIME 
}
"risk_scoring"."RISK_SCORING_CASE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "alerts": JSONB 
  "case_type": VARCHAR(255) 
  "content_hash": VARCHAR(64) 
  "decision_next_refresh_at": DATE 
  "end_date": DATE 
  "entity_identifier": VARCHAR 
  "entity_identifier_type": VARCHAR(255) 
  "is_cancelled": BOOLEAN 
  "market": VARCHAR(255) 
  "provider": VARCHAR(255) 
  "provider_reference_id": VARCHAR 
  "resolved_at": DATETIME 
  "risk_score": INTEGER 
  "start_date": DATE 
  "status": VARCHAR(255) 
}
"risk_scoring"."RISK_SCORING_CASE_HISTORY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "action": VARCHAR(255) 
  "alerts": JSONB 
  "decision_next_refresh_at": DATE 
  "resolved_at": DATETIME 
  "risk_score": INTEGER 
  "risk_scoring_case_id": UUID 
  "status": VARCHAR(255) 
}
"risk_scoring"."RISK_SCORING_PROVIDER_REQUEST" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "direction": VARCHAR(255) 
  "json_request_body": JSONB 
  "json_response_body": JSONB 
  "method": VARCHAR(255) 
  "risk_scoring_case_history_id": UUID 
  "status_code": INTEGER 
  "url": VARCHAR 
}
"risk_scoring"."RISK_SCORING_CASE"."id" -> "risk_scoring"."RISK_SCORING_CASE_HISTORY"."risk_scoring_case_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"risk_scoring"."RISK_SCORING_CASE_HISTORY"."id" -> "risk_scoring"."RISK_SCORING_PROVIDER_REQUEST"."risk_scoring_case_history_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
Hold "Alt" / "Option" to enable pan & zoom