DE_Final_Project

Tables (8)

DataWarehouse (Reicpe) (DB)

  • ID — INT — Primary key — NOT NULL
  • API_ID — INT — Foreign key → external.API_ID — NOT NULL
  • videoid — INT — Foreign key → external.videoid — NOT NULL
  • 요리이름 (food_name) — STRING — Foreign key → external.요리이름 — NOT NULL
  • recipeid — INT — Foreign key → external.recipeid — NOT NULL
  • 요리이미지 (image) — URL
  • 조회수 (views) — INT
  • 게시일 (created_date) — DATE
  • 레시피 (recipe_link) — URL
  • Field5
  • Field6
  • Field7
  • Field8
  • Field9
  • Field10
  • Field11
  • Field12
  • Field13
  • Field14
  • Field15

Rec_model (analytic)

  • ID — INT — Foreign key → DataWarehouse (Reicpe).ID — NOT NULL
  • recipeid — INT — Foreign key → DataWarehouse (Reicpe).recipeid — NOT NULL
  • 조회수 (views) — INT
  • 댓글수 (comments) — INT
  • 후기수 (reviews) — INT
  • 식재료 대분류 (sauce) — STRING
  • 식재료 중분류 (ingredient) — STRING
  • 식재료 정량 (unit) — STRING

external (video_recipe)

  • videoid — INT — Primary key — NOT NULL
  • 요리이름 (food_name) — STRING — Primary key — NOT NULL
  • 요리이미지 (thumbnails) — URL
  • 조회수 (views) — INT
  • 게시일 (uploaded_date) — DATE
  • 좋아요수 (likes) — INT
  • 댓글수 (comments) — INT

external (website_recipe)

  • recipeid — INT — Primary key — NOT NULL
  • 요리이름 (food_name) — STRING — Primary key — NOT NULL
  • 카테고리 고유 ID (category_id) — Foreign key → meta.카테고리 고유 ID — NOT NULL
  • 요리이미지 (food_img) — URL
  • 조회수 (views) — INT
  • 레시피용량 (serving) — STRING
  • 조리시간 (timer) — STRING
  • 난이도 (difficulty) — STRING
  • 식재료 대분류 (sauce) — STRING
  • 식재료 중분류 (ingredient) — STRING
  • 레시피 (recipe_link) — URL
  • 후기수 (reviews) — INT
  • 댓글수 (comments) — INT
  • 게시글작성일 (created_date) — DATE

external (식약처 API)

  • API_ID — INT — Primary key — NOT NULL
  • 요리이름 (food_name) — STIRNG — Primary key — NOT NULL
  • 재료정보 (ingredient) — STRING
  • 레시피용량 (serving) — STRING
  • category_id (category) — STRING
  • 조리방법 (category_2) — STRING
  • 요리 이미지 경로(소) (food_img_1) — URL
  • 요리 이미지 경로(대) (food_img_2) — URL
  • 만드는법_01 (recipe_01) — STRING
  • 만드는법_02 (recipe_02) — STRING
  • 만드는법_03 (recipe_03) — STRING
  • 만드는법_04 (recipe_04) — STRING
  • 만드는법_05 (recipe_05) — STRING
  • 만드는법_06 (recipe_06) — STRING
  • 만드는법_01_img (recipe_img_01) — URL
  • 만드는법_02_img (recipe_img_02) — URL
  • 만드는법_03_img (recipe_img_03) — URL
  • 만드는법_04_img (recipe_img_04) — URL
  • 만드는법_05_img (recipe_img_05) — URL
  • 만드는법_06_img (Field) — URL

meta (Food)

  • ID — INT — Foreign key → DataWarehouse (Reicpe).ID — NOT NULL
  • API_ID — INT — Foreign key → DataWarehouse (Reicpe).API_ID — NOT NULL
  • videoid — INT — Foreign key → DataWarehouse (Reicpe).videoid — NOT NULL
  • 요리이름 (food_name) — STRING — Foreign key → DataWarehouse (Reicpe).요리이름 — NOT NULL
  • recipeid — INT — Foreign key → DataWarehouse (Reicpe).recipeid — NOT NULL
  • ingredient_Id (Ingredient) — STRING
  • Unit (ingredient_unit) — STRING
  • id (ingredient_id) — INT — Foreign key → meta.id — NOT NULL

meta (Ingredients)

  • id (ingredient_id) — INT — Primary key — NOT NULL
  • 재료ID (ID) — INT — Foreign key → meta.ID — NOT NULL
  • API_ID — INT — Foreign key → meta.API_ID — NOT NULL
  • videoid — INT — Foreign key → meta.videoid — NOT NULL
  • 요리이름 (food_name) — STRING — Foreign key → meta.요리이름 — NOT NULL
  • recipeid — INT — Foreign key → meta.recipeid — NOT NULL

meta (Category)

  • 카테고리 고유 ID (category_id) — INT — Primary key — NOT NULL
  • 카테고리 종류별 (category_type_level) — STRING
  • 카테고리 상황별 (category_situation_level) — STRING
  • 카테고리 재료별 (category_ingredient_level) — STRING
  • 카테고리 방법별 (category_method_level) — STRING
  • 요리이름 (food_name) — STRING — Foreign key → DataWarehouse (Reicpe).요리이름 — NOT NULL
  • recipeid — INT — Foreign key → DataWarehouse (Reicpe).recipeid — NOT NULL