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-ent1-000000000001 | null | null | STRING | null | null | null | null | null | 19 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000020 | meta_title | SEO meta title | 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-ent1-000000000001 | null | null | STRING | null | null | null | null | null | 18 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000019 | tax_class | Tax classification | 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-ent1-000000000001 | null | null | BOOLEAN | null | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000018 | is_featured | Featured product flag | 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-ent1-000000000001 | null | null | BOOLEAN | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000017 | is_active | Product availability flag | 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-ent1-000000000001 | null | null | STRING | null | null | IMAGE_URL | null | null | 15 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000016 | image_url | Primary product image | 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-ent1-000000000001 | null | null | DECIMAL | null | null | null | null | null | 14 | 2 | null | null | null | null | null | 00000000-demo-ecom-a101-000000000015 | height | Product height in cm | 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-ent1-000000000001 | null | null | DECIMAL | null | null | null | null | null | 13 | 2 | null | null | null | null | null | 00000000-demo-ecom-a101-000000000014 | width | Product width in cm | 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-ent1-000000000001 | null | null | DECIMAL | null | null | null | null | null | 12 | 2 | null | null | null | null | null | 00000000-demo-ecom-a101-000000000013 | length | Product length in cm | 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-ent1-000000000001 | null | null | STRING | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000012 | weight_unit | Weight measurement 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-ent1-000000000001 | null | null | DECIMAL | null | null | null | null | null | 10 | 3 | null | null | null | null | null | 00000000-demo-ecom-a101-000000000011 | weight | Product weight in kg | 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-ent1-000000000001 | null | null | STRING | null | null | CURRENCY | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000010 | currency | Price currency 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-ent1-000000000001 | null | null | DECIMAL | null | null | PRODUCT_PRICE | null | null | 8 | 2 | null | null | null | null | null | 00000000-demo-ecom-a101-000000000009 | base_price | Base price before discounts | 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-ent1-000000000001 | null | null | STRING | null | null | UUID | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000008 | brand_id | Brand 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-ent1-000000000001 | null | null | STRING | null | null | UUID | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000007 | category_id | Primary category 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-ent1-000000000001 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000006 | short_description | Brief product summary | 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-ent1-000000000001 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000005 | description | Product description | 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-ent1-000000000001 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000004 | slug | URL-friendly product 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-ent1-000000000001 | null | null | STRING | null | null | PRODUCT_NAME | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000003 | name | Product name | 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-ent1-000000000001 | null | null | STRING | null | null | SKU | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000002 | sku | Stock keeping unit 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-ent1-000000000001 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000001 | product_id | Unique product 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-000000000008 | null | null | DATETIME | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-a308-000000000008 | 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-000000000008 | null | null | DECIMAL | null | null | null | null | null | 6 | 2 | null | null | null | null | null | 00000000-demo-ecom-a308-000000000007 | refund_amount | Refund amount for this item | 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-000000000008 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a308-000000000006 | condition | Item condition on return | 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-000000000008 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a308-000000000005 | reason | Return reason for this item | 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-000000000008 | null | null | INTEGER | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a308-000000000004 | quantity | Quantity returned | 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-000000000008 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a308-000000000003 | order_item_id | Original order item 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-000000000008 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a308-000000000002 | return_id | Return 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-000000000008 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a308-000000000001 | return_item_id | Unique return 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-000000000007 | null | null | DATETIME | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-a307-000000000008 | updated_at | Item 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-000000000007 | null | null | DATETIME | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a307-000000000007 | added_at | Item added 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-000000000007 | null | null | DECIMAL | null | null | PRODUCT_PRICE | null | null | 5 | 2 | null | null | null | null | null | 00000000-demo-ecom-a307-000000000006 | unit_price | Unit price at add time | 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-000000000007 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a307-000000000005 | quantity | Quantity in cart | 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-000000000007 | null | null | STRING | null | null | UUID | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a307-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-000000000007 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a307-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-000000000007 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a307-000000000002 | cart_id | Cart 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-000000000007 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a307-000000000001 | cart_item_id | Unique cart 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-000000000006 | null | null | DATETIME | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000017 | 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-000000000006 | null | null | DATETIME | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000016 | 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-000000000006 | null | null | DATETIME | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000015 | captured_at | Capture 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-000000000006 | null | null | DATETIME | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000014 | authorized_at | Authorization 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-000000000006 | null | null | STRING | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000013 | failure_reason | Failure reason if 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-000000000006 | null | null | STRING | null | null | CREDIT_CARD_TYPE | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000012 | card_brand | Card brand used | 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-000000000006 | null | null | STRING | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000011 | card_last_four | Last 4 digits of card | 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-000000000006 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000010 | authorization_code | Authorization 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-000000000006 | null | null | STRING | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000009 | provider_transaction_id | Provider transaction 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-000000000006 | null | null | STRING | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000008 | provider | Payment provider (Stripe, PayPal, etc.) | 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-000000000006 | null | null | STRING | null | null | CURRENCY | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000007 | currency | Payment 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-000000000006 | null | null | DECIMAL | null | null | MONEY | null | null | 5 | 2 | null | null | null | null | null | 00000000-demo-ecom-a306-000000000006 | amount | Payment 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-000000000006 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000005 | status | Payment status (pending, authorized, captured, failed, refunded) | 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-000000000006 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000004 | payment_type | Payment type (card, paypal, bank, cod) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 |