CommitNodeul

Tables (6)

Team

  • teamId (groupId) — INT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • size (max_member) — INT
  • description — TEXT
  • isDeleted — BOOLEAN
  • createdAt — DATE
  • deadLine — DATE

badge

  • badgeId — INT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • description — VARCHAR(255)

badgeHistory

  • rewardId — INT — Primary key — NOT NULL
  • badgeId — INT — Foreign key → badge.badgeId — NOT NULL
  • userId — INT — Foreign key → user.userId — NOT NULL
  • created_at — DATE

commitHistory

  • historyId — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → user.userId — NOT NULL
  • title — VARCHAR(255)
  • description — TEXT
  • createdAt — DATE
  • good — INT
  • bad — INT
  • githubLink — TEXT

member

  • memberId — INT — Primary key — NOT NULL
  • teamId — INT — Foreign key → Team.teamId — NOT NULL
  • userId — INT — Foreign key → user.userId — NOT NULL
  • isHead — BOOLEAN

user

  • userId — INT — Primary key — NOT NULL
  • githubId — VARCHAR(255)
  • level — INT
  • experience — INT
  • freeze_cnt — INT
  • name — VARHCAR(255)