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-e501-000000000010 | null | null | INTEGER | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000006 | MCC_SK | Merchant category key | 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-e501-000000000010 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000005 | TRANSACTION_DATE_SK | Transaction date key | 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-e501-000000000010 | null | null | STRING | NUMBER | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000004 | CUSTOMER_SK | Customer dimension key | 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-e501-000000000010 | null | null | STRING | NUMBER | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000003 | ACCOUNT_SK | Account dimension key | 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-e501-000000000010 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000002 | CARD_TXN_BK | Business key | 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-e501-000000000010 | null | null | STRING | NUMBER | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a510-000000000001 | CARD_TXN_SK | Surrogate key | 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-e501-000000000009 | null | null | BOOLEAN | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a509-000000000015 | IS_CROSS_BORDER | Cross-border payment 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-e501-000000000009 | null | null | BOOLEAN | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a509-000000000014 | IS_INTERNAL | Internal transfer 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-e501-000000000009 | null | null | STRING | VARCHAR | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a509-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-e501-000000000009 | null | null | STRING | NUMBER | null | null | null | null | 11 | 2 | null | null | null | null | null | 00000000-demo-bank-a509-000000000012 | 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-e501-000000000009 | null | null | STRING | NUMBER | null | null | null | null | 10 | 2 | null | null | null | null | null | 00000000-demo-bank-a509-000000000011 | AMOUNT_IN_BASE_CCY | Amount in base 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-e501-000000000009 | null | null | CHAR | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a509-000000000010 | CURRENCY_CODE | 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-e501-000000000009 | null | null | STRING | NUMBER | null | null | null | null | 8 | 2 | null | null | null | null | null | 00000000-demo-bank-a509-000000000009 | 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-e501-000000000009 | null | null | STRING | VARCHAR | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a509-000000000008 | TRANSACTION_TYPE | Transaction 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-e501-000000000009 | null | null | INTEGER | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a509-000000000007 | CHANNEL_SK | Channel dimension key | 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-e501-000000000009 | null | null | INTEGER | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a509-000000000006 | INITIATED_DATE_SK | Initiation date key | 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-e501-000000000009 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a509-000000000005 | VALUE_DATE_SK | Value date key | 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-e501-000000000009 | null | null | STRING | NUMBER | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a509-000000000004 | CREDIT_ACCOUNT_SK | Credit account key | 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-e501-000000000009 | null | null | STRING | NUMBER | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a509-000000000003 | DEBIT_ACCOUNT_SK | Debit account key | 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-e501-000000000009 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a509-000000000002 | TRANSACTION_BK | Business key | 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-e501-000000000009 | null | null | STRING | NUMBER | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a509-000000000001 | TRANSACTION_SK | Surrogate key | 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-e501-000000000008 | null | null | STRING | NUMBER | null | null | null | null | 7 | 8 | null | null | null | null | null | 00000000-demo-bank-a508-000000000008 | EXCHANGE_RATE | Exchange rate used | 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-e501-000000000008 | null | null | STRING | NUMBER | null | null | null | null | 6 | 2 | null | null | null | null | null | 00000000-demo-bank-a508-000000000007 | BALANCE_IN_BASE_CCY | Balance in base currency (EUR) | 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-e501-000000000008 | null | null | STRING | NUMBER | null | null | null | null | 5 | 2 | null | null | null | null | null | 00000000-demo-bank-a508-000000000006 | OVERDRAFT_UTILIZATION | Overdraft amount used | 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-e501-000000000008 | null | null | STRING | NUMBER | null | null | null | null | 4 | 2 | null | null | null | null | null | 00000000-demo-bank-a508-000000000005 | AVAILABLE_BALANCE | Available balance | 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-e501-000000000008 | null | null | STRING | NUMBER | null | null | null | null | 3 | 2 | null | null | null | null | null | 00000000-demo-bank-a508-000000000004 | CURRENT_BALANCE | End of day balance | 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-e501-000000000008 | null | null | INTEGER | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a508-000000000003 | DATE_SK | Date dimension key | 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-e501-000000000008 | null | null | STRING | NUMBER | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a508-000000000002 | ACCOUNT_SK | Account dimension key | 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-e501-000000000008 | null | null | STRING | NUMBER | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a508-000000000001 | BALANCE_SK | Surrogate key | 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-e501-000000000007 | null | null | BOOLEAN | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a507-000000000008 | IS_CURRENT | Current relationship 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-e501-000000000007 | null | null | DATE | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a507-000000000007 | EFFECTIVE_TO | Relationship end 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-e501-000000000007 | null | null | DATE | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a507-000000000006 | EFFECTIVE_FROM | Relationship start 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-e501-000000000007 | null | null | STRING | NUMBER | null | null | null | null | 4 | 2 | null | null | null | null | null | 00000000-demo-bank-a507-000000000005 | OWNERSHIP_PERCENTAGE | Ownership percentage | 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-e501-000000000007 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a507-000000000004 | HOLDER_TYPE | Holder type (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-e501-000000000007 | null | null | STRING | NUMBER | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a507-000000000003 | ACCOUNT_SK | Account surrogate key | 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-e501-000000000007 | null | null | STRING | NUMBER | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a507-000000000002 | CUSTOMER_SK | Customer surrogate key | 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-e501-000000000007 | null | null | STRING | NUMBER | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a507-000000000001 | BRIDGE_SK | Surrogate key | 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-e501-000000000006 | null | null | BOOLEAN | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a506-000000000007 | IS_ESSENTIAL | Essential spending 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-e501-000000000006 | null | null | BOOLEAN | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a506-000000000006 | IS_ENTERTAINMENT | Entertainment category 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-e501-000000000006 | null | null | BOOLEAN | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a506-000000000005 | IS_TRAVEL | Travel category 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-e501-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a506-000000000004 | MCC_GROUP | MCC group | 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-e501-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a506-000000000003 | MCC_DESCRIPTION | MCC 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-e501-000000000006 | null | null | CHAR | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a506-000000000002 | MCC_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-e501-000000000006 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a506-000000000001 | MCC_SK | Surrogate key | 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-e501-000000000005 | null | null | BOOLEAN | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a505-000000000005 | IS_DIGITAL | Digital channel 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-e501-000000000005 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a505-000000000004 | CHANNEL_CATEGORY | Channel category (DIGITAL/PHYSICAL) | 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-e501-000000000005 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a505-000000000003 | CHANNEL_NAME | Channel 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-e501-000000000005 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a505-000000000002 | CHANNEL_CODE | Channel 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-e501-000000000005 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a505-000000000001 | CHANNEL_SK | Surrogate key | 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-e501-000000000004 | null | null | INTEGER | null | null | null | null | null | 19 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000020 | FISCAL_QUARTER | Fiscal quarter | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 |