2023年河北省职业院校学生技能大赛-高职组“大数据技术与应用”赛项赛卷-大数据赛项样例数据

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50734 Source Host : localhost:3306 Source Schema : ds_pub Target Server Type : MySQL Target Server Version : 50734 File Encoding : 65001 Date: 15/07/2022 19:02:03 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for base_province -- ---------------------------- DROP TABLE IF EXISTS `base_province`; CREATE TABLE `base_province` ( `id` bigint(20) NULL DEFAULT NULL COMMENT 'id', `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省名称', `region_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地区id', `area_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地区编码', `iso_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国际编码' ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of base_province -- ---------------------------- INSERT INTO `base_province` VALUES (1, '北京', '1', '110000', 'CN-11'); INSERT INTO `base_province` VALUES (2, '天津市', '1', '120000', 'CN-12'); INSERT INTO `base_province` VALUES (3, '山西', '1', '140000', 'CN-14'); INSERT INTO `base_province` VALUES (4, '内蒙古', '1', '150000', 'CN-15'); INSERT INTO `base_province` VALUES (5, '河北', '1', '130000', 'CN-13'); INSERT INTO `base_province` VALUES (6, '上海', '2', '310000', 'CN-31'); INSERT INTO `base_province` VALUES (7, '江苏', '2', '320000', 'CN-32'); INSERT INTO `base_province` VALUES (8, '浙江', '2', '330000', 'CN-33'); INSERT INTO `base_province` VALUES (9, '安徽', '2', '340000', 'CN-34'); INSERT INTO `base_province` VALUES (10, '福建', '2', '350000', 'CN-35'); INSERT INTO `base_province` VALUES (11, '江西', '2', '360000', 'CN-36'); INSERT INTO `base_province` VALUES (12, '山东', '2', '370000', 'CN-37'); INSERT INTO `base_province` VALUES (14, '台湾', '2', '710000', 'CN-71'); INSERT INTO `base_province` VALUES (15, '黑龙江', '3', '230000', 'CN-23'); INSERT INTO `base_province` VALUES (16, '吉林', '3', '220000', 'CN-22'); INSERT INTO `base_province` VALUES (17, '辽宁', '3', '210000', 'CN-21'); INSERT INTO `base_province` VALUES (18, '陕西', '7', '610000', 'CN-61'); INSERT INTO `base_province` VALUES (19, '甘肃', '7', '620000', 'CN-62'); INSERT INTO `base_province` VALUES (20, '青海', '7', '630000', 'CN-63'); INSERT INTO `base_province` VALUES (21, '宁夏', '7', '640000', 'CN-64'); INSERT INTO `base_province` VALUES (22, '新疆', '7', '650000', 'CN-65'); INSERT INTO `base_province` VALUES (23, '河南', '4', '410000', 'CN-41'); INSERT INTO `base_province` VALUES (24, '湖北', '4', '420000', 'CN-42'); INSERT INTO `base_province` VALUES (25, '湖南', '4', '430000', 'CN-43'); INSERT INTO `base_province` VALUES (26, '广东', '5', '440000', 'CN-44'); INSERT INTO `base_province` VALUES (27, '广西', '5', '450000', 'CN-45'); INSERT INTO `base_province` VALUES (28, '海南', '5', '460000', 'CN-46'); INSERT INTO `base_province` VALUES (29, '香港', '5', '810000', 'CN-91'); INSERT INTO `base_province` VALUES (30, '澳门', '5', '820000', 'CN-92'); INSERT INTO `base_province` VALUES (31, '四川', '6', '510000', 'CN-51'); INSERT INTO `base_province` VALUES (32, '贵州', '6', '520000', 'CN-52'); INSERT INTO `base_province` VALUES (33, '云南', '6', '530000', 'CN-53'); INSERT INTO `base_province` VALUES (13, '重庆', '6', '500000', 'CN-50'); INSERT INTO `base_province` VALUES (34, '西藏', '6', '540000', 'CN-54'); -- ---------------------------- -- Table structure for base_region -- ---------------------------- DROP TABLE IF EXISTS `base_region`; CREATE TABLE `base_region` ( `id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地区id', `region_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地区名称' ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of base_region -- ---------------------------- INSERT INTO `base_region` VALUES ('1', '华北'); INSERT INTO `base_region` VALUES ('2', '华东'); INSERT INTO `base_region` VALUES ('3', '东北'); INSERT INTO `base_region` VALUES ('4', '华中'); INSERT INTO `base_region` VALUES ('5', '华南'); INSERT INTO `base_region` VALUES ('6', '西南'); INSERT INTO `base_region` VALUES ('7', '西北'); -- ---------------------------- -- Table structure for order_detail -- ---------------------------- DROP TABLE IF EXISTS `order_detail`; CREATE TABLE `order_detail` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `order_id` bigint(20) NULL DEFAULT NULL COMMENT '订单编号（对应订单信息表id）', `sku_id` bigint(20) NULL DEFAULT NULL COMMENT '商品id（对应商品表id）', `sku_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称', `img_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片路径', `order_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '购买价格(下单时的商品价格）', `sku_num` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购买数量', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `source_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源类型', `source_id` bigint(20) NULL DEFAULT NULL COMMENT '来源编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 202910 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单详细信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of order_detail -- ---------------------------- INSERT INTO `order_detail` VALUES (8621, 3443, 4, '小米Play 流光渐变AI双摄 4GB+64GB 梦幻蓝 全网通4G 双卡双待 小水滴全面屏拍照游戏智能手机', 'http://SXlkutIjYpDWWTEpNUiisnlsevOHVElrdngQLgyZ', 1442.00, '1', '2020-04-25 18:47:14', '2401', NULL); INSERT INTO `order_detail` VALUES (8622, 3444, 8, 'Apple iPhoneXSMax (A2104) 256GB 深空灰色 移动联通电信4G手机 双卡双待', 'http://RFCTOnWWRtrJdygmPqiUXdBvyhqiTTOnXYagFJDP', 8900.00, '2', '2020-04-25 18:47:14', '2401', NULL); INSERT INTO `order_detail` VALUES (8623, 3445, 12, '联想(Lenovo)拯救者Y7000 英特尔酷睿i7 2019新款 15.6英寸发烧游戏本笔记本电脑（i7-9750H 8GB 512GB SSD GTX1650 4G 高色域', 'http://kAXllAQEzJWHwiExxVmyJIABfXyzbKwedeofMqwh', 6699.00, '3', '2020-04-25 18:47:14', '2401', NULL); INSERT INTO `order_detail` VALUES (8624, 3446, 5, '十月稻田 沁州黄小米 (黄小米 五谷杂粮 山西特产 真空装 大米伴侣 粥米搭档) 2.5kg', 'http://INNButKuTkslasORPBmHACnJuccfsxmRxNuMznPm', 244.00, '1', '2020-04-25 18:47:14', '2402', 19); INSERT INTO `order_detail` VALUES (8625, 3446, 7, '荣耀10青春版 幻彩渐变 2400万AI自拍 全网通版4GB+64GB 渐变蓝 移动联通电信4G全面屏手机 双卡双待', 'http://IJwhvJSuwaMHaevQQKZUzLkOsvYFiYsRhmLSjpZb', 1553.00, '3', '2020-04-25 18:47:14', '2401', NULL); INSERT INTO `order_detail` VALUES (8626, 3447, 1, '荣耀10青春版 幻彩渐变 2400万AI自拍 全网通版4GB+64GB 渐变蓝 移动联通电信4G全面屏手机 双卡双待', 'http://AOvKmfRQEBRJJllwCwCuptVAOtBBcIjWeJRsmhbJ', 2220.00, '3', '2020-04-25 18:47:14', '2404', 2); INSERT INTO `order_detail` VALUES (8627, 3448, 15, '迪奥（Dior）烈艳蓝金唇膏 口红 3.5g 999号 哑光-经典正红', 'http://kAXllAQEzJWHwiExxVmyJIABfXyzbKwedeofMqwh', 252.00, '1', '2020-04-25 18:47:14', '24