/*
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,'abc@123.com','王琦','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
没有合适的资源?快使用搜索试试~ 我知道了~
进销存管理系统springboot1.4
共2个文件
rar:1个
sql:1个
3星 · 超过75%的资源 需积分: 50 88 下载量 170 浏览量
2019-01-21
18:29:10
上传
评论 9
收藏 9.12MB RAR 举报
温馨提示
数据库:MySQL; 语言:JAVA; 架构:springboot+maven 功能:采购管理、库存管理、销售管理、查询统计、资料管理、系统管理
资源推荐
资源详情
资源评论
收起资源包目录
进销存管理系统.rar (2个子文件)
进销存管理系统
数据库
jxc.sql 17KB
源代码
Invoicing.rar 9.7MB
共 2 条
- 1
资源评论
- zhen19862020-11-06不能直接用
- qq_347953982020-08-06项目访问路径呢
- 创誉代码2019-06-14设计思路可以,适合作为参考用
- Criske2019-05-10设计思路可以,适合作为参考用
一点博客
- 粉丝: 215
- 资源: 38
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功