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