Online
v0.9.0
Tables
data_attributes 9849 records
| entity_id | physical_name | origin | data_type | dialect_type | dialect | business_type | business_type_params | data_type_info | order | scale | is_primary_key | is_foreign_key | is_unique | is_nullable | is_autoincrement | is_surrogate_key | is_business_key | is_audit_column | is_scd_column | audit_role | scd_role | pii_level | pcidss_attribute | hipaa_identifier | id | name | description | created_by_id | updated_by_id | created_at | updated_at | version | deleted |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 00000000-demo-bank-e101-000000000008 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000010 | beneficiary_account | Beneficiary account number | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000008 | null | null | STRING | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000009 | beneficiary_name | Name of payment beneficiary | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000008 | null | null | STRING | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000008 | target_account_id | Target account reference (internal) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000008 | null | null | STRING | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000007 | source_account_id | Source account reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000008 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000006 | currency_code | Payment currency | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000008 | null | null | DECIMAL | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000005 | amount | Payment amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000008 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000004 | direction | Payment direction (INBOUND, OUTBOUND) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000008 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000003 | payment_type | Type of payment (DOMESTIC, SEPA, SWIFT, INSTANT) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000008 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000002 | payment_reference | External payment reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000008 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000001 | payment_id | Unique identifier for the payment | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | STRING | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000014 | assigned_loan_id | Reference to created loan if approved | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | STRING | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000013 | rejection_reason | Reason for rejection if applicable | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | DECIMAL | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000012 | approved_rate | Approved interest rate | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | DECIMAL | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000011 | approved_amount | Approved loan amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | INTEGER | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000010 | credit_score | Credit score at time of application | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | STRING | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000009 | status | Application status (PENDING, APPROVED, REJECTED, WITHDRAWN) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | STRING | TIMESTAMP | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000008 | decision_date | Date decision was made | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | STRING | TIMESTAMP | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000007 | application_date | Date application was submitted | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000006 | purpose | Purpose of the loan | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000005 | requested_term | Requested loan term in months | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | DECIMAL | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000004 | requested_amount | Requested loan amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000003 | loan_type | Type of loan applied for | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000002 | customer_id | Reference to applicant customer | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000007 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a107-000000000001 | application_id | Unique identifier for the application | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | DECIMAL | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000017 | ltv_ratio | Loan-to-value ratio | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | DECIMAL | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000016 | collateral_value | Total value of collateral | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | STRING | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000015 | status | Loan status (ACTIVE, CLOSED, DEFAULT, WRITTEN_OFF) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | INTEGER | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000014 | days_past_due | Number of days payment is overdue | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | DATE | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000013 | next_payment_date | Next scheduled payment date | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | DATE | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000012 | maturity_date | Loan maturity date | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | DATE | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000011 | disbursement_date | Date loan was disbursed | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | DECIMAL | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000010 | monthly_payment | Regular monthly payment amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | INTEGER | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000009 | term_months | Loan term in months | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | STRING | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000008 | rate_type | Interest rate type (FIXED, VARIABLE) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | DECIMAL | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000007 | interest_rate | Current interest rate | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000006 | currency_code | Loan currency | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | DECIMAL | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000005 | outstanding_principal | Current outstanding principal | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | DECIMAL | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000004 | principal_amount | Original loan principal | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000003 | loan_type | Type of loan (MORTGAGE, PERSONAL, AUTO, BUSINESS) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000002 | loan_number | External loan reference number | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000006 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a106-000000000001 | loan_id | Unique identifier for the loan | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000005 | null | null | DATE | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a105-000000000008 | effective_to | End date of the relationship | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000005 | null | null | DATE | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a105-000000000007 | effective_from | Start date of the relationship | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000005 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a105-000000000006 | signing_authority | Signing authority level | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000005 | null | null | DECIMAL | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a105-000000000005 | ownership_percentage | Percentage of ownership | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000005 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a105-000000000004 | holder_type | Type of holder (PRIMARY, SECONDARY, AUTHORIZED) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000005 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a105-000000000003 | customer_id | Reference to the customer | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000005 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a105-000000000002 | account_id | Reference to the account | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000005 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a105-000000000001 | account_holder_id | Unique identifier for the relationship | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 | ||||||||||
| 00000000-demo-bank-e101-000000000004 | null | null | STRING | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a104-000000000013 | product_code | Banking product code | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 |