ㅠㅠ

Tables (3)

evaluation

  • evaluationID — int — Primary key
  • userID — varchar(20)
  • lectureName — varchar(50)
  • professorName — varchar(20)
  • lectureYear — int
  • semesterDivide — varchar(20)
  • lectureDivide — varchar(10)
  • evaluationTitle — varchar(50)
  • evaluationContent — varchar(2048)
  • totalScore — varchar(5)
  • creditScore — varchar(5)
  • comfortableScore — varchar(5)
  • lectureScore — varchar(5)
  • likeCount — int

likey

  • userID — varchar(20) — Primary key
  • evaluationID — int — Primary key
  • userIP — varchar(50)

user

  • userID — varchar(20) — Primary key
  • userPassword — varchar(64)
  • userEmail — varchar(50)
  • userEmailHash — varchar(64)
  • userEmailChecked — boolean