다모아레시피 수정수정
테이블 (6)
Untitled (user)
- Key (user_id) — VARCHAR(30) — 기본 키 — NOT NULL
- Field (user_pw) — VARCHAR(30)
- Field (user_name) — VARCHAR(30)
- Field2 (user_email) — VARCHAR(100)
- Field (user_image) — VARCHAR(500)
- Field (user_created_at) — TIMESTAMP
- Field (user_updated_at) — TIMESTAMP
- Field (user_status) — TINYINT
Untitled (category)
- Key (category_id) — INT — 기본 키 — NOT NULL
- Field (category_type) — VARCHAR(30)
- Field (category_created_at) — TIMESTAMP
- Field2 (category_updated_at) — TIMESTAMP
- Field (category_status) — TINYINT
Untitled (recipe)
- Key (recipe_id) — BIGINT — 기본 키 — NOT NULL
- Field (recipe_name) — VARCHAR(30)
- Field (recipe_content) — VARCHAR(10000)
- Field2 (recipe_cooking_time) — VARCHAR(30)
- Field3 (recipe_level) — TINYINT
- Field4 (recipe_created_at) — TIMESTAMP
- Field5 (recipe_updated_at) — TIMESTAMP
- Field6 (recipe_status) — TINYINT
Untitled (ingredient)
- Key (ingredient_id) — VARCHAR(30) — 기본 키 — NOT NULL
- Field (ingredient_unit) — VARCHAR(30)
- Field2 (ingredient_calorie) — INT
- Field (ingredient_created_at) — TIMESTAMP
- Field2 (ingredient_updated_at) — TIMESTAMP
- Field3 (ingredient_status) — TINYINT
Untitled (image(recipe))
- Key (image_id) — VARCHAR(300) — 기본 키 — NOT NULL
- Field (image1) — VARCHAR(500)
- Field2 (image2) — VARCHAR(500)
- Field3 (image3) — VARCHAR(500)
- Field4 (image4) — VARCHAR(500)
- Field5 (image5) — VARCHAR(500)
- Field6 (image_created_at) — TIMESTAMP
- Field7 (image_updated_at) — TIMESTAMP
- Field8 (image_status) — TINYINT
Untitled2 (review)
- Key (review_id) — BIGINT — 기본 키 — NOT NULL
- Field (review_content) — VARCHAR(5000)
- Field (review_created_at) — TIMESTAMP
- Field (review_updated_at) — TIMESTAMP
- Field (review_status) — TINYINT