hellodb.io
MODELS · 17
/
29 refs · 155 fields
customer
9
PK
id
uuid
full_name
varchar
email
varchar
phone
varchar
date_of_birth
date
kyc_status
enum
risk_rating
enum
created_at
timestamp
closed_at
timestamp?
kyc_document
9
PK
id
uuid
FK
customer_id
uuid
document_type
enum
document_number
varchar
issuing_country
varchar
verification_status
enum
expires_on
date?
verified_at
timestamp?
uploaded_at
timestamp
account
9
PK
id
uuid
account_number
varchar
account_type
enum
currency
varchar
status
enum
overdraft_limit
decimal
branch_code
varchar
opened_at
timestamp
closed_at
timestamp?
account_holder
7
PK
id
uuid
FK
account_id
uuid
FK
customer_id
uuid
holder_role
enum
ownership_share
decimal
added_at
timestamp
removed_at
timestamp?
balance
8
PK
id
uuid
FK
account_id
uuid
available_amount
decimal
ledger_amount
decimal
hold_amount
decimal
currency
varchar
version
bigint
as_of
timestamp
transaction
10
PK
id
uuid
FK
account_id
uuid
FK
transfer_id
uuid?
direction
enum
amount
decimal
currency
varchar
status
enum
narrative
varchar
value_date
date
posted_at
timestamp?
ledger_entry
8
PK
id
uuid
FK
transaction_id
uuid
FK
account_id
uuid
entry_side
enum
amount
decimal
currency
varchar
sequence_no
int
booked_at
timestamp
transfer
10
PK
id
uuid
FK
source_account_id
uuid
FK
destination_account_id
uuid?
FK
beneficiary_id
uuid?
FK
initiated_by_id
uuid
amount
decimal
fee_amount
decimal
rail
enum
status
enum
requested_at
timestamp
beneficiary
9
PK
id
uuid
FK
customer_id
uuid
FK
linked_account_id
uuid?
nickname
varchar
payee_account_number
varchar
bank_identifier
varchar
status
enum
cooling_off_until
timestamp?
created_at
timestamp
standing_instruction
9
PK
id
uuid
FK
source_account_id
uuid
FK
beneficiary_id
uuid
amount
decimal
frequency
enum
next_run_on
date
end_on
date?
status
enum
created_at
timestamp
card
10
PK
id
uuid
FK
account_id
uuid
FK
customer_id
uuid
card_network
enum
card_type
enum
last_four
varchar
expires_on
date
daily_limit
decimal
status
enum
issued_at
timestamp
card_transaction
9
PK
id
uuid
FK
card_id
uuid
FK
transaction_id
uuid?
merchant_name
varchar
merchant_category_code
varchar
authorised_amount
decimal
settled_amount
decimal?
auth_status
enum
authorised_at
timestamp
loan
10
PK
id
uuid
FK
customer_id
uuid
FK
disbursement_account_id
uuid
product_type
enum
principal_amount
decimal
annual_interest_rate
decimal
term_months
int
status
enum
disbursed_on
date?
created_at
timestamp
loan_repayment
10
PK
id
uuid
FK
loan_id
uuid
FK
transaction_id
uuid?
instalment_no
int
due_on
date
principal_component
decimal
interest_component
decimal
amount_paid
decimal
status
enum
paid_at
timestamp?
interest_accrual
9
PK
id
uuid
FK
account_id
uuid?
FK
loan_id
uuid?
FK
posted_transaction_id
uuid?
accrual_date
date
principal_base
decimal
daily_rate
decimal
accrued_amount
decimal
is_capitalised
boolean
statement
10
PK
id
uuid
FK
account_id
uuid
period_start
date
period_end
date
opening_balance
decimal
closing_balance
decimal
total_credits
decimal
total_debits
decimal
delivery_status
enum
generated_at
timestamp
audit_log
9
PK
id
bigint
FK
actor_customer_id
uuid?
entity_type
enum
entity_id
uuid
action
enum
before_state
jsonb?
after_state
jsonb?
ip_address
varchar
occurred_at
timestamp
110%
Opening Banking App