CREATE TABLE Ingredient
(
    ingredient_id INTEGER
            primary key,
    category      TEXT,
    name          TEXT,
    plural        TEXT
);
Ingredient
CREATE TABLE Recipe
(
    recipe_id  INTEGER
            primary key,
    title      TEXT,
    subtitle   TEXT,
    servings   INTEGER,
    yield_unit TEXT,
    prep_min   INTEGER,
    cook_min   INTEGER,
    stnd_min   INTEGER,
    source     TEXT,
    intro      TEXT,
    directions TEXT
);
Recipe
CREATE TABLE Nutrition
(
    recipe_id     INTEGER
            primary key,
    protein       REAL,
    carbo         REAL,
    alcohol       REAL,
    total_fat     REAL,
    sat_fat       REAL,
    cholestrl     REAL,
    sodium        REAL,
    iron          REAL,
    vitamin_c     REAL,
    vitamin_a     REAL,
    fiber         REAL,
    pcnt_cal_carb REAL,
    pcnt_cal_fat  REAL,
    pcnt_cal_prot REAL,
    calories      REAL,
    foreign key (recipe_id) references Recipe(recipe_id)
);
Nutrition
CREATE TABLE Quantity
(
    quantity_id   INTEGER
            primary key,
    recipe_id     INTEGER,
    ingredient_id INTEGER,
    max_qty       REAL,
    min_qty       REAL,
    unit          TEXT,
    preparation   TEXT,
    optional      TEXT,
    foreign key (recipe_id) references Recipe(recipe_id),
    foreign key (ingredient_id) references Ingredient(ingredient_id),
    foreign key (recipe_id) references Nutrition(recipe_id)
);
Quantity
original_column_name,column_name,column_description,data_format,value_description
quantity_id,quantity id,the unique identifier for the quantity,integer,
recipe_id,recipe id,the id of the recipe,integer,
ingredient_id,ingredient id,the id of the ingredient,integer,
max_qty,maximum quantity,the max quantity of the ingredient,real,
min_qty,minimum quantity,the min quantity of the ingredient,real,"commonsense evidence: If max_qty equals to min_qty, it means that the ingredient must be rationed. "
unit,,the unit of the ingredient,text,
preparation,,,text,commonsense evidence: 'No data' means the ingredient doesn't need preprocessing. 
optional,,whether the ingredient is optional ,text,
Quantity
original_column_name,column_name,column_description,data_format,value_description
ingredient_id,ingredient id,the unique identifier for the ingredient,integer,
category,,the category of the ingredient,text,
name,,the name of the ingredient,text,
plural,,the plural suffix of the ingredient,text,
Ingredient
original_column_name,column_name,column_description,data_format,value_description
recipe_id,recipe id,the id of the recipe,integer,
protein,,the protein content in the recipe,real,
carbo,,the carbo content in the recipe,real,
alcohol,,the alcohol content in the recipe,real,
total_fat,total fat,the total fat content in the recipe,real,commonsense evidence: higher --> higher possibility to gain weight
sat_fat,saturated fat,the saturated fat content in the recipe,real,commonsense evidence: unsaturated fat = total_fat - saturated fat
cholestrl,cholesterol,the cholesterol content in the recipe,real,
sodium,,the sodium content in the recipe,real,"commonsense evidence:
Salt/Sodium-Free - Less than 5 mg of sodium per serving
Very Low Sodium - 35 mg of sodium or less per serving
Low Sodium -140 mg of sodium or less per serving
Reduced Sodium - At least 25% less sodium than the regular product
Light in Sodium or Lightly Salted - At least 50% less sodium than the regular product
No-Salt-Added or Unsalted - No salt is added during processing - but these products may not be salt/sodium-free unless stated"
iron,,the iron content in the recipe,real,"commonsense evidence: if iron > 20mg, it will lead to  
 constipation 
 feeling sick 
 being sick 
 stomach pain 
question could mention any of functions listed before."
vitamin_c,vitamin c,the vitamin c content in the recipe,real,"commonsense evidence: Vitamin C, also known as ascorbic acid, if the VC is higher, it will:
 helping to protect cells and keeping them healthy 
 maintaining healthy skin, blood vessels, bones and cartilage 
 helping with wound healing 
question could mention any of functions listed before."
vitamin_a,vitamin a,the vitamin a content in the recipe,real,"commonsense evidence:
higher --> beneficial to 
 helping your body's natural defense against illness and infection (the immune system) work properly 
 helping vision in dim light 
 keeping skin and the lining of some parts of the body, such as the nose, healthy 
question could mention any of functions listed before."
fiber,,the fiber a content in the recipe,real,
pcnt_cal_carb,percentage calculation carbo,percentage of carbo in total nutrient composition,real,
pcnt_cal_fat,percentage calculation fat,percentage of fat in total nutrient composition,real,
pcnt_cal_prot,percentage calculation protein,percentage of protein in total nutrient composition,real,
calories,,the calories of the recipe,real,
Nutrition
original_column_name,column_name,column_description,data_format,value_description
recipe_id,recipe id,the unique identifier for the recipe,integer,
title,,the title of the recipe,text,
subtitle,,the subtitle of the recipe,text,
servings,,the number of people the recipe can serve,integer,
yield_unit,yield unit ,the unit of the yield for the recipe,text,
prep_min,preparation minute,the preparation minute of the recipe,integer,
cook_min,cooked minute,the cooked minute of the recipe,integer,
stnd_min,stand minute,the stand minute of the price,integer,"commonsense evidence: The stand minute stands for the time to take the dish away from the heat source. 
the total time of the recipe = prep_min + cook_min + stnd_min"
source,,the source of the recipe,text,
intro,introduction,the introduction of the recipe,text,
directions,,the directions of the recipe,text,
Recipe