/*
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
