5. 데이터베이스 설계

1. 테이블명 : USER (회원 정보)

 

+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| userID           | varchar(20) | YES  |  PRI   | NULL    |       |  ==> 기본키
| userPassword     | varchar(64) | YES  |     | NULL    |       |
| userEmail        | varchar(50) | YES  |     | NULL    |       |
| userEmailHash    | varchar(64) | YES  |     | NULL    |       |
| userEmailChecked | tinyint(1)  | YES  |     | NULL    |       |
+------------------+-------------+------+-----+---------+-------+

 

 

2. 테이블명 : EVALUATION ( 강의평가 내용)

+-------------------+---------------+------+-----+---------+----------------+
| Field             | Type          | Null | Key | Default | Extra          |
+-------------------+---------------+------+-----+---------+----------------+
| evaluationID      | int           | NO   | PRI | NULL    | auto_increment |   ==> 기본키
| userID            | varchar(20)   | YES  |     | NULL    |                |
| lectureName       | varchar(50)   | YES  |     | NULL    |                |
| professorName     | varchar(20)   | YES  |     | NULL    |                |
| lectureYear       | int           | YES  |     | NULL    |                |
| semesterDivide    | varchar(20)   | YES  |     | NULL    |                |
| lectureDivide     | varchar(10)   | YES  |     | NULL    |                |
| evaluationTitle   | varchar(50)   | YES  |     | NULL    |                |
| evaluationContent | varchar(2048) | YES  |     | NULL    |                |
| totalScore        | varchar(5)    | YES  |     | NULL    |                |
| creditScore       | varchar(5)    | YES  |     | NULL    |                |
| comfortableScore  | varchar(5)    | YES  |     | NULL    |                |
| lectureScore      | varchar(5)    | YES  |     | NULL    |                |
| likeCount         | int           | YES  |     | NULL    |                |
+-------------------+---------------+------+-----+---------+----------------+

 

 

3. 테이블명 : LIKEY (동일한 글에 동일한 사람이 추천을 못 누르게하기 위해)

+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| userID       | varchar(20) | YES  |     | NULL    |       |
| evaluationID | int         | YES  |     | NULL    |       |
| userIP       | varchar(50) | YES  |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+