p
Tables (10)
RefreshToken (Untitled)
- Key (rt_key) — NOT NULL — Primary key — NOT NULL
- Field (re_value) — N
badge (뱃지)
- 뱃지ID (badge_id) — NOT NULL — Primary key — NOT NULL
- 맴버ID (member_id) — NOT NULL — Foreign key → member.맴버ID — NOT NULL
- Field (badgeName) — N
- Field (badgeNumber) — N
- Field (createdAt) — N
comment (댓글)
- 댓글ID (comment_id) — NOT NULL — Primary key — NOT NULL
- 맴버ID (member_id) — NOT NULL — Foreign key → member.맴버ID — NOT NULL
- 습관ID (goal_id) — NOT NULL — Foreign key → goal.습관ID — NOT NULL
- Field (content) — N
- Field (createdAt) — N
- Field (modifiedAt) — N
- Field (nickname) — N
- Field (profileImage) — N
- Field (socialid) — N
deletedUrlPath (Untitled2)
- Key (deletedUrlPath_id) — NOT NULL — Primary key — NOT NULL
- Field (deletedUrlPath) — N
friend (Untitled3)
- Key (friend_id) — NOT NULL — Primary key — NOT NULL
- Field (followerd) — N
- Field (followingId) — N
goal (습관)
- 습관ID (goal_id) — NOT NULL — Primary key — NOT NULL
- 맴버ID (member_id) — NOT NULL — Foreign key → member.맴버ID — NOT NULL
- 소셜ID (socialId) — NOT NULL — Foreign key → member.소셜ID — NOT NULL
- Field (achievementCheck) — N
- Field (category) — N
- Field (characterId) — N
- Field (currentDate) — N
- Field (endDate) — N
- Field (goalFlag) — N
- Field (privateCheck) — N
- Field (startDate) — N
- Field (time) — N
- Field (title) — N
heart (좋아요)
- 좋아요ID (heatr_id) — NOT NULL — Primary key — NOT NULL
- 습관ID (goal_id) — NOT NULL — Foreign key → goal.습관ID — NOT NULL
- Field (socialId) — N
image (이미지)
- 이미지ID (image_id) — NOT NULL — Primary key — NOT NULL
- 맴버ID (member_id) — NOT NULL — Foreign key → member.맴버ID — NOT NULL
- Field (createdAt) — N
- Field (imgName) — N
- Field (imgUrl) — N
- Field (modifiedAt) — N
member (맴버)
- 맴버ID (member_id) — NOT NULL — Primary key — NOT NULL
- 소셜ID (socialId) — NOT NULL — Primary key — NOT NULL
- Field (authority) — N
- Field (createdAt) — N
- Field (email) — N
- Field (heartClickCnt) — NOT NULL
- Field (modifiedAt) — N
- Field (nickname) — NOT NULL
- Field (password) — NOT NULL
- Field (socialCode) — N
- Field (status) — N
notification (알림)
- 알림ID (notification_id) — NOT NULL — Primary key — NOT NULL
- 맴버ID (member_id) — NOT NULL — Foreign key → member.맴버ID — NOT NULL
- Field (isRead) — N
- Field (message) — N
- Field (notificationType) — N