/*
Navicat MySQL Data Transfer

Source Server         : Dareen
Source Server Version : 50722
Source Host           : localhost:3306
Source Database       : nxbbd

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

Date: 2019-05-26 08:57:00
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for finger
-- ----------------------------
DROP TABLE IF EXISTS `finger`;
CREATE TABLE `finger` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `active` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否可用',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  `update_by` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '修改者',
  `fingerPhoto` varchar(100) DEFAULT NULL COMMENT '指纹相片',
  `fingerLocation` varchar(100) DEFAULT NULL COMMENT '指位',
  `name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `sex` varchar(10) DEFAULT NULL COMMENT '性别',
  `cardNo` varchar(20) DEFAULT NULL COMMENT '身份证号码',
  `companyName` varchar(100) DEFAULT NULL COMMENT '公司名称',
  `inputPerson` varchar(50) DEFAULT NULL COMMENT '采集人',
  `inputOrg` varchar(100) DEFAULT NULL COMMENT '采集机构',
  PRIMARY KEY (`id`),
  KEY `finger_key` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;