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-ent3-000000000002 | null | null | DECIMAL | null | null | null | null | null | 9 | 2 | null | null | null | null | null | 00000000-demo-ecom-a302-000000000010 | tax_amount | Item tax amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000002 | null | null | DECIMAL | null | null | null | null | null | 8 | 2 | null | null | null | null | null | 00000000-demo-ecom-a302-000000000009 | discount_amount | Item discount amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000002 | null | null | DECIMAL | null | null | PRODUCT_PRICE | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-ecom-a302-000000000008 | unit_price | Price per unit | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000002 | null | null | INTEGER | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a302-000000000007 | quantity | Quantity ordered | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000002 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a302-000000000006 | name | Product name at time of order | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000002 | null | null | STRING | null | null | SKU | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a302-000000000005 | sku | SKU at time of order | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000002 | null | null | STRING | null | null | UUID | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a302-000000000004 | variant_id | Product variant reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000002 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a302-000000000003 | product_id | Product reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000002 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a302-000000000002 | order_id | Parent order reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000002 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a302-000000000001 | order_item_id | Unique order item identifier | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | DATETIME | null | null | null | null | null | 24 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000025 | updated_at | Record last update timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | DATETIME | null | null | null | null | null | 23 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000024 | created_at | Record creation timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | DATETIME | null | null | null | null | null | 22 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000023 | delivered_at | Order delivery timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | DATETIME | null | null | null | null | null | 21 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000022 | shipped_at | Order shipment timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | DATETIME | null | null | null | null | null | 20 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000021 | confirmed_at | Order confirmation timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | DATETIME | null | null | null | null | null | 19 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000020 | ordered_at | Order placement timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | null | null | null | 18 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000019 | source_channel | Order source (web, mobile, marketplace) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | USER_AGENT | null | null | 17 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000018 | user_agent | Browser user agent | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | IP_ADDRESS | null | null | 16 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000017 | ip_address | Customer IP address | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000016 | order_notes | Customer order notes | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000015 | shipping_method | Selected shipping method | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | UUID | null | null | 13 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000014 | shipping_address_id | Shipping address reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | UUID | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000013 | billing_address_id | Billing address reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000012 | coupon_code | Applied coupon code | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | CURRENCY | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000011 | currency | Order currency | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | DECIMAL | null | null | MONEY | null | null | 9 | 2 | null | null | null | null | null | 00000000-demo-ecom-a301-000000000010 | total_amount | Final order total | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | DECIMAL | null | null | null | null | null | 8 | 2 | null | null | null | null | null | 00000000-demo-ecom-a301-000000000009 | tax_amount | Tax amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | DECIMAL | null | null | null | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-ecom-a301-000000000008 | shipping_amount | Shipping cost | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | DECIMAL | null | null | null | null | null | 6 | 2 | null | null | null | null | null | 00000000-demo-ecom-a301-000000000007 | discount_amount | Total discount applied | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | DECIMAL | null | null | MONEY | null | null | 5 | 2 | null | null | null | null | null | 00000000-demo-ecom-a301-000000000006 | subtotal | Order subtotal before tax/shipping | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000005 | payment_status | Payment status (pending, paid, refunded, failed) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000004 | order_status | Order status (pending, confirmed, shipped, delivered, cancelled) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000003 | customer_id | Customer reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000002 | order_number | Human-readable order number | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-ent3-000000000001 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a301-000000000001 | order_id | Unique order identifier | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | DATE | null | null | null | null | null | 27 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000028 | SNAPSHOT_DATE | Snapshot date | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 26 | 2 | null | null | null | null | null | 00000000-demo-ecom-p006-000000000027 | CUSTOMER_LIFETIME_VALUE | Predicted CLV | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | INTEGER | null | null | null | null | null | 25 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000026 | CHURN_RISK_SCORE | Churn risk score (0-100) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | INTEGER | null | null | null | null | null | 24 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000025 | REVIEWS_COUNT | Number of reviews given | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 23 | 2 | null | null | null | null | null | 00000000-demo-ecom-p006-000000000024 | AVG_REVIEW_RATING | Average review rating given | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | INTEGER | null | null | null | null | null | 22 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000023 | CART_ABANDONMENT_COUNT | Cart abandonment count | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 21 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000022 | PREFERRED_CHANNEL | Preferred purchase channel | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 20 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000021 | TOP_BRAND | Most purchased brand | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | STRING | VARCHAR | null | null | null | null | 19 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000020 | TOP_CATEGORY | Most purchased category | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 18 | 2 | null | null | null | null | null | 00000000-demo-ecom-p006-000000000019 | TOTAL_REFUND_AMOUNT | Total refund amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 17 | 4 | null | null | null | null | null | 00000000-demo-ecom-p006-000000000018 | RETURN_RATE | Return rate (0-1) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | INTEGER | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000017 | TOTAL_RETURNS | Total returns | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 15 | 2 | null | null | null | null | null | 00000000-demo-ecom-p006-000000000016 | YTD_ORDER_VALUE | YTD order value | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | INTEGER | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-ecom-p006-000000000015 | YTD_ORDERS | Year-to-date orders | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 13 | 2 | null | null | null | null | null | 00000000-demo-ecom-p006-000000000014 | MTD_ORDER_VALUE | MTD order value | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 |