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