代码拉取完成,页面将自动刷新
本仓库提供57万多古诗、词、曲、文言文。作者3.8万,为大家构建项目提供支持,并长期维护。 前端程序
讨论可加微信(有交流群):songbo236589
古诗词数据库 由于数据过大提供以下链接:https://pan.baidu.com/s/1S5flvzPmrIQTkm_SCbhTdw?pwd=v32l
在这里还做了对应的微信小程序,可以查看: 1.这个数据库中包含了约58w古诗词和3.8古诗词作者。
2.lv_writing_authors
lv_writing_authors是古诗词作者表
CREATE TABLE `lv_writing_authors` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '作者ID',
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '姓名',
`name_tr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '姓名繁体',
`death_year` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '死亡年份',
`birth_year` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '出生年份',
`desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '描述',
`desc_tr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '描述繁体',
`dynasty_id` int(11) DEFAULT NULL COMMENT '朝代ID',
`dynasty` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '朝代',
`dynasty_tr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '朝代繁体',
`baidu_wiki` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '抓取地址',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
`sort` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
`works_count` int(11) NOT NULL DEFAULT '0' COMMENT '作品数量',
`created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38032 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='作者表';
3.lv_writing_dynastys
lv_writing_dynastys是朝代表
CREATE TABLE `lv_writing_dynastys` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '朝代ID',
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
`name_tr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称繁体',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '内容',
`content_tr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '内容繁体',
`baidu_wiki` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '抓取地址',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
`sort` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
`created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='朝代表';
4.lv_writing_works
lv_writing_works是古诗词表
CREATE TABLE `lv_writing_works` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '作品ID',
`title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '标题',
`title_tr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '标题繁体',
`author_id` int(11) DEFAULT NULL COMMENT '作者ID',
`author` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '作者',
`author_tr` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '作者繁体',
`dynasty_id` int(11) DEFAULT NULL COMMENT '朝代ID',
`dynasty` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '朝代',
`dynasty_tr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '朝代繁体',
`kind` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '体裁拼音',
`kind_cn` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '体裁',
`kind_cn_tr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '体裁繁体',
`baidu_wiki` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '抓取地址',
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '内容',
`content_tr` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '内容繁体',
`intro` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '评析',
`intro_tr` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '评析繁体',
`annotation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '注释',
`annotation_tr` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '注释繁体',
`translation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '译文',
`translation_tr` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '译文繁体',
`master_comment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '辑评',
`master_comment_tr` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '辑评繁体',
`quote` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '名句',
`quote_tr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '名句繁体',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
`sort` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
`created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=574964 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='作品表';
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。