/*
 Navicat Premium Data Transfer

 Source Server         : Localhost
 Source Server Type    : MySQL
 Source Server Version : 50534
 Source Host           : localhost
 Source Database       : itrims_angular

 Target Server Type    : MySQL
 Target Server Version : 50534
 File Encoding         : utf-8

 Date: 03/06/2017 17:07:24 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `reference_verifications`
-- ----------------------------
DROP TABLE IF EXISTS `reference_verifications`;
CREATE TABLE `reference_verifications` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` mediumint(9) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `type_id` char(1) DEFAULT NULL,
  `other_name` varchar(255) DEFAULT NULL,
  `fees` decimal(9,2) DEFAULT NULL,
  `is_flagged` char(1) DEFAULT NULL,
  `organization_name` mediumint(9) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `street_address1` varchar(255) DEFAULT NULL,
  `street_address2` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state_id` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `reference_form_id` int(10) DEFAULT NULL,

  `reference_prev_position` varchar(100) DEFAULT NULL,
  `reference_start_date` varchar(50) DEFAULT NULL,
  `reference_end_date` varchar(50) DEFAULT NULL,
  `reference_reason_for_leaving` varchar(255) DEFAULT NULL,
  `reference_salary` varchar(50) DEFAULT NULL,
  `reference_eligible_for_rehire` char(1) DEFAULT NULL,
  `reference_disciplinary_action` char(1) DEFAULT NULL,
  `reference_disciplinary_action_explanation` text DEFAULT NULL,

  `resp_reference_prev_position` varchar(100) DEFAULT NULL,
  `resp_reference_start_date` varchar(50) DEFAULT NULL,
  `resp_reference_end_date` varchar(50) DEFAULT NULL,
  `resp_reference_reason_for_leaving` varchar(255) DEFAULT NULL,
  `resp_reference_salary` varchar(50) DEFAULT NULL,
  `resp_reference_eligible_for_rehire` char(1) DEFAULT NULL,
  `resp_reference_disciplinary_action` char(1) DEFAULT NULL,
  `resp_reference_disciplinary_action_explanation` text DEFAULT NULL,

  `comments` text DEFAULT NULL,
  `recruiter_notes` text DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL;

  `verified_by_src` varchar(255) DEFAULT NULL,
  `verified_by_emp` varchar(255) DEFAULT NULL,
  `verified_date` varchar(255) DEFAULT NULL,
  `verification_status` varchar(255) DEFAULT NULL,
  `employee` varchar(255) DEFAULT NULL,
  `last_update` varchar(255) DEFAULT NULL,
  `added_by_recruiter` char(1) DEFAULT NULL,
  `hard_copies_required` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `rv_custom_form_answers`;
CREATE TABLE `rv_custom_form_answers` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `verifiction_id` bigint(20) NOT NULL,
    `question_id` bigint(20) NOT NULL,
    `answer` text DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;


SET FOREIGN_KEY_CHECKS = 1;