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)