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)