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-000000000005 | null | null | INTEGER | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-a105-000000000008 | reorder_quantity | Standard reorder 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-ent1-000000000005 | null | null | INTEGER | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a105-000000000007 | reorder_point | Low stock threshold | 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-ent1-000000000005 | null | null | INTEGER | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a105-000000000006 | quantity_available | Available for sale | 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-ent1-000000000005 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a105-000000000005 | quantity_reserved | Reserved for pending 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-ent1-000000000005 | null | null | INTEGER | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a105-000000000004 | quantity_on_hand | Current stock quantity | 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-ent1-000000000005 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a105-000000000003 | warehouse_id | Warehouse location reference | 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-ent1-000000000005 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a105-000000000002 | variant_id | Product variant reference | 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-ent1-000000000005 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a105-000000000001 | inventory_id | Unique inventory record identifier | 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-ent1-000000000004 | null | null | DATETIME | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-ecom-a104-000000000015 | updated_at | Record last update timestamp | 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-ent1-000000000004 | null | null | DATETIME | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-ecom-a104-000000000014 | created_at | Record creation timestamp | 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-ent1-000000000004 | null | null | BOOLEAN | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-a104-000000000013 | is_active | Variant availability 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-ent1-000000000004 | null | null | BOOLEAN | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-a104-000000000012 | is_default | Default variant 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-ent1-000000000004 | null | null | STRING | null | null | IMAGE_URL | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-a104-000000000011 | image_url | Variant-specific image | 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-ent1-000000000004 | null | null | STRING | null | null | UPC | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-a104-000000000010 | barcode | Barcode/UPC 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-ent1-000000000004 | null | null | DECIMAL | null | null | null | null | null | 8 | 3 | null | null | null | null | null | 00000000-demo-ecom-a104-000000000009 | weight | Variant weight in kg | 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-ent1-000000000004 | null | null | DECIMAL | null | null | null | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-ecom-a104-000000000008 | price_adjustment | Price difference from base | 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-ent1-000000000004 | null | null | STRING | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a104-000000000007 | material | Variant material | 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-ent1-000000000004 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a104-000000000006 | size | Variant size | 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-ent1-000000000004 | null | null | STRING | null | null | COLOR | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a104-000000000005 | color | Variant color | 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-ent1-000000000004 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a104-000000000004 | name | Variant name/title | 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-ent1-000000000004 | null | null | STRING | null | null | SKU | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a104-000000000003 | sku | Variant SKU 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-ent1-000000000004 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a104-000000000002 | product_id | Parent product reference | 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-ent1-000000000004 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a104-000000000001 | variant_id | Unique variant identifier | 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-ent1-000000000003 | null | null | DATETIME | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-a103-000000000010 | updated_at | Record last update timestamp | 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-ent1-000000000003 | null | null | DATETIME | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-a103-000000000009 | created_at | Record creation timestamp | 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-ent1-000000000003 | null | null | BOOLEAN | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-a103-000000000008 | is_active | Brand availability 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-ent1-000000000003 | null | null | STRING | null | null | COUNTRY | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a103-000000000007 | country_of_origin | Brand country of origin | 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-ent1-000000000003 | null | null | STRING | null | null | URL | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a103-000000000006 | website_url | Brand website | 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-ent1-000000000003 | null | null | STRING | null | null | IMAGE_URL | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a103-000000000005 | logo_url | Brand logo image | 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-ent1-000000000003 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a103-000000000004 | description | Brand description | 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-ent1-000000000003 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a103-000000000003 | slug | URL-friendly brand identifier | 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-ent1-000000000003 | null | null | STRING | null | null | COMPANY_NAME | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a103-000000000002 | name | Brand 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-ent1-000000000003 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a103-000000000001 | brand_id | Unique brand identifier | 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-ent1-000000000002 | null | null | DATETIME | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000014 | updated_at | Record last update timestamp | 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-ent1-000000000002 | null | null | DATETIME | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000013 | created_at | Record creation timestamp | 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-ent1-000000000002 | null | null | STRING | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000012 | meta_description | SEO meta description | 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-ent1-000000000002 | null | null | STRING | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000011 | meta_title | SEO meta title | 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-ent1-000000000002 | null | null | BOOLEAN | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000010 | is_active | Category availability 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-ent1-000000000002 | null | null | INTEGER | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000009 | sort_order | Display sort 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-ent1-000000000002 | null | null | STRING | null | null | IMAGE_URL | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000008 | image_url | Category image | 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-ent1-000000000002 | null | null | STRING | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000007 | path | Full category path | 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-ent1-000000000002 | null | null | INTEGER | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000006 | level | Category depth 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-ent1-000000000002 | null | null | STRING | null | null | UUID | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000005 | parent_category_id | Parent category for hierarchy | 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-ent1-000000000002 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000004 | description | Category description | 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-ent1-000000000002 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000003 | slug | URL-friendly category identifier | 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-ent1-000000000002 | null | null | STRING | null | null | PRODUCT_CATEGORY | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000002 | name | Category 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-ent1-000000000002 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a102-000000000001 | category_id | Unique category identifier | 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-ent1-000000000001 | null | null | DATETIME | null | null | null | null | null | 22 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000023 | updated_at | Record last update timestamp | 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-ent1-000000000001 | null | null | DATETIME | null | null | null | null | null | 21 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000022 | created_at | Record creation timestamp | 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-ent1-000000000001 | null | null | STRING | null | null | null | null | null | 20 | null | null | null | null | null | null | 00000000-demo-ecom-a101-000000000021 | meta_description | SEO meta description | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 |