DU-FinalSchema
Tables (62)
Agreement
- agreeId — bigint — Primary key — NOT NULL
- code — varchar(100) — NOT NULL
- title — varchar(255) — NOT NULL
- type — enum('SERVICE', 'PRIVACY', 'MARKETING') — NOT NULL — SERVICE, PRIVACY, MARKETING
- content — text — NOT NULL
- isRequired — tinyint(1) — NOT NULL
- version — varchar(32) — NOT NULL
- isActive — tinyint(1) — NOT NULL
- effectiveDate — date — NOT NULL
- displayOrder — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
ArchiveArtist
- archiveArtistId — bigint — Primary key — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
- savedAt — datetime — NOT NULL
- artistProfileId — bigint — Foreign key → ArtistProfile.artistProfileId — NOT NULL
ArchiveDisplay
- archiveDisplayId — bigint — Primary key — NOT NULL
- displayId — bigint — Foreign key → Display.displayId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
- savedAt — datetime — NOT NULL
ArchiveWork
- archiveWorkId — bigint — Primary key — NOT NULL
- displayArtworkId — bigint — Foreign key → DisplayArtwork.displayArtworkId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
- savedAt — datetime — NOT NULL
AreaOfActivity
- areaOfActivityId — bigint — Primary key — NOT NULL
- artistProfileId — bigint — Foreign key → ArtistProfile.artistProfileId — NOT NULL
- field — varchar(255) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
ArtistProfile
- artistProfileId — bigint — Primary key — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
- artistName — varchar(50) — NOT NULL
- profileImageUrl — varchar(2048)
- schoolEmail — varchar(255) — NOT NULL
- univName — varchar(255) — NOT NULL
- portfolioUrl — varchar(255)
- introduction — varchar(100)
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
ArtworkFeeling
- feelingId — bigint — Primary key — NOT NULL
- content — text — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- displayArtworkId — bigint — NOT NULL
- userId — bigint — NOT NULL
ArtworkFeelingImage
- feelingImageId — bigint — Primary key — NOT NULL
- imageUrl — text — NOT NULL
- width — int — NOT NULL
- height — int — NOT NULL
- sortOrder — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- feelingId — bigint — Foreign key → ArtworkFeeling.feelingId — NOT NULL
ArtworkFeelingLike
- feelingLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- feelingId — bigint — NOT NULL
- userId — bigint — NOT NULL
ArtworkFeelingReply
- feelingReplyId — bigint — Primary key — NOT NULL
- content — text — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- feelingId — bigint — NOT NULL
- userId — bigint
ArtworkFeelingReplyImage
- feelingReplyImageId — bigint — Primary key — NOT NULL
- imageUrl — text — NOT NULL
- width — int — NOT NULL
- height — int — NOT NULL
- sortOrder — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- feelingReplyId — bigint — Foreign key → ArtworkFeelingReply.feelingReplyId — NOT NULL
ArtworkFeelingReplyLike
- feelingReplyLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- feelingReplyId — bigint — Foreign key → ArtworkFeelingReply.feelingReplyId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
ArtworkImage
- artImageId — bigint — Primary key — NOT NULL
- imageUrl — text — NOT NULL
- isThumbnail — tinyint(1) — NOT NULL
- imageType — enum('ARTWORK', 'WORK_PROCESS') — NOT NULL — ARTWORK, WORK_PROCESS
- sortOrder — int — NOT NULL
- caption — varchar(255)
- width — int — NOT NULL
- height — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- displayArtworkId — bigint — Foreign key → DisplayArtwork.displayArtworkId — NOT NULL
ArtworkQuestion
- questionId — bigint — Primary key — NOT NULL
- content — varchar(255) — NOT NULL
- isPublic — tinyint(1) — NOT NULL
- answerStatus — enum('WAITING', 'ANSWERED') — NOT NULL — WAITING, ANSWERED
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- displayArtworkId — bigint — NOT NULL
- userId — bigint — NOT NULL
ArtworkQuestionLike
- questionLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- questionId — bigint — Foreign key → ArtworkQuestion.questionId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
ArtworkQuestionReply
- queReplyId — bigint — Primary key — NOT NULL
- content — text — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- questionId — bigint — NOT NULL
- creatorId — bigint
- activeQuestionId — bigint
ArtworkQuestionReplyLike
- questionReplyLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- questionReplyId — bigint — Foreign key → ArtworkQuestionReply.queReplyId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
Column
- columnId — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- content — text — NOT NULL
- columnImageUrl — text — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
Creator
- creatorId — bigint — Primary key — NOT NULL
- creatorName — varchar(255) — NOT NULL
- isContact — tinyint(1) — NOT NULL
- isLeader — tinyint(1) — NOT NULL — 권한과 상관 x
- userId — bigint — Foreign key → User.userId — 직접 입력의 경우 null
- displayArtworkId — bigint — Foreign key → DisplayArtwork.displayArtworkId — NOT NULL
Display
- displayId — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- subtitle — varchar(255) — NOT NULL
- content — text — NOT NULL
- placeName — varchar(255) — NOT NULL
- latitude — decimal(10, 7) — NOT NULL
- longitude — decimal(10, 7) — NOT NULL
- qnaAccount — varchar(255) — NOT NULL
- note — text — NOT NULL
- organization — varchar(255) — NOT NULL
- department — varchar(255) — NOT NULL
- displayType — enum('GRADUATION', 'ASSIGNMENTS', 'DEPARTMENTS', 'SMALL_GROUP', 'INTER_GROUP', 'OTHERS') — NOT NULL — GRADUATION, ASSIGNMENTS, DEPARTMENTS, SMALL_GROUP, INTER_GROUP, OTHERS
- startDate — date — NOT NULL
- endDate — date — NOT NULL
- startTime — time — NOT NULL
- endTime — time — NOT NULL
- artWorkContentOpen — enum('IMMEDIATELY', 'ON_EXHIBITION') — NOT NULL — IMMEDIATELY, ON_EXHIBITION
- exhibitionContentOpen — enum('IMMEDIATELY', 'ON_EXHIBITION') — NOT NULL — IMMEDIATELY, ON_EXHIBITION
- status — enum('DRAFT', 'PUBLISHED') — NOT NULL — DRAFT, PUBLISHED
- invitationToken — varchar(255)
- invitationDisabledAt — datetime
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- userId — bigint — NOT NULL
- region — enum('ALL', 'SEOUL', 'GYEONGGI_INCHEON', 'OTHERS') — NOT NULL
- version — bigint — NOT NULL
- contract — varchar(50)
DisplayArtwork
- displayArtworkId — bigint — Primary key — NOT NULL
- artworkName — varchar(255) — NOT NULL
- content — text
- type — enum('PAINTING', 'DESIGN', 'PHOTOGRAPHY', 'ARCHITECTURE', 'MEDIA', 'CRAFT', 'SCULPTURE', 'FASHION', 'COMPLEX', 'ETC') — NOT NULL — PAINTING, DESIGN, PHOTOGRAPHY, ARCHITECTURE, MEDIA, CRAFT, SCULPTURE, FASHION, COMPLEX, ETC
- productionYear — int — NOT NULL
- materialMedia — varchar(255) — NOT NULL
- size — varchar(255)
- point — text
- workSortOrder — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- displayId — bigint — Foreign key → Display.displayId — NOT NULL
- registeredByUserId — bigint — Foreign key → User.userId — NOT NULL
- status — enum('DRAFT', 'PUBLISHED') — NOT NULL
DisplayArtworkLike
- displayArtworkLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- displayArtworkId — bigint — Foreign key → DisplayArtwork.displayArtworkId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
DisplayContent
- displayContentId — bigint — Primary key — NOT NULL
- imageUrl — varchar(255)
- width — int — NOT NULL
- height — int — NOT NULL
- contentsSortOrder — int — NOT NULL — 0 : 대표 이미지
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- categoryId — bigint — NOT NULL
- status — enum('DRAFT', 'PUBLISHED') — NOT NULL
DisplayContentCategory
- categoryId — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- description — varchar(255) — NOT NULL
- categorySortOrder — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- displayId — bigint — NOT NULL
DisplayField
- displayFieldId — bigint — Primary key — NOT NULL
- field — enum('PAINTING','DESIGN','PHOTOGRAPHY','ARCHITECTURE','VIDEO','CRAFTS','SCULPTURE','FASHION','INTERDISCIPLINARY','OTHERS') — NOT NULL
- sortOrder — int — NOT NULL
- displayId — bigint — Foreign key → Display.displayId — NOT NULL
DisplayImage
- disImageId — bigint — Primary key — NOT NULL
- imageUrl — text — NOT NULL
- imageType — enum('MAIN', 'DETAIL') — NOT NULL — MAIN, DETAIL
- width — int — NOT NULL
- height — int — NOT NULL
- sortOrder — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- displayId — bigint — NOT NULL
- activeDisplayImageUniqueKey — tinyint
DisplayInvitation
- disInvitationId — bigint — Primary key — NOT NULL
- userId — bigint — NOT NULL — 전시의 팀 리더 아이디
- displayId — bigint — NOT NULL
- userId2 — bigint — NOT NULL — 초대 된 팀 멤버 아이디
- status — enum('PENDING', 'ACCEPTED', 'REJECTED') — NOT NULL — PENDING, ACCEPTED, REJECTED
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- respondedAt — datetime
- deletedAt — datetime — 초대 받은 팀원이 초대를 거절했을때 (비활성화)
- activePendingInviteeUserId — bigint
DisplayLike
- displayLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- displayId — bigint — Foreign key → Display.displayId — NOT NULL
- userId — bigint — NOT NULL
DisplayReview
- displayReviewId — bigint — Primary key — NOT NULL
- content — text — NOT NULL
- displayId — bigint — Foreign key → Display.displayId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
DisplayReviewImage
- reviewImageId — bigint — Primary key — NOT NULL
- imageUrl — text — NOT NULL
- width — int — NOT NULL
- height — int — NOT NULL
- displayReviewId — bigint — Foreign key → DisplayReview.displayReviewId — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- sortOrder — int — NOT NULL
DisplayReviewLike
- displayReviewLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- displayReviewId — bigint — Foreign key → DisplayReview.displayReviewId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
DisplayReviewReply
- displayReviewReplyId — bigint — Primary key — NOT NULL
- content — varchar(300) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- displayReviewId — bigint — Foreign key → DisplayReview.displayReviewId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
DisplayReviewReplyImage
- displayReviewReplyImageId — bigint — Primary key — NOT NULL
- imageUrl — text — NOT NULL
- width — int — NOT NULL
- height — int — NOT NULL
- sortOrder — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- displayReviewReplyId — bigint — Foreign key → DisplayReviewReply.displayReviewReplyId — NOT NULL
DisplayReviewReplyLike
- displayReviewReplyLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- displayReviewReplyId — bigint — Foreign key → DisplayReviewReply.displayReviewReplyId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
LoungeComment
- loungeCommentId — bigint — Primary key — NOT NULL
- content — text — NOT NULL
- commentStatus — enum('ACTIVE', 'HIDDEN', 'DELETED') — NOT NULL — ACTIVE,HIDDEN,DELETED
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- parentCommentId — bigint
- loungePostId — bigint — NOT NULL
- userId — bigint — NOT NULL
LoungeCommentImage
- loungeCommentImageId — bigint — Primary key — NOT NULL
- imageUrl — text — NOT NULL
- sortOrder — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- loungeCommentId — bigint — Foreign key → LoungeComment.loungeCommentId — NOT NULL
LoungeCommentLike
- loungeCommentLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- loungeCommentId — bigint — NOT NULL
- userId — bigint — NOT NULL
LoungePost
- loungePostId — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- postStatus — enum('ACTIVE', 'HIDDEN', 'DELETED') — NOT NULL — ACTIVE,HIDDEN,DELETED
- category — enum('DISPLAY_REVIEW', 'WORK_TIP', 'COLLABORATION', 'SPACE_RENTAL') — NOT NULL — DISPLAY_REVIEW, WORK_TIP, COLLABORATION, SPACE_RENTAL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- userId — bigint — NOT NULL
LoungePostImage
- loungePostImageId — bigint — Primary key — NOT NULL
- loungePostId — bigint — Foreign key → LoungePost.loungePostId — NOT NULL
- imageUrl — text — NOT NULL
- sortOrder — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
LoungePostLike
- loungePostLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- loungePostId — bigint — NOT NULL
- userId — bigint — NOT NULL
LoungePostScrap
- loungePostScrapId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- loungePostId — bigint — NOT NULL
- userId — bigint — NOT NULL
Memo
- memoId — bigint — Primary key — NOT NULL
- content — text — NOT NULL
- visitDate — date
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- archiveDisplayId — bigint — Foreign key → ArchiveDisplay.archiveDisplayId
- archiveWorkId — bigint — Foreign key → ArchiveWork.archiveWorkId
- activeArchiveDisplayId — bigint
- activeArchiveWorkId — bigint
MemoImage
- memoImageId — bigint — Primary key — NOT NULL
- imageUrl — text — NOT NULL
- width — int — NOT NULL
- height — int — NOT NULL
- memoId — bigint — NOT NULL
PersonalArtwork
- personalArtworkId — bigint — Primary key — NOT NULL
- artworkName — varchar(255) — NOT NULL
- content — text
- type — enum('PAINTING', 'DESIGN', 'PHOTOGRAPHY', 'ARCHITECTURE', 'MEDIA', 'CRAFT', 'SCULPTURE', 'FASHION', 'COMPLEX', 'ETC') — NOT NULL — PAINTING, DESIGN, PHOTOGRAPHY, ARCHITECTURE, MEDIA, CRAFT, SCULPTURE, FASHION, COMPLEX, ETC
- productionYear — int — NOT NULL
- materialMedia — varchar(255) — NOT NULL
- size — varchar(255)
- point — text
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- userId — bigint — Foreign key → User.userId — NOT NULL
PersonalArtworkFeeling
- personalFeelingId — bigint — Primary key — NOT NULL
- content — varchar(300) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- personalArtworkId — bigint — Foreign key → PersonalArtwork.personalArtworkId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
PersonalArtworkFeelingImage
- personalFeelingImageId — bigint — Primary key — NOT NULL
- imageUrl — text — NOT NULL
- width — int — NOT NULL
- height — int — NOT NULL
- sortOrder — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- personalFeelingId — bigint — Foreign key → PersonalArtworkFeeling.personalFeelingId — NOT NULL
PersonalArtworkFeelingLike
- personalFeelingLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- personalFeelingId — bigint — Foreign key → PersonalArtworkFeeling.personalFeelingId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
PersonalArtworkFeelingReply
- personalFeelingReplyId — bigint — Primary key — NOT NULL
- content — varchar(300) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- personalFeelingId — bigint — Foreign key → PersonalArtworkFeeling.personalFeelingId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
PersonalArtworkFeelingReplyImage
- personalFeelingReplyImageId — bigint — Primary key — NOT NULL
- imageUrl — text — NOT NULL
- width — int — NOT NULL
- height — int — NOT NULL
- sortOrder — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- personalFeelingReplyId — bigint — Foreign key → PersonalArtworkFeelingReply.personalFeelingReplyId — NOT NULL
PersonalArtworkFeelingReplyLike
- personalFeelingReplyLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- personalFeelingReplyId — bigint — Foreign key → PersonalArtworkFeelingReply.personalFeelingReplyId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
PersonalArtworkImage
- personalArtworkImageId — bigint — Primary key — NOT NULL
- imageUrl — text — NOT NULL
- isThumbnail — tinyint(1) — NOT NULL
- imageType — enum('ARTWORK', 'WORK_PROCESS') — NOT NULL — ARTWORK, WORK_PROCESS
- sortOrder — int — NOT NULL
- caption — varchar(255)
- width — int — NOT NULL
- height — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- personalArtworkId — bigint — Foreign key → PersonalArtwork.personalArtworkId — NOT NULL
PersonalArtworkLike
- personalArtworkLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- personalArtworkId — bigint — Foreign key → PersonalArtwork.personalArtworkId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
PersonalArtworkQuestion
- personalQuestionId — bigint — Primary key — NOT NULL
- content — varchar(300) — NOT NULL
- isPublic — tinyint(1) — NOT NULL
- answerStatus — enum('WAITING', 'ANSWERED') — NOT NULL — WAITING, ANSWERED
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- personalArtworkId — bigint — Foreign key → PersonalArtwork.personalArtworkId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
PersonalArtworkQuestionLike
- personalQuestionLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- personalQuestionId — bigint — Foreign key → PersonalArtworkQuestion.personalQuestionId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
PersonalArtworkQuestionReply
- personalQuestionReplyId — bigint — Primary key — NOT NULL
- content — text — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- personalQuestionId — bigint — Foreign key → PersonalArtworkQuestion.personalQuestionId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
- activePersonalQuestionId — bigint
PersonalArtworkQuestionReplyLike
- personalQuestionReplyLikeId — bigint — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- personalQuestionReplyId — bigint — Foreign key → PersonalArtworkQuestionReply.personalQuestionReplyId — NOT NULL
- userId — bigint — Foreign key → User.userId — NOT NULL
RefreshToken
- tokenId — bigint — Primary key — NOT NULL
- refreshToken — varchar(255) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- userId — bigint — NOT NULL
SchoolEmailVerification
- verificationId — bigint — Primary key — NOT NULL
- schoolEmail — varchar(255) — NOT NULL
- univName — varchar(255) — NOT NULL
- verificationCode — varchar(10) — NOT NULL
- expiresAt — datetime — NOT NULL
- sentAt — datetime — NOT NULL
- verified — tinyint(1) — NOT NULL
- failedAttemptCount — int — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- userId — bigint — Foreign key → User.userId
TeamMember
- teamId — bigint — Primary key — NOT NULL
- displayNickname — varchar(255) — NOT NULL — 실명 말고 닉네임을 보여주는 경우에 필요함.
- author — enum('TEAM_MEM', 'TEAM_LEADER') — NOT NULL — TEAM_MEM, TEAM_LEADER
- isAccepted — tinyint(1) — NOT NULL
- deletedAt — datetime
- displayId — bigint — NOT NULL
- userId — bigint — NOT NULL
- activeUserId — bigint
User
- userId — bigint — Primary key — NOT NULL
- provider — enum('Google', 'Kakao') — NOT NULL — Google, Kakao
- providerId — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL
- profileImageUrl — varchar(2048)
- isVerified — tinyint(1) — NOT NULL
- socialEmail — varchar(255) — NOT NULL
- schoolEmail — varchar(255)
- univ_name — varchar(255)
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — datetime
- nicknameChangeAt — datetime — 닉네임 변경 날짜
UserAgreement
- userAgreeId — bigint — Primary key — NOT NULL
- isAgreed — tinyint(1) — NOT NULL
- agreedAt — datetime — NOT NULL
- agreeId — bigint — NOT NULL
- userId — bigint — NOT NULL
flyway_schema_history
- installed_rank — int — Primary key — NOT NULL
- version — varchar(50)
- description — varchar(200) — NOT NULL
- type — varchar(20) — NOT NULL
- script — varchar(1000) — NOT NULL
- checksum — int
- installed_by — varchar(100) — NOT NULL
- installed_on — timestamp — NOT NULL
- execution_time — int — NOT NULL
- success — tinyint(1) — NOT NULL