lms-erd

Tables (9)

classroom

  • classroom_id — varchar(20) — Primary key — NOT NULL
  • building_name — varchar(100) — NOT NULL
  • room_number — varchar(20) — NOT NULL
  • capacity — int4 — NOT NULL
  • classroom_type — varchar(30)

college

  • college_code — varchar(10) — Primary key — NOT NULL
  • college_name — varchar(100) — NOT NULL
  • building_name — varchar(100)
  • phone — varchar(20)

course

  • course_code — varchar(20) — Primary key — NOT NULL
  • department_code (department_code2) — varchar(20) — Foreign key → department.department_code — NOT NULL
  • college_code (college_code2) — varchar(10) — Foreign key → department.college_code — NOT NULL
  • course_name — varchar(100) — NOT NULL
  • credits — int4 — NOT NULL
  • target_grade — int4
  • course_type — varchar(20) — NOT NULL
  • department_code — varchar(20) — NOT NULL

course_section

  • section_id — varchar(20) — Primary key — NOT NULL
  • professor_id (professor_id2) — varchar(20) — Foreign key → professor.professor_id — NOT NULL
  • department_code (department_code2) — varchar(20) — Foreign key → professor.department_code — NOT NULL
  • course_code (course_code2) — varchar(20) — Foreign key → course.course_code — NOT NULL
  • classroom_id — varchar(20) — Foreign key → classroom.classroom_id — NOT NULL
  • department_code (department_code22) — varchar(20) — Foreign key → course.department_code — NOT NULL
  • college_code (college_code2) — varchar(10) — Foreign key → course.college_code — NOT NULL
  • course_code — varchar(20) — NOT NULL
  • professor_id — varchar(20) — NOT NULL
  • academic_year — int4 — NOT NULL
  • semester — int4 — NOT NULL
  • enrollment_limit — int4 — NOT NULL

department

  • department_code — varchar(20) — Primary key — NOT NULL
  • college_code (college_code2) — varchar(10) — Foreign key → college.college_code — NOT NULL
  • department_name — varchar(50) — NOT NULL
  • college_code — varchar(20) — NOT NULL
  • phone — varchar(20)
  • department_office — varchar(100)

enrollment

  • enrollment_id — bigserial — Primary key — NOT NULL
  • student_id (student_id2) — varchar(20) — Foreign key → student.student_id — NOT NULL
  • course_code — varchar(20) — Foreign key → course.course_code — NOT NULL
  • department_code (department_code2) — varchar(20) — Foreign key → course.department_code — NOT NULL
  • department_code (department_code22) — varchar(20) — Foreign key → student.department_code — NOT NULL
  • college_code (college_code2) — varchar(10) — Foreign key → student.college_code — NOT NULL
  • student_id — varchar(20) — NOT NULL
  • section_id — varchar(20) — NOT NULL
  • enrollment_date — date — NOT NULL
  • enrollment_status — varchar(20) — NOT NULL
  • grade — varchar(2)
  • retake_yn — bool

professor

  • professor_id — varchar(20) — Primary key — NOT NULL
  • department_code (department_code2) — varchar(20) — Foreign key → department.department_code — NOT NULL
  • college_code (college_code2) — varchar(10) — Foreign key → department.college_code — NOT NULL
  • professor_name — varchar(50) — NOT NULL
  • birth_date — date
  • professor_position — varchar(30) — NOT NULL
  • department_code — varchar(20) — NOT NULL
  • email — varchar(100)
  • phone — varchar(20)
  • employment_status — varchar(20) — NOT NULL

section_schedule

  • schedule_id — int8 — Primary key — NOT NULL
  • course_code — varchar(20) — Foreign key → course.course_code — NOT NULL
  • classroom_id (classroom_id2) — varchar(20) — Foreign key → classroom.classroom_id — NOT NULL
  • department_code (department_code2) — varchar(20) — Foreign key → course.department_code — NOT NULL
  • college_code (college_code2) — varchar(10) — Foreign key → course.college_code — NOT NULL
  • section_id — varchar(20) — NOT NULL
  • classroom_id — varchar(20) — NOT NULL
  • day_of_week — varchar(10) — NOT NULL
  • start_time — time — NOT NULL
  • end_time — time — NOT NULL

student

  • student_id — varchar(20) — Primary key — NOT NULL
  • department_code (department_code2) — varchar(20) — Foreign key → department.department_code — NOT NULL
  • college_code (college_code2) — varchar(10) — Foreign key → department.college_code — NOT NULL
  • student_name — varchar(50) — NOT NULL
  • birth_date — date — NOT NULL
  • admission_year — int4 — NOT NULL
  • current_semester — int4 — NOT NULL
  • student_status — varchar(20) — NOT NULL
  • department_code — varchar(20) — NOT NULL
  • phone — varchar(20)
  • email — varchar(100)