Skip to content

Instantly share code, notes, and snippets.

@pedro2555

pedro2555/db_fos.sql

Last active May 11, 2019 14:35
Show Gist options
  • Save pedro2555/6f8def57bd590e944bece6ccbac38b6e to your computer and use it in GitHub Desktop.
Save pedro2555/6f8def57bd590e944bece6ccbac38b6e to your computer and use it in GitHub Desktop.
Download ZIP
tapvirtual database structure dump
Raw
db_fos.sql
-- MySQL dump 10.13 Distrib 5.6.35, for debian-linux-gnu (x86_64)
--
-- Host: flytapv.com Database: db_fos
-- ------------------------------------------------------
-- Server version 4.1.21-standard
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `tbl_access_control`
--
DROP TABLE IF EXISTS `tbl_access_control`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_access_control` (
`access_id` int(11) NOT NULL auto_increment,
`callsign_FK` varchar(7) NOT NULL default '',
`access_date` date default NULL,
`access_time` time default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`access_id`),
KEY `indx_callsign_FK` (`callsign_FK`),
KEY `indx_access_date` (`access_date`),
CONSTRAINT `access` FOREIGN KEY (`callsign_FK`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_access_pages`
--
DROP TABLE IF EXISTS `tbl_access_pages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_access_pages` (
`access_page_id` int(11) NOT NULL auto_increment,
`access_id_FK` int(11) NOT NULL default '0',
`page_URL` varchar(150) default NULL,
`access_time` time default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`access_page_id`),
KEY `indx_access_id_FK` (`access_id_FK`),
KEY `indx_access_time` (`access_time`),
CONSTRAINT `access_pages` FOREIGN KEY (`access_id_FK`) REFERENCES `tbl_access_control` (`access_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_aircraft_type`
--
DROP TABLE IF EXISTS `tbl_aircraft_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_aircraft_type` (
`air_type_ID` varchar(5) NOT NULL default '',
`air_description` varchar(30) default NULL,
`fleet_id` int(11) default NULL,
`qualification_id` int(2) default NULL,
`model_price` varchar(6) default NULL,
`model_image` varchar(30) default NULL,
`model_obs` varchar(255) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`air_type_ID`),
KEY `fleet_id` (`fleet_id`),
KEY `qualification_id` (`qualification_id`),
CONSTRAINT `fleet` FOREIGN KEY (`fleet_id`) REFERENCES `tbl_fleet` (`fleet_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `qualification_II` FOREIGN KEY (`qualification_id`) REFERENCES `tbl_qualification` (`qualification_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_company_status`
--
DROP TABLE IF EXISTS `tbl_company_status`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_company_status` (
`type_id` char(2) NOT NULL default '',
`description` varchar(30) default NULL,
`long_description` varchar(60) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_country`
--
DROP TABLE IF EXISTS `tbl_country`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_country` (
`country_id` char(3) NOT NULL default '',
`printable_name` varchar(80) NOT NULL default '',
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_cpny_needs`
--
DROP TABLE IF EXISTS `tbl_cpny_needs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_cpny_needs` (
`ID` int(11) NOT NULL auto_increment,
`fleet_id_FK` int(11) default '0',
`rank_id_FK` int(2) default '0',
`maximum_slots` int(3) default NULL,
`necessitie` tinyint(1) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `indx_fleet_rank` (`fleet_id_FK`,`rank_id_FK`),
KEY `rank_V` (`rank_id_FK`),
CONSTRAINT `fleet_III` FOREIGN KEY (`fleet_id_FK`) REFERENCES `tbl_fleet` (`fleet_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `rank_V` FOREIGN KEY (`rank_id_FK`) REFERENCES `tbl_rank` (`rank_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_exam_pratical`
--
DROP TABLE IF EXISTS `tbl_exam_pratical`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_exam_pratical` (
`ID` int(11) NOT NULL auto_increment,
`exam_id_FK` int(11) default NULL,
`fleet_id_FK` int(11) default NULL,
`exam_pratical_desc` varchar(30) default NULL,
`requirement_eval` int(12) default NULL,
`failure` int(2) default NULL,
`failure_aft_time` int(2) default NULL,
`wind_speed` int(3) default NULL,
`wind_hdg` int(3) default NULL,
`wind_dep` int(1) default NULL,
`wind_arr` int(1) default NULL,
`visibility` int(2) default NULL,
`visibility_dep` int(1) default NULL,
`visibility_arr` int(1) default NULL,
`precipitation` int(2) default NULL,
`precipitation_dep` int(1) default NULL,
`precipitation_arr` int(1) default NULL,
`turbulence` int(2) default NULL,
`turbulence_dep` int(1) default NULL,
`turbulence_arr` int(1) default NULL,
`ori_dest` varchar(15) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `indx_exam_fleet` (`exam_id_FK`,`fleet_id_FK`),
KEY `fleet_VI` (`fleet_id_FK`),
CONSTRAINT `exam_id_IV` FOREIGN KEY (`exam_id_FK`) REFERENCES `tbl_exams` (`exam_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fleet_VI` FOREIGN KEY (`fleet_id_FK`) REFERENCES `tbl_fleet` (`fleet_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_exam_questions`
--
DROP TABLE IF EXISTS `tbl_exam_questions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_exam_questions` (
`question_id` int(11) NOT NULL auto_increment,
`exam_id_FK` int(11) NOT NULL default '0',
`question_nmbr` int(3) default NULL,
`question_desc` varchar(200) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`question_id`),
UNIQUE KEY `unique_question` (`exam_id_FK`,`question_nmbr`),
KEY `exam_id_FK` (`exam_id_FK`),
CONSTRAINT `exam_id_II` FOREIGN KEY (`exam_id_FK`) REFERENCES `tbl_exams` (`exam_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_exams`
--
DROP TABLE IF EXISTS `tbl_exams`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_exams` (
`exam_id` int(11) NOT NULL auto_increment,
`exam_desc` varchar(50) default NULL,
`exam_nquestions` int(2) default NULL,
`minimum_requirement` int(2) default NULL,
`time_to_do` int(3) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`exam_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_exams_answers`
--
DROP TABLE IF EXISTS `tbl_exams_answers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_exams_answers` (
`answers_ID` int(11) NOT NULL auto_increment,
`question_id_FK` int(11) NOT NULL default '0',
`answers_desc` varchar(200) default NULL,
`value` tinyint(1) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`answers_ID`),
KEY `question_id_FK` (`question_id_FK`),
CONSTRAINT `question_id` FOREIGN KEY (`question_id_FK`) REFERENCES `tbl_exam_questions` (`question_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_exams_requests`
--
DROP TABLE IF EXISTS `tbl_exams_requests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_exams_requests` (
`ID` int(11) NOT NULL auto_increment,
`request_id_FK` int(11) default NULL,
`question_id_FK` int(11) default NULL,
`question_nmbr` int(3) default NULL,
`answers_ID` int(11) default NULL,
`anws_true_false` int(1) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `indx_request_question` (`request_id_FK`,`question_id_FK`),
KEY `question_nmbr` (`question_nmbr`),
KEY `question_id_II` (`question_id_FK`),
CONSTRAINT `question_id_II` FOREIGN KEY (`question_id_FK`) REFERENCES `tbl_exam_questions` (`question_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT `request_id` FOREIGN KEY (`request_id_FK`) REFERENCES `tbl_requests` (`request_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_fleet`
--
DROP TABLE IF EXISTS `tbl_fleet`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_fleet` (
`fleet_id` int(11) NOT NULL auto_increment,
`description` varchar(30) default NULL,
`fleet_active` int(11) default NULL,
`free_slots` int(4) default NULL,
`days_outof_base` int(11) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`fleet_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_fleet_has_tbl_users`
--
DROP TABLE IF EXISTS `tbl_fleet_has_tbl_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_fleet_has_tbl_users` (
`ID` int(11) NOT NULL auto_increment,
`fleet_id` int(11) default '0',
`callsign` varchar(7) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `indx_fleet_callsing` (`fleet_id`,`callsign`),
KEY `callsign_II` (`callsign`),
CONSTRAINT `callsign_II` FOREIGN KEY (`callsign`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT `fleet_II` FOREIGN KEY (`fleet_id`) REFERENCES `tbl_fleet` (`fleet_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_fleet_nair_stat`
--
DROP TABLE IF EXISTS `tbl_fleet_nair_stat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_fleet_nair_stat` (
`fleet_nair_stat_id` int(11) NOT NULL auto_increment,
`fleet_id_FK` int(11) NOT NULL default '0',
`n_hours_month` int(11) default NULL,
`month` tinyint(4) default NULL,
`year` smallint(6) default NULL,
`nair` tinyint(4) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`fleet_nair_stat_id`),
KEY `fleet_id_FK` (`fleet_id_FK`),
CONSTRAINT `fleet_VIII` FOREIGN KEY (`fleet_id_FK`) REFERENCES `tbl_fleet` (`fleet_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_flight_events`
--
DROP TABLE IF EXISTS `tbl_flight_events`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_flight_events` (
`flight_events_id` int(11) NOT NULL auto_increment,
`logbook_id_FK` int(11) NOT NULL default '0',
`event_id_FK` char(3) NOT NULL default '',
`time_line` varchar(5) default NULL,
`FltFase` char(3) default NULL,
`efective_value` int(3) default NULL,
`act_evt_value` varchar(80) default NULL,
`ref_evt_value` varchar(80) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`flight_events_id`),
KEY `logbook_event` (`logbook_id_FK`,`event_id_FK`),
KEY `event` (`event_id_FK`),
CONSTRAINT `event` FOREIGN KEY (`event_id_FK`) REFERENCES `tbl_taplog_events` (`event_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `logbook` FOREIGN KEY (`logbook_id_FK`) REFERENCES `tbl_logbook` (`logbook_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_flight_events_stat`
--
DROP TABLE IF EXISTS `tbl_flight_events_stat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_flight_events_stat` (
`flight_events_stat_id` int(11) NOT NULL auto_increment,
`logbook_stat_id_FK` int(11) NOT NULL default '0',
`event_id_FK` char(3) NOT NULL default '',
`flight_events_id_FK` int(11) default NULL,
`time_line` varchar(5) default NULL,
`FltFase` char(3) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
`logbook_id_FK_FK` int(11) NOT NULL default '0',
PRIMARY KEY (`flight_events_stat_id`),
KEY `logbook_event` (`logbook_stat_id_FK`,`event_id_FK`),
KEY `flight_events_id_FK` (`flight_events_id_FK`),
KEY `event_II` (`event_id_FK`),
CONSTRAINT `event_II` FOREIGN KEY (`event_id_FK`) REFERENCES `tbl_taplog_events` (`event_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `logbook_II` FOREIGN KEY (`logbook_stat_id_FK`) REFERENCES `tbl_logbook_stat` (`logbook_stat_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_flight_profile`
--
DROP TABLE IF EXISTS `tbl_flight_profile`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_flight_profile` (
`flight_path_id` int(11) NOT NULL auto_increment,
`request_id_FK` int(11) default NULL,
`logbook_stat_id_FK` int(11) default NULL,
`logbook_id_FK` int(11) NOT NULL default '0',
`time_line` varchar(5) default NULL,
`latitude` double default NULL,
`longitude` double default NULL,
`altitude` int(7) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`flight_path_id`),
KEY `request_id_FK` (`request_id_FK`),
KEY `logbook_id_Fk` (`logbook_id_FK`),
KEY `logbook_stat_id_FK` (`logbook_stat_id_FK`),
CONSTRAINT `logbook_stat_id` FOREIGN KEY (`logbook_stat_id_FK`) REFERENCES `tbl_logbook_stat` (`logbook_stat_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT `request_ID_II` FOREIGN KEY (`request_id_FK`) REFERENCES `tbl_requests` (`request_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_fos_parameters`
--
DROP TABLE IF EXISTS `tbl_fos_parameters`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_fos_parameters` (
`parameter_id` varchar(10) NOT NULL default '',
`parameter_desc` varchar(50) default NULL,
`parameter_value` varchar(150) default NULL,
`parameter_desc_help` varchar(200) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`parameter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_hangar`
--
DROP TABLE IF EXISTS `tbl_hangar`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_hangar` (
`aircraft_registration` varchar(8) NOT NULL default '',
`air_type_ID` varchar(5) NOT NULL default '',
`TOP_aircraft_desc` varchar(11) default NULL,
`aircraft_name` varchar(50) default NULL,
`aircraft_selcal` varchar(10) default NULL,
`aircraft_flight_hours` varchar(10) default NULL,
`aircraft_cycles` int(11) default NULL,
`aircraft_active` tinyint(1) default NULL,
`icao` varchar(5) default NULL,
`lst_date_flight` date default NULL,
`state` char(3) default NULL,
`altitude` int(7) default NULL,
`latitude` double default NULL,
`longitude` double default NULL,
`Heading` int(3) default NULL,
`pilot_flying` varchar(7) default NULL,
`lst_codflight` varchar(7) default NULL,
`lst_date_location_change` datetime default NULL,
`p_fob` int(6) default NULL,
`m_zfw` int(6) default NULL,
`m_lw` int(6) default NULL,
`m_tow` int(6) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`aircraft_registration`),
KEY `air_type_id` (`air_type_ID`),
KEY `icao` (`icao`),
KEY `indx_top_aircraft_desc` (`TOP_aircraft_desc`),
CONSTRAINT `Air_type` FOREIGN KEY (`air_type_ID`) REFERENCES `tbl_aircraft_type` (`air_type_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `Icao` FOREIGN KEY (`icao`) REFERENCES `tbl_iata_icao` (`icao`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `TOP_aircraft_id` FOREIGN KEY (`TOP_aircraft_desc`) REFERENCES `tbl_top_aircraft_type` (`aircraft_type_TOP_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_iata_icao`
--
DROP TABLE IF EXISTS `tbl_iata_icao`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_iata_icao` (
`icao` varchar(5) NOT NULL default '',
`lat` double default NULL,
`lon` double default NULL,
`alt` int(11) default NULL,
`name` varchar(40) default NULL,
`iata` varchar(4) NOT NULL default '',
`hub_type` char(1) default NULL,
`pref_gates` varchar(50) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`icao`),
KEY `iata` (`iata`),
KEY `hub_type` (`hub_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_iata_icao_has_tbl_fleet`
--
DROP TABLE IF EXISTS `tbl_iata_icao_has_tbl_fleet`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_iata_icao_has_tbl_fleet` (
`ID` int(11) NOT NULL auto_increment,
`icao_FK` varchar(5) default NULL,
`fleet_id_FK` int(11) default '0',
`n_aircrafts` int(11) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `indx_icao_fleet` (`icao_FK`,`fleet_id_FK`),
KEY `fleet_VII` (`fleet_id_FK`),
CONSTRAINT `fleet_VII` FOREIGN KEY (`fleet_id_FK`) REFERENCES `tbl_fleet` (`fleet_id`) ON DELETE NO ACTION ON UPDATE SET NULL,
CONSTRAINT `icao_hub` FOREIGN KEY (`icao_FK`) REFERENCES `tbl_iata_icao` (`icao`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_icao_rwy`
--
DROP TABLE IF EXISTS `tbl_icao_rwy`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_icao_rwy` (
`rwy_id` int(11) NOT NULL auto_increment,
`icao_FK` varchar(5) NOT NULL default '',
`rwy_ident` char(3) default NULL,
`true_hdg` float(9,2) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`rwy_id`),
KEY `indx_icao_FK` (`icao_FK`),
CONSTRAINT `icao_rwy` FOREIGN KEY (`icao_FK`) REFERENCES `tbl_iata_icao` (`icao`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_incident`
--
DROP TABLE IF EXISTS `tbl_incident`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_incident` (
`incident_id` int(11) NOT NULL auto_increment,
`callsign` varchar(7) default NULL,
`fst_lst_name` varchar(35) default NULL,
`description` text,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`incident_id`),
KEY `callsign` (`callsign`),
CONSTRAINT `users_callsign / incident_callsign` FOREIGN KEY (`callsign`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_logbook`
--
DROP TABLE IF EXISTS `tbl_logbook`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_logbook` (
`logbook_id` int(11) NOT NULL auto_increment,
`callsign` varchar(7) default NULL,
`codflight` varchar(7) default NULL,
`data` date default NULL,
`Departure` varchar(4) default NULL,
`Arrival` varchar(4) default NULL,
`block` varchar(10) default NULL,
`aircraft` varchar(6) default NULL,
`flight_plan_short_form` text,
`air_type` char(3) default NULL,
`comments` text,
`rating` int(9) default NULL,
`ep` int(6) default NULL,
`aproved` tinyint(1) default NULL,
`comments_to_pilot` text,
`cpu_id` varchar(70) default NULL,
`mb_id` varchar(70) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
`geo_ip` varchar(25) default NULL,
`geo_CountryName` varchar(25) default NULL,
`geo_RegionName` varchar(25) default NULL,
`geo_city` varchar(25) default NULL,
`geo_latitude` varchar(25) default NULL,
`geo_longitude` varchar(25) default NULL,
PRIMARY KEY (`logbook_id`),
KEY `callsign` (`callsign`),
CONSTRAINT `callsign_III` FOREIGN KEY (`callsign`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_logbook_stat`
--
DROP TABLE IF EXISTS `tbl_logbook_stat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_logbook_stat` (
`logbook_stat_id` int(11) NOT NULL auto_increment,
`logbook_id_FK` int(11) NOT NULL default '0',
`callsign` varchar(7) default NULL,
`pilot_name` varchar(30) default NULL,
`codflight` varchar(7) default NULL,
`data` date default NULL,
`Departure` varchar(4) default NULL,
`Arrival` varchar(4) default NULL,
`flight_plan_short_form` text,
`block` varchar(10) default NULL,
`aircraft` varchar(6) default NULL,
`air_type` char(3) default NULL,
`rating` int(9) default NULL,
`ep` int(6) default NULL,
`aproved` tinyint(1) default NULL,
`cpu_id` varchar(70) default NULL,
`mb_id` varchar(70) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
`geo_ip` varchar(25) default NULL,
`geo_CountryName` varchar(25) default NULL,
`geo_RegionName` varchar(25) default NULL,
`geo_city` varchar(25) default NULL,
`geo_latitude` varchar(25) default NULL,
`geo_longitude` varchar(25) default NULL,
PRIMARY KEY (`logbook_stat_id`),
KEY `callsign` (`callsign`),
KEY `aircraft_reg` (`aircraft`),
KEY `logbook_id_FK` (`logbook_id_FK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_man_flight`
--
DROP TABLE IF EXISTS `tbl_man_flight`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_man_flight` (
`man_flight_id` int(11) NOT NULL auto_increment,
`callsign_FK` varchar(7) NOT NULL default '',
`codflight` varchar(7) default NULL,
`ICAO_ori` varchar(4) default NULL,
`ICAO_dest` varchar(4) default NULL,
`flight_date` date default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`man_flight_id`),
KEY `callsign_FK` (`callsign_FK`),
CONSTRAINT `callsign_VIII` FOREIGN KEY (`callsign_FK`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_merchandise`
--
DROP TABLE IF EXISTS `tbl_merchandise`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_merchandise` (
`merchadise_id` int(11) NOT NULL auto_increment,
`callsign_FK` varchar(7) NOT NULL default '',
`air_type_ID_FK` varchar(5) NOT NULL default '',
`air_price` varchar(6) NOT NULL default '',
`air_avlb` tinyint(1) default NULL,
`dte_avlb` date default NULL,
`air_buy` tinyint(1) default NULL,
`dte_buy` date default NULL,
`document_file` varchar(50) default NULL,
`invoice_file` varchar(50) default NULL,
`air_cancel` tinyint(1) default NULL,
`dte_cancel` date default NULL,
`cancel_file` varchar(50) default NULL,
`air_send` tinyint(1) default NULL,
`dte_send` date default NULL,
`air_received` tinyint(1) default NULL,
`dte_received` date default NULL,
`merch_value_paid` float(9,3) default NULL,
`lst_user_change` varchar(7) NOT NULL default '',
`lst_dte_change` date NOT NULL default '0000-00-00',
PRIMARY KEY (`merchadise_id`),
KEY `indx_callsign_FK` (`callsign_FK`),
KEY `indx_air_type_ID_FK` (`air_type_ID_FK`),
CONSTRAINT `air_type_III` FOREIGN KEY (`air_type_ID_FK`) REFERENCES `tbl_aircraft_type` (`air_type_ID`) ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT `callsign_IX` FOREIGN KEY (`callsign_FK`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_notam_notification`
--
DROP TABLE IF EXISTS `tbl_notam_notification`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_notam_notification` (
`not_notf_id` int(11) NOT NULL auto_increment,
`subject` varchar(100) default NULL,
`description` text,
`type` tinyint(1) default NULL,
`sender` varchar(7) default NULL,
`destination_notm_type` varchar(20) default NULL,
`send` tinyint(1) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`not_notf_id`),
KEY `sender` (`sender`),
CONSTRAINT `sender/callsign` FOREIGN KEY (`sender`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_qualification`
--
DROP TABLE IF EXISTS `tbl_qualification`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_qualification` (
`qualification_id` int(2) NOT NULL auto_increment,
`description` varchar(30) default NULL,
`qualification_image` varchar(30) default NULL,
`qualification_type` int(1) default NULL,
`valid_period_months` int(2) default NULL,
`qlf_active` tinyint(1) default NULL,
`exam_id_FK` int(11) default NULL,
`exam_id_FK_cnd` int(11) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`qualification_id`),
KEY `qualification_type` (`qualification_type`),
KEY `exam_id_FK` (`exam_id_FK`),
KEY `exam_id_FK_cnd` (`exam_id_FK_cnd`),
CONSTRAINT `exam_candidate` FOREIGN KEY (`exam_id_FK_cnd`) REFERENCES `tbl_exams` (`exam_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `exam_id` FOREIGN KEY (`exam_id_FK`) REFERENCES `tbl_exams` (`exam_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_qualification_has_tbl_fleet`
--
DROP TABLE IF EXISTS `tbl_qualification_has_tbl_fleet`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_qualification_has_tbl_fleet` (
`ID` int(11) NOT NULL auto_increment,
`qualification_id_FK` int(2) default '0',
`fleet_id_FK` int(11) default '0',
`lst_user_change` varchar(7) default NULL,
`Recruitment` tinyint(1) default NULL,
`credit` int(11) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `indx_qualification_fleet` (`qualification_id_FK`,`fleet_id_FK`),
KEY `fleet_IV` (`fleet_id_FK`),
CONSTRAINT `fleet_IV` FOREIGN KEY (`fleet_id_FK`) REFERENCES `tbl_fleet` (`fleet_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `qualification_VIII` FOREIGN KEY (`qualification_id_FK`) REFERENCES `tbl_qualification` (`qualification_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_qualification_has_tbl_iata_icao`
--
DROP TABLE IF EXISTS `tbl_qualification_has_tbl_iata_icao`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_qualification_has_tbl_iata_icao` (
`ID` int(11) NOT NULL auto_increment,
`qualification_id_FK` int(2) default '0',
`icao_dest_FK` varchar(5) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `indx_qualification_icao` (`qualification_id_FK`,`icao_dest_FK`),
KEY `icao_dest` (`icao_dest_FK`),
CONSTRAINT `icao_dest` FOREIGN KEY (`icao_dest_FK`) REFERENCES `tbl_iata_icao` (`icao`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `qualification_III` FOREIGN KEY (`qualification_id_FK`) REFERENCES `tbl_qualification` (`qualification_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_qualification_has_tbl_rank`
--
DROP TABLE IF EXISTS `tbl_qualification_has_tbl_rank`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_qualification_has_tbl_rank` (
`ID` int(11) NOT NULL auto_increment,
`qualification_id_FK` int(2) default '0',
`rank_id_FK` int(2) default '0',
`EP` int(4) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `indx_qualification_rank` (`qualification_id_FK`,`rank_id_FK`),
KEY `rank_II` (`rank_id_FK`),
CONSTRAINT `qualfication` FOREIGN KEY (`qualification_id_FK`) REFERENCES `tbl_qualification` (`qualification_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `rank_II` FOREIGN KEY (`rank_id_FK`) REFERENCES `tbl_rank` (`rank_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_qualification_has_tbl_rank_promotions`
--
DROP TABLE IF EXISTS `tbl_qualification_has_tbl_rank_promotions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_qualification_has_tbl_rank_promotions` (
`ID` int(11) NOT NULL auto_increment,
`qualification_id_FK` int(2) default '0',
`rank_id_FK` int(2) default '0',
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `indx_qualification_rank` (`qualification_id_FK`,`rank_id_FK`),
KEY `rank_III` (`rank_id_FK`),
CONSTRAINT `qualification_VI` FOREIGN KEY (`qualification_id_FK`) REFERENCES `tbl_qualification` (`qualification_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `rank_III` FOREIGN KEY (`rank_id_FK`) REFERENCES `tbl_rank` (`rank_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_rank`
--
DROP TABLE IF EXISTS `tbl_rank`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_rank` (
`rank_id` int(2) NOT NULL auto_increment,
`description` varchar(30) default NULL,
`rank_image` varchar(30) default NULL,
`ntype_rating_promotion` int(2) default NULL,
`flying_hours_promotion` int(11) default NULL,
`EP_promotion` int(3) default NULL,
`exam_id_FK` int(11) default NULL,
`M_assign` int(11) default NULL,
`rank_order` int(2) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`rank_id`),
UNIQUE KEY `rank_order` (`rank_order`),
KEY `exam_id_FK` (`exam_id_FK`),
CONSTRAINT `exam_id_III` FOREIGN KEY (`exam_id_FK`) REFERENCES `tbl_exams` (`exam_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_recruitment_competition`
--
DROP TABLE IF EXISTS `tbl_recruitment_competition`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_recruitment_competition` (
`recruitment_id` int(11) NOT NULL auto_increment,
`dta_ini` date default NULL,
`dta_end` date default NULL,
`status` tinyint(1) default NULL,
`r_type` char(1) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`recruitment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_recruitment_details`
--
DROP TABLE IF EXISTS `tbl_recruitment_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_recruitment_details` (
`detail_id` int(11) NOT NULL auto_increment,
`recruitment_id_FK` int(11) NOT NULL default '0',
`fleet_id_FK` int(11) NOT NULL default '0',
`vacances` int(11) default NULL,
`tot_vacances` int(11) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`detail_id`),
UNIQUE KEY `indx_details` (`recruitment_id_FK`,`fleet_id_FK`),
KEY `recruitment` (`fleet_id_FK`),
CONSTRAINT `competition` FOREIGN KEY (`recruitment_id_FK`) REFERENCES `tbl_recruitment_competition` (`recruitment_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT `recruitment` FOREIGN KEY (`fleet_id_FK`) REFERENCES `tbl_fleet` (`fleet_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_requests`
--
DROP TABLE IF EXISTS `tbl_requests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_requests` (
`request_id` int(11) NOT NULL auto_increment,
`callsign_FK_from` varchar(7) NOT NULL default '',
`EP` varchar(6) default NULL,
`qualification_id_FK` int(2) default NULL,
`qualification_type` int(1) default NULL,
`rank_id_FK` int(2) default NULL,
`accept_declained` int(1) default NULL,
`accept_date` date default NULL,
`callsign_FK_by` varchar(7) default NULL,
`exame_start_date` datetime default NULL,
`exam_end_date` datetime default NULL,
`exam_final_rating` int(3) default NULL,
`exam_pos_neg` char(1) default NULL,
`air_type_ID_FK` varchar(5) default NULL,
`requirement_eval` int(2) default NULL,
`simulator_date` date default NULL,
`exam_pratical_final_rating` int(3) default NULL,
`exam_pratical_pos_neg` char(1) default NULL,
`final_aprove` tinyint(1) default NULL,
`icao_origem_FK` varchar(5) default NULL,
`icao_destino_FK` varchar(5) default NULL,
`failure` int(2) default NULL,
`failure_aft_time` varchar(5) default NULL,
`wind_speed` int(3) default NULL,
`wind_hdg` int(3) default NULL,
`wind_dep` int(1) default NULL,
`wind_arr` int(1) default NULL,
`visibility` int(2) default NULL,
`visibility_dep` int(1) default NULL,
`visibility_arr` int(1) default NULL,
`precipitation` int(2) default NULL,
`precipitation_dep` int(1) default NULL,
`precipitation_arr` int(1) default NULL,
`turbulence` int(2) default NULL,
`turbulence_dep` int(1) default NULL,
`turbulence_arr` int(1) default NULL,
`recruitment_id` int(11) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`request_id`),
KEY `callsign_FK_from` (`callsign_FK_from`),
KEY `qualification_id_FK` (`qualification_id_FK`),
KEY `rank_id_FK` (`rank_id_FK`),
KEY `callsign_FK_by` (`callsign_FK_by`),
KEY `icao_origem_FK` (`icao_origem_FK`),
KEY `icao_destino_FK` (`icao_destino_FK`),
KEY `recruitmant_id` (`recruitment_id`),
KEY `Air_type_II` (`air_type_ID_FK`),
CONSTRAINT `Air_type_II` FOREIGN KEY (`air_type_ID_FK`) REFERENCES `tbl_aircraft_type` (`air_type_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `callsign_IV` FOREIGN KEY (`callsign_FK_by`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT `callsign_V` FOREIGN KEY (`callsign_FK_from`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT `icao_dest_II` FOREIGN KEY (`icao_destino_FK`) REFERENCES `tbl_iata_icao` (`icao`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `icao_origem` FOREIGN KEY (`icao_origem_FK`) REFERENCES `tbl_iata_icao` (`icao`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `qualification_VII` FOREIGN KEY (`qualification_id_FK`) REFERENCES `tbl_qualification` (`qualification_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `rank_IV` FOREIGN KEY (`rank_id_FK`) REFERENCES `tbl_rank` (`rank_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_requests_flight_events`
--
DROP TABLE IF EXISTS `tbl_requests_flight_events`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_requests_flight_events` (
`requests_flight_events_ID` int(11) NOT NULL auto_increment,
`request_id_FK` int(11) NOT NULL default '0',
`event_id_FK` char(3) NOT NULL default '',
`time_line` varchar(5) default NULL,
`FltFase` char(3) default NULL,
`efective_value` int(3) default NULL,
`act_evt_value` varchar(80) default NULL,
`ref_evt_value` varchar(80) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`requests_flight_events_ID`),
KEY `request_event` (`request_id_FK`,`event_id_FK`),
KEY `flight_event` (`event_id_FK`),
CONSTRAINT `flight_event` FOREIGN KEY (`event_id_FK`) REFERENCES `tbl_taplog_events` (`event_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `request_event` FOREIGN KEY (`request_id_FK`) REFERENCES `tbl_requests` (`request_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_svr_pymnt`
--
DROP TABLE IF EXISTS `tbl_svr_pymnt`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_svr_pymnt` (
`pay_id` int(11) NOT NULL auto_increment,
`callsign_FK` varchar(7) default NULL,
`year` varchar(4) default NULL,
`month` char(2) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`pay_id`),
UNIQUE KEY `ind_pymnt` (`callsign_FK`,`year`,`month`),
KEY `callsign` (`callsign_FK`),
CONSTRAINT `callsign_VI` FOREIGN KEY (`callsign_FK`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_tap_OFP`
--
DROP TABLE IF EXISTS `tbl_tap_OFP`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_tap_OFP` (
`OFP_id` varchar(40) NOT NULL default '',
`codflight` varchar(8) default NULL,
`ICAO_ori` varchar(4) default NULL,
`ICAO_dest` varchar(4) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` datetime default NULL,
PRIMARY KEY (`OFP_id`),
KEY `codflight` (`codflight`,`ICAO_ori`,`ICAO_dest`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_taplog_events`
--
DROP TABLE IF EXISTS `tbl_taplog_events`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_taplog_events` (
`event_id` char(3) NOT NULL default '',
`description` varchar(50) default '',
`active` tinyint(1) default NULL,
`value` int(3) default NULL,
`lst_user_change` varchar(7) default '',
`lst_dte_change` date default NULL,
PRIMARY KEY (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_timetable`
--
DROP TABLE IF EXISTS `tbl_timetable`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_timetable` (
`id` int(6) NOT NULL default '0',
`codflight` varchar(7) default NULL,
`initdate` date default NULL,
`enddate` date default NULL,
`weekdays` varchar(8) default NULL,
`equip` varchar(4) default NULL,
`departure_time` varchar(5) default NULL,
`IATA_ori` varchar(11) default NULL,
`IATA_dest` varchar(11) default NULL,
`arrival_time` varchar(5) default NULL,
`block` varchar(5) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`id`),
KEY `IATA_ori` (`IATA_ori`),
KEY `IATA_dest` (`IATA_dest`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_top_aircraft_type`
--
DROP TABLE IF EXISTS `tbl_top_aircraft_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_top_aircraft_type` (
`aircraft_type_TOP_id` varchar(11) NOT NULL default '',
`engine_type` varchar(20) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`aircraft_type_TOP_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_top_delta_header`
--
DROP TABLE IF EXISTS `tbl_top_delta_header`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_top_delta_header` (
`delta_header_id` int(11) NOT NULL auto_increment,
`exit_id_FK` int(11) NOT NULL default '0',
`aircraft_desc` varchar(10) default NULL,
`tref` int(2) default NULL,
`tmax` int(2) default NULL,
`rwy_cond` varchar(10) default NULL,
`dqnh` int(3) default NULL,
`conf` varchar(10) default NULL,
`wind_1` int(3) default '-10',
`dgw_1` float(5,1) default NULL,
`dflx_1` int(2) default NULL,
`dv1_1` int(2) default NULL,
`dvr_1` int(2) default NULL,
`dv2_1` int(2) default NULL,
`tvmc_1` int(2) default NULL,
`dgw2_1` float(5,1) default NULL,
`dflx2_1` int(2) default NULL,
`dv1_2_1` int(2) default NULL,
`dvr2_1` int(2) default NULL,
`dv2_2_1` int(2) default NULL,
`wind_2` int(3) default '0',
`dgw_2` float(5,1) default NULL,
`dflx_2` int(2) default NULL,
`dv1_2` int(2) default NULL,
`dvr_2` int(2) default NULL,
`dv2_2` int(2) default NULL,
`tvmc_2` int(2) default NULL,
`dgw2_2` float(5,1) default NULL,
`dflx2_2` int(2) default NULL,
`dv1_2_2` int(2) default NULL,
`dvr2_2` int(2) default NULL,
`dv2_2_2` int(2) default NULL,
`wind_3` int(3) default '10',
`dgw_3` float(5,1) default NULL,
`dflx_3` int(2) default NULL,
`dv1_3` int(2) default NULL,
`dvr_3` int(2) default NULL,
`dv2_3` int(2) default NULL,
`tvmc_3` int(2) default NULL,
`dgw2_3` float(5,1) default NULL,
`dflx2_3` int(2) default NULL,
`dv1_2_3` int(2) default NULL,
`dvr2_3` int(2) default NULL,
`dv2_2_3` int(2) default NULL,
`conf_2` varchar(10) default NULL,
`wind_4` int(3) default '-10',
`dgw_4` float(5,1) default NULL,
`dflx_4` int(2) default NULL,
`dv1_4` int(2) default NULL,
`dvr_4` int(2) default NULL,
`dv2_4` int(2) default NULL,
`tvmc_4` int(2) default NULL,
`dgw2_4` float(5,1) default NULL,
`dflx2_4` int(2) default NULL,
`dv1_2_4` int(2) default NULL,
`dvr2_4` int(2) default NULL,
`dv2_2_4` int(2) default NULL,
`wind_5` int(3) default '0',
`dgw_5` float(5,1) default NULL,
`dflx_5` int(2) default NULL,
`dv1_5` int(2) default NULL,
`dvr_5` int(2) default NULL,
`dv2_5` int(2) default NULL,
`tvmc_5` int(2) default NULL,
`dgw2_5` float(5,1) default NULL,
`dflx2_5` int(2) default NULL,
`dv1_2_5` int(2) default NULL,
`dvr2_5` int(2) default NULL,
`dv2_2_5` int(2) default NULL,
`wind_6` int(3) default '10',
`dgw_6` float(5,1) default NULL,
`dflx_6` int(2) default NULL,
`dv1_6` int(2) default NULL,
`dvr_6` int(2) default NULL,
`dv2_6` int(2) default NULL,
`tvmc_6` int(2) default NULL,
`dgw2_6` float(5,1) default NULL,
`dflx2_6` int(2) default NULL,
`dv1_2_6` int(2) default NULL,
`dvr2_6` int(2) default NULL,
`dv2_2_6` int(2) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`delta_header_id`),
KEY `indx_exit_id_FK` (`exit_id_FK`),
KEY `indx_aircraft_desc` (`aircraft_desc`),
CONSTRAINT `exit_II` FOREIGN KEY (`exit_id_FK`) REFERENCES `tbl_top_exits` (`exit_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_top_exits`
--
DROP TABLE IF EXISTS `tbl_top_exits`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_top_exits` (
`exit_id` int(11) NOT NULL auto_increment,
`rwy_id_FK` int(11) NOT NULL default '0',
`exit_desc` varchar(50) default NULL,
`to_shift` int(11) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`exit_id`),
KEY `indx_rwy_id_FK` (`rwy_id_FK`),
CONSTRAINT `exit` FOREIGN KEY (`rwy_id_FK`) REFERENCES `tbl_icao_rwy` (`rwy_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_top_qnh_alt`
--
DROP TABLE IF EXISTS `tbl_top_qnh_alt`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_top_qnh_alt` (
`id` int(11) NOT NULL auto_increment,
`aircraft_type_TOP_id_FK` varchar(11) NOT NULL default '',
`qnh` int(5) default NULL,
`alt_corr` int(5) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`id`),
KEY `indx_aircraft_type_TOP_id_FK` (`aircraft_type_TOP_id_FK`),
CONSTRAINT `TOP_aircraft_id_II` FOREIGN KEY (`aircraft_type_TOP_id_FK`) REFERENCES `tbl_top_aircraft_type` (`aircraft_type_TOP_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_top_ref_speed`
--
DROP TABLE IF EXISTS `tbl_top_ref_speed`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_top_ref_speed` (
`ref_speed_id` int(11) NOT NULL auto_increment,
`delta_header_id_FK` int(11) NOT NULL default '0',
`oat` int(2) default NULL,
`gw_1` float(5,1) default NULL,
`gw_2` float(5,1) default NULL,
`gw_3` float(5,1) default NULL,
`gw_4` float(5,1) default NULL,
`gw_5` float(5,1) default NULL,
`gw_6` float(5,1) default NULL,
`v1_1` int(3) default NULL,
`vr_1` int(3) default NULL,
`v2_1` int(2) default NULL,
`v1_2` int(2) default NULL,
`vr_2` int(2) default NULL,
`v2_2` int(2) default NULL,
`v1_3` int(2) default NULL,
`vr_3` int(2) default NULL,
`v2_3` int(2) default NULL,
`v1_4` int(2) default NULL,
`vr_4` int(2) default NULL,
`v2_4` int(2) default NULL,
`v1_5` int(2) default NULL,
`vr_5` int(2) default NULL,
`v2_5` int(2) default NULL,
`v1_6` int(2) default NULL,
`vr_6` int(2) default NULL,
`v2_6` int(2) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date NOT NULL default '0000-00-00',
PRIMARY KEY (`ref_speed_id`),
KEY `indx_delta_header_id_FK` (`delta_header_id_FK`),
CONSTRAINT `speed` FOREIGN KEY (`delta_header_id_FK`) REFERENCES `tbl_top_delta_header` (`delta_header_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_user_doc`
--
DROP TABLE IF EXISTS `tbl_user_doc`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_user_doc` (
`user_doc` int(11) NOT NULL auto_increment,
`callsign_FK` varchar(7) NOT NULL default '',
`doc_desc` varchar(50) default NULL,
`document` mediumblob,
`file_name` varchar(50) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`user_doc`),
KEY `callsign_FK` (`callsign_FK`),
CONSTRAINT `callsign_X` FOREIGN KEY (`callsign_FK`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_users`
--
DROP TABLE IF EXISTS `tbl_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_users` (
`callsign` varchar(7) NOT NULL default '',
`pass` varchar(10) default NULL,
`rank_id` int(2) default NULL,
`fst_name` varchar(15) default NULL,
`lst_name` varchar(15) default NULL,
`birth_dte` date default NULL,
`email` varchar(50) default NULL,
`address` varchar(50) default NULL,
`zip_code` varchar(50) default NULL,
`city` varchar(30) default NULL,
`country_id` char(3) default NULL,
`NIF` varchar(12) default NULL,
`iban_bank` varchar(50) default NULL,
`iban` varchar(33) default NULL,
`phone` varchar(15) default NULL,
`admission_dte` date default NULL,
`IVAO_id` varchar(10) default NULL,
`VATSIM_id` varchar(10) default NULL,
`vic_id` varchar(10) default NULL,
`share_logbook` int(1) default NULL,
`Comments` varchar(200) default NULL,
`flight_hours` varchar(10) default NULL,
`loged_hours` varchar(10) default NULL,
`lst_flight_dte` date default NULL,
`cur_location` varchar(11) default NULL,
`vic_miles` float(9,2) default NULL,
`ep` int(11) default NULL,
`overall_efficiency` int(3) default NULL,
`type_id` char(2) default NULL,
`user_suspended` int(11) default NULL,
`aircraft_registration_FK` varchar(8) default NULL,
`air_type_id_FK` varchar(8) default NULL,
`codflight` varchar(7) default NULL,
`ICAO_ori` varchar(4) default NULL,
`ICAO_dest` varchar(4) default NULL,
`ICAO_alt_1` varchar(4) default NULL,
`ICAO_alt_2` varchar(4) default NULL,
`ICAO_alt_3` varchar(4) default NULL,
`ICAO_alt_4` varchar(4) default NULL,
`ICAO_alt_5` varchar(4) default NULL,
`ICAO_alt_6` varchar(4) default NULL,
`ICAO_alt_7` varchar(4) default NULL,
`ICAO_alt_8` varchar(4) default NULL,
`ICAO_alt_9` varchar(4) default NULL,
`ICAO_alt_10` varchar(50) default NULL,
`p_fob` int(6) default NULL,
`m_zfw` int(6) default NULL,
`m_lw` int(6) default NULL,
`m_tow` int(6) default NULL,
`departure_UTC` varchar(5) default NULL,
`flight_plan_file` varchar(40) default NULL,
`flight_plan_short_form` text,
`flight_type` char(1) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`callsign`),
UNIQUE KEY `vic_id` (`vic_id`),
KEY `country_id` (`country_id`),
KEY `rank_id` (`rank_id`),
KEY `type_id` (`type_id`),
KEY `aircraft_registration_FK` (`aircraft_registration_FK`),
KEY `air_type_id_FK` (`air_type_id_FK`),
CONSTRAINT `Country` FOREIGN KEY (`country_id`) REFERENCES `tbl_country` (`country_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `rank` FOREIGN KEY (`rank_id`) REFERENCES `tbl_rank` (`rank_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT `type` FOREIGN KEY (`type_id`) REFERENCES `tbl_company_status` (`type_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_users_has_tbl_qualification`
--
DROP TABLE IF EXISTS `tbl_users_has_tbl_qualification`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_users_has_tbl_qualification` (
`ID` int(11) NOT NULL auto_increment,
`callsign_FK` varchar(7) default NULL,
`qualification_id_FK` int(2) default NULL,
`start_dte` date default NULL,
`end_dte` date default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `indx_callsign_qualification` (`callsign_FK`,`qualification_id_FK`),
KEY `qualification_IV` (`qualification_id_FK`),
CONSTRAINT `callsign` FOREIGN KEY (`callsign_FK`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT `qualification_IV` FOREIGN KEY (`qualification_id_FK`) REFERENCES `tbl_qualification` (`qualification_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_vacation`
--
DROP TABLE IF EXISTS `tbl_vacation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_vacation` (
`vacation_id` int(11) NOT NULL auto_increment,
`callsign_FK` varchar(7) NOT NULL default '',
`vacation_date` date NOT NULL default '0000-00-00',
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`vacation_id`),
UNIQUE KEY `callsign_date` (`callsign_FK`,`vacation_date`),
CONSTRAINT `vacation` FOREIGN KEY (`callsign_FK`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_vic_miles`
--
DROP TABLE IF EXISTS `tbl_vic_miles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_vic_miles` (
`rec_id` int(11) NOT NULL auto_increment,
`callsign_FK` varchar(7) default NULL,
`vic_id` varchar(10) default NULL,
`miles` int(11) default NULL,
`remaider` float(9,2) default NULL,
`date` date default NULL,
`transfer` tinyint(1) default NULL,
`file` varchar(19) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`rec_id`),
KEY `callsign_FK` (`callsign_FK`),
CONSTRAINT `callsign_VII` FOREIGN KEY (`callsign_FK`) REFERENCES `tbl_users` (`callsign`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tbl_vic_seq`
--
DROP TABLE IF EXISTS `tbl_vic_seq`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_vic_seq` (
`vic_seq_id` int(11) NOT NULL auto_increment,
`filename` varchar(19) default NULL,
`filename_ret` varchar(19) default NULL,
`vic_seq` int(11) default NULL,
`lst_user_change` varchar(7) default NULL,
`lst_dte_change` date default NULL,
PRIMARY KEY (`vic_seq_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2017-11-14 11:21:17
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment