# 中国古诗词大全60万

**Repository Path**: code-ai/600000-chinese-ancient-poems

## Basic Information

- **Project Name**: 中国古诗词大全60万
- **Description**: 本仓库提供57万多古诗、词、曲、文言文。作者3.8万，为大家构建项目提供支持，并长期维护。
- **Primary Language**: SQL
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 21
- **Created**: 2022-12-13
- **Last Updated**: 2023-08-05

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 中国古诗词大全60万

#### 介绍
本仓库提供57万多古诗、词、曲、文言文。作者3.8万，为大家构建项目提供支持，并长期维护。


 **古诗词数据库** 
由于数据过大提供以下链接：[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='作品表';
```