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)