README.md · :-O礻大象/中国古诗词大全60万

# 中国古诗词大全60万

#### 介绍
本仓库提供57万多古诗、词、曲、文言文。作者3.8万，为大家构建项目提供支持，并长期维护。
[前端程序](https://gitee.com/song-bo/ancient-poems-and-ci-of-umil)

讨论可加微信（有交流群）：songbo236589

**古诗词数据库** 
由于数据过大提供以下链接：[https://pan.baidu.com/s/1S5flvzPmrIQTkm_SCbhTdw?pwd=v32l](https://pan.baidu.com/s/1S5flvzPmrIQTkm_SCbhTdw?pwd=v32l)

**在这里还做了对应的微信小程序，可以查看：**
![公众号](https://img.kancloud.cn/2a/3e/2a3e03cb805b053e5fc69ae441cb4cc8_344x344.jpg)![小程序](https://img.kancloud.cn/dd/74/dd74f74859f19f3f36257b329adec2de_344x344.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='作品表';
```

:-O礻大象/中国古诗词大全60万

About

Releases

Contributors

Activities