Data model

"parties"."LEGAL_ENTITY" {
  shape: sql_table
    link: "../../parties/internals/models/#components.payment_gateway.subcomponents.parties.models.legal_entity.LegalEntity"

"id": UUID {constraint: primary_key}
  "address_city": VARCHAR(100) 
  "address_country_code": VARCHAR(2) 
  "address_postal_code": VARCHAR(20) 
  "address_street": VARCHAR(255) 
  "address_street_2": VARCHAR(255) 
  "address_subdivision_code": VARCHAR(6) 
  "entity_type": VARCHAR(255) 
  "first_name": VARCHAR(100) 
  "last_name": VARCHAR(100) 
  "legal_country_code": VARCHAR(2) 
  "legal_name": VARCHAR(255) 
  "terminated_at": DATETIME 
  "unique_key": VARCHAR(255) 
}
"parties"."FINANCIAL_INSTRUMENT" {
  shape: sql_table
    link: "../../parties/internals/models/#components.payment_gateway.subcomponents.parties.models.ca_local_account_financial_instrument.CALocalAccountFinancialInstrument"

"id": UUID {constraint: primary_key}
  "description": TEXT 
  "display_value": VARCHAR(64) 
  "instrument_type": VARCHAR(255) 
  "legal_entity_id": UUID 
  "reference": TEXT 
  "terminated_at": DATETIME 
}
"accounts"."ACCOUNT_HOLDER" {
  shape: sql_table
    link: "../../accounts/internals/models/#components.payment_gateway.subcomponents.accounts.models.account_holder.AccountHolder"

"id": UUID {constraint: primary_key}
  "description": TEXT 
  "external_id": VARCHAR(255) 
  "reference": TEXT 
  "terminated_at": DATETIME 
  "workspace_key": VARCHAR(50) 
}
"banking_documents"."SEPA_MANDATE" {
  shape: sql_table
    link: "../internals/models/#components.payment_gateway.subcomponents.banking_documents.models.sepa_mandate.SepaMandate"

"id": UUID {constraint: primary_key}
  "account_holder_id": UUID 
  "debtor_country": VARCHAR(3) 
  "debtor_iban": VARCHAR(34) 
  "debtor_name": VARCHAR(255) 
  "external_id": VARCHAR(255) 
  "issued_at": DATETIME 
  "sepa_creditor_identifier": VARCHAR(255) 
  "unique_mandate_reference": VARCHAR(255) 
  "workspace_key": VARCHAR(50) 
}
"banking_documents"."SEPA_MANDATE_STATUS_LOG" {
  shape: sql_table
    link: "../internals/models/#components.payment_gateway.subcomponents.banking_documents.models.sepa_mandate.SepaMandateStatusLog"

"id": UUID {constraint: primary_key}
  "sepa_mandate_id": UUID 
  "status": VARCHAR(255) 
}
"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) 
}
"banking_documents"."PAYMENT_MANDATE" {
  shape: sql_table
    link: "../internals/models/#components.payment_gateway.subcomponents.banking_documents.models.pad_payment_mandate.PadPaymentMandate"

"id": UUID {constraint: primary_key}
  "consent_captured_at": DATETIME 
  "creditor_legal_entity_id": UUID 
  "debtor_financial_instrument_id": UUID 
  "mandate_type": VARCHAR(255) 
  "payment_type": VARCHAR(255) 
  "unique_key": VARCHAR(255) 
}
"banking_documents"."PAD_PAYMENT_MANDATE" {
  shape: sql_table
    link: "../internals/models/#components.payment_gateway.subcomponents.banking_documents.models.pad_payment_mandate.PadPaymentMandate"

"id": UUID {constraint: primary_key}
}
"banking_documents"."PAYMENT_MANDATE_PROVIDER_MAPPING" {
  shape: sql_table
    link: "../internals/models/#components.payment_gateway.subcomponents.banking_documents.models.payment_mandate_provider_mapping.PaymentMandateProviderMapping"

"id": UUID {constraint: primary_key}
  "external_id": VARCHAR(255) 
  "payment_mandate_id": UUID 
  "workspace_key": VARCHAR(50) 
}
"banking_documents"."PAYMENT_MANDATE_STATUS_LOG" {
  shape: sql_table
    link: "../internals/models/#components.payment_gateway.subcomponents.banking_documents.models.payment_mandate_status_log.PaymentMandateStatusLog"

"id": UUID {constraint: primary_key}
  "payment_mandate_id": UUID 
  "reason": VARCHAR 
  "status": VARCHAR(255) 
}
"banking_documents"."SEPA_PAYMENT_MANDATE" {
  shape: sql_table
    link: "../internals/models/#components.payment_gateway.subcomponents.banking_documents.models.sepa_payment_mandate.SepaPaymentMandate"

"id": UUID {constraint: primary_key}
  "scheme": VARCHAR(255) 
  "umr": VARCHAR(35) 
  "valid_until": DATETIME 
}
"parties"."LEGAL_ENTITY"."id" -> "parties"."FINANCIAL_INSTRUMENT"."legal_entity_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"accounts"."ACCOUNT_HOLDER"."id" -> "banking_documents"."SEPA_MANDATE"."account_holder_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"banking_documents"."SEPA_MANDATE"."id" -> "banking_documents"."SEPA_MANDATE_STATUS_LOG"."sepa_mandate_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"banking_documents"."SEPA_MANDATE"."id" -> "transfers"."BANK_TRANSFER"."sepa_mandate_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"parties"."FINANCIAL_INSTRUMENT"."id" -> "banking_documents"."PAYMENT_MANDATE"."debtor_financial_instrument_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"parties"."LEGAL_ENTITY"."id" -> "banking_documents"."PAYMENT_MANDATE"."creditor_legal_entity_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"banking_documents"."PAYMENT_MANDATE"."id" -> "banking_documents"."PAD_PAYMENT_MANDATE"."id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"banking_documents"."PAYMENT_MANDATE"."id" -> "banking_documents"."PAYMENT_MANDATE_PROVIDER_MAPPING"."payment_mandate_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"banking_documents"."PAYMENT_MANDATE"."id" -> "banking_documents"."PAYMENT_MANDATE_STATUS_LOG"."payment_mandate_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"banking_documents"."PAYMENT_MANDATE"."id" -> "banking_documents"."SEPA_PAYMENT_MANDATE"."id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}

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