104 lines
12 KiB
SQL
104 lines
12 KiB
SQL
/*
|
|
Navicat Premium Dump SQL
|
|
|
|
Source Server : mixue
|
|
Source Server Type : MySQL
|
|
Source Server Version : 90001 (9.0.1)
|
|
Source Host : localhost:3306
|
|
Source Schema : ai_article
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 90001 (9.0.1)
|
|
File Encoding : 65001
|
|
|
|
Date: 16/12/2025 11:29:04
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for ai_statistics
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `ai_statistics`;
|
|
CREATE TABLE `ai_statistics` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'Auto-increment ID',
|
|
`author_id` int NOT NULL DEFAULT 0 COMMENT '作者ID',
|
|
`author_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '作者名称',
|
|
`channel` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=baidu|2=toutiao|3=weixin',
|
|
`date` date NOT NULL COMMENT 'Date of statistics',
|
|
`submission_count` int NULL DEFAULT 0 COMMENT 'Number of submissions (投稿量)',
|
|
`read_count` int NULL DEFAULT 0 COMMENT 'Number of reads (阅读量)',
|
|
`comment_count` int NULL DEFAULT 0 COMMENT 'Number of comments (评论量)',
|
|
`comment_rate` decimal(5, 4) NULL DEFAULT 0.0000 COMMENT 'Comment rate (评论率)',
|
|
`like_count` int NULL DEFAULT 0 COMMENT 'Number of likes (点赞量)',
|
|
`like_rate` decimal(5, 4) NULL DEFAULT 0.0000 COMMENT 'Like rate (点赞率)',
|
|
`favorite_count` int NULL DEFAULT 0 COMMENT 'Number of favorites (收藏量)',
|
|
`favorite_rate` decimal(5, 4) NULL DEFAULT 0.0000 COMMENT 'Favorite rate (收藏率)',
|
|
`share_count` int NULL DEFAULT 0 COMMENT 'Number of shares (分享量)',
|
|
`share_rate` decimal(5, 4) NULL DEFAULT 0.0000 COMMENT 'Share rate (分享率)',
|
|
`slide_ratio` decimal(5, 4) NULL DEFAULT 0.0000 COMMENT 'Slide view ratio (滑图占比)',
|
|
`baidu_search_volume` int NULL DEFAULT 0 COMMENT 'Baidu search volume (百度搜索量)',
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation timestamp',
|
|
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Update timestamp',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `unique_date`(`date` ASC) USING BTREE,
|
|
INDEX `idx_date`(`date` ASC) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'AI Content Statistics' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of ai_statistics
|
|
-- ----------------------------
|
|
INSERT INTO `ai_statistics` VALUES (1, 136, '普外科马春雷', 1, '2025-12-16', 16, 19649, 182, 0.0093, 1801, 0.0917, 663, 0.0337, 172, 0.0088, 0.6682, 3404, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (2, 143, '黄金财医生', 1, '2025-12-15', 48, 41937, 477, 0.0114, 1034, 0.0247, 645, 0.0154, 15, 0.0004, 0.5703, 2173, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (3, 117, '唐小明医生', 1, '2025-12-14', 22, 33237, 491, 0.0148, 1229, 0.0370, 687, 0.0207, 153, 0.0046, 0.5208, 2618, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (4, 179, '风湿免疫专家李小峰', 1, '2025-12-13', 23, 37739, 310, 0.0082, 313, 0.0083, 367, 0.0097, 173, 0.0046, 0.7476, 814, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (5, 219, '人民医院武医生', 1, '2025-12-12', 87, 4888, 468, 0.0957, 1191, 0.2437, 445, 0.0910, 112, 0.0229, 0.6204, 1049, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (6, 226, '中医李伟杰', 1, '2025-12-11', 13, 7765, 327, 0.0421, 1336, 0.1721, 65, 0.0084, 83, 0.0107, 0.2945, 846, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (7, 169, '眼科周医师', 1, '2025-12-10', 25, 3753, 194, 0.0517, 1672, 0.4455, 50, 0.0133, 75, 0.0200, 0.2833, 521, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (8, 177, '好孕闺蜜王珂', 1, '2025-12-09', 67, 38635, 304, 0.0079, 1106, 0.0286, 88, 0.0023, 25, 0.0006, 0.8390, 3025, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (9, 250, '爱情号', 2, '2025-12-08', 65, 27693, 454, 0.0164, 348, 0.0126, 590, 0.0213, 171, 0.0062, 0.5739, 2406, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (10, 241, '测试作者_更新', 1, '2025-12-07', 50, 44883, 423, 0.0094, 1662, 0.0370, 159, 0.0035, 70, 0.0016, 0.8617, 4569, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (11, 148, '肿瘤科郭秋均医生', 1, '2025-12-06', 90, 13791, 414, 0.0300, 530, 0.0384, 314, 0.0228, 171, 0.0124, 0.5822, 2696, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (12, 123, '微创腋臭专家邹普功', 1, '2025-12-05', 96, 31392, 155, 0.0049, 229, 0.0073, 26, 0.0008, 120, 0.0038, 0.5938, 3737, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (13, 188, '苗辉医生', 1, '2025-12-04', 48, 43140, 327, 0.0076, 497, 0.0115, 296, 0.0069, 15, 0.0003, 0.5338, 2256, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (14, 148, '肿瘤科郭秋均医生', 1, '2025-12-03', 39, 33647, 129, 0.0038, 141, 0.0042, 675, 0.0201, 135, 0.0040, 0.3683, 1226, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (15, 172, '李亮亮中医', 1, '2025-12-02', 15, 30122, 421, 0.0140, 53, 0.0018, 536, 0.0178, 7, 0.0002, 0.5285, 1341, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (16, 149, '生殖科医生师楠', 1, '2025-12-01', 79, 23558, 318, 0.0135, 1383, 0.0587, 221, 0.0094, 34, 0.0014, 0.5290, 2791, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (17, 207, '男科吴洪涛医生', 1, '2025-11-30', 14, 15681, 133, 0.0085, 152, 0.0097, 137, 0.0087, 64, 0.0041, 0.6343, 1996, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (18, 107, '耳鼻咽喉科宋安中', 1, '2025-11-29', 45, 28382, 202, 0.0071, 130, 0.0046, 346, 0.0122, 70, 0.0025, 0.1381, 4133, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (19, 200, '血管外科刘雷霆', 1, '2025-11-28', 27, 45241, 207, 0.0046, 1105, 0.0244, 254, 0.0056, 143, 0.0032, 0.2728, 869, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (20, 152, '皮肤科医生郑占才', 1, '2025-11-27', 19, 4780, 417, 0.0872, 331, 0.0692, 405, 0.0847, 73, 0.0153, 0.7350, 1060, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (21, 201, '面部提升梁永鑫', 1, '2025-11-26', 59, 21209, 105, 0.0050, 398, 0.0188, 78, 0.0037, 178, 0.0084, 0.6635, 3542, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (22, 227, '中医院张医生', 1, '2025-11-25', 18, 7096, 23, 0.0032, 404, 0.0569, 87, 0.0123, 126, 0.0178, 0.8124, 3545, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (23, 186, '董强中医', 1, '2025-11-24', 16, 41784, 129, 0.0031, 1318, 0.0315, 649, 0.0155, 109, 0.0026, 0.3949, 4758, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (24, 203, '中医针灸侯医生', 1, '2025-11-23', 19, 34948, 144, 0.0041, 199, 0.0057, 469, 0.0134, 8, 0.0002, 0.6606, 4515, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (25, 209, '刘晓宁', 1, '2025-11-22', 17, 19759, 292, 0.0148, 216, 0.0109, 741, 0.0375, 102, 0.0052, 0.3674, 2662, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (26, 212, '中医王焕焕', 1, '2025-11-21', 83, 46543, 190, 0.0041, 1987, 0.0427, 25, 0.0005, 91, 0.0020, 0.8369, 871, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (27, 146, 'Dr蓝剑雄', 1, '2025-11-20', 100, 10787, 85, 0.0079, 1660, 0.1539, 208, 0.0193, 190, 0.0176, 0.3104, 2146, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (28, 222, '中医王凡', 1, '2025-11-19', 61, 19897, 90, 0.0045, 1984, 0.0997, 96, 0.0048, 8, 0.0004, 0.7195, 4666, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (29, 127, '黄燕飞医生', 1, '2025-11-18', 60, 26308, 107, 0.0041, 1696, 0.0645, 420, 0.0160, 99, 0.0038, 0.8203, 3955, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (30, 201, '面部提升梁永鑫', 1, '2025-11-17', 100, 45103, 222, 0.0049, 53, 0.0012, 201, 0.0045, 61, 0.0014, 0.8678, 4099, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (31, 203, '中医针灸侯医生', 1, '2025-11-16', 30, 14802, 333, 0.0225, 513, 0.0347, 724, 0.0489, 139, 0.0094, 0.2333, 3462, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (32, 134, '刘志坚医生', 1, '2025-11-15', 12, 47214, 398, 0.0084, 1684, 0.0357, 201, 0.0043, 10, 0.0002, 0.2208, 4384, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (33, 129, '梁金宇医生', 1, '2025-11-14', 28, 20512, 95, 0.0046, 1972, 0.0961, 348, 0.0170, 62, 0.0030, 0.2596, 4185, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (34, 137, '儿科钱美娣', 1, '2025-11-13', 75, 26458, 43, 0.0016, 475, 0.0180, 368, 0.0139, 60, 0.0023, 0.3241, 1673, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (35, 115, '冯玉燕医生', 1, '2025-11-12', 59, 17099, 349, 0.0204, 1837, 0.1074, 340, 0.0199, 129, 0.0075, 0.3421, 1366, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (36, 140, '射雕女英雄', 1, '2025-11-11', 71, 26270, 352, 0.0134, 807, 0.0307, 592, 0.0225, 83, 0.0032, 0.8597, 2258, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (37, 241, '测试作者_更新', 1, '2025-11-10', 29, 37688, 180, 0.0048, 1774, 0.0471, 267, 0.0071, 145, 0.0038, 0.7716, 1684, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (38, 209, '刘晓宁', 1, '2025-11-09', 37, 45670, 145, 0.0032, 1374, 0.0301, 349, 0.0076, 173, 0.0038, 0.6899, 4447, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (39, 164, '王巍药师', 1, '2025-11-08', 87, 25078, 447, 0.0178, 1585, 0.0632, 253, 0.0101, 41, 0.0016, 0.4734, 4615, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (40, 222, '中医王凡', 1, '2025-11-07', 98, 10480, 87, 0.0083, 1000, 0.0954, 658, 0.0628, 48, 0.0046, 0.4747, 3903, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (41, 135, '内科黄湘霞医生', 1, '2025-11-06', 85, 32555, 309, 0.0095, 725, 0.0223, 775, 0.0238, 104, 0.0032, 0.2555, 3917, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (42, 145, '注射刘新亚', 1, '2025-11-05', 74, 24637, 327, 0.0133, 1551, 0.0630, 726, 0.0295, 128, 0.0052, 0.6387, 2148, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (43, 125, '口腔科何卫康', 1, '2025-11-04', 52, 6565, 158, 0.0241, 1100, 0.1676, 303, 0.0462, 184, 0.0280, 0.5485, 3376, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (44, 112, '范正鹏医生', 1, '2025-11-03', 95, 43266, 216, 0.0050, 468, 0.0108, 723, 0.0167, 115, 0.0027, 0.8451, 1935, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (45, 172, '李亮亮中医', 1, '2025-11-02', 95, 8013, 481, 0.0600, 969, 0.1209, 685, 0.0855, 118, 0.0147, 0.3403, 212, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (46, 146, 'Dr蓝剑雄', 1, '2025-11-01', 42, 19022, 29, 0.0015, 350, 0.0184, 595, 0.0313, 124, 0.0065, 0.3701, 975, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (47, 197, '静脉曲张孙国洋', 1, '2025-10-31', 61, 21291, 65, 0.0031, 123, 0.0058, 283, 0.0133, 198, 0.0093, 0.5448, 1384, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (48, 201, '面部提升梁永鑫', 1, '2025-10-30', 94, 15223, 288, 0.0189, 1138, 0.0748, 601, 0.0395, 97, 0.0064, 0.4460, 3891, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (49, 163, '外科莫家伟', 1, '2025-10-29', 80, 5503, 455, 0.0827, 920, 0.1672, 651, 0.1183, 49, 0.0089, 0.7975, 3523, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
INSERT INTO `ai_statistics` VALUES (50, 166, '邹其针脑科中心', 1, '2025-10-28', 57, 31758, 147, 0.0046, 1958, 0.0617, 366, 0.0115, 138, 0.0043, 0.3303, 2735, '2025-12-16 10:53:58', '2025-12-16 11:28:19');
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|