.
Tables (6)
class (수업)
- id (수업코드) — bigint — Primary key — NOT NULL
- porf_id (교수번호) — bigint — Foreign key → professor.id — NOT NULL
- course_id (과목코드) — bigint — Foreign key → course.id — NOT NULL
- year (이수학년) — int
- semester (이수학기) — int
- division (분반) — int
- classroom (강의실) — varchar
- enroll (수강정원) — int
course (과목)
- id (과목코드) — bigint — Primary key — NOT NULL
- title (과목명) — varchar
- credit (이수학점) — int
department (학과)
- id (학과번호) — bigint — Primary key — NOT NULL
- name (학과명) — varchar
- office (학과사무실) — varchar
grade (성적)
- stu_id (학번) — bigint — Foreign key → student.id — NOT NULL
- class_id (수업코드) — bigint — Foreign key → class.id — NOT NULL
- grade (성적) — enum
professor (교수)
- id (교수번호) — bigint — Primary key — NOT NULL
- dept_id (학과번호) — bigint — Foreign key → department.id — NOT NULL
- name (이름) — varchar
- year_emp (임용년도) — int
- resident_id (주민번호) — int
- position (직위) — enum
student (학생)
- id (학번) — bigint — Primary key — NOT NULL
- dept_id (학과번호) — bigint — Foreign key → department.id — NOT NULL
- name (이름) — varchar
- resident_id (주민번호) — int
- address (주소) — varchar
- year (학년) — int