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-000000000006 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000003 | payment_method_id | Saved payment method 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 | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000002 | order_id | 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-000000000006 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a306-000000000001 | payment_id | Unique payment 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-000000000005 | null | null | DATETIME | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000016 | 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-000000000005 | null | null | DATETIME | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000015 | 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-000000000005 | null | null | DATETIME | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000014 | refunded_at | Refund processed 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-000000000005 | null | null | DATETIME | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000013 | received_at | Return received 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-000000000005 | null | null | DATETIME | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000012 | approved_at | Return approval 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-000000000005 | null | null | DATETIME | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000011 | requested_at | Return request 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-000000000005 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000010 | return_tracking_number | Return shipment tracking | 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-000000000005 | null | null | STRING | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000009 | refund_method | Refund method (original, store_credit) | 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-000000000005 | null | null | DECIMAL | null | null | MONEY | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-ecom-a305-000000000008 | refund_amount | 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-ent3-000000000005 | null | null | STRING | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000007 | reason_details | Additional return details | 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-000000000005 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000006 | reason | Return reason 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-000000000005 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000005 | status | Return status (requested, approved, received, refunded, rejected) | 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-000000000005 | null | null | STRING | null | null | UUID | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000004 | 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-000000000005 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000003 | order_id | Original 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-000000000005 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000002 | return_number | Human-readable return 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-000000000005 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a305-000000000001 | return_id | Unique return 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-000000000004 | null | null | DATETIME | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-ecom-a304-000000000014 | 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-000000000004 | null | null | DATETIME | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-a304-000000000013 | 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-000000000004 | null | null | DATETIME | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-a304-000000000012 | delivered_at | Actual 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-000000000004 | null | null | DATETIME | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-a304-000000000011 | estimated_delivery_at | Estimated delivery 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-ent3-000000000004 | null | null | DATETIME | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-a304-000000000010 | shipped_at | Shipment dispatch 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-000000000004 | null | null | STRING | null | null | UUID | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-a304-000000000009 | warehouse_id | Origin warehouse 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-000000000004 | null | null | STRING | null | null | UUID | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-a304-000000000008 | shipping_address_id | Destination 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-000000000004 | null | null | DECIMAL | null | null | null | null | null | 6 | 3 | null | null | null | null | null | 00000000-demo-ecom-a304-000000000007 | weight | Package 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-ent3-000000000004 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a304-000000000006 | status | Shipment status (pending, shipped, in_transit, delivered) | 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-000000000004 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a304-000000000005 | shipping_method | Shipping method/service | 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-000000000004 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a304-000000000004 | carrier | Shipping carrier (UPS, FedEx, USPS) | 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-000000000004 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a304-000000000003 | tracking_number | Carrier tracking 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-000000000004 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a304-000000000002 | order_id | 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-000000000004 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a304-000000000001 | shipment_id | Unique shipment 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-000000000003 | null | null | DATETIME | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-a303-000000000013 | updated_at | Cart 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-000000000003 | null | null | DATETIME | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-a303-000000000012 | created_at | Cart 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-000000000003 | null | null | DATETIME | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-a303-000000000011 | abandoned_at | Cart abandonment 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-000000000003 | null | null | STRING | null | null | UUID | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-a303-000000000010 | converted_order_id | Order ID if cart was converted | 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-000000000003 | null | null | STRING | null | null | USER_AGENT | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-a303-000000000009 | 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-000000000003 | null | null | STRING | null | null | IP_ADDRESS | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-a303-000000000008 | 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-000000000003 | null | null | STRING | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a303-000000000007 | 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-000000000003 | null | null | DECIMAL | null | null | null | null | null | 5 | 2 | null | null | null | null | null | 00000000-demo-ecom-a303-000000000006 | subtotal | Cart subtotal | 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-000000000003 | null | null | STRING | null | null | CURRENCY | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a303-000000000005 | currency | Cart 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-000000000003 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a303-000000000004 | status | Cart status (active, abandoned, converted) | 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-000000000003 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a303-000000000003 | session_id | Session identifier for guest carts | 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-000000000003 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a303-000000000002 | customer_id | Customer reference (null for guest) | 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-000000000003 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a303-000000000001 | cart_id | Unique cart 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-000000000002 | null | null | DATETIME | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-ecom-a302-000000000014 | 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-000000000002 | null | null | DATETIME | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-a302-000000000013 | 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-000000000002 | null | null | STRING | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-a302-000000000012 | fulfillment_status | Item fulfillment status | 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 | 10 | 2 | null | null | null | null | null | 00000000-demo-ecom-a302-000000000011 | total_amount | Total line item amount | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 |