-- 数据库大全:图书馆管理系统-试卷表
-- 来源:
CREATE TABLE `yesapi_t_paper` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`subject_id` varchar(64) NOT NULL COMMENT '',
`course_id` varchar(64) NOT NULL COMMENT '',
`school_id` varchar(64) NOT NULL COMMENT '',
`area_id` varchar(64) NOT NULL COMMENT '',
`creater_id` varchar(64) NOT NULL COMMENT '',
`name` varchar(100) NOT NULL COMMENT '标题',
`question_info` text NOT NULL COMMENT '题目类型,以逗号分割',
`type` varchar(10) NOT NULL DEFAULT '0' COMMENT '类型(1:真题试卷,2:模拟试卷,3:押题预测,4:名校精品)',
`year` varchar(5) NOT NULL COMMENT '年份',
`down_hits` int(10) NOT NULL DEFAULT '0' COMMENT '下载数量',
`open_hits` int(10) NOT NULL DEFAULT '0' COMMENT '打开数量',
`seo_title` varchar(255) NOT NULL COMMENT 'seo标题',
`seo_keywords` varchar(255) NOT NULL COMMENT 'seo关键字',
`seo_description` varchar(255) NOT NULL COMMENT 'seo描述',
`point` varchar(20) NOT NULL COMMENT '',
`money` varchar(20) NOT NULL COMMENT '',
`free` varchar(1) NOT NULL DEFAULT '1' COMMENT '',
KEY `subject_id` (`subject_id`),
KEY `course_id` (`course_id`),
KEY `school_id` (`school_id`),
KEY `area_id` (`area_id`),
KEY `creater_id` (`creater_id`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '图书馆管理系统-试卷表';