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