studywithcam2
Tables (6)
Attendance
- attendanceId — INT
- userId — INT — Foreign key → User.userId — NOT NULL
- attendanceDate — DATETIME
- studyTime — INT
Board
- boardId — INT
- userId — INT — Foreign key → User.userId — NOT NULL
- groupId — INT — Foreign key → StudyGroup.groupId — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- createdAt — DATETIME — NOT NULL
Ranking
- rankingId — INT
- totalStudyTime — INT
- userId — INT — Foreign key → User.userId — NOT NULL
- groupId — INT — Foreign key → StudyGroup.groupId — NOT NULL
StudyGroup
- groupId — INT
- groupName — VARCHAR(255) — NOT NULL
User
- userId — INT
- username — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
UserGroup
- userId — INT — Foreign key → User.userId — NOT NULL
- groupId — INT — Foreign key → StudyGroup.groupId — NOT NULL