과제
테이블 (6)
CameraRecognition
- RecognitionID (Key) — NUMBER — 기본 키 — NOT NULL
- IngredientID — NUMBER
- RecognitionDate — DATE
Ingredients
- IngredientID (Key) — NUMBER — 기본 키 — NOT NULL
- Name — VARCHAR2(100) — NOT NULL
- Category — VARCHAR2(50)
- RecognitionID (Key2) — NUMBER — 외래 키 → CameraRecognition.RecognitionID — NOT NULL
- RecipeIngredientID (Key3) — NUMBER — 외래 키 → RecipeIngredients.RecipeIngredientID — NOT NULL
RAGResults
- ResultID (Key) — NUMBER — 기본 키 — NOT NULL
- RecipeID — NUMBER
- MatchingScore — NUMBER(3,2)
- GeneratedDate — DATE
RecipeIngredients
- RecipeIngredientID (Key) — NUMBER — 기본 키 — NOT NULL
- RecipeID — NUMBER
- IngredientID — NUMBER
Recipes
- RecipeID (Key) — NUMBER — 기본 키 — NOT NULL
- RecipeName — VARCHAR2(200) — NOT NULL
- Description — VARCHAR2(1000)
- CookingTime — NUMBER
- CookingMethod — VARCHAR2(100)
- RecipeIngredientID (Key2) — NUMBER — 외래 키 → RecipeIngredients.RecipeIngredientID — NOT NULL
- ResultID (Key3) — NUMBER — 외래 키 → RAGResults.ResultID — NOT NULL
Users
- UserID (Key) — NUMBER — 기본 키 — NOT NULL
- Name — VARCHAR2(100) — NOT NULL
- Email — VARCHAR2(100) — NOT NULL
- Password — VARCHAR2(100) — NOT NULL