Schema · Entity relationship diagram
ShopMy tables and relationships
Every creator-attributed ShopMy order: order and commission amounts in USD, creator, link, code, click-to-order time, customer status and ship-to country, kept up to date as orders change.
ConnectPaste an API key
Default schema
shopmySource API docsdocs.shopmy.us
DestinationsAmazon Redshift, Google BigQuery, Snowflake, PostgreSQL, Amazon S3
- One row per creator-attributed order (or per order × SKU when reporting by SKU), updated as orders change.
Primary keyForeign keyReferencesJoins on (not a key)
Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.
Table reference
1 tables · click a table for its columnsorder_report23 columnsshow in diagram
Primary key: _jsdata_key
| Column | Type | Key | Description |
|---|---|---|---|
| _jsdata_keyPrimary key. | varchar(32) | PK | Primary key. |
| order_id | varchar(256) | ||
| sku | varchar(256) | ||
| transaction_date | timestamp | ||
| record_updated_date | timestamp | ||
| click_date | timestamp | ||
| order_amount_usd | decimal(18,2) | ||
| commission_amount_usd | decimal(18,2) | ||
| gross_sales | decimal(18,2) | ||
| number_of_items | integer | ||
| order_status | varchar(256) | ||
| customer_status | varchar(256) | ||
| creator_name | varchar(1024) | ||
| creator_shopmy_url | varchar(2048) | ||
| pin_link_url | varchar(4096) | ||
| domain | varchar(1024) | ||
| code | varchar(1024) | ||
| currency | varchar(16) | ||
| click_order_delta_hours | decimal(18,2) | ||
| ship_to_country | varchar(256) | ||
| social_accounts | varchar(65535) | ||
| report_by_sku | boolean | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |