.

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