/*
Navicat MySQL Data Transfer

Source Server         : bcxin
Source Server Version : 50518
Source Host           : bcxin366.mysql.rds.aliyuncs.com:3306
Source Database       : ars

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

Date: 2017-08-27 09:26:44
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for backgroundapproval
-- ----------------------------
DROP TABLE IF EXISTS `backgroundapproval`;
CREATE TABLE `backgroundapproval` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `active` bit(1) DEFAULT NULL COMMENT '是否可用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` varchar(50) DEFAULT NULL COMMENT '修改者',
  `businesstype` varchar(3) DEFAULT NULL COMMENT '业务类型',
  `approvalstate` varchar(3) DEFAULT NULL COMMENT '审批状态',
  `approvalreason` varchar(20) DEFAULT NULL COMMENT '审批人',
  `businessid` int(11) DEFAULT NULL,
  `rawid` int(11) DEFAULT NULL,
  `inrawid` int(11) DEFAULT NULL,
  `approvalDate` datetime DEFAULT NULL COMMENT '审批时间',
  `libraryType` varchar(10) DEFAULT NULL,
  `rgapprovalstate` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bg_id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;