【免费】访问和咨询用户数据模块sql文件_hive数据分析案例资源-CSDN文库

共1个文件

sql：1个

sql

需积分: 0 145 浏览量 2024-05-04 17:35:57 上传评论收藏 61.68MB ZIP 举报

资源推荐

资源详情

资源评论

收起资源包目录

访问和咨询用户数据模块sql文件.zip （1个子文件）

nev.sql 204.18MB

-- MySQL dump 10.13 Distrib 5.7.26, for Linux (x86_64) -- -- Host: localhost Database: nev -- ------------------------------------------------------ -- Server version 5.7.26 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!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' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `nev` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `nev` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */; USE `nev`; -- -- Table structure for table `web_chat_ems_2019_07` -- DROP TABLE IF EXISTS `web_chat_ems_2019_07`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `web_chat_ems_2019_07` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `create_date_time` timestamp NULL DEFAULT NULL COMMENT '数据创建时间', `session_id` varchar(48) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '七陌sessionId', `sid` varchar(48) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '访客id', `create_time` datetime DEFAULT NULL COMMENT '会话创建时间', `seo_source` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '搜索来源', `seo_keywords` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '关键字', `ip` varchar(48) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT 'IP地址', `area` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '地域', `country` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '所在国家', `province` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '省', `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '城市', `origin_channel` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '投放渠道', `user` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '所属坐席', `manual_time` datetime DEFAULT NULL COMMENT '人工开始时间', `begin_time` datetime DEFAULT NULL COMMENT '坐席领取时间 ', `end_time` datetime DEFAULT NULL COMMENT '会话结束时间', `last_customer_msg_time_stamp` datetime DEFAULT NULL COMMENT '客户最后一条消息的时间', `last_agent_msg_time_stamp` datetime DEFAULT NULL COMMENT '坐席最后一下回复的时间', `reply_msg_count` int(12) DEFAULT '0' COMMENT '客服回复消息数', `msg_count` int(12) DEFAULT '0' COMMENT '客户发送消息数', `browser_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '浏览器名称', `os_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '系统名称', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=211198 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `web_chat_ems_2019_07` -- LOCK TABLES `web_chat_ems_2019_07` WRITE; /*!40000 ALTER TABLE `web_chat_ems_2019_07` DISABLE KEYS */; INSERT INTO `web_chat_ems_2019_07` VALUES (1,'2019-12-23 17:45:00','481aeb70-9c19-11e9-9a74-2f35b751ada5','3dba8460-9c19-11e9-ba58-a91e6c68cb36','2019-07-02 00:00:00','百度搜索','','113.119.156.105','中国广东广州','中国','广东','广州','未知','','2019-07-02 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 5.1.1'),(2,'2019-12-23 17:45:00','477cfdc0-9c19-11e9-88bf-291f631fb18c','4778b800-9c19-11e9-a6e6-49e71b626506','2019-07-01 23:59:00','其他网站','未知','223.90.243.56','中国河南许昌','中国','河南','许昌','未知','','2019-07-02 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'Safari','iOS 12.0'),(3,'2019-12-23 17:45:00','4597c300-9c19-11e9-9c9e-dd175450bfcc','97549c10-39b1-11e9-8c6b-a7d8c8ea8acb','2019-07-01 23:59:00','站内','','111.194.45.237','中国北京北京','中国','北京','北京','未知','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Safari','OS X 10.14.1'),(4,'2019-12-23 17:45:00','4414a570-9c19-11e9-bccd-45bba054701c','44101190-9c19-11e9-83d1-1762aa55e1f8','2019-07-01 23:59:00','百度搜索','SC4M','36.110.199.138','中国北京北京','中国','北京','北京','百度竞价','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 6.0.1'),(5,'2019-12-23 17:45:00','4335de30-9c19-11e9-83fd-8d8afacbd16c','43320da0-9c19-11e9-9381-292a67de89fc','2019-07-01 23:59:00','站内','','10.103.170.21','局域网局域网','局域网','局域网','','百度竞价','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 8.0.0'),(6,'2019-12-23 17:45:00','428552e0-9c19-11e9-9d00-ebdfec890b7f','36f9b340-9c0e-11e9-a288-2f2ed132c7a1','2019-07-01 23:59:00','百度搜索','数学','117.162.113.246','中国江西上饶','中国','江西','上饶','百度竞价','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 8.1.0'),(7,'2019-12-23 17:45:00','41d033b0-9c19-11e9-ad1d-c78cc6b39ce0','19fcde40-7349-11e9-a393-2f1609eb2bc8','2019-07-01 23:59:00','其他网站','未知','112.96.173.162','中国广东','中国','广东','','未知','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Safari','iOS 12.1.2'),(8,'2019-12-23 17:45:00','41fe2180-9c19-11e9-a46d-53534b574a0f','40a5a000-919d-11e9-aace-9bba37f2825e','2019-07-01 23:59:00','站内','','222.131.117.41','中国北京北京','中国','北京','北京','未知','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome','OS X 10.14.5'),(9,'2019-12-23 17:45:00','403c2630-9c19-11e9-83fd-8d8afacbd16c','cdb65ea0-9c18-11e9-83d1-1762aa55e1f8','2019-07-01 23:59:00','站内','','223.104.11.60','中国陕西','中国','陕西','','未知','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome','Windows 7 / Server 2008 R2 64-bit'),(10,'2019-12-23 17:45:00','3eaa89b0-9c19-11e9-ad03-638d7474afec','3ea69210-9c19-11e9-bd15-81c8d4908f9a','2019-07-01 23:59:00','百度搜索','S3HB','36.110.199.244','中国北京北京','中国','北京','北京','百度竞价','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 6.0.1'),(11,'2019-12-23 17:45:00','3e31fe50-9c19-11e9-af30-2371659abf25','11d8b200-9c0e-11e9-844f-1508c4b66f88','2019-07-01 23:59:00','百度搜索','英语','39.170.223.134','中国浙江绍兴','中国','浙江','绍兴','百度竞价','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 5.1.1'),(12,'2019-12-23 17:45:00','3dbef130-9c19-11e9-bccd-45bba054701c','3dba8460-9c19-11e9-ba58-a91e6c68cb36','2019-07-01 23:59:00','百度搜索','','113.119.156.105','中国广东广州','中国','广东','广州','未知','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 5.1.1'),(13,'2019-12-23 17:45:00','3c68d710-9c19-11e9-a46d-53534b574a0f','3c644330-9c19-11e9-8ce2-99bfe29661bd','2019-07-01 23:59:00','百度搜索','ETQH','36.110.199.135','中国北京北京','中国','北京','北京','百度竞价','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 6.0.1'),(14,'2019-12-23 17:45:00','3bfe0750-9c19-11e9-a46d-53534b574a0f','3ba01200-996a-11e9-9381-292a67de89fc','2019-07-01 23:59:00','站内','','113.101.85.50','中国广东潮州','中国','广东','潮州','未知','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Safari','OS X 10.14.5'),(15,'2019-12-23 17:45:00','386a3230-9c19-11e9-bccd-45bba054701c','81e1ac00-812e-11e9-8b69-8301d33a1603','2019-07-01 23:59:00','百度搜索','三明php培训','111.40.197.141','中国 �

评论收藏

内容反馈