eco-sign-backend-db
Tables (19)
category (카테고리)
- 카테고리ID (categoryId) — Primary key — NOT NULL
- 카테고리 제목 (categoryTitle)
daily (데일리 미션)
- 데일리미션ID (dailyId) — Primary key — NOT NULL
- 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
- 데일리 제목 (dailyTitle)
- 데일리 상세 (dailyDescription)
dailyLike (미션 좋아요)
- 데일리미션ID (dailyLikeId) — Foreign key → daily.데일리미션ID — NOT NULL
- 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
meeting (모임)
- 모임ID (meetingId) — bigint — Primary key — NOT NULL
- 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL — 주최자
- 카테고리ID (categoryId) — Foreign key → category.카테고리ID — NOT NULL
- 모임 제목 (meetingTitle)
- 모임 상세 (meetingDescription)
- 모임 인원수 (meeting MaxMemberCount)
meetingAttend (모임 참가자)
- 모임 참가자ID (attendId) — bigint — Primary key — NOT NULL
- 모임ID (meetingId) — bigint — Foreign key → meeting.모임ID — NOT NULL
meetingChat (채팅)
- 채팅ID (chatId) — Primary key — NOT NULL
- 모임 참가자ID (attendId) — bigint — Foreign key → meetingAttend.모임 참가자ID — NOT NULL
- 미팅룸 ID (roomId) — Foreign key → meetingRoom.미팅룸 ID — NOT NULL
- 채팅 메시지 (chatMsg) — varchar
meetingComment (모임 댓글)
- 댓글ID (commentId) — Primary key — NOT NULL
- 모임ID (meetingId) — bigint — Foreign key → meeting.모임ID — NOT NULL
- 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
- 댓글 내용 (commentDescription) — varchar
meetingHashtag (해쉬태그)
- 해쉬태그ID (hashtagId) — Primary key — NOT NULL
- 모임ID (meetingId) — bigint — Foreign key → meeting.모임ID — NOT NULL
- 해쉬태그 제목 (hashtagTitle) — varchar
meetingLike (모임 좋아요)
- 좋아요ID (meetigLikeId) — Primary key — NOT NULL
- 모임ID (meetingId) — bigint — Foreign key → meeting.모임ID — NOT NULL
- 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
meetingRoom (모임 성사(채팅))
- 미팅룸 ID (roomId) — Primary key — NOT NULL
- 모임ID (meetingId) — bigint — Foreign key → meeting.모임ID — NOT NULL
- 모임 참가자ID (attendId) — bigint — Foreign key → meetingAttend.모임 참가자ID — NOT NULL
member (사용자)
- 유저ID (memberId) — bigint — Primary key — NOT NULL
- 유저 계정명 (memberEmail) — varchar
- 유저 비밀번호 (memberPassword) — varchar
- 유저 핸드폰번호 (memberPhoneNumber) — varchar — NOT NULL
- 유저 마켓팅 (memberIsMarkettingAgree) — ENUM(Y,N)
memberLike (북마크)
- 북마크ID (memberLikeId) — Primary key — NOT NULL
- 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
- 모임ID (meetingId) — bigint — Foreign key → meeting.모임ID — NOT NULL
notification (알림)
- 알림ID (notificationId) — Primary key — NOT NULL
- 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
- 알림 유형 (notificationType)
post (커뮤니티)
- 게시물ID (postId) — bigint — Primary key — NOT NULL
- 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
- 카테고리ID (categoryId) — Foreign key → category.카테고리ID — NOT NULL
- 게시물 제목 (postTitle) — varchar
- 게시물 상세 (postDescription)
- 커뮤니티 이미지 (postImg)
postComment (커뮤니티 댓글)
- 커뮤니티 댓글 ID (postCommentId) — Primary key — NOT NULL
- 게시물ID (postId) — bigint — Foreign key → post.게시물ID — NOT NULL
- 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
postHashTag (커뮤니티 해쉬태그)
- 커뮤니티 해쉬태그 ID (postHasgTagId) — Primary key — NOT NULL
- 게시물ID (postId) — bigint — Foreign key → post.게시물ID — NOT NULL
- 커뮤니티 해쉬태그 제목 (postTitle)
postLike (커뮤니티 좋아요)
- 커뮤니티 좋아요 ID (postLikeId) — Primary key — NOT NULL
- 게시물ID (postId) — bigint — Foreign key → post.게시물ID — NOT NULL
- 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
profile (사용자 프로필)
- 프로필ID (profileId) — bigint — Primary key — NOT NULL
- 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
- 유저 닉네임 (memberNickName) — varchar(8)
- 유저 이미지 (memberImg) — varchar(256)
social (사용자 유형)
- 유형ID (socialId) — bigint — Primary key — NOT NULL
- 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
- 유저 유형 (socialType) — bigint