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 ihubz_crm ai_agents
* id : int(11)
* user_email : varchar(255)
* name : varchar(255)
* segment : varchar(50)
* use_inventory : tinyint(1)
* use_appointment_booking : tinyint(1)
* appointment_stage : varchar(80)
* appointment_title : varchar(255)
* appointment_slot_minutes : int(11)
* appointment_max_per_slot : int(11)
* appointment_lookahead_days : int(11)
* prompt : longtext
* model : varchar(120)
* temperature : decimal(3,2)
* active : tinyint(1)
* updated_at : timestamp
v ihubz_crm appointment_kanban_columns
* id : int(11)
* user_email : varchar(255)
* name : varchar(100)
* color : varchar(20)
* position : int(11)
* created_at : timestamp
* updated_at : timestamp
v ihubz_crm chatbot_config
* id : int(11)
* user_email : varchar(255)
* name : varchar(255)
* flow_json : longtext
* active : tinyint(1)
* updated_at : timestamp
v ihubz_crm companies
* id : int(11)
* owner_email : varchar(255)
* login_email : varchar(255)
* company_name : varchar(255)
* contact_name : varchar(255)
* phone : varchar(50)
* password_hash : varchar(255)
* active : tinyint(1)
* created_by_email : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v ihubz_crm evolution_config
* id : int(11)
* user_email : varchar(255)
* apiUrl : varchar(255)
* apiKey : varchar(255)
* updated_at : timestamp
v ihubz_crm facebook_data_deletion_requests
* id : int(11)
* confirmation_code : varchar(120)
* facebook_user_id : varchar(255)
* user_email : varchar(255)
* request_payload_json : longtext
* deletion_status : varchar(60)
* deletion_summary : text
* created_at : timestamp
* updated_at : timestamp
v ihubz_crm facebook_leads
* id : int(11)
* user_email : varchar(255)
* leadgen_id : varchar(255)
* page_id : varchar(255)
* form_id : varchar(255)
* campaign_id : varchar(255)
* campaign_name : varchar(255)
* adset_id : varchar(255)
* adset_name : varchar(255)
* ad_id : varchar(255)
* ad_name : varchar(255)
* full_name : varchar(255)
* first_name : varchar(255)
* last_name : varchar(255)
* email : varchar(255)
* phone : varchar(40)
* message : longtext
* company_name : varchar(255)
* city : varchar(255)
* state : varchar(255)
* country : varchar(255)
* form_name : varchar(255)
* page_name : varchar(255)
* raw_fields_json : longtext
* raw_payload_json : longtext
* status : varchar(60)
* assigned_user_id : varchar(120)
* queue_id : varchar(120)
* queue_name : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v ihubz_crm facebook_leads_config
* id : int(11)
* user_email : varchar(255)
* connection_name : varchar(255)
* app_id : varchar(255)
* app_secret : text
* access_token : longtext
* verify_token : varchar(255)
* page_id : varchar(255)
* page_name : varchar(255)
* form_id : varchar(255)
* form_name : varchar(255)
* default_queue_id : varchar(120)
* default_queue_name : varchar(255)
* default_agent_id : varchar(120)
* oauth_facebook_user_id : varchar(255)
* oauth_facebook_user_name : varchar(255)
* oauth_connected : tinyint(1)
* oauth_user_token : longtext
* active : tinyint(1)
* auto_create_conversation : tinyint(1)
* auto_assign : tinyint(1)
* last_sync_at : timestamp
* last_test_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v ihubz_crm facebook_leads_pages
* id : int(11)
* user_email : varchar(255)
* page_id : varchar(255)
* page_name : varchar(255)
* access_token : longtext
* form_id : varchar(255)
* form_name : varchar(255)
* is_primary : tinyint(1)
* subscribed_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v ihubz_crm facebook_leads_raw
* id : int(11)
* user_email : varchar(255)
* page_id : varchar(255)
* form_id : varchar(255)
* leadgen_id : varchar(255)
* payload_json : longtext
* headers_json : longtext
* received_at : timestamp
v ihubz_crm filas_config
* id : int(11)
* user_email : varchar(255)
* filas_json : longtext
* updated_at : timestamp
v ihubz_crm lead_appointments
* id : int(11)
* user_email : varchar(255)
* lead_phone : varchar(40)
* lead_jid : varchar(255)
* lead_name : varchar(255)
* queue_id : varchar(120)
* queue_name : varchar(255)
* assigned_user_id : varchar(120)
* assigned_user_name : varchar(255)
* stage : varchar(40)
* appointment_title : varchar(255)
* appointment_notes : longtext
* scheduled_for : datetime
* created_by_email : varchar(255)
* created_by_name : varchar(255)
* last_updated_by_email : varchar(255)
* last_updated_by_name : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v ihubz_crm lead_queue_assignments
* id : int(11)
* user_email : varchar(255)
* queue_id : varchar(120)
* queue_name : varchar(255)
* lead_phone : varchar(40)
* source : varchar(255)
* assigned_user_id : varchar(120)
* last_jid : varchar(255)
* assigned_at : timestamp
* first_response_at : timestamp
* last_seen_at : timestamp
v ihubz_crm lead_queue_assignment_history
* id : int(11)
* user_email : varchar(255)
* queue_id : varchar(120)
* queue_name : varchar(255)
* lead_phone : varchar(40)
* source : varchar(255)
* assigned_user_id : varchar(120)
* last_jid : varchar(255)
* assigned_at : timestamp
* first_response_at : timestamp
* unassigned_at : timestamp
* unassigned_by_name : varchar(255)
* unassigned_by_email : varchar(255)
* unassign_method : varchar(255)
* created_at : timestamp
v ihubz_crm openai_config
* id : int(11)
* user_email : varchar(255)
* api_key : text
* model : varchar(120)
* system_prompt : longtext
* enabled : tinyint(1)
* updated_at : timestamp
v ihubz_crm queue_round_robin_state
* id : int(11)
* user_email : varchar(255)
* queue_id : varchar(120)
* last_user_id : varchar(120)
* last_index : int(11)
* updated_at : timestamp
v ihubz_crm settings
* key : varchar(255)
* value : text
v ihubz_crm site_inventory_config
* id : int(11)
* user_email : varchar(255)
* connection_name : varchar(255)
* source_type : varchar(50)
* base_url : text
* endpoint_path : text
* auth_type : varchar(50)
* auth_token : text
* auth_username : varchar(255)
* auth_password : text
* bridge_status : varchar(50)
* bridge_message : text
* bridge_authenticated_user : varchar(255)
* inventory_vehicle_count : int(11)
* inventory_root : varchar(80)
* inventory_checked_at : timestamp
* bridge_synced_at : timestamp
* cache_minutes : int(11)
* active : tinyint(1)
* updated_at : timestamp
v ihubz_crm site_leads
* id : int(11)
* user_email : varchar(255)
* lead_phone : varchar(40)
* lead_name : varchar(255)
* source_name : varchar(255)
* created_at : timestamp
v ihubz_crm smtp_config
* id : int(11)
* host : varchar(255)
* port : int(11)
* crypto : varchar(50)
* email : varchar(255)
* password : varchar(255)
v ihubz_crm team_users
* id : int(11)
* user_id : varchar(120)
* owner_email : varchar(255)
* user_email : varchar(255)
* name : varchar(255)
* password_hash : varchar(255)
* phone : varchar(50)
* role : varchar(30)
* profile_picture : longtext
* active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v ihubz_crm user_profile
* id : int(11)
* user_email : varchar(255)
* name : varchar(255)
* phone : varchar(50)
* profile_picture : longtext
* updated_at : timestamp
v ihubz_crm wpp_config
* id : int(11)
* user_email : varchar(255)
* apiUrl : varchar(255)
* apiKey : varchar(255)
* instanceName : varchar(255)
* profileName : varchar(255)
* profilePictureUrl : text
* owner : varchar(100)
* integration : varchar(80)
* state : varchar(50)
* updated_at : timestamp
Criar relacionamento
FOREIGN KEY
on delete
on update
Apagar relacionamento