8team

Tables (7)

DAILY_NUTRIENT

  • 성별 (gender) — VARCHAR
  • 연령대 (age_group) — INT
  • 열량 (kcal) — FLOAT(7,2)
  • 탄수화물 (carbohydrate) — FLOAT(7,2)
  • 단백질 (protein) — FLOAT(7,2)
  • 지방 (fat) — FLOAT(7,2)

FEED

  • FEEDID (feed_id) — INT — Primary key — NOT NULL
  • UID (user_id) — INT — Foreign key → USER.UID — NOT NULL
  • 이미지키 (image_url) — VARCHAR
  • 식사시간 (meal_time) — VARCHAR
  • 날짜 (date) — DATE
  • 생성일자 (created_at) — DATE
  • 수정일자 (updated_at) — DATE
  • 공개여부 (open) — BOOL
  • Field (thumbnail) — VARCHAR

FEED_FOODS

  • FEEDID (feed_id) — INT — Foreign key → FEED.FEEDID — NOT NULL
  • 이미지 (image_url) — VARCHAR
  • 음식 (food_id) — INT
  • 무게 (weight) — FLOAT(7,2)

FOOD_INFO

  • FOODID (food_id) — INT — Primary key — NOT NULL
  • 음식 (name) — VARCHAR
  • 1인분 weight (weight) — FLOAT(7,2)
  • 열량 (kcal) — FLOAT(7,2)
  • 탄수화물 (carbohydrate) — FLOAT(7,2)
  • 단백질 (protein) — FLOAT(7,2)
  • 지방 (fat) — FLOAT(7,2)

LIKES

  • UID (user_id) — INT — Foreign key → USER.UID — NOT NULL
  • FEEDID (feed_id) — INT — Foreign key → FEED.FEEDID — NOT NULL

USER

  • UID (user_id) — INT — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR — NOT NULL
  • 암호화된비번 (password) — VARCHAR — NOT NULL
  • 성별 (gender) — VARCHAR — NOT NULL
  • 연령대 (age_group) — INT — NOT NULL
  • 닉네임 (nickname) — VARCHAR — NOT NULL
  • 생성일자 (created_at) — DATE — NOT NULL
  • 수정일자 (updated_at) — DATE
  • 삭제여부 (is_deleted) — BOOL
  • 목표 (goal) — VARCHAR

USER_DAILY_NUTRIENT

  • UID (user_id) — INT — Foreign key → USER.UID — NOT NULL
  • 열량 (kcal) — FLOAT(7,2)
  • 탄수화물 (carbohydrate) — FLOAT(7,2)
  • 단백질 (protein) — FLOAT(7,2)
  • 지방 (fat) — FLOAT(7,2)