test

Tables (7)

allergy_info (Untitled8)

  • id — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL

favorite (Untitled7)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • 취향 (favor) — varchar

ingredient (Untitled6)

  • id — Primary key — NOT NULL
  • 재료명 (name) — varchar
  • 권장유효기간 (expiration_date)

ingredient_type (Untitled4)

  • id — Primary key — NOT NULL
  • 대분류 (main) — varchar

my_ingredient (Untitled5)

  • user_id — int — Foreign key → user.id — NOT NULL
  • ingredient_id — Foreign key → ingredient.id — NOT NULL
  • 날짜 (date)
  • 재료양 (amount)

user (Untitled)

  • id — int — Primary key — NOT NULL
  • 이름 (name) — varchar
  • 전화번호 (phone) — varchar

user_service (Untitled2)

  • id — Primary key — NOT NULL
  • user_id — Foreign key → user.id — NOT NULL
  • 소셜로그인타입 (type) — int — 001 : kakao 002 : naver 003 : google
  • 이메일 (email) — varchar
  • 비밀번호 (password) — varchar
  • 소셜정보 (socialInfo) — varchar — NOT NULL