P-project

Tables (11)

FOOD (Untitled4)

  • name (음식 명) — NOT NULL — Primary key — NOT NULL
  • category (음식 분류) — NOT NULL
  • quantity (양(g)) — NOT NULL
  • id (AUTO_INCREMENT) — NOT NULL
  • image (음식 이미지 URL)

FOOD_NUTRITION (Untitled5)

  • id (AUTO_INCREMENT) — NOT NULL — Primary key — NOT NULL
  • name (음식 참조 외래키) — NOT NULL — Foreign key → FOOD.name — NOT NULL
  • calorie (칼로리(kcal)) — NOT NULL
  • carb (탄수화물(g))
  • protein (단백질(g))
  • fat (지방(g))
  • sodium (나트륨(mg))
  • fiber (식이섬유(g))
  • sugar (당(g))
  • gi (gi 수치)

REPORT_LOG (Untitled8)

  • id (AUTO_INCREMENT) — NOT NULL — Primary key — NOT NULL
  • email (이메일) — NOT NULL — Foreign key → USER.email — NOT NULL
  • content (제보 내용) — NOT NULL
  • created_at (제보 시간) — NOT NULL
  • type (신고 종류) — NOT NULL
  • status (신고상태) — NOT NULL

USER (Untitled)

  • email (이메일) — NOT NULL — Primary key — NOT NULL
  • password (비밀번호) — NOT NULL
  • name (이름) — NOT NULL
  • gender (성별) — NOT NULL
  • birth (생일) — NOT NULL
  • height (키(ch)) — NOT NULL
  • weight (몸무게(kg)) — NOT NULL
  • created_at (계정을 만든 날짜) — NOT NULL
  • id (AUTO_INCREMENT) — NOT NULL

USER_ALLERGY (Untitled7)

  • id (AUTO_INCREMENT) — NOT NULL — Primary key — NOT NULL
  • email (이메일) — NOT NULL — Foreign key → USER.email — NOT NULL
  • allergy_name (알러지 이름)

USER_BLOOD_SUGAR_LOG (Untitled6)

  • id (AUTO_INCREMENT) — NOT NULL — Primary key — NOT NULL
  • email (사용자 이메일) — NOT NULL — Foreign key → USER.email — NOT NULL
  • bs (혈당) — NOT NULL
  • logged_at (기록 날짜) — NOT NULL
  • type (기록 타입(공복, 식전, 식후)) — NOT NULL

USER_DIABETES (Untitled10)

  • id (AUTO_INCREMENT) — NOT NULL — Primary key — NOT NULL
  • email (이메일) — NOT NULL — Foreign key → USER.email — NOT NULL
  • diabetes_type (당뇨병 유형) — NOT NULL
  • activity (하루 활동량) — NOT NULL
  • bs_goal (목표 혈당)

USER_FOOD_FAVORITE (음식 즐겨찾기)

  • id (AUTO_INCREMENT) — NOT NULL — Primary key — NOT NULL
  • email (사용자 이메일) — NOT NULL — Foreign key → USER.email — NOT NULL
  • food_name (음식 이름) — NOT NULL — Foreign key → FOOD.name — NOT NULL
  • calorie (음식 칼로리) — NOT NULL
  • created_at (즐겨찾기 추가 시간) — NOT NULL
  • image (음식 이미지)
  • gl (즐겨찾기 한 음식의 gl 수치)

USER_FOOD_HISTORY (Untitled3)

  • id (AUTO_INCREMENT) — NOT NULL — Primary key — NOT NULL
  • email (USER 참조 외래키) — NOT NULL — Foreign key → USER.email — NOT NULL
  • food_name (FOOD 참조 외래키) — NOT NULL — Foreign key → FOOD.name — NOT NULL
  • quantity (양(g)) — NOT NULL
  • eaten_at (먹은 날짜/시간) — NOT NULL
  • meal_type (식사 종류(아침/점심...)) — NOT NULL
  • image (먹은 사진)
  • gl (먹음 음식의 gl 수치)

USER_FOOD_PREFERENCE (Untitled2)

  • id (AUTO_INCREMENT) — NOT NULL — Primary key — NOT NULL
  • email (사용자 이메일) — NOT NULL — Foreign key → USER.email — NOT NULL
  • health_goal (건강 목표) — NOT NULL
  • preferred_food (선호 음식)
  • dispreferred_food (비선호음식)

USER_FOOD_RECOMMENDATION_LOG (Untitled9)

  • id (AUTO_INCREMENT) — NOT NULL — Primary key — NOT NULL
  • email (이메일) — NOT NULL — Foreign key → USER.email — NOT NULL
  • food_name (음식 명) — NOT NULL — Foreign key → FOOD.name — NOT NULL
  • created_at (추천 받은 날짜) — NOT NULL