/*
 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: 02/03/2017 17:20:14 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `academic_verifications`
-- ----------------------------
DROP TABLE IF EXISTS `academic_verifications`;
CREATE TABLE `academic_verifications` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` mediumint(9) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `school_id` mediumint(9) DEFAULT NULL,
  `employer_id` varchar(255) DEFAULT NULL,
  `other_name` varchar(255) DEFAULT NULL,
  `name_at_grad` varchar(255) DEFAULT NULL,
  `start_date` varchar(255) DEFAULT NULL,
  `end_date` varchar(255) DEFAULT NULL,
  `grad_date` varchar(255) DEFAULT NULL,
  `degree` varchar(255) DEFAULT NULL,
  `course_of_study` varchar(255) DEFAULT NULL,
  `resp_school_name` varchar(255) DEFAULT NULL,
  `resp_name_at_grad` varchar(255) DEFAULT NULL,
  `resp_start_date` varchar(255) DEFAULT NULL,
  `resp_end_date` varchar(255) DEFAULT NULL,
  `resp_grad_date` varchar(255) DEFAULT NULL,
  `resp_degree` varchar(255) DEFAULT NULL,
  `resp_course_of_study` varchar(255) DEFAULT NULL,
  `verified_by_src` varchar(255) DEFAULT NULL,
  `verified_by_emp` varchar(255) DEFAULT NULL,
  `fees` decimal(9,2) 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=23 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `crim_verification_records`
-- ----------------------------
DROP TABLE IF EXISTS `crim_verification_records`;
CREATE TABLE `crim_verification_records` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `case_no` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `dob` varchar(255) DEFAULT NULL,
  `other_id` varchar(255) DEFAULT NULL,
  `ssn` varchar(255) DEFAULT NULL,
  `count` varchar(255) DEFAULT NULL,
  `offense_date` varchar(255) DEFAULT NULL,
  `file_date` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `final_disposition` varchar(255) DEFAULT NULL,
  `final_disp_date` varchar(255) DEFAULT NULL,
  `sentence` text,
  `crim_verification_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `crim_verifications`
-- ----------------------------
DROP TABLE IF EXISTS `crim_verifications`;
CREATE TABLE `crim_verifications` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` mediumint(9) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `type` varchar(2) DEFAULT NULL,
  `is_found` char(1) DEFAULT NULL,
  `method` varchar(2) DEFAULT NULL,
  `fees` decimal(9,2) DEFAULT NULL,
  `verified_by_emp` varchar(255) DEFAULT NULL,
  `verified_date` 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=25 DEFAULT CHARSET=latin1;

SET FOREIGN_KEY_CHECKS = 1;
