recipick
Tables (9)
FavoriteRecipe
- favorite_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
- recipe_id — BIGINT — Foreign key → Recipe.recipe_id — NOT NULL
- created_at — DATETIME — NOT NULL
IngredientCategory
- category_id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT
- name — VARCHAR(50) — NOT NULL
IngredientMaster
- ingredient_id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Foreign key → IngredientCategory.category_id — NOT NULL
- name_ko — VARCHAR(50) — NOT NULL
- icon_url — VARCHAR(255)
- created_at — DATETIME — NOT NULL
Recipe
- recipe_id — BIGINT — Primary key — NOT NULL
- source — ENUM('SPOONACULAR', 'MFDS') — NOT NULL
- external_id — VARCHAR(255)
- title — VARCHAR(100) — NOT NULL
- image_url — VARCHAR(255)
- ready_minutes — INT
- difficulty — ENUM('EASY', 'NORMAL', 'HARD') — NOT NULL
- step_count — INT — NOT NULL
- instructions — JSON
- created_at — DATETIME — NOT NULL
RecipeIngredient
- recipe_ingredient_id — BIGINT — Primary key — NOT NULL
- recipe_id — BIGINT — Foreign key → Recipe.recipe_id — NOT NULL
- ingredient_id — BIGINT — Foreign key → IngredientMaster.ingredient_id — NOT NULL
- ingredient_name — VARCHAR(50) — NOT NULL
- is_optional — BOOLEAN — NOT NULL
RecipeLog
- recipe_log_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
- recipe_id — BIGINT — Foreign key → Recipe.recipe_id — NOT NULL
- cooked_at — DATE — NOT NULL
- rating — INT — NOT NULL
- memo — TEXT
- image_url — VARCHAR(255)
- created_at — DATETIME — NOT NULL
UserIngredient
- user_ingredient_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
- ingredient_id — BIGINT — Foreign key → IngredientMaster.ingredient_id — NOT NULL
- expire_at — DATE
- is_consumed — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
UserProfile
- user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
- cooking_level — ENUM('EASY','NORMAL','HARD') — NOT NULL
- allergies — JSON
- banned_ingredients — JSON
- updated_at — DATETIME — NOT NULL
Users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- provider — ENUM('LOCAL','GOOGLE','KAKAO','NAVER') — NOT NULL
- provider_id — VARCHAR(255)
- password — VARCHAR(255)
- created_at — DATETIME — NOT NULL