/*
Navicat MySQL Data Transfer
Source Server : mysql168
Source Server Version : 50642
Source Host : 192.168.0.168:3306
Source Database : goods
Target Server Type : MYSQL
Target Server Version : 50642
File Encoding : 65001
Date: 2021-04-30 17:13:43
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for QX_GOODS
-- ----------------------------
DROP TABLE IF EXISTS `QX_GOODS`;
CREATE TABLE `QX_GOODS` (
`QX_GOODS_KEY` varchar(100) NOT NULL,
`TYPE_KEY` varchar(255) DEFAULT NULL COMMENT '分类',
`NAME` varchar(255) DEFAULT NULL COMMENT '名称',
`PATH` varchar(255) DEFAULT NULL COMMENT '图片',
`PRICE` varchar(255) DEFAULT NULL COMMENT '价格',
`PAY_NUM` varchar(255) DEFAULT NULL COMMENT '销量',
`STOCK` varchar(255) DEFAULT NULL COMMENT '库存',
`QUALITY` varchar(255) DEFAULT NULL COMMENT '保质期',
`ADD_DATE` varchar(255) DEFAULT NULL COMMENT '添加时间',
PRIMARY KEY (`QX_GOODS_KEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of QX_GOODS
-- ----------------------------
INSERT INTO `QX_GOODS` VALUES ('14973f68303941099cfa916dc75e3714', '0ba365e76f2a4daf8859d1791d79f436', '111', '1619608970807.png', '1111', '11', '111', '111', '2021-04-28 19:22:54');
INSERT INTO `QX_GOODS` VALUES ('191f8608281b46bdafd0c2af40760494', '0312fc81980443038ea84d86f98f94c2', '555', '1619702610050.png', '555', '555', '555', '555', '2021-04-29 21:23:35');
INSERT INTO `QX_GOODS` VALUES ('d0155fe4f6714ef48a18662d172df77f', '1540c1749cec4c219ae26698fef153c1', '666', '1619703289369.png', '666', '666', '666', '666', '2021-04-29 21:34:54');
INSERT INTO `QX_GOODS` VALUES ('fec4a173ad7044c6a84288811e02b0d5', '86e9bb8badc54fcca05490ea1b4809f0', '444', '1619702462479.png', '444', '444', '444', '444', '2021-04-29 21:21:06');
-- ----------------------------
-- Table structure for QX_PURCHASE
-- ----------------------------
DROP TABLE IF EXISTS `QX_PURCHASE`;
CREATE TABLE `QX_PURCHASE` (
`QX_PURCHASE_KEY` varchar(100) NOT NULL,
`NAME` varchar(255) DEFAULT NULL COMMENT '名称',
`PATH` varchar(255) DEFAULT NULL COMMENT '图片',
`PRICE` varchar(255) DEFAULT NULL COMMENT '进货价',
`STOCK` varchar(255) DEFAULT NULL COMMENT '数量',
`SUM_PRICE` varchar(255) DEFAULT NULL COMMENT '总价',
`ADD_DATE` varchar(255) DEFAULT NULL COMMENT '添加时间',
`USER_KEY` varchar(255) DEFAULT NULL,
PRIMARY KEY (`QX_PURCHASE_KEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of QX_PURCHASE
-- ----------------------------
INSERT INTO `QX_PURCHASE` VALUES ('05b0fc6898b040cb9b07743b6c351a42', '444', '1619702450638.png', '444', '555', '444', '2021-04-29 21:20:53', null);
INSERT INTO `QX_PURCHASE` VALUES ('4ee63c8e6818457cb25b298f379fce2b', '666', '1619703073432.png', '666', '666', '666', '2021-04-29 21:31:18', null);
INSERT INTO `QX_PURCHASE` VALUES ('6abcbd5147434790ab5ca375b919f7e2', '555', '1619702597683.png', '555', '555', '555', '2021-04-29 21:23:22', null);
INSERT INTO `QX_PURCHASE` VALUES ('6f98e7b2157d4836a68ff66c3d6c8981', '111', '1619608923077.png', '111', '111', '111', '2021-04-28 19:22:06', null);
-- ----------------------------
-- Table structure for QX_SALE
-- ----------------------------
DROP TABLE IF EXISTS `QX_SALE`;
CREATE TABLE `QX_SALE` (
`QX_SALE_KEY` varchar(100) NOT NULL,
`GOODS_KEY` varchar(255) DEFAULT NULL COMMENT '商品id',
`PRICE` varchar(255) DEFAULT NULL COMMENT '价格',
`STOCK` varchar(255) DEFAULT NULL COMMENT '数量',
`SUM_PRICE` varchar(255) DEFAULT NULL COMMENT '总价',
`ADD_DATE` varchar(255) DEFAULT NULL COMMENT '添加时间',
PRIMARY KEY (`QX_SALE_KEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of QX_SALE
-- ----------------------------
INSERT INTO `QX_SALE` VALUES ('3ca9efc63a484442a287aeb58c38fd08', 'fec4a173ad7044c6a84288811e02b0d5', '444', '444', '444', '2021-04-29 21:21:19');
INSERT INTO `QX_SALE` VALUES ('71c32a5f6708493985d76931b161e781', '191f8608281b46bdafd0c2af40760494', '555', '555', '555', '2021-04-29 21:23:45');
INSERT INTO `QX_SALE` VALUES ('884658a48f4349f0b2244ebb1e462a6a', '14973f68303941099cfa916dc75e3714', '111', '111', '111', '2021-04-28 19:25:34');
INSERT INTO `QX_SALE` VALUES ('f0b0cd40734941bf8a75f7e1f56cc23f', '14973f68303941099cfa916dc75e3714', '222', '111', '111', '2021-04-29 21:32:15');
-- ----------------------------
-- Table structure for QX_TYPE
-- ----------------------------
DROP TABLE IF EXISTS `QX_TYPE`;
CREATE TABLE `QX_TYPE` (
`QX_TYPE_KEY` varchar(100) NOT NULL,
`NAME` varchar(255) DEFAULT NULL COMMENT '鍚嶇О',
`ADD_DATE` varchar(255) DEFAULT NULL COMMENT '娣诲姞鏃堕棿',
PRIMARY KEY (`QX_TYPE_KEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of QX_TYPE
-- ----------------------------
INSERT INTO `QX_TYPE` VALUES ('0312fc81980443038ea84d86f98f94c2', '555', '2021-04-29 21:23:11');
INSERT INTO `QX_TYPE` VALUES ('0ba365e76f2a4daf8859d1791d79f436', '222', '2021-04-28 19:08:04');
INSERT INTO `QX_TYPE` VALUES ('1540c1749cec4c219ae26698fef153c1', '666', '2021-04-29 21:34:38');
INSERT INTO `QX_TYPE` VALUES ('40eb141e627b4112b002070e16be9039', '111', '2021-04-28 19:08:10');
INSERT INTO `QX_TYPE` VALUES ('65a68bfa67be4501a096d286cd5bb8e7', '333', '2021-04-28 19:08:01');
INSERT INTO `QX_TYPE` VALUES ('86e9bb8badc54fcca05490ea1b4809f0', '444', '2021-04-29 21:20:44');
-- ----------------------------
-- Table structure for QX_USER
-- ----------------------------
DROP TABLE IF EXISTS `QX_USER`;
CREATE TABLE `QX_USER` (
`QX_USER_KEY` varchar(100) NOT NULL,
`USERNAME` varchar(255) DEFAULT NULL COMMENT '用户名',
`PASSWORD` varchar(255) DEFAULT NULL COMMENT '密码',
`NAME` varchar(255) DEFAULT NULL COMMENT '姓名',
`SEX` varchar(255) DEFAULT NULL COMMENT '性别',
`TYPE` varchar(255) DEFAULT NULL COMMENT '类型',
`SCHOOL` varchar(255) DEFAULT NULL COMMENT '地址',
`PHONE` varchar(255) DEFAULT NULL COMMENT '联系方式',
`ADD_DATE` varchar(255) DEFAULT NULL COMMENT '添加时间',
PRIMARY KEY (`QX_USER_KEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of QX_USER
-- ----------------------------
INSERT INTO `QX_USER` VALUES ('01253e84b3db451eaecd59d11f00538f', '222', '222', '222', '男', '1', '2222', '222', '2021-04-28');
INSERT INTO `QX_USER` VALUES ('1ec648b80e3746228b6f30891c439836', '333', '444', '444', '男', '1', '333', '333', '2021-04-29');
INSERT INTO `QX_USER` VALUES ('44959f870fd54fb99470c5634aff58e2', '666', '666', '666', '女', '1', '666', '666', '2021-04-26');
INSERT INTO `QX_USER` VALUES ('5afcf0b1c0194337b9e1cf031496a9ef', '999', '999', '999', '男', '2', '999', '999', '2021-04-29');
INSERT INTO `QX_USER` VALUES ('7c62ff1188da45018586151efadcc4a3', '888', '888', '888', '男', '2', '河北省石家庄市桥西区', '12312312312', '2021-04-25');
INSERT INTO `QX_USER` VALUES ('ca106eadfe40471b835942c12cd06084', '111', '111', '222', '女', '1', '111', '111', '2021-04-28');
-- ----------------------------
-- Table structure for SYS_GL_QX
-- ----------------------------
DROP TABLE IF EXISTS `SYS_GL_QX`;
CREATE TABLE `SYS_GL_QX` (
`GL_ID` varchar(100) NOT NULL,
`ROLE_ID` varchar(100) DEFAULT NULL,
`FX_QX` decimal(10,0) DEFAULT NULL,
`FW_QX` decimal(10,0) DEFAULT NULL,
`QX1` decimal(10,0) DEFAULT NULL,
`QX2` decimal(10,0) DEFAULT NULL,
`QX3` decimal(10,0) DEFAULT NULL,
`QX4` decimal(10,0) DEFAULT NULL,
`QX5` decimal(10,0) DEFAULT '0' COMMENT '微信小程序管理员',
PRIMARY KEY (`GL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of SYS_GL_QX
-- ----------------------------
INSERT INTO `SYS_GL_QX` VALUES ('1', '0', '1', '1', '1', '1', '1', '1', '0');
INSERT INTO `SYS_G
中小型超市商品销售管理-源代码.zip
版权申诉
176 浏览量
2022-04-13
09:53:52
上传
评论
收藏 49.83MB ZIP 举报
程序员入门进阶
- 粉丝: 2329
- 资源: 968
最新资源
- 常用工具配置docker,elasticsearch,minio,nfs,nginx,tippercane,vsftp
- 基于IIC接口E2PROM(AT24C64)芯片FPGA读写VERILOG 设计源码+仿真激励文件.zip
- 基于FPGA深度学习的Block 模块方案实战,适合FPGA初学者
- 20225T9050袁凤(1).py
- Rsa算法详解.docx
- Youren Shang InClassQuiz.ipynb
- code-qat.zip
- usb-serial-for-android
- drools决策表示例Excel文件
- AD5724芯片FPGA Verilog驱动源码+4通道12bit位宽的DAC芯片AD5724技术手册.zip
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈