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