Cockpybara_Sample

Tables (5)

Bookmarks (즐겨찾기)

  • member_id (멤버ID) — bigint — Foreign key → Member.id — NOT NULL
  • receipe_id (레시피ID) — bigint — Foreign key → CocktailReceipe.id — NOT NULL

CocktailReceipe (칵테일레시피)

  • id (아이디) — bigint — Primary key — NOT NULL
  • name (이름) — varchar
  • description (설명) — varchar

Ingredient (재료)

  • id (아이디) — bigint — Primary key — NOT NULL
  • name (이름) — varchar

Member (회원)

  • id (아이디) — bigint — Primary key — NOT NULL
  • email (이메일) — varchar
  • password (비밀번호) — varchar
  • nickname (이름) — varchar
  • gender (성별) — char
  • age (나이) — int

RecipeIngredient (레시피_재료)

  • receipe_id (레시피ID) — bigint — Foreign key → CocktailReceipe.id — NOT NULL
  • ingredient_id (재료ID) — bigint — Foreign key → Ingredient.id — NOT NULL