테이블test

테이블 (5)

board

  • num — int — 기본 키 — NOT NULL
  • title — varchar
  • contents — varchar
  • like — int

comment

  • chat_num — int — 기본 키 — NOT NULL
  • num — int — 외래 키 → board.num — NOT NULL
  • contents — varchar
  • like — int

commodity

  • num — int — 기본 키 — NOT NULL
  • name — varchar
  • carbohydrates — int
  • protein — int
  • lipid — int
  • kcal — int

member

  • id — varchar — 기본 키 — NOT NULL
  • 비밀번호 (password) — varchar — NOT NULL
  • 성별 (gender) — VARCHAR(255) — NOT NULL
  • age (나이) — int — NOT NULL
  • goals — VARCHAR(255) — NOT NULL

member_info

  • id — varchar — 외래 키 → member.id — NOT NULL
  • height — int — NOT NULL
  • Weight — int — NOT NULL