# Column schema ERD

Table and field reference for the Fivetran Column connector.

## Table & Field Reference

### business_detail_beneficial_owner

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| business_detail_id | Unknown | PK, FK |
| address_city | Unknown |  |
| address_country_code | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| date_of_birth | Unknown |  |
| drivers_license | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| middle_name | Unknown |  |
| national_id | Unknown |  |
| passport | Json |  |
| ssn | Unknown |  |

### business_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| address_city | Unknown |  |
| address_country_code | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| business_name | Unknown |  |
| ein | Unknown |  |
| industry | Unknown |  |
| legal_type | Unknown |  |
| registration_id_country_code | Unknown |  |
| registration_id_number | Unknown |  |
| website | Unknown |  |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| bank_account_id | Unknown | FK |
| loan_id | Unknown | FK |
| created_at | Unknown |  |
| currency | Unknown |  |
| description | Unknown |  |
| principal_amount | Unknown |  |
| status | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| data | Json |  |
| type | Unknown |  |

### counter_party

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| local_account_number | Unknown | FK |
| account_number | Unknown |  |
| account_type | Unknown |  |
| address_city | Unknown |  |
| address_country_code | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| beneficiary_address_city | Unknown |  |
| beneficiary_address_country_code | Unknown |  |
| beneficiary_address_line_1 | Unknown |  |
| beneficiary_address_line_2 | Unknown |  |
| beneficiary_address_postal_code | Unknown |  |
| beneficiary_address_state | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| email | Unknown |  |
| is_column_account | Unknown |  |
| legal_id | Unknown |  |
| legal_type | Unknown |  |
| local_bank_code | Unknown |  |
| local_bank_country_code | Unknown |  |
| local_bank_name | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| routing_number | Unknown |  |
| routing_number_type | Unknown |  |
| updated_at | Unknown |  |
| wire_beneficiary_email | Unknown |  |
| wire_beneficiary_legal_id | Unknown |  |
| wire_beneficiary_name | Unknown |  |
| wire_beneficiary_phone | Unknown |  |
| wire_beneficiary_type | Unknown |  |
| wire_drawdown_allowed | Unknown |  |
| wire_local_account_number | Unknown |  |
| wire_local_bank_code | Unknown |  |

### disbursement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| bank_account_id | Unknown | FK |
| loan_id | Unknown | FK |
| amount | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| description | Unknown |  |
| effective_at | Unknown |  |
| status | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bank_account_id | Unknown | FK |
| account_number | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| routing_number | Unknown |  |

### loan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| primary_signer_entity_id | Unknown | FK |
| balances_principal_charged_off | Unknown |  |
| balances_principal_holding | Unknown |  |
| balances_principal_outstanding | Unknown |  |
| balances_principal_paid | Unknown |  |
| canceled_at | Unknown |  |
| charged_off_at | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| delinquent_at | Unknown |  |
| description | Unknown |  |
| disputed_at | Unknown |  |
| is_revolving | Unknown |  |
| maturity_date | Unknown |  |
| max_principal_balance | Unknown |  |
| paid_off_at | Unknown |  |
| status | Unknown |  |

### entity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| document | Json |  |
| is_root | Unknown |  |
| name | Unknown |  |
| review_reason | Json |  |
| type | Unknown |  |
| verification_status | Unknown |  |

### book_transfer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| receiver_account_id | Unknown | FK |
| receiver_bank_account_id | Unknown | FK |
| sender_account_id | Unknown | FK |
| sender_bank_account_id | Unknown | FK |
| allow_overdraft | Unknown |  |
| amount | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| description | Unknown |  |
| idempotency_key | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### transfer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| counterparty_id | Unknown | FK |
| sender_bank_account_id | Unknown | FK |
| amount | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| description | Unknown |  |
| external_source_bank_name | Unknown |  |
| external_source_sender_name | Unknown |  |
| idempotency_key | Unknown |  |
| is_incoming | Unknown |  |
| receiver_internal_account_account_number_id | Unknown |  |
| receiver_internal_account_bank_account_id | Unknown |  |
| sender_account_id | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### wire_draw_down

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| bank_account_id | Unknown | FK |
| amount | Unknown |  |
| beneficiary_account_number | Unknown |  |
| beneficiary_counterparty_id | Unknown |  |
| beneficiary_name | Unknown |  |
| currency_code | Unknown |  |
| imad | Unknown |  |
| is_incoming | Unknown |  |
| message_identifier | Unknown |  |
| originator_account_number | Unknown |  |
| originator_name | Unknown |  |
| originator_to_beneficiary_information | Unknown |  |
| received_at | Unknown |  |
| receiver_di_name | Unknown |  |
| receiver_di_routing_number | Unknown |  |
| sender_di_name | Unknown |  |
| sender_di_routing_number | Unknown |  |
| status | Unknown |  |
| wire_transfer_id | Unknown |  |

### ach_return_detail

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ach_return_id | Unknown | FK |
| addenda | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| return_code | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### ach_return

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ach_transfer_id | Unknown | FK |
| created_at | Unknown |  |
| is_incoming | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### international_wire_charge

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| international_wire_id | Unknown | FK |
| agent | Unknown |  |
| amount | Unknown |  |
| currency_code | Unknown |  |

### international_wire

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_number_id | Unknown | FK |
| bank_account_id | Unknown | FK |
| account_id | Unknown |  |
| allow_overdraft | Unknown |  |
| amount | Unknown |  |
| beneficiary_account_number | Unknown |  |
| beneficiary_address_city | Unknown |  |
| beneficiary_address_country_code | Unknown |  |
| beneficiary_address_line_1 | Unknown |  |
| beneficiary_address_line_2 | Unknown |  |
| beneficiary_address_postal_code | Unknown |  |
| beneficiary_address_state | Unknown |  |
| beneficiary_fi | Unknown |  |
| beneficiary_name | Unknown |  |
| charge_bearer | Unknown |  |
| charges | Json |  |
| completed_at | Unknown |  |
| counterparty_id | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| description | Unknown |  |
| end_to_end_id | Unknown |  |
| fx_quota_id | Unknown |  |
| fx_rate | Unknown |  |
| idempotency_key | Unknown |  |
| initiated_at | Unknown |  |
| instructed_amount | Unknown |  |
| instructed_currency_code | Unknown |  |
| instruction_id | Unknown |  |
| instruction_to_beneficiary_fi | Unknown |  |
| is_incoming | Unknown |  |
| manual_review_at | Unknown |  |
| originator_account_number | Unknown |  |
| originator_address_city | Unknown |  |
| originator_address_country_code | Unknown |  |
| originator_address_line_1 | Unknown |  |
| originator_address_line_2 | Unknown |  |
| originator_address_postal_code | Unknown |  |
| originator_address_state | Unknown |  |
| originator_fi | Unknown |  |
| originator_name | Unknown |  |
| pending_submission_at | Unknown |  |
| raw_message | Unknown |  |
| remittance_info_general_info | Unknown |  |
| return_reason | Unknown |  |
| returned_amount | Unknown |  |
| returned_at | Unknown |  |
| returned_currency_code | Unknown |  |
| settled_amount | Unknown |  |
| settled_currency_code | Unknown |  |
| settlement_date | Unknown |  |
| status | Unknown |  |
| submitted_at | Unknown |  |
| uetr | Unknown |  |
| ultimate_beneficiary_address | Unknown |  |
| ultimate_beneficiary_name | Unknown |  |
| ultimate_originator_address | Unknown |  |
| ultimate_originator_name | Unknown |  |
| updated_at | Unknown |  |

### ach_transfer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| bank_account_id | Unknown | FK |
| counterparty_id | Unknown | FK |
| acknowledged_at | Unknown |  |
| allow_overdraft | Unknown |  |
| amount | Unknown |  |
| cancelled_at | Unknown |  |
| company_discretionary_data | Unknown |  |
| company_entry_description | Unknown |  |
| company_id | Unknown |  |
| company_name | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| description | Unknown |  |
| effective_on | Unknown |  |
| entry_class_code | Unknown |  |
| iat_foreign_correspondent_bank_info | Json |  |
| iat_foreign_payment_amount | Unknown |  |
| iat_foreign_trace_number | Unknown |  |
| iat_odfi_branch_country_code | Unknown |  |
| iat_odfi_identification | Unknown |  |
| iat_odfi_identification_number_qualifier | Unknown |  |
| iat_odfi_name | Unknown |  |
| iat_originator_city_state_province | Unknown |  |
| iat_originator_country_postal_code | Unknown |  |
| iat_originator_name | Unknown |  |
| iat_originator_street_address | Unknown |  |
| iat_payment_related_info | Unknown |  |
| iat_rdfi_branch_country_code | Unknown |  |
| iat_rdfi_identification | Unknown |  |
| iat_rdfi_identification_number_qualifier | Unknown |  |
| iat_rdfi_name | Unknown |  |
| iat_receiver_city_state_province | Unknown |  |
| iat_receiver_country_postal_code | Unknown |  |
| iat_receiver_identification_number | Unknown |  |
| iat_receiver_street_address | Unknown |  |
| iat_receiving_company_or_individual_name | Unknown |  |
| iat_transaction_type_code | Unknown |  |
| idempotency_key | Unknown |  |
| initiated_at | Unknown |  |
| intermediary_financial_institutions | Unknown |  |
| is_incoming | Unknown |  |
| is_on_us | Unknown |  |
| manual_review_at | Unknown |  |
| notification_of_changes | Unknown |  |
| nsf_deadline | Unknown |  |
| odfi_routing_number | Unknown |  |
| payment_related_info | Unknown |  |
| receiver_id | Unknown |  |
| receiver_name | Unknown |  |
| return_contested_at | Unknown |  |
| return_detail | Json |  |
| return_dishonored_at | Unknown |  |
| returned_at | Unknown |  |
| reversal_pair_transfer_id | Unknown |  |
| same_day | Unknown |  |
| settled_at | Unknown |  |
| status | Unknown |  |
| submitted_at | Unknown |  |
| trace_number | Unknown |  |
| type | Unknown |  |
| ultimate_beneficiary_counterparty_id | Unknown |  |
| ultimate_originator_counterparty_id | Unknown |  |
| updated_at | Unknown |  |

### check_return

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| check_transfer_id | Unknown | FK |
| created_at | Unknown |  |
| return_reason | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### check_transfer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_number_id | Unknown | FK |
| bank_account_id | Unknown | FK |
| account_id | Unknown |  |
| back_image | Unknown |  |
| check_number | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| delivered_by_column | Unknown |  |
| delivery_status | Unknown |  |
| deposited_amount | Unknown |  |
| deposited_at | Unknown |  |
| description | Unknown |  |
| external_routing_number | Unknown |  |
| first_return_at | Unknown |  |
| front_image | Unknown |  |
| idempotency_key | Unknown |  |
| is_preview_pdf_available | Unknown |  |
| issued_at | Unknown |  |
| manual_review_at | Unknown |  |
| memo | Unknown |  |
| message | Unknown |  |
| micr_line_amount_field | Unknown |  |
| micr_line_auxiliary_on_us | Unknown |  |
| micr_line_external_processing_code | Unknown |  |
| micr_line_on_us | Unknown |  |
| micr_line_payor_bank_routing_number | Unknown |  |
| payee_address | Unknown |  |
| payee_name | Unknown |  |
| pending_deposit_at | Unknown |  |
| pending_first_return_at | Unknown |  |
| pending_stop_at | Unknown |  |
| pending_user_initiated_return_at | Unknown |  |
| positive_pay_amount | Unknown |  |
| reclear_at | Unknown |  |
| rejected_at | Unknown |  |
| second_return_at | Unknown |  |
| settled_at | Unknown |  |
| status | Unknown |  |
| stopped_at | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| user_initiated_return_dishonored_at | Unknown |  |
| user_initiated_return_submitted_at | Unknown |  |
| user_initiated_returned_at | Unknown |  |

### person_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| address_city | Unknown |  |
| address_country_code | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| date_of_birth | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| middle_name | Unknown |  |
| passport | Json |  |
| ssn | Unknown |  |

### bank_account_owner

| Column | Type | Keys |
| --- | --- | --- |
| bank_account_id | Unknown | PK, FK |
| owner_id | Unknown | PK, FK |

### bank_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_account_id | Unknown | FK |
| balances_available_amount | Unknown |  |
| balances_holding_amount | Unknown |  |
| balances_locked_amount | Unknown |  |
| balances_pending_amount | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| default_account_number | Unknown |  |
| description | Unknown |  |
| is_overdraftable | Unknown |  |
| overdraft_reserve_account_id | Unknown |  |
| type | Unknown |  |

### wire_transfer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| bank_account_id | Unknown | FK |
| counterparty_id | Unknown | FK |
| allow_overdraft | Unknown |  |
| amount | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| description | Unknown |  |
| idempotency_key | Unknown |  |
| initiated_at | Unknown |  |
| is_incoming | Unknown |  |
| is_on_us | Unknown |  |
| pending_submission_at | Unknown |  |
| platform_id | Unknown |  |
| rejected_at | Unknown |  |
| status | Unknown |  |
| submitted_at | Unknown |  |
| updated_at | Unknown |  |
| wire_drawdown_request_id | Unknown |  |

## Relationships

- business_detail_beneficial_owner(business_detail_id) → business_detail(id)
- business_detail(id) → entity(id)
- payment(loan_id) → loan(id)
- payment(bank_account_id) → bank_account(id)
- payment(account_id) → account(id)
- counter_party(local_account_number) → account(id)
- disbursement(loan_id) → loan(id)
- disbursement(bank_account_id) → bank_account(id)
- disbursement(account_id) → account(id)
- account(bank_account_id) → bank_account(id)
- loan(primary_signer_entity_id) → entity(id)
- book_transfer(sender_bank_account_id) → bank_account(id)
- book_transfer(receiver_bank_account_id) → bank_account(id)
- book_transfer(receiver_account_id) → account(id)
- book_transfer(sender_account_id) → account(id)
- transfer(sender_bank_account_id) → bank_account(id)
- transfer(counterparty_id) → counter_party(id)
- transfer(account_id) → account(id)
- wire_draw_down(bank_account_id) → bank_account(id)
- wire_draw_down(account_id) → account(id)
- ach_return_detail(ach_return_id) → ach_return(id)
- ach_return(ach_transfer_id) → ach_transfer(id)
- international_wire_charge(international_wire_id) → international_wire(id)
- international_wire(bank_account_id) → bank_account(id)
- international_wire(account_number_id) → account(id)
- ach_transfer(bank_account_id) → bank_account(id)
- ach_transfer(counterparty_id) → counter_party(id)
- ach_transfer(account_id) → account(id)
- check_return(check_transfer_id) → check_transfer(id)
- check_transfer(bank_account_id) → bank_account(id)
- check_transfer(account_number_id) → account(id)
- person_detail(id) → entity(id)
- bank_account_owner(owner_id) → entity(id)
- bank_account_owner(bank_account_id) → bank_account(id)
- bank_account(default_account_id) → account(id)
- wire_transfer(bank_account_id) → bank_account(id)
- wire_transfer(counterparty_id) → counter_party(id)
- wire_transfer(account_id) → account(id)