数据库表

sp_record

sr_gradeid(VARCHAR)sr_stuid(INT)sr_courseid(VARCHAR)sr_examtime(VARCHAR)sr_examtype(VARCHAR)sr_xueqi(INT)sr_score(DOUBLE)

sp_student

s_id(INT)s_name(VARCHAR)s_pass(VARCHAR)s_sex(VARCHAR)s_idcard(VARCHAR)s_address(VARCHAR)s_nation(VARCHAR)s_pol_stat(VARCHAR)s_school_time(VARCHAR)s_househld(VARCHAR)s_schoolmethod(VARCHAR)s_class(VARCHAR)s_pic_path(VARCHAR)

sp_teacher

t_id(VARCHAR)t_name(VARCHAR)t_pass(VARCHAR)t_sex(VARCHAR)t_nation(VARCHAR)t_pol_stat(VARCHAR)t_idcard(VARCHAR)t_job_time(DATE)t_edu_bg(VARCHAR)t_gta_ins(VARCHAR)t_phone(VARCHAR)t_course(VARCHAR)t_pic_path(VARCHAR)

sp_sc

sc_classid(VARCHAR)sc_stuid(INT)

sp_course

c_id(VARCHAR)c_name(VARCHAR)

sp_admin

admin_id (VARCHAR)admin_name(VARCHAR)admin_pass(VARCHAR)reg_ip(VARCHAR)reg_time(VARCHAR)rel_t_id(VARCHAR)

sp_classes

cs_id(VARCHAR)cs_date(INT)cs_class(INT)cs_adviser((VARCHAR)

sp_ctc

ctc_classid(VARCHAR)ctc_teacherid(VARCHAR)ctc_courseid(VARCHAR)ctc_xueqi(INT)