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 (활동량)