《卖淘乐》商城的数据库设计

/* Navicat Premium Data Transfer Source Server : 我的MySQL Source Server Type : MySQL Source Server Version : 80026 Source Host : localhost:3306 Source Schema : db_mtl Target Server Type : MySQL Target Server Version : 80026 File Encoding : 65001 Date: 13/01/2022 17:26:02 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_basic_info -- ---------------------------- DROP TABLE IF EXISTS `tb_basic_info`; CREATE TABLE `tb_basic_info` ( `basic_info_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '评估类目ID', `basic_info_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评估类目名称', `basic_info_status` int(0) NULL DEFAULT NULL COMMENT '评估类目启用状态（1启用，0停用）', PRIMARY KEY (`basic_info_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_basic_info -- ---------------------------- INSERT INTO `tb_basic_info` VALUES (1, '版本', 1); INSERT INTO `tb_basic_info` VALUES (2, '保修期', 1); INSERT INTO `tb_basic_info` VALUES (3, '型号', 1); INSERT INTO `tb_basic_info` VALUES (4, '机身内存', 1); INSERT INTO `tb_basic_info` VALUES (5, '颜色', 1); INSERT INTO `tb_basic_info` VALUES (6, '开机情况', 1); INSERT INTO `tb_basic_info` VALUES (7, '功能情况（可多选或不选）', 1); INSERT INTO `tb_basic_info` VALUES (8, '外观情况', 1); INSERT INTO `tb_basic_info` VALUES (9, '触摸屏情况', 1); INSERT INTO `tb_basic_info` VALUES (10, '显示屏情况', 1); INSERT INTO `tb_basic_info` VALUES (11, '维修情况', 1); INSERT INTO `tb_basic_info` VALUES (12, '配件', 1); INSERT INTO `tb_basic_info` VALUES (13, '拆修情况', 1); -- ---------------------------- -- Table structure for tb_brand -- ---------------------------- DROP TABLE IF EXISTS `tb_brand`; CREATE TABLE `tb_brand` ( `brand_id` int(0) NOT NULL AUTO_INCREMENT, `brand_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `brand_logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '品牌logo', `brand_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '品牌描述', `create_time` timestamp(0) NULL DEFAULT NULL COMMENT '加入时间', `brand_status` int(0) NULL DEFAULT NULL COMMENT '品牌状态（1启用，0停用）', PRIMARY KEY (`brand_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_brand -- ---------------------------- INSERT INTO `tb_brand` VALUES (1, 'iPhone', NULL, NULL, NULL, 1); INSERT INTO `tb_brand` VALUES (2, '魅族', NULL, NULL, NULL, 1); INSERT INTO `tb_brand` VALUES (3, '诺基亚', NULL, NULL, NULL, 1); INSERT INTO `tb_brand` VALUES (4, 'LG', NULL, NULL, NULL, 1); INSERT INTO `tb_brand` VALUES (5, '三星', NULL, NULL, NULL, 1); INSERT INTO `tb_brand` VALUES (6, '华为', NULL, NULL, NULL, 1); INSERT INTO `tb_brand` VALUES (7, '小米', NULL, NULL, NULL, 1); INSERT INTO `tb_brand` VALUES (8, 'HTC', NULL, NULL, NULL, 1); INSERT INTO `tb_brand` VALUES (9, '联想', 'upload/d756dc7ad2ae49309b369e8fe60547c5.jpg', 'Lenovo', '2021-12-28 15:25:17', 1); INSERT INTO `tb_brand` VALUES (10, 'iTouch', NULL, NULL, NULL, 1); INSERT INTO `tb_brand` VALUES (11, '惠普', NULL, NULL, NULL, 1); INSERT INTO `tb_brand` VALUES (12, 'ASUS', NULL, NULL, NULL, 1); INSERT INTO `tb_brand` VALUES (15, '微软', 'upload/894fbc04b21b433ebb086d591d38734a.jpg', 'Microsoft', '2021-12-28 15:25:55', 0); INSERT INTO `tb_brand` VALUES (16, 'oppo', 'upload/7317d49ad1134aa2b4a58b4907c60a92.jpg', 'oppo 666', '2021-12-28 15:47:48', 0); -- ---------------------------- -- Table structure for tb_brand_good -- ---------------------------- DROP TABLE IF EXISTS `tb_brand_good`; CREATE TABLE `tb_brand_good` ( `brand_good_id` int(0) NOT NULL AUTO_INCREMENT, `fk_brand_id` int(0) NULL DEFAULT NULL, `fk_good_id` int(0) NULL DEFAULT NULL, PRIMARY KEY (`brand_good_id`) USING BTREE, INDEX `fk_brand_id`(`fk_brand_id`) USING BTREE, INDEX `fk_good_id`(`fk_good_id`) USING BTREE, CONSTRAINT `tb_brand_good_ibfk_1` FOREIGN KEY (`fk_brand_id`) REFERENCES `tb_brand` (`brand_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `tb_brand_good_ibfk_2` FOREIGN KEY (`fk_good_id`) REFERENCES `tb_good` (`good_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_brand_good -- ---------------------------- INSERT INTO `tb_brand_good` VALUES (1, 1, 1); INSERT INTO `tb_brand_good` VALUES (2, 1, 2); INSERT INTO `tb_brand_good` VALUES (3, 1, 3); INSERT INTO `tb_brand_good` VALUES (4, 1, 4); INSERT INTO `tb_brand_good` VALUES (5, 7, 5); INSERT INTO `tb_brand_good` VALUES (6, 7, 6); INSERT INTO `tb_brand_good` VALUES (7, 10, 7); INSERT INTO `tb_brand_good` VALUES (8, 1, 8); -- ---------------------------- -- Table structure for tb_cart -- ---------------------------- DROP TABLE IF EXISTS `tb_cart`; CREATE TABLE `tb_cart` ( `cart_id` int(0) NOT NULL AUTO_INCREMENT, `fk_cart_user_id` int(0) NULL DEFAULT NULL, `fk_cart_good_id` int(0) NULL DEFAULT NULL, `cart_good_price` int(0) NULL DEFAULT NULL, PRIMARY KEY (`cart_id`) USING BTREE, INDEX `fk_cart_user_id`(`fk_cart_user_id`) USING BTREE, INDEX `fk_cart_good_id`(`fk_cart_good_id`) USING BTREE, CONSTRAINT `tb_cart_ibfk_1` FOREIGN KEY (`fk_cart_user_id`) REFERENCES `tb_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `tb_cart_ibfk_2` FOREIGN KEY (`fk_cart_good_id`) REFERENCES `tb_good` (`good_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 480 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_cart -- ---------------------------- INSERT INTO `tb_cart` VALUES (1, 33, 1, 1960); INSERT INTO `tb_cart` VALUES (2, 33, 1, 1740); INSERT INTO `tb_cart` VALUES (3, 33, 1, 1460); INSERT INTO `tb_cart` VALUES (4, 33, 2, 2015); INSERT INTO `tb_cart` VALUES (5, 33, 7, 245); INSERT INTO `tb_cart` VALUES (6, 36, 1, 1180); INSERT INTO `tb_cart` VALUES (7, 39, 2, 1930); INSERT INTO `tb_cart` VALUES (8, 39, 7, 230); INSERT INTO `tb_cart` VALUES (9, 43, 1, 180); INSERT INTO `tb_cart` VALUES (10, 45, 5, 190); INSERT INTO `tb_cart` VALUES (11, 60, 1, 1905); INSERT INTO `tb_cart` VALUES (12, 45, 5, 190); INSERT INTO `tb_cart` VALUES (13, 45, 5, 190); INSERT INTO `tb_cart` VALUES (14, 45, 5, 190); INSERT INTO `tb_cart` VALUES (15, 45, 5, 190); INSERT INTO `tb_cart` VALUES (16, 45, 5, 190); INSERT INTO `tb_cart` VALUES (17, 45, 5, 190); INSERT INTO `tb_cart` VALUES (18, 60, 1, 1905); INSERT INTO `tb_cart` VALUES (19, 60, 1, 1905); INSERT INTO `tb_cart` VALUES (20, 80, 1, 1935); INSERT INTO `tb_cart` VALUES (21, 60, 1, 1905); INSERT INTO `tb_cart` VALUES (22, 60, 1, 1905); INSERT INTO `tb_cart` VALUES (23, 60, 1, 1905); INSERT INTO `tb_cart` VALUES (24, 93, 1, 800); INSERT INTO `tb_cart` VALUES (25, 93, 1, 1000); INSERT INTO `tb_cart` VALUES (26, 88, 1, 1485); INSERT INTO `tb_cart` VALUES (27, 59, 1, 1305); INSERT INTO `tb_cart` VALUES (28, 59, 1, 1305); INSERT INTO `tb_cart` VALUES (29, 93, 1, 800); INSERT INTO `tb_cart` VALUES (30, 93, 1, 1000); INSERT INTO `tb_cart` VALUES (31, 93, 1, 1150); INSERT INTO `tb_cart` VALUES (32, 99, 3, 470); INSERT INTO `tb_cart` VALUES (33, 45, 5, 190); INSERT INTO `tb_cart` VALUES (34, 103, 1, 2055); INSERT INTO `tb_cart` VALUES (35, 103, 1, 2055); INSERT INTO `tb_cart` VALUES (36, 103, 1, 2055)