Diferenças de Estrutura

Array
(
    [only_in_first] => Array
        (
            [0] => POC
            [1] => POC2
            [2] => REQUISICOES_API_ARQUIVOS_POC
            [3] => REQUISICOES_API_POC
            [4] => erros
            [5] => portos_inport
        )

    [only_in_second] => Array
        (
            [0] => CARTA_CREDITO
            [1] => CERTIFICADOS
            [2] => CHAMADAS_PORTO
            [3] => DOC_ANEXO_B
            [4] => DOC_ANEXO_B_TANQUES
            [5] => DOC_APROVACAO_PLANO
            [6] => DOC_CERTIFICADO_INTERNACIONAL
            [7] => DOC_CERTIFICADO_SISTEMA
            [8] => DOC_LIVRO_REGISTRO
            [9] => DOC_LIVRO_REGISTRO_OPERACOES
            [10] => DOC_PLANO_GESTAO
            [11] => ERROS_NOVOS
            [12] => ERROS_NOVOS_bkp
            [13] => ESTATISTICA_PORTO
            [14] => FATURAMENTO
            [15] => FILIAL
            [16] => MODELO_EMAIL
            [17] => NAVIO_CHEGADA
            [18] => NAVIO_ESTADIA
            [19] => NAVIO_ROTA_ANTIGA
            [20] => NAVIO_ROTA_CONSOLIDADA
            [21] => NAVIO_ROTA_NOVA
            [22] => NAVIO_TIPO_PRECO
            [23] => NAVIO_TIPO_PRECO_bkp
            [24] => PAGAMENTO_BACKUP
            [25] => PORTOS
            [26] => RAA_NIVEIS_RISCO
            [27] => REQUISICAO_ALERTAS
            [28] => REQUISICAO_BACKUP
            [29] => REQUISICAO_ERROS_bkp
            [30] => REQUISICAO_PARCEIRO
            [31] => TABELA_PRECO
            [32] => ais_shiptypes
            [33] => importacartas
            [34] => jobs
            [35] => navios_esperados
            [36] => navios_esperados_aratu
            [37] => navios_esperados_ilheus
            [38] => navios_esperados_itajai
            [39] => navios_esperados_salvador
            [40] => requisicao_campos
        )

    [different] => Array
        (
            [ADMIN] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                            [SNAPROVACAO] => Array
                                (
                                    [type] => enum('N','S')
                                    [null] => NO
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [SNPRECO] => Array
                                (
                                    [type] => enum('S','N')
                                    [null] => YES
                                    [key] => 
                                    [default] => N
                                    [extra] => 
                                )

                        )

                    [different] => Array
                        (
                        )

                )

            [API_PORTO] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                        )

                    [different] => Array
                        (
                            [TOKEN] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => varchar(200)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => varchar(255)
                                            [null] => NO
                                            [key] => MUL
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                        )

                )

            [CONFIG] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                            [DESCRICAO] => Array
                                (
                                    [type] => varchar(200)
                                    [null] => NO
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [TIPO] => Array
                                (
                                    [type] => varchar(200)
                                    [null] => NO
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [FATURAMENTO_ID] => Array
                                (
                                    [type] => int(11)
                                    [null] => NO
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [SN_ISS_RETIDO] => Array
                                (
                                    [type] => enum('N','S')
                                    [null] => NO
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [SN_IMPOSTOS_RETIDOS] => Array
                                (
                                    [type] => enum('N','S')
                                    [null] => NO
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                        )

                    [different] => Array
                        (
                        )

                )

            [EMPRESA] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                            [TABELA_PRECO_ID] => Array
                                (
                                    [type] => int(11)
                                    [null] => NO
                                    [key] => 
                                    [default] => 1
                                    [extra] => 
                                )

                            [MODELO_EMAIL_ID] => Array
                                (
                                    [type] => int(11)
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                        )

                    [different] => Array
                        (
                            [APELIDO] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => varchar(100)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => varchar(200)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                        )

                )

            [EMPRESA_DESCONTO] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                            [CATEGORIA] => Array
                                (
                                    [type] => enum('Desconto','Comissão','Carta de Crédito')
                                    [null] => YES
                                    [key] => 
                                    [default] => Desconto
                                    [extra] => 
                                )

                        )

                    [different] => Array
                        (
                        )

                )

            [ERRO] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                            [nivel_erro] => Array
                                (
                                    [type] => varchar(5)
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                        )

                    [different] => Array
                        (
                        )

                )

            [FATURAMENTOLACKMAN] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                        )

                    [different] => Array
                        (
                            [COPIA] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => varchar(300)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => varchar(500)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                        )

                )

            [NAVIO] => Array
                (
                    [only_in_first] => Array
                        (
                            [NMSI] => Array
                                (
                                    [type] => int(11)
                                    [null] => NO
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                        )

                    [only_in_second] => Array
                        (
                            [VESSEL_UID] => Array
                                (
                                    [type] => int(11)
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [MMSI] => Array
                                (
                                    [type] => int(11)
                                    [null] => NO
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [LATITUDE] => Array
                                (
                                    [type] => decimal(10,6)
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [LONGITUDE] => Array
                                (
                                    [type] => decimal(10,6)
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [DESTINO] => Array
                                (
                                    [type] => varchar(100)
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [ETA] => Array
                                (
                                    [type] => datetime
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [SOG] => Array
                                (
                                    [type] => decimal(5,2)
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [STATUS_NAVEGACAO] => Array
                                (
                                    [type] => int(2)
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [DATA_POSICAO] => Array
                                (
                                    [type] => datetime
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                        )

                    [different] => Array
                        (
                        )

                )

            [NAVIO_ROTA] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                        )

                    [different] => Array
                        (
                            [NAVIO_ID] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => MUL
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                        )

                )

            [NORMAS] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                        )

                    [different] => Array
                        (
                            [ID] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => PRI
                                            [default] => 
                                            [extra] => auto_increment
                                        )

                                )

                        )

                )

            [NOTA] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                            [ID_CONFIG_FATURAMENTO] => Array
                                (
                                    [type] => int(11)
                                    [null] => NO
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                        )

                    [different] => Array
                        (
                            [ID_REQUISICAO] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => int(11)
                                            [null] => YES
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => int(11)
                                            [null] => YES
                                            [key] => MUL
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                            [NR_NOTA] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => int(11)
                                            [null] => YES
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => int(11)
                                            [null] => YES
                                            [key] => MUL
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                            [STATUS] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => enum('PROCESSAMENTO','EMITIDA','RASCUNHO')
                                            [null] => YES
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => enum('PROCESSAMENTO','EMITIDA','RASCUNHO')
                                            [null] => YES
                                            [key] => MUL
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                            [DATA_EMISSAO] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => datetime
                                            [null] => YES
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => date
                                            [null] => YES
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                        )

                )

            [PAGAMENTO] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                            [VALOR_DESCONTO] => Array
                                (
                                    [type] => decimal(10,2)
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                        )

                    [different] => Array
                        (
                            [STATUS_COBRANCA] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => enum('ABERTO','PAGO','ATRASADO','CANCELADO')
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => enum('ABERTO','PAGO','ATRASADO','CANCELADO','ANALISE')
                                            [null] => NO
                                            [key] => MUL
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                        )

                )

            [PAGAMENTO_NOTA] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                        )

                    [different] => Array
                        (
                            [ID_NOTA] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => MUL
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                            [ID_PAGAMENTO] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => MUL
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                        )

                )

            [PORTO] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                            [FATURAMENTO_ID] => Array
                                (
                                    [type] => int(11)
                                    [null] => NO
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [FILIAL_ID] => Array
                                (
                                    [type] => int(11)
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                        )

                    [different] => Array
                        (
                        )

                )

            [REQUISICAO] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                        )

                    [different] => Array
                        (
                            [PORTO_ID] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => 
                                            [default] => 1
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => MUL
                                            [default] => 1
                                            [extra] => 
                                        )

                                )

                            [EMPRESA_ID] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => MUL
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                            [IMO_DECLARACAO] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => MUL
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                            [STATUS_PROCESSAMENTO] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => enum('AGUARDANDO','LIBERADO','RECUSADO','VERIFICAR')
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => enum('AGUARDANDO','LIBERADO','RECUSADO','VERIFICAR')
                                            [null] => NO
                                            [key] => MUL
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                            [STATUS_PAGAMENTO] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => enum('AGUARDANDO','PAGO')
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => enum('AGUARDANDO','PAGO','ANALISE')
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                            [FORMA] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => enum('Pix','Boleto','Depósito','Antecipado','Posterior')
                                            [null] => YES
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => enum('Pix','Boleto','Depósito','Antecipado','Posterior','Bonificação','Liberação')
                                            [null] => YES
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                            [DT_CADASTRO] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => datetime
                                            [null] => NO
                                            [key] => 
                                            [default] => CURRENT_TIMESTAMP
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => datetime
                                            [null] => NO
                                            [key] => MUL
                                            [default] => CURRENT_TIMESTAMP
                                            [extra] => 
                                        )

                                )

                        )

                )

            [REQUISICAO_ERROS] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                            [tipoerro] => Array
                                (
                                    [type] => varchar(100)
                                    [null] => NO
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [nivel_erro] => Array
                                (
                                    [type] => varchar(5)
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [acao_correcao] => Array
                                (
                                    [type] => text
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [ds_erro_parceiro] => Array
                                (
                                    [type] => text
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [ds_obs_parceiro] => Array
                                (
                                    [type] => text
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                            [acao_correcao_parceiro] => Array
                                (
                                    [type] => text
                                    [null] => YES
                                    [key] => 
                                    [default] => 
                                    [extra] => 
                                )

                        )

                    [different] => Array
                        (
                        )

                )

            [certificados_internacionais_analise] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                        )

                    [different] => Array
                        (
                            [id] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => PRI
                                            [default] => 
                                            [extra] => auto_increment
                                        )

                                )

                            [resumo_analise] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => text
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => text
                                            [null] => YES
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                            [navio_imo] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => int(11)
                                            [null] => YES
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                            [navio_nome] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => varchar(200)
                                            [null] => YES
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                            [url_validacao] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => varchar(200)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => varchar(200)
                                            [null] => YES
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                            [dados] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => json
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => json
                                            [null] => YES
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                )

                        )

                )

            [sessao] => Array
                (
                    [only_in_first] => Array
                        (
                        )

                    [only_in_second] => Array
                        (
                        )

                    [different] => Array
                        (
                            [id] => Array
                                (
                                    [first] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => 
                                            [default] => 
                                            [extra] => 
                                        )

                                    [second] => Array
                                        (
                                            [type] => int(11)
                                            [null] => NO
                                            [key] => PRI
                                            [default] => 
                                            [extra] => auto_increment
                                        )

                                )

                        )

                )

        )

)