目录搜索

暂无相关搜索结果！

本文档使用 MinDoc 发布

整体框架

功能介绍
数据采集
数据清洗
数据分析
数据服务
项目骨架
数据采集
数据清洗
数据分析
数据展示
使用案例
用户行为分析
开发说明
部署与测试

功能介绍

此大数据开发提供项目模板，支持数据采集、清洗、分析和统计、接口服务。此框架包括主要的处理步骤如下：

数据采集

1.1.1支持通过请求接口的方式进行采集，采集的数据同步到kafaka中
1.1.2支持通过logstash来采集，可以收集日志、DB数据、文件等（支持分布式部署），数据可以同步到kafaka（供进一步处理），也可以直接同步到ElasticSearch

数据清洗

1.2.1 从kafaka获取原始数据进行校验和处理后，对于符合要求的数据，存入DB（或大数据存储Hbase等）,也可以直接同步到ElasticSearch
1.2.2后续可以考虑引入Flink来进行实时清洗

数据分析

1.3.1对于清洗过的数据(存储在DB或HBase或ElasticSearch）,按照标签或模型进行统计和分析，相应的统计和计算结果进行存储到DB（或Redis或ElasticSearch）

数据服务

1.4.1提供apijson免后端编程框架，可以对数据按照APIJSON的规范进行调用
1.4.2对于ElasticSearch中存储的数据，提供相应的全文搜索服务

项目骨架

骨架示例：

模块说明如下：

数据采集

<module>dp-craw</module>

提供接口服务，目前接口数据同步到kafaka

数据清洗

<module>dp-sync</module>

从kafaka获取数据，进行清洗和处理，处理后数据可以通过内部接口进行储存（数据库），
同时也支持结果写入ElasticSearch中。

数据分析

<module>dp-algo</module>

根据业务需求，进行建立数据模型（DB中表模型），使用mybatis plus进行数据分析和计算处理，写入对应的结果表模型中，
同时支持，对相应的数据同步到ElasticSearch中。

数据展示

<module>dp-svc</module>

APIJSON框架代理，只需要按照APIJSON调用方式进行使用。

使用案例

用户行为分析

开发说明

需求说明：用户行为分析，是对所用园区用户的各端（PCweb、IOS、Android等）进行操作行为进行记录，根据记录的行为进行实时统计和分析，输出结果。
分析说明：目前通过实验和测试，采用美团开源日志Logan对各端（PCweb、IOS、Android等）进行采集数据，存储mysql中，根据定义维度进行分析，实时统计相应的结果，使用apijson进行免后端编码方式输出，结合前端图表进行实时展示。
各端数据采集标准定义：

类型	类型ID	收集内容	示例
新用户	101	AppID、渠道ID（即园区ID）、版本ID、设备平台ID、日志时间、用户唯一ID、账户唯一ID、页面路径
新账户	102	同上	同上（注册用户）
启动APP	103	同上	同上（包括用户和注册用户）
退出APP	104	同上	同上（包括用户和注册用户）
页面事件	105	同上	同上（包括用户和注册用户）

数据表模型定义：

127.0.0.1仅为参考，具体以实际分配地址为准

-- --------------------------------------------------------
-- 主机:                           127.0.0.1
-- 服务器版本:                        5.7.29-log - Source distribution
-- 服务器操作系统:                      Linux
-- HeidiSQL 版本:                  11.0.0.5919
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- 导出 pai-dp-data 的数据库结构
CREATE DATABASE IF NOT EXISTS `pai-dp-data` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `pai-dp-data`;

-- 导出  表 pai-dp-data.Access 结构
CREATE TABLE IF NOT EXISTS `Access` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `debug` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否为调试表，只允许在开发环境使用，测试和线上环境禁用',
  `name` varchar(50) NOT NULL COMMENT '实际表名，例如 apijson_user',
  `alias` varchar(20) DEFAULT NULL COMMENT '外部调用的表别名，例如 User',
  `get` varchar(100) NOT NULL DEFAULT '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 get 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]\n用 JSON 类型不能设置默认值，反正权限对应的需求是明确的，也不需要自动转 JSONArray。\nTODO: 直接 LOGIN,CONTACT,CIRCLE,OWNER 更简单，反正是开发内部用，不需要复杂查询。',
  `head` varchar(100) NOT NULL DEFAULT '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 head 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
  `gets` varchar(100) NOT NULL DEFAULT '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 gets 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
  `heads` varchar(100) NOT NULL DEFAULT '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 heads 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
  `post` varchar(100) NOT NULL DEFAULT '["OWNER", "ADMIN"]' COMMENT '允许 post 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
  `put` varchar(100) NOT NULL DEFAULT '["OWNER", "ADMIN"]' COMMENT '允许 put 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
  `delete` varchar(100) NOT NULL DEFAULT '["OWNER", "ADMIN"]' COMMENT '允许 delete 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`),
  UNIQUE KEY `alias_UNIQUE` (`alias`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='权限配置';

-- 正在导出表  pai-dp-data.Access 的数据：~19 rows (大约)
/*!40000 ALTER TABLE `Access` DISABLE KEYS */;
INSERT INTO `Access` (`id`, `debug`, `name`, `alias`, `get`, `head`, `gets`, `heads`, `post`, `put`, `delete`, `date`) VALUES
    (1, 0, 'Access', NULL, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2019-07-21 20:21:36'),
    (4, 0, 'Function', NULL, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2018-11-29 00:38:15'),
    (5, 0, 'Request', NULL, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2018-11-29 00:38:14'),
    (12, 0, 'Login', NULL, '[]', '[]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[ "ADMIN"]', '[ "ADMIN"]', '["ADMIN"]', '2018-11-29 00:29:48'),
    (13, 0, 'Verify', NULL, '[]', '[]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[ "ADMIN"]', '["ADMIN"]', '2018-11-29 00:29:48'),
    (14, 0, 'apijson_user', 'User', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2018-11-29 00:28:53'),
    (15, 0, 'apijson_privacy', 'Privacy', '[]', '[]', '["OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2018-11-29 00:29:48'),
    (25, 0, 'company_info', 'CompanyInfo', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-01 14:36:51'),
    (26, 0, 'company_finance', 'CompanyFinance', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-01 14:36:51'),
    (27, 0, 'company_original_info', 'CompanyOriginalInfo', '[]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-01 15:14:44'),
    (28, 0, 'company_original_revenue', 'OriginalRevenue', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-01 15:17:01'),
    (29, 0, 'user_tag', 'UserTag', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-15 15:53:07'),
    (30, 0, 'user_overview_data', 'OverviewData', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-15 15:53:07'),
    (31, 0, 'user_date_hour_data', 'DateHourData', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-15 15:53:07'),
    (32, 0, 'user_retention_data', 'RetentionData', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-15 15:53:07'),
    (33, 0, 'user_retention_calc_data', 'RetentionCalcData', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-15 15:53:07'),
    (34, 0, 'user_behavior_tag', 'BehaviorTag', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-28 10:29:48'),
    (35, 0, 'user_behavior_summary_data', 'BehaviorSummaryData', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-28 10:29:49'),
    (36, 0, 'user_behavior_daily_data', 'BehaviorDailyData', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-28 10:29:49'),
    (37, 0, 'user_tag_rank_data', 'TagRankData', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-28 11:05:01'),
    (38, 0, 'user_tag_daily_rank_data', 'TagDailyRankData', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2020-07-28 11:05:02');
/*!40000 ALTER TABLE `Access` ENABLE KEYS */;


-- 导出  表 pai-dp-data.company_finance 结构
CREATE TABLE IF NOT EXISTS `company_finance` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公司财务id',
  `unique_code` varchar(50) NOT NULL COMMENT '企业唯一码',
  `finance_month` int(11) NOT NULL COMMENT '公司财务月份',
  `production_value_month` decimal(11,2) DEFAULT NULL COMMENT '月产值',
  `production_value_total` decimal(11,2) DEFAULT NULL COMMENT '总产值',
  `production_value_last_year_month_rate` decimal(11,2) DEFAULT NULL COMMENT '月产值同比',
  `production_value_last_month_rate` decimal(11,2) DEFAULT NULL COMMENT '月产值环比',
  `tax_month` decimal(11,2) DEFAULT NULL COMMENT '月税费',
  `tax_total` decimal(11,2) DEFAULT NULL COMMENT '总税费',
  `tax_last_year_month_rate` decimal(11,2) DEFAULT NULL COMMENT '月税费同比',
  `tax_last_month_rate` decimal(11,2) DEFAULT NULL COMMENT '月税费环比',
  `revenue_month` decimal(11,2) DEFAULT NULL COMMENT '月营收',
  `revenue_total` decimal(11,2) DEFAULT NULL COMMENT '总营收',
  `revenue_last_year_month_rate` decimal(11,2) DEFAULT NULL COMMENT '月营收同比',
  `revenue_last_month_rate` decimal(11,2) DEFAULT NULL COMMENT '月营收环比',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `unique_code` (`unique_code`),
  KEY `finance_month` (`finance_month`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COMMENT='公司财务';

-- 正在导出表  pai-dp-data.company_finance 的数据：~33 rows (大约)
/*!40000 ALTER TABLE `company_finance` DISABLE KEYS */;
INSERT INTO `company_finance` (`id`, `unique_code`, `finance_month`, `production_value_month`, `production_value_total`, `production_value_last_year_month_rate`, `production_value_last_month_rate`, `tax_month`, `tax_total`, `tax_last_year_month_rate`, `tax_last_month_rate`, `revenue_month`, `revenue_total`, `revenue_last_year_month_rate`, `revenue_last_month_rate`, `create_time`, `update_time`) VALUES
    (1, 'unique_code_10000', 202005, 100.10, 20000.50, NULL, NULL, 15.00, 185.00, NULL, NULL, 150.30, 1000.20, NULL, NULL, '2020-06-19 07:02:09', '2020-07-03 12:55:21'),
    (2, 'unique_code_10000', 202004, 100.00, 19900.40, NULL, NULL, 10.00, 170.00, NULL, NULL, 100.00, 849.90, NULL, NULL, '2020-06-19 07:02:18', '2020-07-03 12:55:21'),
    (3, 'unique_code_10000', 202003, 100.00, 19800.40, NULL, NULL, 10.00, 160.00, NULL, NULL, 100.00, 749.90, NULL, NULL, '2020-06-19 07:02:18', '2020-07-03 12:55:21'),
    (4, 'unique_code_10000', 202002, 100.00, 19700.40, NULL, NULL, 10.00, 150.00, NULL, NULL, 100.00, 649.90, NULL, NULL, '2020-06-19 07:02:18', '2020-07-03 12:55:21'),
    (5, 'unique_code_10000', 202001, 100.00, 19600.40, NULL, NULL, 10.00, 140.00, NULL, NULL, 100.00, 549.90, NULL, NULL, '2020-06-19 07:02:18', '2020-07-03 12:55:21'),
    (6, 'unique_code_10000', 201912, 100.00, 19500.40, NULL, NULL, 10.00, 130.00, NULL, NULL, 100.00, 449.90, NULL, NULL, '2020-06-19 07:02:18', '2020-07-03 12:55:21'),
    (7, 'unique_code_10000', 201911, 100.00, 19300.40, NULL, NULL, 10.00, 120.00, NULL, NULL, 100.00, 349.90, NULL, NULL, '2020-06-19 07:02:19', '2020-07-03 12:55:21'),
    (8, 'unique_code_10000', 201910, 100.00, 19200.40, NULL, NULL, 10.00, 110.00, NULL, NULL, 100.00, 249.90, NULL, NULL, '2020-06-19 07:02:19', '2020-07-03 12:55:21'),
    (9, 'unique_code_10000', 201909, 100.00, 19100.40, NULL, NULL, 10.00, 100.00, NULL, NULL, 100.00, 149.90, NULL, NULL, '2020-06-19 07:02:19', '2020-07-03 12:55:22'),
    (10, 'unique_code_10000', 201908, 100.00, 19000.40, NULL, NULL, 10.00, 90.00, NULL, NULL, 49.90, 49.90, NULL, NULL, '2020-06-19 07:02:19', '2020-07-03 12:55:22'),
    (11, 'unique_code_10000', 201907, 10000.40, 18900.40, NULL, NULL, 10.00, 80.00, NULL, NULL, 0.00, 0.00, NULL, NULL, '2020-06-19 07:02:19', '2020-07-03 12:55:22'),
    (12, 'unique_code_10000', 201906, 8000.00, 8900.00, NULL, NULL, 10.00, 70.00, NULL, NULL, 0.00, 0.00, NULL, NULL, '2020-06-19 07:02:19', '2020-07-03 12:55:22'),
    (13, 'unique_code_10000', 201905, 900.00, 900.00, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, NULL, NULL, '2020-06-19 07:02:19', '2020-07-03 12:55:20'),
    (14, 'unique_code_10001', 202005, 100.10, 20000.50, NULL, NULL, 15.00, 185.00, NULL, NULL, 150.30, 1000.20, NULL, NULL, '2020-06-19 07:02:19', '2020-07-03 12:55:22'),
    (15, 'unique_code_10001', 202004, 100.00, 19900.40, NULL, NULL, 10.00, 170.00, NULL, NULL, 100.00, 849.90, NULL, NULL, '2020-06-19 07:02:19', '2020-07-03 12:55:22'),
    (16, 'unique_code_10001', 202003, 100.00, 19800.40, NULL, NULL, 10.00, 160.00, NULL, NULL, 100.00, 749.90, NULL, NULL, '2020-06-19 07:02:20', '2020-07-03 12:55:22'),
    (17, 'unique_code_10001', 202002, 100.00, 19700.40, NULL, NULL, 10.00, 150.00, NULL, NULL, 100.00, 649.90, NULL, NULL, '2020-06-19 07:02:20', '2020-07-03 12:55:22'),
    (18, 'unique_code_10001', 202001, 100.00, 19600.40, NULL, NULL, 10.00, 140.00, NULL, NULL, 100.00, 549.90, NULL, NULL, '2020-06-19 07:02:20', '2020-07-03 12:55:22'),
    (19, 'unique_code_10001', 201912, 100.00, 19500.40, NULL, NULL, 10.00, 130.00, NULL, NULL, 100.00, 449.90, NULL, NULL, '2020-06-19 07:02:20', '2020-07-03 12:55:22'),
    (20, 'unique_code_10001', 201911, 100.00, 19300.40, NULL, NULL, 10.00, 120.00, NULL, NULL, 100.00, 349.90, NULL, NULL, '2020-06-19 07:02:20', '2020-07-03 12:55:22'),
    (21, 'unique_code_10001', 201910, 100.00, 19200.40, NULL, NULL, 10.00, 110.00, NULL, NULL, 100.00, 249.90, NULL, NULL, '2020-06-19 07:02:20', '2020-07-03 12:55:22'),
    (22, 'unique_code_10001', 201909, 100.00, 19100.40, NULL, NULL, 10.00, 100.00, NULL, NULL, 100.00, 149.90, NULL, NULL, '2020-06-19 07:02:20', '2020-07-03 12:55:22'),
    (23, 'unique_code_10001', 201908, 100.00, 19000.40, NULL, NULL, 10.00, 90.00, NULL, NULL, 49.90, 49.90, NULL, NULL, '2020-06-19 07:02:20', '2020-07-03 12:55:22'),
    (24, 'unique_code_10001', 201907, 10000.40, 18900.40, NULL, NULL, 10.00, 80.00, NULL, NULL, 0.00, 0.00, NULL, NULL, '2020-06-19 07:02:20', '2020-07-03 12:55:22'),
    (25, 'unique_code_10001', 201906, 8000.00, 8900.00, NULL, NULL, 10.00, 70.00, NULL, NULL, 0.00, 0.00, NULL, NULL, '2020-06-19 07:02:20', '2020-07-03 12:55:22'),
    (26, 'unique_code_10001', 201905, 900.00, 900.00, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, NULL, NULL, '2020-06-19 07:02:21', '2020-07-03 12:55:21'),
    (27, 'unique_code_10000', 202006, NULL, NULL, NULL, NULL, 15.00, 200.00, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:03:26', '2020-07-03 12:55:21'),
    (28, 'unique_code_10031', 202006, 100.00, 1000.00, NULL, NULL, 10.00, 100.00, NULL, NULL, 50.00, 500.00, NULL, NULL, '2020-06-19 10:43:20', '2020-07-03 12:55:22'),
    (29, 'unique_code_10032', 202006, 100.00, 1000.00, NULL, NULL, 10.00, 100.00, NULL, NULL, 50.00, 500.00, NULL, NULL, '2020-06-20 01:16:30', '2020-07-03 12:55:23'),
    (30, 'unique_code_10033', 202006, 100.00, 1000.00, NULL, NULL, 10.00, 100.00, NULL, NULL, 50.00, 500.00, NULL, NULL, '2020-06-20 01:54:50', '2020-07-03 12:55:23'),
    (31, 'unique_code_10034', 202006, 100.00, 1000.00, NULL, NULL, 10.00, 100.00, NULL, NULL, 50.00, 500.00, NULL, NULL, '2020-06-20 10:06:30', '2020-07-03 12:55:23'),
    (32, 'unique_code_10035', 202006, 100.00, 1000.00, NULL, NULL, 10.00, 100.00, NULL, NULL, 50.00, 500.00, NULL, NULL, '2020-06-29 13:51:10', '2020-07-03 12:55:23'),
    (33, 'unique_code_10037', 202006, NULL, NULL, NULL, NULL, 20.00, 100.00, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-06 15:19:35', '2020-07-06 15:19:35');
/*!40000 ALTER TABLE `company_finance` ENABLE KEYS */;

-- 导出  表 pai-dp-data.company_info 结构
CREATE TABLE IF NOT EXISTS `company_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企业id',
  `unique_code` varchar(50) NOT NULL COMMENT '企业唯一码',
  `name` varchar(128) NOT NULL COMMENT '企业名',
  `area` decimal(11,2) DEFAULT NULL COMMENT '租园面积',
  `state` bit(1) NOT NULL COMMENT '在园状态',
  `enter_time` datetime NOT NULL COMMENT '入园时间',
  `out_time` datetime DEFAULT NULL COMMENT '离园时间',
  `high_tech` bit(1) DEFAULT NULL COMMENT '是否高企',
  `buz_type` int(11) DEFAULT NULL COMMENT '企业类型（1为个人，2为私营，3为内资，4为外资，5为分公司，6为中外合资）',
  `ipo_type` int(11) NOT NULL DEFAULT '0' COMMENT '企业上市类型（0为未上市，1为主板，2为新三板，3为创业板，4为科创板）',
  `industry_id` int(11) DEFAULT NULL COMMENT '行业类型id（1为新能源2为新材料，3为其他）',
  `industry_sub_id` int(11) DEFAULT NULL COMMENT '行业子类型id（1为新能源2为新材料，3为其他）',
  `park_id` int(11) NOT NULL COMMENT '所在园区id（1为南方软件园，2为清华园）',
  `address` varchar(128) DEFAULT NULL COMMENT '公司地址',
  `people` int(11) DEFAULT NULL COMMENT '企业人数',
  `financial_date` int(11) DEFAULT NULL COMMENT '财务年月',
  `tax_month` decimal(11,2) DEFAULT NULL COMMENT '月税收',
  `revenue_month` decimal(11,2) DEFAULT NULL COMMENT '月营收',
  `production_value_month` decimal(11,2) DEFAULT NULL COMMENT '月产值',
  `tax_total` decimal(11,2) DEFAULT NULL COMMENT '总税收',
  `revenue_total` decimal(11,2) DEFAULT NULL COMMENT '总营收',
  `production_value_total` decimal(11,2) DEFAULT NULL COMMENT '总产值',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `unique_code` (`unique_code`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COMMENT='公司信息表';

-- 正在导出表  pai-dp-data.company_info 的数据：~37 rows (大约)
/*!40000 ALTER TABLE `company_info` DISABLE KEYS */;
INSERT INTO `company_info` (`id`, `unique_code`, `name`, `area`, `state`, `enter_time`, `out_time`, `high_tech`, `buz_type`, `ipo_type`, `industry_id`, `industry_sub_id`, `park_id`, `address`, `people`, `financial_date`, `tax_month`, `revenue_month`, `production_value_month`, `tax_total`, `revenue_total`, `production_value_total`, `create_time`, `update_time`) VALUES
    (1, 'unique_code_10000', '测试1', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 1, NULL, 100, 202006, 15.00, NULL, NULL, 200.00, NULL, NULL, '2020-06-19 07:06:56', '2020-08-13 19:59:16'),
    (2, 'unique_code_10002', '测试2', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:07:58', '2020-08-13 19:59:16'),
    (3, 'unique_code_10003', '测试3', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:00', '2020-08-13 19:59:16'),
    (4, 'unique_code_10004', '测试4', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:02', '2020-08-13 19:59:16'),
    (5, 'unique_code_10005', '测试5', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:08', '2020-08-13 19:59:16'),
    (6, 'unique_code_10006', '测试6', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:08', '2020-08-13 19:59:16'),
    (7, 'unique_code_10007', '测试7', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'0', 2, 0, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:08', '2020-08-13 19:59:16'),
    (8, 'unique_code_10008', '测试8', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 2, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:08', '2020-08-13 19:59:16'),
    (9, 'unique_code_10009', '测试9', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 2, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:09', '2020-08-13 19:59:16'),
    (10, 'unique_code_10010', '测试10', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'0', 2, 0, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:09', '2020-08-13 19:59:16'),
    (11, 'unique_code_10011', '测试11', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'0', 2, 0, 1, 1, 2, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:09', '2020-08-13 19:59:16'),
    (12, 'unique_code_10012', '测试12', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 2, NULL, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:09', '2020-08-13 19:59:17'),
    (13, 'unique_code_10013', '测试13', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:09', '2020-08-13 19:59:17'),
    (14, 'unique_code_10014', '测试14', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 2, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:09', '2020-08-13 19:59:17'),
    (15, 'unique_code_10015', '测试15', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 2, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:09', '2020-08-13 19:59:17'),
    (16, 'unique_code_10016', '测试16', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:09', '2020-08-13 19:59:17'),
    (17, 'unique_code_10017', '测试17', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:10', '2020-08-13 19:59:17'),
    (18, 'unique_code_10018', '测试18', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:10', '2020-08-13 19:59:17'),
    (19, 'unique_code_10019', '测试19', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:10', '2020-08-13 19:59:17'),
    (20, 'unique_code_10020', '测试20', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 0, 1, 1, 1, NULL, 500, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:10', '2020-08-13 19:59:17'),
    (21, 'unique_code_10021', '测试21', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 1, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:10', '2020-08-13 19:59:17'),
    (22, 'unique_code_10022', '测试22', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 1, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:10', '2020-08-13 19:59:17'),
    (23, 'unique_code_10023', '测试23', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 1, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:10', '2020-08-13 19:59:17'),
    (24, 'unique_code_10024', '测试24', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 1, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:10', '2020-08-13 19:59:17'),
    (25, 'unique_code_10025', '测试25', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 1, 1, 1, 1, NULL, 1000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:10', '2020-08-13 19:59:17'),
    (26, 'unique_code_10026', '测试26', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 1, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:10', '2020-08-13 19:59:17'),
    (27, 'unique_code_10027', '测试27', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 1, 1, 2, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:11', '2020-08-13 19:59:17'),
    (28, 'unique_code_10028', '测试28', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:11', '2020-08-13 19:59:17'),
    (29, 'unique_code_10029', '测试29', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:11', '2020-08-13 19:59:17'),
    (30, 'unique_code_10030', '测试30', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 3, 1, 1, 1, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-19 07:08:11', '2020-08-13 19:59:17'),
    (31, 'unique_code_10001', '测试31', 10.00, b'1', '2020-06-19 08:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, 202005, 15.00, 150.30, 100.10, 185.00, 1000.20, 20000.50, '2020-06-19 09:29:46', '2020-08-13 19:59:17'),
    (32, 'unique_code_10031', '测试32', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, 202006, 10.00, 50.00, 100.00, 100.00, 500.00, 1000.00, '2020-06-19 10:44:40', '2020-08-13 19:59:17'),
    (33, 'unique_code_10032', '测试32', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, 202006, 10.00, 50.00, 100.00, 100.00, 500.00, 1000.00, '2020-06-20 01:14:00', '2020-08-13 19:59:17'),
    (34, 'unique_code_10033', '测试33', 10.00, b'1', '2020-06-19 08:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, 202006, 10.00, 50.00, 100.00, 100.00, 500.00, 1000.00, '2020-06-20 01:55:10', '2020-08-13 19:59:17'),
    (35, 'unique_code_10034', '测试34', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, 202006, 10.00, 50.00, 100.00, 100.00, 500.00, 1000.00, '2020-06-20 10:07:00', '2020-08-13 19:59:17'),
    (36, 'unique_code_10035', '测试35', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-29 13:50:10', '2020-08-13 19:59:17'),
    (37, 'unique_code_10040', '测试40', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-08 17:33:30', '2020-08-13 19:59:17'),
    (46, 'unique_code_10083', '测试83', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-17 15:06:30', '2020-08-13 19:59:17'),
    (47, 'unique_code_10084', '测试84', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-17 15:08:40', '2020-08-13 19:59:17'),
    (48, 'unique_code_10085', '测试85', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-23 11:20:20', '2020-08-13 19:59:17'),
    (49, 'unique_code_10086', '测试86', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-24 12:56:45', '2020-08-13 19:59:17'),
    (50, 'unique_code_10087', '测试87', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-28 17:08:55', '2020-08-13 19:59:17'),
    (51, 'unique_code_10088', '测试88', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-03 14:44:20', '2020-08-13 19:59:17'),
    (52, 'unique_code_10089', '测试89', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 1, NULL, NULL, 2, NULL, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-03 14:56:35', '2020-08-13 19:59:17');
/*!40000 ALTER TABLE `company_info` ENABLE KEYS */;

-- 导出  表 pai-dp-data.company_original_info 结构
CREATE TABLE IF NOT EXISTS `company_original_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企业id',
  `name` varchar(128) NOT NULL COMMENT '企业名',
  `unique_code` varchar(50) NOT NULL COMMENT '企业唯一码',
  `area` decimal(11,2) DEFAULT NULL COMMENT '租园面积',
  `state` bit(1) NOT NULL COMMENT '在园状态',
  `enter_time` datetime NOT NULL COMMENT '入园时间',
  `out_time` datetime DEFAULT NULL COMMENT '离园时间',
  `high_tech` bit(1) DEFAULT NULL COMMENT '是否高企',
  `buz_type` int(11) DEFAULT NULL COMMENT '企业类型（1为个人，2为私营，3为内资，4为外资，5为分公司，6为中外合资）',
  `enter_type` int(11) DEFAULT NULL COMMENT '入驻类型（1为注册，2为租赁，3为购买）',
  `from_source` int(11) DEFAULT NULL COMMENT '来源方式（1为自主开发，2为企业介绍，3为主动上门，4为招商会，5为其他方式）',
  `from_type` int(11) DEFAULT NULL COMMENT '来源类型（1为内部，2为外部）',
  `ipo_type` int(11) NOT NULL DEFAULT '0' COMMENT '企业上市类型（0为未上市，1为主板，2为新三板，3为创业板，4为科创板）',
  `industry_id` int(11) DEFAULT NULL COMMENT '行业类型id（1为新能源2为新材料，3为其他）',
  `industry_sub_id` int(11) DEFAULT NULL COMMENT '行业子类型id（1为新能源2为新材料，3为其他）',
  `park_id` int(11) NOT NULL COMMENT '所在园区id（1为南方软件园，2为清华园）',
  `address` varchar(128) DEFAULT NULL COMMENT '公司地址',
  `phone` varchar(50) DEFAULT NULL COMMENT '公司电话',
  `fax` varchar(50) DEFAULT NULL COMMENT '公司传真',
  `website` varchar(50) DEFAULT NULL COMMENT '公司网址',
  `contract_people` varchar(50) DEFAULT NULL COMMENT '联系人',
  `contract_phone` varchar(50) DEFAULT NULL COMMENT '联系电话',
  `contract_position` varchar(50) DEFAULT NULL COMMENT '联系人职务',
  `contract_email` varchar(50) DEFAULT NULL COMMENT '联系人邮箱',
  `contract_qq` varchar(50) DEFAULT NULL COMMENT '联系人qq',
  `people` int(11) DEFAULT NULL COMMENT '企业人数',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `unique_code` (`unique_code`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COMMENT='公司原始信息表';

-- 正在导出表  pai-dp-data.company_original_info 的数据：~40 rows (大约)
/*!40000 ALTER TABLE `company_original_info` DISABLE KEYS */;
INSERT INTO `company_original_info` (`id`, `name`, `unique_code`, `area`, `state`, `enter_time`, `out_time`, `high_tech`, `buz_type`, `enter_type`, `from_source`, `from_type`, `ipo_type`, `industry_id`, `industry_sub_id`, `park_id`, `address`, `phone`, `fax`, `website`, `contract_people`, `contract_phone`, `contract_position`, `contract_email`, `contract_qq`, `people`, `create_time`, `update_time`) VALUES
    (1, '测试1', 'unique_code_10000', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三1', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (2, '测试2', 'unique_code_10002', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三2', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (3, '测试3', 'unique_code_10003', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三3', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (4, '测试4', 'unique_code_10004', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三4', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (5, '测试5', 'unique_code_10005', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三5', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (6, '测试6', 'unique_code_10006', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三6', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (7, '测试7', 'unique_code_10007', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'0', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三7', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (8, '测试8', 'unique_code_10008', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 2, NULL, NULL, NULL, NULL, '张三8', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (9, '测试9', 'unique_code_10009', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 2, NULL, NULL, NULL, NULL, '张三9', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (10, '测试10', 'unique_code_10010', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'0', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三10', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (11, '测试11', 'unique_code_10011', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'0', 2, 2, 3, 2, 0, 1, 1, 2, NULL, NULL, NULL, NULL, '张三11', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (12, '测试12', 'unique_code_10012', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 2, NULL, NULL, NULL, NULL, '张三12', NULL, NULL, NULL, NULL, 50, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (13, '测试13', 'unique_code_10013', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三13', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (14, '测试14', 'unique_code_10014', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 2, NULL, NULL, NULL, NULL, '张三14', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (15, '测试15', 'unique_code_10015', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 2, NULL, NULL, NULL, NULL, '张三15', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (16, '测试16', 'unique_code_10016', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三16', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (17, '测试17', 'unique_code_10017', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三17', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (18, '测试18', 'unique_code_10018', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三18', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (19, '测试19', 'unique_code_10019', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三19', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (20, '测试20', 'unique_code_10020', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 0, 1, 1, 1, NULL, NULL, NULL, NULL, '张三20', NULL, NULL, NULL, NULL, 500, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (21, '测试21', 'unique_code_10021', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 1, 1, 1, 1, NULL, NULL, NULL, NULL, '张三21', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (22, '测试22', 'unique_code_10022', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 1, 1, 1, 1, NULL, NULL, NULL, NULL, '张三22', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (23, '测试23', 'unique_code_10023', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 1, 1, 1, 1, NULL, NULL, NULL, NULL, '张三23', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (24, '测试24', 'unique_code_10024', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 1, 1, 1, 1, NULL, NULL, NULL, NULL, '张三24', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (25, '测试25', 'unique_code_10025', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 1, 1, 1, 1, NULL, NULL, NULL, NULL, '张三25', NULL, NULL, NULL, NULL, 1000, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (26, '测试26', 'unique_code_10026', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 1, 1, 1, 1, NULL, NULL, NULL, NULL, '张三26', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (27, '测试27', 'unique_code_10027', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 2, 1, 1, 2, NULL, NULL, NULL, NULL, '张三27', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (28, '测试28', 'unique_code_10028', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 2, 1, 1, 1, NULL, NULL, NULL, NULL, '张三28', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (29, '测试29', 'unique_code_10029', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 2, 1, 1, 1, NULL, NULL, NULL, NULL, '张三29', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (30, '测试30', 'unique_code_10030', 200.00, b'1', '2020-06-19 05:59:42', '2030-06-19 05:59:44', b'1', 2, 2, 3, 2, 3, 1, 1, 1, NULL, NULL, NULL, NULL, '张三30', NULL, NULL, NULL, NULL, 100, '2021-06-19 06:02:09', '2021-06-19 06:02:10'),
    (31, '测试31', 'unique_code_10001', 10.00, b'1', '2020-06-19 08:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-06-19 09:28:30', '2020-06-19 09:28:30'),
    (32, '测试31', 'unique_code_10001', 10.00, b'1', '2020-06-19 08:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-06-19 09:31:52', '2020-06-19 09:31:52'),
    (33, '测试31', 'unique_code_10001', 10.00, b'1', '2020-06-19 08:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-06-19 09:41:35', '2020-06-19 09:41:35'),
    (34, '测试31', 'unique_code_10001', 10.00, b'1', '2020-06-19 08:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-06-19 09:42:24', '2020-06-19 09:42:24'),
    (35, '测试32', 'unique_code_10031', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-06-19 10:44:34', '2020-06-19 10:44:34'),
    (36, '测试32', 'unique_code_10032', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-06-20 01:13:50', '2020-06-20 01:13:50'),
    (37, '测试32', 'unique_code_10032', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-06-20 01:17:08', '2020-06-20 01:17:08'),
    (38, '测试33', 'unique_code_10033', 10.00, b'1', '2020-06-19 08:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-06-20 01:55:02', '2020-06-20 01:55:02'),
    (39, '测试34', 'unique_code_10034', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-06-20 10:06:57', '2020-06-20 10:06:57'),
    (40, '测试35', 'unique_code_10035', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-06-29 13:50:06', '2020-06-29 13:50:06'),
    (41, '测试40', 'unique_code_10040', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-07-08 17:33:28', '2020-07-08 17:33:28'),
    (51, '测试83', 'unique_code_10083', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-07-17 15:06:27', '2020-07-17 15:06:27'),
    (52, '测试84', 'unique_code_10084', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-07-17 15:08:37', '2020-07-17 15:08:37'),
    (53, '测试85', 'unique_code_10085', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-07-23 11:20:19', '2020-07-23 11:20:19'),
    (54, '测试86', 'unique_code_10086', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-07-24 12:56:43', '2020-07-24 12:56:43'),
    (55, '测试87', 'unique_code_10087', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-07-28 17:08:55', '2020-07-28 17:08:55'),
    (56, '测试88', 'unique_code_10088', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-08-03 14:44:16', '2020-08-03 14:44:16'),
    (57, '测试89', 'unique_code_10089', 10.00, b'1', '2020-06-19 16:00:00', NULL, b'0', 2, 2, 2, 2, 1, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50, '2020-08-03 14:56:31', '2020-08-03 14:56:31');
/*!40000 ALTER TABLE `company_original_info` ENABLE KEYS */;

-- 导出  表 pai-dp-data.company_original_revenue 结构
CREATE TABLE IF NOT EXISTS `company_original_revenue` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公司财务id',
  `unique_code` varchar(50) NOT NULL COMMENT '企业唯一码',
  `month` int(11) NOT NULL COMMENT '公司财务月份',
  `production_value_month` decimal(11,2) NOT NULL COMMENT '月产值',
  `production_value_total` decimal(11,2) DEFAULT NULL COMMENT '总产值',
  `revenue_month` decimal(11,2) NOT NULL COMMENT '月营收',
  `revenue_total` decimal(11,2) DEFAULT NULL COMMENT '总营收',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `unique_code` (`unique_code`),
  KEY `month` (`month`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COMMENT='公司原始收入';

-- 正在导出表  pai-dp-data.company_original_revenue 的数据：~31 rows (大约)
/*!40000 ALTER TABLE `company_original_revenue` DISABLE KEYS */;
INSERT INTO `company_original_revenue` (`id`, `unique_code`, `month`, `production_value_month`, `production_value_total`, `revenue_month`, `revenue_total`, `create_time`, `update_time`) VALUES
    (1, 'unique_code_10000', 202005, 100.10, 20000.50, 150.30, 1000.20, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (2, 'unique_code_10000', 202004, 100.00, 19900.40, 100.00, 849.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (3, 'unique_code_10000', 202003, 100.00, 19800.40, 100.00, 749.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (4, 'unique_code_10000', 202002, 100.00, 19700.40, 100.00, 649.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (5, 'unique_code_10000', 202001, 100.00, 19600.40, 100.00, 549.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (6, 'unique_code_10000', 201912, 100.00, 19500.40, 100.00, 449.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (7, 'unique_code_10000', 201911, 100.00, 19300.40, 100.00, 349.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (8, 'unique_code_10000', 201910, 100.00, 19200.40, 100.00, 249.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (9, 'unique_code_10000', 201909, 100.00, 19100.40, 100.00, 149.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (10, 'unique_code_10000', 201908, 100.00, 19000.40, 49.90, 49.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (11, 'unique_code_10000', 201907, 10000.40, 18900.40, 0.00, 0.00, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (12, 'unique_code_10000', 201906, 8000.00, 8900.00, 0.00, 0.00, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (13, 'unique_code_10000', 201905, 900.00, 900.00, 0.00, 0.00, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (14, 'unique_code_10001', 202005, 100.10, 20000.50, 150.30, 1000.20, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (15, 'unique_code_10001', 202004, 100.00, 19900.40, 100.00, 849.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (16, 'unique_code_10001', 202003, 100.00, 19800.40, 100.00, 749.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (17, 'unique_code_10001', 202002, 100.00, 19700.40, 100.00, 649.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (18, 'unique_code_10001', 202001, 100.00, 19600.40, 100.00, 549.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (19, 'unique_code_10001', 201912, 100.00, 19500.40, 100.00, 449.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (20, 'unique_code_10001', 201911, 100.00, 19300.40, 100.00, 349.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (21, 'unique_code_10001', 201910, 100.00, 19200.40, 100.00, 249.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (22, 'unique_code_10001', 201909, 100.00, 19100.40, 100.00, 149.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (23, 'unique_code_10001', 201908, 100.00, 19000.40, 49.90, 49.90, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (24, 'unique_code_10001', 201907, 10000.40, 18900.40, 0.00, 0.00, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (25, 'unique_code_10001', 201906, 8000.00, 8900.00, 0.00, 0.00, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (26, 'unique_code_10001', 201905, 900.00, 900.00, 0.00, 0.00, '2020-06-19 06:04:29', '2020-06-19 06:04:31'),
    (27, 'unique_code_10031', 202006, 100.00, 1000.00, 50.00, 500.00, '2020-06-19 10:44:02', '2020-06-19 10:44:02'),
    (28, 'unique_code_10032', 202006, 100.00, 1000.00, 50.00, 500.00, '2020-06-20 01:16:24', '2020-06-20 01:16:24'),
    (29, 'unique_code_10033', 202006, 100.00, 1000.00, 50.00, 500.00, '2020-06-20 01:54:50', '2020-06-20 01:54:50'),
    (30, 'unique_code_10034', 202006, 100.00, 1000.00, 50.00, 500.00, '2020-06-20 10:06:46', '2020-06-20 10:06:46'),
    (31, 'unique_code_10035', 202006, 100.00, 1000.00, 50.00, 500.00, '2020-06-29 13:51:18', '2020-06-29 13:51:18');
/*!40000 ALTER TABLE `company_original_revenue` ENABLE KEYS */;

-- 导出  表 pai-dp-data.company_original_tax 结构
CREATE TABLE IF NOT EXISTS `company_original_tax` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公司财务id',
  `unique_code` varchar(50) NOT NULL COMMENT '企业唯一码',
  `month` int(11) NOT NULL COMMENT '公司财务月份',
  `tax_month` decimal(11,2) NOT NULL COMMENT '月税费',
  `tax_total` decimal(11,2) DEFAULT NULL COMMENT '总税费',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `unique_code` (`unique_code`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COMMENT='公司原始税收';

-- 正在导出表  pai-dp-data.company_original_tax 的数据：~31 rows (大约)
/*!40000 ALTER TABLE `company_original_tax` DISABLE KEYS */;
INSERT INTO `company_original_tax` (`id`, `unique_code`, `month`, `tax_month`, `tax_total`, `create_time`, `update_time`) VALUES
    (1, 'unique_code_10000', 202006, 15.00, 200.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (2, 'unique_code_10000', 202005, 15.00, 185.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (3, 'unique_code_10000', 202004, 10.00, 170.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (4, 'unique_code_10000', 202003, 10.00, 160.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (5, 'unique_code_10000', 202002, 10.00, 150.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (6, 'unique_code_10000', 202001, 10.00, 140.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (7, 'unique_code_10000', 201912, 10.00, 130.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (8, 'unique_code_10000', 201911, 10.00, 120.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (9, 'unique_code_10000', 201910, 10.00, 110.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (10, 'unique_code_10000', 201909, 10.00, 100.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (11, 'unique_code_10000', 201908, 10.00, 90.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (12, 'unique_code_10000', 201907, 10.00, 80.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (13, 'unique_code_10000', 201906, 10.00, 70.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (14, 'unique_code_10001', 202005, 15.00, 185.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (15, 'unique_code_10001', 202004, 10.00, 170.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (16, 'unique_code_10001', 202003, 10.00, 160.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (17, 'unique_code_10001', 202002, 10.00, 150.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (18, 'unique_code_10001', 202001, 10.00, 140.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (19, 'unique_code_10001', 201912, 10.00, 130.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (20, 'unique_code_10001', 201911, 10.00, 120.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (21, 'unique_code_10001', 201910, 10.00, 110.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (22, 'unique_code_10001', 201909, 10.00, 100.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (23, 'unique_code_10001', 201908, 10.00, 90.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (24, 'unique_code_10001', 201907, 10.00, 80.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (25, 'unique_code_10001', 201906, 10.00, 70.00, '2021-06-19 06:13:56', '2021-06-19 06:13:58'),
    (26, 'unique_code_10031', 202006, 10.00, 100.00, '2020-06-19 10:43:10', '2020-06-19 10:43:10'),
    (27, 'unique_code_10032', 202006, 10.00, 100.00, '2020-06-20 01:16:36', '2020-06-20 01:16:36'),
    (28, 'unique_code_10033', 202006, 10.00, 100.00, '2020-06-20 01:54:40', '2020-06-20 01:54:40'),
    (29, 'unique_code_10034', 202006, 10.00, 100.00, '2020-06-20 10:06:29', '2020-06-20 10:06:29'),
    (30, 'unique_code_10035', 202006, 10.00, 100.00, '2020-06-29 13:51:08', '2020-06-29 13:51:08'),
    (31, 'unique_code_10037', 202006, 20.00, 100.00, '2020-07-06 15:19:34', '2020-07-06 15:19:34');
/*!40000 ALTER TABLE `company_original_tax` ENABLE KEYS */;

-- 导出  表 pai-dp-data.company_staff 结构
CREATE TABLE IF NOT EXISTS `company_staff` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '员工id',
  `unique_code` varchar(50) NOT NULL COMMENT '企业唯一码',
  `name` varchar(50) NOT NULL COMMENT '姓名',
  `education` int(11) NOT NULL COMMENT '学历（1.大专以下，2为大专，3为本科，4为硕士，5为博士，6为其他）',
  `employ_time` datetime NOT NULL COMMENT '入职时间',
  `employed` bit(1) DEFAULT NULL COMMENT '雇佣状态',
  `leave_time` datetime DEFAULT NULL COMMENT '离职时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `unique_code` (`unique_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='公司员工表';

-- 正在导出表  pai-dp-data.company_staff 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `company_staff` DISABLE KEYS */;
/*!40000 ALTER TABLE `company_staff` ENABLE KEYS */;

-- 导出  表 pai-dp-data.user_behavior_tag 结构
CREATE TABLE IF NOT EXISTS `user_behavior_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '标签ID',
  `name` varchar(128) NOT NULL COMMENT '标签名',
  `key` varchar(128) NOT NULL COMMENT '标签key',
  `valid` bit(1) NOT NULL COMMENT '是否有效',
  `show` bit(1) NOT NULL COMMENT '是否展示',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`),
  KEY `show` (`show`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='单个用户行为标签';

-- 正在导出表  pai-dp-data.user_behavior_tag 的数据：~3 rows (大约)
/*!40000 ALTER TABLE `user_behavior_tag` DISABLE KEYS */;
INSERT INTO `user_behavior_tag` (`id`, `name`, `key`, `valid`, `show`, `create_time`, `update_time`) VALUES
    (1, '启动次数', 'launch', b'1', b'1', '2020-07-27 17:16:52', '2020-07-27 17:16:55'),
    (2, '点击页面数', 'page', b'1', b'1', '2020-07-27 17:18:46', '2020-07-27 17:18:51'),
    (3, '使用总时长', 'time', b'0', b'0', '2020-07-27 17:21:17', '2020-07-27 17:21:19');
/*!40000 ALTER TABLE `user_behavior_tag` ENABLE KEYS */;

-- 导出  表 pai-dp-data.user_tag 结构
CREATE TABLE IF NOT EXISTS `user_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '标签ID',
  `name` varchar(128) NOT NULL COMMENT '标签名',
  `key` varchar(128) NOT NULL COMMENT '标签key',
  `valid` bit(1) NOT NULL COMMENT '是否有效',
  `show` bit(1) NOT NULL COMMENT '是否展示',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`),
  KEY `show` (`show`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='用户标签';

-- 正在导出表  pai-dp-data.user_tag 的数据：~5 rows (大约)
/*!40000 ALTER TABLE `user_tag` DISABLE KEYS */;
INSERT INTO `user_tag` (`id`, `name`, `key`, `valid`, `show`, `create_time`, `update_time`) VALUES
    (1, '新增用户', 'newUser', b'1', b'1', '2020-07-15 16:34:40', '2020-07-15 16:34:42'),
    (2, '新增账户', 'newAccount', b'1', b'1', '2020-07-15 16:34:40', '2020-07-15 16:34:42'),
    (3, '活跃账户', 'activeAccount', b'1', b'1', '2020-07-15 16:34:40', '2020-07-15 16:34:42'),
    (4, '启动次数', 'launch', b'1', b'1', '2020-07-15 16:34:40', '2020-07-15 16:34:42'),
    (7, '页面访问数', 'page', b'1', b'1', '2020-07-28 11:58:49', '2020-07-28 11:58:51');
/*!40000 ALTER TABLE `user_tag` ENABLE KEYS */;

-- 导出  表 pai-dp-data.logan_log_detail 结构
CREATE TABLE IF NOT EXISTS `logan_log_detail` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `task_id` bigint(20) unsigned NOT NULL COMMENT '所属任务id',
  `log_type` int(10) unsigned NOT NULL COMMENT '日志类型',
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '原始日志',
  `log_time` bigint(20) unsigned NOT NULL COMMENT '本条日志产生的具体时间戳',
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '添加时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_update_time` (`update_time`),
  KEY `idx_task_id` (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14418 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='日志解析后的数据详情';

-- 数据导出被取消选择。

-- 导出  表 pai-dp-data.logan_task 结构
CREATE TABLE IF NOT EXISTS `logan_task` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `platform` tinyint(3) unsigned NOT NULL COMMENT '平台1android2iOS',
  `amount` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '文件大小',
  `app_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'app标识',
  `union_id` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户标识',
  `device_id` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '设备标识',
  `app_version` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'app版本',
  `build_version` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '构建版本',
  `log_file_name` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '日志文件所在路径',
  `log_date` bigint(20) unsigned DEFAULT NULL COMMENT '日志所属日期',
  `add_time` bigint(20) unsigned NOT NULL COMMENT '业务字段，日志上报时间',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0未分析过,1分析过',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_update_time` (`update_time`)
) ENGINE=InnoDB AUTO_INCREMENT=1186 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='上报日志任务表';

-- 数据导出被取消选择。

-- 导出  表 pai-dp-data.user_behavior_daily_data 结构
CREATE TABLE IF NOT EXISTS `user_behavior_daily_data` (
  `id` bigint(20) NOT NULL COMMENT '雪花算法生成ID',
  `appkey` varchar(128) NOT NULL COMMENT '账户ID',
  `channels` varchar(128) NOT NULL COMMENT '渠道名称',
  `versions` varchar(128) DEFAULT NULL COMMENT '版本名称',
  `account_id` varchar(128) NOT NULL COMMENT '账户ID',
  `behavior_key` varchar(128) NOT NULL COMMENT '行为key',
  `date` date NOT NULL COMMENT '日期',
  `value` int(11) NOT NULL COMMENT '值',
  `valid` bit(1) NOT NULL COMMENT '是否有效',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更细时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='单个用户每日数据';

-- 数据导出被取消选择。

-- 导出  表 pai-dp-data.user_behavior_record 结构
CREATE TABLE IF NOT EXISTS `user_behavior_record` (
  `id` bigint(20) NOT NULL COMMENT '雪花算法生成id',
  `type_id` int(11) NOT NULL COMMENT '类型ID,101为新用户，102为新账户，103为启动，104为退出',
  `appkey` varchar(128) NOT NULL COMMENT '应用 ID',
  `channels` varchar(128) NOT NULL COMMENT '渠道名称',
  `versions` varchar(128) DEFAULT NULL COMMENT '版本名称',
  `date` datetime NOT NULL COMMENT '操作时间',
  `user_id` varchar(128) NOT NULL COMMENT '用户唯一ID',
  `account_id` varchar(128) DEFAULT NULL COMMENT '账户唯一ID',
  `platform` varchar(128) NOT NULL COMMENT '平台类型',
  `path` varchar(128) DEFAULT NULL COMMENT '页面路径',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户行为实时记录';

-- 数据导出被取消选择。

-- 导出  表 pai-dp-data.user_behavior_summary_data 结构
CREATE TABLE IF NOT EXISTS `user_behavior_summary_data` (
  `id` bigint(20) NOT NULL COMMENT '雪花算法生成ID',
  `appkey` varchar(128) NOT NULL COMMENT 'APPID',
  `channels` varchar(128) NOT NULL COMMENT '渠道名称',
  `versions` varchar(128) DEFAULT NULL COMMENT '版本名称',
  `account_id` varchar(128) NOT NULL COMMENT '账户ID',
  `behavior_key` varchar(128) NOT NULL COMMENT '行为key',
  `value` int(11) NOT NULL COMMENT '值',
  `valid` bit(1) NOT NULL COMMENT '是否有效',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更细时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='单个用户统计数据';

-- 数据导出被取消选择。

-- 导出  表 pai-dp-data.user_date_hour_data 结构
CREATE TABLE IF NOT EXISTS `user_date_hour_data` (
  `id` bigint(20) NOT NULL COMMENT '雪花算法生成id',
  `appkey` varchar(128) NOT NULL COMMENT '应用 ID',
  `channels` varchar(128) NOT NULL COMMENT '渠道名称',
  `versions` varchar(128) DEFAULT NULL COMMENT '版本名称',
  `date_hour` datetime NOT NULL COMMENT '日期小时',
  `tag_key` varchar(128) NOT NULL COMMENT '用户标签key',
  `value` int(11) NOT NULL COMMENT '数量',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='每日小时数据';

-- 数据导出被取消选择。

-- 导出  表 pai-dp-data.user_overview_data 结构
CREATE TABLE IF NOT EXISTS `user_overview_data` (
  `id` bigint(20) NOT NULL COMMENT '雪花算法生成id',
  `appkey` varchar(128) NOT NULL COMMENT '应用 ID',
  `channels` varchar(128) NOT NULL COMMENT '渠道名称',
  `versions` varchar(128) DEFAULT NULL COMMENT '版本名称',
  `date` date NOT NULL COMMENT '日期',
  `tag_key` varchar(128) NOT NULL COMMENT '用户标签key',
  `value` int(11) NOT NULL COMMENT '数量',
  `rate` decimal(10,2) NOT NULL COMMENT '比率',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='每日总览数据';

-- 数据导出被取消选择。

-- 导出  表 pai-dp-data.user_retention_calc_data 结构
CREATE TABLE IF NOT EXISTS `user_retention_calc_data` (
  `id` bigint(20) NOT NULL COMMENT '雪花算法生成id',
  `retention_data_id` bigint(20) NOT NULL COMMENT 'user_retention_data的id',
  `date` date NOT NULL COMMENT '统计日期',
  `value` int(11) NOT NULL COMMENT '数量',
  `rate` decimal(10,2) NOT NULL COMMENT '比率',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='每日留存计算数据';

-- 数据导出被取消选择。

-- 导出  表 pai-dp-data.user_retention_data 结构
CREATE TABLE IF NOT EXISTS `user_retention_data` (
  `id` bigint(20) NOT NULL COMMENT '雪花算法生成id',
  `appkey` varchar(128) NOT NULL COMMENT '应用 ID',
  `channels` varchar(128) NOT NULL COMMENT '渠道名称',
  `versions` varchar(128) DEFAULT NULL COMMENT '版本名称',
  `date` date NOT NULL COMMENT '日期',
  `tag_key` varchar(128) NOT NULL COMMENT '用户标签key',
  `value` int(11) NOT NULL COMMENT '数量',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='每日留存数据';

-- 数据导出被取消选择。

-- 导出  表 pai-dp-data.user_tag_daily_rank_data 结构
CREATE TABLE IF NOT EXISTS `user_tag_daily_rank_data` (
  `id` bigint(20) NOT NULL COMMENT '雪花算法生成id',
  `appkey` varchar(128) NOT NULL COMMENT '应用 ID',
  `channels` varchar(128) NOT NULL COMMENT '渠道名称',
  `versions` varchar(128) DEFAULT NULL COMMENT '版本名称',
  `tag_key` varchar(128) NOT NULL COMMENT '用户标签key',
  `date` date NOT NULL COMMENT '日期',
  `name` varchar(128) NOT NULL COMMENT '名称',
  `value` int(11) NOT NULL COMMENT '数量',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户标签每日排行';

-- 数据导出被取消选择。

-- 导出  表 pai-dp-data.user_tag_rank_data 结构
CREATE TABLE IF NOT EXISTS `user_tag_rank_data` (
  `id` bigint(20) NOT NULL COMMENT '雪花算法生成id',
  `appkey` varchar(128) NOT NULL COMMENT '应用 ID',
  `channels` varchar(128) NOT NULL COMMENT '渠道名称',
  `versions` varchar(128) DEFAULT NULL COMMENT '版本名称',
  `tag_key` varchar(128) NOT NULL COMMENT '用户标签key',
  `name` varchar(128) NOT NULL COMMENT '名称',
  `value` int(11) NOT NULL COMMENT '数量',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户标签总排行';

-- 数据导出被取消选择。

-- 导出  表 pai-dp-data.web_detail 结构
CREATE TABLE IF NOT EXISTS `web_detail` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `task_id` bigint(20) NOT NULL COMMENT '所属任务id',
  `log_type` int(11) NOT NULL COMMENT '日志类型',
  `content` mediumtext NOT NULL COMMENT '日志内容',
  `log_time` bigint(20) NOT NULL COMMENT '日志所属时间',
  `log_level` int(11) DEFAULT NULL COMMENT '日志等级',
  `add_time` bigint(20) NOT NULL COMMENT '添加时间',
  `minute_offset` int(11) NOT NULL COMMENT '距离当天0点的分钟数',
  PRIMARY KEY (`id`),
  KEY `taskid_logtype` (`task_id`,`log_type`)
) ENGINE=InnoDB AUTO_INCREMENT=1905 DEFAULT CHARSET=utf8 COMMENT='H5日志详情表';

-- 数据导出被取消选择。

-- 导出  表 pai-dp-data.web_task 结构
CREATE TABLE IF NOT EXISTS `web_task` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `device_id` varchar(128) NOT NULL DEFAULT '' COMMENT '设备id',
  `web_source` varchar(128) DEFAULT NULL COMMENT '来源',
  `environment` varchar(2048) DEFAULT NULL COMMENT '客户端自定义环境信息',
  `page_num` int(11) NOT NULL COMMENT '日志页码',
  `content` mediumtext NOT NULL COMMENT '日志内容',
  `add_time` bigint(20) NOT NULL COMMENT '添加时间',
  `log_date` bigint(20) NOT NULL COMMENT '日志所属日期',
  `status` int(11) NOT NULL COMMENT '日志状态0未解析，1已解析',
  `custom_report_info` varchar(2048) DEFAULT NULL COMMENT '自定义上报信息',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `log_date_deviceid` (`log_date`,`device_id`),
  KEY `add_time_deviceid` (`add_time`,`device_id`),
  KEY `idx_update_time` (`update_time`)
) ENGINE=InnoDB AUTO_INCREMENT=1688 DEFAULT CHARSET=utf8 COMMENT='H5上报任务表';

-- 数据导出被取消选择。

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

开发步骤：
1.使用pai工具创建【大数据项目】，例如创建项目名为【data】:

pai create data -n dp-data

2.登录提供的数据库，导入对应的数据库表：

3.使用pai命令生成相应的表的实体和mapper文件【pai code -t table_xxx】

pai code -t user_tag

4.根据实时统计的业务需求，完成编码。

部署与测试

1.在当前项目路径下，使用pai工具提交代码：

pai init
pai add *
pai commit
pai push

2.使用pai工具部署项目，目前需要部分4个项目，分别是
数据分析：
命令：

pai deploy data -n pai-dp-data -m pai-dp-data/pai-dp-data-algo

计算参考：
2.1用户数据图表测试说明

数据服务：
命令：

pai deploy data -n pai-dp-data -m pai-dp-data/pai-dp-data-svc

参考：
2.用户行为分析

接口界面参考：

Logan日志采集后端：
命令：

pai deploy service -n ext-logan-web -r https://codehub-cn-south-1.devcloud.huaweicloud.com/fqhljszt_zengxh00001/ext-logan-web.git -u user_xxx -p pwd_xxx

展示：

Logan日志后端展示：
命令：

pai deploy front -n ext-logansite -r https://codehub-cn-south-1.devcloud.huaweicloud.com/fqhljszt_zengxh00001/ext-logansite.git -u user_xxx -p pwd_xxx

展示：

文档更新时间: 2022-05-19 17:18 作者：伍润源