/*
Navicat MySQL Data Transfer
Source Server : rxl
Source Server Version : 50537
Source Host : localhost:3306
Source Database : factory_db
Target Server Type : MYSQL
Target Server Version : 50537
File Encoding : 65001
Date: 2021-07-24 11:00:41
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for manager_factory
-- ----------------------------
DROP TABLE IF EXISTS `manager_factory`;
CREATE TABLE `manager_factory` (
`id` int(11) NOT NULL,
`fname` varchar(50) NOT NULL,
PRIMARY KEY (`id`,`fname`),
KEY `FK_管理员与工厂关系2` (`fname`),
CONSTRAINT `FK_管理员与工厂关系` FOREIGN KEY (`id`) REFERENCES `t_manager` (`id`),
CONSTRAINT `FK_管理员与工厂关系2` FOREIGN KEY (`fname`) REFERENCES `t_factory` (`fname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='管理员与工厂关系';
-- ----------------------------
-- Table structure for production_material
-- ----------------------------
DROP TABLE IF EXISTS `production_material`;
CREATE TABLE `production_material` (
`mno` int(11) NOT NULL,
`pno` int(11) NOT NULL,
PRIMARY KEY (`mno`,`pno`),
KEY `FK_production_material2` (`pno`),
CONSTRAINT `FK_production_material` FOREIGN KEY (`mno`) REFERENCES `t_material` (`mno`),
CONSTRAINT `FK_production_material2` FOREIGN KEY (`pno`) REFERENCES `t_product` (`pno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='产品与材料的关系';
-- ----------------------------
-- Table structure for production_workshop
-- ----------------------------
DROP TABLE IF EXISTS `production_workshop`;
CREATE TABLE `production_workshop` (
`pno` int(11) NOT NULL,
`wno` int(11) NOT NULL,
PRIMARY KEY (`pno`,`wno`),
KEY `FK_production_workshop2` (`wno`),
CONSTRAINT `FK_production_workshop` FOREIGN KEY (`pno`) REFERENCES `t_product` (`pno`),
CONSTRAINT `FK_production_workshop2` FOREIGN KEY (`wno`) REFERENCES `t_workshop` (`wno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='产品与车间关系';
-- ----------------------------
-- Table structure for t_factory
-- ----------------------------
DROP TABLE IF EXISTS `t_factory`;
CREATE TABLE `t_factory` (
`fname` varchar(50) NOT NULL,
`fleader` varchar(20) NOT NULL,
`fintroduction` varchar(500) NOT NULL,
`fregistertTime` date NOT NULL,
`flocation` varchar(20) NOT NULL,
PRIMARY KEY (`fname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='工厂信息';
-- ----------------------------
-- Table structure for t_manager
-- ----------------------------
DROP TABLE IF EXISTS `t_manager`;
CREATE TABLE `t_manager` (
`id` int(11) NOT NULL,
`mname` varchar(20) NOT NULL,
`username` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`mtel` varchar(20) NOT NULL,
`memail` varchar(20) NOT NULL,
`mcategory` int(11) NOT NULL,
`mremark` varchar(300) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='管理员信息的表';
-- ----------------------------
-- Table structure for t_material
-- ----------------------------
DROP TABLE IF EXISTS `t_material`;
CREATE TABLE `t_material` (
`mno` int(11) NOT NULL,
`mname` varchar(20) NOT NULL,
`mnum` int(11) NOT NULL,
`mprice` int(11) NOT NULL,
`mremark` char(10) NOT NULL,
PRIMARY KEY (`mno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='产品所用材料信息';
-- ----------------------------
-- Table structure for t_product
-- ----------------------------
DROP TABLE IF EXISTS `t_product`;
CREATE TABLE `t_product` (
`pno` int(11) NOT NULL,
`hno` int(11) DEFAULT NULL,
`pname` varchar(20) NOT NULL,
`pprice` int(11) NOT NULL,
`wnumber` int(11) NOT NULL,
`premark` varchar(300) NOT NULL,
`pcreatTime` date NOT NULL,
PRIMARY KEY (`pno`),
KEY `FK_production_worehouse` (`hno`),
CONSTRAINT `FK_production_worehouse` FOREIGN KEY (`hno`) REFERENCES `t_worehouse` (`hno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='产品信息';
-- ----------------------------
-- Table structure for t_staff
-- ----------------------------
DROP TABLE IF EXISTS `t_staff`;
CREATE TABLE `t_staff` (
`sno` varchar(20) NOT NULL,
`wno` int(11) NOT NULL,
`fname` varchar(50) NOT NULL,
`sname` varchar(20) NOT NULL,
`scategory` varchar(10) NOT NULL,
`sage` int(11) NOT NULL,
`ssex` varchar(2) NOT NULL,
`stel` varchar(20) NOT NULL,
`sloation` varchar(20) NOT NULL,
`sID` varchar(20) NOT NULL,
`sremark` varchar(20) NOT NULL,
PRIMARY KEY (`sno`),
KEY `FK_staff_factory` (`fname`),
KEY `FK_staff_workshop` (`wno`),
CONSTRAINT `FK_staff_factory` FOREIGN KEY (`fname`) REFERENCES `t_factory` (`fname`),
CONSTRAINT `FK_staff_workshop` FOREIGN KEY (`wno`) REFERENCES `t_workshop` (`wno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='员工信息';
-- ----------------------------
-- Table structure for t_worehouse
-- ----------------------------
DROP TABLE IF EXISTS `t_worehouse`;
CREATE TABLE `t_worehouse` (
`hno` int(11) NOT NULL,
`hmanagerId` int(11) NOT NULL,
`hmanagerName` varchar(20) NOT NULL,
`htel` varchar(20) NOT NULL,
`hlocation` varchar(20) NOT NULL,
`hremark` varchar(300) NOT NULL,
PRIMARY KEY (`hno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='仓库信息';
-- ----------------------------
-- Table structure for t_workshop
-- ----------------------------
DROP TABLE IF EXISTS `t_workshop`;
CREATE TABLE `t_workshop` (
`wno` int(11) NOT NULL,
`fname` varchar(50) NOT NULL,
`wmanager` varchar(20) NOT NULL,
`wlocation` varchar(20) NOT NULL,
`wtel` varchar(20) NOT NULL,
`wremark` varchar(300) NOT NULL,
PRIMARY KEY (`wno`),
KEY `FK_workshop_factory` (`fname`),
CONSTRAINT `FK_workshop_factory` FOREIGN KEY (`fname`) REFERENCES `t_factory` (`fname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='车间信息';
-- ----------------------------
-- Table structure for worehouse_material
-- ----------------------------
DROP TABLE IF EXISTS `worehouse_material`;
CREATE TABLE `worehouse_material` (
`hno` int(11) NOT NULL,
`mno` int(11) NOT NULL,
PRIMARY KEY (`hno`,`mno`),
KEY `FK_worehouse_material2` (`mno`),
CONSTRAINT `FK_worehouse_material` FOREIGN KEY (`hno`) REFERENCES `t_worehouse` (`hno`),
CONSTRAINT `FK_worehouse_material2` FOREIGN KEY (`mno`) REFERENCES `t_material` (`mno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='仓库与材料的关系';
-- ----------------------------
-- Table structure for workshop_material
-- ----------------------------
DROP TABLE IF EXISTS `workshop_material`;
CREATE TABLE `workshop_material` (
`wno` int(11) NOT NULL,
`mno` int(11) NOT NULL,
PRIMARY KEY (`wno`,`mno`),
KEY `FK_workshop_material2` (`mno`),
CONSTRAINT `FK_workshop_material` FOREIGN KEY (`wno`) REFERENCES `t_workshop` (`wno`),
CONSTRAINT `FK_workshop_material2` FOREIGN KEY (`mno`) REFERENCES `t_material` (`mno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='车间与材料关系';
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
管理系统.zip (2个子文件)
管理系统(前后端)
数据库
factory_db.sql 7KB
源代码
factory.zip 3.15MB
共 2 条
- 1
技术很low的瓜贼
- 粉丝: 29
- 资源: 7
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
- 4
- 5
- 6
前往页