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