ㅇㅇ
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)