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