-- 数据库大全:图书馆管理系统-试卷表
-- 来源:YesApi.cn
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 '下载数量',
`o