all_data_types.json

{
   "core":{
      "id":"string",
      "active":"bool",
      "first_name":"string",
      "last_name":"string",
      "email":"string",
      "phone_number":"string",
      "date_created":"timestamp",
      "affinity_number":"int",
      "date_updated":"timestamp",
      "cipher":"string",
      "display_name":"string",
      "profile_pic":"string",
      "gender":"string",
      "zip":"string",
      "email_opt_out":"bool",
      "store_primary_wfm":"int",
      "store_primary_365":"int",
      "profile_pic_base_url":"string",
      "birth_year":"int",
      "birth_month":"int",
      "birth_day":"int",
      "email_hash":"string",
      "age":"int",
      "household_size":"string",
      "secondary_store_wfm":"int",
      "secondary_store_365":"int"
   },
   "preferences":{
      "365.food_choices":[
         {
            "bone_health":"bool"
         },
         {
            "fat_free":"bool"
         },
         {
            "halal":"bool"
         },
         {
            "heart_healthy":"bool"
         },
         {
            "high_fiber":"bool"
         },
         {
            "lower_cholesterol":"bool"
         },
         {
            "low_fat":"bool"
         },
         {
            "low_sodium":"bool"
         },
         {
            "paleo":"bool"
         },
         {
            "raw":"bool"
         }
      ],
      "365.lifestyle_choices":[
         {
            "beer_and_wine_afficianado":"bool"
         },
         {
            "best_for_the_planet":"bool"
         },
         {
            "cookie_for_one_or_two":"bool"
         },
         {
            "cooking_for_a_new_diet":"bool"
         },
         {
            "cooking_made_easy":"bool"
         },
         {
            "health_and_fitness":"bool"
         },
         {
            "kids_and_family":"bool"
         },
         {
            "love_to_entertain":"bool"
         },
         {
            "on_the_go":"bool"
         }
      ],
      "email":[
         {
            "newsletter_opt_in":"bool"
         }
      ],
      "esp.food_choices":[
         {
            "beer":"bool"
         },
         {
            "meat":"bool"
         },
         {
            "seafood":"bool"
         },
         {
            "wine":"bool"
         }
      ],
      "esp.lifestyle_choices":[
         {
            "career":"bool"
         },
         {
            "children_parenting":"bool"
         },
         {
            "green_living":"bool"
         },
         {
            "pets":"bool"
         }
      ],
      "food_choices":[
         {
            "cheese":"bool"
         },
         {
            "gluten_free":"bool"
         },
         {
            "health_wellness":"bool"
         },
         {
            "kosher":"bool"
         },
         {
            "no_added_sugar":"bool"
         },
         {
            "non_gmo":"bool"
         },
         {
            "organic":"bool"
         },
         {
            "vegan":"bool"
         },
         {
            "vegetarian":"bool"
         }
      ],
      "lifestyle_choices":[
         {
            "healthy_eating":"bool"
         }
      ]
   },
   "program":{
      "365":[
         {
            "365_affinity":"bool"
         },
         {
            "365_insight":"bool"
         }
      ],
      "esp":[
         {
            "estore_optin":"bool"
         },
         {
            "store_specials":"bool"
         },
         {
            "recipes":"bool"
         },
         {
            "newsletter":"bool"
         },
         {
            "health_wellness":"bool"
         },
         {
            "new_products":"bool"
         },
         {
            "online_ordering":"bool"
         },
         {
            "body_beauty":"bool"
         },
         {
            "whole_cities_opt_in":"bool"
         },
         {
            "whole_planet_opt_in":"bool"
         },
         {
            "whole_kids_opt_in":"bool"
         },
         {
            "wfm_affinity_rewards_opt_in":"bool"
         },
         {
            "365_email_opt_in":"bool"
         },
         {
            "wfm_whole_body_benefits_opt_in":"bool"
         },
         {
            "instacart_optin":"bool"
         },
         {
            "e2_optin":"bool"
         },
         {
            "e2_date":"date"
         },
         {
            "gift_card":"bool"
         },
         {
            "local_store_news":"bool"
         }
      ],
      "wfm_mobile_app":[
         {
            "tcs_version":"string"
         },
         {
            "tcs_date_acceptance":"date"
         },
         {
            "current_privacy_policy_version":"string"
         },
         {
            "current_privacy_policy_date_acceptance":"date"
         },
         {
            "terms_conditions":"string"
         },
         {
            "ic_delivery":"bool"
         },
         {
            "ic_zip":"string"
         },
         {
            "ios":[
               {
                  "push":"bool"
               },
               {
                  "guided_tour":"bool"
               }
            ]
         }
      ]
   }
}

## PREFERENCES SECTION

#These need to be fields in the profile table
[core.generic]
    age: int
    household_size
    kids #Leaving this one out for now, sent out an email to rajat, ashmi and jeb to clarify on feb 15 2015
    secondary_store_wfm
    secondary_store_365

[preferences.food_choices]
    cheese
    health_wellness
    gluten_free
    vegetarian
    vegan
    non_gmo
    organic
    kosher
    no_added_sugar

[preferences.lifestyle_choices]
    healthy_eating


[preferences.esp.food_choices]
    meat
    seafood
    beer
    wine

[preferences.esp.lifestyle_choices]
    green_living
    children_parenting
    pets
    career


[preferences.365.food_choices]
    paleo
    low_fat
    fat_free
    high_fiber
    raw
    halal
    heart_healthy
    bone_health
    low_sodium
    lower_cholesterol

[preferences.365.lifestyle_choices]
    best_for_the_planet
    kids_and_family
    health_and_fitness
    on_the_go
    love_to_entertain
    cooking_made_easy
    cooking_for_a_new_diet
    beer_and_wine_afficianado
    cookie_for_one_or_two

    cooking_knowlege: beginner, comfortable, advanced  #Asked if we can defer this

# A program called esp
[esp]
    whole_cities_opt_in
    whole_planet_opt_in
    whole_kids_opt_in
    wfm_affinity_rewards_opt_in
    365_email_opt_in
    wfm_whole_body_benefits_opt_in
    instacart_optin
    estore_optin
    e2_optin
    e2_date
    gift_card
    local_store_news
    store_specials
    recipes
    newsletter
    health_wellness
    new_products
    online_ordering
    body_beauty


# Program called 365
[365]
    365_affinity
    365_insight