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