DB 링크 설계 링크: https://dbdiagram.io/d/67f915a64f7afba18440e4d5
API: 연관 테이블
users, social_loginsusers, social_loginsusers, social_loginsusers, social_loginsingredientsusers, ingredients, user_unavailable_ingredientsconditionsingredientsuser_daily_conditions, user_daily_ingredientsrecommendation_result_caches, recommendation_result_recipes
유저 입력 수집: user_daily_conditions, user_daily_ingredients
캐시 키 생성
예시
const key = sha256(
`condition:${condition_id}|ingredients:${ingredientIds.sort().join(',')}|slot:${timeSlot}`
);
캐시 키 존재 여부 확인
SELECT id FROM recommendation_result_caches
WHERE cache_key = :key
LIMIT 1;
존재하면 반환
SELECT recipe_id
FROM recommendation_result_recipes
WHERE recommendation_result_cache_id = :id
ORDER BY order_num ASC;
존재하지 않으면,
recommendation_result_cache에 데이터 추가recommendation_result_recipes에 추가