?? logistic.sql

?? java畢業設計
?? SQL
?? 第 1 頁 / 共 2 頁
字號:
12 下一頁
-- MySQL dump 10.11
--
-- Host: localhost    Database: logistic
-- ------------------------------------------------------
-- Server version	5.0.37-community-nt

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES gbk */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

--
-- Table structure for table `carmanagetable`
--

DROP TABLE IF EXISTS `carmanagetable`;
CREATE TABLE `carmanagetable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '車輛信息表自動ID',
  `CarId` varchar(20) NOT NULL COMMENT '車輛Id',
  `CarDriverId` varchar(20) NOT NULL COMMENT '司機Id',
  `CarTeamId` varchar(20) NOT NULL COMMENT '車隊Id',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `CarId` (`CarId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `carmanagetable`
--

LOCK TABLES `carmanagetable` WRITE;
/*!40000 ALTER TABLE `carmanagetable` DISABLE KEYS */;
INSERT INTO `carmanagetable` VALUES (1,'豫ACC277','10009','10005'),(2,'豫ADC200','10009','10009'),(3,'豫A87627','10007','10009'),(4,'豫B23147','10008','10006');
/*!40000 ALTER TABLE `carmanagetable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `carteaminfotable`
--

DROP TABLE IF EXISTS `carteaminfotable`;
CREATE TABLE `carteaminfotable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '車隊信息表自動ID',
  `CarTeamId` varchar(20) NOT NULL COMMENT '車隊Id',
  `CarTeamName` varchar(20) NOT NULL COMMENT '車隊名稱',
  `ChargeId` varchar(20) NOT NULL COMMENT '負責人Id',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `CarTeamId` (`CarTeamId`),
  KEY `FK_carteaminfo_employee` (`ChargeId`),
  CONSTRAINT `carteaminfotable_ibfk_1` FOREIGN KEY (`ChargeId`) REFERENCES `employeeinfotable` (`EmployeeId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `carteaminfotable`
--

LOCK TABLES `carteaminfotable` WRITE;
/*!40000 ALTER TABLE `carteaminfotable` DISABLE KEYS */;
INSERT INTO `carteaminfotable` VALUES (5,'10005','第一車隊','10005'),(6,'10006','第二車隊','10006'),(7,'10007','第三車隊','10005'),(8,'10008','第五車隊','10006'),(9,'10009','第四車隊','10007');
/*!40000 ALTER TABLE `carteaminfotable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `commcatetable`
--

DROP TABLE IF EXISTS `commcatetable`;
CREATE TABLE `commcatetable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '商品分類表自動ID',
  `CommodityId` varchar(20) NOT NULL COMMENT '商品分類Id',
  `CommodityName` varchar(20) NOT NULL COMMENT '商品分類名稱',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `CommodityId` (`CommodityId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `commcatetable`
--

LOCK TABLES `commcatetable` WRITE;
/*!40000 ALTER TABLE `commcatetable` DISABLE KEYS */;
INSERT INTO `commcatetable` VALUES (1,'10001','電視'),(2,'10002','空調'),(3,'10003','冰箱'),(4,'10004','電腦'),(5,'10005','洗衣機'),(6,'10006','廚具'),(7,'10007','手機');
/*!40000 ALTER TABLE `commcatetable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `departmentinfotable`
--

DROP TABLE IF EXISTS `departmentinfotable`;
CREATE TABLE `departmentinfotable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '部門信息表自動ID',
  `DepartmentId` varchar(20) NOT NULL COMMENT '部門Id',
  `DepartmentName` varchar(20) NOT NULL COMMENT '部門名稱',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `DepartmentId` (`DepartmentId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `departmentinfotable`
--

LOCK TABLES `departmentinfotable` WRITE;
/*!40000 ALTER TABLE `departmentinfotable` DISABLE KEYS */;
INSERT INTO `departmentinfotable` VALUES (1,'1001','研發部'),(2,'1002','銷售部'),(3,'1003','采購部'),(4,'1004','售后服務部'),(5,'1005','維修部'),(6,'1007','內勤部'),(7,'1008','運輸部');
/*!40000 ALTER TABLE `departmentinfotable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `diplomainfotable`
--

DROP TABLE IF EXISTS `diplomainfotable`;
CREATE TABLE `diplomainfotable` (
  `ID` int(4) NOT NULL auto_increment,
  `DiplomaName` varchar(20) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `diplomainfotable`
--

LOCK TABLES `diplomainfotable` WRITE;
/*!40000 ALTER TABLE `diplomainfotable` DISABLE KEYS */;
INSERT INTO `diplomainfotable` VALUES (1,'博士后'),(2,'博士'),(3,'碩士'),(4,'學士'),(5,'大專'),(6,'高中'),(7,'中專'),(8,'初中'),(9,'小學');
/*!40000 ALTER TABLE `diplomainfotable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employeeinfotable`
--

DROP TABLE IF EXISTS `employeeinfotable`;
CREATE TABLE `employeeinfotable` (
  `ID` int(8) NOT NULL auto_increment COMMENT '職員信息表自動ID',
  `EmployeeId` varchar(20) NOT NULL COMMENT '職員Id',
  `EmployeeName` varchar(20) NOT NULL COMMENT '職員姓名',
  `EmployeeSex` varchar(4) NOT NULL COMMENT '職員性別',
  `EmployeeAge` int(3) NOT NULL COMMENT '職員年齡',
  `EmployeeIdenCard` varchar(20) NOT NULL COMMENT '職員身份證號',
  `EmployeeBirthDate` varchar(20) default NULL COMMENT '職員出生日期',
  `EmployeeDiploma` varchar(20) NOT NULL COMMENT '職員學歷',
  `EmployeeJoinDate` varchar(20) default NULL COMMENT '職員加入公司日期',
  `EmployeeAdd` varchar(50) NOT NULL COMMENT '職員家庭住址',
  `EmployeePhone` varchar(20) default NULL COMMENT '職員固定電話',
  `EmployeeMobile` varchar(20) default NULL COMMENT '職員移動電話',
  `DepartmentId` varchar(20) NOT NULL COMMENT '職員所屬部門編號',
  `JobsId` varchar(20) NOT NULL COMMENT '職員的職務編號',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `EmployeeId` (`EmployeeId`),
  KEY `FK_employeeinfo_department` (`DepartmentId`),
  CONSTRAINT `employeeinfotable_ibfk_1` FOREIGN KEY (`DepartmentId`) REFERENCES `departmentinfotable` (`DepartmentId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `employeeinfotable`
--

LOCK TABLES `employeeinfotable` WRITE;
/*!40000 ALTER TABLE `employeeinfotable` DISABLE KEYS */;
INSERT INTO `employeeinfotable` VALUES (4,'10003','蘇長城','男',23,'410108198309110515','1983-12-14','2','2001-12-11','河南省周口市','037163982910','13837178301','1001','1001'),(6,'10005','陳凱','男',24,'410108198309110515','1983-09-11','1','2002-09-12','河南省鄭州市惠濟區','037163982910','13837178301','1001','1007'),(7,'10006','張冠軍','男',25,'410108198309110511','2007-04-27','1','2007-04-14','河南省平頂山市','037163982910','13837178301','1001','1001'),(8,'10007','馮杰','女',30,'410108198309110515','1982-04-23','1','2003-07-18','河南省信陽市','037163982910','13837178301','1002','1010'),(9,'10008','程傳林','男',25,'410108198209120516','1982-03-22','3','2002-06-11','河南省信陽市','037163982910','13837178301','1008','1010'),(10,'10009','肖雷','男',25,'410108198309110519','1981-09-15','4','2001-12-11','河南省鶴壁市','037163982910','13837178301','1008','1010');
/*!40000 ALTER TABLE `employeeinfotable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goodsinfotable`
--

DROP TABLE IF EXISTS `goodsinfotable`;
CREATE TABLE `goodsinfotable` (
  `ID` int(8) NOT NULL auto_increment COMMENT '商品信息表自動ID',
  `GoodsId` varchar(20) NOT NULL COMMENT '商品Id',
  `GoodsName` varchar(20) NOT NULL COMMENT '商品名稱',
  `GoodsCateId` varchar(20) NOT NULL COMMENT '商品分類Id',
  `GoodsSupplyId` varchar(20) NOT NULL COMMENT '商品供應商Id',
  `GoodsABC` varchar(10) NOT NULL COMMENT '商品ABC分類',
  `GoodsProvince` varchar(20) NOT NULL COMMENT '商品產地省',
  `GoodsCity` varchar(20) NOT NULL COMMENT '商品產地市',
  `GoodsStockId` varchar(20) NOT NULL COMMENT '商品所在倉庫Id',
  `GoodsPrice` float NOT NULL COMMENT '商品單價',
  `GoodsStockNumber` int(8) NOT NULL COMMENT '商品庫存量',
  `GoodsOrderDate` varchar(20) NOT NULL COMMENT '商品定購日期',
  `GoodsStockInDate` varchar(20) NOT NULL COMMENT '商品入庫日期',
  `GoodsUnit` varchar(4) NOT NULL COMMENT '商品單位',
  `StockRegionId` varchar(20) NOT NULL COMMENT '商品在庫中位置編號',
  `TypeId` varchar(20) NOT NULL COMMENT '商品型號Id',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `GoodsId` (`GoodsId`),
  KEY `FK_goodinfo_supply` (`GoodsSupplyId`),
  KEY `FK_goodinfo_warehouse` (`GoodsStockId`),
  KEY `FK_goodinfo_commoditycate` (`GoodsCateId`),
  CONSTRAINT `goodsinfotable_ibfk_1` FOREIGN KEY (`GoodsSupplyId`) REFERENCES `supplytable` (`SupplyId`),
  CONSTRAINT `goodsinfotable_ibfk_2` FOREIGN KEY (`GoodsStockId`) REFERENCES `warehouseinfotable` (`WareHouseId`),
  CONSTRAINT `goodsinfotable_ibfk_3` FOREIGN KEY (`GoodsCateId`) REFERENCES `commcatetable` (`CommodityId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `goodsinfotable`
--

LOCK TABLES `goodsinfotable` WRITE;
/*!40000 ALTER TABLE `goodsinfotable` DISABLE KEYS */;
INSERT INTO `goodsinfotable` VALUES (1,'10001','長虹34寸液晶彩電','10001','10001','A','四川省','成都市','10001',10000,30,'2005-04-20','2007-04-18','臺','10001','10002'),(2,'10002','長虹普通25寸彩電','10001','10001','A','四川省','成都市','10001',2500,30,'2004-04-07','2004-06-16','臺','10002','10001'),(3,'10003','長虹29寸平板彩電','10001','10001','B','四川省','成都市','10001',3000,20,'2004-06-17','2004-09-10','臺','10003','10001');
/*!40000 ALTER TABLE `goodsinfotable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goodslocationtable`
--

DROP TABLE IF EXISTS `goodslocationtable`;
CREATE TABLE `goodslocationtable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '商品在倉庫中位置表自動ID',
  `LocationId` varchar(20) NOT NULL COMMENT '商品位置Id',
  `LocationName` varchar(20) NOT NULL COMMENT '商品位置名稱',
  PRIMARY KEY  (`ID`,`LocationId`),
  UNIQUE KEY `LocationId` (`LocationId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `goodslocationtable`
--

LOCK TABLES `goodslocationtable` WRITE;
/*!40000 ALTER TABLE `goodslocationtable` DISABLE KEYS */;
INSERT INTO `goodslocationtable` VALUES (1,'1001','東一區'),(2,'1002','東二區'),(3,'1003','東三區'),(4,'1004','東四區'),(5,'1005','東五區'),(6,'1006','西一區'),(7,'1007','西二區'),(8,'1008','西三區'),(9,'1009','西四區'),(10,'1010','西五區'),(11,'1011','南一區'),(12,'1012','南二區'),(13,'1013','南三區'),(14,'1014','南四區'),(15,'1015','南五區'),(16,'1016','北一區'),(17,'1017','北二區'),(18,'1018','北三區'),(19,'1019','北四區'),(20,'1020','北五區');
/*!40000 ALTER TABLE `goodslocationtable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goodsrowstable`
--

DROP TABLE IF EXISTS `goodsrowstable`;
CREATE TABLE `goodsrowstable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '商品在倉庫排號表自動ID',
  `RowsId` varchar(20) NOT NULL COMMENT '排號Id',
  `RowsName` varchar(20) NOT NULL COMMENT '排號名稱',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `RowsId` (`RowsId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `goodsrowstable`
--

LOCK TABLES `goodsrowstable` WRITE;
/*!40000 ALTER TABLE `goodsrowstable` DISABLE KEYS */;
INSERT INTO `goodsrowstable` VALUES (1,'1001','一排'),(2,'1002','二排'),(3,'1003','三排'),(4,'1004','四排'),(5,'1005','五排'),(6,'1006','六排'),(7,'1007','七排'),(8,'1008','八排'),(9,'1009','九排'),(10,'1010','十排'),(11,'1011','十一排'),(12,'1012','十二排'),(13,'1013','十三排'),(14,'1014','十四排'),(15,'1015','十五排'),(16,'1016','十六排'),(17,'1017','十七排'),(18,'1018','十八排'),(19,'1019','十九排'),(20,'1020','二十排');
/*!40000 ALTER TABLE `goodsrowstable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goodsseatstable`
--

DROP TABLE IF EXISTS `goodsseatstable`;
CREATE TABLE `goodsseatstable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '商品在倉庫座號表自動ID',
  `SeatsId` varchar(20) NOT NULL COMMENT '商品位Id',
12 下一頁
?? 文件大小 1998 K
?? 上傳用戶 dsjacky
?? 所屬分類 Java編程
??? 相關標簽

#java #畢業設計
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? logistic.sql

?? 快捷鍵說明
