bigdata

Tables (3)

User (user)

  • id — int — Primary key — NOT NULL
  • password — varchar
  • name — varchar
  • email — varchar
  • last_ingredient — varchar

recipe

  • id — int — Primary key — NOT NULL
  • name — varchar
  • ingredients — varchar
  • time_req — varchar
  • cook_method — varchar
  • img — varchar
  • category — varchar

score

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • recipe_id — int — Foreign key → recipe.id — NOT NULL
  • score — float