hellodb.io
MODELS · 18
/
42 refs · 162 fields
currency
6
PK
id
uuid
code
varchar
name
varchar
symbol
varchar
minor_unit
int
is_supported
boolean
merchant
10
PK
id
uuid
FK
currency_id
uuid
name
varchar
email
varchar
country_code
varchar
payout_schedule
enum
charges_enabled
boolean
payouts_enabled
boolean
status
enum
created_at
timestamp
customer
9
PK
id
uuid
FK
merchant_id
uuid
FK
default_payment_method_id
uuid?
email
varchar
name
varchar
balance
decimal
livemode
boolean
created_at
timestamp
deleted_at
timestamp?
payment_method
10
PK
id
uuid
FK
merchant_id
uuid
FK
customer_id
uuid?
method_type
enum
brand
varchar
last4
varchar
expires_at
date?
fingerprint
varchar
status
enum
created_at
timestamp
idempotency_key
10
PK
id
uuid
FK
merchant_id
uuid
key
varchar
request_path
varchar
request_hash
varchar
response_code
int?
response_body
jsonb?
status
enum
expires_at
timestamp
created_at
timestamp
payment_intent
10
PK
id
uuid
FK
merchant_id
uuid
FK
customer_id
uuid?
FK
payment_method_id
uuid?
FK
currency_id
uuid
FK
idempotency_key_id
uuid?
amount
decimal
amount_received
decimal
status
enum
created_at
timestamp
charge
10
PK
id
uuid
FK
payment_intent_id
uuid
FK
merchant_id
uuid
FK
payment_method_id
uuid
FK
currency_id
uuid
amount
decimal
amount_refunded
decimal
status
enum
captured_at
timestamp?
created_at
timestamp
refund
8
PK
id
uuid
FK
charge_id
uuid
FK
merchant_id
uuid
FK
currency_id
uuid
amount
decimal
reason
enum
status
enum
created_at
timestamp
dispute
10
PK
id
uuid
FK
charge_id
uuid
FK
merchant_id
uuid
FK
currency_id
uuid
amount
decimal
reason
enum
status
enum
evidence_due_by
timestamp
is_charge_refundable
boolean
created_at
timestamp
ledger_account
8
PK
id
uuid
FK
merchant_id
uuid?
FK
currency_id
uuid
code
varchar
account_type
enum
normal_balance
enum
balance
decimal
is_active
boolean
ledger_transaction
8
PK
id
uuid
FK
merchant_id
uuid?
FK
currency_id
uuid
FK
idempotency_key_id
uuid?
transaction_type
enum
is_posted
boolean
effective_at
timestamp
created_at
timestamp
ledger_entry
7
PK
id
bigint
FK
ledger_transaction_id
uuid
FK
ledger_account_id
uuid
direction
enum
amount
decimal
running_balance
decimal
created_at
timestamp
balance_transaction
10
PK
id
uuid
FK
merchant_id
uuid
FK
ledger_transaction_id
uuid
FK
currency_id
uuid
source_type
enum
gross_amount
decimal
fee_amount
decimal
net_amount
decimal
status
enum
available_on
timestamp
fee
8
PK
id
uuid
FK
merchant_id
uuid
FK
balance_transaction_id
uuid
fee_type
enum
amount
decimal
percentage_rate
decimal
fixed_amount
decimal
description
varchar
bank_account
10
PK
id
uuid
FK
merchant_id
uuid
FK
currency_id
uuid
country_code
varchar
bank_name
varchar
last4
varchar
routing_number
varchar
status
enum
is_default
boolean
created_at
timestamp
payout
10
PK
id
uuid
FK
merchant_id
uuid
FK
bank_account_id
uuid
FK
currency_id
uuid
FK
ledger_transaction_id
uuid?
amount
decimal
method
enum
status
enum
arrival_date
date
created_at
timestamp
webhook_endpoint
8
PK
id
uuid
FK
merchant_id
uuid
url
varchar
signing_secret
varchar
enabled_events
varchar[]
api_version
varchar
status
enum
created_at
timestamp
webhook_delivery
10
PK
id
bigint
FK
webhook_endpoint_id
uuid
FK
merchant_id
uuid
event_type
varchar
payload
jsonb
attempt_count
int
response_status
int?
status
enum
next_retry_at
timestamp?
created_at
timestamp
81%
Opening Payment System