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