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-enrg-ent3-000000000001 | null | null | STRING | null | null | UUID | null | null | 11 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000012 | grid_node_id | Grid connection node 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-enrg-ent3-000000000001 | null | null | DECIMAL | null | null | LONGITUDE | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000011 | longitude | GPS longitude | 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-enrg-ent3-000000000001 | null | null | DECIMAL | null | null | LATITUDE | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000010 | latitude | GPS latitude | 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-enrg-ent3-000000000001 | null | null | STRING | null | null | POSTAL_CODE | null | null | 8 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000009 | postal_code | Postal/ZIP 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-enrg-ent3-000000000001 | null | null | STRING | null | null | COUNTRY | null | null | 7 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000008 | country_code | Country 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-enrg-ent3-000000000001 | null | null | STRING | null | null | STATE | null | null | 6 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000007 | state | State/province | 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-enrg-ent3-000000000001 | null | null | STRING | null | null | CITY | null | null | 5 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000006 | city | City | 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-enrg-ent3-000000000001 | null | null | STRING | null | null | STREET_ADDRESS | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000005 | address | Physical 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-enrg-ent3-000000000001 | null | null | STRING | null | null | UUID | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000004 | consumer_category_id | Consumer 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-enrg-ent3-000000000001 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000003 | name | Consumer 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-enrg-ent3-000000000001 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000002 | consumer_code | Industry standard consumer 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-enrg-ent3-000000000001 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000001 | consumer_id | Unique consumer 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-000000000008 | null | null | DATETIME | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-a108-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-ent1-000000000008 | null | null | BOOLEAN | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a108-000000000007 | is_primary | Primary image 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-000000000008 | null | null | INTEGER | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a108-000000000006 | sort_order | Display sort 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-ent1-000000000008 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a108-000000000005 | alt_text | Image alt text for accessibility | 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-000000000008 | null | null | STRING | null | null | IMAGE_URL | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a108-000000000004 | url | Image URL | 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-000000000008 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a108-000000000003 | variant_id | Variant reference (optional) | 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-000000000008 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a108-000000000002 | 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-ent1-000000000008 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a108-000000000001 | image_id | Unique image 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-000000000007 | null | null | DATETIME | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-ecom-a107-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-ent1-000000000007 | null | null | DATETIME | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-a107-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-ent1-000000000007 | null | null | BOOLEAN | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-a107-000000000012 | is_active | Warehouse active 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-000000000007 | null | null | INTEGER | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-a107-000000000011 | capacity | Total storage capacity | 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-000000000007 | null | null | DECIMAL | null | null | LONGITUDE | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-a107-000000000010 | longitude | GPS longitude | 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-000000000007 | null | null | DECIMAL | null | null | LATITUDE | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-a107-000000000009 | latitude | GPS latitude | 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-000000000007 | null | null | STRING | null | null | COUNTRY | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-a107-000000000008 | country_code | Country 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-000000000007 | null | null | STRING | null | null | POSTAL_CODE | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a107-000000000007 | postal_code | Postal 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-000000000007 | null | null | STRING | null | null | STATE | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a107-000000000006 | state | State/province | 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-000000000007 | null | null | STRING | null | null | CITY | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a107-000000000005 | city | City | 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-000000000007 | null | null | STRING | null | null | STREET_ADDRESS | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a107-000000000004 | address_line_1 | Street 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-ent1-000000000007 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a107-000000000003 | name | Warehouse 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-000000000007 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a107-000000000002 | code | Warehouse 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-000000000007 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a107-000000000001 | warehouse_id | Unique warehouse 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-000000000006 | null | null | DATETIME | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-a106-000000000013 | 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-ent1-000000000006 | null | null | DATETIME | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-a106-000000000012 | 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-ent1-000000000006 | null | null | BOOLEAN | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-a106-000000000011 | is_active | Price active 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-000000000006 | null | null | DATETIME | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-a106-000000000010 | valid_to | Price valid to 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-ent1-000000000006 | null | null | DATETIME | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-a106-000000000009 | valid_from | Price valid from 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-ent1-000000000006 | null | null | STRING | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-a106-000000000008 | customer_group | Customer group for price tier | 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-000000000006 | null | null | INTEGER | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a106-000000000007 | min_quantity | Minimum quantity for price | 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-000000000006 | null | null | STRING | null | null | CURRENCY | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a106-000000000006 | 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-000000000006 | null | null | DECIMAL | null | null | PRODUCT_PRICE | null | null | 4 | 2 | null | null | null | null | null | 00000000-demo-ecom-a106-000000000005 | amount | Price 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-ent1-000000000006 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a106-000000000004 | price_type | Price type (regular, sale, wholesale) | 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-000000000006 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a106-000000000003 | variant_id | Variant reference (optional) | 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-000000000006 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a106-000000000002 | 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-ent1-000000000006 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a106-000000000001 | price_id | Unique price record 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-000000000005 | null | null | DATETIME | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-a105-000000000011 | 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-ent1-000000000005 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-a105-000000000010 | location_bin | Warehouse bin location | 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-000000000005 | null | null | DATE | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-a105-000000000009 | last_restock_date | Last inventory replenishment | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 |