题库中单选题表设计:
CREATE TABLE IF NOT EXISTS `des_study_item_1` (
`tid` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘单选试题ID号’,
`uid` int(11) NOT NULL DEFAULT ‘1’,
`title` text NOT NULL COMMENT ‘试题标题’,
`cat_id` tinyint(2) NOT NULL DEFAULT ‘1’ COMMENT ‘题型的分类ID, 固定1’,
`item_content` text NOT NULL COMMENT ‘试题内容’,
`daan` varchar(500) DEFAULT NULL,
`fenxi` varchar(1000) DEFAULT NULL COMMENT ‘试题分析’,
`jieda` text NOT NULL COMMENT ‘试题解答’,
`fen` int(2) NOT NULL DEFAULT ‘0’ COMMENT ‘试题分值’,
`title_image` varchar(200) DEFAULT NULL,
`comments` varchar(1000) DEFAULT NULL COMMENT ‘点评’,
`image` varchar(255) DEFAULT ” COMMENT ‘是否有图片’,
`class_id` tinyint(2) NOT NULL DEFAULT ‘0’ COMMENT ‘年级分类ID’,
`course_id` tinyint