Healthymeal_1.0

Tables (11)

daily_intake (영양소별 섭취량)

  • id (식별번호) — int — Primary key — NOT NULL
  • user_id (사용자명) — varchar(255) — Foreign key → user.id — NOT NULL
  • day (날짜) — date
  • energy_kcal (칼로리) — double
  • protein_g (단백질) — double
  • fat_g (지방) — double
  • carbohydrate_g (탄수화물) — double
  • sugars_g (당류) — double
  • cellulose_g (식이섬유) — double
  • sodium_mg (나트륨) — double
  • cholesterol_mg (콜레스테롤) — double
  • score (식생활점수) — score

diet_criterion (섭취권장량)

  • id (식별번호) — int — Primary key — NOT NULL
  • start_age (시작나이) — int
  • end_age (끝나이) — int
  • gender (성별) — char(1)
  • energy_kcal (칼로리) — float
  • protein_g (단백질) — float
  • fat_g (지방) — float
  • carbohydrate_g (탄수화물) — float
  • sugars_g (당류) — float
  • cellulose_g (식이섬유) — float
  • sodium_mg (나트륨) — float
  • cholesterol_mg (콜레스테롤) — float

diet_scoring_criterion (식생활점수 산출기준)

  • id (식별번호) — bigint — Primary key — NOT NULL
  • nutrient_name (영양소명) — varchar(255)
  • recommended_amount (권장섭취량) — double
  • mix_optimal_ratio (섭취량 임계최대비율) — double
  • min_optimal_ratio (섭취량 임계최소비율) — double
  • penalty_start_ratio_upper (점수차감 기준점 상단) — double
  • zero_score_ratio_upper (점수없음 기준점 상단) — double

food (식품)

  • id (식별번호) — bigint — Primary key — NOT NULL
  • name (식품명) — varchar(255)
  • major_category (대분류명) — varchar(255)
  • medium_category (중분류명) — varchar(255)
  • minor_category (소분류명) — varchar(255)
  • subcategory (세분류명) — varchar(255)
  • representative_food (대표식품명) — varchar(255)
  • nutri_ref_amt (영양소산출 기준중량) — varchar(5)
  • weight (식품중량) — varchar(255)
  • energy_kcal (칼로리) — double
  • protein_g (단백질) — double
  • fat_g (지방) — double
  • carbohydrate_g (탄수화물) — double
  • sugars_g (당류) — double
  • cellulose_g (식이섬유) — double
  • sodium_mg (나트륨) — double
  • cholesterol_mg (콜레스테롤) — double

food_cluster (식품클러스터)

  • cluter_num (클러스터번호) — bigint — Primary key — NOT NULL
  • description (클러스터특성) — varchar(255)
  • high_nutrients (최대 영양소) — varchar(255)
  • low_nutrients (최소 영양소) — varchar(255)
  • nutri_vector (영양소벡터) — varchar(255)

food_recommendation (식품추천)

  • id (식별번호) — bigint — Primary key — NOT NULL
  • cluter_num (클러스터번호) — bigint — Foreign key → food_cluster.cluter_num — NOT NULL
  • name (이름) — varchar(255)
  • category (카테고리) — varchar(255)
  • energy_kcal (칼로리) — double
  • protein_g (단백질) — double
  • fat_g (지방) — double
  • carbohydrate_g (탄수화물) — double
  • sugars_g (당류) — double
  • sodium_mg (나트륨) — double
  • cholesterol_mg (콜레스테롤) — double

meal_info (식단기록)

  • id (식별번호) — bigint — Primary key — NOT NULL
  • user_id (사용자명) — varchar(255) — Foreign key → user.id — NOT NULL
  • img_path (이미지경로) — varchar(255)
  • created_at (생성일시) — datetime
  • last_modified_at (수정일시) — datetime
  • diary (일기) — tinytext

meal_info_food_link (식단기록과 식품 조인테이블)

  • meal_info_id (식단기록 식별번호) — bigint — Foreign key → meal_info.id — NOT NULL
  • food_id (식품 식별번호) — bigint — Foreign key → food.id — NOT NULL
  • intake_amount (섭취량) — float

nutri_weight (영양소별 섭취량가중치)

  • id (식별번호) — int — Primary key — NOT NULL
  • user_id (사용자명) — varchar(255) — Foreign key → user.id — NOT NULL
  • nutrient (영양소명) — varchar(255)
  • weight (가중치) — float

user (사용자)

  • id (사용자명) — varchar(255) — Primary key — NOT NULL
  • hashed_password (패스워드) — varchar(255)
  • birthday (생년월일) — date
  • gender (성별) — char(1)
  • critweight (섭취권장량 가중치) — varchar(255)

user_food_link (사용자와 식품 조인테이블)

  • user_id (사용자명) — varchar(255) — Foreign key → user.id — NOT NULL
  • food_id (식품 식별번호) — bigint — Foreign key → food.id — NOT NULL