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