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