Suelte aquí los archivos

Carga SQL ( 0 ) x -

Ajustes de página relacionada Pulse en la barra para deslizarse al tope de la página
Presione Ctrl+Enter para ejecutar la consulta Presione Enter para ejecutar la consulta
ascendente
descendente
Orden:
Depuración SQL
Cantidad
Orden de ejecución
Tiempo necesario
Ordenar por:
Consultas grupales
Desagrupar las consultas
Colapsar Expandir Mostrar rastro Ocultar rastro Cantidad : Tiempo necesario :
Favoritos
Actualizar
Agregar
Ningún favorito
Agregar favorito
Opciones
Definir predeterminado





Colapsar Expandir Reconsultar Editar Explicar Perfilando Agregar a favoritos Falló la consulta Base de datos : Fecha y hora la consulta :
Sin título *
v Mostrar/Ocultar lista de tablas Ver en pantalla completa Añadir tablas de otras bases de datos Nueva página Abrir página Guardar página Guardar página como Borrar páginas Crear tabla Crear relación Elegir la columna a mostrar Cargar nuevamente Ayuda Enlaces angulares / Enlaces directos Cuadrícula magnética v Pequeño/grande todos Alterne entre pequeño y grande Alternar líneas de relación Exportar estructura > Mover el Menú > Fijar texto
v v
Número de tablas: 0
v labbi activity_log
* id : bigint(20) unsigned
* log_name : varchar(191)
* description : text
* subject_type : varchar(191)
* subject_id : bigint(20) unsigned
* causer_type : varchar(191)
* causer_id : bigint(20) unsigned
* properties : longtext
* created_at : timestamp
* updated_at : timestamp
v labbi antibiotics
* id : int(10) unsigned
* name : varchar(191)
* shortcut : varchar(191)
* commercial_name : longtext
* deleted_at : timestamp
v labbi branches
* id : bigint(20) unsigned
* name : varchar(191)
* address : text
* phone : varchar(191)
* lat : double(8,2)
* lng : double(8,2)
* zoom_level : int(11)
* deleted_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v labbi chats
* id : bigint(20) unsigned
* from : int(10) unsigned
* to : int(10) unsigned
* message : text
* read : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v labbi contracts
* id : bigint(20) unsigned
* title : varchar(191)
* description : longtext
* discount : double(8,2) unsigned
* deleted_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v labbi cultures
* id : int(10) unsigned
* name : varchar(191)
* sample_type : varchar(191)
* precautions : text
* price : double
* deleted_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v labbi culture_options
* id : bigint(20) unsigned
* value : varchar(191)
* parent_id : int(11)
* deleted_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v labbi currencies
* id : bigint(20) unsigned
* iso : varchar(191)
* name : varchar(191)
* symbol : varchar(191)
v labbi doctors
* id : bigint(20) unsigned
* code : varchar(191)
* name : varchar(191)
* phone : varchar(191)
* email : varchar(191)
* address : varchar(191)
* deleted_at : timestamp
* created_at : timestamp
* updated_at : timestamp
* commission : double
v labbi expenses
* id : bigint(20) unsigned
* expense_category_id : int(11)
* amount : double
* date : date
* notes : longtext
* created_at : timestamp
* updated_at : timestamp
* doctor_id : int(11)
v labbi expense_categories
* id : bigint(20) unsigned
* name : varchar(191)
* deleted_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v labbi failed_jobs
* id : bigint(20) unsigned
* connection : text
* queue : text
* payload : text
* exception : text
* failed_at : timestamp
v labbi groups
* id : bigint(20) unsigned
* branch_id : int(10) unsigned
* patient_id : int(11)
* doctor_id : int(11)
* contract_id : int(11)
* discount : double(8,2)
* subtotal : double(8,2)
* total : double(8,2)
* paid : double(8,2)
* due : double(8,2)
* done : tinyint(1)
* report_pdf : text
* receipt_pdf : text
* created_at : timestamp
* updated_at : timestamp
* barcode : varchar(191)
* doctor_commission : double
* signature : varchar(191)
v labbi group_cultures
* id : bigint(20) unsigned
* group_id : int(11)
* culture_id : int(11)
* price : double(8,2)
* done : tinyint(1)
* comment : longtext
* created_at : timestamp
* updated_at : timestamp
v labbi group_culture_options
* id : bigint(20) unsigned
* group_culture_id : int(11)
* culture_option_id : int(11)
* value : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v labbi group_culture_results
* id : bigint(20) unsigned
* group_culture_id : int(11)
* antibiotic_id : int(11)
* sensitivity : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v labbi group_tests
* id : bigint(20) unsigned
* group_id : int(11)
* test_id : int(11)
* price : double(8,2)
* has_results : tinyint(1)
* has_entered : tinyint(1)
* done : tinyint(1)
* comment : longtext
* created_at : timestamp
* updated_at : timestamp
v labbi group_test_results
* id : bigint(20) unsigned
* group_test_id : int(11)
* test_id : int(11)
* result : varchar(191)
* status : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v labbi languages
* id : bigint(20) unsigned
* iso : varchar(191)
* active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
* rtl : tinyint(1)
v labbi migrations
* id : int(10) unsigned
* migration : varchar(191)
* batch : int(11)
v labbi modules
* id : bigint(20) unsigned
* name : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v labbi oauth_access_tokens
* id : varchar(100)
* user_id : bigint(20) unsigned
* client_id : bigint(20) unsigned
* name : varchar(191)
* scopes : text
* revoked : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
* expires_at : datetime
v labbi oauth_auth_codes
* id : varchar(100)
* user_id : bigint(20) unsigned
* client_id : bigint(20) unsigned
* scopes : text
* revoked : tinyint(1)
* expires_at : datetime
v labbi oauth_clients
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* name : varchar(191)
* secret : varchar(100)
* provider : varchar(191)
* redirect : text
* personal_access_client : tinyint(1)
* password_client : tinyint(1)
* revoked : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v labbi oauth_personal_access_clients
* id : bigint(20) unsigned
* client_id : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v labbi oauth_refresh_tokens
* id : varchar(100)
* access_token_id : varchar(100)
* revoked : tinyint(1)
* expires_at : datetime
v labbi password_resets
* email : varchar(191)
* token : varchar(191)
* created_at : datetime
v labbi patients
* id : bigint(20) unsigned
* code : varchar(191)
* name : varchar(191)
* gender : varchar(191)
* dob : varchar(191)
* phone : varchar(191)
* email : varchar(191)
* address : varchar(191)
* deleted_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v labbi permissions
* id : bigint(20) unsigned
* module_id : int(11)
* name : varchar(191)
* key : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v labbi roles
* id : bigint(20) unsigned
* name : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v labbi role_permissions
* id : bigint(20) unsigned
* role_id : int(11)
* permission_id : int(11)
* created_at : timestamp
* updated_at : timestamp
v labbi settings
* id : bigint(20) unsigned
* key : varchar(191)
* value : text
* created_at : timestamp
* updated_at : timestamp
v labbi tests
* id : int(10) unsigned
* parent_id : int(11)
* name : varchar(191)
* shortcut : varchar(191)
* sample_type : varchar(191)
* unit : varchar(191)
* reference_range : text
* type : text
* separated : tinyint(1)
* price : double
* status : tinyint(1)
* title : tinyint(1)
* precautions : text
* deleted_at : timestamp
v labbi test_options
* id : bigint(20) unsigned
* name : varchar(191)
* test_id : int(11)
* deleted_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v labbi users
* id : bigint(20) unsigned
* name : varchar(191)
* email : varchar(191)
* email_verified_at : datetime
* password : varchar(191)
* remember_token : varchar(100)
* token : text
* created_at : timestamp
* updated_at : timestamp
* signature : text
v labbi user_roles
* id : bigint(20) unsigned
* user_id : int(11)
* role_id : int(11)
* created_at : timestamp
* updated_at : timestamp
v labbi visits
* id : bigint(20) unsigned
* patient_id : int(11)
* lat : double(8,2)
* lng : double(8,2)
* zoom_level : int(11)
* visit_date : varchar(191)
* attach : varchar(191)
* read : tinyint(1)
* status : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
Crear relación
FOREIGN KEY
on delete
on update
Eliminar la relación