Solte os arquivos aqui

Envio de SQL ( 0 ) x -

Configurações da página Clique na barra para rolar até o topo da página
Pressione Ctrl+Enter para executar consulta Pressione Enter para executar consulta
ascendente
descendente
Ordem:
Depurar SQL
Contagem
Ordem de execução
Tempo gasto
Ordenar por:
Agrupar consultas
Desagrupar consultas
Recolher Expandir Mostrar rastro Ocultar rastro Contagem : Tempo gasto :
Favoritos
Atualizar
Adicionar
Sem marcador(es)
Adicionar marcador
Opções
Definir padrão





Recolher Expandir Repetir consulta Editar Demonstrar SQL Perfil Marcadores Falha na consulta Banco de dados : Tempo de execução da consulta :
Sem título *
v Mostrar/ocultar lista de tabelas Ver em tela cheia Adicione tabelas de outra base de dados Nova página Páginas abertas Selecionar página Salvar página como Apagar páginas Criar tabela Criar relacionamento Marque a coluna para exibir Recarregar Ajuda Links angulares / Links diretos Ajustar à grade v Tudo pequeno/grande Mudar para pequeno/grande Alternar linhas de relação Exportar estrutura > Mover Menu > Fixar texto
v v
Número de tabelas: 0
v crmihubz crm_ai_agents
* id : bigint(20)
* name : varchar(255)
* queue_name : varchar(191)
* provider : varchar(50)
* tone : varchar(100)
* prompt_text : longtext
* avatar_url : longtext
* template_key : varchar(100)
* is_active : tinyint(1)
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v crmihubz crm_catarinacarros_leads
* id : bigint(20)
* integration_id : bigint(20)
* external_message_id : varchar(255)
* email_uid : bigint(20)
* email_date : datetime
* source_name : varchar(191)
* customer_name : varchar(255)
* customer_email : varchar(255)
* customer_phone : varchar(50)
* vehicle_title : varchar(255)
* vehicle_year : varchar(50)
* vehicle_color : varchar(50)
* ad_url : text
* channel : varchar(100)
* message_text : text
* raw_subject : text
* raw_from_email : varchar(255)
* raw_text : longtext
* raw_html : longtext
* parsed_payload_json : longtext
* crm_contact_id : bigint(20)
* crm_chat_id : bigint(20)
* import_status : varchar(50)
* created_at : timestamp
* updated_at : timestamp
* company_id : int(11)
* user_id : int(11)
v crmihubz crm_companies
* id : int(11)
* razao_social : varchar(255)
* nome_fantasia : varchar(255)
* cnpj : varchar(20)
* email : varchar(255)
* telefone : varchar(20)
* created_at : timestamp
* updated_at : timestamp
v crmihubz crm_facebook_leads
* id : bigint(20)
* integration_id : bigint(20)
* page_id : varchar(100)
* form_id : varchar(100)
* leadgen_id : varchar(100)
* ad_id : varchar(100)
* ad_name : varchar(255)
* campaign_id : varchar(100)
* campaign_name : varchar(255)
* customer_name : varchar(255)
* customer_email : varchar(255)
* customer_phone : varchar(50)
* lead_data : longtext
* crm_contact_id : bigint(20)
* crm_chat_id : bigint(20)
* import_status : varchar(50)
* created_at : timestamp
* updated_at : timestamp
* company_id : int(11)
* user_id : int(11)
v crmihubz crm_facebook_pages
* id : bigint(20)
* integration_id : bigint(20)
* page_id : varchar(100)
* page_name : varchar(255)
* page_access_token : text
* page_picture_url : text
* page_category : varchar(255)
* is_selected : tinyint(1)
* is_subscribed : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v crmihubz crm_flow_counters
* counter_key : varchar(100)
* current_value : bigint(20)
* updated_at : timestamp
v crmihubz crm_instagram_accounts
* id : bigint(20)
* integration_id : bigint(20)
* ig_id : varchar(100)
* ig_username : varchar(255)
* ig_name : varchar(255)
* ig_profile_picture_url : text
* page_id : varchar(100)
* page_access_token : text
* is_selected : tinyint(1)
* is_subscribed : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v crmihubz crm_integrations
* id : bigint(20)
* integration_key : varchar(100)
* name : varchar(191)
* is_active : tinyint(1)
* config_json : longtext
* status : varchar(50)
* last_success_sync_at : datetime
* last_error_at : datetime
* last_error_message : text
* total_leads_imported : int(11)
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
* company_id : int(11)
* user_id : int(11)
v crmihubz crm_mercadolivre_leads
* id : int(11)
* integration_id : int(11)
* lead_id : varchar(255)
* ad_id : varchar(255)
* ad_title : varchar(255)
* customer_name : varchar(255)
* customer_email : varchar(255)
* customer_phone : varchar(255)
* lead_data : longtext
* created_at : timestamp
* crm_contact_id : bigint(20)
* crm_chat_id : bigint(20)
* import_status : varchar(50)
* updated_at : timestamp
* company_id : int(11)
* user_id : int(11)
v crmihubz crm_napista_leads
* id : bigint(20)
* integration_id : bigint(20)
* external_message_id : varchar(255)
* email_uid : bigint(20)
* email_date : datetime
* source_name : varchar(191)
* customer_name : varchar(255)
* customer_email : varchar(255)
* customer_phone : varchar(50)
* customer_cpf : varchar(50)
* vehicle_title : varchar(255)
* vehicle_price : varchar(100)
* vehicle_year : varchar(50)
* vehicle_km : varchar(50)
* vehicle_plate : varchar(50)
* financing_details : text
* insurance_details : text
* message_text : text
* ad_url : text
* raw_subject : text
* raw_from_email : varchar(255)
* raw_text : longtext
* raw_html : longtext
* parsed_payload_json : longtext
* crm_contact_id : bigint(20)
* crm_chat_id : bigint(20)
* import_status : varchar(50)
* created_at : timestamp
* updated_at : timestamp
* company_id : int(11)
* user_id : int(11)
v crmihubz crm_olx_chat_messages
* id : bigint(20)
* integration_id : bigint(20)
* chat_id : varchar(191)
* message_id : varchar(191)
* list_id : varchar(191)
* sender_type : varchar(50)
* origin : varchar(50)
* customer_name : varchar(255)
* customer_email : varchar(255)
* customer_phone : varchar(50)
* message_text : longtext
* message_timestamp_source : datetime
* payload_json : longtext
* direction : varchar(20)
* created_at : timestamp
* updated_at : timestamp
v crmihubz crm_olx_leads
* id : bigint(20)
* integration_id : bigint(20)
* external_key : varchar(191)
* external_id : varchar(191)
* source : varchar(100)
* ad_id : varchar(191)
* list_id : varchar(191)
* customer_name : varchar(255)
* customer_email : varchar(255)
* customer_phone : varchar(50)
* message_text : longtext
* created_at_source : datetime
* buyer_history : longtext
* ads_info : longtext
* payload_json : longtext
* crm_contact_id : bigint(20)
* crm_chat_id : bigint(20)
* import_status : varchar(50)
* created_at : timestamp
* updated_at : timestamp
* company_id : int(11)
* user_id : int(11)
v crmihubz crm_olx_webhook_events
* id : bigint(20)
* integration_id : bigint(20)
* event_type : varchar(100)
* external_event_id : varchar(191)
* path_token : varchar(191)
* authorization_header : varchar(255)
* payload_json : longtext
* processed_at : datetime
* processing_status : varchar(50)
* response_payload : longtext
* created_at : timestamp
* updated_at : timestamp
v crmihubz crm_queues
* id : int(11)
* name : varchar(191)
* color : varchar(50)
* icon : varchar(50)
* greeting_message : text
* is_active : tinyint(1)
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
* instance_name : varchar(191)
v crmihubz crm_queue_users
* id : bigint(20)
* queue_id : int(11)
* user_id : int(11)
* distribution_order : int(11)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v crmihubz crm_site_leads
* id : bigint(20)
* integration_id : bigint(20)
* source_name : varchar(191)
* customer_name : varchar(255)
* customer_email : varchar(255)
* customer_phone : varchar(50)
* vehicle_title : varchar(255)
* vehicle_year : varchar(50)
* vehicle_color : varchar(50)
* vehicle_km : varchar(50)
* vehicle_price : varchar(50)
* ad_url : text
* channel : varchar(100)
* message_text : text
* parsed_payload_json : longtext
* crm_contact_id : bigint(20)
* crm_chat_id : bigint(20)
* import_status : varchar(50)
* created_at : timestamp
* updated_at : timestamp
* company_id : int(11)
* user_id : int(11)
v crmihubz crm_webmotors_leads
* id : bigint(20)
* integration_id : bigint(20)
* external_message_id : varchar(255)
* email_uid : bigint(20)
* email_date : datetime
* source_name : varchar(191)
* customer_name : varchar(255)
* customer_email : varchar(255)
* customer_phone : varchar(50)
* vehicle_title : varchar(255)
* vehicle_color : varchar(100)
* vehicle_year : varchar(50)
* vehicle_plate : varchar(50)
* vehicle_price : varchar(50)
* listing_url : text
* message_text : text
* raw_subject : text
* raw_from_email : varchar(255)
* raw_text : longtext
* raw_html : longtext
* parsed_payload_json : longtext
* crm_contact_id : bigint(20)
* crm_chat_id : bigint(20)
* import_status : varchar(50)
* created_at : timestamp
* updated_at : timestamp
* company_id : int(11)
* user_id : int(11)
v crmihubz crm_whatsapp_chats
* id : bigint(20)
* instance_name : varchar(191)
* remote_jid : varchar(191)
* display_name : varchar(255)
* profile_picture_url : longtext
* is_group : tinyint(1)
* last_message_text : text
* last_message_at : datetime
* source_identifiers : longtext
* payload_json : longtext
* created_at : timestamp
* updated_at : timestamp
* assigned_queue_id : int(11)
* assigned_user_id : int(11)
* assigned_by_flow : tinyint(1)
* assignment_source : varchar(50)
* assignment_meta : longtext
* assigned_at : datetime
* last_flow_protocol_code : varchar(50)
v crmihubz crm_whatsapp_contacts
* id : bigint(20)
* instance_name : varchar(191)
* remote_jid : varchar(191)
* display_name : varchar(255)
* profile_picture_url : longtext
* source_identifiers : longtext
* payload_json : longtext
* created_at : timestamp
* updated_at : timestamp
v crmihubz crm_whatsapp_deleted_chats
* id : bigint(20)
* instance_name : varchar(191)
* remote_jid : varchar(191)
* deleted_at : datetime
* created_at : timestamp
* updated_at : timestamp
v crmihubz crm_whatsapp_flows
* id : bigint(20)
* name : varchar(191)
* queue_id : int(11)
* flow_json : longtext
* is_active : tinyint(1)
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
* instance_name : varchar(191)
v crmihubz crm_whatsapp_flow_dispatch_log
* id : bigint(20)
* instance_name : varchar(191)
* remote_jid : varchar(191)
* message_id : varchar(191)
* trigger_node_id : varchar(50)
* created_at : timestamp
v crmihubz crm_whatsapp_flow_sessions
* id : bigint(20)
* instance_name : varchar(191)
* remote_jid : varchar(191)
* flow_id : bigint(20)
* current_node_id : varchar(50)
* waiting_type : varchar(50)
* protocol_code : varchar(50)
* session_data : longtext
* last_user_message_at : datetime
* last_bot_message_at : datetime
* resume_offered_at : datetime
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v crmihubz crm_whatsapp_instances
* id : int(11)
* instance_name : varchar(191)
* original_name : varchar(191)
* created_by : int(11)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
* assigned_user_id : int(11)
* company_id : int(11)
* capture_started_at : timestamp
v crmihubz crm_whatsapp_messages
* id : bigint(20)
* instance_name : varchar(191)
* remote_jid : varchar(191)
* message_id : varchar(191)
* from_me : tinyint(1)
* message_timestamp : datetime
* message_type : varchar(100)
* text_preview : text
* payload_json : longtext
* created_at : timestamp
* updated_at : timestamp
v crmihubz crm_whatsapp_webhook_status
* id : bigint(20)
* instance_name : varchar(191)
* last_event_name : varchar(100)
* last_received_at : datetime
* created_at : timestamp
* updated_at : timestamp
v crmihubz system_settings
* id : int(11)
* category : varchar(50)
* config_data : longtext
v crmihubz users
* id : int(11)
* email : varchar(255)
* password : varchar(255)
* name : varchar(100)
* created_at : timestamp
* reset_token : varchar(255)
* reset_token_expires : datetime
* whatsapp : varchar(50)
* photo : longtext
* company_id : int(11)
* profile : varchar(20)
* dashboard_reset_at : timestamp
Criar relacionamento
FOREIGN KEY
on delete
on update
Apagar relacionamento