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)