themightiestkpk

Tables (10)

current_grocery

  • autoincrement (curr_grocery_id) — int — Primary key — NOT NULL
  • fridge number (fridge_number) — varchar(255) — Foreign key → refrigerator.fridge number — NOT NULL
  • name of the grocery (grocery) — varchar(255)
  • how many? (how_many) — int
  • date (grocery_date) — datetime
  • 1 = image / 2 = by myself (input_type) — int

current_recipe

  • autoincrement (curr_recipe_id) — int — Primary key — NOT NULL
  • fridge number (fridge_number) — varchar(255) — Foreign key → refrigerator.fridge number — NOT NULL
  • name of the recipe (recipe) — varchar(255)
  • ingredients (ingredient) — varchar(255)
  • name of the ingredient (ingredient_name) — varchar(255)
  • seasonings (seasoning) — varchar(255)
  • name of the seasoning (seasoning_name) — varchar(255)
  • how to cook it (howto) — varchar(255)
  • what for? (for_what) — varchar(255)
  • views in the website (views) — int
  • url of the image (img_url) — varchar(255)
  • number of the recipe (recipe_num) — int

fav_recipe

  • autoincrement (curr_recipe_id) — int — Primary key — NOT NULL
  • fridge number (fridge_number) — varchar(255) — Foreign key → current_recipe.fridge number — NOT NULL
  • autoincrement (user_id) — int — Foreign key → user_info.autoincrement — NOT NULL

follower

  • autoincrement (follower_id) — int — Primary key — NOT NULL
  • autoincrement (user_id) — int — Foreign key → user_info.autoincrement — NOT NULL
  • who am i following (following_id) — varchar(255)
  • photo checked (photo_checked) — boolean

photo

  • autoincrement (photo_id) — int — Primary key — NOT NULL
  • fridge number (fridge_number) — varchar(255) — Foreign key → refrigerator.fridge number — NOT NULL
  • image url (url) — varchar(255)
  • photo date and time (photo_date) — datetime

refrigerator (refridgerator)

  • fridge number (fridge_number) — varchar(255) — Primary key — NOT NULL
  • autoincrement (user_id) — int — Foreign key → user_info.autoincrement — NOT NULL
  • manufactured date (fridge_date) — date
  • motion sensor on/of (motion_onoff) — int
  • for how long? (motion_timegap) — int

sensor

  • autoincrement (sensor_id) — int — Primary key — NOT NULL
  • fridge number (fridge_number) — varchar(255) — Foreign key → refrigerator.fridge number — NOT NULL
  • sensor name (sensor_name) — varchar(255)
  • sensor value (sensor_value) — int
  • sensed date and time (reg_date) — datetime

user_info

  • autoincrement (user_id) — int — Primary key — NOT NULL
  • age — int
  • 1male 2female (sex) — int
  • login email (email) — varchar(255)
  • user name (user_name) — varchar(255)
  • password — varchar(255)
  • guardian name (guardian_name) — varchar(255)
  • guardian phone number (guardian_phone) — varchar(255)
  • what is your purpose (for_what_personal) — varchar(255)
  • Field

whole_grocery

  • autoincrement (whole_grocery_id) — int — Primary key — NOT NULL
  • name of the grocery (whole_grocery) — varchar(255)

whole_recipe

  • autoincrement (whole_recipe_id) — int — Primary key — NOT NULL
  • recipe (whole_recipe) — varchar(255)
  • ingredients (whole_ingredient) — varchar(255)
  • name of the ingredients (whole_ingredient_name) — varchar(255)
  • seasonings (whole_seasoning) — varchar(255)
  • how to cook it (whole_howto) — varchar(255)
  • what for? (whole_for_what) — varchar(255)
  • views in the website (whole_views) — int
  • url of the image (whole_img_url) — varchar(255)
  • number of the recipe (whole_recipe_num) — int