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