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-e201-000000000004 | null | null | CHAR | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a204-000000000007 | CCY_CD | 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-e201-000000000004 | null | null | DECIMAL | null | null | null | null | null | 5 | 2 | null | null | null | null | null | 00000000-demo-bank-a204-000000000006 | AMT | 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-e201-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a204-000000000005 | CR_ACCT_ID | Credit account 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-e201-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a204-000000000004 | DR_ACCT_ID | Debit account 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-e201-000000000004 | null | null | CHAR | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a204-000000000003 | TXN_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-e201-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a204-000000000002 | TXN_REF | Transaction reference | 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-e201-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a204-000000000001 | TXN_ID | Transaction identifier | 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-e201-000000000003 | null | null | STRING | TIMESTAMP | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000018 | UPD_TS | Last update timestamp | 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-e201-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000017 | DISB_ACCT_ID | Disbursement account 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-e201-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000016 | CUST_ID | Customer 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-e201-000000000003 | null | null | CHAR | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000015 | STATUS_CD | Status 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-e201-000000000003 | null | null | INTEGER | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000014 | DPD | 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-e201-000000000003 | null | null | DATE | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000013 | NEXT_PMT_DT | Next payment 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-e201-000000000003 | null | null | DATE | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000012 | MATURITY_DT | Maturity 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-e201-000000000003 | null | null | DATE | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000011 | DISBMT_DT | Disbursement 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-e201-000000000003 | null | null | DECIMAL | null | null | null | null | null | 9 | 2 | null | null | null | null | null | 00000000-demo-bank-a203-000000000010 | MONTHLY_PMT | Monthly payment | 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-e201-000000000003 | null | null | INTEGER | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000009 | TERM_MONTHS | Term in 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-e201-000000000003 | null | null | CHAR | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000008 | RATE_TYPE | Rate type (F/V) | 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-e201-000000000003 | null | null | DECIMAL | null | null | null | null | null | 6 | 5 | null | null | null | null | null | 00000000-demo-bank-a203-000000000007 | INT_RATE | 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-e201-000000000003 | null | null | CHAR | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000006 | CCY_CD | 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-e201-000000000003 | null | null | DECIMAL | null | null | null | null | null | 4 | 2 | null | null | null | null | null | 00000000-demo-bank-a203-000000000005 | OUTSTAND_AMT | 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-e201-000000000003 | null | null | DECIMAL | null | null | null | null | null | 3 | 2 | null | null | null | null | null | 00000000-demo-bank-a203-000000000004 | PRINCIPAL_AMT | Original 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-e201-000000000003 | null | null | CHAR | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000003 | LOAN_TYPE | Loan type 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-e201-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000002 | LOAN_NO | Loan reference number | 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-e201-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a203-000000000001 | LOAN_ID | Loan identifier | 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-e201-000000000002 | null | null | STRING | TIMESTAMP | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a202-000000000015 | UPD_TS | Last update timestamp | 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-e201-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a202-000000000014 | CUST_ID | Primary customer 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-e201-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a202-000000000013 | PROD_CD | Product 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-e201-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a202-000000000012 | BRANCH_CD | Branch 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-e201-000000000002 | null | null | CHAR | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a202-000000000011 | STATUS_CD | Status 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-e201-000000000002 | null | null | DATE | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a202-000000000010 | CLOSE_DT | Closing 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-e201-000000000002 | null | null | DATE | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a202-000000000009 | OPEN_DT | Opening 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-e201-000000000002 | null | null | DECIMAL | null | null | null | null | null | 7 | 5 | null | null | null | null | null | 00000000-demo-bank-a202-000000000008 | INT_RATE | 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-e201-000000000002 | null | null | DECIMAL | null | null | null | null | null | 6 | 2 | null | null | null | null | null | 00000000-demo-bank-a202-000000000007 | OD_LIMIT | Overdraft limit | 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-e201-000000000002 | null | null | DECIMAL | null | null | null | null | null | 5 | 2 | null | null | null | null | null | 00000000-demo-bank-a202-000000000006 | AVAIL_BAL | Available balance | 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-e201-000000000002 | null | null | DECIMAL | null | null | null | null | null | 4 | 2 | null | null | null | null | null | 00000000-demo-bank-a202-000000000005 | CURR_BAL | Current balance | 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-e201-000000000002 | null | null | CHAR | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a202-000000000004 | CCY_CD | 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-e201-000000000002 | null | null | CHAR | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a202-000000000003 | ACCT_TYPE | Account type 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-e201-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a202-000000000002 | ACCT_NO | Account number (IBAN) | 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-e201-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a202-000000000001 | ACCT_ID | Account identifier | 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-e201-000000000001 | null | null | STRING | TIMESTAMP | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-bank-a201-000000000016 | UPD_TS | Last update timestamp | 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-e201-000000000001 | null | null | CHAR | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a201-000000000015 | STATUS_CD | Status 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-e201-000000000001 | null | null | DATE | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a201-000000000014 | ONBOARD_DT | Onboarding 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-e201-000000000001 | null | null | CHAR | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a201-000000000013 | KYC_STATUS | KYC verification status | 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-e201-000000000001 | null | null | CHAR | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a201-000000000012 | COUNTRY_CD | Country 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-e201-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 10 | null | null | null | PIILevel.INDIRECT | null | HIPAAIdentifier.GEO | 00000000-demo-bank-a201-000000000011 | POSTAL_CD | Postal 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-e201-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 9 | null | null | null | PIILevel.INDIRECT | null | null | 00000000-demo-bank-a201-000000000010 | CITY | City | 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-e201-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 8 | null | null | null | PIILevel.DIRECT | null | HIPAAIdentifier.GEO | 00000000-demo-bank-a201-000000000009 | ADDR_LINE2 | Address line 2 | 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-e201-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 7 | null | null | null | PIILevel.DIRECT | null | HIPAAIdentifier.GEO | 00000000-demo-bank-a201-000000000008 | ADDR_LINE1 | Address line 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-e201-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | PIILevel.SENSITIVE | null | HIPAAIdentifier.SSN | 00000000-demo-bank-a201-000000000007 | TAX_ID | Tax ID number | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 |