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