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-000000000004 | null | null | INTEGER | null | null | null | null | null | 18 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000019 | FISCAL_YEAR | Fiscal year | 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-000000000004 | null | null | BOOLEAN | null | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000018 | IS_BUSINESS_DAY | Business day flag | 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-000000000004 | null | null | BOOLEAN | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000017 | IS_HOLIDAY | Holiday flag | 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-000000000004 | null | null | BOOLEAN | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000016 | IS_WEEKEND | Weekend flag | 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-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000015 | YEAR_QUARTER | Year-Quarter (YYYY-Q#) | 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-000000000004 | null | null | CHAR | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000014 | YEAR_MONTH | Year-Month (YYYY-MM) | 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-000000000004 | null | null | INTEGER | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000013 | YEAR | Year | 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-000000000004 | null | null | CHAR | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000012 | QUARTER_NAME | Quarter name (Q1-Q4) | 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-000000000004 | null | null | INTEGER | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000011 | QUARTER | Quarter (1-4) | 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-000000000004 | null | null | CHAR | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000010 | MONTH_SHORT_NAME | Month short name | 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-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000009 | MONTH_NAME | Month name | 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-000000000004 | null | null | INTEGER | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000008 | MONTH_NUMBER | Month 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-e501-000000000004 | null | null | INTEGER | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000007 | WEEK_OF_YEAR | Week of year | 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-000000000004 | null | null | INTEGER | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000006 | DAY_OF_YEAR | Day of year | 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-000000000004 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000005 | DAY_OF_MONTH | Day of month | 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-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000004 | DAY_NAME | Day name | 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-000000000004 | null | null | INTEGER | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000003 | DAY_OF_WEEK | Day of week (1-7) | 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-000000000004 | null | null | DATE | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000002 | DATE_VALUE | Date value | 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-000000000004 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a504-000000000001 | DATE_SK | Surrogate key (YYYYMMDD) | 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-000000000003 | null | null | BOOLEAN | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000015 | IS_CURRENT | Current record flag | 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-000000000003 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000014 | EFFECTIVE_TO | SCD2 effective to | 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-000000000003 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000013 | EFFECTIVE_FROM | SCD2 effective from | 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-000000000003 | null | null | STRING | NUMBER | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000012 | CUSTOMER_SK | Customer 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-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000011 | STATUS | Loan 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-e501-000000000003 | null | null | DATE | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000010 | MATURITY_DATE | 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-e501-000000000003 | null | null | DATE | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000009 | DISBURSEMENT_DATE | 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-e501-000000000003 | null | null | INTEGER | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000008 | 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-e501-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000007 | RATE_TYPE | Rate 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-000000000003 | null | null | CHAR | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000006 | 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-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000005 | LOAN_TYPE_DESC | Loan type description | 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-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000004 | 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-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000003 | LOAN_NUMBER | 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-e501-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000002 | LOAN_BK | Business 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-000000000003 | null | null | STRING | NUMBER | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a503-000000000001 | LOAN_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-000000000002 | null | null | BOOLEAN | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000017 | IS_CURRENT | Current record flag | 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-000000000002 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000016 | EFFECTIVE_TO | SCD2 effective to | 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-000000000002 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000015 | EFFECTIVE_FROM | SCD2 effective from | 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-000000000002 | null | null | STRING | NUMBER | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000014 | PRIMARY_CUSTOMER_SK | Primary customer 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-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000013 | STATUS | Account 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-e501-000000000002 | null | null | DATE | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000012 | CLOSING_DATE | 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-e501-000000000002 | null | null | DATE | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000011 | OPENING_DATE | 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-e501-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000010 | BRANCH_CODE | 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-e501-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000009 | PRODUCT_NAME | Product name (denormalized) | 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-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000008 | PRODUCT_CODE | 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-e501-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000007 | CURRENCY_NAME | Currency name (denormalized) | 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-000000000002 | null | null | CHAR | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000006 | 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-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000005 | ACCOUNT_TYPE_DESC | Account type description | 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-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000004 | ACCOUNT_TYPE | Account 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-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000003 | ACCOUNT_NUMBER | 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-e501-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a502-000000000002 | ACCOUNT_BK | Business key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:28 | 2026-01-03 15:41:28 | 1 |