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-ecom-phys-000000000006 | null | null | INTEGER | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000013 | MTD_ORDERS | Month-to-date orders | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | INTEGER | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000012 | DAYS_SINCE_LAST_ORDER | Days since last order | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | DATE | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000011 | LAST_ORDER_DATE | Last order date | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | DATE | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000010 | FIRST_ORDER_DATE | First order date | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | INTEGER | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000009 | TOTAL_ITEMS_ORDERED | Total items ordered | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-ecom-p006-000000000008 | AVG_ORDER_VALUE | Average order value | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 6 | 2 | null | null | null | null | null | 00000000-demo-ecom-p006-000000000007 | TOTAL_ORDER_VALUE | Total order value (lifetime) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | INTEGER | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000006 | TOTAL_ORDERS | Total number of orders | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000005 | TENURE_MONTHS | Tenure in months | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000004 | CUSTOMER_SEGMENT | Customer segment | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000003 | FULL_NAME | Full name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000002 | CUSTOMER_BK | Business key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000001 | CUSTOMER_SK | Customer key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | STRING | VARCHAR | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000017 | SOURCE_CHANNEL | Source channel | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | STRING | VARCHAR | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000016 | CONVERTED_ORDER_BK | Converted order business key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | BOOLEAN | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000015 | WAS_CONVERTED | Cart was converted flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | INTEGER | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000014 | HOURS_TO_ABANDON | Hours from creation to abandonment | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | CHAR | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000013 | CURRENCY_CODE | Currency code | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | DECIMAL | null | null | null | null | null | 11 | 2 | null | null | null | null | null | 00000000-demo-ecom-p005-000000000012 | CART_TOTAL_VALUE | Total cart value | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | DECIMAL | null | null | null | null | null | 10 | 2 | null | null | null | null | null | 00000000-demo-ecom-p005-000000000011 | LINE_VALUE | Total line value | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | DECIMAL | null | null | null | null | null | 9 | 2 | null | null | null | null | null | 00000000-demo-ecom-p005-000000000010 | UNIT_PRICE | Unit price | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | INTEGER | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000009 | QUANTITY | Quantity in cart | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | BOOLEAN | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000008 | IS_GUEST | Guest cart flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000007 | CART_STATUS | Cart status | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | INTEGER | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000006 | ABANDONED_DATE_SK | Abandonment date key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000005 | CART_CREATED_DATE_SK | Cart created date key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | INTEGER | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000004 | PRODUCT_SK | Product dimension key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | INTEGER | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000003 | CUSTOMER_SK | Customer dimension key (null for guests) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000002 | CART_BK | Cart business key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000005 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-p005-000000000001 | CART_FACT_SK | Surrogate key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | INTEGER | null | null | null | null | null | 25 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000026 | DAYS_TO_DELIVER | Days from order to delivery | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | INTEGER | null | null | null | null | null | 24 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000025 | DAYS_TO_SHIP | Days from order to ship | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 23 | 2 | null | null | null | null | null | 00000000-demo-ecom-p004-000000000024 | RETURN_AMOUNT | Return/refund amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | BOOLEAN | null | null | null | null | null | 22 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000023 | IS_RETURNED | Item returned flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | BOOLEAN | null | null | null | null | null | 21 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000022 | IS_FIRST_ORDER | First order flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 20 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000021 | SOURCE_CHANNEL | Order source channel | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 19 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000020 | SHIPPING_METHOD | Shipping method | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | CHAR | null | null | null | null | null | 18 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000019 | CURRENCY_CODE | Currency code | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 17 | 2 | null | null | null | null | null | 00000000-demo-ecom-p004-000000000018 | SHIPPING_AMOUNT | Shipping amount (order level) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 16 | 2 | null | null | null | null | null | 00000000-demo-ecom-p004-000000000017 | NET_AMOUNT | Net amount (after discount + tax) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 15 | 2 | null | null | null | null | null | 00000000-demo-ecom-p004-000000000016 | TAX_AMOUNT | Tax amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 14 | 2 | null | null | null | null | null | 00000000-demo-ecom-p004-000000000015 | DISCOUNT_AMOUNT | Discount amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 13 | 2 | null | null | null | null | null | 00000000-demo-ecom-p004-000000000014 | GROSS_AMOUNT | Gross amount (qty * unit_price) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 12 | 2 | null | null | null | null | null | 00000000-demo-ecom-p004-000000000013 | UNIT_PRICE | Unit price | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | INTEGER | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000012 | QUANTITY | Quantity ordered | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000011 | PAYMENT_STATUS | Payment status | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000010 | ORDER_STATUS | Order status | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000009 | ORDER_NUMBER | Order number | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | INTEGER | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000008 | DELIVERY_DATE_SK | Delivery date dimension key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | INTEGER | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000007 | SHIP_DATE_SK | Ship date dimension key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 |