K-HTML

Tables (6)

Ingredient Category

  • (id) — integer — Primary key — NOT NULL
  • (name) — string — NOT NULL

Ingredients

  • (id) — integer — Primary key — NOT NULL
  • (name) — string — NOT NULL
  • (nutrition_info) — string
  • (storage_method) — string
  • (disposal_method) — string
  • (category_id) — integer — Foreign key → Ingredient Category.id — NOT NULL

Recipe History

  • id — integer — Primary key — NOT NULL
  • (name) — string — NOT NULL
  • (nutrition_info) — string — NOT NULL
  • (review) — integer — NOT NULL — Enum('beginner', 'intermediate', 'advanced'), 조리 난이도
  • user_id — integer — Foreign key → User.integer — NOT NULL

Recipe History Ingredients

  • (id) — integer — Primary key — NOT NULL
  • (ingredients_id) — integer — Foreign key → Recipe History.id — NOT NULL
  • (recipe_history_id) — integer — Foreign key → Ingredients.id — NOT NULL

User

  • integer (id) — integer — Primary key — NOT NULL
  • carbon_reduce — integer — NOT NULL
  • email — string — NOT NULL
  • name — string — NOT NULL
  • Key (password) — string — NOT NULL

User Ingredients

  • (id) — integer — Primary key — NOT NULL
  • (ingredients_id) — integer — Foreign key → Ingredients.id — NOT NULL
  • (user_id) — integer — Foreign key → User.integer — NOT NULL