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-phys-000000000002 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000001 | CUSTOMER_SK | Surrogate key | 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-000000000001 | null | null | BOOLEAN | null | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000018 | IS_CURRENT | Current record 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-phys-000000000001 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000017 | EFFECTIVE_TO | SCD2 effective to | 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-000000000001 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000016 | EFFECTIVE_FROM | SCD2 effective from | 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-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000015 | 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-phys-000000000001 | null | null | BOOLEAN | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000014 | 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-phys-000000000001 | null | null | BOOLEAN | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000013 | IS_ACTIVE | Product 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-phys-000000000001 | null | null | DECIMAL | null | null | null | null | null | 11 | 3 | null | null | null | null | null | 00000000-demo-ecom-p001-000000000012 | WEIGHT_KG | 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-phys-000000000001 | null | null | CHAR | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000011 | CURRENCY_CODE | 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-phys-000000000001 | null | null | DECIMAL | null | null | null | null | null | 9 | 2 | null | null | null | null | null | 00000000-demo-ecom-p001-000000000010 | CURRENT_PRICE | Current selling 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-phys-000000000001 | null | null | DECIMAL | null | null | null | null | null | 8 | 2 | null | null | null | null | null | 00000000-demo-ecom-p001-000000000009 | BASE_PRICE | Base 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-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000008 | BRAND_NAME | Brand name (denormalized) | 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-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000007 | CATEGORY_PATH | Full category path | 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-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000006 | CATEGORY_NAME | Product category (denormalized) | 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-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000005 | PRODUCT_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-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000004 | PRODUCT_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-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000003 | SKU | Stock keeping 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-phys-000000000001 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000002 | PRODUCT_BK | Business key (product_id) | 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-000000000001 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-p001-000000000001 | PRODUCT_SK | Surrogate key | 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-ent2-000000000006 | null | null | DATETIME | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a206-000000000007 | added_at | Date item was added | 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-ent2-000000000006 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a206-000000000006 | notes | Personal notes about the 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-ent2-000000000006 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a206-000000000005 | priority | Item priority ranking | 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-ent2-000000000006 | null | null | STRING | null | null | UUID | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a206-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-ent2-000000000006 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a206-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-ent2-000000000006 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a206-000000000002 | wishlist_id | Wishlist 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-ent2-000000000006 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a206-000000000001 | wishlist_item_id | Unique wishlist 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-ent2-000000000005 | null | null | DATETIME | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-a205-000000000012 | 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-ent2-000000000005 | null | null | DATETIME | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-a205-000000000011 | 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-ent2-000000000005 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-a205-000000000010 | status | Review status (pending, approved, 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-ent2-000000000005 | null | null | BOOLEAN | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-a205-000000000009 | is_verified_purchase | Verified purchase 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-ent2-000000000005 | null | null | INTEGER | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-a205-000000000008 | helpful_votes | Number of helpful votes | 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-ent2-000000000005 | null | null | STRING | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a205-000000000007 | body | Review text content | 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-ent2-000000000005 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a205-000000000006 | title | Review 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-ent2-000000000005 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a205-000000000005 | rating | Rating score (1-5) | 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-ent2-000000000005 | null | null | STRING | null | null | UUID | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a205-000000000004 | order_id | Order reference (verified purchase) | 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-ent2-000000000005 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a205-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-ent2-000000000005 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a205-000000000002 | 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-ent2-000000000005 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a205-000000000001 | review_id | Unique review 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-ent2-000000000004 | null | null | DATETIME | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-a204-000000000007 | 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-ent2-000000000004 | null | null | DATETIME | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-a204-000000000006 | 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-ent2-000000000004 | null | null | STRING | null | null | URL | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-a204-000000000005 | share_url | Shareable wishlist 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-ent2-000000000004 | null | null | BOOLEAN | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-a204-000000000004 | is_public | Wishlist visibility 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-ent2-000000000004 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-a204-000000000003 | name | Wishlist 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-ent2-000000000004 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-a204-000000000002 | 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-ent2-000000000004 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-a204-000000000001 | wishlist_id | Unique wishlist 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-ent2-000000000003 | null | null | DATETIME | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-a203-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-ent2-000000000003 | null | null | DATETIME | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-a203-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-ent2-000000000003 | null | null | STRING | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-a203-000000000011 | status | Payment method status (active, expired, deleted) | 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-ent2-000000000003 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-a203-000000000010 | provider_token | Payment provider token (tokenized) | 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-ent2-000000000003 | null | null | BOOLEAN | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-a203-000000000009 | is_default | Default payment method flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 |