分享一个古诗词小程序(约58w古诗词和3.8w古诗词作者)

古诗文相关开发者
218 阅读3分钟
highlight: a11y-dark theme: juejin --- # **古诗词数据库**

由于数据过大提供以下链接：pan.baidu.com/s/1S5flvzPm…

在这里还做了对应的微信小程序，可以查看：

qrcode_for_gh_29445efe8215_1280.jpggh_8498f83f42ea_1280.jpg

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='作品表';
avatar
文章
阅读
粉丝