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 megabanco_test_202610031012291225 mc_art_versions
* id : int(10) unsigned
* item_id : int(10) unsigned
* version_number : int(10) unsigned
* file_id : int(10) unsigned
* status : varchar(30)
* reviewed_by : int(10) unsigned
* reviewed_at : datetime
* customer_feedback : text
* created_at : datetime
v megabanco_test_202610031012291225 mc_assistant_conversations
* customer_id : int(10) unsigned
* mode : varchar(20)
* reason : varchar(30)
* updated_by : int(10) unsigned
* updated_at : datetime
v megabanco_test_202610031012291225 mc_assistant_knowledge
* id : int(10) unsigned
* title : varchar(120)
* questions : text
* keywords : text
* answer : text
* active : tinyint(4)
* updated_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v megabanco_test_202610031012291225 mc_assistant_replies
* id : int(10) unsigned
* trigger_message_id : int(10) unsigned
* reply_message_id : int(10) unsigned
* knowledge_id : int(10) unsigned
* outcome : varchar(30)
* confidence : decimal(5,3)
* created_at : datetime
v megabanco_test_202610031012291225 mc_assistant_settings
* id : tinyint(3) unsigned
* enabled : tinyint(4)
* name : varchar(80)
* fallback : text
* updated_by : int(10) unsigned
* updated_at : datetime
v megabanco_test_202610031012291225 mc_audit_logs
* id : int(10) unsigned
* staff_id : int(10) unsigned
* action : varchar(50)
* entity_type : varchar(40)
* entity_id : int(10) unsigned
* details : text
* ip : varchar(45)
* created_at : datetime
v megabanco_test_202610031012291225 mc_catalog_groups
* id : int(10) unsigned
* name : varchar(150)
* category : varchar(100)
* description : text
* image_path : varchar(255)
* active : tinyint(4)
* sort_order : int(11)
* version : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v megabanco_test_202610031012291225 mc_catalog_variants
* product_id : int(10) unsigned
* group_id : int(10) unsigned
v megabanco_test_202610031012291225 mc_customers
* id : int(10) unsigned
* name : varchar(150)
* phone : varchar(20)
* password_hash : varchar(255)
* avatar : int(10) unsigned
* active : tinyint(4)
* created_at : datetime
* updated_at : datetime
v megabanco_test_202610031012291225 mc_customer_sessions
* id : int(10) unsigned
* customer_id : int(10) unsigned
* token_hash : char(64)
* last_activity : datetime
* expires_at : datetime
* created_at : datetime
v megabanco_test_202610031012291225 mc_files
* id : int(10) unsigned
* customer_id : int(10) unsigned
* scope : varchar(20)
* path : varchar(255)
* original_name : varchar(180)
* mime : varchar(100)
* size : int(10) unsigned
* uploaded_by_type : varchar(20)
* uploaded_by : int(10) unsigned
* created_at : datetime
v megabanco_test_202610031012291225 mc_messages
* id : int(10) unsigned
* customer_id : int(10) unsigned
* sender_type : varchar(20)
* sender_id : int(10) unsigned
* message_type : varchar(20)
* body : text
* file_path : int(10) unsigned
* file_name : varchar(180)
* related_order_id : int(10) unsigned
* request_key : char(64)
* created_at : datetime
* delivered_at : datetime
* read_at : datetime
v megabanco_test_202610031012291225 mc_notifications
* id : int(10) unsigned
* target_type : varchar(20)
* target_id : int(10) unsigned
* event_type : varchar(30)
* title : varchar(180)
* body : varchar(500)
* related_id : int(10) unsigned
* event_key : varchar(190)
* created_at : datetime
* read_at : datetime
v megabanco_test_202610031012291225 mc_orders
* id : int(10) unsigned
* customer_id : int(10) unsigned
* title : varchar(180)
* description : text
* status : varchar(40)
* reservation_status : varchar(20)
* reservation_expires_at : datetime
* amount : decimal(12,2)
* duration_minutes : int(10) unsigned
* created_source : varchar(20)
* schedule_mode : varchar(20)
* delivery_date : date
* delivery_time : time
* created_by : int(10) unsigned
* request_key : char(64)
* version : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v megabanco_test_202610031012291225 mc_order_history
* id : int(10) unsigned
* order_id : int(10) unsigned
* actor_type : varchar(20)
* actor_id : int(10) unsigned
* action : varchar(40)
* details : text
* created_at : datetime
v megabanco_test_202610031012291225 mc_order_items
* id : int(10) unsigned
* order_id : int(10) unsigned
* product_id : int(10) unsigned
* description : varchar(255)
* quantity : int(10) unsigned
* unit_price : decimal(12,2)
* duration_minutes : int(10) unsigned
* setup_minutes : int(10) unsigned
* minutes_per_unit : decimal(10,3)
* art_path : int(10) unsigned
* art_source : varchar(20)
* customer_notes : text
* consignment : tinyint(4)
* consignment_settled : tinyint(4)
* consignment_settled_at : datetime
* consignment_settled_by : int(10) unsigned
* consignment_settled_amount : decimal(12,2)
* deleted_at : datetime
* created_at : datetime
* updated_at : datetime
v megabanco_test_202610031012291225 mc_order_requests
* order_id : int(10) unsigned
* requested_date : date
* fulfilment : varchar(20)
* address : varchar(1000)
* quoted_at : datetime
v megabanco_test_202610031012291225 mc_payments
* id : int(10) unsigned
* order_id : int(10) unsigned
* amount : decimal(12,2)
* status : varchar(20)
* method : varchar(30)
* external_reference : varchar(180)
* paid_at : datetime
* created_at : datetime
v megabanco_test_202610031012291225 mc_products
* id : int(10) unsigned
* name : varchar(150)
* category : varchar(100)
* variation : varchar(100)
* duration_minutes : int(10) unsigned
* setup_minutes : int(10) unsigned
* minutes_per_unit : decimal(10,3)
* base_price : decimal(12,2)
* allow_art_upload : tinyint(4)
* active : tinyint(4)
* sort_order : int(11)
* created_at : datetime
* updated_at : datetime
v megabanco_test_202610031012291225 mc_push_devices
* subscription_id : int(10) unsigned
* device_hash : char(64)
* updated_at : datetime
v megabanco_test_202610031012291225 mc_push_jobs
* id : bigint(20) unsigned
* notification_id : int(10) unsigned
* subscription_id : int(10) unsigned
* status : varchar(12)
* attempts : tinyint(3) unsigned
* next_attempt_at : datetime
* delivered_at : datetime
* last_status : smallint(5) unsigned
* created_at : datetime
v megabanco_test_202610031012291225 mc_push_settings
* id : tinyint(3) unsigned
* public_key : varchar(100)
* private_key_encrypted : text
* created_at : datetime
v megabanco_test_202610031012291225 mc_push_subscriptions
* id : int(10) unsigned
* customer_id : int(10) unsigned
* staff_id : int(10) unsigned
* endpoint : text
* endpoint_hash : char(64)
* p256dh : text
* auth : text
* created_at : datetime
* revoked_at : datetime
v megabanco_test_202610031012291225 mc_rate_limits
* bucket : char(64)
* attempts : int(10) unsigned
* window_start : datetime
* blocked_until : datetime
v megabanco_test_202610031012291225 mc_schedule_blocks
* id : int(10) unsigned
* block_date : date
* start_time : time
* end_time : time
* reason : varchar(180)
* created_by : int(10) unsigned
* created_at : datetime
v megabanco_test_202610031012291225 mc_schedule_days
* schedule_date : date
* updated_at : datetime
v megabanco_test_202610031012291225 mc_schedule_segments
* id : int(10) unsigned
* order_id : int(10) unsigned
* start_at : datetime
* end_at : datetime
* segment_order : int(10) unsigned
* created_at : datetime
v megabanco_test_202610031012291225 mc_schedule_settings
* id : int(11)
* work_start : time
* work_end : time
* slot_minutes : int(10) unsigned
* allow_fragmented : tinyint(4)
* minimum_notice_minutes : int(10) unsigned
* working_days : varchar(30)
* updated_at : datetime
v megabanco_test_202610031012291225 mc_staff
* id : int(10) unsigned
* name : varchar(150)
* username : varchar(100)
* password_hash : varchar(255)
* role : varchar(20)
* active : tinyint(4)
* created_at : datetime
v megabanco_test_202610031012291225 mc_work_calendar
* calendar_date : date
* is_closed : tinyint(4)
* work_start : time
* work_end : time
* reason : varchar(180)
v megabanco_test_202610031012291225 schema_migrations
* version : varchar(120)
* checksum : char(64)
* applied_at : datetime
v megabanco_test_202610031012291225 site_categories
* id : int(10) unsigned
* name : varchar(100)
* description : varchar(300)
* sort_order : int(11)
v megabanco_test_202610031012291225 site_settings
* setting_key : varchar(80)
* setting_value : mediumtext
Criar relacionamento
FOREIGN KEY
on delete
on update
Apagar relacionamento