进销存管理系统springboot1.4

/* SQLyog v10.2 MySQL - 5.5.27 : Database - jxc ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`jxc` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `jxc`; /*Table structure for table `customer` */ DROP TABLE IF EXISTS `customer`; CREATE TABLE `customer` ( `customer_id` bigint(20) NOT NULL AUTO_INCREMENT, `address` varchar(255) DEFAULT NULL, `bank` varchar(255) DEFAULT NULL, `bank_account` bigint(20) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `link_man` varchar(255) DEFAULT NULL, `link_tel` varchar(255) DEFAULT NULL, `customer_name` varchar(255) DEFAULT NULL, `tel_phone` varchar(255) DEFAULT NULL, `zip` varchar(255) DEFAULT NULL, PRIMARY KEY (`customer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `customer` */ insert into `customer`(`customer_id`,`address`,`bank`,`bank_account`,`email`,`link_man`,`link_tel`,`customer_name`,`tel_phone`,`zip`) values (1,'江西省南昌市昌北经开区','南昌银行',137347874478935,'[email protected]','王琦','123456789','XXX电子上午有限公司','0790-7378785789','3274837'); /*Table structure for table `dept` */ DROP TABLE IF EXISTS `dept`; CREATE TABLE `dept` ( `dept_id` bigint(20) NOT NULL AUTO_INCREMENT, `dept_name` varchar(255) DEFAULT NULL, PRIMARY KEY (`dept_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `dept` */ /*Table structure for table `dept_emp` */ DROP TABLE IF EXISTS `dept_emp`; CREATE TABLE `dept_emp` ( `dept_dept_id` bigint(20) NOT NULL, `emp_employee_id` bigint(20) NOT NULL, PRIMARY KEY (`dept_dept_id`,`emp_employee_id`), UNIQUE KEY `UK_qq4f5qwsx62pxd4n9e36o2bo8` (`emp_employee_id`), CONSTRAINT `FKdoe5h9vyfn8rgkctpgf5187ek` FOREIGN KEY (`dept_dept_id`) REFERENCES `dept` (`dept_id`), CONSTRAINT `FKm56w74ah1p47kryw5g8owdcws` FOREIGN KEY (`emp_employee_id`) REFERENCES `employee` (`employee_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `dept_emp` */ /*Table structure for table `dept_man` */ DROP TABLE IF EXISTS `dept_man`; CREATE TABLE `dept_man` ( `dept_dept_id` bigint(20) NOT NULL, `man_managers_id` bigint(20) NOT NULL, PRIMARY KEY (`dept_dept_id`,`man_managers_id`), UNIQUE KEY `UK_kng1bmi31mltq7sp124vbrxw8` (`man_managers_id`), CONSTRAINT `FKcy4hbwca5nvv48pqmhmtyo9jg` FOREIGN KEY (`man_managers_id`) REFERENCES `managers` (`managers_id`), CONSTRAINT `FKrby2ojom9201o9raqmi0ohh9c` FOREIGN KEY (`dept_dept_id`) REFERENCES `dept` (`dept_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `dept_man` */ /*Table structure for table `employee` */ DROP TABLE IF EXISTS `employee`; CREATE TABLE `employee` ( `employee_id` bigint(20) NOT NULL AUTO_INCREMENT, `employee_age` bigint(20) DEFAULT NULL, `employee_gender` varchar(255) DEFAULT NULL, `employee_name` varchar(255) DEFAULT NULL, `employee_password` varchar(255) DEFAULT NULL, `employee_phonenumber` varchar(255) DEFAULT NULL, PRIMARY KEY (`employee_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `employee` */ insert into `employee`(`employee_id`,`employee_age`,`employee_gender`,`employee_name`,`employee_password`,`employee_phonenumber`) values (1,22,'男','赵琪','123456','123456789'); /*Table structure for table `goods` */ DROP TABLE IF EXISTS `goods`; CREATE TABLE `goods` ( `goods_id` bigint(20) NOT NULL AUTO_INCREMENT, `approve_id` varchar(255) DEFAULT NULL, `batch_id` varchar(255) DEFAULT NULL, `goods_name` varchar(255) NOT NULL, `price` double DEFAULT NULL, `space` varchar(255) DEFAULT NULL, `supplier_id` bigint(20) DEFAULT NULL, `unit` varchar(255) DEFAULT NULL, PRIMARY KEY (`goods_id`), UNIQUE KEY `UK_8nlyljvfo33wg4ei3nx2fujdr` (`goods_name`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8; /*Data for the table `goods` */ insert into `goods`(`goods_id`,`approve_id`,`batch_id`,`goods_name`,`price`,`space`,`supplier_id`,`unit`) values (1,'13243434564','65454213113','apple',6777,'上海',121323,'台'),(2,'13243434564','65454213113','魅族',3333,'珠海',12332,'台'),(5,'13243434564','65454213113','小米',3333,'北京',12332,'台'),(6,'13243434564','65454213113','魅蓝',1222,'珠海',121323,'台'),(7,'13243434564','65454213113','apple6s',6777,'上海',121323,'台'),(8,'13243434564','65454213113','apple7',6777,'珠海',121323,'台'),(9,'13243434564','65454213113','iphone5s',6777,'上海',121323,'台'),(10,'13243434564','65454213113','魅蓝4',1222,'珠海',121323,'台'),(11,'13243434564','65454213113','魅族6',3333,'珠海',121323,'台'),(12,'13243434564','65454213113','iphone7p',6777,'北京',121323,'台'),(13,'13243434564','65454213113','魅族6p',3333,'珠海',121323,'台'),(14,'13243434564','65454213113','小米6s',3333,'珠海',121323,'台'),(15,'13243434564','65454213113','opple',2333,'上海',12332,'台'),(16,'13243434564','65454213113','vivo Xplay7',2333,'珠海',1001,'台'),(17,'13243434564','65454213113','iphone7ps',6777,'上海',1001,'台'),(18,'13243434564','65454213113','魅蓝note',1222,'珠海',1001,'台'),(19,'13243434564','65454213113','iPhone4s',4567,'上海',1001,'台'); /*Table structure for table `managers` */ DROP TABLE IF EXISTS `managers`; CREATE TABLE `managers` ( `managers_id` bigint(20) NOT NULL AUTO_INCREMENT, `managers_age` bigint(20) DEFAULT NULL, `managers_gender` varchar(255) DEFAULT NULL, `managers_name` varchar(255) DEFAULT NULL, `managers_password` varchar(255) DEFAULT NULL, `managers_phonenumber` varchar(255) DEFAULT NULL, PRIMARY KEY (`managers_id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; /*Data for the table `managers` */ insert into `managers`(`managers_id`,`managers_age`,`managers_gender`,`managers_name`,`managers_password`,`managers_phonenumber`) values (1,22,'男','张三','e10adc3949ba59abbe56e057f20f883e','123456789'),(2,22,'男','李四','e10adc3949ba59abbe56e057f20f883e','123456789'),(6,22,'男','tom','e10adc3949ba59abbe56e057f20f883e','123456789'),(7,34,'男','王远','e10adc3949ba59abbe56e057f20f883e','123456789'),(8,33,'女','李丽珊','e10adc3949ba59abbe56e057f20f883e','123456789'); /*Table structure for table `message` */ DROP TABLE IF EXISTS `message`; CREATE TABLE `message` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `date` datetime DEFAULT NULL, `msg` varchar(255) DEFAULT NULL, `flag` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; /*Data for the table `message` */ insert into `message`(`id`,`date`,`msg`,`flag`) values (1,'2017-05-11 14:50:37','小米6s库存不足100，现在剩余33件！！！',NULL),(2,'2017-05-11 16:36:48','小米6s库存不足100，现在剩余33件！！！','已查看'),(3,'2017-05-11 16:44:45','小米6s库存不足100，现在剩余33件！！！','未查看'),(4,'2017-05-12 11:35:50','小米6s库存不足100，现在剩余33件！！！','未查看'),(5,'2017-05-12 13:31:44','小米6s库存不足100，现在剩余33件！！！','未查看'),(6,'2017-05-12 13:39:21','小米6s库存不足100，现在剩余33件！！！','未查看'),(7,'2017-05-12 14:04:56','小米6s库存不足100，现在剩余33件！！！','未查看'); /*Table structure for table `purchase_item` */ DROP TABLE IF EXISTS `purchase_item`; CREATE TABLE `purchase_item` ( `purchase_item_id` bigint(20) NOT NULL AUTO_INCREMENT, `purchase_count` bigint(20) DEFAULT NULL, `name` varchar(255) DEFAULT