test

Tables (5)

class (과목)

  • cl_no (과목번호) — varchar(50) — Primary key — NOT NULL
  • pf_no (교수번호) — varchar(50) — Foreign key → professor.pf_no
  • cl_credit (학점) — int
  • cl_name (과목이름) — varchar(50)

major (학과)

  • m_no (학과번호) — varchar(50) — Primary key — NOT NULL
  • m_name (학과이름) — varchar(50)

professor (교수)

  • pf_no (교수번호) — varchar(50) — Primary key
  • m_no (학과번호) — varchar(50) — Foreign key → major.m_no — NOT NULL
  • pf_name (교수이름) — varchar(50)

register (수강)

  • st_no (학생번호) — varchar(50) — Foreign key → student.st_no — NOT NULL
  • cl_no (과목번호) — varchar(50) — Foreign key → class.cl_no — NOT NULL
  • pf_no (교수번호) — varchar(50) — Foreign key → class.pf_no
  • rg_score (점수) — int
  • rg_rate (등급) — char(2)

student (학생)

  • st_no (학생번호) — varchar(50) — Primary key — NOT NULL
  • m_no (학과번호) — varchar(50) — Foreign key → major.m_no — NOT NULL
  • st_name (학생이름) — varchar(50)
  • st_phone (학생전화번호) — varchar(50)
  • st_address (학생주소) — varchar(200)
  • st_state (학생상태) — char(2)
  • st_date (입력일자) — DATE