rb1217
Tables (10)
food
- id — int(11) — Primary key — NOT NULL
- type — int(11) — Foreign key → food_type.id
- name — varchar(50) — NOT NULL
- serving — int(11) — NOT NULL
- description — varchar(2000)
- image — varchar(200)
- recipe — varchar(200)
- source — varchar(100)
food_ingredient
- food_id — int(11) — Foreign key → food.id
- ingredient_id — int(11) — Foreign key → ingredient.id
- ingredient_amount — float(11,0) — NOT NULL
food_type
- id — int(11) — Primary key — NOT NULL
- name — varchar(40) — NOT NULL
ingredient
- id — int(11) — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- name — varchar(50) — NOT NULL
- ingredient_type_id — int(11) — Foreign key → ingredient_type.id
- ingredient_unit_id — int(11)
ingredient_nutrient
- ingredient_id — int(11) — Foreign key → ingredient.id
- nutrient_id — int(11) — Foreign key → nutrient.id
- nutrient_amount — float — NOT NULL
ingredient_type
- id — int(11) — Primary key — NOT NULL
- name — varchar(25) — NOT NULL
nutrient
- id — int(11) — Primary key — NOT NULL
- name_kor — varchar(20) — NOT NULL
- name_eng — varchar(100) — NOT NULL
- unit — varchar(10) — NOT NULL
- nutrient_type_id — int(11) — Foreign key → nutrient_type.id
nutrient_type
- id — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
recommended_daily_amount
- standard_gender_age_id — int(11) — Foreign key → standard_gender_age.id
- nutrient_id — int(11) — Foreign key → nutrient.id
- amount — int(11) — NOT NULL
standard_gender_age
- id — int(11) — Primary key — NOT NULL
- gender — varchar(10) — NOT NULL
- age — varchar(20) — NOT NULL