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