ITCOOP
Tables (16)
followers
- followId — int — NOT NULL
- follow — varchar(100) — NOT NULL
- follower — varchar(100) — NOT NULL
- createdAt — timestamp
informationBookmarks
- informationBookmarkId — int — NOT NULL
- userId — varchar(100) — NOT NULL
- informationPostId — int — NOT NULL
- createdAt — timestamp
informationComments
- informationCommentId — int — NOT NULL
- commentDepth — int
- commentGroup — int
- userId — varchar(100) — NOT NULL
- informationPostId — int — NOT NULL
- informationCommentContent — varchar(100)
- createdAt — timestamp
- updatedAt — timestamp
informationLikes
- informationLikeId — int — NOT NULL
- userId — varchar(100) — NOT NULL
- informationPostId — int — NOT NULL
- createdAt — timestamp
informationPostImages
- informationPostImageId — int — NOT NULL
- informationPostId — int — NOT NULL
- imgUrl — varchar(100)
- createdAt — timestamp
- updatedAt — timestamp
informationPosts
- informationPostId — int — NOT NULL
- title — varchar(100)
- userId — varchar(100) — NOT NULL
- informationContent — text
- informationBookmarkCount — int
- informationLikeCount — int
- informationCommentCount — int
- viewCount — int
- createdAt — timestamp
- updatedAt — timestamp
notification
- notificationId — int — NOT NULL
- notificationReceiver — varchar(100) — NOT NULL
- notificationSender — varchar(100) — NOT NULL
- eventType — int
- eventContent — varchar(100)
- targetId — int
- isRead — bool
- createdAt — timestamp
recruitApplies
- recruitApplyId — int — NOT NULL
- recruitPostId — int — NOT NULL
- applicant — varchar(100) — NOT NULL
- task — int
- applyMessage — varchar(100)
- isAccepted — bool
- createdAt — timestamp
- updatedAt — timestamp
recruitBookmarks
- recruitBookmarkId — int — NOT NULL
- userId — varchar(100) — NOT NULL
- recruitPostId — int — NOT NULL
- createdAt — timestamp
recruitComments
- recruitCommentId — int
- commentDepth — int
- commentGroup — int
- userId — varchar(100) — NOT NULL
- recruitPostId — int — NOT NULL
- recruitCommentContent — varchar(100)
- createdAt — timestamp
- updatedAt — timestamp
recruitPostImages
- recruitPostImageId — int — NOT NULL
- recruitPostId — int
- imgUrl — varchar(100)
- createdAt — timestamp
- updatedAt — timestamp
recruitPosts
- recruitPostId — int — NOT NULL
- title — varchar(100)
- userId — varchar(100) — NOT NULL
- recruitContent — text
- viewCount — int
- recruitBookmarkCount — int
- recruitCommentCount — int
- recruitDurationDays — int
- endAt — timestamp
- createdAt — timestamp
- updatedAt — timestamp
recruitStacks
- recruitPostId — int — NOT NULL
- recruitTankAndStack — int
- numberOfPeopleRequired — int
- numberOfPeopleSet — int
- createdAt — timestamp
- updatedAt — timestamp
recruitTasks
- recruitPostId — int — NOT NULL
- recruitTask — int
- numberOfPeopleRequired — int
- numberOfPeopleSet — int
- createdAt — timestamp
- updatedAt — timestamp
userReputation
- userReputationId — int — NOT NULL
- userReputationSender — varchar(100) — NOT NULL
- userReputationReceiver — varchar(100) — NOT NULL
- userReputationPoint — int
- recruitPostId — int — NOT NULL
- createdAt — timestamp
- updatedAt — timestamp
users
- userId — varchar(100) — NOT NULL
- nickname — varchar(100)
- profileImgUrl — varchar(100)
- technologyStack — varchar(100)
- activityPoint — int
- selfIntroduction — varchar(100)
- portfolioUrl — varchar(100)
- password — varchar(100)
- loginType — int
- loginToken — varchar(100)
- isValid — bool
- createdAt — timestamp
- updatedAt — timestamp