加载中
表名：wm_novel_novel
WMCMS程序版本：[V4.261.533] - 表名字：小说书籍表
| 字段名 | 字段类型 | 允许为空 | 键 | 默认值 | 自动增长 | 备注 |
|---|
|
| novel_id | int(11) | NO | PRI | | 是 | |
| author_id | int(4) | NO | | 0 | | 作者id |
| novel_name | varchar(35) | NO | | | | 小说名 |
| novel_wordname | varchar(30) | YES | | | | 全文字书名 |
| novel_pinyin | varchar(50) | NO | MUL | | | 拼音 |
| novel_status | tinyint(1) | NO | MUL | 1 | | 0为审核,1为正常 |
| novel_copyright | tinyint(1) | NO | | 0 | | 0为无版权，1为签约销售，2为买断版权 |
| novel_sign_id | int(4) | NO | | 0 | | 签约等级的id |
| novel_sell | tinyint(1) | NO | | 0 | | 是否允许上架出售 |
| novel_process | tinyint(1) | NO | | 1 | | 1为连载，2完成，3断更 |
| novel_type | int(1) | NO | | 1 | | 1为原创首发，2为他站首发 |
| type_id | int(4) | NO | MUL | | | 类型id |
| novel_author | varchar(20) | NO | MUL | | | 作者 |
| novel_cover | varchar(200) | NO | | | | 封面 |
| novel_comment | varchar(500) | YES | | | | 编辑点评 |
| novel_info | varchar(1000) | NO | | | | 小说简介 |
| novel_tags | varchar(50) | YES | | | | 小说标签 |
| novel_chapter | int(4) | NO | | 0 | | 总章节数 |
| novel_wordnumber | int(4) | NO | MUL | 0 | | 总字数 |
| novel_uptime | int(4) | NO | MUL | 0 | | 最后更新时间年月日时分秒 |
| novel_clicktime | int(4) | NO | | 0 | | 点击更新日期年月日 |
| novel_score | decimal(2,1) | NO | MUL | 0.0 | | 评分 |
| novel_ding | int(4) | NO | MUL | 0 | | 顶 |
| novel_cai | int(4) | NO | MUL | 0 | | 踩 |
| novel_replay | int(4) | NO | MUL | 0 | | 评论条数 |
| novel_startcid | int(4) | NO | | 0 | | 第一章节的id |
| novel_startcname | varchar(50) | NO | | 0 | | 第一章节的名字 |
| novel_newcid | int(4) | NO | | 0 | | 最新章节的id |
| novel_newcname | varchar(50) | NO | | 0 | | 最新章节的名字 |
| novel_createtime | int(4) | NO | MUL | 0 | | 创建时间 |
| novel_todayclick | int(4) | NO | MUL | 0 | | 今日点击 |
| novel_weekclick | int(4) | NO | MUL | 0 | | 周点击 |
| novel_monthclick | int(4) | NO | MUL | 0 | | 本月点击 |
| novel_yearclick | int(4) | YES | MUL | 0 | | 年点击 |
| novel_allclick | int(4) | NO | MUL | 0 | | 总点击数 |
| novel_todaycoll | int(4) | NO | MUL | 0 | | 日收藏 |
| novel_weekcoll | int(4) | NO | MUL | 0 | | 周收藏 |
| novel_monthcoll | int(4) | NO | MUL | 0 | | 月收藏 |
| novel_yearcoll | int(4) | NO | MUL | 0 | | 年收藏 |
| novel_allcoll | int(4) | NO | MUL | 0 | | 总收藏 |
| novel_colltime | int(4) | NO | | 0 | | 收藏更新时间 |
| novel_todayrec | int(4) | NO | MUL | 0 | | 日用户推荐 |
| novel_weekrec | int(4) | NO | MUL | 0 | | 周用户推荐 |
| novel_monthrec | int(4) | NO | MUL | 0 | | 月用户推荐 |
| novel_yearrec | int(4) | NO | MUL | 0 | | 年用户推荐 |
| novel_allrec | int(4) | NO | MUL | 0 | | 总用户推荐 |
| novel_path | varchar(250) | YES | | | | 小说完本txt保存地址 |
| novel_rectime | int(4) | NO | | 0 | | 推荐更新时间 |