tmi
Tables (4)
COURSE (강의정보)
- courseID (강의아이디) — int(11) — Primary key — NOT NULL
- courseUniversity (학부,대학원) — varchar(50)
- courseYear (강좌가열린연도) — int
- courseTerm (몇학기) — varchar(50)
- courseArea (교양전공) — varchar(50)
- courseMajor (학부) — varchar(50)
- courseGrade (학년) — varchar(50)
- courseTitle (강의명) — varchar(50)
- courseCredit (학점) — INT
- courseDivide (분반) — int
- coursePersonnel (제한인원) — int
- courseProfessor (지도교수) — varchar(50)
- courseTime (강의시간) — varchar(100)
- courseRoom (강의실) — varchar(100)
- courseorePersonnel (예년 수강인원) — int
NOTICE (공지사항)
- noticeContent (내용) — varchar(1000)
- noticeName (제목) — varchar(50)
- noticeDate (작성일자) — date
SCHEDULE (시간표)
- courseID (강의아이디2) — int(11) — Foreign key → COURSE.courseID — NOT NULL
- userID (아이디2) — varchar(50) — Foreign key → USER.userID — NOT NULL
- userID (유저명) — varchar(50)
- courseID (강의아이디) — int(11)
USER (유저정보)
- userID (아이디) — varchar(50) — Primary key — NOT NULL
- userPassword (비밀번호) — varchar(50)
- userGender (성별) — varchar(50)
- userMajor (전공) — varchar(50)
- userEmail (이메일) — varchar(50)