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-000000000012 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a112-000000000001 | interaction_id | Unique identifier for the interaction | 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-000000000011 | null | null | DATE | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a111-000000000013 | retirement_date | Product retirement 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-000000000011 | null | null | DATE | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a111-000000000012 | launch_date | Product launch 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-000000000011 | null | null | BOOLEAN | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a111-000000000011 | is_active | Product active flag | 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-000000000011 | null | null | DECIMAL | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a111-000000000010 | interest_rate_base | Base 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-000000000011 | null | null | DECIMAL | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a111-000000000009 | max_amount | Maximum 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-000000000011 | null | null | DECIMAL | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a111-000000000008 | min_amount | Minimum 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-000000000011 | null | null | STRING | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a111-000000000007 | currency_code | Product 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-000000000011 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a111-000000000006 | description | Product description | 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-000000000011 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a111-000000000005 | product_type | Specific product type | 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-000000000011 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a111-000000000004 | product_category | Product category (DEPOSITS, LOANS, CARDS, INVESTMENTS) | 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-000000000011 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a111-000000000003 | product_name | Product display name | 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-000000000011 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a111-000000000002 | product_code | 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 | ||||||||||
| 00000000-demo-bank-e101-000000000011 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a111-000000000001 | product_id | Unique identifier for the product | 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-000000000010 | null | null | BOOLEAN | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000015 | is_contactless | Contactless transaction flag | 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-000000000010 | null | null | BOOLEAN | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000014 | is_online | Online transaction flag | 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-000000000010 | null | null | STRING | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000013 | status | Transaction status | 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-000000000010 | null | null | STRING | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000012 | authorization_code | Authorization code | 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-000000000010 | null | null | STRING | TIMESTAMP | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000011 | transaction_timestamp | Transaction date and time | 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-000000000010 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000010 | merchant_country | Merchant country code | 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-000000000010 | null | null | STRING | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000009 | merchant_category_code | MCC code | 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-000000000010 | null | null | STRING | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000008 | merchant_name | Merchant name | 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-000000000010 | null | null | STRING | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000007 | billing_currency | Billing currency code | 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-000000000010 | null | null | DECIMAL | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000006 | billing_amount | Amount in billing 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-000000000010 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000005 | currency_code | Transaction 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-000000000010 | null | null | DECIMAL | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000004 | amount | Transaction 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-000000000010 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000003 | transaction_type | Type (PURCHASE, WITHDRAWAL, REFUND) | 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-000000000010 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000002 | card_id | Reference to the card | 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-000000000010 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a110-000000000001 | transaction_id | Unique identifier for the transaction | 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-000000000009 | null | null | BOOLEAN | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a109-000000000013 | online_enabled | Online/e-commerce enabled flag | 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-000000000009 | null | null | BOOLEAN | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a109-000000000012 | contactless_enabled | Contactless payment enabled flag | 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-000000000009 | null | null | STRING | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a109-000000000011 | status | Card status (ACTIVE, BLOCKED, EXPIRED, CANCELLED) | 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-000000000009 | null | null | DATE | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a109-000000000010 | expiry_date | Card expiry 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-000000000009 | null | null | DATE | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a109-000000000009 | issue_date | Card issue 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-000000000009 | null | null | DECIMAL | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a109-000000000008 | available_credit | Available credit 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-000000000009 | null | null | DECIMAL | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a109-000000000007 | credit_limit | Credit limit for credit cards | 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-000000000009 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a109-000000000006 | customer_id | Card holder 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-000000000009 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a109-000000000005 | account_id | Linked 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-000000000009 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a109-000000000004 | card_scheme | Card scheme (VISA, MASTERCARD, AMEX) | 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-000000000009 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a109-000000000003 | card_type | Type of card (DEBIT, CREDIT, PREPAID) | 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-000000000009 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a109-000000000002 | card_number_masked | Masked card 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-000000000009 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a109-000000000001 | card_id | Unique identifier for the card | 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 | 17 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000018 | fee_amount | Transaction fee | 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 | 16 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000017 | channel | Channel used (BRANCH, ATM, ONLINE, MOBILE) | 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 | 15 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000016 | status | Payment status (PENDING, COMPLETED, FAILED, CANCELLED) | 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 | DATE | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000015 | value_date | Value date of 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-000000000008 | null | null | STRING | TIMESTAMP | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000014 | processed_at | Timestamp when payment was processed | 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 | TIMESTAMP | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000013 | initiated_at | Timestamp when payment was initiated | 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 | 11 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000012 | remittance_info | Payment description/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 | 10 | null | null | null | null | null | null | 00000000-demo-bank-a108-000000000011 | beneficiary_bank_code | Beneficiary bank BIC/SWIFT | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 |