1. 考生 考生=编号+姓名+密码+性别+注册时间+提示问题+问题答案+专业+身份证号 编号设计=类型（1：考生；2：教师；3：管理员）+注册序号 tb_Student表的结构 "字段名 "数据类型 "是否为空 "是否主键/ "默认值 "描述 " " " " "外键 " " " "id "bigint "NO " 主键 " "自动编码 " "sname "varchar(20"NO " " "姓名 " " ") " " " " " "pwd "varchar(20"NO " " "密码 " " ") " " " " " "sex "varchar(2)"NO " " "性别 " "joinTime "datetime "NO " "getdate() "注册时间 " "question "varchar(50"NO " " "提示问题 " " ") " " " " " "answer "varchar(50"NO " " "问题答案 " " ") " " " " " "prefession"varchar(30"NO " " "专业 " " ") " " " " " "canrNo "varchar(20"NO " " "身份证号 " " ") " " " " " (二)教师 教师=编号+姓名+密码+性别+注册时间+提示问题+问题答案+专业+身份证号 编号设计=类型（0：考生；1：教师；2：管理员）+注册序号 tb_Teacher表的结构 "字段名 "数据类型 "是否为空 "是否主键/ "默认值 "描述 " " " " "外键 " " " "id "bigint "NO "主键 " "自动编码 " "tname "varchar(20"NO " " "姓名 " " ") " " " " " "pwd "varchar(20"NO " " "密码 " " ") " " " " " "sex "varchar(2)"NO " " "性别 " "joinTime "datetime "NO " "getdate() "注册时间 " "question "varchar(50"NO " " "提示问题 " " ") " " " " " "answer "varchar(50"NO " " "问题答案 " " ") " " " " " "prefession"varchar(30"NO " " "专业 " " ") " " " " " "canrNo "varchar(20"NO " " "身份证号 " " ") " " " " " 7. 管理员 管理员=编号+姓名+密码+性别+加入时间+身份证号+类别 编号设计=类型（0：考生；1：教师；2：管理员）+注册序号 tb_Manager表的结构 "字段名 "数据类型 "是否为空 "是否主键/ "默认值 "描述 " " " " "外键 " " " "id "bigint "NO "主键 " "自动编码 " "mname "varchar(20"NO " " "姓名 " " ") " " " " " "pwd "varchar(20"NO " " "密码 " " ") " " " " " "sex "varchar(2)"NO " " "性别 " "joinTime "datetime "NO " " "注册时间 " "canrNo "varchar(20"NO " " "身份证号 " " ") " " " " " （四）套题 套题=编号+名称+所属课程+添加时间 tb_Tao表的结构 "字段名 "数据类型 "是否为空 "是否主键/外"默认值 "描述 " " " " "键 " " " "id "bigint "NO "主键 " "自动编码 " "tname "varchar(50"NO " " "套题名称 " " ") " " " " " "lessonID "bigint "NO "外键（tb_Le" "课程ID " " " " "sson） " " " "joinTime "datetime "NO " "getdate() "考试时间 " （五）课程表 tb_Lesson "字段名 "数据结构 "是否为空 "是否主键/ "默认值 "描述 " " " " "外键 " " " "id "bigint(8) "NO "主键 " "自动编码 " "lname "varchar(60"NO " " "课程名称 " " ") " " " " " "joinTime "datetime "NO " "getdate() "添加时间 " (六)单选题考试题目 tb_danQuestions表的结构 "字段名 "数据结构 "是否为空 "是否主键/ "默认值 "描述 " " " " "外键 " " " "i
