Challenge

Tables (10)

Book (북)

  • bookId (Key2) — long — Primary key — NOT NULL
  • isbn (Field) — string
  • bookName (Field2) — string
  • writer (Field3) — string
  • publisher (Field4) — string
  • thumbnailImagePath (Field7) — string

Challenge (챌린지)

  • challengeId (Key) — long — Primary key — NOT NULL
  • createMemberId (Field9) — long
  • groupSize (Field) — int
  • chanllengeName (Field2) — string
  • description (Field3) — string
  • startDate (Field4) — datetime
  • endDate (Field5) — datetime
  • recruitDate (Field6) — datetime
  • deleteDate (Field7) — datetime
  • isFullStart (Field8) — bool
  • certificationCycle (Field12) — enum
  • character (Field13) — enum
  • createDate (Field10) — datetime
  • updateDate (Field11) — datetime
  • bookId (Key2) — long — Foreign key → Book.bookId — NOT NULL

ChallengeMember (챌린지맵핑)

  • challengeMemberId (Key) — long — Primary key — NOT NULL
  • memberId (Key2) — long — Foreign key → Member.memberId — NOT NULL
  • challengeId (Key3) — long — Foreign key → Challenge.challengeId — NOT NULL
  • joinDate (Field) — datetime
  • isSuccess (Field2) — bool
  • cetificationRate (Field3) — double
  • certificationCount (Field6) — int
  • createDate (Field4) — datetime
  • updateDate (Field5) — datetime

Comment (댓글)

  • commentId (Key) — long — Primary key — NOT NULL
  • feedId (Key2) — long — Foreign key → Feed.feedId — NOT NULL
  • memberId (Key3) — long — Foreign key → Member.memberId — NOT NULL
  • parentCommentId (Field) — long
  • comment (Field2) — string
  • createDate (Field3) — datetime
  • updateDate (Field4) — datetime

CommentLike (댓글좋아요)

  • commentLikeId (Key) — long — Primary key — NOT NULL
  • memberId (Key2) — long — Foreign key → Member.memberId — NOT NULL
  • commentId (Key3) — long — Foreign key → Comment.commentId — NOT NULL
  • createDate (Field) — datetime

Feed (게시글)

  • feedId (Key) — long — Primary key — NOT NULL
  • challengeId (Key2) — long — Foreign key → Challenge.challengeId — NOT NULL
  • memberId (Key3) — long — Foreign key → Member.memberId — NOT NULL
  • title (Field) — string
  • content (Field2) — string
  • isSpoiler (Field3) — bool
  • createDate (Field4) — datetime
  • updateDate (Field5) — datetime

FeedLike (좋아요)

  • feedLikeId (Key) — long — Primary key — NOT NULL
  • feedId (Key2) — long — Foreign key → Feed.feedId — NOT NULL
  • memberId (Key3) — long — Foreign key → Member.memberId — NOT NULL
  • createDate (Field) — datetime

FeedPicture (게시글사진)

  • feedPictureId (Key) — long — Primary key — NOT NULL
  • feedId (Key2) — long — Foreign key → Feed.feedId — NOT NULL
  • path (Field) — string
  • order (Field4) — int
  • createDate (Field2) — datetime
  • updateDate (Field3) — datetime

Member (회원)

  • memberId (Key) — long — Primary key — NOT NULL
  • uid (Field) — string
  • displayName (Field3) — string
  • email (Field2) — string
  • photoURL (Field5) — string
  • socialProvider (Field8) — string
  • createDate (Field6) — datetime
  • updateDate (Field7) — datetime
  • deleteDate (Field9) — datetime

PushToken (푸시토큰)

  • id (Key2) — long — Primary key — NOT NULL
  • memberId (Key) — long — Foreign key → Member.memberId — NOT NULL
  • Token (Field) — string
  • CreateDate (Field2) — datetime
  • UpdateDate (Field3) — datetime