re-itcoop
Tables (7)
recruitApplies
- userId — varchar(50) — Foreign key → users.userId — NOT NULL
- postId — int — Foreign key → recruitPosts.postId
- recruitApplyId — int
- applicant — varchar(50)
- task — int
- applyMessage — varchar(100)
- isAccepted — tinyint(1)
- createdAt — timestamp
- updatedAt — timestamp
recruitComments
- postId (postId2) — int — Foreign key → recruitPosts.postId
- recruitCommentId — int
- commentDepth — int
- commentGroup — int
- recruitCommentContent — varchar(100)
- createdAt — timestamp
- updatedAt — timestamp
- postId — int
- userId — varchar(50) — NOT NULL
recruitKeeps
- userId — varchar(50) — Foreign key → users.userId — NOT NULL
- postId — int — Foreign key → recruitPosts.postId
- recruitPostId — int — NOT NULL
- createdAt — timestamp
recruitPosts
- postId — int — Primary key
- title — varchar(100)
- thumbImgUrl — varchar(255)
- recruitContent — text
- viewCount — int
- region — int
- recruitDurationDays — int
- projectEndAt — timestamp
- createdAt — timestamp
- updatedAt — timestamp
- userId — varchar(50) — Foreign key → users.userId — NOT NULL
recruitStacks
- postId (postId2) — int — Foreign key → recruitPosts.postId
- postId — int — Foreign key → recruitPosts.postId
- recruitStack — int
- numberOfPeopleRequired — int
- numberOfPeopleSet — int
- postId (postId3) — int — Foreign key → recruitPosts.postId
recruitTasks
- postId (postId2) — int — Foreign key → recruitPosts.postId
- postId — int — Foreign key → recruitPosts.postId
- recruitTask — int — NOT NULL
- numberOfPeopleRequired — int — NOT NULL
- numberOfPeopleSet — int — NOT NULL
- postId (postId3) — int — Foreign key → recruitPosts.postId
users
- userId — varchar(50) — Primary key — 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