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