java服装连锁店管理系统设计与实现

服装连锁店管理系统设计与实现
开发工具(eclipse/idea/vscode等):
数据库(sqlite/mysql/sqlserver等):
功能模块(请用文字描述,至少200字):

 /*
Navicat MySQL Data Transfer

 

Source Server         : test
Source Server Version : 50722
Source Host           : localhost:3306
Source Database       : db_bdm012fuzhuangliansuo

Target Server Type    : MYSQL
Target Server Version : 50722
File Encoding         : 65001

Date: 2020-12-10 21:50:34
*/

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_jcbiaoti`
-- ----------------------------
DROP TABLE IF EXISTS `t_jcbiaoti`;
CREATE TABLE `t_jcbiaoti` (
  `jcbiaotiId` int(11) NOT NULL AUTO_INCREMENT,
  `jcbiaotiName` varchar(255) DEFAULT NULL COMMENT '汉字',
  `jcbiaotiNeirong` varchar(255) DEFAULT NULL COMMENT 'url',
  `jcbiaotiMark` varchar(255) DEFAULT NULL,
  `jcbiaotiMark1` varchar(255) DEFAULT NULL,
  `jcbiaotiMark2` varchar(255) DEFAULT NULL,
  `jcbiaotiPaixu` int(11) DEFAULT NULL,
  `jcbiaotiType` int(11) DEFAULT NULL COMMENT '0网页导航1admin导航2user导航3yonghu导航4juese导航',
  `jcbiaotiType1` int(11) DEFAULT NULL,
  `jcbiaotiType2` int(11) DEFAULT NULL,
  PRIMARY KEY (`jcbiaotiId`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_jcbiaoti
-- ----------------------------
INSERT INTO `t_jcbiaoti` VALUES ('2', '员工信息', null, null, null, null, '2', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('3', '服装信息', null, null, null, null, '3', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('4', '采购信息', null, null, null, null, '4', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('6', '销售信息', null, null, null, null, '6', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('7', '批发信息', null, null, null, null, '3', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('8', '库存信息', null, null, null, null, '8', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('11', '服装信息', null, null, null, null, '3', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('12', '采购信息', null, null, null, null, '4', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('14', '销售信息', null, null, null, null, '6', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('15', '批发信息', null, null, null, null, '3', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('17', '门店信息', null, null, null, null, '2', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('18', '门店信息', null, null, null, null, '2', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('19', '供应商信息', null, null, null, null, '2', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('20', '供应商信息', null, null, null, null, '2', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('21', '财务信息', null, null, null, null, '9', '1', '0', null);

-- ----------------------------
-- Table structure for `t_jcdaohang`
-- ----------------------------
DROP TABLE IF EXISTS `t_jcdaohang`;
CREATE TABLE `t_jcdaohang` (
  `jcdaohangId` int(11) NOT NULL AUTO_INCREMENT,
  `jcdaohangName` varchar(255) DEFAULT NULL COMMENT '汉字',
  `jcdaohangNeirong` varchar(255) DEFAULT NULL COMMENT 'url',
  `jcdaohangMark` varchar(255) DEFAULT NULL,
  `jcdaohangMark1` varchar(255) DEFAULT NULL,
  `jcdaohangMark2` varchar(255) DEFAULT NULL,
  `jcdaohangPaixu` int(11) DEFAULT NULL,
  `jcdaohangType` int(11) DEFAULT NULL COMMENT '0网页导航1admin导航2user导航3yonghu导航4juese导航',
  `jcdaohangType1` int(11) DEFAULT NULL,
  `jcdaohangType2` int(11) DEFAULT NULL,
  `jcbiaotiId` int(11) DEFAULT NULL,
  `jcbiaotiName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`jcdaohangId`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_jcdaohang
-- ----------------------------
INSERT INTO `t_jcdaohang` VALUES ('4', '员工信息', 'user.jsp', null, null, null, '2', '1', '0', null, '2', null);
INSERT INTO `t_jcdaohang` VALUES ('8', '服装类型', 'sjleixing.jsp', null, null, null, '1', '1', '0', null, '3', null);
INSERT INTO `t_jcdaohang` VALUES ('9', '服装品牌', 'sjxingtai.jsp', null, null, null, '2', '1', '0', null, '3', null);
INSERT INTO `t_jcdaohang` VALUES ('10', '服装信息', 'shuju.jsp', null, null, null, '3', '1', '0', null, '3', null);
INSERT INTO `t_jcdaohang` VALUES ('11', '供应商信息', 'sjlaiyuan.jsp', null, null, null, '1', '1', '0', null, '19', null);
INSERT INTO `t_jcdaohang` VALUES ('12', '采购信息', 'sjduochu0.jsp', null, null, null, '2', '1', '0', null, '4', null);
INSERT INTO `t_jcdaohang` VALUES ('19', '销售信息', 'sjshaochu0.jsp', null, null, null, '1', '1', '0', null, '6', null);
INSERT INTO `t_jcdaohang` VALUES ('21', '门店信息', 'sjqita.jsp', null, null, null, '1', '1', '0', null, '17', null);
INSERT INTO `t_jcdaohang` VALUES ('22', '批发信息', 'sjjianchu.jsp', null, null, null, '2', '1', '0', null, '7', null);
INSERT INTO `t_jcdaohang` VALUES ('23', '库存信息', 'bingzhuangtu.jsp?tijiaoUrl=shujuTongji', null, null, null, '1', '1', '0', null, '8', null);
INSERT INTO `t_jcdaohang` VALUES ('24', '采购统计', 'zhuzhuangtu.jsp?tijiaoUrl=sjduochuTongji', null, null, null, '2', '1', '0', null, '21', null);
INSERT INTO `t_jcdaohang` VALUES ('25', '销售统计', 'zhuzhuangtu.jsp?tijiaoUrl=sjshaochuTongji', null, null, null, '3', '1', '0', null, '21', null);
INSERT INTO `t_jcdaohang` VALUES ('26', '批发统计', 'zhuzhuangtu.jsp?tijiaoUrl=sjjianchuTongji', null, null, null, '4', '1', '0', null, '21', null);
INSERT INTO `t_jcdaohang` VALUES ('30', '服装信息', 'shuju.jsp', null, null, null, '1', '2', '0', null, '11', null);
INSERT INTO `t_jcdaohang` VALUES ('31', '供应商信息', 'sjlaiyuan.jsp', null, null, null, '1', '2', '0', null, '20', null);
INSERT INTO `t_jcdaohang` VALUES ('32', '采购信息', 'sjduochu0.jsp', null, null, null, '2', '2', '0', null, '12', null);
INSERT INTO `t_jcdaohang` VALUES ('35', '销售信息', 'sjshaochu0.jsp', null, null, null, '1', '2', '0', null, '14', null);
INSERT INTO `t_jcdaohang` VALUES ('37', '门店信息', 'sjqita.jsp', null, null, null, '1', '2', '0', null, '18', null);
INSERT INTO `t_jcdaohang` VALUES ('38', '批发信息', 'sjjianchu.jsp', null, null, null, '2', '2', '0', null, '15', null);

-- ----------------------------
-- Table structure for `t_jcpeizhi`
-- ----------------------------
DROP TABLE IF EXISTS `t_jcpeizhi`;
CREATE TABLE `t_jcpeizhi` (
  `jcpeizhiId` int(11) NOT NULL AUTO_INCREMENT,
  `jcpeizhiName` varchar(255) DEFAULT NULL,
  `jcpeizhiNeirong` varchar(255) DEFAULT NULL,
  `jcpeizhiMark` varchar(255) DEFAULT NULL,
  `bumenBieming` varchar(255) DEFAULT NULL,
  `buyuanBieming` varchar(255) DEFAULT NULL,
  `buzhiBieming` varchar(255) DEFAULT NULL,
  `userBieming` varchar(255) DEFAULT NULL COMMENT 'userBieming',
  `uxtypeBieming` varchar(255) DEFAULT NULL,
  `uxinxiBieming` varchar(255) DEFAULT NULL,
  `uyijianBieming` varchar(255) DEFAULT NULL,
  `roleBieming` varchar(255) DEFAULT NULL,
  `byumenBieming` varchar(255) DEFAULT NULL,
  `byuyuanBieming` varchar(255) DEFAULT NULL,
  `byuzhiBieming` varchar(255) DEFAULT NULL,
  `yonghuBieming` varchar(255) DEFAULT NULL COMMENT 'yonghuBieming',
  `yxtypeBieming` varchar(255) DEFAULT NULL,
  `yxinxiBieming` varchar(255) DEFAULT NULL,
  `yyijianBieming` varchar(255) DEFAULT NULL,
  `yhroleBieming` varchar(255) DEFAULT NULL,
  `ggtypeBieming` varchar(255) DEFAULT NULL,
  `gonggaoBieming` varchar(255) DEFAULT NULL,
  `ggpinglunBieming` varchar(255) DEFAULT NULL,
  `shujuBieming` varchar(255) DEFAULT NULL,
  `sjduochuBieming` varchar(255) DEFAULT NULL,
  `sjjianchuBieming` varchar(255) DEFAULT NULL,
  `sjlaiyuanBieming` varchar(255) DEFAULT NULL,
  `sjleixingBieming` varchar(255) DEFAULT NULL,
  `sjpinglunBieming` varchar(255) DEFAULT NULL,
  `sjqitaBieming` varchar(255) DEFAULT NULL,
  `sjshaochuBieming` varchar(255) DEFAULT NULL,
  `sjxingtaiBieming` varchar(255) DEFAULT NULL,
  `jcpeizhiType` int(11) DEFAULT NULL,
  `jcpeizhiType1` int(11) DEFAULT NULL,
  `jcpeizhiType2` int(11) DEFAULT NULL,
  PRIMARY KEY (`jcpeizhiId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_jcpeizhi
-- ----------------------------
INSERT INTO `t_jcpeizhi` VALUES ('1', '服装连锁店管理系统', 'bdm012fuzhuangliansuo', 'bdm012fuzhuangliansuo', null, null, '门店', '员工', '类型', '信息', '意见', null, null, null, '类型', '客户', '类型', '信息', '反馈', null, '类型', '公告', null, '服装', '采购', '批发', '供应商', '类型', null, '门店', '销售', '品牌', null, null, null);

-- ----------------------------
-- Table structure for `t_rizhi`
-- ----------------------------
DROP TABLE IF EXISTS `t_rizhi`;
CREATE TABLE `t_rizhi` (
  `rizhiId` int(11) NOT NULL AUTO_INCREMENT,
  `rizhiName` varchar(255) NOT NULL,
  `dengluIp` varchar(255) NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`rizhiId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_rizhi
-- ----------------------------
INSERT INTO `t_rizhi` VALUES ('1', 'admin', '127.0.0.1', '2020-12-10 21:44:12');
INSERT INTO `t_rizhi` VALUES ('2', 'user1', '127.0.0.1', '2020-12-10 21:46:20');
INSERT INTO `t_rizhi` VALUES ('3', 'admin', '127.0.0.1', '2020-12-10 21:48:02');
INSERT INTO `t_rizhi` VALUES ('4', 'admin', '127.0.0.1', '2020-12-10 21:49:01');

-- ----------------------------
-- Table structure for `t_shuju`
-- ----------------------------
DROP TABLE IF EXISTS `t_shuju`;
CREATE TABLE `t_shuju` (
  `shujuId` int(11) NOT NULL AUTO_INCREMENT,
  `shujuName` varchar(255) DEFAULT NULL,
  `shujuMark` varchar(2550) DEFAULT NULL,
  `shujuMark1` varchar(2550) DEFAULT NULL,
  `shujuMark2` varchar(2550) DEFAULT NULL,
  `shujuMark3` varchar(2550) DEFAULT NULL,
  `shujuDate` datetime DEFAULT NULL,
  `shujuDate1` datetime DEFAULT NULL,
  `shujuZong` int(11) DEFAULT NULL,
  `shujuZong1` int(11) DEFAULT NULL,
  `shujuZong2` int(11) DEFAULT NULL,
  `shujuDouble` double DEFAULT NULL,
  `shujuDouble1` double DEFAULT NULL,
  `shujuDouble2` double DEFAULT NULL,
  `shujuDouble3` double DEFAULT NULL,
  `shujuDouble4` double DEFAULT NULL,
  `shujuType` int(11) DEFAULT NULL,
  `shujuType1` int(11) DEFAULT NULL,
  `shujuType2` int(11) DEFAULT NULL,
  `shujuImg` varchar(255) DEFAULT NULL,
  `shujuImgName` varchar(255) DEFAULT NULL,
  `sjleixingId` int(11) DEFAULT NULL,
  `sjleixingName` varchar(255) DEFAULT NULL,
  `sjxingtaiId` int(11) DEFAULT NULL,
  `sjxingtaiName` varchar(255) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `userName` varchar(255) DEFAULT NULL,
  `bumenId` int(11) DEFAULT NULL,
  `bumenName` varchar(255) DEFAULT NULL,
  `buyuanId` int(11) DEFAULT NULL,
  `buyuanName` varchar(255) DEFAULT NULL,
  `yonghuId` int(11) DEFAULT NULL,
  `yonghuName` varchar(255) DEFAULT NULL,
  `byumenId` int(11) DEFAULT NULL,
  `byumenName` varchar(255) DEFAULT NULL,
  `byuyuanId` int(11) DEFAULT NULL,
  `byuyuanName` varchar(255) DEFAULT NULL,
  `buzhiId` int(11) DEFAULT NULL,
  `buzhiName` varchar(255) DEFAULT NULL,
  `roleId` int(11) DEFAULT NULL,
  `roleName` varchar(255) DEFAULT NULL,
  `byuzhiId` int(11) DEFAULT NULL,
  `byuzhiName` varchar(255) DEFAULT NULL,
  `yhroleId` int(11) DEFAULT NULL,
  `yhroleName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`shujuId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_shuju
-- ----------------------------
INSERT INTO `t_shuju` VALUES ('1', '服装信息1', '服装信息', null, null, null, '2020-12-10 21:45:30', null, '145', null, null, '100', '2400', '200', '-2200', null, '0', null, null, null, null, '1', '上衣', '1', '品牌1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_shuju` VALUES ('2', '服装信息2', '服装信息', null, null, null, '2020-12-10 21:45:39', null, '115', null, null, '100', '2550', '600', '-1950', null, '0', null, null, null, null, '2', '裤子', '1', '品牌1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_shuju` VALUES ('3', '服装信息3', '服装信息', null, null, null, '2020-12-10 21:45:47', null, '81', null, null, '100', '600', '400', '-200', null, '0', null, null, null, null, '2', '裤子', '1', '品牌1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjduochu`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjduochu`;
CREATE TABLE `t_sjduochu` (
  `sjduochuId` int(11) NOT NULL AUTO_INCREMENT,
  `sjduochuName` varchar(255) DEFAULT NULL,
  `sjduochuMark` varchar(2550) DEFAULT NULL,
  `sjduochuMark1` varchar(2550) DEFAULT NULL,
  `sjduochuMark2` varchar(2550) DEFAULT NULL,
  `sjduochuMark3` varchar(2550) DEFAULT NULL,
  `sjduochuDate` datetime DEFAULT NULL,
  `sjduochuDate1` datetime DEFAULT NULL,
  `sjduochuZong` int(11) DEFAULT NULL,
  `sjduochuZong1` int(11) DEFAULT NULL,
  `sjduochuZong2` int(11) DEFAULT NULL,
  `sjduochuDouble` double DEFAULT NULL,
  `sjduochuDouble1` double DEFAULT NULL,
  `sjduochuDouble2` double DEFAULT NULL,
  `sjduochuType` int(11) DEFAULT NULL,
  `sjduochuType1` int(11) DEFAULT NULL,
  `sjduochuType2` int(11) DEFAULT NULL,
  `sjqitaId` int(11) DEFAULT NULL,
  `sjqitaName` varchar(255) DEFAULT NULL,
  `sjlaiyuanId` int(11) DEFAULT NULL,
  `sjlaiyuanName` varchar(255) DEFAULT NULL,
  `sjduochuImg` varchar(255) DEFAULT NULL,
  `sjduochuImgName` varchar(255) DEFAULT NULL,
  `shujuId` int(11) DEFAULT NULL,
  `shujuName` varchar(255) DEFAULT NULL,
  `sjleixingId` int(11) DEFAULT NULL,
  `sjleixingName` varchar(255) DEFAULT NULL,
  `sjxingtaiId` int(11) DEFAULT NULL,
  `sjxingtaiName` varchar(255) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `userName` varchar(255) DEFAULT NULL,
  `bumenId` int(11) DEFAULT NULL,
  `bumenName` varchar(255) DEFAULT NULL,
  `buyuanId` int(11) DEFAULT NULL,
  `buyuanName` varchar(255) DEFAULT NULL,
  `yonghuId` int(11) DEFAULT NULL,
  `yonghuName` varchar(255) DEFAULT NULL,
  `byumenId` int(11) DEFAULT NULL,
  `byumenName` varchar(255) DEFAULT NULL,
  `byuyuanId` int(11) DEFAULT NULL,
  `byuyuanName` varchar(255) DEFAULT NULL,
  `buzhiId` int(11) DEFAULT NULL,
  `buzhiName` varchar(255) DEFAULT NULL,
  `roleId` int(11) DEFAULT NULL,
  `roleName` varchar(255) DEFAULT NULL,
  `byuzhiId` int(11) DEFAULT NULL,
  `byuzhiName` varchar(255) DEFAULT NULL,
  `yhroleId` int(11) DEFAULT NULL,
  `yhroleName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`sjduochuId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjduochu
-- ----------------------------
INSERT INTO `t_sjduochu` VALUES ('1', null, null, null, null, null, '2020-12-10 21:47:14', null, '80', null, null, '30', '2400', null, '0', null, null, null, null, '1', '供应商1', null, null, '1', '服装信息1', '1', '上衣', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjduochu` VALUES ('2', null, null, null, null, null, '2020-12-10 21:47:20', null, '85', null, null, '30', '2550', null, '0', null, null, null, null, '1', '供应商1', null, null, '2', '服装信息2', '2', '裤子', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjduochu` VALUES ('3', null, null, null, null, null, '2020-12-10 21:47:26', null, '20', null, null, '30', '600', null, '0', null, null, null, null, '1', '供应商1', null, null, '3', '服装信息3', '2', '裤子', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjjianchu`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjjianchu`;
CREATE TABLE `t_sjjianchu` (
  `sjjianchuId` int(11) NOT NULL AUTO_INCREMENT,
  `sjjianchuName` varchar(255) DEFAULT NULL,
  `sjjianchuMark` varchar(2550) DEFAULT NULL,
  `sjjianchuMark1` varchar(2550) DEFAULT NULL,
  `sjjianchuMark2` varchar(2550) DEFAULT NULL,
  `sjjianchuMark3` varchar(2550) DEFAULT NULL,
  `sjjianchuDate` datetime DEFAULT NULL,
  `sjjianchuDate1` datetime DEFAULT NULL,
  `sjjianchuZong` int(11) DEFAULT NULL,
  `sjjianchuZong1` int(11) DEFAULT NULL,
  `sjjianchuZong2` int(11) DEFAULT NULL,
  `sjjianchuDouble` double DEFAULT NULL,
  `sjjianchuDouble1` double DEFAULT NULL,
  `sjjianchuDouble2` double DEFAULT NULL,
  `sjjianchuType` int(11) DEFAULT NULL,
  `sjjianchuType1` int(11) DEFAULT NULL,
  `sjjianchuType2` int(11) DEFAULT NULL,
  `sjqitaId` int(11) DEFAULT NULL,
  `sjqitaName` varchar(255) DEFAULT NULL,
  `sjlaiyuanId` int(11) DEFAULT NULL,
  `sjlaiyuanName` varchar(255) DEFAULT NULL,
  `sjjianchuImg` varchar(255) DEFAULT NULL,
  `sjjianchuImgName` varchar(255) DEFAULT NULL,
  `shujuId` int(11) DEFAULT NULL,
  `shujuName` varchar(255) DEFAULT NULL,
  `sjleixingId` int(11) DEFAULT NULL,
  `sjleixingName` varchar(255) DEFAULT NULL,
  `sjxingtaiId` int(11) DEFAULT NULL,
  `sjxingtaiName` varchar(255) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `userName` varchar(255) DEFAULT NULL,
  `bumenId` int(11) DEFAULT NULL,
  `bumenName` varchar(255) DEFAULT NULL,
  `buyuanId` int(11) DEFAULT NULL,
  `buyuanName` varchar(255) DEFAULT NULL,
  `yonghuId` int(11) DEFAULT NULL,
  `yonghuName` varchar(255) DEFAULT NULL,
  `byumenId` int(11) DEFAULT NULL,
  `byumenName` varchar(255) DEFAULT NULL,
  `byuyuanId` int(11) DEFAULT NULL,
  `byuyuanName` varchar(255) DEFAULT NULL,
  `buzhiId` int(11) DEFAULT NULL,
  `buzhiName` varchar(255) DEFAULT NULL,
  `roleId` int(11) DEFAULT NULL,
  `roleName` varchar(255) DEFAULT NULL,
  `byuzhiId` int(11) DEFAULT NULL,
  `byuzhiName` varchar(255) DEFAULT NULL,
  `yhroleId` int(11) DEFAULT NULL,
  `yhroleName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`sjjianchuId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjjianchu
-- ----------------------------
INSERT INTO `t_sjjianchu` VALUES ('1', null, null, null, null, null, '2020-12-10 21:46:37', null, '33', null, null, '3', '99', null, '0', null, null, '1', '门店信息1', null, null, null, null, '1', '服装信息1', '1', '上衣', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjjianchu` VALUES ('2', null, null, null, null, null, '2020-12-10 21:46:47', null, '44', null, null, '3', '132', null, '0', null, null, '2', '门店信息2', null, null, null, null, '2', '服装信息2', '2', '裤子', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjjianchu` VALUES ('3', null, null, null, null, null, '2020-12-10 21:46:57', null, '55', null, null, '3', '165', null, '0', null, null, '2', '门店信息2', null, null, null, null, '3', '服装信息3', '2', '裤子', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjlaiyuan`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjlaiyuan`;
CREATE TABLE `t_sjlaiyuan` (
  `sjlaiyuanId` int(11) NOT NULL AUTO_INCREMENT,
  `sjlaiyuanName` varchar(255) DEFAULT NULL,
  `sjlaiyuanMark` varchar(255) DEFAULT NULL,
  `sjlaiyuanMark1` varchar(255) DEFAULT NULL,
  `sjlaiyuanMark2` varchar(255) DEFAULT NULL,
  `sjlaiyuanPhone` varchar(255) DEFAULT NULL,
  `sjlaiyuanDizhi` varchar(255) DEFAULT NULL,
  `sjlaiyuanDate` datetime DEFAULT NULL,
  `sjlaiyuanDate1` datetime DEFAULT NULL,
  `sjlaiyuanType` int(11) DEFAULT NULL,
  `sjlaiyuanType1` int(11) DEFAULT NULL,
  `sjlaiyuanDouble` double DEFAULT NULL,
  `sjlaiyuanDouble1` double DEFAULT NULL,
  PRIMARY KEY (`sjlaiyuanId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjlaiyuan
-- ----------------------------
INSERT INTO `t_sjlaiyuan` VALUES ('1', '供应商1', '供应商', null, null, '1301234578', '供应商', null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjleixing`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjleixing`;
CREATE TABLE `t_sjleixing` (
  `sjleixingId` int(11) NOT NULL AUTO_INCREMENT,
  `sjleixingName` varchar(255) DEFAULT NULL,
  `sjleixingMark` varchar(255) DEFAULT NULL,
  `sjleixingMark1` varchar(255) DEFAULT NULL,
  `sjleixingMark2` varchar(255) DEFAULT NULL,
  `sjleixingPhone` varchar(255) DEFAULT NULL,
  `sjleixingDizhi` varchar(255) DEFAULT NULL,
  `sjleixingDate` datetime DEFAULT NULL,
  `sjleixingDate1` datetime DEFAULT NULL,
  `sjleixingType` int(11) DEFAULT NULL,
  `sjleixingType1` int(11) DEFAULT NULL,
  `sjleixingDouble` double DEFAULT NULL,
  `sjleixingDouble1` double DEFAULT NULL,
  PRIMARY KEY (`sjleixingId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjleixing
-- ----------------------------
INSERT INTO `t_sjleixing` VALUES ('1', '上衣', '上衣', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjleixing` VALUES ('2', '裤子', '裤子', null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjqita`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjqita`;
CREATE TABLE `t_sjqita` (
  `sjqitaId` int(11) NOT NULL AUTO_INCREMENT,
  `sjqitaName` varchar(255) DEFAULT NULL,
  `sjqitaMark` varchar(255) DEFAULT NULL,
  `sjqitaMark1` varchar(255) DEFAULT NULL,
  `sjqitaMark2` varchar(255) DEFAULT NULL,
  `sjqitaPhone` varchar(255) DEFAULT NULL,
  `sjqitaDizhi` varchar(255) DEFAULT NULL,
  `sjqitaDate` datetime DEFAULT NULL,
  `sjqitaDate1` datetime DEFAULT NULL,
  `sjqitaType` int(11) DEFAULT NULL,
  `sjqitaType1` int(11) DEFAULT NULL,
  `sjqitaDouble` double DEFAULT NULL,
  `sjqitaDouble1` double DEFAULT NULL,
  PRIMARY KEY (`sjqitaId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjqita
-- ----------------------------
INSERT INTO `t_sjqita` VALUES ('1', '门店信息1', '门店信息', null, null, '13012345678', '门店信息', null, null, null, null, null, null);
INSERT INTO `t_sjqita` VALUES ('2', '门店信息2', '门店信息2', null, null, '13012345678', '门店信息2', null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjshaochu`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjshaochu`;
CREATE TABLE `t_sjshaochu` (
  `sjshaochuId` int(11) NOT NULL AUTO_INCREMENT,
  `sjshaochuName` varchar(255) DEFAULT NULL,
  `sjshaochuMark` varchar(2550) DEFAULT NULL,
  `sjshaochuMark1` varchar(2550) DEFAULT NULL,
  `sjshaochuMark2` varchar(2550) DEFAULT NULL,
  `sjshaochuMark3` varchar(2550) DEFAULT NULL,
  `sjshaochuDate` datetime DEFAULT NULL,
  `sjshaochuDate1` datetime DEFAULT NULL,
  `sjshaochuZong` int(11) DEFAULT NULL,
  `sjshaochuZong1` int(11) DEFAULT NULL,
  `sjshaochuZong2` int(11) DEFAULT NULL,
  `sjshaochuDouble` double DEFAULT NULL,
  `sjshaochuDouble1` double DEFAULT NULL,
  `sjshaochuDouble2` double DEFAULT NULL,
  `sjshaochuType` int(11) DEFAULT NULL,
  `sjshaochuType1` int(11) DEFAULT NULL,
  `sjshaochuType2` int(11) DEFAULT NULL,
  `sjqitaId` int(11) DEFAULT NULL,
  `sjqitaName` varchar(255) DEFAULT NULL,
  `sjlaiyuanId` int(11) DEFAULT NULL,
  `sjlaiyuanName` varchar(255) DEFAULT NULL,
  `sjshaochuImg` varchar(255) DEFAULT NULL,
  `sjshaochuImgName` varchar(255) DEFAULT NULL,
  `shujuId` int(11) DEFAULT NULL,
  `shujuName` varchar(255) DEFAULT NULL,
  `sjleixingId` int(11) DEFAULT NULL,
  `sjleixingName` varchar(255) DEFAULT NULL,
  `sjxingtaiId` int(11) DEFAULT NULL,
  `sjxingtaiName` varchar(255) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `userName` varchar(255) DEFAULT NULL,
  `bumenId` int(11) DEFAULT NULL,
  `bumenName` varchar(255) DEFAULT NULL,
  `buyuanId` int(11) DEFAULT NULL,
  `buyuanName` varchar(255) DEFAULT NULL,
  `yonghuId` int(11) DEFAULT NULL,
  `yonghuName` varchar(255) DEFAULT NULL,
  `byumenId` int(11) DEFAULT NULL,
  `byumenName` varchar(255) DEFAULT NULL,
  `byuyuanId` int(11) DEFAULT NULL,
  `byuyuanName` varchar(255) DEFAULT NULL,
  `buzhiId` int(11) DEFAULT NULL,
  `buzhiName` varchar(255) DEFAULT NULL,
  `roleId` int(11) DEFAULT NULL,
  `roleName` varchar(255) DEFAULT NULL,
  `byuzhiId` int(11) DEFAULT NULL,
  `byuzhiName` varchar(255) DEFAULT NULL,
  `yhroleId` int(11) DEFAULT NULL,
  `yhroleName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`sjshaochuId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjshaochu
-- ----------------------------
INSERT INTO `t_sjshaochu` VALUES ('1', '第三方', null, null, null, null, '2020-12-10 21:47:39', null, '2', null, null, '100', '200', null, '0', null, null, null, null, null, null, null, null, '1', '服装信息1', '1', '上衣', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjshaochu` VALUES ('2', '第三方', null, null, null, null, '2020-12-10 21:47:46', null, '6', null, null, '100', '600', null, '0', null, null, null, null, null, null, null, null, '2', '服装信息2', '2', '裤子', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjshaochu` VALUES ('3', '第三方', null, null, null, null, '2020-12-10 21:47:52', null, '4', null, null, '100', '400', null, '0', null, null, null, null, null, null, null, null, '3', '服装信息3', '2', '裤子', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjxingtai`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjxingtai`;
CREATE TABLE `t_sjxingtai` (
  `sjxingtaiId` int(11) NOT NULL AUTO_INCREMENT,
  `sjxingtaiName` varchar(255) DEFAULT NULL,
  `sjxingtaiMark` varchar(255) DEFAULT NULL,
  `sjxingtaiMark1` varchar(255) DEFAULT NULL,
  `sjxingtaiMark2` varchar(255) DEFAULT NULL,
  `sjxingtaiPhone` varchar(255) DEFAULT NULL,
  `sjxingtaiDizhi` varchar(255) DEFAULT NULL,
  `sjxingtaiDate` datetime DEFAULT NULL,
  `sjxingtaiDate1` datetime DEFAULT NULL,
  `sjxingtaiType` int(11) DEFAULT NULL,
  `sjxingtaiType1` int(11) DEFAULT NULL,
  `sjxingtaiDouble` double DEFAULT NULL,
  `sjxingtaiDouble1` double DEFAULT NULL,
  PRIMARY KEY (`sjxingtaiId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjxingtai
-- ----------------------------
INSERT INTO `t_sjxingtai` VALUES ('1', '品牌1', '品牌', null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(255) DEFAULT NULL,
  `userPassword` varchar(255) DEFAULT NULL,
  `userXingming` varchar(255) DEFAULT NULL,
  `userSex` int(11) DEFAULT NULL,
  `userAge` int(11) DEFAULT NULL,
  `userMinzu` varchar(255) DEFAULT NULL,
  `userPhone` varchar(255) DEFAULT NULL,
  `userMark` varchar(2550) DEFAULT NULL,
  `userMark1` varchar(255) DEFAULT NULL,
  `userMark2` varchar(255) DEFAULT NULL,
  `userMark3` varchar(255) DEFAULT NULL,
  `userMark4` varchar(255) DEFAULT NULL,
  `userDate` datetime DEFAULT NULL,
  `userDate1` datetime DEFAULT NULL,
  `userDate2` datetime DEFAULT NULL,
  `userType` int(11) DEFAULT NULL,
  `userType1` int(11) DEFAULT NULL,
  `userType2` int(11) DEFAULT NULL,
  `userDouble` double DEFAULT NULL,
  `userDouble1` double DEFAULT NULL,
  `userDouble2` double DEFAULT NULL,
  `userZong` int(11) DEFAULT NULL,
  `userZong1` int(11) DEFAULT NULL,
  `userZong2` int(11) DEFAULT NULL,
  `userImg` varchar(255) DEFAULT NULL,
  `userImgName` varchar(255) DEFAULT NULL,
  `roleId` int(11) DEFAULT NULL,
  `roleName` varchar(255) DEFAULT NULL,
  `bumenId` int(11) DEFAULT NULL,
  `bumenName` varchar(255) DEFAULT NULL,
  `buyuanId` int(11) DEFAULT NULL,
  `buyuanName` varchar(255) DEFAULT NULL,
  `buzhiId` int(11) DEFAULT NULL,
  `buzhiName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', 'user1', 'user1', 'user1', '0', '22', null, '13012345678', null, null, null, null, null, '2020-12-10 21:44:24', null, null, '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
 

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值