DATADA.AI
Online v0.9.0
data_entities 791 records
Home
model_id color physical_name origin use_type entity_type materialization_type business_domain scd_type file_type dialect dwh_use_type schema_name database_name id name description created_by_id updated_by_id created_at updated_at version deleted x y
00000000-demo-bank-mod2-000000000001 null null null UseType.SOURCE EntityType.TABLE null CRM null null null null null null 00000000-demo-bank-e201-000000000006 CRM_ACCOUNT CRM - Business account/company 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 1124 -364
00000000-demo-bank-mod2-000000000001 null null null UseType.SOURCE EntityType.TABLE null CRM null null null null null null 00000000-demo-bank-e201-000000000005 CRM_CONTACT CRM - Contact/lead information 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 1051 -674
00000000-demo-bank-mod2-000000000001 null null null UseType.SOURCE EntityType.TABLE null Core Banking null null null null null null 00000000-demo-bank-e201-000000000004 CBS_FUNDS_TRANSFER Core Banking System - Funds transfer transactions 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -1428 -469
00000000-demo-bank-mod2-000000000001 null null null UseType.SOURCE EntityType.TABLE null Core Banking null null null null null null 00000000-demo-bank-e201-000000000003 CBS_LOAN Core Banking System - Loan master data 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -1681 -351
00000000-demo-bank-mod2-000000000001 null null null UseType.SOURCE EntityType.TABLE null Core Banking null null null null null null 00000000-demo-bank-e201-000000000002 CBS_ACCOUNT Core Banking System - Account master data 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -1456 -699
00000000-demo-bank-mod2-000000000001 null null null UseType.SOURCE EntityType.TABLE null Core Banking null null null null null null 00000000-demo-bank-e201-000000000001 CBS_CUSTOMER Core Banking System - Customer master data 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -1222 -617
00000000-demo-bank-mod4-000000000001 null null null UseType.SOURCE EntityType.TABLE null Silver - Reference null null null null null null 00000000-demo-bank-e401-000000000009 REF_EXCHANGE_RATE Reference exchange rate data 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 564 170
00000000-demo-bank-mod4-000000000001 null null null UseType.SOURCE EntityType.TABLE null Silver - Reference null null null null null null 00000000-demo-bank-e401-000000000008 REF_CURRENCY Reference currency data 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 414 -134
00000000-demo-bank-mod4-000000000001 null null null UseType.SOURCE EntityType.TABLE null Silver - Reference null null null null null null 00000000-demo-bank-e401-000000000007 REF_COUNTRY Reference country data 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 277 113
00000000-demo-bank-mod4-000000000001 null null null UseType.SOURCE EntityType.TABLE null Silver - Contact Center null null null null null null 00000000-demo-bank-e401-000000000006 STG_INTERACTION Cleansed contact center interactions (append-only) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -336 -666
00000000-demo-bank-mod4-000000000001 null null null UseType.SOURCE EntityType.TABLE null Silver - Cards null null null null null null 00000000-demo-bank-e401-000000000005 STG_CARD_TRANSACTION Cleansed card transactions (append-only) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -1137 -100
00000000-demo-bank-mod4-000000000001 null null null UseType.SOURCE EntityType.TABLE null Silver - Transactions null null null null null null 00000000-demo-bank-e401-000000000004 STG_TRANSACTION Cleansed funds transfer transactions (append-only) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -636 204
00000000-demo-bank-mod4-000000000001 null null null UseType.SOURCE EntityType.TABLE null Silver - Lending null null null null null null 00000000-demo-bank-e401-000000000003 STG_LOAN Cleansed and conformed loan data with SCD Type 2 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -1249 -1016
00000000-demo-bank-mod4-000000000001 null null null UseType.SOURCE EntityType.TABLE null Silver - Account null null null null null null 00000000-demo-bank-e401-000000000002 STG_ACCOUNT Cleansed and conformed account data with SCD Type 2 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 195 707
00000000-demo-bank-mod4-000000000001 null null null UseType.SOURCE EntityType.TABLE null Silver - Customer null null null null null null 00000000-demo-bank-e401-000000000001 STG_CUSTOMER Cleansed and conformed customer data with SCD Type 2 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 704 -1220
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Marts null null null null null null 00000000-demo-bank-e501-000000000015 MART_DAILY_TRANSACTIONS Daily transaction summary mart 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -269 -406
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Marts null null null null null null 00000000-demo-bank-e501-000000000014 MART_LOAN_PORTFOLIO Loan portfolio analytics mart 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -186 -1103
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Marts null null null null null null 00000000-demo-bank-e501-000000000013 MART_CUSTOMER_360 Customer 360 aggregated view 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -486 -1365
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Facts null null null null null null 00000000-demo-bank-e501-000000000012 FACT_INTERACTION Contact center interaction fact 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 1571 361
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Facts null null null null null null 00000000-demo-bank-e501-000000000011 FACT_LOAN_SNAPSHOT Monthly loan balance snapshot fact 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 1597 -171
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Facts null null null null null null 00000000-demo-bank-e501-000000000010 FACT_CARD_TRANSACTION Card transaction fact table 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 1788 47
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Facts null null null null null null 00000000-demo-bank-e501-000000000009 FACT_TRANSACTION Transaction fact table 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 1247 329
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Facts null null null null null null 00000000-demo-bank-e501-000000000008 FACT_ACCOUNT_BALANCE Daily account balance snapshot fact 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 1758 -432
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Bridges null null null null null null 00000000-demo-bank-e501-000000000007 BRIDGE_CUSTOMER_ACCOUNT Bridge table for customer-account many-to-many 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 307 -442
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Dimensions null null null null null null 00000000-demo-bank-e501-000000000006 DIM_MERCHANT_CATEGORY Merchant category code dimension 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -1399 760
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Dimensions null null null null null null 00000000-demo-bank-e501-000000000005 DIM_CHANNEL Channel dimension 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -1383 236
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Dimensions null null null null null null 00000000-demo-bank-e501-000000000004 DIM_DATE Date dimension (role-playing) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -1693 45
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Dimensions null null null null null null 00000000-demo-bank-e501-000000000003 DIM_LOAN Loan dimension with SCD Type 2 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -1995 13
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Dimensions null null null null null null 00000000-demo-bank-e501-000000000002 DIM_ACCOUNT Account dimension with SCD Type 2 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -1541 -193
00000000-demo-bank-mod5-000000000001 null null null UseType.SOURCE EntityType.TABLE null Gold - Dimensions null null null null null null 00000000-demo-bank-e501-000000000001 DIM_CUSTOMER Customer dimension with SCD Type 2 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:37 2 -1356 -522
00000000-demo-bank-mod3-000000000001 null null null UseType.SOURCE EntityType.TABLE null Bronze - Reference null null null null null null 00000000-demo-bank-e301-000000000011 RAW_REF_EXCHANGE_RATE Raw exchange rate reference data 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 2 -270 535
00000000-demo-bank-mod3-000000000001 null null null UseType.SOURCE EntityType.TABLE null Bronze - Reference null null null null null null 00000000-demo-bank-e301-000000000010 RAW_REF_CURRENCY Raw currency reference data 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 2 -445 789
00000000-demo-bank-mod3-000000000001 null null null UseType.SOURCE EntityType.TABLE null Bronze - Reference null null null null null null 00000000-demo-bank-e301-000000000009 RAW_REF_COUNTRY Raw country reference data 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 2 -545 513
00000000-demo-bank-mod3-000000000001 null null null UseType.SOURCE EntityType.TABLE null Bronze - Contact Center null null null null null null 00000000-demo-bank-e301-000000000008 RAW_CC_INTERACTION Raw interaction data from Contact Center 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 2 728 -254
00000000-demo-bank-mod3-000000000001 null null null UseType.SOURCE EntityType.TABLE null Bronze - Card Processing null null null null null null 00000000-demo-bank-e301-000000000007 RAW_CARD_TRANSACTION Raw card transaction data from Card Processing 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 2 524 521
00000000-demo-bank-mod3-000000000001 null null null UseType.SOURCE EntityType.TABLE null Bronze - CRM null null null null null null 00000000-demo-bank-e301-000000000006 RAW_CRM_OPPORTUNITY Raw opportunity data from CRM 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 2 -573 -61
00000000-demo-bank-mod3-000000000001 null null null UseType.SOURCE EntityType.TABLE null Bronze - CRM null null null null null null 00000000-demo-bank-e301-000000000005 RAW_CRM_CONTACT Raw contact data from CRM 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 2 -856 -73
00000000-demo-bank-mod3-000000000001 null null null UseType.SOURCE EntityType.TABLE null Bronze - Core Banking null null null null null null 00000000-demo-bank-e301-000000000004 RAW_CBS_FUNDS_TRANSFER Raw funds transfer data from Core Banking System 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 2 145 -944
00000000-demo-bank-mod3-000000000001 null null null UseType.SOURCE EntityType.TABLE null Bronze - Core Banking null null null null null null 00000000-demo-bank-e301-000000000003 RAW_CBS_LOAN Raw loan data from Core Banking System 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 2 -138 -944
00000000-demo-bank-mod3-000000000001 null null null UseType.SOURCE EntityType.TABLE null Bronze - Core Banking null null null null null null 00000000-demo-bank-e301-000000000002 RAW_CBS_ACCOUNT Raw account data from Core Banking System 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 2 229 -1183
00000000-demo-bank-mod3-000000000001 null null null UseType.SOURCE EntityType.TABLE null Bronze - Core Banking null null null null null null 00000000-demo-bank-e301-000000000001 RAW_CBS_CUSTOMER Raw customer data from Core Banking System 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 2 -46 -1186