Java_관통프로젝트

테이블 (4)

food (Untitled3)

  • foodCode (Key) — String — 기본 키 — NOT NULL
  • foodName (Field) — String
  • category (Field2) — String
  • calorie (Field3) — double
  • carbohydrate (Field4) — double
  • protein (Field5) — double
  • fat (Field6) — double
  • natrium (Field7) — double

foodRecord (Untitled4)

  • record_id (Key) — int — 기본 키 — NOT NULL
  • Field

userInfo (Untitled)

  • USER_ID (Key) — int — 기본 키 — NOT NULL
  • id (Field) — String
  • pw (Field2) — String
  • enabled (Field3) — boolean

userProfile (Untitled2)

  • USER_ID (Key2) — int — 외래 키 → userInfo.USER_ID — NOT NULL
  • name (Field) — String
  • age (Field2) — int
  • gender (Field3) — String
  • height (Field4) — int
  • weight (Field5) — double
  • illness (Field6) — String