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-000000000018 | null | null | CHAR | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a218-000000000003 | TO_CCY | To currency | 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 | CHAR | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a218-000000000002 | FROM_CCY | From currency | 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 | 0 | null | null | null | null | null | null | 00000000-demo-bank-a218-000000000001 | RATE_ID | Rate record ID | 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-000000000017 | null | null | CHAR | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a217-000000000005 | IS_ACTIVE | Active flag | 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-000000000017 | null | null | INTEGER | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a217-000000000004 | DECIMAL_PLACES | Decimal places | 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-000000000017 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a217-000000000003 | CCY_SYMBOL | Currency symbol | 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-000000000017 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a217-000000000002 | CCY_NAME | Currency 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-e201-000000000017 | null | null | CHAR | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a217-000000000001 | CCY_CD | ISO 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-e201-000000000016 | null | null | CHAR | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a216-000000000006 | IS_SEPA | SEPA member flag | 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-000000000016 | null | null | CHAR | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a216-000000000005 | IS_EU | EU member flag | 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-000000000016 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a216-000000000004 | REGION | Geographic 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-e201-000000000016 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a216-000000000003 | COUNTRY_NAME | Country 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-e201-000000000016 | null | null | CHAR | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a216-000000000002 | COUNTRY_CD_3 | ISO 3-letter 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-e201-000000000016 | null | null | CHAR | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a216-000000000001 | COUNTRY_CD | ISO 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-e201-000000000015 | null | null | CHAR | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000017 | IS_CONTACTLESS | Contactless flag | 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-000000000015 | null | null | CHAR | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000016 | IS_ONLINE | Online transaction flag | 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-000000000015 | null | null | STRING | VARCHAR | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000015 | STATUS | Transaction 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-e201-000000000015 | null | null | STRING | VARCHAR | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000014 | RESPONSE_CODE | Response 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-e201-000000000015 | null | null | STRING | VARCHAR | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000013 | AUTH_CODE | Authorization 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-e201-000000000015 | null | null | STRING | TIMESTAMP | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000012 | TXN_TS | Transaction timestamp | 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-000000000015 | null | null | CHAR | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000011 | MERCHANT_COUNTRY | Merchant country | 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-000000000015 | null | null | CHAR | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000010 | MCC | Merchant category 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-e201-000000000015 | null | null | STRING | VARCHAR | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000009 | MERCHANT_NAME | Merchant 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-e201-000000000015 | null | null | STRING | VARCHAR | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000008 | MERCHANT_ID | Merchant identifier | 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-000000000015 | null | null | CHAR | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000007 | BILL_CCY | Billing currency | 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-000000000015 | null | null | DECIMAL | null | null | null | null | null | 5 | 2 | null | null | null | null | null | 00000000-demo-bank-a215-000000000006 | BILL_AMT | Billing 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-e201-000000000015 | null | null | CHAR | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000005 | TXN_CCY | Transaction currency | 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-000000000015 | null | null | DECIMAL | null | null | null | null | null | 3 | 2 | null | null | null | null | null | 00000000-demo-bank-a215-000000000004 | TXN_AMT | Transaction 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-e201-000000000015 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000003 | TXN_TYPE | Transaction type | 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-000000000015 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000002 | CARD_ID | Card identifier | 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-000000000015 | null | null | STRING | VARCHAR | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a215-000000000001 | TXN_ID | Transaction identifier | 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-000000000014 | null | null | STRING | TIMESTAMP | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-bank-a214-000000000014 | UPD_TS | Last update timestamp | 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-000000000014 | null | null | CHAR | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a214-000000000013 | ECOM_FLG | E-commerce enabled | 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-000000000014 | null | null | CHAR | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a214-000000000012 | CONTACTLESS_FLG | Contactless enabled | 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-000000000014 | null | null | STRING | VARCHAR | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a214-000000000011 | STATUS | Card 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-e201-000000000014 | null | null | DATE | null | null | null | null | null | 9 | null | null | null | null | PCIDSSAttribute.EXPIRATION_DATE | null | 00000000-demo-bank-a214-000000000010 | EXPIRY_DT | Expiry 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-000000000014 | null | null | DATE | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a214-000000000009 | ISSUE_DT | Issue 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-000000000014 | null | null | DECIMAL | null | null | null | null | null | 7 | 2 | null | null | PIILevel.SENSITIVE | null | null | 00000000-demo-bank-a214-000000000008 | CREDIT_LIMIT | Credit 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-e201-000000000014 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | PIILevel.INDIRECT | null | null | 00000000-demo-bank-a214-000000000007 | CBS_CUST_ID | CBS customer ID | 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-000000000014 | null | null | STRING | VARCHAR | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-bank-a214-000000000006 | CBS_ACCT_ID | Linked CBS 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-e201-000000000014 | null | null | STRING | VARCHAR | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-bank-a214-000000000005 | SCHEME | Card scheme | 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-000000000014 | null | null | CHAR | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-bank-a214-000000000004 | CARD_TYPE | Card type (D/C/P) | 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-000000000014 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | PIILevel.INDIRECT | null | null | 00000000-demo-bank-a214-000000000003 | CARD_NO_MASKED | Masked card 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-e201-000000000014 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | PIILevel.SENSITIVE | PCIDSSAttribute.MAGSTRIPE | null | 00000000-demo-bank-a214-000000000002 | CARD_NO_HASH | Hashed card 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-e201-000000000014 | null | null | STRING | VARCHAR | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-bank-a214-000000000001 | CARD_ID | Card identifier | 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-000000000013 | null | null | STRING | VARCHAR | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-bank-a213-000000000013 | RESOLUTION | Resolution summary | 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-000000000013 | null | null | STRING | TIMESTAMP | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-bank-a213-000000000012 | SLA_DUE_TS | SLA due timestamp | 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-000000000013 | null | null | STRING | TIMESTAMP | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-bank-a213-000000000011 | CLOSED_TS | Closure timestamp | 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-000000000013 | null | null | STRING | TIMESTAMP | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-bank-a213-000000000010 | CREATED_TS | Creation timestamp | 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-000000000013 | null | null | STRING | VARCHAR | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-bank-a213-000000000009 | OWNER_ID | Case owner | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:36 | 2026-01-03 15:16:36 | 1 |