/*
Navicat MySQL Data Transfer
Source Host     : bcxin366.mysql.rds.aliyuncs.com:3306
Source Database : ars
Target Host     : bcxin366.mysql.rds.aliyuncs.com:3306
Target Database : ars
Date: 2017/4/12 9:48:43
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for invoice
-- ----------------------------
DROP TABLE IF EXISTS `invoice`;
CREATE TABLE `invoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `active` bit(1) DEFAULT b'1',
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL,
  `companyname` varchar(200) DEFAULT NULL COMMENT '单位名称',
  `tel` varchar(30) DEFAULT NULL COMMENT '电话',
  `bank` varchar(50) DEFAULT NULL COMMENT '开户银行',
  `register` varchar(200) DEFAULT NULL COMMENT '注册地址',
  `bankaccount` varchar(50) DEFAULT NULL COMMENT '银行帐号',
  `sendaddress` varchar(200) DEFAULT NULL COMMENT '寄送地址',
  `certificate` varchar(100) DEFAULT NULL COMMENT '税务登记证',
  `businesslicense` varchar(100) DEFAULT NULL COMMENT '营业执照副本',
  `taxprove` varchar(100) DEFAULT NULL COMMENT '一般人纳税证明',
  `proxy` varchar(100) DEFAULT NULL COMMENT '增值税授权委托书',
  `licence` varchar(100) DEFAULT NULL COMMENT '银行开户许可证',
  `user_id` int(11) DEFAULT NULL COMMENT '保安公司ID',
  `update_time` datetime DEFAULT NULL,
  `taxnumber` varchar(50) DEFAULT NULL COMMENT '纳税人识别号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of invoice
-- ----------------------------
INSERT INTO `invoice` VALUES ('1', '
', '2017-04-05 17:04:17', '4', null, '123', '123', '123', '123', '123', 'getResource.do?path=upload/2017-04-05/1491382975441_QQ图片20170314141021.jpg', '', 'getResource.do?path=upload/2017-04-05/1491382980211_QQ图片20170314141021.jpg', 'getResource.do?path=upload/2017-04-05/1491382982249_QQ图片20170314141021.jpg', 'getResource.do?path=upload/2017-04-05/1491382985391_QQ图片20170314141021.jpg', '4', '2017-04-05 17:04:17', '123');
INSERT INTO `invoice` VALUES ('2', '
', '2017-04-05 17:07:05', '4', null, '333', '333', '333', '333', '333', 'getResource.do?path=upload/2017-04-05/1491383165450_QQ图片20170314141021.jpg', 'getResource.do?path=upload/2017-04-05/1491383167894_QQ图片20170314141021.jpg', 'getResource.do?path=upload/2017-04-05/1491383169913_QQ图片20170314141021.jpg', 'getResource.do?path=upload/2017-04-05/1491383172555_QQ图片20170314141021.jpg', 'getResource.do?path=upload/2017-04-05/1491383175486_QQ图片20170314141021.jpg', '4', '2017-04-05 17:07:05', '333');
INSERT INTO `invoice` VALUES ('3', '
', '2017-04-05 17:10:55', '4', 'mm公司', '3', '3', '3', '3', '3', 'getResource.do?path=upload/2017-04-05/1491383439766_QQ图片20170314141021.jpg', 'getResource.do?path=upload/2017-04-05/1491383442578_QQ图片20170314141021.jpg', 'getResource.do?path=upload/2017-04-05/1491383447811_QQ图片20170314141021.jpg', 'getResource.do?path=upload/2017-04-05/1491383445367_QQ图片20170314141021.jpg', 'getResource.do?path=upload/2017-04-05/1491383450380_QQ图片20170314141021.jpg', '4', '2017-04-05 17:10:55', '3');
INSERT INTO `invoice` VALUES ('4', '
', '2017-04-10 13:40:09', '4', null, null, null, null, null, null, null, null, null, null, null, '4', '2017-04-10 13:40:09', null);
INSERT INTO `invoice` VALUES ('5', '
', '2017-04-10 13:40:21', '4', null, null, null, null, null, null, null, null, null, null, null, '4', '2017-04-10 13:40:21', null);
INSERT INTO `invoice` VALUES ('6', '
', '2017-04-10 13:44:40', '4', null, null, null, null, null, null, null, null, null, null, null, '4', '2017-04-10 13:44:40', null);
INSERT INTO `invoice` VALUES ('7', '
', '2017-04-10 17:08:20', '4', null, null, null, null, null, null, null, null, null, null, null, '4', '2017-04-10 17:08:20', null);
INSERT INTO `invoice` VALUES ('8', '
', '2017-04-11 09:30:36', '4', null, null, null, null, null, null, null, null, null, null, null, '4', '2017-04-11 09:30:36', null);
INSERT INTO `invoice` VALUES ('9', '
', '2017-04-11 10:52:13', '4', null, null, null, null, null, null, null, null, null, null, null, '4', '2017-04-11 10:52:13', null);