SpringCloud/bill.sql · 优秀的颜/JavaProject

Fetch the repository succeeded.

Scan WeChat QR to Pay

Cancel

Complete

richgiteeai

Watch

Unwatch Watching Releases Only Ignoring

1 Star 0 Fork 0

优秀的颜/JavaProject

Code Issues 0 Pull Requests 0 Wiki Insights Pipelines

Service

Tencent Cloud Serverless

Create your Gitee Account

Explore and code with more than 14 million developers,Free private repositories !:)

Already have an account? Sign in

文件

master

Branches (1)

Manage

master

Clone or Download

Clone/Download

HTTPS SSH SVN SVN+SSH Download ZIP

Prompt

To download the code, please copy the following command and execute it in the terminal

To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.

git config --global user.name userName 
git config --global user.email userEmail

When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.

1 Generate RSA keys.

2 Obtain the content of the RSA public key and configure it in SSH Public Keys

To use SVN on Gitee, please visit the usage guide

When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # Private Token

Branches 1

Tags 0

JavaProject

SpringCloud

bill.sql

bill.sql 6.82 KB

/*
Navicat MySQL Data Transfer

Source Server : localhost_3306
Source Server Version : 50540
Source Host : localhost:3306
Source Database : bill

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

Date: 2020年07月16日 23:02:46
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for bill
-- ----------------------------
DROP TABLE IF EXISTS `bill`;
CREATE TABLE `bill` (
 `bid` int(10) NOT NULL AUTO_INCREMENT,
 `bill_code` varchar(25) DEFAULT NULL,
 `bill_name` varchar(25) DEFAULT NULL,
 `bill_com` varchar(25) DEFAULT NULL,
 `bill_num` int(8) DEFAULT NULL,
 `money` double(8,2) DEFAULT NULL,
 `pay` int(2) DEFAULT NULL COMMENT '是否付款 0 未付款, 1已付款',
 `pid` int(10) DEFAULT NULL COMMENT '供应商id',
 `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`bid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bill
-- ----------------------------
INSERT INTO `bill` VALUES ('1', 'B_00111', 'ESC包年云服务11', '年11', '39', '400000.00', '1', '1', '2020年01月15日 22:32:07');
INSERT INTO `bill` VALUES ('2', 'b_002', 'ESC包月云服务', '月', '20', '26000.00', '1', '3', '2028年11月12日 11:58:00');
INSERT INTO `bill` VALUES ('3', 'b_003', 'com域名', '年', '33', '15000.00', '0', '1', '2028年11月12日 11:58:00');
INSERT INTO `bill` VALUES ('4', 'b_004', 'cn域名', '小时', '10', '7000.00', '0', '1', '2028年11月12日 11:58:00');
INSERT INTO `bill` VALUES ('5', 'b_005', '团购小程序', '月', '3', '60000.00', '1', '4', '2028年11月12日 11:58:00');
INSERT INTO `bill` VALUES ('7', '1', '11', '1', '11', '1.00', '1', '3', '2020年01月15日 23:12:06');

-- ----------------------------
-- Table structure for dept
-- ----------------------------
DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `dname` varchar(200) NOT NULL,
 `db_source` varchar(200) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dept
-- ----------------------------
INSERT INTO `dept` VALUES ('1', '研发部', 'db01');
INSERT INTO `dept` VALUES ('2', '人事部', 'db01');
INSERT INTO `dept` VALUES ('3', '财务部', 'db01');
INSERT INTO `dept` VALUES ('4', '市场部', 'db01');
INSERT INTO `dept` VALUES ('5', '运维部', 'db01');

-- ----------------------------
-- Table structure for provider
-- ----------------------------
DROP TABLE IF EXISTS `provider`;
CREATE TABLE `provider` (
 `pid` int(10) NOT NULL AUTO_INCREMENT,
 `provider_code` varchar(25) DEFAULT NULL,
 `providerName` varchar(25) DEFAULT NULL,
 `people` varchar(25) DEFAULT NULL,
 `phone` varchar(15) DEFAULT NULL,
 `address` varchar(60) DEFAULT NULL,
 `fax` varchar(25) DEFAULT NULL,
 `describe` varchar(100) DEFAULT NULL,
 `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of provider
-- ----------------------------
INSERT INTO `provider` VALUES ('1', 'P_111', 'A货云服务供应商11', '小码', '1888888888111', '广州白云区', '020-123456', '专业ESC服务商', '2020年01月11日 17:24:43');
INSERT INTO `provider` VALUES ('2', 'P_222', 'B货域名供应商', '小域', '1888886666', '北京朝阳区', '020-112312123', '专业提供域名', '2020年01月02日 21:44:12');
INSERT INTO `provider` VALUES ('3', 'P_333', 'B货小程序企鹅', '小企鹅', '1888666666', '深圳南山区', '020-123123', '专业小程序提供', '2028年11月12日 11:52:17');
INSERT INTO `provider` VALUES ('4', 'P_444', '其他渠道供应商', '无名11', '18889999991', '北京1', '010-10001', '专业渠道来源', '2020年01月03日 22:01:54');
INSERT INTO `provider` VALUES ('6', 'P_555', '梦学谷供应商1', '小张', '18888666981', '深圳软件园', '0911-0123456', '品质Aaa', '2020年01月03日 22:01:38');
INSERT INTO `provider` VALUES ('10', null, '修改名字1', null, '123456789', null, null, null, '2020年03月05日 15:46:23');
INSERT INTO `provider` VALUES ('11', null, '修改名字14744', null, '123456789', null, null, null, '2020年03月05日 13:29:44');

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(200) NOT NULL,
 `tid` int(11) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('1', '小明', '1');
INSERT INTO `student` VALUES ('2', '王阳', '1');
INSERT INTO `student` VALUES ('3', '李哥', '1');
INSERT INTO `student` VALUES ('4', '白菜', '1');
INSERT INTO `student` VALUES ('5', '刘德海', '2');
INSERT INTO `student` VALUES ('6', '东海', '2');
INSERT INTO `student` VALUES ('7', '皮蛋', '3');

-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(200) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES ('1', '郭老师');
INSERT INTO `teacher` VALUES ('2', '马老师');
INSERT INTO `teacher` VALUES ('3', '赢老师');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
 `id` int(10) NOT NULL AUTO_INCREMENT,
 `username` varchar(25) DEFAULT NULL,
 `real_name` varchar(25) DEFAULT NULL,
 `password` varchar(25) DEFAULT NULL,
 `gender` int(1) DEFAULT NULL COMMENT '性别:1 女 2 男',
 `birthday` datetime DEFAULT NULL,
 `user_type` int(1) DEFAULT NULL COMMENT '1管理员 2经理 3普通用户',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'root', '系统管理员', '11', '1', '2003年11月12日 00:00:00', '1');
INSERT INTO `user` VALUES ('2', 'lisi', '李四', '123', '2', '1983年11月12日 00:00:00', '2');
INSERT INTO `user` VALUES ('3', 'wangwu', '王五', '123', '2', '1953年11月12日 00:00:00', '3');
INSERT INTO `user` VALUES ('4', 'zhangsan', '张三', '123', '1', '1973年11月12日 00:00:00', '3');
INSERT INTO `user` VALUES ('6', 'a', 'www', '123', '2', '2018年12月12日 00:00:00', '2');
INSERT INTO `user` VALUES ('8', 'b', 'www', '111', null, '2018年12月12日 00:00:00', null);
INSERT INTO `user` VALUES ('10', 'c', '4444', '111', '1', '2018年12月12日 00:00:00', '2');
INSERT INTO `user` VALUES ('11', 'd', 'd', '111', '1', '2018年12月12日 00:00:00', '2');
INSERT INTO `user` VALUES ('12', '2aaaa', 'e', '111', '2', '2018年12月12日 00:00:00', '1');

Copy Edit Raw Blame History

yan418 authored 2020年08月02日 21:28 +08:00 . SpringCloud构建分布式系统,Eureka、Ribbon、Feign、Hystrix、Zuul、Config、Bus

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158

/*
Navicat MySQL Data Transfer

Source Server : localhost_3306
Source Server Version : 50540
Source Host : localhost:3306
Source Database : bill

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

Date: 2020年07月16日 23:02:46
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for bill
-- ----------------------------
DROP TABLE IF EXISTS `bill`;
CREATE TABLE `bill` (
 `bid` int(10) NOT NULL AUTO_INCREMENT,
 `bill_code` varchar(25) DEFAULT NULL,
 `bill_name` varchar(25) DEFAULT NULL,
 `bill_com` varchar(25) DEFAULT NULL,
 `bill_num` int(8) DEFAULT NULL,
 `money` double(8,2) DEFAULT NULL,
 `pay` int(2) DEFAULT NULL COMMENT '是否付款 0 未付款, 1已付款',
 `pid` int(10) DEFAULT NULL COMMENT '供应商id',
 `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`bid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bill
-- ----------------------------
INSERT INTO `bill` VALUES ('1', 'B_00111', 'ESC包年云服务11', '年11', '39', '400000.00', '1', '1', '2020-01-15 22:32:07');
INSERT INTO `bill` VALUES ('2', 'b_002', 'ESC包月云服务', '月', '20', '26000.00', '1', '3', '2028-11-12 11:58:00');
INSERT INTO `bill` VALUES ('3', 'b_003', 'com域名', '年', '33', '15000.00', '0', '1', '2028-11-12 11:58:00');
INSERT INTO `bill` VALUES ('4', 'b_004', 'cn域名', '小时', '10', '7000.00', '0', '1', '2028-11-12 11:58:00');
INSERT INTO `bill` VALUES ('5', 'b_005', '团购小程序', '月', '3', '60000.00', '1', '4', '2028-11-12 11:58:00');
INSERT INTO `bill` VALUES ('7', '1', '11', '1', '11', '1.00', '1', '3', '2020-01-15 23:12:06');

-- ----------------------------
-- Table structure for dept
-- ----------------------------
DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `dname` varchar(200) NOT NULL,
 `db_source` varchar(200) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dept
-- ----------------------------
INSERT INTO `dept` VALUES ('1', '研发部', 'db01');
INSERT INTO `dept` VALUES ('2', '人事部', 'db01');
INSERT INTO `dept` VALUES ('3', '财务部', 'db01');
INSERT INTO `dept` VALUES ('4', '市场部', 'db01');
INSERT INTO `dept` VALUES ('5', '运维部', 'db01');

-- ----------------------------
-- Table structure for provider
-- ----------------------------
DROP TABLE IF EXISTS `provider`;
CREATE TABLE `provider` (
 `pid` int(10) NOT NULL AUTO_INCREMENT,
 `provider_code` varchar(25) DEFAULT NULL,
 `providerName` varchar(25) DEFAULT NULL,
 `people` varchar(25) DEFAULT NULL,
 `phone` varchar(15) DEFAULT NULL,
 `address` varchar(60) DEFAULT NULL,
 `fax` varchar(25) DEFAULT NULL,
 `describe` varchar(100) DEFAULT NULL,
 `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of provider
-- ----------------------------
INSERT INTO `provider` VALUES ('1', 'P_111', 'A货云服务供应商11', '小码', '1888888888111', '广州白云区', '020-123456', '专业ESC服务商', '2020-01-11 17:24:43');
INSERT INTO `provider` VALUES ('2', 'P_222', 'B货域名供应商', '小域', '1888886666', '北京朝阳区', '020-112312123', '专业提供域名', '2020-01-02 21:44:12');
INSERT INTO `provider` VALUES ('3', 'P_333', 'B货小程序企鹅', '小企鹅', '1888666666', '深圳南山区', '020-123123', '专业小程序提供', '2028-11-12 11:52:17');
INSERT INTO `provider` VALUES ('4', 'P_444', '其他渠道供应商', '无名11', '18889999991', '北京1', '010-10001', '专业渠道来源', '2020-01-03 22:01:54');
INSERT INTO `provider` VALUES ('6', 'P_555', '梦学谷供应商1', '小张', '18888666981', '深圳软件园', '0911-0123456', '品质Aaa', '2020-01-03 22:01:38');
INSERT INTO `provider` VALUES ('10', null, '修改名字1', null, '123456789', null, null, null, '2020-03-05 15:46:23');
INSERT INTO `provider` VALUES ('11', null, '修改名字14744', null, '123456789', null, null, null, '2020-03-05 13:29:44');

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(200) NOT NULL,
 `tid` int(11) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('1', '小明', '1');
INSERT INTO `student` VALUES ('2', '王阳', '1');
INSERT INTO `student` VALUES ('3', '李哥', '1');
INSERT INTO `student` VALUES ('4', '白菜', '1');
INSERT INTO `student` VALUES ('5', '刘德海', '2');
INSERT INTO `student` VALUES ('6', '东海', '2');
INSERT INTO `student` VALUES ('7', '皮蛋', '3');

-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(200) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES ('1', '郭老师');
INSERT INTO `teacher` VALUES ('2', '马老师');
INSERT INTO `teacher` VALUES ('3', '赢老师');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
 `id` int(10) NOT NULL AUTO_INCREMENT,
 `username` varchar(25) DEFAULT NULL,
 `real_name` varchar(25) DEFAULT NULL,
 `password` varchar(25) DEFAULT NULL,
 `gender` int(1) DEFAULT NULL COMMENT '性别:1 女 2 男',
 `birthday` datetime DEFAULT NULL,
 `user_type` int(1) DEFAULT NULL COMMENT '1管理员 2经理 3普通用户',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'root', '系统管理员', '11', '1', '2003-11-12 00:00:00', '1');
INSERT INTO `user` VALUES ('2', 'lisi', '李四', '123', '2', '1983-11-12 00:00:00', '2');
INSERT INTO `user` VALUES ('3', 'wangwu', '王五', '123', '2', '1953-11-12 00:00:00', '3');
INSERT INTO `user` VALUES ('4', 'zhangsan', '张三', '123', '1', '1973-11-12 00:00:00', '3');
INSERT INTO `user` VALUES ('6', 'a', 'www', '123', '2', '2018-12-12 00:00:00', '2');
INSERT INTO `user` VALUES ('8', 'b', 'www', '111', null, '2018-12-12 00:00:00', null);
INSERT INTO `user` VALUES ('10', 'c', '4444', '111', '1', '2018-12-12 00:00:00', '2');
INSERT INTO `user` VALUES ('11', 'd', 'd', '111', '1', '2018-12-12 00:00:00', '2');
INSERT INTO `user` VALUES ('12', '2aaaa', 'e', '111', '2', '2018-12-12 00:00:00', '1');