TeamProject

Tables (4)

Untitled3 (bmicriteria)

  • Field (bmiId)
  • Field (gender)
  • Field (minAge)
  • Field (maxAge)
  • Field (underBmi)
  • Field (normalBmi)
  • Field (obeseBmi)
  • Field (severeBmi)

bmi

  • bmiNo — Primary key — NOT NULL
  • userPk — Foreign key → member.userPk — NOT NULL
  • Field (recordDate)
  • Field (bmiValue)
  • Field (height)
  • Field (weight)
  • Field (age)
  • Field (gender)

heat

  • userPk (heatId) — Primary key — NOT NULL
  • userPk — Foreign key → member.userPk — NOT NULL
  • temp
  • time
  • memo

member

  • userPk — Primary key — NOT NULL
  • age
  • gender
  • phonenumber
  • birth
  • created_at
  • kakao_id
  • never_id (naver_id)