在线考试系统数据库表关系图

PK

ID

titleuser_idauthorgradetotal_scoreclass_idsubject_idstart_timeend_timestatuscreate_timeupdate_time 

comment评论表

link友链表

sys_keysys_valueremarkstatuscreate_timeupdate_time 

tag标签表

permission_idnamedescriptionurlpermsparent_idtypeorder_numiconstatuscreate_timeupdate_time 

namedescriptioncreate_timeupdate_time 

sys_config系统配置表

user_idclass_idusernamepasswordsaltgradenicknameemailphonesexageimgstatuscreate_timeupdate_timelast_login_time 

institute学院表

titlecontentquestion_typeoption_aoption_boption_coption_danswerparsescoredifficultysubject_idstatuscreate_timeupdate_time 

nameurldescriptionimgeamilqqremarkstatuscreate_timeupdate_time 

question题目表

classes班级表

subject课程表

examination试卷表

user_role用户角色表

user_idpidusernamenicknameavatareamilipcontentsupportstatuscreate_timeupdate_time 

user_idrole_id 

user_idexam_idresultauto_resultmanul_resultauto_jsonmanul_jsonstatuscreate_timeupdate_time 

institute_namedescriptioninstitute_logosortauthorstatuscreate_timeupdate_time 

user用户表

role角色表

permission权限表

grade成绩表

role_permission角色权限表

ins_idclass_namedescriptionsortauthorstatuscreate_time 

exam_question试卷题目表

role_idpermission_id 

exam_idquestion_id 

role_idnamedescriptionstatuscreate_timeupdate_time 

namedescriptionimg_urlsortauthorstatuscreate_timeupdate_time