Data model

"SHOP_CLAIM_USAGE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount": FLOAT 
  "app_id": VARCHAR(255) 
  "app_user_id": VARCHAR(255) 
  "prescription_id": TEXT 
  "status": VARCHAR(255) 
  "transaction_id": TEXT 
  "type": VARCHAR(255) 
}
"SHOP_TESTIMONIAL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "alan_answer": TEXT 
  "alan_answer_date": DATE 
  "app_id": VARCHAR(255) 
  "app_user_id": VARCHAR(255) 
  "external_order_id": VARCHAR(255) 
  "internal_comment": TEXT 
  "is_reviewed": BOOLEAN 
  "is_visible_from_product": BOOLEAN 
  "product_id": TEXT 
  "rating": INTEGER 
  "testimonial": TEXT 
  "user_name": VARCHAR(255) 
}
"SHOP_USER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "app_id": VARCHAR(255) 
  "app_user_id": VARCHAR(255) 
  "first_shop_wellbeing_visit_at": DATETIME 
  "last_shop_wellbeing_visit_at": DATETIME 
  "shop_notifications_disabled_at": DATETIME 
}
"SHOPIFY_ORDER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "app_id": VARCHAR(255) 
  "app_user_id": VARCHAR(255) 
  "shopify_order_id": VARCHAR(255) 
}
"TURING_SHOP_RECOMMENDED_PRODUCTS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "recommended_saleor_product_ids": ARRAY 
  "recommended_shopify_product_ids": ARRAY 
  "saleor_product_id": VARCHAR 
  "shopify_product_id": VARCHAR 
}

Hold "Alt" / "Option" to enable pan & zoom