DATADA.AI
Online v0.9.0
Tables
data_attributes 9849 records
Home
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-e401-000000000001 null null DATE null null null null null 5 null null null null null null 00000000-demo-bank-a401-000000000006 DATE_OF_BIRTH Date of birth (validated) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e401-000000000001 null null STRING VARCHAR null null null null 4 null null null null null null 00000000-demo-bank-a401-000000000005 LAST_NAME Last name (trimmed, title case) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e401-000000000001 null null STRING VARCHAR null null null null 3 null null null null null null 00000000-demo-bank-a401-000000000004 FIRST_NAME First name (trimmed, title case) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e401-000000000001 null null STRING VARCHAR null null null null 2 null null null null null null 00000000-demo-bank-a401-000000000003 CUSTOMER_TYPE Customer type (INDIVIDUAL/CORPORATE/SME) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e401-000000000001 null null STRING VARCHAR null null null null 1 null null null null null null 00000000-demo-bank-a401-000000000002 CUSTOMER_BK Business key (source CUST_ID) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e401-000000000001 null null STRING NUMBER null null null null 0 null null null null null null 00000000-demo-bank-a401-000000000001 CUSTOMER_SK Surrogate key 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null STRING NUMBER null null null null 13 4 null null null null null 00000000-demo-bank-a515-000000000014 SUCCESS_RATE Success rate (0-1) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null INTEGER null null null null null 12 null null null null null null 00000000-demo-bank-a515-000000000013 UNIQUE_CUSTOMERS Unique customers 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null STRING NUMBER null null null null 11 2 null null null null null 00000000-demo-bank-a515-000000000012 TOTAL_FEES Total fees collected 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null STRING NUMBER null null null null 10 2 null null null null null 00000000-demo-bank-a515-000000000011 MAX_AMOUNT Maximum amount 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null STRING NUMBER null null null null 9 2 null null null null null 00000000-demo-bank-a515-000000000010 MIN_AMOUNT Minimum amount 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null STRING NUMBER null null null null 8 2 null null null null null 00000000-demo-bank-a515-000000000009 AVG_AMOUNT Average amount 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null STRING NUMBER null null null null 7 2 null null null null null 00000000-demo-bank-a515-000000000008 TOTAL_AMOUNT Total amount 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null INTEGER null null null null null 6 null null null null null null 00000000-demo-bank-a515-000000000007 FAILED_TRANSACTIONS Failed transactions 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null INTEGER null null null null null 5 null null null null null null 00000000-demo-bank-a515-000000000006 SUCCESSFUL_TRANSACTIONS Successful transactions 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null INTEGER null null null null null 4 null null null null null null 00000000-demo-bank-a515-000000000005 TOTAL_TRANSACTIONS Total transactions 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null CHAR null null null null null 3 null null null null null null 00000000-demo-bank-a515-000000000004 CURRENCY_CODE Currency code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null INTEGER null null null null null 2 null null null null null null 00000000-demo-bank-a515-000000000003 CHANNEL_SK Channel key 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null STRING VARCHAR null null null null 1 null null null null null null 00000000-demo-bank-a515-000000000002 TRANSACTION_TYPE Transaction type 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000015 null null INTEGER null null null null null 0 null null null null null null 00000000-demo-bank-a515-000000000001 DATE_SK Date key 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null STRING NUMBER null null null null 18 2 null null null null null 00000000-demo-bank-a514-000000000019 WEIGHTED_AVG_TERM Weighted average term (months) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null STRING NUMBER null null null null 17 5 null null null null null 00000000-demo-bank-a514-000000000018 NPL_RATIO Non-performing loan ratio 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null STRING NUMBER null null null null 16 2 null null null null null 00000000-demo-bank-a514-000000000017 EXPOSURE_90_PLUS_DPD Exposure 90+ DPD 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null STRING NUMBER null null null null 15 2 null null null null null 00000000-demo-bank-a514-000000000016 EXPOSURE_61_90_DPD Exposure 61-90 DPD 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null STRING NUMBER null null null null 14 2 null null null null null 00000000-demo-bank-a514-000000000015 EXPOSURE_31_60_DPD Exposure 31-60 DPD 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null STRING NUMBER null null null null 13 2 null null null null null 00000000-demo-bank-a514-000000000014 EXPOSURE_1_30_DPD Exposure 1-30 DPD 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null STRING NUMBER null null null null 12 2 null null null null null 00000000-demo-bank-a514-000000000013 EXPOSURE_CURRENT Exposure current 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null INTEGER null null null null null 11 null null null null null null 00000000-demo-bank-a514-000000000012 LOANS_90_PLUS_DPD Loans 90+ days past due 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null INTEGER null null null null null 10 null null null null null null 00000000-demo-bank-a514-000000000011 LOANS_61_90_DPD Loans 61-90 days past due 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null INTEGER null null null null null 9 null null null null null null 00000000-demo-bank-a514-000000000010 LOANS_31_60_DPD Loans 31-60 days past due 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null INTEGER null null null null null 8 null null null null null null 00000000-demo-bank-a514-000000000009 LOANS_1_30_DPD Loans 1-30 days past due 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null INTEGER null null null null null 7 null null null null null null 00000000-demo-bank-a514-000000000008 LOANS_CURRENT Loans current (0 DPD) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null STRING NUMBER null null null null 6 5 null null null null null 00000000-demo-bank-a514-000000000007 AVG_INTEREST_RATE Average interest rate 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null STRING NUMBER null null null null 5 2 null null null null null 00000000-demo-bank-a514-000000000006 TOTAL_OUTSTANDING Total outstanding principal 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null STRING NUMBER null null null null 4 2 null null null null null 00000000-demo-bank-a514-000000000005 TOTAL_PRINCIPAL Total principal amount 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null INTEGER null null null null null 3 null null null null null null 00000000-demo-bank-a514-000000000004 TOTAL_LOANS Total number of loans 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null CHAR null null null null null 2 null null null null null null 00000000-demo-bank-a514-000000000003 CURRENCY_CODE Currency code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null STRING VARCHAR null null null null 1 null null null null null null 00000000-demo-bank-a514-000000000002 LOAN_TYPE Loan type 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000014 null null INTEGER null null null null null 0 null null null null null null 00000000-demo-bank-a514-000000000001 SNAPSHOT_DATE_SK Snapshot date key 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000013 null null DATE null null null null null 23 null null null null null null 00000000-demo-bank-a513-000000000024 SNAPSHOT_DATE Snapshot date 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000013 null null STRING VARCHAR null null null null 22 null null null null null null 00000000-demo-bank-a513-000000000023 NEXT_BEST_ACTION Recommended next best action 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000013 null null INTEGER null null null null null 21 null null null null null null 00000000-demo-bank-a513-000000000022 CHURN_RISK_SCORE Churn risk score (0-100) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000013 null null STRING NUMBER null null null null 20 2 null null null null null 00000000-demo-bank-a513-000000000021 CUSTOMER_VALUE_SCORE Calculated customer value score 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000013 null null STRING NUMBER null null null null 19 2 null null null null null 00000000-demo-bank-a513-000000000020 AVG_SENTIMENT_SCORE Average sentiment score 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000013 null null INTEGER null null null null null 18 null null null null null null 00000000-demo-bank-a513-000000000019 TOTAL_INTERACTIONS_L12M Total interactions last 12 months 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000013 null null DATE null null null null null 17 null null null null null null 00000000-demo-bank-a513-000000000018 LAST_TRANSACTION_DATE Last transaction date 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000013 null null STRING NUMBER null null null null 16 2 null null null null null 00000000-demo-bank-a513-000000000017 YTD_TRANSACTION_AMOUNT YTD transaction amount 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000013 null null INTEGER null null null null null 15 null null null null null null 00000000-demo-bank-a513-000000000016 YTD_TRANSACTIONS Year-to-date transactions 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000013 null null STRING NUMBER null null null null 14 2 null null null null null 00000000-demo-bank-a513-000000000015 MTD_TRANSACTION_AMOUNT MTD transaction amount 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000013 null null INTEGER null null null null null 13 null null null null null null 00000000-demo-bank-a513-000000000014 MTD_TRANSACTIONS Month-to-date transactions 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
Page 190 of 197 (9849 total records)