itcoop-master
Tables (12)
chatMembers
- memberId — int
- chatRoomId — int — NOT NULL
- member — varchar(50) — NOT NULL
- createdAt — timestamp
chatRooms
- chatRoomId — int
- participantCount — int
- createdAt — timestamp
- isValid — tinyint(1)
chats
- chatId — int
- chatRoomId — int
- speaker — varchar(50) — NOT NULL
- chat — text — NOT NULL
- createdAt — timestamp
notification
- notificationId — int
- notificationReceiver — varchar(50)
- notificationSender — varchar(50)
- eventType — int
- eventContent — varchar(100)
- targetId — int
- isRead — tinyint(1)
- createdAt — timestamp
recruitApplies
- recruitApplyId — int
- recruitPostId — int — NOT NULL
- applicant — varchar(50)
- task — int
- applyMessage — varchar(100)
- isAccepted — tinyint(1)
- createdAt — timestamp
- updatedAt — timestamp
recruitComments
- recruitCommentId — int
- commentDepth — int
- commentGroup — int
- userId — varchar(50)
- recruitPostId — int — NOT NULL
- recruitCommentContent — varchar(100)
- createdAt — timestamp
- updatedAt — timestamp
recruitKeeps
- recruitKeepId — int
- userId — varchar(50)
- recruitPostId — int — NOT NULL
- createdAt — timestamp
recruitPosts
- recruitPostId — int
- title — varchar(100)
- author — varchar(50)
- thumbImgUrl — varchar(255)
- recruitContent — text
- viewCount — int
- recruitLocation — int
- recruitKeepCount — int
- recruitDurationDays — int
- endAt — timestamp
- createdAt — timestamp
- updatedAt — timestamp
recruitStacks
- recruitStackId — int
- recruitPostId — int — NOT NULL
- recruitStack — int
- numberOfPeopleRequired — int
- numberOfPeopleSet — int
- createdAt — timestamp
- updatedAt — timestamp
recruitTasks
- recruitTaskId — int
- recruitPostId — int — NOT NULL
- recruitTask — int — NOT NULL
- numberOfPeopleRequired — int — NOT NULL
- numberOfPeopleSet — int — NOT NULL
- createdAt — timestamp
- updatedAt — timestamp
userReputation
- userReputationId — int
- userReputationSender — varchar(50)
- userReputationReceiver — varchar(50) — NOT NULL
- userReputationPoint — tinyint(1) — NOT NULL
- recruitPostId — int
- createdAt — timestamp
- updatedAt — timestamp
users
- userId — varchar(50) — NOT NULL
- nickname — varchar(30)
- profileImgUrl — varchar(255)
- technologyStack — varchar(100)
- activityPoint — int
- selfIntroduction — text
- portfolioUrl — varchar(255)
- loginType — int — NOT NULL
- indigenousKey — varchar(255) — NOT NULL
- refreshToken — varchar(255)
- isValid — tinyint(1)
- createdAt — timestamp
- updatedAt — timestamp