main project

Tables (14)

Bookmarks (bookmark)

  • id (bookmark_id) — NOT NULL — Primary key — NOT NULL
  • id (cocktail_id) — NOT NULL — Foreign key → Cocktails.id — NOT NULL
  • 칵테일 사진 url (cocktailImageUrl) — NOT NULL
  • 칵테일 이름 (cockatil_name) — NOT NULL
  • id (user_id) — NOT NULL — Foreign key → Users.id — NOT NULL
  • 사용자 연령대 (age) — NOT NULL
  • 사용자 성별 (gender) — NOT NULL

Cocktail_Ingredient (Ingredients)

  • id (cocktail_id) — NOT NULL — Foreign key → Cocktails.id — NOT NULL
  • 재료 (ingredient) — NOT NULL

Cocktail_Recipe (Recipe)

  • id (cocktail_id) — NOT NULL — Foreign key → Cocktails.id — NOT NULL
  • 과정 (recipe) — NOT NULL

Cocktail_Tag (Tags)

  • id (cocktail_id) — NOT NULL — Foreign key → Cocktails.id — NOT NULL
  • 태그 (tag) — NOT NULL

Cocktails (Cocktail)

  • id (cocktail_id) — NOT NULL — Primary key — NOT NULL
  • 카테고리 (category) — NOT NULL
  • 작성일 (created_at) — NOT NULL
  • 수정일 (last_modified_at)
  • 사진 url (image_url) — NOT NULL
  • 베이스 술 (liquor) — NOT NULL
  • 칵테일명 (name) — NOT NULL
  • 별점 평균 (rate) — Default=0
  • 별점 등록 수 (rated_count) — Default=0
  • 별점 총점 (total_rate_sum) — Default=0
  • 조회수 (view_count) — NOT NULL
  • id (user_id) — NOT NULL — Foreign key → Users.id — NOT NULL

Cocktails_Comment (List<Comment>)

  • id (cocktail_id) — NOT NULL — Foreign key → Cocktails.id — NOT NULL
  • id (comment_id) — NOT NULL — Foreign key → Comments.id — NOT NULL

Comments (Comment)

  • id (comment_id) — NOT NULL — Primary key — NOT NULL
  • id (userId) — NOT NULL — Foreign key → Users.id — NOT NULL
  • 내용 (content) — NOT NULL
  • 생성일 (created_at) — NOT NULL
  • 수정일 (last_modified_at) — NOT NULL

Comments_Replies (List<Reply>)

  • id (comment_id) — NOT NULL — Foreign key → Comments.id — NOT NULL
  • id (reply_id) — NOT NULL — Foreign key → Reply.id — NOT NULL

Follows (Follow)

  • id (follow_id) — NOT NULL — Primary key — NOT NULL
  • 팔로워 id (follower) — NOT NULL
  • 팔로잉 id (following_user_id) — NOT NULL
  • 팔로잉 이름 (following_user_name) — NOT NULL
  • 팔로잉 프로필 이미지 url (following_user_profile_image_url) — NOT NULL

Reply (Untitled)

  • id (reply_id) — NOT NULL — Primary key — NOT NULL
  • 댓글 id (comment_id) — NOT NULL
  • 내용 (content) — NOT NULL
  • 작성일 (created_at) — NOT NULL
  • 수정일 (modified_at) — NOT NULL
  • 태그 된 사용자 id (tagged_user_id) — NOT NULL
  • 태그 된 사용자 이름 (tagged_user_name) — NOT NULL

Users (User)

  • id (user_id) — NOT NULL — Primary key — NOT NULL
  • 나이 (age) — NOT NULL
  • 이메일 (email) — NOT NULL
  • 성별 (gender) — NOT NULL
  • 유저상태 (is_active_user) — NOT NULL
  • 이름 (name) — NOT NULL
  • 비밀번호 (password) — NOT NULL
  • 프로필 이미지 주소 (profileImage_url)
  • 구독자수 (subscribers_count)

Users_Bookmarks (List<Bookmark>)

  • id (user_id) — NOT NULL — Foreign key → Users.id — NOT NULL
  • id (bookmark_id) — NOT NULL — Foreign key → Bookmarks.id — NOT NULL

Users_Follows (List<Follow>)

  • id (user_id) — NOT NULL — Foreign key → Users.id — NOT NULL
  • id (follow_id) — NOT NULL — Foreign key → Follows.id — NOT NULL

Users_Roles (List<String>)

  • id (user_id) — NOT NULL — Foreign key → Users.id — NOT NULL
  • 권한 (role) — NOT NULL