JH

Tables (3)

LikeFood (선호음식)

  • id — Long — Primary key — NOT NULL
  • 음식 (Field) — varchar

User (회원)

  • id — Long — Primary key — NOT NULL
  • name (이름) — varchar(20)
  • birth (생년월일) — DATE
  • address (주소) — varchar(30)
  • detailAddress (세부주소) — varchar(30)
  • checklocation (위치정보제공) — enum
  • Field2

userlikefood (회원선호음식)

  • id — Long — Primary key — NOT NULL
  • user_id (회원ID) — Long — Foreign key → User.id — NOT NULL
  • likefood_id (선호음식ID) — Long — Foreign key → LikeFood.id — NOT NULL