ㅇㅇ

Tables (6)

ENROLLMENT (수강)

  • enr_id (수강ID) — int — Primary key — NOT NULL
  • std_id (학번) — int — Foreign key → STUDENT.std_id — NOT NULL
  • grade (학점) — varchar(2)
  • lec_id (강의ID) — int — Foreign key → LECTURE.lec_id — NOT NULL

INSTRUCTOR (강사)

  • inst_id (강사번호) — int — Primary key — NOT NULL
  • name (이름) — varchar(50)
  • age (나이) — int
  • gender (성별) — char(1)

LECTURE (강의)

  • lec_id (강의ID) — int — Primary key — NOT NULL
  • inst_id (강사번호) — int — Foreign key → INSTRUCTOR.inst_id — NOT NULL
  • lec_time (시간) — varchar(50)
  • room (장소) — varchar(50)
  • sub_id (과목번호) — int — Foreign key → SUBJECT.sub_id — NOT NULL

NOTICE (공지사항)

  • notice_id (Key) — int — Primary key — NOT NULL
  • inst_id (강사번호) — int — Foreign key → INSTRUCTOR.inst_id — NOT NULL
  • title (제목) — varchar(200)
  • content (내용) — text
  • reg_date (작성일) — datetime
  • lec_id (강의ID) — int — Foreign key → LECTURE.lec_id — NOT NULL

STUDENT (학생)

  • std_id (학번) — int — Primary key — NOT NULL
  • name (이름) — varchar(50)
  • address (주소) — varchar(255)

SUBJECT (과목)

  • sub_id (과목번호) — int — Primary key — NOT NULL
  • sub_name (과목명) — varchar(100)