LearningMate
Tables (11)
Announcement (공지사항)
- ID (announcement_id) — bigint — Primary key — NOT NULL
- 제목 (title) — VARCHAR(100)
- 생성날짜 (created_at) — DATETIME
- 내용 (content) — VARCHAR(255)
- ID (professor_id) — bigint — Foreign key → professor.ID — NOT NULL
Assignment (과제)
- ID (assignment_id) — bigint — Primary key — NOT NULL
- 과제명 (title) — VARCHAR(100)
- 설명 (description) — VARCHAR(100)
- 마감 날짜 (due_date) — DATETIME
- 생성 날짜 (created_at) — DATETIME
- ID (course_id) — bigint — Foreign key → Course.ID — NOT NULL
Attendance (출석)
- ID (attendace_id) — bigint — Primary key — NOT NULL
- 상태 (status) — ENUM
- 날짜 (date) — DATETIME
- ID (memeber_id) — INT — Foreign key → Member.ID — NOT NULL
- ID (course_id) — int — Foreign key → Course.ID — NOT NULL
Course (강의)
- ID (course_id) — bigint — Primary key — NOT NULL
- 교수자 (instructor_id) — bigint
- 강의명 (course_name) — VARCHAR(50)
- 전공 (major) — VARCHAR(50)
- 날짜 (date) — DATETIME
- ID (professor_id) — bigint — Foreign key → professor.ID — NOT NULL
Join (학생 강의 연결)
- ID (member_id) — bigint — Foreign key → Member.ID — NOT NULL
- ID (course_id) — bigint — Foreign key → Course.ID — NOT NULL
Join (퀴즈학생연결)
- ID (member_id) — bigint — Foreign key → Member.ID — NOT NULL
- ID (grade_id) — bigint — Foreign key → grade.ID — NOT NULL
LearningMaterial (학습자료)
- ID (material_id) — bigint — Primary key — NOT NULL
- 제목 (title) — VARCHAR(50)
- 링크 (url) — VARCHAR(255)
- 자료날짜 (uploaded_date) — DATETIME
- ID (course_id) — bigint — Foreign key → Course.ID — NOT NULL
Member (학생)
- ID (member_id) — bigint — Primary key — NOT NULL
- 별명 (nickname) — VARCHAR(100)
- 이메일 (email) — VARCHAR(100)
- 이름 (member_name) — VARCHAR(100)
- 비밀번호 (password) — bigint
grade (퀴즈성적)
- ID (grade_id) — bigint — Primary key — NOT NULL
- 성적 (grade) — ENUM
- ID (quiz_id) — bigint — Foreign key → quiz.ID — NOT NULL
professor (교수자)
- ID (professor_id) — bigint — Primary key — NOT NULL
- 별명 (nickname) — VARCHAR(100)
- 이메일 (email) — VARCHAR(100)
- 이름 (member_name) — VARCHAR(100)
- 비밀번호 (password) — bigint
- 분야 (department) — VARCHAR(100)
quiz (퀴즈)
- ID (quiz_id) — bigint — Primary key — NOT NULL
- 제목 (title) — VARCHAR(50)
- 내용 (content) — VARCHAR(255)
- ID (course_id) — bigint — Foreign key → Course.ID — NOT NULL