레시피공유사이트

테이블 (8)

Category

  • korean — str
  • chinese — str
  • japanese — str
  • western — str
  • vegeterian — str
  • other — str

Information

  • serving — int
  • time — int
  • level — int

Ingredients

  • name — str
  • amount — str

SequenceItem

  • picture — str
  • description — str

recipe

  • recipe_id — UUID
  • recipe_title — str
  • recipe_thumbnail — str
  • recipe_description — str
  • recipe_category — List[Category]
  • recipe_info — Information
  • recipe_ingredients — List[Ingredients]
  • recipe_sequence — List[SequenceItem]
  • recipe_tip — str
  • user_id — str

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

users

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