다모아레시피 1차

테이블 (7)

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) — ex) 프로필 사진
  • 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
  • Key (category_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — VARCHAR(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (recipe_author_id) — VARCHAR(30) — 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) — ex) 10g, 1kg
  • Field (ingredient_created_at) — TIMESTAMP
  • Field2 (ingredient_updated_at) — TIMESTAMP
  • Field3 (ingredient_status) — TINYINT

Untitled (image(recipe))

  • Key (image_id) — VARCHAR(300) — 기본 키 — NOT NULL
  • Key (recipe_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (category_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — VARCHAR(30) — 외래 키 → Untitled.Key — 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

Untitled (recipe-ingredient)

  • Key (recipe_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL — 여러 개의 재료가 여러 개의 레시피에 들어갈 수 있기 때문에 M:N
  • Key (category_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (ingredient_id) — VARCHAR(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — VARCHAR(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled2 (review)

  • Key (review_id) — BIGINT — 기본 키 — NOT NULL
  • Key (recipe_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (category_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — VARCHAR(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id2) — VARCHAR(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (review_author_id) — VARCHAR(30) — NOT NULL — 리뷰 작성자
  • Field (review_content) — VARCHAR(5000)
  • Field (review_created_at) — TIMESTAMP
  • Field (review_updated_at) — TIMESTAMP
  • Field (review_status) — TINYINT