과제

테이블 (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