BGCR

Tables (3)

User (user_table)

  • userId (user_id) — INT — Primary key — NOT NULL
  • name — VARCHAR
  • password — VARCHAR
  • classNum (class_num) — INT
  • addMission (addmission) — INT
  • email — VARCHAR
  • nickname — VARCHAR
  • grade — INT
  • githubId (github_id) — VARCHAR

lookup (Lookup_table)

  • Key — Primary key — NOT NULL
  • userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
  • rank — INT — Foreign key → rank.rank — NOT NULL

rank (rank_table)

  • rank — INT — Primary key — NOT NULL
  • amountofcommit (amount_of_commit) — INT