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