프로젝트

테이블 (4)

recipe_comments

  • comment_id — INT
  • recipe_id — INT
  • user_id — VARCHAR(255)
  • comment_text — TEXT
  • created_at — DATETIME

recipe_ratings

  • recipe_id — INT
  • user_id — VARCHAR(255)
  • likes — INT

recipes

  • recipe_id — INT
  • recipe_name — VARCHAR(255)
  • servings — VARCHAR(255)
  • cooking_instructions — TEXT
  • prep_time — VARCHAR(255)
  • recipe_photo — VARCHAR(255)
  • user_id — VARCHAR(255)

users

  • user_id — VARCHAR(255)
  • username — VARCHAR(255)
  • password — VARCHAR(255)
  • email — VARCHAR(255)
  • created_at — DATETIME