Data model

"BILLING_CUSTOMER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "global_profile_id": UUID 
  "stripe_customer_id": VARCHAR 
}
"BILLING_PAYMENT_METHOD" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "billing_customer_id": UUID 
  "display_name": VARCHAR 
  "iban": VARCHAR 
  "is_archived": BOOLEAN 
  "last_payment_attempt_at": DATETIME 
  "method_type": VARCHAR(17) 
  "stripe_payment_method_id": VARCHAR 
}
"DEBIT_MANDATE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "billing_payment_method_id": UUID 
  "signature_metadata": JSONB 
  "signed_at": DATETIME 
  "unique_reference": VARCHAR 
  "uri": VARCHAR 
}
"BILLING_CUSTOMER"."id" -> "BILLING_PAYMENT_METHOD"."billing_customer_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"BILLING_PAYMENT_METHOD"."id" -> "DEBIT_MANDATE"."billing_payment_method_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}

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