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