/*
Navicat MySQL Data Transfer
Source Server : RDZ
Source Server Version : 50703
Source Host : localhost:3306
Source Database : 库存与存货系统
Target Server Type : MYSQL
Target Server Version : 50703
File Encoding : 65001
Date: 2018-07-14 14:02:53
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `customer`
-- ----------------------------
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
`CustomerID` varchar(5) NOT NULL,
`CompanyName` varchar(40) NOT NULL,
`ContactName` varchar(30) NOT NULL,
`ContactTitle` varchar(30) DEFAULT NULL,
`Address` varchar(60) DEFAULT NULL,
`City` varchar(15) DEFAULT NULL,
`Region` varchar(15) DEFAULT NULL,
`PostalCode` varchar(10) DEFAULT NULL,
`Country` varchar(15) DEFAULT NULL,
`Phone` varchar(24) DEFAULT NULL,
`Fax` varchar(24) NOT NULL,
PRIMARY KEY (`CustomerID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of customer
-- ----------------------------
-- ----------------------------
-- Table structure for `employee`
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
`EmployeeID` int(4) NOT NULL,
`LastName` varchar(20) DEFAULT NULL,
`FirstName` varchar(30) DEFAULT NULL,
`Title` varchar(30) DEFAULT NULL,
`TitleofCountry` varchar(25) DEFAULT NULL,
`BirthDate` varchar(255) DEFAULT NULL,
`HireDate` varchar(255) DEFAULT NULL,
`Address` varchar(60) DEFAULT NULL,
`City` varchar(35) DEFAULT NULL,
`Region` varchar(35) DEFAULT NULL,
`PostalCode` varchar(30) DEFAULT NULL,
`Country` varchar(15) DEFAULT NULL,
`HomePhone` varchar(24) DEFAULT NULL,
`Extension` varchar(20) DEFAULT NULL,
`Notes` text,
`ReportsTo` varchar(30) DEFAULT NULL,
`PhotoPath` varchar(255) DEFAULT NULL,
`account` varchar(10) NOT NULL,
PRIMARY KEY (`EmployeeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of employee
-- ----------------------------
INSERT INTO `employee` VALUES ('1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '1');
INSERT INTO `employee` VALUES ('2', '1', '2', '1', '2', '1', '2', '1', '2', '1', '2', '1', '2', '1', '2', '1', '55.gif', '2');
INSERT INTO `employee` VALUES ('3', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '3');
INSERT INTO `employee` VALUES ('4', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '4');
INSERT INTO `employee` VALUES ('5', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '5');
-- ----------------------------
-- Table structure for `goods`
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
`GoodsID` varchar(10) NOT NULL,
`GoodsName` varchar(20) NOT NULL,
`G_Category` varchar(20) NOT NULL,
`GoodsNum` int(4) NOT NULL,
`GoodsPrice` int(4) NOT NULL,
`GoodsCalculate` varchar(10) NOT NULL,
`GoodsDate` datetime(6) NOT NULL,
`BatchNumber` varchar(10) NOT NULL,
`G_Specifications` varchar(30) DEFAULT NULL,
`Color` varchar(10) NOT NULL,
`Hard` varchar(5) NOT NULL,
`HighNum` int(4) DEFAULT NULL,
`LowNum` int(4) DEFAULT NULL,
`SafeNum` int(4) DEFAULT NULL,
`Notes` varchar(255) DEFAULT NULL,
PRIMARY KEY (`GoodsID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES ('10001', '肠炎宁', '胃药类', '0', '44', '盒', '2018-07-25 18:34:43.000000', '2', '绿色药丸', '绿色', '1', '10000', '100', '1000', null);
INSERT INTO `goods` VALUES ('10002', '急支糖浆', '咽喉类', '100', '40', '瓶', '2018-07-14 13:21:10.000000', '1111', '杏仁香微苦', '褐色', '0.11', '10000', '100', '2000', null);
INSERT INTO `goods` VALUES ('10003', '999感冒灵', '感冒类', '50', '20', '盒', '2018-07-05 10:49:26.000000', '120', '粉末状微黄,甜', '微黄', '0.005', '9000', '1000', '4000', null);
INSERT INTO `goods` VALUES ('10004', '维生素A', '维生素类', '400', '21', '瓶', '2018-07-12 13:23:24.000000', '1111', '类似糖果微甜', '淡黄色', '3', '5500', '500', '2500', null);
INSERT INTO `goods` VALUES ('10005', '六味地黄丸', '保健类', '100', '100', '瓶', '2018-07-05 10:46:23.000000', '110', '色黄微苦', '黄', '0.1', '4000', '500', '1000', null);
INSERT INTO `goods` VALUES ('10006', '健胃消食片', '饮食类', '43', '25', '盒', '2018-07-04 14:37:07.000000', '111', '褐色,微甜', '褐色', '0.5', '200000', '5000', '50000', null);
-- ----------------------------
-- Table structure for `goods_linshi`
-- ----------------------------
DROP TABLE IF EXISTS `goods_linshi`;
CREATE TABLE `goods_linshi` (
`goodsID` varchar(10) NOT NULL,
`goodsName` varchar(255) DEFAULT NULL,
`M_Category` varchar(10) DEFAULT NULL,
`goodsNum` int(8) DEFAULT NULL,
`goodsPrice` int(8) DEFAULT NULL,
`goodsCalculate` varchar(10) DEFAULT NULL,
`date` datetime(6) DEFAULT NULL,
`BatchNumber` varchar(10) DEFAULT NULL,
`M_Specifications` varchar(255) DEFAULT NULL,
`Color` varchar(10) DEFAULT NULL,
`Hard` varchar(10) DEFAULT NULL,
`SupplierID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`goodsID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of goods_linshi
-- ----------------------------
-- ----------------------------
-- Table structure for `g_category`
-- ----------------------------
DROP TABLE IF EXISTS `g_category`;
CREATE TABLE `g_category` (
`G_CategoryID` varchar(10) NOT NULL,
`CategoryName` varchar(10) DEFAULT NULL,
`Description` text,
`PicturePath` varchar(255) DEFAULT NULL,
PRIMARY KEY (`G_CategoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of g_category
-- ----------------------------
-- ----------------------------
-- Table structure for `g_indetail`
-- ----------------------------
DROP TABLE IF EXISTS `g_indetail`;
CREATE TABLE `g_indetail` (
`StorageID` char(10) NOT NULL,
`G_ID` varchar(10) DEFAULT NULL,
`Specifications` varchar(20) DEFAULT NULL,
`Calculate` varchar(10) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`EmployeeID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`StorageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of g_indetail
-- ----------------------------
-- ----------------------------
-- Table structure for `g_instorage`
-- ----------------------------
DROP TABLE IF EXISTS `g_instorage`;
CREATE TABLE `g_instorage` (
`StroageID` varchar(10) NOT NULL,
`WarehouseID` varchar(10) DEFAULT NULL,
`InDate` datetime(6) DEFAULT NULL,
`InCategory` varchar(10) DEFAULT NULL,
`DepartID` varchar(10) DEFAULT NULL,
`BatchNumber` varchar(10) DEFAULT NULL,
`Notes` text,
`OriginatorID` varchar(10) DEFAULT NULL,
`AuditorID` varchar(10) DEFAULT NULL,
`BookkeeperID` varchar(10) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`HighNum` int(4) DEFAULT NULL,
`LowNum` int(4) DEFAULT NULL,
`SafeNum` int(4) DEFAULT NULL,
`EmployeeID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`StroageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of g_instorage
-- ----------------------------
-- ----------------------------
-- Table structure for `g_outdetails`
-- ----------------------------
DROP TABLE IF EXISTS `g_outdetails`;
CREATE TABLE `g_outdetails` (
`OutstorageID` varchar(10) NOT NULL,
`ProductID` varchar(10) DEFAULT NULL,
`Specifications` varchar(20) DEFAULT NULL,
`Calculate` varchar(10) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`CostObject` varchar(20) DEFAULT NULL,
PRIMARY KEY (`OutstorageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of g_outdetails
-- ----------------------------
-- ----------------------------
-- Table structure for `g_outstorage`
-- ----------------------------
DROP TABLE IF EXISTS `g_outstorage`;
CREATE TABLE `g_outstorage` (
`OutStorageID` varchar(10) NOT NULL,
`WarehouseID` varchar(10) DEFAULT NULL,
`OutDate` datetime(6) DEFAULT NULL,
`OutCategory` varchar(10) DEFAULT NULL,
`BusinessNumber` varchar(20) DEFAULT NULL,
`DepartID` varchar(10) DEFAULT NULL,
`MakerID` varchar(10) DEFAULT NULL,
`CheckID` varchar(10) DEFAULT NULL,
`HighNum` int(4) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`WriteID` varchar(10) DEFAULT NULL,
`LowNum` int(4) DEFAULT NULL,
`SafeNum` int(4) DEFAULT NULL,
`ProduceID` varchar(10) DEFAULT NULL,
`Notes` text,
PRIMARY KEY (`OutStorageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of g_outstorage
-- ----------------------------
-- ----------------------------
-- Table structure for `inform`
-- ----------------------------
DROP TABLE IF EXISTS `inform`;
CREATE TABLE `inform` (
`date` varchar(255) NOT NULL,
`message` longtext,
PRIMARY KEY (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of inform
-- ----------------------------
INSERT INTO `inform` VALUES ('20170708', '10001价格+10%');
INSERT INTO `inform` VALUES ('20180701', '10002价格-1%');
INSERT INTO `inform` VALUES ('20180702', '10003价格+5%');
INSERT INTO `inform` VALUES ('20180703', '10006价格+19%');
INSERT INTO `inform` VALUES ('20180704', '10001价格-11%');
INSERT INTO `inform` VALUES ('20180705', '10005价格+9%');
INSERT INTO `inform` VALUES ('20180706', '10004价格-8%');
INSERT INTO `inform` VALUES ('20180707', '10001价格+1%');
INSERT INTO `inform` VALUES ('20180709', '10001价格+7%');
-- ----------------------------
-- Table structure for `inventory`
-- ----------------------------
DROP TABLE IF EXISTS `inventory`;
CREATE TABLE `inventory` (
`InventoryID` varchar(10) NOT NULL,
`InventoryDate` datetime(6) DEFAULT NULL,
`WarehouseID` varchar(10) DEFAULT NULL,
`DepartID` varchar(10) DEFAULT NULL,
`OutCategory` varchar(20) DEFAULT NULL,
`InCategory` varchar(10) DEFAULT NULL,
`HandleIID` varchar(10) DEFAULT NULL,
`Notes` longtext,
PRIMARY KEY (`InventoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of inventory
-- ----------------------------
-- ----------------------------
-- Table structure for `inventorydetails`
-- ----------------------------
DROP TABLE IF EXISTS `inventorydetails`;
CREATE TABLE `inventorydetails` (
`inventoryid` varchar(10) NOT NULL,
`color` varchar(10) NOT NULL,
`hard` varchar(20) NOT NULL,
`G_M_ID` varchar(20) DEFAULT NULL,
`batchnumber` varchar(20) DEFAULT NULL,
`listnum` varchar(20) DEFAULT NULL,
`inventorynum` int(4) DEFAULT NULL,
`profitnum` int(4) DEFAULT NULL,
`reason` varchar(255) DEFAULT NULL,
PRIMARY KEY (`inventoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of inventorydetails
-- ----------------------------
INSERT INTO `inventorydetails` VALUES ('', '1', '1', '1', '1', '1', '1', '1', '1');
-- ----------------------------
-- Table structure for `linshishengchan`
-- ----------------------------
DROP TABLE IF EXISTS `linshishengchan`;
CREATE TABLE `linshishengchan` (
`ID` varchar(10) NOT NULL,
`Name` varchar(255) DEFAULT NULL,
`Category` varchar(20) DEFAULT NULL,
`Num` int(8) DEFAULT NULL,
`A_1` varchar(40) DEFAULT NULL,
`A_2` varchar(40) DEFAULT NULL,
`A_3` varchar(40) DEFAULT NULL,
`A_4` int(8) DEFAULT NULL,
`A_5` int(8) DEFAULT NULL,
`A_6` varchar(40) DEFAULT NULL,
`A_7` datetime(6) DEFAULT NULL,
`A_8` varchar(40) DEFAULT NULL,
`A_9` varchar(40) DEFAULT NULL,
`A_10` varchar(40) DEFAULT NULL,
`A_11` int(8) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of linshishengchan
-- ----------------------------
-- ----------------------------
-- Table structure for `login`
-- ----------------------------
DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
`account` varchar(10) NOT NULL,
`password` varchar(10) NOT NULL,
`DepartID` int(10) NOT NULL,
PRIMARY KEY (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of login
-- ----------------------------
INSERT INTO `login` VALUES ('1', '1', '1');
INSERT INTO `login` VALUES ('2', '2', '2');
INSERT INTO `login` VALUES ('3', '3', '3');
INSERT INTO `login` VALUES ('4', '4', '4');
INSERT INTO `login` VALUES ('5', '5', '5');
-- ----------------------------
-- Table structure for `material`
-- ----------------------------
DROP TABLE IF EXISTS `material`;
CREATE TABLE `material` (
`MaterialID` varchar(10) NOT NULL,
`MaterialName` varchar(255) DEFAULT NULL,
`M_Category` varchar(20) DEFAULT NULL,
`MaterialNum` int(4) DEFAULT NULL,
`MaterialPrice` int(4) DEFAULT NULL,
`MaterialCalculate` varchar(20) DEFAULT NULL,
`date` datetime(6) DEFAULT NULL,
`BatchNumber` int(20) DEFAULT NULL,
`M_Specifications` varchar(255) DEFAULT NULL,
`Color` varchar(10) DEFAULT NULL,
`Hard` varchar(10) DEFAULT NULL,
`SupplierID` varchar(20) DEFAULT NULL,
`HIighNum` int(4) DEFAULT NULL,
`LowNum` int(4) DEFAULT NULL,
`SafeNum` int(4) DEFAULT NULL,
`Notes` varchar(255) DEFAULT NULL,
PRIMARY KEY (`MaterialID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of material
-- ----------------------------
INSERT INTO `material` VALUES ('A1', '地锦草、黄毛耳草、樟树根、香薷、枫香树叶', '中成药配方', '0', '5000', '份', '2018-07-20 15:00:41.000000', '2018', '由地锦草、黄毛耳草、樟树根、香薷、枫树叶等组成,属于纯中药制剂。肠炎宁片此方具有清热利湿、行气的功效。', '混合色', '1000', '03', '1000', '10', '600', '----');
INSERT INTO `material` VALUES ('A2', '金荞麦、四季青、麻黄、紫菀、前胡、枳壳、甘草', '中成药配方', '300', '4', '份', '2018-07-03 14:59:43.000000', '220', '药渣与其余金荞麦等六味加水煎煮两次,滤过,合并滤液,浓缩至适量;', '混合色', '0', '01', '1000', '10', '600', '----');
INSERT INTO `material` VALUES ('A3', '三叉苦、岗梅、金盏银盘、薄荷油、野菊花、马来酸氯苯那敏、咖啡因、对乙酰氨基酚', '中成药配方', '100', '2', '份', '2018-07-05 14:58:38.000000', '201', '三九感冒灵颗粒是复方药,里面含有中西药成分,不宜和西药感冒药同服。', '混合色', '0', '01', '1000', '10', '600', '----');
INSERT INTO `material` VALUES ('A4', '维生素A、植物油、明胶、水', '中成药配方', '300', '60', '份', '2018-07-03 13:37:09.000000', '40', '维生素A在分类中属于脂溶性维生素,同属于脂溶性维生素的还有维生素D(又称钙化醇)、维生素E(又称生育酚)和维生素K(又称凝血维生素)', '混合色', '1', '003', '40000', '4000', '20000', null);
INSERT INTO `material` VALUES ('A5', '熟地黄、酒萸肉、牡丹皮、山药、茯苓、泽泻 ', '中成药配方', '6000', '223', '份', '2018-07-03 13:37:14.000000', '404', '方中重用熟地黄,滋阴补肾,填精益髓,为君药。山萸肉补养肝肾,并能涩精;山药补益脾阴,亦能固精,共为臣药。三药相配,滋养肝脾肾,称为“三补”。', '混合色', '2', '0004', '50000', '555', '4000', null);
INSERT INTO `material` VALUES ('A6', '山楂、麦芽、太子参、山药', '中成药配方', '0', '124', '份', '2018-06-25 13:37:18.000000', '245', '山楂、麦芽消食化积,主治消化不良、不思饮食、脘腹胀闷等症; 陈皮行气导滞,具有运脾健胃之功效;太子参、淮山药可健脾益气,', '混合色', '3', '005', '3000', '456', '1000', null);
-- ----------------------------
-- Table structure for `material_linshi`
-- ----------------------------
DROP TABLE IF EXISTS `material_linshi`;
CREATE TABLE `material_linshi` (
`MaterialID` varchar(10) NOT NULL,
`MaterialName` varchar(255) DEFAULT NULL,
`M_Category` varchar(10) DEFAULT NULL,
`MaterialNum` int(8) DEFAULT NULL,
`MaterialPrice` int(8) DEFAULT NULL,
`MaterialCalculate` varchar(10) DEFAULT NULL,
`date` datetime(6) DEFAULT NULL,
`BatchNumber` varchar(10) DEFAULT NULL,
`M_Specifications` varchar(255) DEFAULT NULL,
`Color` varchar(10) DEFAULT NULL,
`Hard` int(4) DEFAULT NULL,
`SupplierID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`MaterialID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of material_linshi
-- ----------------------------
-- ----------------------------
-- Table structure for `material_shengchanlinshi`
-- ----------------------------
DROP TABLE IF EXISTS `material_shengchanlinshi`;
CREATE TABLE `material_shengchanlinshi` (
`MaterialID` varchar(40) NOT NULL,
`MaterialName` varchar(255) DEFAULT NULL,
`M_Category` varchar(10) DEFAULT NULL,
`MaterialNum` int(8) DEFAULT NULL,
`MaterialPrice` int(8) DEFAULT NULL,
`MaterialCalculate` varchar(10) DEFAULT NULL,
`date` datetime(6) DEFAULT NULL,
`BatchNumber` varchar(10) DEFAULT NULL,
`M_Specifications` varchar(255) DEFAULT NULL,
`Color` varchar(10) DEFAULT NULL,
`Hard` int(4) DEFAULT NULL,
`SupplierID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`MaterialID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of material_shengchanlinshi
-- ----------------------------
-- ----------------------------
-- Table structure for `m_category`
-- ----------------------------
DROP TABLE IF EXISTS `m_category`;
CREATE TABLE `m_category` (
`M_CategoryID` varchar(5) NOT NULL,
`CategoryName` varchar(30) NOT NULL,
`Description` varchar(30) DEFAULT NULL,
`PicturePath` varchar(255) DEFAULT NULL,
PRIMARY KEY (`M_CategoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of m_category
-- ----------------------------
-- ----------------------------
-- Table structure for `m_indetail`
-- ----------------------------
DROP TABLE IF EXISTS `m_indetail`;
CREATE TABLE `m_indetail` (
`StorageID` char(10) NOT NULL,
`M_ID` varchar(10) DEFAULT NULL,
`Specifications` varchar(20) DEFAULT NULL,
`Calculate` varchar(10) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`EmployeeID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`StorageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of m_indetail
-- ----------------------------
-- ----------------------------
-- Table structure for `m_instorage`
-- ----------------------------
DROP TABLE IF EXISTS `m_instorage`;
CREATE TABLE `m_instorage` (
`StroageID` varchar(10) NOT NULL,
`WarehouseID` varchar(10) DEFAULT NULL,
`InDate` datetime(6) DEFAULT NULL,
`InCategory` varchar(10) DEFAULT NULL,
`DepartID` varchar(10) DEFAULT NULL,
`BatchNumber` varchar(10) DEFAULT NULL,
`Notes` text,
`OriginatorID` varchar(10) DEFAULT NULL,
`AuditorID` varchar(10) DEFAULT NULL,
`BookkeeperID` varchar(10) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`HighNum` int(4) DEFAULT NULL,
`LowNum` int(4) DEFAULT NULL,
`SafeNum` int(4) DEFAULT NULL,
`EmployeeID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`StroageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of m_instorage
-- ----------------------------
-- ----------------------------
-- Table structure for `m_outdetails`
-- ----------------------------
DROP TABLE IF EXISTS `m_outdetails`;
CREATE TABLE `m_outdetails` (
`OutstorageID` varchar(10) NOT NULL,
`M_ID` varchar(10) DEFAULT NULL,
`Specifications` varchar(20) DEFAULT NULL,
`Calculate` varchar(10) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`CostObject` varchar(20) DEFAULT NULL,
PRIMARY KEY (`OutstorageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of m_outdetails
-- ----------------------------
-- ----------------------------
-- Table structure for `m_outstorage`
-- ----------------------------
DROP TABLE IF EXISTS `m_outstorage`;
CREATE TABLE `m_outstorage` (
`OutStorageID` varchar(10) NOT NULL,
`WarehouseID` varchar(10) DEFAULT NULL,
`OutDate` datetime(6) DEFAULT NULL,
`OutCategory` varchar(10) DEFAULT NULL,
`BusinessNumber` varchar(20) DEFAULT NULL,
`DepartID` varchar(10) DEFAULT NULL,
`MakerID` varchar(10) DEFAULT NULL,
`CheckID` varchar(10) DEFAULT NULL,
`HighNum` int(4) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`WriteID` varchar(10) DEFAULT NULL,
`LowNum` int(4) DEFAULT NULL,
`SafeNum` int(4) DEFAULT NULL,
`ProduceID` varchar(10) DEFAULT NULL,
`Notes` text,
PRIMARY KEY (`OutStorageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of m_outstorage
-- ----------------------------
-- ----------------------------
-- Table structure for `supplier`
-- ----------------------------
DROP TABLE IF EXISTS `supplier`;
CREATE TABLE `supplier` (
`SupplierID` char(5) NOT NULL,
`CompanyName` varchar(40) DEFAULT NULL,
`ContactName` varchar(30) DEFAULT NULL,
`ContactTitle` varchar(30) DEFAULT NULL,
`Address` varchar(60) DEFAULT NULL,
`City` varchar(15) DEFAULT NULL,
`Region` varchar(15) DEFAULT NULL,
`PostalCode` varchar(10) DEFAULT NULL,
`Country` varchar(15) DEFAULT NULL,
`Phone` varchar(24) DEFAULT NULL,
`Fax` varchar(24) DEFAULT NULL,
`HomePagepath` varchar(255) DEFAULT NULL,
PRIMARY KEY (`SupplierID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of supplier
-- ----------------------------
-- ----------------------------
-- Table structure for `warehouse`
-- ----------------------------
DROP TABLE IF EXISTS `warehouse`;
CREATE TABLE `warehouse` (
`WarehouseID` varchar(5) NOT NULL,
`WarehouseName` varchar(20) NOT NULL,
PRIMARY KEY (`WarehouseID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of warehouse
-- ----------------------------
Navicat MySQL Data Transfer
Source Server : RDZ
Source Server Version : 50703
Source Host : localhost:3306
Source Database : 库存与存货系统
Target Server Type : MYSQL
Target Server Version : 50703
File Encoding : 65001
Date: 2018-07-14 14:02:53
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `customer`
-- ----------------------------
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
`CustomerID` varchar(5) NOT NULL,
`CompanyName` varchar(40) NOT NULL,
`ContactName` varchar(30) NOT NULL,
`ContactTitle` varchar(30) DEFAULT NULL,
`Address` varchar(60) DEFAULT NULL,
`City` varchar(15) DEFAULT NULL,
`Region` varchar(15) DEFAULT NULL,
`PostalCode` varchar(10) DEFAULT NULL,
`Country` varchar(15) DEFAULT NULL,
`Phone` varchar(24) DEFAULT NULL,
`Fax` varchar(24) NOT NULL,
PRIMARY KEY (`CustomerID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of customer
-- ----------------------------
-- ----------------------------
-- Table structure for `employee`
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
`EmployeeID` int(4) NOT NULL,
`LastName` varchar(20) DEFAULT NULL,
`FirstName` varchar(30) DEFAULT NULL,
`Title` varchar(30) DEFAULT NULL,
`TitleofCountry` varchar(25) DEFAULT NULL,
`BirthDate` varchar(255) DEFAULT NULL,
`HireDate` varchar(255) DEFAULT NULL,
`Address` varchar(60) DEFAULT NULL,
`City` varchar(35) DEFAULT NULL,
`Region` varchar(35) DEFAULT NULL,
`PostalCode` varchar(30) DEFAULT NULL,
`Country` varchar(15) DEFAULT NULL,
`HomePhone` varchar(24) DEFAULT NULL,
`Extension` varchar(20) DEFAULT NULL,
`Notes` text,
`ReportsTo` varchar(30) DEFAULT NULL,
`PhotoPath` varchar(255) DEFAULT NULL,
`account` varchar(10) NOT NULL,
PRIMARY KEY (`EmployeeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of employee
-- ----------------------------
INSERT INTO `employee` VALUES ('1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '1');
INSERT INTO `employee` VALUES ('2', '1', '2', '1', '2', '1', '2', '1', '2', '1', '2', '1', '2', '1', '2', '1', '55.gif', '2');
INSERT INTO `employee` VALUES ('3', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '3');
INSERT INTO `employee` VALUES ('4', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '4');
INSERT INTO `employee` VALUES ('5', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '5');
-- ----------------------------
-- Table structure for `goods`
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
`GoodsID` varchar(10) NOT NULL,
`GoodsName` varchar(20) NOT NULL,
`G_Category` varchar(20) NOT NULL,
`GoodsNum` int(4) NOT NULL,
`GoodsPrice` int(4) NOT NULL,
`GoodsCalculate` varchar(10) NOT NULL,
`GoodsDate` datetime(6) NOT NULL,
`BatchNumber` varchar(10) NOT NULL,
`G_Specifications` varchar(30) DEFAULT NULL,
`Color` varchar(10) NOT NULL,
`Hard` varchar(5) NOT NULL,
`HighNum` int(4) DEFAULT NULL,
`LowNum` int(4) DEFAULT NULL,
`SafeNum` int(4) DEFAULT NULL,
`Notes` varchar(255) DEFAULT NULL,
PRIMARY KEY (`GoodsID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES ('10001', '肠炎宁', '胃药类', '0', '44', '盒', '2018-07-25 18:34:43.000000', '2', '绿色药丸', '绿色', '1', '10000', '100', '1000', null);
INSERT INTO `goods` VALUES ('10002', '急支糖浆', '咽喉类', '100', '40', '瓶', '2018-07-14 13:21:10.000000', '1111', '杏仁香微苦', '褐色', '0.11', '10000', '100', '2000', null);
INSERT INTO `goods` VALUES ('10003', '999感冒灵', '感冒类', '50', '20', '盒', '2018-07-05 10:49:26.000000', '120', '粉末状微黄,甜', '微黄', '0.005', '9000', '1000', '4000', null);
INSERT INTO `goods` VALUES ('10004', '维生素A', '维生素类', '400', '21', '瓶', '2018-07-12 13:23:24.000000', '1111', '类似糖果微甜', '淡黄色', '3', '5500', '500', '2500', null);
INSERT INTO `goods` VALUES ('10005', '六味地黄丸', '保健类', '100', '100', '瓶', '2018-07-05 10:46:23.000000', '110', '色黄微苦', '黄', '0.1', '4000', '500', '1000', null);
INSERT INTO `goods` VALUES ('10006', '健胃消食片', '饮食类', '43', '25', '盒', '2018-07-04 14:37:07.000000', '111', '褐色,微甜', '褐色', '0.5', '200000', '5000', '50000', null);
-- ----------------------------
-- Table structure for `goods_linshi`
-- ----------------------------
DROP TABLE IF EXISTS `goods_linshi`;
CREATE TABLE `goods_linshi` (
`goodsID` varchar(10) NOT NULL,
`goodsName` varchar(255) DEFAULT NULL,
`M_Category` varchar(10) DEFAULT NULL,
`goodsNum` int(8) DEFAULT NULL,
`goodsPrice` int(8) DEFAULT NULL,
`goodsCalculate` varchar(10) DEFAULT NULL,
`date` datetime(6) DEFAULT NULL,
`BatchNumber` varchar(10) DEFAULT NULL,
`M_Specifications` varchar(255) DEFAULT NULL,
`Color` varchar(10) DEFAULT NULL,
`Hard` varchar(10) DEFAULT NULL,
`SupplierID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`goodsID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of goods_linshi
-- ----------------------------
-- ----------------------------
-- Table structure for `g_category`
-- ----------------------------
DROP TABLE IF EXISTS `g_category`;
CREATE TABLE `g_category` (
`G_CategoryID` varchar(10) NOT NULL,
`CategoryName` varchar(10) DEFAULT NULL,
`Description` text,
`PicturePath` varchar(255) DEFAULT NULL,
PRIMARY KEY (`G_CategoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of g_category
-- ----------------------------
-- ----------------------------
-- Table structure for `g_indetail`
-- ----------------------------
DROP TABLE IF EXISTS `g_indetail`;
CREATE TABLE `g_indetail` (
`StorageID` char(10) NOT NULL,
`G_ID` varchar(10) DEFAULT NULL,
`Specifications` varchar(20) DEFAULT NULL,
`Calculate` varchar(10) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`EmployeeID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`StorageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of g_indetail
-- ----------------------------
-- ----------------------------
-- Table structure for `g_instorage`
-- ----------------------------
DROP TABLE IF EXISTS `g_instorage`;
CREATE TABLE `g_instorage` (
`StroageID` varchar(10) NOT NULL,
`WarehouseID` varchar(10) DEFAULT NULL,
`InDate` datetime(6) DEFAULT NULL,
`InCategory` varchar(10) DEFAULT NULL,
`DepartID` varchar(10) DEFAULT NULL,
`BatchNumber` varchar(10) DEFAULT NULL,
`Notes` text,
`OriginatorID` varchar(10) DEFAULT NULL,
`AuditorID` varchar(10) DEFAULT NULL,
`BookkeeperID` varchar(10) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`HighNum` int(4) DEFAULT NULL,
`LowNum` int(4) DEFAULT NULL,
`SafeNum` int(4) DEFAULT NULL,
`EmployeeID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`StroageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of g_instorage
-- ----------------------------
-- ----------------------------
-- Table structure for `g_outdetails`
-- ----------------------------
DROP TABLE IF EXISTS `g_outdetails`;
CREATE TABLE `g_outdetails` (
`OutstorageID` varchar(10) NOT NULL,
`ProductID` varchar(10) DEFAULT NULL,
`Specifications` varchar(20) DEFAULT NULL,
`Calculate` varchar(10) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`CostObject` varchar(20) DEFAULT NULL,
PRIMARY KEY (`OutstorageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of g_outdetails
-- ----------------------------
-- ----------------------------
-- Table structure for `g_outstorage`
-- ----------------------------
DROP TABLE IF EXISTS `g_outstorage`;
CREATE TABLE `g_outstorage` (
`OutStorageID` varchar(10) NOT NULL,
`WarehouseID` varchar(10) DEFAULT NULL,
`OutDate` datetime(6) DEFAULT NULL,
`OutCategory` varchar(10) DEFAULT NULL,
`BusinessNumber` varchar(20) DEFAULT NULL,
`DepartID` varchar(10) DEFAULT NULL,
`MakerID` varchar(10) DEFAULT NULL,
`CheckID` varchar(10) DEFAULT NULL,
`HighNum` int(4) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`WriteID` varchar(10) DEFAULT NULL,
`LowNum` int(4) DEFAULT NULL,
`SafeNum` int(4) DEFAULT NULL,
`ProduceID` varchar(10) DEFAULT NULL,
`Notes` text,
PRIMARY KEY (`OutStorageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of g_outstorage
-- ----------------------------
-- ----------------------------
-- Table structure for `inform`
-- ----------------------------
DROP TABLE IF EXISTS `inform`;
CREATE TABLE `inform` (
`date` varchar(255) NOT NULL,
`message` longtext,
PRIMARY KEY (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of inform
-- ----------------------------
INSERT INTO `inform` VALUES ('20170708', '10001价格+10%');
INSERT INTO `inform` VALUES ('20180701', '10002价格-1%');
INSERT INTO `inform` VALUES ('20180702', '10003价格+5%');
INSERT INTO `inform` VALUES ('20180703', '10006价格+19%');
INSERT INTO `inform` VALUES ('20180704', '10001价格-11%');
INSERT INTO `inform` VALUES ('20180705', '10005价格+9%');
INSERT INTO `inform` VALUES ('20180706', '10004价格-8%');
INSERT INTO `inform` VALUES ('20180707', '10001价格+1%');
INSERT INTO `inform` VALUES ('20180709', '10001价格+7%');
-- ----------------------------
-- Table structure for `inventory`
-- ----------------------------
DROP TABLE IF EXISTS `inventory`;
CREATE TABLE `inventory` (
`InventoryID` varchar(10) NOT NULL,
`InventoryDate` datetime(6) DEFAULT NULL,
`WarehouseID` varchar(10) DEFAULT NULL,
`DepartID` varchar(10) DEFAULT NULL,
`OutCategory` varchar(20) DEFAULT NULL,
`InCategory` varchar(10) DEFAULT NULL,
`HandleIID` varchar(10) DEFAULT NULL,
`Notes` longtext,
PRIMARY KEY (`InventoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of inventory
-- ----------------------------
-- ----------------------------
-- Table structure for `inventorydetails`
-- ----------------------------
DROP TABLE IF EXISTS `inventorydetails`;
CREATE TABLE `inventorydetails` (
`inventoryid` varchar(10) NOT NULL,
`color` varchar(10) NOT NULL,
`hard` varchar(20) NOT NULL,
`G_M_ID` varchar(20) DEFAULT NULL,
`batchnumber` varchar(20) DEFAULT NULL,
`listnum` varchar(20) DEFAULT NULL,
`inventorynum` int(4) DEFAULT NULL,
`profitnum` int(4) DEFAULT NULL,
`reason` varchar(255) DEFAULT NULL,
PRIMARY KEY (`inventoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of inventorydetails
-- ----------------------------
INSERT INTO `inventorydetails` VALUES ('', '1', '1', '1', '1', '1', '1', '1', '1');
-- ----------------------------
-- Table structure for `linshishengchan`
-- ----------------------------
DROP TABLE IF EXISTS `linshishengchan`;
CREATE TABLE `linshishengchan` (
`ID` varchar(10) NOT NULL,
`Name` varchar(255) DEFAULT NULL,
`Category` varchar(20) DEFAULT NULL,
`Num` int(8) DEFAULT NULL,
`A_1` varchar(40) DEFAULT NULL,
`A_2` varchar(40) DEFAULT NULL,
`A_3` varchar(40) DEFAULT NULL,
`A_4` int(8) DEFAULT NULL,
`A_5` int(8) DEFAULT NULL,
`A_6` varchar(40) DEFAULT NULL,
`A_7` datetime(6) DEFAULT NULL,
`A_8` varchar(40) DEFAULT NULL,
`A_9` varchar(40) DEFAULT NULL,
`A_10` varchar(40) DEFAULT NULL,
`A_11` int(8) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of linshishengchan
-- ----------------------------
-- ----------------------------
-- Table structure for `login`
-- ----------------------------
DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
`account` varchar(10) NOT NULL,
`password` varchar(10) NOT NULL,
`DepartID` int(10) NOT NULL,
PRIMARY KEY (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of login
-- ----------------------------
INSERT INTO `login` VALUES ('1', '1', '1');
INSERT INTO `login` VALUES ('2', '2', '2');
INSERT INTO `login` VALUES ('3', '3', '3');
INSERT INTO `login` VALUES ('4', '4', '4');
INSERT INTO `login` VALUES ('5', '5', '5');
-- ----------------------------
-- Table structure for `material`
-- ----------------------------
DROP TABLE IF EXISTS `material`;
CREATE TABLE `material` (
`MaterialID` varchar(10) NOT NULL,
`MaterialName` varchar(255) DEFAULT NULL,
`M_Category` varchar(20) DEFAULT NULL,
`MaterialNum` int(4) DEFAULT NULL,
`MaterialPrice` int(4) DEFAULT NULL,
`MaterialCalculate` varchar(20) DEFAULT NULL,
`date` datetime(6) DEFAULT NULL,
`BatchNumber` int(20) DEFAULT NULL,
`M_Specifications` varchar(255) DEFAULT NULL,
`Color` varchar(10) DEFAULT NULL,
`Hard` varchar(10) DEFAULT NULL,
`SupplierID` varchar(20) DEFAULT NULL,
`HIighNum` int(4) DEFAULT NULL,
`LowNum` int(4) DEFAULT NULL,
`SafeNum` int(4) DEFAULT NULL,
`Notes` varchar(255) DEFAULT NULL,
PRIMARY KEY (`MaterialID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of material
-- ----------------------------
INSERT INTO `material` VALUES ('A1', '地锦草、黄毛耳草、樟树根、香薷、枫香树叶', '中成药配方', '0', '5000', '份', '2018-07-20 15:00:41.000000', '2018', '由地锦草、黄毛耳草、樟树根、香薷、枫树叶等组成,属于纯中药制剂。肠炎宁片此方具有清热利湿、行气的功效。', '混合色', '1000', '03', '1000', '10', '600', '----');
INSERT INTO `material` VALUES ('A2', '金荞麦、四季青、麻黄、紫菀、前胡、枳壳、甘草', '中成药配方', '300', '4', '份', '2018-07-03 14:59:43.000000', '220', '药渣与其余金荞麦等六味加水煎煮两次,滤过,合并滤液,浓缩至适量;', '混合色', '0', '01', '1000', '10', '600', '----');
INSERT INTO `material` VALUES ('A3', '三叉苦、岗梅、金盏银盘、薄荷油、野菊花、马来酸氯苯那敏、咖啡因、对乙酰氨基酚', '中成药配方', '100', '2', '份', '2018-07-05 14:58:38.000000', '201', '三九感冒灵颗粒是复方药,里面含有中西药成分,不宜和西药感冒药同服。', '混合色', '0', '01', '1000', '10', '600', '----');
INSERT INTO `material` VALUES ('A4', '维生素A、植物油、明胶、水', '中成药配方', '300', '60', '份', '2018-07-03 13:37:09.000000', '40', '维生素A在分类中属于脂溶性维生素,同属于脂溶性维生素的还有维生素D(又称钙化醇)、维生素E(又称生育酚)和维生素K(又称凝血维生素)', '混合色', '1', '003', '40000', '4000', '20000', null);
INSERT INTO `material` VALUES ('A5', '熟地黄、酒萸肉、牡丹皮、山药、茯苓、泽泻 ', '中成药配方', '6000', '223', '份', '2018-07-03 13:37:14.000000', '404', '方中重用熟地黄,滋阴补肾,填精益髓,为君药。山萸肉补养肝肾,并能涩精;山药补益脾阴,亦能固精,共为臣药。三药相配,滋养肝脾肾,称为“三补”。', '混合色', '2', '0004', '50000', '555', '4000', null);
INSERT INTO `material` VALUES ('A6', '山楂、麦芽、太子参、山药', '中成药配方', '0', '124', '份', '2018-06-25 13:37:18.000000', '245', '山楂、麦芽消食化积,主治消化不良、不思饮食、脘腹胀闷等症; 陈皮行气导滞,具有运脾健胃之功效;太子参、淮山药可健脾益气,', '混合色', '3', '005', '3000', '456', '1000', null);
-- ----------------------------
-- Table structure for `material_linshi`
-- ----------------------------
DROP TABLE IF EXISTS `material_linshi`;
CREATE TABLE `material_linshi` (
`MaterialID` varchar(10) NOT NULL,
`MaterialName` varchar(255) DEFAULT NULL,
`M_Category` varchar(10) DEFAULT NULL,
`MaterialNum` int(8) DEFAULT NULL,
`MaterialPrice` int(8) DEFAULT NULL,
`MaterialCalculate` varchar(10) DEFAULT NULL,
`date` datetime(6) DEFAULT NULL,
`BatchNumber` varchar(10) DEFAULT NULL,
`M_Specifications` varchar(255) DEFAULT NULL,
`Color` varchar(10) DEFAULT NULL,
`Hard` int(4) DEFAULT NULL,
`SupplierID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`MaterialID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of material_linshi
-- ----------------------------
-- ----------------------------
-- Table structure for `material_shengchanlinshi`
-- ----------------------------
DROP TABLE IF EXISTS `material_shengchanlinshi`;
CREATE TABLE `material_shengchanlinshi` (
`MaterialID` varchar(40) NOT NULL,
`MaterialName` varchar(255) DEFAULT NULL,
`M_Category` varchar(10) DEFAULT NULL,
`MaterialNum` int(8) DEFAULT NULL,
`MaterialPrice` int(8) DEFAULT NULL,
`MaterialCalculate` varchar(10) DEFAULT NULL,
`date` datetime(6) DEFAULT NULL,
`BatchNumber` varchar(10) DEFAULT NULL,
`M_Specifications` varchar(255) DEFAULT NULL,
`Color` varchar(10) DEFAULT NULL,
`Hard` int(4) DEFAULT NULL,
`SupplierID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`MaterialID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of material_shengchanlinshi
-- ----------------------------
-- ----------------------------
-- Table structure for `m_category`
-- ----------------------------
DROP TABLE IF EXISTS `m_category`;
CREATE TABLE `m_category` (
`M_CategoryID` varchar(5) NOT NULL,
`CategoryName` varchar(30) NOT NULL,
`Description` varchar(30) DEFAULT NULL,
`PicturePath` varchar(255) DEFAULT NULL,
PRIMARY KEY (`M_CategoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of m_category
-- ----------------------------
-- ----------------------------
-- Table structure for `m_indetail`
-- ----------------------------
DROP TABLE IF EXISTS `m_indetail`;
CREATE TABLE `m_indetail` (
`StorageID` char(10) NOT NULL,
`M_ID` varchar(10) DEFAULT NULL,
`Specifications` varchar(20) DEFAULT NULL,
`Calculate` varchar(10) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`EmployeeID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`StorageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of m_indetail
-- ----------------------------
-- ----------------------------
-- Table structure for `m_instorage`
-- ----------------------------
DROP TABLE IF EXISTS `m_instorage`;
CREATE TABLE `m_instorage` (
`StroageID` varchar(10) NOT NULL,
`WarehouseID` varchar(10) DEFAULT NULL,
`InDate` datetime(6) DEFAULT NULL,
`InCategory` varchar(10) DEFAULT NULL,
`DepartID` varchar(10) DEFAULT NULL,
`BatchNumber` varchar(10) DEFAULT NULL,
`Notes` text,
`OriginatorID` varchar(10) DEFAULT NULL,
`AuditorID` varchar(10) DEFAULT NULL,
`BookkeeperID` varchar(10) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`HighNum` int(4) DEFAULT NULL,
`LowNum` int(4) DEFAULT NULL,
`SafeNum` int(4) DEFAULT NULL,
`EmployeeID` varchar(10) DEFAULT NULL,
PRIMARY KEY (`StroageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of m_instorage
-- ----------------------------
-- ----------------------------
-- Table structure for `m_outdetails`
-- ----------------------------
DROP TABLE IF EXISTS `m_outdetails`;
CREATE TABLE `m_outdetails` (
`OutstorageID` varchar(10) NOT NULL,
`M_ID` varchar(10) DEFAULT NULL,
`Specifications` varchar(20) DEFAULT NULL,
`Calculate` varchar(10) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`CostObject` varchar(20) DEFAULT NULL,
PRIMARY KEY (`OutstorageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of m_outdetails
-- ----------------------------
-- ----------------------------
-- Table structure for `m_outstorage`
-- ----------------------------
DROP TABLE IF EXISTS `m_outstorage`;
CREATE TABLE `m_outstorage` (
`OutStorageID` varchar(10) NOT NULL,
`WarehouseID` varchar(10) DEFAULT NULL,
`OutDate` datetime(6) DEFAULT NULL,
`OutCategory` varchar(10) DEFAULT NULL,
`BusinessNumber` varchar(20) DEFAULT NULL,
`DepartID` varchar(10) DEFAULT NULL,
`MakerID` varchar(10) DEFAULT NULL,
`CheckID` varchar(10) DEFAULT NULL,
`HighNum` int(4) DEFAULT NULL,
`Num` int(4) DEFAULT NULL,
`WriteID` varchar(10) DEFAULT NULL,
`LowNum` int(4) DEFAULT NULL,
`SafeNum` int(4) DEFAULT NULL,
`ProduceID` varchar(10) DEFAULT NULL,
`Notes` text,
PRIMARY KEY (`OutStorageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of m_outstorage
-- ----------------------------
-- ----------------------------
-- Table structure for `supplier`
-- ----------------------------
DROP TABLE IF EXISTS `supplier`;
CREATE TABLE `supplier` (
`SupplierID` char(5) NOT NULL,
`CompanyName` varchar(40) DEFAULT NULL,
`ContactName` varchar(30) DEFAULT NULL,
`ContactTitle` varchar(30) DEFAULT NULL,
`Address` varchar(60) DEFAULT NULL,
`City` varchar(15) DEFAULT NULL,
`Region` varchar(15) DEFAULT NULL,
`PostalCode` varchar(10) DEFAULT NULL,
`Country` varchar(15) DEFAULT NULL,
`Phone` varchar(24) DEFAULT NULL,
`Fax` varchar(24) DEFAULT NULL,
`HomePagepath` varchar(255) DEFAULT NULL,
PRIMARY KEY (`SupplierID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of supplier
-- ----------------------------
-- ----------------------------
-- Table structure for `warehouse`
-- ----------------------------
DROP TABLE IF EXISTS `warehouse`;
CREATE TABLE `warehouse` (
`WarehouseID` varchar(5) NOT NULL,
`WarehouseName` varchar(20) NOT NULL,
PRIMARY KEY (`WarehouseID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of warehouse
-- ----------------------------