Mollie

Explore the interactive ERD

Table & Field Reference

balance_transaction

Column	Type	Keys
`id`	String	PK
`balance_id`	String	PKFK
`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	PKFK
`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	PKFK

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	PKFK
`settlement_period_settlement_id`	String	PKFK
`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	PKFK
`settlement_period_settlement_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`profile_id`	String	PKFK
`image`	Json
`name`	String

payment_method_pricing

Column	Type	Keys
`index`	Unknown	PK
`payment_method_id`	String	PKFK
`profile_id`	String	PKFK
`description`	String
`fee_region`	String
`fixed_currency`	String
`fixed_value`	String
`variable`	String

payment_method

Column	Type	Keys
`id`	String	PK
`profile_id`	String	PKFK
`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	PKFK
`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