MyCurly

Tables (6)

Ingredient (재료)

  • id (Key) — Long — Primary key — NOT NULL
  • name (재료명) — String

Inventory (마켓컬리재고)

  • id (Key) — Long — Primary key — NOT NULL
  • name (이름) — String
  • price (가격) — int
  • deliveryMethod (배송 방식) — String
  • gram (중량) — int
  • link (상품링크) — String

PersonalRecipe (개인레시피)

  • id (Key) — Long — Primary key — NOT NULL
  • name (레시피명) — String
  • id (ProfileKey) — Long — Foreign key → Profile.id — NOT NULL

Profile (프로필)

  • id (Key) — Long — Primary key — NOT NULL
  • accountId (계정ID) — String
  • password (비밀번호) — String
  • nickName (닉네임) — String

RecipeIngredient (레시피에 들어가는 재료)

  • id (Key) — Primary key — NOT NULL
  • id (PersonalRecipeKey) — Long — Foreign key → PersonalRecipe.id — NOT NULL
  • id (StandardRecipeKey) — Long — Foreign key → standardRecipe.id — NOT NULL
  • id (IngredientKey) — Long — Foreign key → Ingredient.id — NOT NULL — NotNull

standardRecipe (정규레시피)

  • id (Key) — Long — Primary key — NOT NULL
  • name (레시피명) — String