考试系统 二零一五年十二月 编制人： 审核人： 编制时间： 2015-12-17 版本号：V1.0 目 录 1 数据库设计 ................................................................................................................................ 5 1.1 数据分区 ........................................................................................................................... 5 1.2 数据模型（每张表主键皆为obj_id） ............................................................................ 5 1.2.1 部门 pm_gd_zsk_bm ............................................................................................ 5 1.2.2 用户 PM_GD_ZSK_USERS .............................................................................. 5 1.2.3 题库信息PM_GD_ZSK_TKXX .......................................................................... 5 1.2.4 客观题题干PM_GD_ZSK_KGTTG .................................................................... 6 1.2.5 客观题选项信息PM_GD_ZSK_KGTXX ........................................................... 6 1.2.6 主观题题干PM_GD_ZSK_ZGTTG .................................................................... 6 1.2.7 试卷类型PM_GD_ZSK_SJLX ............................................................................ 7 1.2.8 试卷基本信息PM_GD_ZSK_SJJBXX ................................................................ 7 1.2.9 试卷-题型分值设置PM_GD_ZSK_SJLX_TXJFZ.............................................. 7 1.2.10 试卷分发用户 pm_gd_zsk_sj_ffyh ...................................................................... 8 1.2.11 试卷题目PM_GD_ZSK_SJTM ............................................................................ 8 1.2.12 答卷基本信息PM_GD_ZSK_KSDJJBXX .......................................................... 8 1.2.13 答卷具体信息PM_GD_ZSK_KSDJJTXX .......................................................... 9 1.2.14 培训资料管理PM_GD_ZSK_PXZL—新增 ....................................................... 9 1.2.15 在线培训资料 分配用户PM_GD_ZSK_ PXZL_fpyh ....................................... 9 1.2.16 外网管理PM_GD_ZSK_IP—新增 ................................................................. 9 1 数据库设计 1.1
