opti-meal

Tables (6)

allergen_master (알레르기 유발 물질)

  • allergen_id — SERIAL
  • allergen_name — VARCHAR(50) — NOT NULL

food_allergens (식품별 알레르기 연결 테이블)

  • food_cd — VARCHAR(50) — Foreign key → food_master.food_cd
  • allergen_id — INT — Foreign key → allergen_master.allergen_id

food_master (식품 기본 정보)

  • food_cd — VARCHAR(50)
  • food_nm_kr — VARCHAR(255) — NOT NULL
  • db_grp_nm — VARCHAR(100)
  • food_cat1_nm — VARCHAR(100)
  • food_cat2_nm — VARCHAR(100)
  • food_cat3_nm — VARCHAR(100)
  • food_cat4_nm — VARCHAR(100)
  • food_ref_nm — VARCHAR(100)
  • origin_nm — VARCHAR(100)
  • maker_nm — VARCHAR(255)

food_nutrition_detail (미세 영양소 및 아미노산)

  • food_cd — VARCHAR(50) — Foreign key → food_master.food_cd
  • calcium_mg — DECIMAL(10, 2)
  • iron_mg — DECIMAL(10, 2)
  • vitamin_a_ug — DECIMAL(10, 2)
  • vitamin_c_mg — DECIMAL(10, 2)
  • lysine_mg — DECIMAL(10, 2)
  • methionine_mg — DECIMAL(10, 2)
  • valine_mg — DECIMAL(10, 2)

food_nutrition_main (필수 영양성분 정보)

  • food_cd — VARCHAR(50) — Foreign key → food_master.food_cd
  • serving_size — DECIMAL(10, 2)
  • kcal — DECIMAL(10, 2)
  • protein_g — DECIMAL(10, 2)
  • fat_g — DECIMAL(10, 2)
  • carb_g — DECIMAL(10, 2)
  • sugar_g — DECIMAL(10, 2)
  • sodium_mg — DECIMAL(10, 2)
  • cholesterol_mg — DECIMAL(10, 2)
  • trans_fat_g — DECIMAL(10, 2)

menu_recipe (조리 및 제공 정보)

  • recipe_id — SERIAL
  • menu_name — VARCHAR(255) — NOT NULL
  • cooking_method — TEXT
  • serving_amount — INT
  • serving_unit — VARCHAR(10)
  • food_cd — VARCHAR(50) — Foreign key → food_master.food_cd