Data model

"parties"."LEGAL_ENTITY" {
  shape: sql_table
    link: "../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: "../internals/models/#components.payment_gateway.subcomponents.parties.models.ca_local_account_financial_instrument.CALocalAccountFinancialInstrument"

"id": UUID {constraint: primary_key}
  "description": TEXT 
  "instrument_type": VARCHAR(255) 
  "legal_entity_id": UUID 
  "reference": TEXT 
  "terminated_at": DATETIME 
}
"parties"."FINANCIAL_INSTRUMENT_PROVIDER_MAPPING" {
  shape: sql_table
    link: "../internals/models/#components.payment_gateway.subcomponents.parties.models.financial_instrument_provider_mapping.FinancialInstrumentProviderMapping"

"id": UUID {constraint: primary_key}
  "external_id": VARCHAR(255) 
  "financial_instrument_id": UUID 
  "workspace_key": VARCHAR(50) 
}
"parties"."IBAN_ACCOUNT_FINANCIAL_INSTRUMENT" {
  shape: sql_table
    link: "../internals/models/#components.payment_gateway.subcomponents.parties.models.iban_account_financial_instrument.IBANAccountFinancialInstrument"

"id": UUID {constraint: primary_key}
  "iban_account_data": VARCHAR 
}
"parties"."CA_LOCAL_ACCOUNT_FINANCIAL_INSTRUMENT" {
  shape: sql_table
    link: "../internals/models/#components.payment_gateway.subcomponents.parties.models.ca_local_account_financial_instrument.CALocalAccountFinancialInstrument"

"id": UUID {constraint: primary_key}
  "ca_local_account_data": VARCHAR 
}
"parties"."LEGAL_ENTITY"."id" -> "parties"."FINANCIAL_INSTRUMENT"."legal_entity_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"parties"."FINANCIAL_INSTRUMENT"."id" -> "parties"."FINANCIAL_INSTRUMENT_PROVIDER_MAPPING"."financial_instrument_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"parties"."FINANCIAL_INSTRUMENT"."id" -> "parties"."IBAN_ACCOUNT_FINANCIAL_INSTRUMENT"."id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"parties"."FINANCIAL_INSTRUMENT"."id" -> "parties"."CA_LOCAL_ACCOUNT_FINANCIAL_INSTRUMENT"."id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}

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