/*
SQLyog Ultimate v13.1.1 (64 bit)
MySQL - 10.4.10-MariaDB : Database - jacob
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`jacob` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `jacob`;

/*Data for the table `finan_fatura` */

/*Data for the table `finan_fatura_itens` */

/*Data for the table `global_grauinstrucao` */

insert  into `global_grauinstrucao`(`id_grauinstrucao`,`descricao_grauinstrucao`,`sefip_grauinstrucao`,`caged_grauinstrucao`,`rais_grauinstrucao`,`idstatus_grauinstrucao`,`criacao_grauinstrucao`,`idcriacao_grauinstrucao`,`modificacao_grauinstrucao`,`idmodificacao_grauinstrucao`,`delete_grauinstrucao`,`iddelete_grauinstrucao`) values 
(1,'ANALFABETO','1','1','1',1,'2020-03-19 00:49:41',NULL,'2020-10-04 03:36:41',NULL,0,NULL),
(2,'PRIMARIO','02','02','2',1,'2020-10-04 03:29:05',NULL,'2020-10-04 03:37:16',NULL,0,NULL),
(3,'FUNDAMENTAL','03','03','3',1,'2020-10-04 03:37:49',NULL,'2020-10-04 03:37:49',NULL,0,NULL),
(4,'FUNDAMENTAL INCOMPLETO','04','04','4',1,'2020-10-04 03:38:40',NULL,'2020-10-04 03:38:40',NULL,0,NULL),
(5,'ENSINO MEDIO','05','05','5',1,'2020-10-04 03:40:08',NULL,'2020-10-04 03:40:08',NULL,0,NULL),
(6,'ENSINO MEDIO INCOMPLETO','06','06','6',1,'2020-10-04 03:41:18',NULL,'2020-10-04 03:41:18',NULL,0,NULL),
(7,'SUPERIO','07','07','7',1,'2020-10-04 03:42:07',NULL,'2020-10-04 03:42:07',NULL,0,NULL),
(8,'SUPERIO INCOMPLETO','08','08','8',1,'2020-10-04 03:45:21',NULL,'2020-10-04 03:45:21',NULL,0,NULL),
(9,'POS-GRADUAçãO','09','09','9',1,'2020-10-04 03:45:53',NULL,'2020-10-04 03:45:53',NULL,0,NULL),
(10,'MESTRADO','10','10','10',1,'2020-10-04 03:46:16',NULL,'2020-10-04 03:46:16',NULL,0,NULL),
(11,'DOUTORADO','11','11','11',1,'2020-10-04 03:46:37',NULL,'2020-10-04 03:46:37',NULL,0,NULL),
(12,'PHD','12','12','12',1,'2020-10-04 03:47:01',NULL,'2020-10-04 03:47:01',NULL,0,NULL);

/*Data for the table `global_instituicao` */

insert  into `global_instituicao`(`id_instituicao`,`nome_instituicao`,`cnpj_instituicao`,`inscricaoestadual_instituicao`,`site_instituicao`,`criacao_instituicao`,`idcriacao_instituicao`,`modificacao_instituicao`,`idmodificacao_instituicao`,`delete_instituicao`,`iddelete_instituicao`) values 
(1,'ALCANCE DIGITAL','00000000000000','ISENTO','www.alcancedigital.com.br','2020-03-19 00:44:25',1,'2020-08-29 12:17:42',0,0,NULL);

/*Data for the table `global_modulo` */

insert  into `global_modulo`(`idinstituicao_modulo`,`id_modulo`,`nome_modulo`,`icone_modulo`,`idstatus_modulo`,`ordem_modulo`,`criacao_modulo`,`idcriacao_modulo`,`modificacao_modulo`,`idmodificacao_modulo`,`delete_modulo`,`iddelete_modulo`) values 
(1,5,'OK TESTE','sem',1,9999,'2020-08-28 03:25:24',1,'2020-08-28 03:25:24',NULL,0,NULL),
(1,6,'SISTEMA','zmdi zmdi-flower',1,0,'2020-08-28 03:35:45',1,'2020-10-01 23:11:25',1,0,NULL),
(1,7,'RASTREADORES','zmdi zmdi-swap-alt',1,1,'2020-08-28 03:42:54',1,'2020-10-19 10:59:50',1,0,NULL),
(1,8,'GGGGGGGGGGG','sssss',1,9999,'2020-08-28 03:47:49',1,'2020-08-29 09:14:13',NULL,1,1),
(1,9,'FINANCEIRO','zmdi zmdi-delicious',1,9999,'2020-08-28 03:49:02',1,'2020-11-12 10:48:37',1,0,NULL),
(1,10,'MMMMM','mmm',1,9999,'2020-08-28 14:00:55',1,'2020-08-28 14:00:55',NULL,0,NULL),
(1,11,'GGGG','ggg',1,9999,'2020-08-28 14:03:19',1,'2020-08-28 14:03:19',NULL,0,NULL),
(1,12,'SSSSSS','sss',1,9999,'2020-08-28 14:06:19',1,'2020-08-28 14:06:19',NULL,0,NULL),
(1,13,'YYYYY','yy',1,9999,'2020-08-28 14:09:39',1,'2020-08-28 14:09:39',NULL,0,NULL),
(1,15,'HUDSON DIAS','dias',1,9999,'2020-08-28 15:23:56',1,'2020-08-28 15:26:40',1,0,NULL),
(1,16,'QUEBRA DE PAGINA','testq',1,9999,'2020-08-28 15:45:15',1,'2020-08-28 15:45:15',NULL,0,NULL),
(1,17,'MAIS UM','tessss',1,9999,'2020-08-28 15:46:38',1,'2020-08-28 15:46:38',NULL,0,NULL);

/*Data for the table `global_pessoa` */

insert  into `global_pessoa`(`idinstituicao_pessoa`,`id_pessoa`,`nome_pessoa`,`empresa_pessoa`,`apelido_pessoa`,`cpfcnpj_pessoa`,`fantasia_pessoa`,`inscestatual_pessoa`,`inscmunicipal_pessoa`,`nascimento_pessoa`,`cep_pessoa`,`endereco_pessoa`,`num_pessoa`,`compl_pessoa`,`bairro_pessoa`,`cidade_pessoa`,`uf_pessoa`,`email_pessoa`,`email2_pessoa`,`tele1_pessoa`,`tele2_pessoa`,`estadocivil_pessoa`,`sexo_pessoa`,`nacionalidade_pessoa`,`idgrauinstrucao_pessoa`,`idprofissao_pessoa`,`obs_pessoa`,`idstatus_pessoa`,`criacao_pessoa`,`idcriacao_pessoa`,`modificacao_pessoa`,`idmodificacao_pessoa`,`delete_pessoa`,`iddelete_pessoa`) values 
(1,1,'ADMINISTRADOR','','HUDSON','03707904644','',NULL,NULL,NULL,'31840360','RUA ÁLVARO CAMARGOS SOBRINHO','655','','FLORAMAR','BELO HORIZONTE','MG','hudson@alcancedigital.com.br',NULL,'313434360',NULL,'SOLTEIRO','MASCULINO','BRA',1,1,NULL,1,NULL,NULL,'2020-09-24 00:15:01',NULL,0,NULL),
(1,2,'HUDSON DIAS ALMEIDA','','HUDSON','00000000000','',NULL,NULL,NULL,'31840440','RUA VíTOR GONçALVES','64','','FLORAMAR','BELO HORIZONTE','MG','hudson@alcancedigital.com.br',NULL,'31988060649',NULL,'SOLTEIRO','MASCULINO','BRASILEIRO',1,1,NULL,1,NULL,NULL,'2020-09-28 14:19:56',NULL,0,NULL),
(1,3,'','MAKMOS','','00000000000000','MAKMOS','0000000000000','00000000000000',NULL,'31840440','RUA VíTOR GONçALVES','74','','FLORAMAR','BELO HORIZONTE','MG','hudson@almail.com',NULL,'0000000000',NULL,'','','',NULL,NULL,NULL,1,NULL,NULL,'2020-09-28 16:26:42',NULL,0,NULL),
(1,4,'TESTE HUDSON','','TESTE','00000000000','',NULL,NULL,NULL,'31840360','RUA ÁLVARO CAMARGOS SOBRINHO','655','','FLORAMAR','BELO HORIZONTE','MG','hudson@tes.com',NULL,'3187254668',NULL,'SOLTEIRO','MASCULINO','BRASILEIRO',1,1,'teste hudsoh',1,NULL,NULL,'2020-10-05 13:28:35',NULL,0,NULL),
(1,5,'FERNANDA CRISTINA NUNES PEREIRA','','NANDA','11111111111','',NULL,NULL,NULL,'31840360','RUA ÁLVARO CAMARGOS SOBRINHO','655','','FLORAMAR','BELO HORIZONTE','MG','fernanda@alcancedigital.com.br',NULL,'31333333333',NULL,'CASADO','FEMININO','BRASILEIRA',7,62,NULL,1,NULL,NULL,'2020-10-29 20:22:22',1,0,NULL),
(1,6,'ANGELA DIAS LIMA SILVA','','ANGELA','12345645645','',NULL,NULL,NULL,'31840360','RUA ÁLVARO CAMARGOS SOBRINHO','655','','FLORAMAR','BELO HORIZONTE','MG','angela@alcancedigital.com.br',NULL,'31888908700',NULL,'CASADO','FEMININO','BRASILEIRA',9,211,'Mae linda',1,'2020-10-29 22:55:58',1,'2020-10-29 22:55:58',NULL,0,NULL),
(1,7,'RAIMUNDA DIAS LIMA','','RAIMUNDA','12345645645','',NULL,NULL,NULL,'31840360','RUA ÁLVARO CAMARGOS SOBRINHO','655','','FLORAMAR','BELO HORIZONTE','MG','raimunda@alcancedigital.com.br',NULL,'31888908700',NULL,'CASADO','FEMININO','BRASILEIRA',9,195,'vo linda',1,NULL,1,'2020-10-29 23:22:59',1,0,NULL),
(1,8,'HUGO DIAS ALMEIDA','','GUIM','12345678998','',NULL,NULL,NULL,'31840360','RUA ÁLVARO CAMARGOS SOBRINHO','655','','FLORAMAR','BELO HORIZONTE','MG','guim@testee.com',NULL,'3198868587',NULL,'SOLTEIRO','MASCULINO','BRASILEIRO',5,42,'teste',1,'2020-10-29 23:10:31',1,'2020-10-29 23:10:31',NULL,0,NULL),
(1,9,'MARCOS ANTONIO DA SILVA','','MARQUINHO','12345678988','',NULL,NULL,NULL,'31840360','RUA ÁLVARO CAMARGOS SOBRINHO','655','','FLORAMAR','BELO HORIZONTE','MG','marcos@alcancedigital.com.br',NULL,'31988890870',NULL,'CASADO','MASCULINO','BRASILEIRO',5,18,'marcos',1,'2020-10-29 23:27:20',1,'2020-10-29 23:27:20',NULL,0,NULL);

/*Data for the table `global_profissao` */

insert  into `global_profissao`(`id_profissao`,`codigo_profissao`,`descricao_profissao`,`obs_profissao`,`idstatus_profissao`,`criacao_profissao`,`idcriacao_profissao`,`modificacao_profissao`,`idmodificacao_profissao`,`delete_profissao`,`iddelete_profissao`) values 
(1,'001','PROGRAMADOR',NULL,1,'2020-03-19 00:48:56',NULL,NULL,NULL,0,NULL),
(2,'110','Oficiais1',NULL,1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(3,'120','Sargentos',NULL,1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(4,'130','Praças',NULL,1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(5,'1120','Quadros Su','periores da Administração Pública',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(6,'1143','Dirigentes','e Quadros Superiores de Organizações Humanitárias e Outras Organizações Especializadas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(7,'1210','Directores','Gerais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(8,'1221','Directores','de Produção e Exploração Agrícola e Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(9,'1222','Directores','de Produção das Indústrias Transformadora e Extractiva',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(10,'1223','Directores','de Construção Civil e Obras Públicas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(11,'1224','Directores','do Comércio Grossista e Retalhista',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(12,'1225','Directores','de Restauração e Hotelaria',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(13,'1226','Directores','de Transportes, Entrepostos e Telecomunicações',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(14,'1227','Directores','de Empresas de Mediação e Prestação de Serviços',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(15,'1228','Directores','de Empresas de Serviços Pessoais, Limpeza e Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(16,'1229','Directores','de Produção, Exploração e Similares Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(17,'1231','Directores','de Serviços Administrativos e Financeiros',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(18,'1232','Directores','de Recursos Humanos e Relações de Trabalho',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(19,'1233','Directores','de Vendas e Comercialização',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(20,'1234','Directores','de Publicidade e Relações Públicas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(21,'1235','Directores','de Compras e Distribuição',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(22,'1236','Directores','de Serviços Informáticos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(23,'1237','Directores','de Serviços de Investigação e Desenvolvimento',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(24,'1311','Directores','e Gerentes da Agricultura, Silvicultura e da Pesca',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(25,'1312','Directores','e Gerentes da Produção Industrial',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(26,'1313','Directores','e Gerentes da Construção Civil',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(27,'1314','Directores','e Gerentes do Comércio Grossista e Retalhista',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(28,'1315','Directores','e Gerentes de Restauração e Hotelaria',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(29,'1316','Directores','e Gerentes de Transportes e Telecomunicações',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(30,'1317','Directores','e Gerentes de Empresas de Mediação e Prestação de Serviços',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(31,'1318','Directores','e Gerentes de Empresas de Serviços Pessoais, de Limpeza e Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(32,'1319','Directores','e Gerentes de Pequenas Empresas Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(33,'2111','Físicos e','Astrónomos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(34,'2112','Meteorolog','istas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(35,'2113','Químicos',NULL,1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(36,'2114','Geólogos e','Geofísicos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(37,'2115','Oceanógraf','os',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(38,'2121','Matemático','s e Especialistas Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(39,'2122','Estaticist','as',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(40,'2131','Analistas','de Sistemas e Outros Especialistas de Informática',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(41,'2141','Arquitecto','s e Urbanistas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(42,'2142','Engenheiro','s Civis e Engenheiros Técnicos Civis',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(43,'2143','Engenheiro','s Electrotécnicos e Engenheiros Técnicos Electrotécnicos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(44,'2145','Engenheiro','s Mecânicos e Engenheiros Técnicos Mecânicos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(45,'2146','Engenheiro','s Químicos e Engenheiros Técnicos Químicos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(46,'2147','Engenheiro','s de Minas, Metalúrgicos e Engenheiros Técnicos de Minas e Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(47,'2148','Engenheiro','s Geógrafos e Hidrógrafos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(48,'2211','Biológos e','Especialistas Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(49,'2212','Farmacolog','istas, Patologistas e Outros Especialistas das Ciências da Vida',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(50,'2213','Engenheiro','s Agrónomos e Engenheiros Técnicos Agrários',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(51,'2221','Médicos',NULL,1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(52,'2222','Médicos De','ntistas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(53,'2223','Veterinári','os',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(54,'2224','Farmacêuti','cos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(55,'2230','Enfermeiro','s',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(56,'2310','Docentes d','o Ensino Universitário e de Estabelecimentos de Ensino Superior',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(57,'2320','Docentes d','o Ensino Básico (2º e 3º ciclos) e Secundário',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(58,'2351','Outros Esp','ecialistas do Ensino',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(59,'2352','Inspectore','s de Educação',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(60,'2359','Outros Doc','entes do Ensino Superior, Básico, Secundário e Similares Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(61,'2411','Contabilis','tas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(62,'2412','Especialis','tas em Assuntos de Pessoal e Informação Profissional',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(63,'2419','Especialis','tas de Profissões Administrativas e Comerciais Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(64,'2421','Advogados','e Consultores Jurídicos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(65,'2422','Magistrado','s Judiciais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(66,'2429','Advogados,','Magistrados e Outros Juristas Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(67,'2431','Arquivista','s e Conservadores de Museus',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(68,'2432','Bibliotecá','rios e Documentalistas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(69,'2441','Economista','s',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(70,'2442','Sociólogos',', Antropólogos e Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(71,'2443','Historiado','res e Especialistas das Ciências Políticas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(72,'2444','Filólogos,','Tradutores e Intérpretes',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(73,'2445','Psicólogos',NULL,1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(74,'2446','Especialis','tas do Trabalho Social',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(75,'2451','Escritores',', Jornalistas e Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(76,'2452','Escultores',', Pintores e Outros Artistas Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(77,'2453','Compositor','es, Músicos e Cantores',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(78,'2454','Coreógrafo','s e Bailarinos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(79,'2455','Actores, E','ncenadores e Realizadores',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(80,'2460','Ministros','de Culto e Membros de Ordens Religiosas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(81,'2471','Técnicos d','a Administração Pública Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(82,'3111','Técnicos d','e Ciências Físico--Químicas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(83,'3112','Técnicos d','e Engenharia Civil',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(84,'3113','Técnicos d','e Electricidade',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(85,'3114','Técnicos d','e Electrónica e Telecomunicações',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(86,'3115','Técnicos d','e Relojoaria',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(87,'3116','Técnicos I','ntermédios de Química Industrial',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(88,'3118','Desenhador','es e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(89,'3119','Técnicos d','e Investigação Física e Química, do Fabrico Industrial e Trabalhadores Similares, Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(90,'3121','Programado','res de Informática e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(91,'3122','Operadores','de Informática',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(92,'3123','Técnicos d','e Robots Industriais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(93,'3131','Fotógrafos','e Operadores de Aparelhos de Registo de Imagem e de Som',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(94,'3132','Operadores','de Equipamento de Emissões de Rádio, TV e Telecomunicações',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(95,'3133','Técnicos d','e Diagnóstico e Terapêutica',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(96,'3141','Oficiais M','aquinistas de Navios',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(97,'3142','Oficiais d','e Pilotagem',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(98,'3143','Pilotos de','Aviões e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(99,'3144','Controlado','res de Tráfego Aéreo',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(100,'3145','Técnicos d','e Segurança Aérea',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(101,'3151','Técnicos d','e Prevenção de Incêndios, Fiscais de Obras e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(102,'3152','Inspectore','s e Técnicos de Segurança do Trabalho, Higiene, Controlo de Qualidade e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(103,'3211','Técnicos d','as Ciências da Vida',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(104,'3213','Inspectore','s e Técnicos Agrários e Florestais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(105,'3222','Técnicos S','anitários e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(106,'3223','Dietistas',NULL,1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(107,'3224','Optometris','tas e Ópticos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(108,'3225','Assistente','s de Medicina Dentária',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(109,'3226','Fisioterap','eutas e Profissionais Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(110,'3227','Técnicos e','Assistentes Veterinários',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(111,'3228','Técnicos d','e Farmácia',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(112,'3229','Profission','ais Técnicos da Medicina – à Excepção dos Enfermeiros – Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(113,'3232','Parteiras',NULL,1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(114,'3241','Especialis','tas da Medicina Tradicional',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(115,'3310','Docentes d','o Ensino Básico, Primário e Pré-Primário',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(116,'3311','Docentes d','o Ensino Básico – 1º Ciclo',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(117,'3321','Educadores','de Infância',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(118,'3331','Docentes d','e Educação Especial',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(119,'3391','Profission','ais do Ensino Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(120,'3411','Corretores','de Bolsa, Cambistas e de Outros Serviços Financeiros',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(121,'3412','Agentes de','Seguros',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(122,'3413','Mediadores','Oficiais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(123,'3414','Técnicos d','e Turismo',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(124,'3415','Representa','ntes Comerciais e Técnicos de Vendas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(125,'3416','Compradore','s',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(126,'3417','Avaliadore','s e Leiloeiros',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(127,'3421','Corretores','de Mercadorias',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(128,'3422','Agentes Co','ncessionários',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(129,'3423','Técnicos d','a Área do Emprego',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(130,'3429','Agentes Co','merciais e Corretores, Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(131,'3431','Profission','ais de Nível Intermédio dos Serviços Administrativos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(132,'3432','Profission','ais de Nível Intermédio dos Serviços Jurídicos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(133,'3433','Técnicos d','e Contabilidade e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(134,'3434','Profission','ais de Nível Intermédio dos Serviços Estatísticos, Matemáticos e Outros',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(135,'3441','Inspectore','s e Técnicos das Alfândegas e Fronteiras',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(136,'3442','Inspectore','s das Finanças',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(137,'3443','Inspectore','s da Segurança Social',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(138,'3449','Profission','ais de Nível Intermédio da Administração Pública, das Alfândegas, dos Impostos e Trabalhadores Similares Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(139,'3450','Inspectore','s da Polícia Judiciária e Detectives',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(140,'3471','Decoradore','s e Desenhadores Modelistas de Produtos Industriais e Comerciais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(141,'3472','Locutores','e Apresentadores de Rádio, de Televisão e de Espectáculos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(142,'3473','Músicos, C','antores e Bailarinos de Espectáculos de Variedades e Artistas Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(143,'3474','Artistas d','e Circo',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(144,'3475','Atletas, D','esportistas e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(145,'3476','Toureiros,','Cavaleiros Tauromáquicos e outros Profissionais Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(146,'4111','Dactilógra','fos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(147,'4112','Operadores','de Equipamento de Teleinformação e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(148,'4113','Operadores','de Registo de Dados',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(149,'4115','Secretário','s',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(150,'4121','Empregados','Administrativos de Contabilidade e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(151,'4122','Empregados','Administrativos dos Serviços Financeiros e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(152,'4131','Empregados','de Aprovisionamento e Armazém',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(153,'4132','Empregados','do Planeamento e Apoio à Produção',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(154,'4133','Empregados','dos Serviços de Transportes',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(155,'4141','Empregados','de Biblioteca e Classificadores Arquivistas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(156,'4142','Carteiros','e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(157,'4143','Codificado','res, Revisores de Provas e Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(158,'4190','Outros Emp','regados de Escritório Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(159,'4211','Caixas e B','ilheteiros',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(160,'4212','Caixas de','Estabelecimentos Bancários',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(161,'4213','Empregados','da Banca de Casinos e Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(162,'4214','Penhorista','s e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(163,'4215','Cobradores','e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(164,'4222','Recepcioni','stas e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(165,'4223','Operadores','de Exploração de Telecomunicações e Telefonistas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(166,'5111','Assistente','s, Comissários e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(167,'5112','Cobradores',', Revisores de Bilhetes e Trabalhadores Similares dos Transportes',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(168,'5113','Guias-Inté','rpretes e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(169,'5121','Ecónomos,','Governantas e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(170,'5122','Cozinheiro','s e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(171,'5123','Empregados','de Mesa e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(172,'5131','Vigilantes','de Crianças',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(173,'5132','Assistente','s Dentários e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(174,'5133','Ajudantes','Familiares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(175,'5139','Vigilantes',', Assistentes Médicos e Trabalhadores Similares Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(176,'5141','Cabeleirei','ros, Esteticistas, Massagistas e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(177,'5143','Agentes Fu','nerários e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(178,'5149','Trabalhado','res dos Serviços Directos e Particulares Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(179,'5151','Astrólogos','e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(180,'5161','Bombeiros',NULL,1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(181,'5162','Agentes de','Polícia',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(182,'5163','Guardas do','s Serviços Prisionais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(183,'5169','Pessoal do','s Serviços de Protecção e Segurança Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(184,'5210','Manequins','e Outros Modelos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(185,'5220','Vendedores','e Demonstradores',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(186,'5230','Vendedores','de Quiosque e de Mercados',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(187,'6111','Agricultor','es – Produção de Cereais e Vegetais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(188,'6112','Arboricult','ores – Árvores e Arbustos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(189,'6113','Floriculto','res, Horticultores e Viveiristas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(190,'6121','Criadores','de Animais e Produtores de Leite',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(191,'6122','Produtores','de Aves',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(192,'6123','Apicultore','s',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(193,'6129','Criadores','e Trabalhadores Qualificados do Tratamento de Animais Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(194,'6130','Agricultor','es e Trabalhadores Qualificados da Policultura, Criação e Tratamento de Animais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(195,'6141','Trabalhado','res Florestais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(196,'6142','Carvoeiros','e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(197,'6151','Aquacultor','es',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(198,'6152','Trabalhado','res da Pesca – Pesca Local e Costeira',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(199,'6153','Trabalhado','res da Pesca – Pesca do Largo',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(200,'6210','Agricultor','es e pescadores – Agricultura e Pesca de Subsistência',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(201,'7111','Mineiros,','Trabalhadores de Pedreiras e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(202,'7112','Carregador','es de Fogo',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(203,'7113','Canteiros','e Polidores de Pedra',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(204,'7114','Salineiros',NULL,1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(205,'7122','Pedreiros','e Calceteiros',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(206,'7123','Trabalhado','res da Construção Civil e Obras Públicas – Betão Armado',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(207,'7124','Carpinteir','os',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(208,'7129','Trabalhado','res da Construção Civil e Obras Públicas Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(209,'7131','Telhadores',NULL,1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(210,'7132','Assentador','es de Revestimentos e Ladrilhadores',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(211,'7133','Estucadore','s',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(212,'7134','Montadores','de Isolamentos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(213,'7135','Vidraceiro','s',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(214,'7136','Canalizado','res',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(215,'7137','Electricis','tas da Construção Civil e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(216,'7141','Pintores d','a Construção Civil e Colocadores de Revestimentos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(217,'7142','Pintores d','e Superfícies Metálicas, Plastificadores e Envernizadores',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(218,'7143','Limpadores','de Fachadas e Limpa-Chaminés',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(219,'7211','Fundidores','– Moldadores e Macheiros',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(220,'7212','Soldadores','e Maçariqueiros',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(221,'7213','Caldeireir','os, Latoeiros e Bate-Chapas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(222,'7214','Montadores','de Estruturas Metálicas e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(223,'7215','Montadores','de Cabos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(224,'7216','Mergulhado','res',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(225,'7221','Forjadores',', Estampadores e Operadores de Prensas de Forjar',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(226,'7222','Serralheir','os Mecânicos e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(227,'7223','Afinadores','– Operadores de Máquinas Ferramentas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(228,'7224','Polidores','de Metais e Afiadores de Ferramentas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(229,'7231','Mecânicos','e Ajustadores de Veículos a Motor',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(230,'7232','Mecânicos','de Motores de Avião',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(231,'7233','Mecânicos','e Ajustadores de Máquinas Industriais e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(232,'7241','Electromec','ânicos e Electricistas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(233,'7242','Montadores','e Reparadores de Aparelhagem Electrónica',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(234,'7243','Reparadore','s de Aparelhos Receptores de Rádio e TV',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(235,'7244','Montadores','e Reparadores de Instalações Telefónicas e Telegráficas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(236,'7245','Montadores','e Reparadores de Linhas Eléctricas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(237,'7311','Mecânicos','de Instrumentos de Precisão',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(238,'7312','Trabalhado','res do Fabrico e Reparação de Instrumentos de Música',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(239,'7313','Joalheiros','e Lapidadores',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(240,'7321','Oleiros, T','rabalhadores do Fabrico de Abrasivos e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(241,'7322','Vidreiros,','Moldadores, Cortadores, Polidores de Vidro e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(242,'7323','Lapidadore','s e Gravadores de Vidro e Cerâmica',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(243,'7324','Pintores e','Decoradores de Vidro, Cerâmica e Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(244,'7331','Artesãos d','e Artigos em Madeira e Materiais Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(245,'7332','Artesãos d','e Artigos em Tecido, Couro e Materiais Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(246,'7341','Compositor','es e Montadores de Artes Gráficas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(247,'7343','Gravadores','e Fotogravadores de Artes Gráficas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(248,'7344','Reveladore','s e Impressores em Câmara Escura',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(249,'7345','Encadernad','ores e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(250,'7346','Serígrafos','e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(251,'7411','Magarefes,','Cortadores de Carnes e Trabalhadores Similares da Preparação de Carnes e Peixes',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(252,'7412','Padeiros,','Pasteleiros e Confeiteiros',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(253,'7413','Trabalhado','res do Fabrico de Produtos Lácteos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(254,'7414','Conserveir','os de Frutas, Legumes e Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(255,'7415','Provadores','e Seleccionadores de Produtos Alimentares e Bebidas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(256,'7416','Trabalhado','res da Preparação do Tabaco',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(257,'7421','Trabalhado','res do Tratamento e Preparação de Madeiras e Cortiça',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(258,'7422','Marceneiro','s, Carpinteiros e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(259,'7423','Operadores','de Máquinas para Trabalhar Madeira e Cortiça',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(260,'7424','Cesteiros,','Pinceleiros e Trabalhadores Similares.',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(261,'7431','Preparador','es de Fibras',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(262,'7432','Tecelões d','e Teares Manuais e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(263,'7433','Alfaiates,','Costureiros e Chapeleiros',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(264,'7434','Peleiros e','Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(265,'7435','Riscadores','e Cortadores de Moldes',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(266,'7436','Costureira','s, Bordadores e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(267,'7437','Estofadore','s, Colchoeiros e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(268,'7441','Curtidores',', Preparadores e Acabadores de Peles e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(269,'7442','Sapateiros',', Trabalhadores de Calçado e do Couro.',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(270,'7451','Trabalhado','res de Artigos de Pirotecnia',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(271,'8111','Condutores','de Máquinas de Extracção – Minas e Pedreiras',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(272,'8112','Operadores','de Instalações de Preparação de Minério e Rocha',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(273,'8113','Sondadores',NULL,1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(274,'8121','Operadores','de Fornos de Minerais e de Fornos de Primeira Fusão de Metais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(275,'8122','Operadores','de Fornos de Segunda Fusão de Metais, Vazadores de Fundição e Operadores de Laminagem',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(276,'8123','Operadores','de Tratamento Térmico de Metais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(277,'8124','Trefilador','es e Estiradores',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(278,'8131','Forneiros,','Fundidores e Trabalhadores Similares de Vidro e Cerâmica',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(279,'8139','Operadores','de Instalações de Vidro e Cerâmica Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(280,'8141','Operadores','de Instalações para Trabalhar Madeiras e Cortiça',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(281,'8142','Operadores','de Instalações do Fabrico de Pasta para Papel',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(282,'8143','Operadores','de Instalações do Fabrico de Papel',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(283,'8151','Operadores','de Instalações de Moagem e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(284,'8152','Operadores','de Fornos e de Aparelhos de Tratamento Térmico – Indústria Química',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(285,'8153','Operadores','de Instalações de Filtração e Separação Químicas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(286,'8154','Operadores','de Aparelhos de Destilação, Reacção, Cristalização e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(287,'8155','Operadores','de Instalações de Refinação e Armazenamento de Petróleo e Gás',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(288,'8159','Operadores','de Instalações de Tratamento Químico Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(289,'8161','Operadores','de Instalações de Produção de Energia',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(290,'8162','Operadores','de Máquinas a Vapor e Caldeiras',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(291,'8163','Operadores','de Incineradores, Instalações de Tratamento de Água e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(292,'8172','Operadores','de Robots Industriais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(293,'8211','Operadores','de Máquinas-Ferramentas – Trabalho em Série dos Metais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(294,'8212','Operadores','de Máquinas do Fabrico de Cimento e outros Produtos Químicos e de Transformação de Pedras',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(295,'8219','Operadores','de Máquinas para Trabalhar Metais e Produtos Minerais Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(296,'8221','Operadores','de Máquinas de Fabricar Produtos Farmacêuticos e Cosméticos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(297,'8222','Trabalhado','res dos Explosivos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(298,'8223','Operadores','de Máquinas do Tratamento das Superfícies dos Metais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(299,'8224','Operadores','de Máquinas de Revelação',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(300,'8229','Operadores','de Máquinas do Fabrico de Produtos Químicos Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(301,'8231','Operadores','de Máquinas do Fabrico de Artigos de Borracha',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(302,'8232','Operadores','de Máquinas do Fabrico de Artigos de Plástico',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(303,'8240','Operadores','de Máquinas do Fabrico de Artigos em Madeira e Cortiça',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(304,'8251','Operadores','de Máquinas de Imprimir – Artes Gráficas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(305,'8252','Operadores','de Máquinas de Encadernação',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(306,'8253','Cartonagei','ros e Operadores de Máquinas de Cartonagem',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(307,'8261','Operadores','de Máquinas de Fiar, Torcer e Bobinar',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(308,'8262','Afinadores',', Preparadores e Operadores de Teares (Tecelões)',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(309,'8263','Operadores','de Máquinas para Confecção',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(310,'8264','Operadores','de Máquinas de Tratamento de Produtos Têxteis',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(311,'8265','Operadores','de Máquinas de Preparação de Peles e Couro',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(312,'8266','Operadores','de Máquinas do Fabrico de Calçado e Artigos de Couro',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(313,'8269','Operadores','de Máquinas Têxteis e de Vestuário Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(314,'8271','Operadores','de Máquinas de Preparação de Carne e Peixe',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(315,'8272','Operadores','de Máquinas de Fabrico de Produtos Lácteos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(316,'8273','Operadores','de Máquinas de Moagem',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(317,'8274','Operadores','de Máquinas de Fabrico de Produtos de Padaria, Pastelaria e Produtos à Base de Cereais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(318,'8275','Operadores','de Máquinas de Tratamento de Frutas e Legumes',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(319,'8276','Operadores','de Máquinas da Produção e Refinação de Açúcar',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(320,'8277','Operadores','de Máquinas da Preparação de Chá, Café e Cacau',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(321,'8278','Cervejeiro','s e Operadores de Máquinas da Preparação de Vinhos e de Outras Bebidas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(322,'8279','Operadores','de Máquinas do Fabrico do Tabaco',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(323,'8281','Montadores','de Construções Mecânicas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(324,'8282','Montadores','de Aparelhagem Eléctrica e Electrónica',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(325,'8284','Montadores','de Artigos em Metal, Borracha e Materiais Plásticos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(326,'8285','Montadores','de Artigos em Madeira',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(327,'8290','Outros Ope','radores de Máquinas e Trabalhadores da Montagem Não Classificados em Outra Parte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(328,'8311','Maquinista','s de Locomotivas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(329,'8312','Manobrador','es de Estação e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(330,'8322','Condutores','de Veículos Ligeiros',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(331,'8323','Condutores','de Veículos Pesados de Passageiros e Carros Eléctricos',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(332,'8324','Condutores','de Veículos Pesados de Mercadorias',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(333,'8331','Condutores','de Máquinas Agrícolas e Florestais',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(334,'8332','Condutores','de Máquinas de Escavação e Terraplanagem',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(335,'8333','Operadores','de Gruas e de Outros Aparelhos de Elevação e Transporte',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(336,'8334','Operadores','de Veículos e Equipamentos de Elevação',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(337,'8340','Mestres, M','arinheiros e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(338,'9111','Vendedores','Ambulantes de Produtos Comestíveis',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(339,'9112','Vendedores','Ambulantes de Produtos Não Comestíveis',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(340,'9113','Vendedores','por Telefone e ao Domicílio',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(341,'9120','Engraxador','es e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(342,'9131','Pessoal de','Limpeza de Casas Particulares e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(343,'9132','Pessoal de','Limpeza de Escritórios, Hotéis e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(344,'9133','Lavadeiras','e Engomadores de Roupa',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(345,'9141','Pessoal de','Vigilância e Limpeza – Prédios e Outros Edifícios',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(346,'9142','Lavadores','de Vidros, de Veículos e Colocadores de Anúncios',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(347,'9151','Estafetas,','Distribuidores, Bagageiros e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(348,'9152','Porteiros,','Guardas e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(349,'9153','Controlado','res de Salas de Jogos e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(350,'9162','Cantoneiro','s de Limpeza e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(351,'9211','Trabalhado','res Agrícolas Não Qualificados',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(352,'9212','Trabalhado','res Florestais Não Qualificados',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(353,'9213','Trabalhado','res das Pescas Não Qualificados',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(354,'9311','Trabalhado','res Não Qualificados das Minas',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(355,'9312','Serventes','da Construção Civil e Obras Públicas, Porta Miras e Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(356,'9313','ENCERADORE','s e Trabalhadores Similares da Construção Civil',1,'2020-10-06 23:14:02',NULL,'2020-10-30 01:52:29',1,0,NULL),
(357,'9321','Ensaiadore','s e Outros Trabalhadores Similares',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(358,'9322','Trabalhado','res Não Qualificados da Indústria Transformadora',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(359,'9332','Condutores','de Veículos de Tracção Animal',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(360,'9333','Carregador','es e Descarregadores de Mercadorias',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(361,'9998','Profissão','Desconhecida',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL),
(362,'9999','Sem Profis','são',1,'2020-10-06 23:14:02',NULL,'2020-10-06 23:14:02',NULL,0,NULL);

/*Data for the table `global_status` */

insert  into `global_status`(`idinstituicao_status`,`id_status`,`nome_status`,`sigla_status`,`criacao_status`,`idcriacao_status`,`modificacao_status`,`idmodificacao_status`,`delete_status`,`iddelete_status`) values 
(1,1,'ATIVO','AT','2020-03-19 00:47:51',NULL,NULL,NULL,0,NULL),
(1,2,'CANCELADO','CA','2020-03-19 00:48:18',NULL,NULL,NULL,0,NULL);

/*Data for the table `global_tela` */

insert  into `global_tela`(`idinstituicao_tela`,`id_tela`,`idmodulo_tela`,`nome_tela`,`url_tela`,`idstatus_tela`,`ordem_tela`,`criacao_tela`,`idcriacao_tela`,`modificacao_tela`,`idmodificacao_tela`,`delete_tela`,`iddelete_tela`) values 
(1,2,6,'MODULO','modulo',1,1,'2020-09-02 07:27:10',NULL,'2020-10-01 23:12:36',NULL,0,NULL),
(1,3,6,'INSTITUICAO','instituicao',1,3,'2020-09-02 07:27:49',NULL,'2020-10-01 23:13:25',NULL,0,NULL),
(1,4,6,'TELA','tela',1,2,'2020-09-02 07:28:11',NULL,'2020-10-01 23:12:52',NULL,0,NULL),
(1,5,6,'PESSOA','pessoa',1,4,'2020-09-18 11:30:47',NULL,'2020-10-01 23:13:43',NULL,0,NULL),
(1,6,6,'USUARIO','usuario',1,5,'2020-09-26 01:01:32',NULL,'2020-10-01 23:13:56',NULL,0,NULL),
(1,7,6,'PERMISSOES','usuarioperm',1,6,'2020-09-28 15:56:34',NULL,'2020-10-01 23:14:04',NULL,0,NULL),
(1,8,6,'GRAU DE INSTRUCAO','grauinstrucao',1,99,'2020-10-03 15:56:52',NULL,'2020-10-03 15:56:52',NULL,0,NULL),
(1,9,6,'PROFISSAO','profissao',1,99,'2020-10-03 15:57:36',NULL,'2020-10-30 01:28:38',1,0,NULL),
(1,10,7,'CLIENTES','clienterast',1,0,'2020-10-19 00:33:19',NULL,'2020-10-29 20:58:28',1,0,NULL),
(1,11,7,'PRODUTO','produtorast',1,99,'2020-11-04 12:00:20',1,'2020-11-05 09:19:39',1,0,NULL),
(1,12,7,'EQUIPAMENTOS','equipamentorast',1,99,'2020-11-04 12:07:31',1,'2020-11-04 12:07:31',NULL,0,NULL),
(1,13,6,'STATUS','status',1,99,'2020-11-04 16:06:53',1,'2020-11-04 16:06:53',NULL,0,NULL),
(1,14,9,'FATURAS','fatura',1,99,'2020-11-12 10:56:52',1,'2020-11-12 10:56:52',NULL,0,NULL);

/*Data for the table `global_usuario` */

insert  into `global_usuario`(`idinstituicao_usuario`,`id_usuario`,`idpessoa_usuario`,`nomeusuario_usuario`,`senhausuario_usuario`,`foto_usuario`,`tema_usuario`,`corskins_usuaario`,`rtl_usuario`,`barralateral_usuario`,`idstatus_usuario`,`criacao_usuario`,`idcriacao_usuario`,`modificacao_usuario`,`idmodificacao_usuario`,`delete_usuario`,`iddelete_usuario`) values 
(1,1,1,'admin','$2y$10$G2AcngjkmbFXBfGBrXSXh.K6UGxgQBKIFZqAYREmmt9DHDxlZ9QUu',NULL,NULL,NULL,NULL,NULL,1,'2020-10-22 11:24:57',NULL,'2020-10-23 15:57:53',NULL,0,NULL),
(1,4,4,'teste','$2y$10$ciGsz47gI6V6D3TqP0k7tOp..B9Ze0JpmFUQaQriJmVXQMRgWxWXS',NULL,NULL,NULL,NULL,NULL,1,'2020-10-23 13:19:41',NULL,'2020-10-23 15:58:07',NULL,0,NULL),
(1,5,5,'fernandanunes','$2y$10$JxnGi2IEGQwmkdb3DjDfKu47XuYdqudSe3xFI677VKalX6jwVxZ0K',NULL,NULL,NULL,NULL,NULL,1,'2020-10-25 16:17:14',NULL,'2020-10-25 16:17:14',NULL,0,NULL);

/*Data for the table `global_usuario_perm` */

insert  into `global_usuario_perm`(`idinstituicao_usuario_perm`,`id_usuario_perm`,`idusuario_usuario_perm`,`idmodulo_usuario_perm`,`idtela_usuario_perm`,`nivel_usuario_perm`,`idstatus_usuario_perm`,`criacao_usuario_perm`,`idcriacao_usuario_perm`,`modificacao_usuario_perm`,`idmodificacao_usuario_perm`,`delete_usuario_perm`,`iddelete_usuario_perm`) values 
(1,1,1,6,2,5,1,'2020-10-23 15:53:05',NULL,'2020-10-23 15:53:05',NULL,0,NULL),
(1,2,1,6,4,5,1,'2020-10-23 15:53:08',NULL,'2020-10-23 15:53:08',NULL,0,NULL),
(1,3,1,6,3,5,1,'2020-10-23 15:53:11',NULL,'2020-10-23 15:53:11',NULL,0,NULL),
(1,4,1,6,5,5,1,'2020-10-23 15:53:15',NULL,'2020-10-23 15:53:15',NULL,0,NULL),
(1,5,1,6,6,5,1,'2020-10-23 15:53:18',NULL,'2020-10-23 15:53:18',NULL,0,NULL),
(1,6,1,6,7,5,1,'2020-10-23 15:53:21',NULL,'2020-10-23 15:53:21',NULL,0,NULL),
(1,7,1,6,8,5,1,'2020-10-23 15:53:24',NULL,'2020-10-23 15:53:24',NULL,0,NULL),
(1,8,1,6,9,5,1,'2020-10-23 15:53:27',NULL,'2020-10-23 15:53:27',NULL,0,NULL),
(1,9,1,7,10,5,1,'2020-10-23 15:53:30',NULL,'2020-10-23 15:53:30',NULL,0,NULL),
(1,10,5,6,5,5,1,'2020-10-25 16:17:37',NULL,'2020-10-25 16:17:37',NULL,0,NULL),
(1,11,5,7,10,5,1,'2020-10-25 16:17:44',NULL,'2020-10-25 16:17:44',NULL,0,NULL),
(1,12,1,7,12,5,1,'2020-11-04 12:07:50',NULL,'2020-11-04 12:07:50',1,0,NULL),
(1,13,1,7,11,5,1,'2020-11-04 12:07:54',NULL,'2020-11-04 12:07:54',1,0,NULL),
(1,14,1,6,13,5,1,'2020-11-04 16:07:13',NULL,'2020-11-04 16:07:58',1,1,1),
(1,15,5,6,8,5,1,'2020-11-06 01:32:20',NULL,'2020-11-06 01:32:20',1,0,NULL),
(1,16,1,9,14,5,1,'2020-11-12 10:57:16',NULL,'2020-11-12 10:57:16',1,0,NULL);

/*Data for the table `rast_cli` */

insert  into `rast_cli`(`idinstituicao_rast_cli`,`id_rast_cli`,`idpessoa_rast_cli`,`idstatus_rast_cli`,`criacao_rast_cli`,`idcriacao_rast_cli`,`modificacao_rast_cli`,`idmodificacao_rast_cli`,`delete_rast_cli`,`iddelete_rast_cli`) values 
(1,1,2,1,'2020-10-29 22:49:57',1,'2020-10-29 22:49:57',NULL,0,NULL),
(1,2,5,1,'2020-10-29 22:53:18',1,'2020-11-06 01:33:40',1,0,NULL),
(1,3,6,1,'2020-11-06 02:22:18',1,'2020-11-06 02:22:18',NULL,0,NULL),
(1,4,8,1,'2020-11-06 02:27:00',1,'2020-11-06 02:27:00',NULL,0,NULL);

/*Data for the table `rast_equip` */

insert  into `rast_equip`(`idinstituicao_rast_equip`,`id_rast_equip`,`descricao_rast_equip`,`marca_rast_equip`,`modelo_rast_equip`,`serie_rast_equip`,`patrimonio_rast_equip`,`idstatus_rast_equip`,`obs_rast_equip`,`criacao_rast_equip`,`idcriacao_rast_equip`,`modificacao_rast_equip`,`idmodificacao_rast_equip`,`delete_rast_equip`,`iddelete_rast_equip`) values 
(1,1,'SEM EQUIPAMENTO','SEM','SEM','SEM','EMPRESA',1,'teste de cadstros','2020-11-04 14:06:28',1,'2020-11-11 10:22:54',1,0,NULL),
(1,2,'rastreador 02','yamaha','123456789','258963','EMPRESA',1,'teste 02','2020-11-06 01:37:45',1,'2020-11-06 01:37:45',NULL,0,NULL),
(1,3,'rastreador 03','honda','3968521','126456789','EMPRESA',1,'teste 03','2020-11-06 01:38:21',1,'2020-11-06 01:38:21',NULL,0,NULL),
(1,4,'modeulo 04','gm','gm1234','gg11223344','EMPRESA',1,'teste 04','2020-11-08 11:59:05',1,'2020-11-08 11:59:05',NULL,0,NULL),
(1,5,'modulo 05','vw','gol','556321','EMPRESA',1,'teste 05','2020-11-08 11:59:45',1,'2020-11-08 11:59:45',NULL,0,NULL),
(1,6,'modulo 06','simmmes','teste','0000000','EMPRESA',1,'ttste 06','2020-11-08 12:00:57',1,'2020-11-08 12:00:57',NULL,0,NULL);

/*Data for the table `rast_prod` */

insert  into `rast_prod`(`idinstituicao_rast_prod`,`id_rast_prod`,`idcli_rast_prod`,`idequip_rast_prod`,`tipo_rast_prod`,`desc_rast_prod`,`venc_rast_prod`,`valor_rast_prod`,`plano_rast_prod`,`obs_rast_prod`,`idstatus_rast_prod`,`criacao_rast_prod`,`idcriacao_rast_prod`,`modificacao_rast_prod`,`idmodificacao_rast_prod`,`delete_rast_prod`,`iddelete_rast_prod`) values 
(1,1,1,6,'MOTO','testedesc','2020-11-20',39.90,'teste','teste obs',1,'2020-11-04 15:41:32',1,'2020-11-11 18:17:12',NULL,0,NULL),
(1,2,2,2,'CARRO','ndf6464','2020-11-19',30.00,'teste',NULL,1,'2020-11-06 01:46:19',NULL,'2020-11-08 01:33:06',NULL,0,NULL),
(1,4,1,3,'MOTO','teste','2020-11-19',20.95,'teste','teste 07',1,'2020-11-11 10:28:21',1,'2020-11-11 10:28:21',NULL,0,NULL),
(1,5,2,6,'CAMINHAO','Teste','2020-11-26',41.85,'teste','hdson',1,'2020-11-11 10:42:12',1,'2020-11-11 10:42:12',NULL,0,NULL),
(1,6,4,5,'NAUTICO','jet ski','2020-11-23',30.00,'teste','jet',1,'2020-11-12 11:33:58',1,'2020-11-12 11:33:58',NULL,0,NULL);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;