java基于web的中药材管理系统

基于web的中药材管理系统
开发工具(eclipse/idea/vscode等)：
数据库(sqlite/mysql/sqlserver等)：
功能模块(请用文字描述，至少200字)：

*/

 

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `t_admin`
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
  `adminId` int(11) NOT NULL AUTO_INCREMENT,
  `adminName` varchar(255) DEFAULT NULL,
  `adminPassword` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`adminId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_admin
-- ----------------------------
INSERT INTO `t_admin` VALUES ('1', 'admin', 'admin');

-- ----------------------------
-- Table structure for `t_bumen`
-- ----------------------------
DROP TABLE IF EXISTS `t_bumen`;
CREATE TABLE `t_bumen` (
  `bumenId` int(11) NOT NULL AUTO_INCREMENT,
  `bumenName` varchar(255) DEFAULT NULL,
  `bumenMark` varchar(255) DEFAULT NULL,
  `bumenMark1` varchar(255) DEFAULT NULL,
  `bumenMark2` varchar(255) DEFAULT NULL,
  `bumenType` int(11) DEFAULT NULL,
  `bumenType1` int(11) DEFAULT NULL,
  `bumenType2` int(11) DEFAULT NULL,
  `bumenDouble` double DEFAULT NULL,
  `bumenDouble1` double DEFAULT NULL,
  `bumenDouble2` double DEFAULT NULL,
  `buyuanId` int(11) DEFAULT NULL,
  `buyuanName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bumenId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_bumen
-- ----------------------------
INSERT INTO `t_bumen` VALUES ('1', null, null, null, null, '1', null, null, null, null, null, '1', 'yishi1');
INSERT INTO `t_bumen` VALUES ('3', null, null, null, null, '2', null, null, null, null, null, '4', 'yisheng2');

-- ----------------------------
-- Table structure for `t_buyuan`
-- ----------------------------
DROP TABLE IF EXISTS `t_buyuan`;
CREATE TABLE `t_buyuan` (
  `buyuanId` int(11) NOT NULL AUTO_INCREMENT,
  `buyuanName` varchar(255) DEFAULT NULL,
  `buyuanMark` varchar(255) DEFAULT NULL,
  `buyuanMark1` varchar(255) DEFAULT NULL,
  `buyuanMark2` varchar(255) DEFAULT NULL,
  `buyuanType` int(11) DEFAULT NULL,
  `buyuanType1` int(11) DEFAULT NULL,
  `buyuanType2` int(11) DEFAULT NULL,
  `buyuanDouble` double DEFAULT NULL,
  `buyuanDouble1` double DEFAULT NULL,
  `buyuanDouble2` double DEFAULT NULL,
  PRIMARY KEY (`buyuanId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_buyuan
-- ----------------------------
INSERT INTO `t_buyuan` VALUES ('1', '标签1', '标签1', null, null, null, null, null, null, null, null);
INSERT INTO `t_buyuan` VALUES ('2', '标签2', '标签2', null, null, null, null, null, null, null, null);
INSERT INTO `t_buyuan` VALUES ('3', '标签3', '标签3', null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_buzhi`
-- ----------------------------
DROP TABLE IF EXISTS `t_buzhi`;
CREATE TABLE `t_buzhi` (
  `buzhiId` int(11) NOT NULL AUTO_INCREMENT,
  `buzhiName` varchar(255) DEFAULT NULL,
  `buzhiMark` varchar(255) DEFAULT NULL,
  `buzhiMark1` varchar(255) DEFAULT NULL,
  `buzhiMark2` varchar(255) DEFAULT NULL,
  `buzhiType` int(11) DEFAULT NULL,
  `buzhiType1` int(11) DEFAULT NULL,
  `buzhiType2` int(11) DEFAULT NULL,
  `buzhiDouble` double DEFAULT NULL,
  `buzhiDouble1` double DEFAULT NULL,
  `buzhiDouble2` double DEFAULT NULL,
  `buyuanId` int(11) DEFAULT NULL,
  `buyuanName` varchar(255) DEFAULT NULL,
  `bumenId` int(11) DEFAULT NULL,
  `bumenName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`buzhiId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_buzhi
-- ----------------------------
INSERT INTO `t_buzhi` VALUES ('1', '本科', '本科本科', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_buzhi` VALUES ('2', '专科', '专科专科', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_buzhi` VALUES ('3', '硕士', '硕士硕士', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_buzhi` VALUES ('4', '在职', '在职在职在职', null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_ggtype`
-- ----------------------------
DROP TABLE IF EXISTS `t_ggtype`;
CREATE TABLE `t_ggtype` (
  `ggtypeId` int(11) NOT NULL AUTO_INCREMENT,
  `ggtypeName` varchar(255) DEFAULT NULL,
  `ggtypeMark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ggtypeId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_ggtype
-- ----------------------------
INSERT INTO `t_ggtype` VALUES ('1', '类型一', '类型一类型一类型一类型一');
INSERT INTO `t_ggtype` VALUES ('2', '类型二', '类型二类型二类型二类型二');
INSERT INTO `t_ggtype` VALUES ('3', '类型三', '类型三类型三类型三类型三类型三');