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-e101-000000000004 | null | null | STRING | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a104-000000000012 | branch_code | Branch where account is held | 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-e101-000000000004 | null | null | STRING | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a104-000000000011 | status | Account status (ACTIVE, DORMANT, CLOSED, BLOCKED) | 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-e101-000000000004 | null | null | DATE | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a104-000000000010 | closing_date | Account closing 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-e101-000000000004 | null | null | DATE | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a104-000000000009 | opening_date | Account opening 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-e101-000000000004 | null | null | DECIMAL | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a104-000000000008 | interest_rate | Current interest rate | 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-e101-000000000004 | null | null | DECIMAL | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a104-000000000007 | overdraft_limit | Authorized overdraft limit | 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-e101-000000000004 | null | null | DECIMAL | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a104-000000000006 | available_balance | Available balance for transactions | 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-e101-000000000004 | null | null | DECIMAL | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a104-000000000005 | current_balance | Current account 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-e101-000000000004 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a104-000000000004 | currency_code | ISO 4217 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-e101-000000000004 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a104-000000000003 | account_type | Type of account (CURRENT, SAVINGS, TERM_DEPOSIT) | 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-e101-000000000004 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a104-000000000002 | account_number | External account number (IBAN or local format) | 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-e101-000000000004 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a104-000000000001 | account_id | Unique identifier for the account | 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-e101-000000000003 | null | null | DATE | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a103-000000000011 | valid_to | Address validity 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-e101-000000000003 | null | null | DATE | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a103-000000000010 | valid_from | Address validity 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-e101-000000000003 | null | null | BOOLEAN | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a103-000000000009 | is_primary | Flag indicating primary address | 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-e101-000000000003 | null | null | STRING | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a103-000000000008 | country_code | ISO 3166-1 alpha-2 country 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-e101-000000000003 | null | null | STRING | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a103-000000000007 | region | State/Province/Region | 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-e101-000000000003 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a103-000000000006 | postal_code | Postal/ZIP 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-e101-000000000003 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a103-000000000005 | city | City 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-e101-000000000003 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a103-000000000004 | street_line_2 | Secondary street address | 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-e101-000000000003 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a103-000000000003 | street_line_1 | Primary street address | 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-e101-000000000003 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a103-000000000002 | address_type | Type of address (REGISTERED, CORRESPONDENCE, DELIVERY) | 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-e101-000000000003 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a103-000000000001 | address_id | Unique identifier for the address | 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-e101-000000000002 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a102-000000000010 | status | Company status in the bank | 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-e101-000000000002 | null | null | DATE | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a102-000000000009 | incorporation_date | Date of company incorporation | 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-e101-000000000002 | null | null | INTEGER | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a102-000000000008 | employee_count | Number of employees | 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-e101-000000000002 | null | null | DECIMAL | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a102-000000000007 | annual_revenue | Annual revenue 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-e101-000000000002 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a102-000000000006 | company_size | Size classification (MICRO, SMALL, MEDIUM, LARGE) | 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-e101-000000000002 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a102-000000000005 | industry_code | NACE/SIC industry classification 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-e101-000000000002 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a102-000000000004 | tax_id | Company tax identification number | 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-e101-000000000002 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a102-000000000003 | registration_number | Company registration number | 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-e101-000000000002 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a102-000000000002 | company_name | Legal name of the company | 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-e101-000000000002 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a102-000000000001 | company_id | Unique identifier for the company | 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-e101-000000000001 | null | null | STRING | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a101-000000000013 | status | Customer status (ACTIVE, INACTIVE, BLOCKED) | 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-e101-000000000001 | null | null | DATE | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a101-000000000012 | onboarding_date | Date when customer was onboarded | 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-e101-000000000001 | null | null | STRING | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a101-000000000011 | kyc_status | Know Your Customer verification 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-e101-000000000001 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a101-000000000010 | customer_segment | Customer segmentation (MASS, AFFLUENT, PRIVATE) | 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-e101-000000000001 | null | null | STRING | null | null | null | null | null | 8 | null | null | null | PIILevel.DIRECT | null | HIPAAIdentifier.PHONE | 00000000-demo-bank-a101-000000000009 | phone_number | Primary phone number | 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-e101-000000000001 | null | null | STRING | null | null | null | null | null | 7 | null | null | null | PIILevel.DIRECT | null | HIPAAIdentifier.EMAIL | 00000000-demo-bank-a101-000000000008 | Primary email address | 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-e101-000000000001 | null | null | STRING | null | null | null | null | null | 6 | null | null | null | PIILevel.SENSITIVE | null | HIPAAIdentifier.SSN | 00000000-demo-bank-a101-000000000007 | tax_id | Tax identification number | 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-e101-000000000001 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | PIILevel.SENSITIVE | null | HIPAAIdentifier.SSN | 00000000-demo-bank-a101-000000000006 | national_id | National identification number | 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-e101-000000000001 | null | null | DATE | null | null | null | null | null | 4 | null | null | null | PIILevel.DIRECT | null | HIPAAIdentifier.DATES | 00000000-demo-bank-a101-000000000005 | date_of_birth | Customer's date of birth | 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-e101-000000000001 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | PIILevel.DIRECT | null | HIPAAIdentifier.NAMES | 00000000-demo-bank-a101-000000000004 | last_name | Customer's last 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-e101-000000000001 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | PIILevel.DIRECT | null | HIPAAIdentifier.NAMES | 00000000-demo-bank-a101-000000000003 | first_name | Customer's first 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-e101-000000000001 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a101-000000000002 | customer_type | Type of customer (INDIVIDUAL, CORPORATE, SME) | 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-e101-000000000001 | null | null | STRING | null | null | null | null | null | 0 | null | null | null | PIILevel.INDIRECT | null | null | 00000000-demo-bank-a101-000000000001 | customer_id | Unique identifier for the customer | 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-e201-000000000018 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a218-000000000007 | SOURCE | Rate source | 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-e201-000000000018 | null | null | DATE | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a218-000000000006 | EFFECTIVE_DT | Effective 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-e201-000000000018 | null | null | DECIMAL | null | null | null | null | null | 4 | 8 | null | null | null | null | null | 00000000-demo-bank-a218-000000000005 | RATE | Exchange rate | 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-e201-000000000018 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a218-000000000004 | RATE_TYPE | Rate type (MID/BUY/SELL) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 |