# Mollie schema ERD

Table and field reference for the Fivetran Mollie connector.

## Table & Field Reference

### balance_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| balance_id | String | PK, FK |
| payment_id | String | FK |
| created_at | Instant |  |
| deduction_commission_currency | String |  |
| deduction_commission_value | String |  |
| deduction_fee_currency | String |  |
| deduction_fee_value | String |  |
| deduction_repayment_currency | String |  |
| deduction_repayment_value | String |  |
| deduction_reservation_currency | String |  |
| deduction_reservation_value | String |  |
| deductions_currency | String |  |
| deductions_value | String |  |
| initial_amount_currency | String |  |
| initial_amount_value | String |  |
| result_amount_currency | String |  |
| result_amount_value | String |  |
| type | String |  |

### mandate

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_id | String | PK, FK |
| created_at | Instant |  |
| mandate_reference | String |  |
| method | String |  |
| signature_date | LocalDate |  |
| status | String |  |
| custom_** |  |  |

### profile_activity_country

| Column | Type | Keys |
| --- | --- | --- |
| country | Unknown | PK |
| profile_id | String | PK, FK |

### profile

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| business_category | String |  |
| category_code | Long |  |
| created_at | Instant |  |
| description | String |  |
| email | String |  |
| name | String |  |
| phone | String |  |
| review_status | String |  |
| status | String |  |
| website | String |  |

### terminal

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| profile_id | String | FK |
| brand | String |  |
| created_at | Instant |  |
| currency | String |  |
| description | String |  |
| model | String |  |
| serial_number | String |  |
| status | String |  |
| updated_at | Instant |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_id | String | FK |
| mandate_id | String | FK |
| amount_currency | String |  |
| amount_value | String |  |
| application_fee | Json |  |
| canceled_at | Instant |  |
| created_at | Instant |  |
| description | String |  |
| interval | String |  |
| metadata | Json |  |
| method | String |  |
| next_payment_date | LocalDate |  |
| start_date | LocalDate |  |
| status | String |  |
| times | Unknown |  |
| times_remaining | Unknown |  |
| webhook_url | String |  |

### payment_link

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_id | String | FK |
| profile_id | String | FK |
| allowed_method | Json |  |
| amount_currency | String |  |
| amount_value | String |  |
| application_fee | Json |  |
| archived | Boolean |  |
| created_at | Instant |  |
| description | String |  |
| expires_at | Instant |  |
| minimum_amount_currency | String |  |
| minimum_amount_value | String |  |
| paid_at | Instant |  |
| redirect_url | String |  |
| reusable | Boolean |  |
| sequence_type | String |  |
| webhook_url | String |  |

### settlement_period_cost

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| settlement_period_index | Unknown | PK, FK |
| settlement_period_settlement_id | String | PK, FK |
| amount_gross_currency | Unknown |  |
| amount_gross_value | Unknown |  |
| amount_net_currency | Unknown |  |
| amount_net_value | Unknown |  |
| amount_vat_currency | Unknown |  |
| amount_vat_value | Unknown |  |
| count | Unknown |  |
| description | Unknown |  |
| method | Unknown |  |
| rate_fixed_currency | Unknown |  |
| rate_fixed_value | Unknown |  |
| rate_percentage | Unknown |  |

### settlement_period_revenue

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| settlement_period_index | Unknown | PK, FK |
| settlement_period_settlement_id | String | PK, FK |
| amount_gross_currency | Unknown |  |
| amount_gross_value | Unknown |  |
| amount_net_currency | Unknown |  |
| amount_net_value | Unknown |  |
| amount_vat_currency | Unknown |  |
| amount_vat_value | Unknown |  |
| count | Unknown |  |
| description | Unknown |  |
| method | Unknown |  |

### settlement_period

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| settlement_id | String | PK, FK |
| invoice_id | Unknown | FK |
| invoice_is_downloadable | Unknown |  |
| month | Unknown |  |
| year | Unknown |  |

### settlement

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| balance_id | String | FK |
| invoice_id | String | FK |
| amount_currency | String |  |
| amount_value | String |  |
| created_at | Instant |  |
| reference | String |  |
| settled_at | Instant |  |
| status | String |  |

### balance

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| available_amount_currency | String |  |
| available_amount_value | String |  |
| created_at | Instant |  |
| currency | String |  |
| description | String |  |
| pending_amount_currency | String |  |
| pending_amount_value | String |  |
| status | String |  |
| transfer_destination_bank_account | String |  |
| transfer_destination_beneficiary_name | String |  |
| transfer_destination_type | String |  |
| transfer_frequency | String |  |
| transfer_reference | String |  |
| transfer_threshold_currency | String |  |
| transfer_threshold_value | String |  |

### chargeback

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payment_id | String | FK |
| settlement_id | String | FK |
| amount_currency | String |  |
| amount_value | String |  |
| created_at | Instant |  |
| reason_code | String |  |
| reason_description | String |  |
| reversed_at | Instant |  |
| settlement_amount_currency | String |  |
| settlement_amount_value | String |  |

### payment_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| payment_id | String | PK, FK |
| categories | Json |  |
| description | Unknown |  |
| discount_amount_currency | String |  |
| discount_amount_value | String |  |
| image_url | String |  |
| product_url | String |  |
| quantity | Unknown |  |
| quantity_unit | String |  |
| recurring_amount_currency | String |  |
| recurring_amount_value | String |  |
| recurring_description | String |  |
| recurring_interval | String |  |
| recurring_start_date | String |  |
| recurring_times | String |  |
| sku | String |  |
| total_amount_currency | String |  |
| total_amount_value | String |  |
| type | Unknown |  |
| unit_price_currency | String |  |
| unit_price_value | String |  |
| vat_amount_currency | String |  |
| vat_amount_value | String |  |
| vat_rate | String |  |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_id | String | FK |
| mandate_id | String | FK |
| profile_id | String | FK |
| settlement_id | String | FK |
| subscription_id | String | FK |
| amount_captured_currency | String |  |
| amount_captured_value | String |  |
| amount_charged_back_currency | String |  |
| amount_charged_back_value | String |  |
| amount_currency | String |  |
| amount_refunded_currency | String |  |
| amount_refunded_value | String |  |
| amount_remaining_currency | String |  |
| amount_remaining_value | String |  |
| amount_value | String |  |
| application_fee | Json |  |
| authorized_at | Instant |  |
| billing_address_city | String |  |
| billing_address_country | String |  |
| billing_address_email | String |  |
| billing_address_family_name | String |  |
| billing_address_given_name | String |  |
| billing_address_organization_name | String |  |
| billing_address_phone | String |  |
| billing_address_postal_code | String |  |
| billing_address_region | String |  |
| billing_address_street_additional | String |  |
| billing_address_street_and_number | String |  |
| billing_address_title | String |  |
| cancel_url | String |  |
| canceled_at | Instant |  |
| capture_before | String |  |
| capture_delay | String |  |
| capture_mode | String |  |
| country_code | String |  |
| created_at | Instant |  |
| description | String |  |
| expired_at | Instant |  |
| expires_at | Instant |  |
| failed_at | Instant |  |
| is_cancelable | Boolean |  |
| locale | String |  |
| metadata | Json |  |
| method | String |  |
| order_id | String |  |
| paid_at | Instant |  |
| redirect_url | String |  |
| restrict_payment_methods_to_country | String |  |
| sequence_type | String |  |
| shipping_address_city | String |  |
| shipping_address_country | String |  |
| shipping_address_email | String |  |
| shipping_address_family_name | String |  |
| shipping_address_given_name | String |  |
| shipping_address_organization_name | String |  |
| shipping_address_phone | String |  |
| shipping_address_postal_code | String |  |
| shipping_address_region | String |  |
| shipping_address_street_additional | String |  |
| shipping_address_street_and_number | String |  |
| shipping_address_title | String |  |
| status | String |  |
| status_reason | String |  |
| webhook_url | String |  |
| custom_** |  |  |

### invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | String | PK, FK |
| amount_currency | String |  |
| amount_value | String |  |
| count | Long |  |
| description | String |  |
| period | String |  |
| vat_percentage | Long |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| due_at | LocalDate |  |
| gross_amount_currency | String |  |
| gross_amount_value | String |  |
| issued_at | LocalDate |  |
| net_amount_currency | String |  |
| net_amount_value | String |  |
| paid_at | LocalDate |  |
| reference | String |  |
| status | String |  |
| vat_amount_currency | String |  |
| vat_amount_value | String |  |
| vat_number | String |  |

### payment_method_issuer

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payment_method_id | String | PK, FK |
| profile_id | String | PK, FK |
| image | Json |  |
| name | String |  |

### payment_method_pricing

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| payment_method_id | String | PK, FK |
| profile_id | String | PK, FK |
| description | String |  |
| fee_region | String |  |
| fixed_currency | String |  |
| fixed_value | String |  |
| variable | String |  |

### payment_method

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| profile_id | String | PK, FK |
| description | String |  |
| image | Json |  |
| maximum_amount_currency | String |  |
| maximum_amount_value | String |  |
| minimum_amount_currency | String |  |
| minimum_amount_value | String |  |
| status | String |  |

### refund_routing_reversal

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| refund_id | String | PK, FK |
| amount_currency | Unknown |  |
| amount_value | Unknown |  |
| organization_id | Unknown |  |

### refund

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payment_id | String | FK |
| settlement_id | String | FK |
| amount_currency | String |  |
| amount_value | String |  |
| created_at | Instant |  |
| description | String |  |
| external_reference_id | String |  |
| external_reference_type | String |  |
| metadata | Json |  |
| settlement_amount_currency | String |  |
| settlement_amount_value | String |  |
| status | String |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| email | String |  |
| locale | String |  |
| metadata | Json |  |
| name | String |  |

## Relationships

- balance_transaction(payment_id) → payment(id)
- balance_transaction(balance_id) → balance(id)
- mandate(customer_id) → customer(id)
- profile_activity_country(profile_id) → profile(id)
- terminal(profile_id) → profile(id)
- subscription(mandate_id) → mandate(id)
- subscription(customer_id) → customer(id)
- payment_link(profile_id) → profile(id)
- payment_link(customer_id) → customer(id)
- settlement_period_cost(settlement_period_index) → settlement_period(index)
- settlement_period_cost(settlement_period_settlement_id) → settlement_period(settlement_id)
- settlement_period_revenue(settlement_period_index) → settlement_period(index)
- settlement_period_revenue(settlement_period_settlement_id) → settlement_period(settlement_id)
- settlement_period(invoice_id) → invoice(id)
- settlement_period(settlement_id) → settlement(id)
- settlement(balance_id) → balance(id)
- settlement(invoice_id) → invoice(id)
- chargeback(payment_id) → payment(id)
- chargeback(settlement_id) → settlement(id)
- payment_line(payment_id) → payment(id)
- payment(subscription_id) → subscription(id)
- payment(mandate_id) → mandate(id)
- payment(profile_id) → profile(id)
- payment(settlement_id) → settlement(id)
- payment(customer_id) → customer(id)
- invoice_line(invoice_id) → invoice(id)
- payment_method_issuer(profile_id) → payment_method(profile_id)
- payment_method_issuer(payment_method_id) → payment_method(id)
- payment_method_pricing(profile_id) → payment_method(profile_id)
- payment_method_pricing(payment_method_id) → payment_method(id)
- payment_method(profile_id) → profile(id)
- refund_routing_reversal(refund_id) → refund(id)
- refund(payment_id) → payment(id)
- refund(settlement_id) → settlement(id)