lms 페이지

테이블 (6)

Assignment (assignment)

  • Project ID (project_id) — VERCHAR — 기본 키 — NOT NULL
  • Project Name (project_name) — VERCHAR
  • Deadline (deadline) — INT
  • Class ID (class_id) — INTEGER — 외래 키 → Class.Class ID — NOT NULL
  • Submit (submit) — BOOLEAN
  • Gradingg (grading) — BOOLEAN
  • Last Modifying (last_modifying) — TIMESTAMP
  • Left deadline (left_deadline) — INTERVAL

Class (class)

  • Class ID (class_id) — INTEGER — 기본 키 — NOT NULL
  • Class Name (Field) — VERCHAR
  • Professor ID (professor _id) — INTEGER — 외래 키 → Professor.Professor ID — NOT NULL
  • Progress (progress) — VERCHAR
  • Attendance (attendance) — BOOLEAN
  • Score (score) — VERCHAR

Professor (professor)

  • Professor ID (professor _id) — INTEGER — 기본 키 — NOT NULL
  • Professor Name (professor_name) — VERCHAR
  • Pro's Major (pro's_major) — VERCHAR

Student (student)

  • Student ID (student_id) — INTEGER — 기본 키 — NOT NULL
  • Name (name) — VERCHAR
  • Major (major) — VERCHAR
  • Student Number (student_number) — VERCHAR(8)

Student_assignment (student_assignment)

  • Assignment ID (assignment_id) — INTEGER — 외래 키 → Assignment.Project ID — NOT NULL
  • Student ID (student_id) — INTEGER — 외래 키 → Student.Student ID — NOT NULL

Student_class (student_class)

  • S_C ID (s_c_id) — INTEGER — 기본 키 — NOT NULL
  • Student ID (student_id) — INTEGER — 외래 키 → Student.Student ID — NOT NULL
  • Class ID (class_id) — INTEGER — 외래 키 → Class.Class ID — NOT NULL