Data model

"accounts"."ACCOUNT" {
  shape: sql_table
    link: "../../accounts/internals/models/#components.payment_gateway.subcomponents.accounts.models.account.Account"

"id": UUID {constraint: primary_key}
  "account_holder_id": UUID 
  "description": TEXT 
  "external_id": VARCHAR(255) 
  "reference": TEXT 
  "terminated_at": DATETIME 
  "workspace_key": VARCHAR(50) 
}
"transfers"."BANK_TRANSFER" {
  shape: sql_table
    link: "../../transfers/internals/models/#components.payment_gateway.subcomponents.transfers.models.bank_transfer.BankTransfer"

"id": UUID {constraint: primary_key}
  "account_id": UUID 
  "direction": VARCHAR(255) 
  "effective_date": DATETIME 
  "external_id": VARCHAR(255) 
  "raw": JSONB 
  "sepa_beneficiary_id": UUID 
  "sepa_mandate_id": UUID 
  "transfer_history_id": UUID 
  "workspace_key": VARCHAR(50) 
}
"payments"."PAYMENT_REQUEST" {
  shape: sql_table
    link: "../internals/models/#components.payment_gateway.subcomponents.payments.models.payment_request.PaymentRequest"

"id": UUID {constraint: primary_key}
  "account_id": UUID 
  "bank_transfer_id": UUID 
  "external_id": VARCHAR(255) 
  "raw": JSONB 
  "workspace_key": VARCHAR(50) 
}
"accounts"."ACCOUNT"."id" -> "transfers"."BANK_TRANSFER"."account_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"transfers"."BANK_TRANSFER"."id" -> "payments"."PAYMENT_REQUEST"."bank_transfer_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"accounts"."ACCOUNT"."id" -> "payments"."PAYMENT_REQUEST"."account_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}

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