Recipe
Tables (12)
Category_country (Untitled7)
- name (Key) — varchar(100) — Primary key — NOT NULL — 음식 카테고리 국가
Category_day (Untitled4)
- name (Key) — varchar(100) — Primary key — NOT NULL — 상황별 카테고리 1 (휴일)
- recipe_id (Key2) — int — Foreign key → Recipe.recipe_id — NOT NULL
Category_emotion (Untitled8)
- emotion (Key) — varchar(100) — Primary key — NOT NULL — 상황별 카테고리 감정
Category_genre1 (Untitled)
- name (Key) — varchar(100) — Primary key — NOT NULL — 음식 카테고리 1(장르)
Category_genre2 (Untitled5)
- name (Key) — varchar(100) — Primary key — NOT NULL — 음식 카테고리2(장르)
Category_health (Untitled3)
- name (Key) — varchar(100) — Primary key — NOT NULL — 상황별 카테고리(신체)
- recipe_id (Key2) — int — Foreign key → Recipe.recipe_id — NOT NULL
Category_mealType (Untitled6)
- name (Key) — varchar(100) — Primary key — NOT NULL — 상황별 카테고리(특이섭취)
Cookware (Untitled9)
- name (Key) — varchar(100) — Primary key — NOT NULL — 조리도구
- recipe_id (Key2) — int — Foreign key → Recipe.recipe_id — NOT NULL
Ingrdient (Untitled10)
- name (Key) — varchar(100) — Primary key — NOT NULL — 재료
- recipe_id (Key2) — int — Foreign key → Recipe.recipe_id — NOT NULL
Recipe
- recipe_id (Key) — int — Primary key — NOT NULL
- name — varchar — NOT NULL — 레시피 이름
- difficulty (Field) — int — 난이도
- time_spend_min (Field2) — int — 소요시간(분)
- unit (Field3) — int — 인분
- name (Key2) — varchar(100) — Foreign key → Category_genre1.name — NOT NULL — 음식 카테고리 1(장르)
- name (Key3) — varchar(100) — Foreign key → Category_genre2.name — NOT NULL — 음식 카테고리2(장르)
- name (Key4) — varchar(100) — Foreign key → Category_country.name — NOT NULL — 음식 카테고리 국가
- name (Key5) — varchar(100) — Foreign key → Category_day.name — NOT NULL — 상황별 카테고리 1 (휴일)
- emotion (Key6) — varchar(100) — Foreign key → Category_emotion.emotion — NOT NULL — 상황별 카테고리 감정
- name (Key7) — varchar(100) — Foreign key → Category_mealType.name — NOT NULL — 상황별 카테고리(특이섭취)
- name (Key8) — varchar(100) — Foreign key → Category_health.name — NOT NULL — 상황별 카테고리(신체)
- name (Key9) — varchar(100) — Foreign key → Taste.name — NOT NULL — 맛
- name (Key10) — varchar(100) — Foreign key → Cookware.name — NOT NULL — 조리도구
- name (Key11) — varchar(100) — Foreign key → Ingrdient.name — NOT NULL — 재료
Recipe Process (Untitled2)
- id (Key) — int — Primary key — NOT NULL — 키 값
- picture — text — 사진
- description (Field) — text — 설명
- recipe_id (Key2) — int — Foreign key → Recipe.recipe_id — NOT NULL
Taste (Untitled11)
- name (Key) — varchar(100) — Primary key — NOT NULL — 맛
- recipe_id (Key2) — int — Foreign key → Recipe.recipe_id — NOT NULL