| Field name | Data Type | Not Null | Remark |
| user_id | varchar32 | NO | student id |
| user _name | varchar50 | NO | student name |
| password | varchar32 | NO | password |
| open_id | varchar128 | NO | open id |
| nickname | varchar50 | NO | nickname |
| gender | tinyint1 | YES | gender，default man |
| header | varchar512 | NO | header picture url |
| status | tinyint1 | NO | 0-unautherized，1-autherized |
| major_id | varchar32 | YES | major id |
| class_id | varchar32 | YES | class id |
| college_id | varchar32 | YES | College id |
| identity | tinyint3 | NO | 0-student，1-teacher |
| create_time | timestamp | NO | record creat time |
| update_time | timestamp | NO | record update time |
| del | tinyint1 | NO | default not delete record |