recipe

Tables (5)

comments

  • id — Primary key — NOT NULL
  • authorId — Int — Foreign key → users.id — NOT NULL
  • recipeId — Int — Foreign key → receipes.id — NOT NULL
  • comment — string

favorite

  • userId — Int — Foreign key → users.id — NOT NULL
  • recipeId — Int — Foreign key → receipes.id — NOT NULL

orders

  • id — Primary key — NOT NULL
  • recipeId — Int — Foreign key → receipes.id — NOT NULL
  • image — string
  • content — string
  • order — int

receipes

  • id — Int — Primary key — NOT NULL
  • authorId — Int — Foreign key → users.id — NOT NULL
  • image — string
  • title — string
  • way — string
  • type — string
  • cnt — int
  • ingredients — string

users

  • id — Int — Primary key — NOT NULL
  • email — string
  • password — string
  • nickname — string