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