다모아레시피 수정수정

테이블 (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