c
Tables (7)
Untitled (Recipe)
- Key (ID) — NOT NULL — Primary key — NOT NULL
- Field (title) — NOT NULL
- Field (scrap) — NOT NULL
- Field (time) — NOT NULL
- Field (calories) — NULL
- Field (size) — NULL
- Field (difiiculty) — NULL
- Field (ingredient) — NULL
- Field (test) — NULL
- Key (userID) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- ID (userID2) — NOT NULL — Foreign key → Untitled.ID — NOT NULL
- Key (userID3) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- ID (userID22) — NOT NULL — Foreign key → Untitled.ID — NOT NULL
- ID (userID4) — NOT NULL — Foreign key → Untitled.ID — NOT NULL
Untitled (refriger)
- ID — NOT NULL — Foreign key → User.ID — NOT NULL
- Field (떡/곡류) — NULL
- Field (가공식품) — NULL
- Field (계란/유제품) — NULL
- Field (콩/묵/두부) — NULL
- Field (채소류) — NULL
- Field (육류) — NULL
- Field (과일류) — NULL
- Field (조미료/양념/육수) — NULL
- Field (빵/면/만두류) — NULL
- Field (수산/건어물) — NULL
- Field (기름/향신료/가루) — NULL
- Field (초콜릿/과자/견과류) — NULL
- Field (음료/주류) — NULL
Untitled (scrapRecipesId)
- Key (userID) — NOT NULL — Primary key — NOT NULL
- ID (userID2) — NOT NULL — Foreign key → User.ID — NOT NULL
- Field (Recipe) — NULL
Untitled (likeRecipesId)
- Key (userID) — NOT NULL — Primary key — NOT NULL
- ID (userID2) — NOT NULL — Foreign key → User.ID — NOT NULL
- Field (Recipe) — NULL
Untitled (historyRecipesId)
- ID (userID) — NOT NULL — Foreign key → User.ID — NOT NULL
- Field (Recipe) — NULL
Untitled (preferenceVector)
- ID (userID) — NOT NULL — Foreign key → User.ID — NOT NULL
- Field (vectors) — NOT NULL
User (user)
- ID (userID) — NOT NULL — Primary key — NOT NULL
- 선택한 레시피 갯수 (recipeCount) — NULL
- 닉네임 (nickname) — NULL
- 상태메시지 (statusMessage) — NULL
- 사진 (photo) — NULL
- 싫어하는 재료 (dislikeIngredient) — NULL
- 스크랩한 레시피 (scrapRecipesId) — NULL
- 좋아하는 레시피 (likeRecipesId) — NULL
- 선택했던 과거 레시피 (historyRecipesId) — NULL
- 냉장고 (refriger) — NULL
- 선호도 벡터 (preferenceVector) — NULL
- 소셜로그인 토큰 (token) — NOT NULL
- 플랫폼 (platform) — NOT NULL