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)