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