Cocktail_Service_ERD

Tables (16)

AiChatMessage (Untitled16)

  • Key (Id) — Primary key — NOT NULL
  • Key (session_id) — Foreign key → AiChatSession.Key — NOT NULL
  • 유저 ID (user_id) — Foreign key → AiChatSession.유저 ID — NOT NULL
  • 구분 (role) — user, assistant
  • 내용 (content)
  • (created_at)

AiChatSession (Untitled15)

  • Key (Id) — Primary key — NOT NULL
  • 유저 ID (user_id) — Foreign key → User.유저 ID — NOT NULL
  • (created_at)

Comment (Untitled10)

  • Key (Id) — Primary key — NOT NULL
  • Key (post_id) — Foreign key → Post.Key — NOT NULL
  • 유저 ID (user_id) — Foreign key → Post.유저 ID — NOT NULL
  • 내용 (content)
  • (created_at)

Ingredient (Untitled3)

  • Key (id) — Primary key — NOT NULL
  • 재료명 (name)
  • 종류 (type) — alcohol, glass, garnish, mixer
  • 이미지 (image_url)
  • 도수 (abv)

Post (Untitled8)

  • Key (id) — Primary key — NOT NULL
  • 유저 ID (user_id) — Foreign key → User.유저 ID — NOT NULL
  • 제목 (title)
  • 내용 (content)
  • (created_at)

PostImage (Untitled9)

  • Key (Id) — Primary key — NOT NULL
  • Key (post_id) — Foreign key → Post.Key — NOT NULL
  • 유저 ID (user_id) — Foreign key → Post.유저 ID — NOT NULL
  • 이미지 (image_url)

PostLike (Untitled11)

  • Key (post_id) — Foreign key → Post.Key — NOT NULL
  • 유저 ID (user_id) — Foreign key → Post.유저 ID — NOT NULL
  • (created_at)

PostTag (Untitled13)

  • Key (post_id) — Foreign key → Post.Key — NOT NULL
  • 유저 ID (user_id) — Foreign key → Post.유저 ID — NOT NULL
  • Key (tag_id) — Foreign key → Tag.Key — NOT NULL

Recipe (Untitled5)

  • Key (id) — Primary key — NOT NULL
  • 추천 잔 (glass_id) — Foreign key → Ingredient.Key — NOT NULL
  • 칵테일명 (name)
  • 설명 (description)
  • 도수 (abv)
  • 진위 (is_official)
  • (created_at)

RecipeIngredient (Untitled6)

  • Key (id) — Primary key — NOT NULL
  • Key (recipe_id) — Foreign key → Recipe.Key — NOT NULL
  • Key (glass_id) — Foreign key → Recipe.추천 잔 — NOT NULL
  • Key (ingredient_id) — Foreign key → Ingredient.Key — NOT NULL
  • 용량 (amount)
  • 대체 가능 여부 (is_optional)

RecipeLike (Untitled7)

  • 유저 ID (user_id) — Foreign key → User.유저 ID — NOT NULL
  • (created_at)

Tag (Untitled12)

  • Key (Id) — Primary key — NOT NULL
  • 내용 (name)

User (Untitled)

  • 유저 ID (id) — Primary key — NOT NULL
  • 닉네임 (nickname)
  • 이메일 (email) — unique
  • 생성일 (created_at)

UserAuth (Untitled2)

  • Key (id) — Primary key — NOT NULL
  • 유저 ID (user_id) — Foreign key → User.유저 ID — NOT NULL
  • 종류 (provider) — google, kakao, local
  • 고유 ID (provider_user_id)
  • local (password_hash)
  • (created_at)

UserIingredient (Untitled4)

  • Key (id) — Primary key — NOT NULL
  • Key (ingredient_id) — Foreign key → Ingredient.Key — NOT NULL
  • 종류 (source) — manual,, ai
  • (created_at)

UserToken (Untitled14)

  • 유저 ID (user_id) — Foreign key → User.유저 ID — NOT NULL
  • 토큰 수 (remaining_count) — 5
  • (updated_at)