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