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 grsdayey_farmagrs 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 grsdayey_farmagrs antibiotics
* id : int(10) unsigned
* name : varchar(191)
* shortcut : varchar(191)
* commercial_name : longtext
* deleted_at : timestamp
v grsdayey_farmagrs 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 grsdayey_farmagrs 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 grsdayey_farmagrs 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 grsdayey_farmagrs 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 grsdayey_farmagrs culture_options
* id : bigint(20) unsigned
* value : varchar(191)
* parent_id : int(11)
* deleted_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v grsdayey_farmagrs currencies
* id : bigint(20) unsigned
* iso : varchar(191)
* name : varchar(191)
* symbol : varchar(191)
v grsdayey_farmagrs 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 grsdayey_farmagrs 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 grsdayey_farmagrs expense_categories
* id : bigint(20) unsigned
* name : varchar(191)
* deleted_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v grsdayey_farmagrs failed_jobs
* id : bigint(20) unsigned
* connection : text
* queue : text
* payload : text
* exception : text
* failed_at : timestamp
v grsdayey_farmagrs 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 grsdayey_farmagrs 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 grsdayey_farmagrs 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 grsdayey_farmagrs 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 grsdayey_farmagrs 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 grsdayey_farmagrs 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 grsdayey_farmagrs languages
* id : bigint(20) unsigned
* iso : varchar(191)
* active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
* rtl : tinyint(1)
v grsdayey_farmagrs migrations
* id : int(10) unsigned
* migration : varchar(191)
* batch : int(11)
v grsdayey_farmagrs modules
* id : bigint(20) unsigned
* name : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v grsdayey_farmagrs 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 grsdayey_farmagrs 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 grsdayey_farmagrs 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 grsdayey_farmagrs oauth_personal_access_clients
* id : bigint(20) unsigned
* client_id : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v grsdayey_farmagrs oauth_refresh_tokens
* id : varchar(100)
* access_token_id : varchar(100)
* revoked : tinyint(1)
* expires_at : datetime
v grsdayey_farmagrs password_resets
* email : varchar(191)
* token : varchar(191)
* created_at : datetime
v grsdayey_farmagrs 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 grsdayey_farmagrs permissions
* id : bigint(20) unsigned
* module_id : int(11)
* name : varchar(191)
* key : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v grsdayey_farmagrs roles
* id : bigint(20) unsigned
* name : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v grsdayey_farmagrs role_permissions
* id : bigint(20) unsigned
* role_id : int(11)
* permission_id : int(11)
* created_at : timestamp
* updated_at : timestamp
v grsdayey_farmagrs settings
* id : bigint(20) unsigned
* key : varchar(191)
* value : text
* created_at : timestamp
* updated_at : timestamp
v grsdayey_farmagrs 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 grsdayey_farmagrs test_options
* id : bigint(20) unsigned
* name : varchar(191)
* test_id : int(11)
* deleted_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v grsdayey_farmagrs 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 grsdayey_farmagrs user_roles
* id : bigint(20) unsigned
* user_id : int(11)
* role_id : int(11)
* created_at : timestamp
* updated_at : timestamp
v grsdayey_farmagrs 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