dongurami

Tables (21)

admin

  • adminId — BIGINT
  • adminUUID — VARCHAR(255)
  • adminAccount — VARCHAR(255)
  • adminPw — VARCHAR(255)
  • adminName — VARCHAR(100)
  • role — VARCHAR(50)

applic

  • applicId — BIGINT
  • profileId — BIGINT
  • clubId — BIGINT
  • applicUUID — VARCHAR(255)
  • applicGoogleFormUrl — TEXT
  • applicSubmittedAt — DATETIME
  • applicStatus — ENUM('wait', 'pass', 'fail')
  • applicChecked — BOOLEAN
  • applicDeleteDate — DATETIME

authToken

  • authTokenId — BIGINT
  • userUUID — VARCHAR(255)
  • authCode — VARCHAR(255)

club

  • clubId — BIGINT
  • clubName — VARCHAR(255)
  • department — ENUM('인문', '공학', '예체능')
  • leaderHp — VARCHAR(50)
  • leaderId — BIGINT
  • clubStatus — VARCHAR(50)
  • clubRoomNumber — VARCHAR(50)

clubCategory

  • clubCategoryId — BIGINT
  • clubCategoryUUID — VARCHAR(255)
  • clubCategoryName — VARCHAR(100)

clubCategoryMapping

  • clubCategoryMappingId — BIGINT
  • clubCategoryId — BIGINT
  • clubId — BIGINT

clubHashtag

  • clubHashtagId — BIGINT
  • clubId — BIGINT
  • clubHashtag — VARCHAR(100)

clubIntro

  • clubIntroId — BIGINT
  • clubId — BIGINT
  • clubRecruitment — TEXT
  • googleFormUrl — TEXT
  • recruitmentStatus — ENUM('모집중', '모집종료')

clubIntroPhoto

  • clubIntroPhotoId — BIGINT
  • clubIntroId — BIGINT
  • clubIntroPhotoName — VARCHAR(255)
  • clubIntroPhotoS3Key — VARCHAR(255)
  • photoOrder — INT

clubMainPhoto

  • clubMainPhotoId — BIGINT
  • clubId — BIGINT
  • clubMainPhotoName — VARCHAR(255)
  • clubMainPhotoS3Key — VARCHAR(255)

clubMemberAccountStatus

  • clubMemberAccountStatusId — BIGINT
  • clubMemberTempId — BIGINT
  • clubId — BIGINT

clubMemberTemp

  • clubMemberTempId — BIGINT
  • profileTempAccount — VARCHAR(255)
  • profileTempName — VARCHAR(255)
  • profileTempMajor — VARCHAR(100)
  • profileTempStudentNumber — VARCHAR(50)
  • profileTempHp — VARCHAR(20)
  • profileTempEmail — VARCHAR(255)
  • totalQuizResult — INT
  • clubRequestCount — INT
  • clubMemberTempExpiryDate — DATETIME

clubMembers

  • clubMemberId — BIGINT
  • profileId — BIGINT
  • clubId — BIGINT

emailToken

  • emailTokenId — BIGINT
  • emailToken_uuid — VARCHAR(255)
  • signup_uuid — VARCHAR(255)
  • email — VARCHAR(255)
  • expiration_time — DATETIME
  • is_verified — BOOLEAN

leader

  • leaderId — BIGINT
  • leaderUUID — VARCHAR(255)
  • clubId — BIGINT
  • leaderAccount — VARCHAR(255)
  • leaderPw — VARCHAR(255)
  • role — VARCHAR(50)
  • isAgreedTerms — BOOLEAN

notice

  • noticeId — BIGINT
  • adminId — BIGINT
  • noticeTitle — VARCHAR(255)
  • noticeContent — TEXT
  • noticeCreatedAt — DATETIME

noticePhoto

  • noticePhotoId — BIGINT
  • noticeId — BIGINT
  • noticePhotoPathName — VARCHAR(255)

profile

  • profileId — BIGINT
  • userId — BIGINT
  • userName — VARCHAR(100)
  • studentNumber — VARCHAR(50)
  • userMajor — VARCHAR(100)
  • userHp — VARCHAR(20)
  • profileCreatedAt — DATETIME
  • profileUpdatedAt — DATETIME
  • fcmToken — TEXT
  • fcmTokenCertificationTimestamp — DATETIME
  • memberType — VARCHAR(50)

user

  • userId — BIGINT
  • userUUID — VARCHAR(255)
  • userAccount — VARCHAR(255)
  • userPw — VARCHAR(255)
  • email — VARCHAR(255)
  • userCreatedAt — DATETIME
  • userUpdatedAt — DATETIME
  • role — VARCHAR(50)

userTemp

  • userTempId — BIGINT
  • tempAccount — VARCHAR(255)
  • tempPw — VARCHAR(255)
  • tempName — VARCHAR(100)
  • tempHp — VARCHAR(20)
  • tempMajor — VARCHAR(100)
  • tempStudentNumber — VARCHAR(50)
  • tempEmail — VARCHAR(255)
  • isEmailVerified — BOOLEAN

withdrawalToken

  • withdrawalId — BIGINT
  • userUUID — VARCHAR(255)
  • withdrawalCode — VARCHAR(255)