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