diet recommedation
Tables (5)
diet (식단 테이블)
- member_id (회원id) — NOT NULL — Primary key — NOT NULL
- date (날짜) — NOT NULL — Primary key — NOT NULL
- category (아,점,저) — NOT NULL — Primary key — NOT NULL
diet_composition (식단-구성 음식 중간 테이블)
- member_id (회원id) — NOT NULL — Primary key — NOT NULL
- date (날짜 PK) — NOT NULL — Primary key — NOT NULL
- category (아,점,저) — NOT NULL — Primary key — NOT NULL
- food_id (음식 PK) — NOT NULL — Primary key — NOT NULL
food (음식 테이블)
- food_id (음식 PK) — NOT NULL — Primary key — NOT NULL
- food_name (음식이름) — NOT NULL
- carbohydrate (탄수화물) — NOT NULL
- protain (단백질) — NOT NULL
- fat_amount (지방) — NOT NULL
- calories (칼로리) — NOT NULL
- quantity (섭취량) — NOT NULL
member (회원 테이블)
- member_id (회원id) — NOT NULL — Primary key — NOT NULL
- name (이름) — NOT NULL
- nickname (별명) — NOT NULL
- authority (권한) — NOT NULL
member_info (식단 생성에 필요한 개인정보)
- member_id (회원id) — NOT NULL — Foreign key → member.member_id — NOT NULL
- gender (성별(M, W))
- age (나이)
- height (키)
- weight (몸무게)
- activity_level (활동량)