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