erd

Tables (7)

comment

  • uuid — UUID — Primary key — NOT NULL
  • username — String
  • content — String
  • boardUuid — UUID — Foreign key → recipe_board.uuid — NOT NULL

ingredient (재료)

  • uuid — UUID — Primary key — NOT NULL
  • ingredient — String
  • recipeUuid — UUID — Foreign key → recipe.uuid — NOT NULL

likes (CopyOfcomment)

  • uuid — UUID — Primary key — NOT NULL
  • boardUuid — UUID — Foreign key → recipe_board.uuid — NOT NULL
  • username — String

recipe (레시피)

  • uuid — UUID — Primary key — NOT NULL
  • recipeName — String
  • username — String

recipe_board

  • uuid — UUID — Primary key — NOT NULL
  • username — String
  • title — String
  • content — String
  • imageUrl — String

step (단계)

  • uuid — UUID — Primary key — NOT NULL
  • order — Integer
  • description — String
  • recipeUuid — UUID — Foreign key → recipe.uuid — NOT NULL

users (사용자)

  • uuid — UUID — Primary key — NOT NULL
  • username — String
  • password — String
  • role — Enum
  • platformEnum — Enum
  • platformId — Long