优品商城-建表(user、member-goods、goods_cart、category、order、spec-address、province、city、county)

最新推荐文章于 2024-07-25 20:44:58 发布
最新推荐文章于 2024-07-25 20:44:58 发布
阅读量948 收藏
点赞数
分类专栏： 商城项目 文章标签： java spring
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/qq_39497997/article/details/119462588
版权

文章目录

1 user

1.1 user(管理员表)

在这里插入图片描述

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `nickname` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '管理员昵称',
  `password` CHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '管理员密码 ',
  `avatar` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '管理员头像地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = INNODB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '普通用户表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1374325809885773826', 'adminmm', 'b5e4d6c9d1745071a8eeef78175c38f1', NULL);
INSERT INTO `user` VALUES ('1374345804833390593', 'admin', '0192023a7bbd73250516f069df18b500', NULL);

SET FOREIGN_KEY_CHECKS = 1;

1.2 member

在这里插入图片描述

-- ----------------------------
-- Table structure for member
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member`  (
  `id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `nickname` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `password` CHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户密码',
  `sex` TINYINT NULL DEFAULT NULL COMMENT '用户性别',
  `avatar` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户头像',
  `phone` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号码',
  `gmt_create` DATETIME(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modify` DATETIME(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `nickname`(`nickname`) USING BTREE
) ENGINE = INNODB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统用户表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of member
-- ----------------------------
INSERT INTO `member` VALUES ('21341', 'xiaoming', 'wqe', 1, 'sad', '231', '2021-08-04 10:43:16', '2021-08-04 10:43:16');

2 goods

2.1 goods(商品表)

在这里插入图片描述

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods`  (
  `id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键(商品id)',
  `title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品标题',
  `descp` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品描述',
  `origin_price` BIGINT NULL DEFAULT NULL COMMENT '商品原价(分)',
  `current_price` BIGINT NULL DEFAULT NULL COMMENT '商品现价(分)',
  `image_url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品图片地址',
  `detail` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '商品详情',
  `status` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品状态 0:待审批  1:以上架  2:已拒绝',
  `c_id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品分类id',
  `stock` BIGINT NULL DEFAULT NULL COMMENT '库存',
  `gmt_create` DATETIME(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '商品创建时间',
  `gmt_modify` DATETIME(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '商品修改日期',
  PRIMARY KEY (`id`) USING BTREE,
  FULLTEXT INDEX `ft_title`(`title`) WITH PARSER `ngram` COMMENT '全文索引使用的分词器为ngram'
) ENGINE = INNODB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES ('1376053796356263937', 'OPPO Enco X 真无线降噪耳机  白歌', 'OPPO X 丹拿联合打造，DBEE3.0声音系统，双重主动降噪，支持通透模式，蓝牙5.2低延时双传告别卡顿。', 99999, 99900, '6f005a729618485d8c3536842d78508e_202010190810125f8d84f4975fe.png', 'https://dsfs.oppo.com/archives/202103/20210326100304605d4204c83ad.png?_w_=750&_h_=1086,https://dsfs.oppo.com/archives/202103/20210326100307605d4207b37fa.png?_w_=750&_h_=774,https://dsfs.oppo.com/archives/202103/20210326100311605d420b3f685.png?_w_=750&_h_=1036,https://dsfs.oppo.com/archives/202010/202010190710005f8d7da40b202.jpg,https://dsfs.oppo.com/archives/202010/202010190710195f8d7db7bca0f.jpg,https://dsfs.oppo.com/archives/202010/202010190710265f8d7dbe4066b.jpg,https://dsfs.oppo.com/archives/202010/202010190710245f8d7df895f18.jpg,https://dsfs.oppo.com/archives/202010/202010190710295f8d7dfd4a84c.jpg,https://dsfs.oppo.com/archives/202010/202010190710335f8d7e0194d2b.jpg,https://dsfs.oppo.com/archives/202010/202010190710405f8d7e085f23d.jpg,https://dsfs.oppo.com/archives/202010/202010190710465f8d7e0e84ce5.jpg,https://dsfs.oppo.com/archives/202010/202010190710515f8d7e13eda97.jpg,https://dsfs.oppo.com/archives/202010/202010190710585f8d7e1a12111.jpg,https://dsfs.oppo.com/archives/202010/202010190710035f8d7e1f63b99.jpg', 1, '1375077547123269633', 10, '2021-03-28 14:09:25', '2021-03-28 14:09:25');
INSERT INTO `goods` VALUES ('1376055466750414849', 'OPPO Reno5 星河入梦 8G+128G', '6400万水光人像四摄，65W超级闪充，30个月流畅护航。', 269900, 269900, 'c10fd53f954d4adca2064080f98b9393_202012180212295fdbaa5559a6d.webp', 'https://dsfs.oppo.com/archives/202103/20210326100304605d4204c83ad.png?_w_=750&_h_=1086,https://dsfs.oppo.com/archives/202103/20210326100307605d4207b37fa.png?_w_=750&_h_=774,https://dsfs.oppo.com/archives/202103/20210326100311605d420b3f685.png?_w_=750&_h_=1036,https://dsfs.oppo.com/archives/202010/202010190710005f8d7da40b202.jpg,https://dsfs.oppo.com/archives/202010/202010190710195f8d7db7bca0f.jpg,https://dsfs.oppo.com/archives/202010/202010190710265f8d7dbe4066b.jpg,https://dsfs.oppo.com/archives/202010/202010190710245f8d7df895f18.jpg,https://dsfs.oppo.com/archives/202010/202010190710295f8d7dfd4a84c.jpg,https://dsfs.oppo.com/archives/202010/202010190710335f8d7e0194d2b.jpg,https://dsfs.oppo.com/archives/202010/202010190710405f8d7e085f23d.jpg,https://dsfs.oppo.com/archives/202010/202010190710465f8d7e0e84ce5.jpg,https://dsfs.oppo.com/archives/202010/202010190710515f8d7e13eda97.jpg,https://dsfs.oppo.com/archives/202010/202010190710585f8d7e1a12111.jpg,https://dsfs.oppo.com/archives/202010/202010190710035f8d7e1f63b99.jpg', 1, '1375077547123269633', 3, '2021-03-28 14:16:03', '2021-03-28 14:16:03');
INSERT INTO `goods` VALUES ('1376055727111835649', 'OPPO Find X3 镜黑  8G+128G', '【新品上市 | 现货直发，顺丰极速达 | 银卡及以上会员限时赠OPPO移动电源 | 欢太商城是OPPO官方商城 ，请您放心购机】', 500000, 449900, 'b9e3179581574153be31731b62909a3c_oppofindx3.webp', 'https://dsfs.oppo.com/archives/202103/20210326100304605d4204c83ad.png?_w_=750&_h_=1086,https://dsfs.oppo.com/archives/202103/20210326100307605d4207b37fa.png?_w_=750&_h_=774,https://dsfs.oppo.com/archives/202103/20210326100311605d420b3f685.png?_w_=750&_h_=1036,https://dsfs.oppo.com/archives/202010/202010190710005f8d7da40b202.jpg,https://dsfs.oppo.com/archives/202010/202010190710195f8d7db7bca0f.jpg,https://dsfs.oppo.com/archives/202010/202010190710265f8d7dbe4066b.jpg,https://dsfs.oppo.com/archives/202010/202010190710245f8d7df895f18.jpg,https://dsfs.oppo.com/archives/202010/202010190710295f8d7dfd4a84c.jpg,https://dsfs.oppo.com/archives/202010/202010190710335f8d7e0194d2b.jpg,https://dsfs.oppo.com/archives/202010/202010190710405f8d7e085f23d.jpg,https://dsfs.oppo.com/archives/202010/202010190710465f8d7e0e84ce5.jpg,https://dsfs.oppo.com/archives/202010/202010190710515f8d7e13eda97.jpg,https://dsfs.oppo.com/archives/202010/202010190710585f8d7e1a12111.jpg,https://dsfs.oppo.com/archives/202010/202010190710035f8d7e1f63b99.jpg', 1, '1375077547123269633', 3, '2021-03-28 14:17:05', '2021-03-28 14:17:05');
INSERT INTO `goods` VALUES ('1376056378399166465', '蒙牛特仑苏纯牛奶250ml*16盒*2包/整箱', '完美诠释，更高品质', 18000, 16000, '85eee0060d774d3fbcd3119204b94295_O1CN01DFsPRz28vIjCZlGkN_!!725677994.jpg_430x430q90.jpg', 'https://dsfs.oppo.com/archives/202103/20210326100304605d4204c83ad.png?_w_=750&_h_=1086,https://dsfs.oppo.com/archives/202103/20210326100307605d4207b37fa.png?_w_=750&_h_=774,https://dsfs.oppo.com/archives/202103/20210326100311605d420b3f685.png?_w_=750&_h_=1036,https://dsfs.oppo.com/archives/202010/202010190710005f8d7da40b202.jpg,https://dsfs.oppo.com/archives/202010/202010190710195f8d7db7bca0f.jpg,https://dsfs.oppo.com/archives/202010/202010190710265f8d7dbe4066b.jpg,https://dsfs.oppo.com/archives/202010/202010190710245f8d7df895f18.jpg,https://dsfs.oppo.com/archives/202010/202010190710295f8d7dfd4a84c.jpg,https://dsfs.oppo.com/archives/202010/202010190710335f8d7e0194d2b.jpg,https://dsfs.oppo.com/archives/202010/202010190710405f8d7e085f23d.jpg,https://dsfs.oppo.com/archives/202010/202010190710465f8d7e0e84ce5.jpg,https://dsfs.oppo.com/archives/202010/202010190710515f8d7e13eda97.jpg,https://dsfs.oppo.com/archives/202010/202010190710585f8d7e1a12111.jpg,https://dsfs.oppo.com/archives/202010/202010190710035f8d7e1f63b99.jpg', 1, '1375077469990019073', 3, '2021-03-28 14:19:41', '2021-03-28 14:19:41');
INSERT INTO `goods` VALUES ('1376056745295908865', 'OPPO 智能电视 R1 55英寸', '4K悬浮全面屏超清画质，四核疾速处理器秒开秒看，NFC一碰闪投，杜比音效带来影院级的观影体验。', 7999000, 7799000, '9f7b08bd209a4ea8bd10b71dfed9ce6e_20210324060343605b1a3721d6b.webp', 'https://dsfs.oppo.com/archives/202103/20210326100304605d4204c83ad.png?_w_=750&_h_=1086,https://dsfs.oppo.com/archives/202103/20210326100307605d4207b37fa.png?_w_=750&_h_=774,https://dsfs.oppo.com/archives/202103/20210326100311605d420b3f685.png?_w_=750&_h_=1036,https://dsfs.oppo.com/archives/202010/202010190710005f8d7da40b202.jpg,https://dsfs.oppo.com/archives/202010/202010190710195f8d7db7bca0f.jpg,https://dsfs.oppo.com/archives/202010/202010190710265f8d7dbe4066b.jpg,https://dsfs.oppo.com/archives/202010/202010190710245f8d7df895f18.jpg,https://dsfs.oppo.com/archives/202010/202010190710295f8d7dfd4a84c.jpg,https://dsfs.oppo.com/archives/202010/202010190710335f8d7e0194d2b.jpg,https://dsfs.oppo.com/archives/202010/202010190710405f8d7e085f23d.jpg,https://dsfs.oppo.com/archives/202010/202010190710465f8d7e0e84ce5.jpg,https://dsfs.oppo.com/archives/202010/202010190710515f8d7e13eda97.jpg,https://dsfs.oppo.com/archives/202010/202010190710585f8d7e1a12111.jpg,https://dsfs.oppo.com/archives/202010/202010190710035f8d7e1f63b99.jpg', 1, '1375077547123269633', 2, '2021-03-28 14:21:08', '2021-03-28 14:21:08');

2.2 goods_cart

在这里插入图片描述

-- ----------------------------
-- Table structure for goods_cart
-- ----------------------------
DROP TABLE IF EXISTS `goods_cart`;
CREATE TABLE `goods_cart`  (
  `u_id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户id',
  `u_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户昵称',
  `g_id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品id',
  `g_title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品标题',
  `g_number` INT NOT NULL DEFAULT 1 COMMENT '加入购物车的商品数量',
  `is_delete` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否删除: 0: false  1:true',
  `gmt_create` DATETIME(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modify` DATETIME(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间'
) ENGINE = INNODB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of goods_cart
-- ----------------------------
INSERT INTO `goods_cart` VALUES ('1374345804833390593', 'admin', '1376056378399166465', '蒙牛特仑苏纯牛奶250ml*16盒*2包/整箱', 2, 1, '2021-03-28 14:40:08', '2021-03-28 14:40:08');
INSERT INTO `goods_cart` VALUES ('1374345804833390593', 'admin', '1376056745295908865', 'OPPO 智能电视 R1 55英寸', 20, 0, '2021-03-28 15:14:59', '2021-03-28 15:14:59');

2.3 goods_category(商品类别)

在这里插入图片描述

-- ----------------------------
-- Table structure for goods_category
-- ----------------------------
DROP TABLE IF EXISTS `goods_category`;
CREATE TABLE `goods_category`  (
  `id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品类别id',
  `title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类别标题',
  `descp` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类别描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = INNODB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of goods_category
-- ----------------------------
INSERT INTO `goods_category` VALUES ('1375077469990019073', '生活用品', '母婴用的商品分类');
INSERT INTO `goods_category` VALUES ('1375077547123269633', '电子商品', '高科技电子产品');

2.4 goods_order(商品订单)

在这里插入图片描述

-- ----------------------------
-- Table structure for goods_order
-- ----------------------------
DROP TABLE IF EXISTS `goods_order`;
CREATE TABLE `goods_order`  (
  `id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单id',
  `u_id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户id',
  `u_name` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `g_id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品id',
  `g_title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品标题',
  `addr_id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '收货地址id',
  `buy_number` INT NULL DEFAULT NULL COMMENT '购买数量',
  `current_price` BIGINT NULL DEFAULT NULL COMMENT '商品单价',
  `total_price` BIGINT NULL DEFAULT NULL COMMENT '订单总价',
  `status` TINYINT NOT NULL DEFAULT 0 COMMENT '订单状态  0:未支付  1:已支付',
  `gmt_create` DATETIME(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modify` DATETIME(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = INNODB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of goods_order
-- ----------------------------
INSERT INTO `goods_order` VALUES ('1376104367322853377', '1374345804833390593', 'admin', '1376056378399166465', '蒙牛特仑苏纯牛奶250ml*16盒*2包/整箱', '1376083358800728065', 2, 16000, 32000, 0, '2021-03-28 17:30:22', '2021-03-28 17:30:22');

2.5 goods_spec(商品规格)

在这里插入图片描述

-- ----------------------------
-- Table structure for goods_spec
-- ----------------------------
DROP TABLE IF EXISTS `goods_spec`;
CREATE TABLE `goods_spec`  (
  `id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品规格id',
  `title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '规格名称',
  `g_id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品id',
  `g_title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品标题',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = INNODB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of goods_spec
-- ----------------------------
INSERT INTO `goods_spec` VALUES ('1376053796356263938', '蓝调 新色', '1376053796356263937', 'OPPO Enco X 真无线降噪耳机  白歌');
INSERT INTO `goods_spec` VALUES ('1376053796423372801', '白歌', '1376053796356263937', 'OPPO Enco X 真无线降噪耳机  白歌');
INSERT INTO `goods_spec` VALUES ('1376053796423372802', '夜曲', '1376053796356263937', 'OPPO Enco X 真无线降噪耳机  白歌');
INSERT INTO `goods_spec` VALUES ('1376053796423372803', '竹韵', '1376053796356263937', 'OPPO Enco X 真无线降噪耳机  白歌');
INSERT INTO `goods_spec` VALUES ('1376053796423372804', '故宫福启版', '1376053796356263937', 'OPPO Enco X 真无线降噪耳机  白歌');
INSERT INTO `goods_spec` VALUES ('1376054602916728833', 'ECG版', '1376054602849619969', 'OPPO Watch 41mm 雅黑');
INSERT INTO `goods_spec` VALUES ('1376054602916728834', '41mm', '1376054602849619969', 'OPPO Watch 41mm 雅黑');
INSERT INTO `goods_spec` VALUES ('1376054602916728835', '46mm', '1376054602849619969', 'OPPO Watch 41mm 雅黑');
INSERT INTO `goods_spec` VALUES ('1376054602916728836', '精钢版', '1376054602849619969', 'OPPO Watch 41mm 雅黑');
INSERT INTO `goods_spec` VALUES ('1376055466813329410', '月夜黑', '1376055466750414849', 'OPPO Reno5 星河入梦 8G+128G');
INSERT INTO `goods_spec` VALUES ('1376055466813329411', '极光蓝', '1376055466750414849', 'OPPO Reno5 星河入梦 8G+128G');
INSERT INTO `goods_spec` VALUES ('1376055466813329412', '星河入梦', '1376055466750414849', 'OPPO Reno5 星河入梦 8G+128G');
INSERT INTO `goods_spec` VALUES ('1376055727111835650', '镜黑', '1376055727111835649', 'OPPO Find X3 镜黑  8G+128G');
INSERT INTO `goods_spec` VALUES ('1376055727111835651', '凝白', '1376055727111835649', 'OPPO Find X3 镜黑  8G+128G');
INSERT INTO `goods_spec` VALUES ('1376055727111835652', '雾蓝', '1376055727111835649', 'OPPO Find X3 镜黑  8G+128G');
INSERT INTO `goods_spec` VALUES ('1376056378466275330', '高钙，低脂', '1376056378399166465', '蒙牛特仑苏纯牛奶250ml*16盒*2包/整箱');
INSERT INTO `goods_spec` VALUES ('1376056745295908866', 'OPPO 智能电视 R1 55英寸', '1376056745295908865', 'OPPO 智能电视 R1 55英寸');
INSERT INTO `goods_spec` VALUES ('1376056745295908867', 'OPPO 智能电视 R1 65英寸', '1376056745295908865', 'OPPO 智能电视 R1 55英寸');
INSERT INTO `goods_spec` VALUES ('1376056745358823425', 'OPPO 智能电视 S1 65英寸', '1376056745295908865', 'OPPO 智能电视 R1 55英寸');

3 address

3.1 address(地址)

在这里插入图片描述

-- ----------------------------
-- Table structure for address
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address`  (
  `id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '地址id',
  `p_id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省份id',
  `p_name` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省份名称',
  `c_id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市区id',
  `c_name` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市区名称',
  `co_id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '县区id',
  `co_name` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '县区名称',
  `detail` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '街道门牌号详情地址',
  `u_id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户id',
  `u_name` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户昵称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = INNODB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of address
-- ----------------------------
INSERT INTO `address` VALUES ('1376083358800728065', '1', '陕西省', '110', '西安市', '333', '周至县', '小机箱村子', '1374345804833390593', 'admin');

3.2 province(省)

在这里插入图片描述

-- ----------------------------
-- Table structure for province
-- ----------------------------
DROP TABLE IF EXISTS `province`;
CREATE TABLE `province`  (
  `id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '省份id',
  `name` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = INNODB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of province
-- ----------------------------
INSERT INTO `province` VALUES ('1', '陕西省');
INSERT INTO `province` VALUES ('2', '甘肃省');

3.3 city(市)

在这里插入图片描述

-- ----------------------------
-- Table structure for city
-- ----------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city`  (
  `id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '市区id',
  `name` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市区名称',
  `p_id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省份id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = INNODB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO `city` VALUES ('110', '西安市', '1');
INSERT INTO `city` VALUES ('111', '渭南市', '1');
INSERT INTO `city` VALUES ('112', '天水市', '2');

3.4 county(县)

在这里插入图片描述

-- ----------------------------
-- Table structure for county
-- ----------------------------
DROP TABLE IF EXISTS `county`;
CREATE TABLE `county`  (
  `id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '县id',
  `name` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '县名称',
  `c_id` CHAR(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市区id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = INNODB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of county
-- ----------------------------
INSERT INTO `county` VALUES ('222', '长安区', '110');
INSERT INTO `county` VALUES ('333', '周至县', '110');

4 设置字符集

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

网上购物商城数据库设计表
12-23
网上购物商城数据库设计表，写的很详细，有16张表，其中多使用多对多的关联关系，可作参考
1商品表创建
weixin_30659829的博客
01-28 263
USE php34; SET NAMES utf8; # tinyint : 0~255 # smallint : 0~ 65535 # mediumint : 0~1千6百多万 # int : 0~40多亿 # char 、varchar 、 text容量？ # char :0~255个字符 # varchar : 0~65535 字节 看表编码，如果是u...
商城数据库建表
weixin_30300523的博客
10-20 342
商品类型管理： 先要创建商品类型的表，用来存储商品类型的信息。 create table i_type( id tinyint unsigned primary key auto_increment, type_name varchar(32) not null comment '商品类型的名称', index (type_name) )e...
商城mysql表_商城数据库建表
weixin_39586915的博客
02-05 329
商品类型管理：先要创建商品类型的表，用来存储商品类型的信息。create table i_type(id tinyint unsigned primary key auto_increment,type_name varchar(32) not null comment '商品类型的名称',index (type_name))engine myisam charset utf8;商品的属性表：cr...
创建商品表app
weixin_51118163的博客
10-14 213
1.创建course模型 1.1 创建用户模型course python ../manage.py startapp goods # 创建course模型 1.2 在setting.py中注册goods模型（第一步） INSTALLED_APPS = [ 'goods.apps.GoodsConfig', ] # 注：pycharm无法联想，需要把apps文件夹设置为源根 1.3 syl/urls.py添加路由（第二步） urlpatterns = [ path('goods/', inclu
毕业设计&课程设计&毕设&课设-微信小程序-骆驼优品服饰商城小程序 2.zip
07-14
内容概要：骆驼优品服饰商城小程序 适用人群：学生、老师、企业员工，也适合小白学习进阶，当然也可作为毕设项目、课程设计、作业、项目初期立项演示等。 使用场景及目标： 能学到什么：微信小程序的开发技巧和经验 ...
商城模板类-骆驼优品服饰商城小程序源代码【含图文文档教程+源码导入教程+操作界面截图】
03-27
《骆驼优品服饰商城小程序源代码解析及开发实践》 在移动互联网时代，微信小程序因其轻便快捷的特性，成为商家与用户交互的重要平台。本文将深入探讨“商城模板类-骆驼优品服饰商城小程序”的源代码，旨在帮助...
安卓应用-购物支付-陌狐优品手机版 v2.3.3 安卓版.zip
08-13
陌狐优品是一款专为安卓用户设计的购物支付应用程序，其最新版本为v2.3.3。这个软件集成了在线购物与便捷支付的功能，旨在为用户提供流畅且安全的购物体验。下面我们将深入探讨这款应用的主要特点、功能以及在安卓...
优品商城PC版-1702.rp
09-10
优品商城PC版-1702.rp
微信小程序源码-骆驼优品服饰商城小程序.zip
03-24
微信小程序源码-骆驼优品服饰商城小程序.zip微信小程序源码-骆驼优品服饰商城小程序.zip微信小程序源码-骆驼优品服饰商城小程序.zip微信小程序源码-骆驼优品服饰商城小程序.zip微信小程序源码-骆驼优品服饰商城小...
goods_category.sql
05-27
淘宝商品类别大全数据为2019年最新数据,文件为已整理好的sql脚本可以直接插入mysql数据库，非常方便。
商城后台之user表的实现（二）－－－（１）
qq_39820568的博客
01-06 1506
首先创建user的bean，intellij有个方便快捷的方法 操作步骤： main(鼠标右击）＞＞＞Open Module Settings  在main目录下点击＋号（左上方的）     点击Hibernate     然后点击右上角的＋号 将这个点击下 点击ok,这样就添加成功了 点击ok 可以发现IDEA左侧多了一个Persistence ...
优品商城-注册登录（User、Member）
qq_39497997的博客
08-09 1260
1 登录 2 注册
学习笔记：MySQL数据库操作5
最新发布
2302_76908247的博客
07-25 783
触发器是数据库的一种高级功能，它允许在执行特定数据库操作（如INSERT、UPDATE、DELETE）之前或之后自动执行一段代码。存储过程是一组为了完成特定功能的SQL语句集合，可以接收输入参数，返回结果。这将返回部门编号为20的部门的平均工资。表中所有员工的姓名和工资。
MySQL索引例题
meow的博客
07-13 793
唯一性索引确保在列中的每个值都是唯一的，即不允许重复值。唯一性索引的好处是，当我们需要根据商品名称进行查询或者确保商品名称不重复时，查询效率会得到提升。然而，添加索引也会对数据库的写操作（插入、更新、删除）产生一定的性能开销，因为数据库需要维护索引的数据结构。需要注意的是，如果表中已经存在重复的商品名称，则添加唯一性索引时会失败，并且会返回一个错误。6、在 click_count 上增加普通索引，然后再删除 （分别使用drop index和alter table删除）类型的列，用于存储商品名称。
MySQL数据库
qq_45841548的博客
02-10 2929
一、数据库 1.数据库的介绍 数据库就是存储和管理数据的仓库，数据按照一定的格式进行存储，用户可以对数据库中的数据进行增加、删除、修改、查询等操作。 2.数据库的分类 数据库分为两类：关系型数据库和非关系型数据库。 ①关系型数据库：是指采用了关系模型来组织数据的数据库。简单来说，关系模型指的就是二维表格模型，类似于Excel文件中的表格，强调使用表格的方式存储数据。 关系型数据库中的核心元素： 数据行 数据列 数据表 数据库(数据表的集合) 常用的关系型数据库： Oracle Microsoft SQL
MySQL--创建表
jokerxue___的博客
07-14 1720
初学
商城系统商品属性的数据库设计思路
企业级技术与网站app运营
05-13 2098
思路二，使用key-value模型，使用动态行列转换模型，将商品属性信息碎片化存储，整合型只读输出快照，1、公共键值表，2、公共类表，3、公共键类表，4、属性值物化表，5、商品基本信息表，6、商品属性表，6、商品属性快照表或模型。假设要检索品牌为IBM或HP (在spec_ info表中的spec_ jinfo_ id 分别为1和2)，颜色为红色(在spec_ info表中的spec_ jinfo_ jid 为6)，尺码为15寸(在spec_goods_ spec_ jid 一商品属性id。
29--30商品规格表 虚拟商品表（共88张）
2302_79577253的博客
04-27 298
29--30商品规格表 虚拟商品表（共88张）
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值