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