Reciente
`taller_saas`.`service_status_history`
`farmamedi_doctest`.`review`
`farmamedi_crmshare`.`tblactivity_log`
`farmamedi_crmshare`.`tbltask_followers`
`13abr26`.`wp_litespeed_url_file`
`grsdigow_wp172`.`wpeu_aipkit_chat_logs`
`mitienditasaas`.`fiscal_customers`
`mitienditasaas`.`tenants`
`farmamedi_crmshare`.`tblhr_rec_transfer_records`
`taller_saas`.`site_settings`
Favoritas
No existen tablas favoritas.
Nueva
13abr26
27jun
afa_maestra
csv3n
farmamedi
farmamedi_crmshare
farmamedi_doctest
farmamedi_hms0971mico
farmamedi_miconet
farmamedi_test
florece
grsdayey
grsdayey_blanca2712
grsdayey_f4rm45a1ud
grsdayey_farmagrs
grsdigow_wp172
grsmx
information_schema
lab
labbi
mitienditasaas
mysql
optikom
optikom_db
optikom_erp_db
performance_schema
phpmyadmin
sma_import_tmp
taller_saas
test
tiendita_transform_tmp
Panel de navegación
Árbol de navegación
Servidores
Bases de datos
Tablas
Panel de navegación
Cambiar la apariencia del panel de navegación.
Panel de navegación
Mostrar las bases de datos navegación como árbol
En el panel de navegación, reemplaza el árbol de base de datos con un selector
Enlace al panel principal
Enlace con el panel principal resaltando la base de datos o tabla actual.
Mostrar el logo
Mostrar el logo en el panel de navegación.
URL para enlace del logo
URL a la que apuntará el logo en el panel de navegación.
Logo destino del enlace
Abrir la página enlazada en la ventana principal (
principal
) o en una nueva (
nueva
).
main
new
Permitir destacar
Resaltar servidor bajo el cursor.
Cantidad máxima de elementos en el primer nivel
El número de elementos que pueden ser mostrados en cada página en el primer nivel del árbol de navegación.
Número mínimo de elementos para mostrar la caja de filtro
Define el número mínimo de elementos (tablas, vistas, rutinas y eventos) para mostrar un cuadro de filtro.
Tablas recientemente utilizadas
Número máximo de tablas recientemente utilizadas; 0 para desactivar.
Tablas favoritas
Cantidad máxima de tablas favoritas; 0 para desactivar.
Anchura del panel de navegación
Asignar 0 para ocular el panel de navegación.
Árbol de navegación
Personalizar el árbol de navegación.
Árbol de navegación
Cantidad máxima de elementos en una rama
El número de elementos que pueden ser mostrados en cada página del árbol de navegación.
Agrupar elementos en el árbol
Agrupar elementos en el árbol de navegación (determinado por el separador definido abajo en las pestañas superiores de Bases de datos y Tablas).
Activar la expansión del árbol de navegación
Si tendrá la posibilidad de expandir el árbol en el panel de navegación.
Mostrar tablas en árbol
Si se muestran las tablas bajo base de datos en el árbol de navegación
Mostrar vistas en árbol
Si se muestran vistas bajo base de datos en el árbol de navegación
Mostrar funciones en árbol
Si se muestran las funciones bajo la base de datos en el árbol de navegación
Mostrar procedimientos en árbol
Si se muestran los procedimientos bajo la base de datos en el árbol de navegación
Mostrar eventos en árbol
Si se muestran eventos bajo la base de datos en el árbol de navegación
Expandir la base de datos única
Si se debe desglosar automáticamente una base de datos individual en el árbol de navegación.
Servidores
Opciones para visualizar los servidores.
Servidores
Mostrar la selección de servidores
Mostrar la elección de servidor en la parte superior del panel de navegación.
Mostrar los servidores en una lista
Mostrar los servidores en una lista en lugar de una caja desplegable.
Bases de datos
Opciones para visualizar las bases de datos.
Bases de datos
Número mínimo de bases de datos a mostrar en la ventana de filtro de bases de datos
Separador de árbol de base de datos
Cadena que separa bases de datos en diferentes niveles de árbol.
Tablas
Opciones para visualizar las tablas.
Tablas
Destino para el icono de acceso rápido
Estructura
SQL
Buscar
Insertar
Examinar
Objetivo para el segundo icono de acceso rápido
Estructura
SQL
Buscar
Insertar
Examinar
Separador de árbol de tablas
Cadena que separa tablas en diferentes niveles de árbol.
Profundidad máxima del árbol de tablas
Suelte aquí los archivos
Carga SQL (
0
)
x
-
Mostrar los elementos escondidos del árbol de navegación.
Crear vista
¡Pasado este punto, debe tener Javascript activado!
Servidor: 127.0.0.1
Base de datos: farmamedi_hms0971mico
Estructura
SQL
Buscar
Generar una consulta
(actual)
Exportar
Importar
Operaciones
Privilegios
Rutinas
Eventos
Disparadores
Seguimiento
Diseñador
Columnas centrales
Consola
Limpiar
Historial
Opciones
Favoritos
Depuración SQL
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
Etiqueta:
Base de datos de destino:
Compartir favorito
OK
Opciones
Definir predeterminado
Siempre expandir mensajes de consultas
Mostrar histórico de consultas al iniciar
Mostrar consulta de navegación actual
Ejecute consultas en Enter e inserte una nueva línea con Shift+Enter. Para que esto sea permanente, consulte la configuración.
Cambiar al tema oscuro
Colapsar
Expandir
Reconsultar
Editar
Explicar
Perfilando
Agregar a favoritos
Falló la consulta
Base de datos :
Fecha y hora la consulta :
Cargando
Editor de ENUM/SET
Crear vista
Consulta multitabla
Consulta por ejemplo
Cambiar al
constructor visual
Búsquedas favoritas guardadas:
Nuevo favorito
Columna:
`accountant`.*
`accountant`.`id`
`accountant`.`img_url`
`accountant`.`name`
`accountant`.`email`
`accountant`.`address`
`accountant`.`phone`
`accountant`.`x`
`accountant`.`ion_user_id`
`accountant`.`hospital_id`
`accountant`.`signature`
`accountant`.`profile`
`alloted_bed`.*
`alloted_bed`.`id`
`alloted_bed`.`number`
`alloted_bed`.`category`
`alloted_bed`.`patient`
`alloted_bed`.`a_time`
`alloted_bed`.`d_time`
`alloted_bed`.`status`
`alloted_bed`.`x`
`alloted_bed`.`bed_id`
`alloted_bed`.`patientname`
`alloted_bed`.`category_status`
`alloted_bed`.`reaksione`
`alloted_bed`.`covid_19`
`alloted_bed`.`transferred_from`
`alloted_bed`.`anamneza`
`alloted_bed`.`accepting_doctor`
`alloted_bed`.`doctor`
`alloted_bed`.`diagnosis`
`alloted_bed`.`diagnoza_a_shtrimit`
`alloted_bed`.`blood_group`
`alloted_bed`.`other_illnesses`
`alloted_bed`.`a_timestamp`
`alloted_bed`.`d_timestamp`
`alloted_bed`.`hospital_id`
`appointment`.*
`appointment`.`id`
`appointment`.`patient`
`appointment`.`doctor`
`appointment`.`date`
`appointment`.`time_slot`
`appointment`.`s_time`
`appointment`.`e_time`
`appointment`.`remarks`
`appointment`.`add_date`
`appointment`.`registration_time`
`appointment`.`s_time_key`
`appointment`.`status`
`appointment`.`user`
`appointment`.`request`
`appointment`.`patientname`
`appointment`.`doctorname`
`appointment`.`room_id`
`appointment`.`live_meeting_link`
`appointment`.`cron_job`
`appointment`.`hospital_id`
`appointment`.`app_time`
`appointment`.`app_time_full_format`
`appointment`.`payment_status`
`appointment`.`visit_description`
`appointment`.`visit_charges`
`appointment`.`payment_id`
`appointment`.`discount`
`appointment`.`grand_total`
`attendance`.*
`attendance`.`id`
`attendance`.`staff`
`attendance`.`month`
`attendance`.`year`
`attendance`.`log`
`attendance`.`details`
`autoemailshortcode`.*
`autoemailshortcode`.`id`
`autoemailshortcode`.`name`
`autoemailshortcode`.`type`
`autoemailtemplate`.*
`autoemailtemplate`.`id`
`autoemailtemplate`.`name`
`autoemailtemplate`.`message`
`autoemailtemplate`.`type`
`autoemailtemplate`.`status`
`autoemailtemplate`.`hospital_id`
`autosmsshortcode`.*
`autosmsshortcode`.`id`
`autosmsshortcode`.`name`
`autosmsshortcode`.`type`
`autosmstemplate`.*
`autosmstemplate`.`id`
`autosmstemplate`.`name`
`autosmstemplate`.`message`
`autosmstemplate`.`type`
`autosmstemplate`.`status`
`autosmstemplate`.`hospital_id`
`bankb`.*
`bankb`.`id`
`bankb`.`group`
`bankb`.`status`
`bankb`.`hospital_id`
`bed`.*
`bed`.`id`
`bed`.`category`
`bed`.`number`
`bed`.`description`
`bed`.`last_a_time`
`bed`.`last_d_time`
`bed`.`status`
`bed`.`bed_id`
`bed`.`hospital_id`
`bed_category`.*
`bed_category`.`id`
`bed_category`.`category`
`bed_category`.`description`
`bed_category`.`hospital_id`
`bed_checkout`.*
`bed_checkout`.`id`
`bed_checkout`.`date`
`bed_checkout`.`final_diagnosis`
`bed_checkout`.`anatomopatologic_diagnosis`
`bed_checkout`.`dikordance`
`bed_checkout`.`alloted_bed_id`
`bed_checkout`.`doctor`
`bed_checkout`.`epicrisis`
`bed_checkout`.`checkout_state`
`bed_checkout`.`checkout_diagnosis`
`bed_checkout`.`instruction`
`bed_checkout`.`medicine_to_take`
`bed_checkout`.`hospital_id`
`bed_medicine`.*
`bed_medicine`.`id`
`bed_medicine`.`generic_name`
`bed_medicine`.`medicine_name`
`bed_medicine`.`medicine_id`
`bed_medicine`.`s_price`
`bed_medicine`.`hospital_id`
`bed_medicine`.`quantity`
`bed_medicine`.`total`
`bed_medicine`.`alloted_bed_id`
`bed_medicine`.`date`
`bed_medicine`.`payment_id`
`bed_medicine`.`medicine_pharmacy_id`
`bed_service`.*
`bed_service`.`id`
`bed_service`.`date`
`bed_service`.`nurse`
`bed_service`.`service`
`bed_service`.`price`
`bed_service`.`alloted_bed_id`
`bed_service`.`payment_id`
`bed_service`.`hospital_id`
`blood_group`.*
`blood_group`.`id`
`blood_group`.`bloodgroup`
`category`.*
`category`.`id`
`category`.`category`
`category`.`description`
`category`.`hospital_id`
`chat`.*
`chat`.`id`
`chat`.`sender_id`
`chat`.`receiver_id`
`chat`.`chat_text`
`chat`.`status`
`chat`.`date_time`
`chat`.`chat_group_id`
`chat_group`.*
`chat_group`.`id`
`chat_group`.`title`
`chat_group`.`employee`
`chat_group`.`hospital_id`
`daily_progress`.*
`daily_progress`.`id`
`daily_progress`.`date`
`daily_progress`.`datestamp`
`daily_progress`.`daily_description`
`daily_progress`.`description`
`daily_progress`.`alloted_bed_id`
`daily_progress`.`hospital_id`
`daily_progress`.`time`
`daily_progress`.`nurse`
`department`.*
`department`.`id`
`department`.`name`
`department`.`description`
`department`.`x`
`department`.`y`
`department`.`hospital_id`
`diagnostic_report`.*
`diagnostic_report`.`id`
`diagnostic_report`.`date`
`diagnostic_report`.`invoice`
`diagnostic_report`.`report`
`diagnostic_report`.`status`
`diagnostic_report`.`hospital_id`
`doctor`.*
`doctor`.`id`
`doctor`.`img_url`
`doctor`.`name`
`doctor`.`email`
`doctor`.`address`
`doctor`.`phone`
`doctor`.`department`
`doctor`.`profile`
`doctor`.`x`
`doctor`.`y`
`doctor`.`ion_user_id`
`doctor`.`hospital_id`
`doctor`.`department_name`
`doctor`.`appointment_confirmation`
`doctor`.`signature`
`doctor_visit`.*
`doctor_visit`.`id`
`doctor_visit`.`doctor_id`
`doctor_visit`.`doctor_name`
`doctor_visit`.`visit_description`
`doctor_visit`.`visit_charges`
`doctor_visit`.`status`
`doctor_visit`.`hospital_id`
`donor`.*
`donor`.`id`
`donor`.`name`
`donor`.`group`
`donor`.`age`
`donor`.`sex`
`donor`.`ldd`
`donor`.`phone`
`donor`.`email`
`donor`.`add_date`
`donor`.`hospital_id`
`draft_payment`.*
`draft_payment`.`id`
`draft_payment`.`category_name`
`draft_payment`.`patient`
`draft_payment`.`date`
`draft_payment`.`amount`
`draft_payment`.`doctor`
`draft_payment`.`discount`
`draft_payment`.`flat_discount`
`draft_payment`.`gross_total`
`draft_payment`.`user`
`draft_payment`.`patient_name`
`draft_payment`.`patient_phone`
`draft_payment`.`patient_address`
`draft_payment`.`patient_email`
`draft_payment`.`patient_gender`
`draft_payment`.`date_string`
`draft_payment`.`remarks`
`draft_payment`.`date_delivery`
`draft_payment`.`doctor_phone`
`draft_payment`.`age`
`draft_payment`.`birthdate`
`draft_payment`.`deposit_type`
`draft_payment`.`doctor_name`
`draft_payment`.`doctor_email`
`draft_payment`.`time_delivery`
`draft_payment`.`hospital_id`
`draft_payment`.`amount_received`
`draft_payment`.`vat`
`draft_payment`.`percent_discount`
`draft_payment`.`vat_amount_percent`
`email`.*
`email`.`id`
`email`.`subject`
`email`.`date`
`email`.`message`
`email`.`reciepient`
`email`.`user`
`email`.`hospital_id`
`email_settings`.*
`email_settings`.`id`
`email_settings`.`admin_email`
`email_settings`.`type`
`email_settings`.`user`
`email_settings`.`password`
`email_settings`.`hospital_id`
`email_settings`.`smtp_host`
`email_settings`.`smtp_port`
`email_settings`.`send_multipart`
`email_settings`.`mail_provider`
`expense`.*
`expense`.`id`
`expense`.`category`
`expense`.`date`
`expense`.`note`
`expense`.`amount`
`expense`.`user`
`expense`.`datestring`
`expense`.`hospital_id`
`expense_category`.*
`expense_category`.`id`
`expense_category`.`category`
`expense_category`.`description`
`expense_category`.`x`
`expense_category`.`y`
`expense_category`.`hospital_id`
`featured`.*
`featured`.`id`
`featured`.`img_url`
`featured`.`name`
`featured`.`profile`
`featured`.`description`
`featured`.`hospital_id`
`file`.*
`file`.`id`
`file`.`title`
`file`.`img_url`
`file`.`module`
`file`.`hospital_id`
`folder`.*
`folder`.`id`
`folder`.`folder_name`
`folder`.`patient`
`folder`.`add_date`
`folder`.`folder_path`
`folder`.`hospital_id`
`gallery`.*
`gallery`.`id`
`gallery`.`img`
`gallery`.`position`
`gallery`.`status`
`google_captcha`.*
`google_captcha`.`id`
`google_captcha`.`site_key`
`google_captcha`.`secret_key`
`google_captcha`.`hospital_id`
`grid`.*
`grid`.`id`
`grid`.`category`
`grid`.`title`
`grid`.`description`
`grid`.`img`
`grid`.`position`
`grid`.`status`
`groups`.*
`groups`.`id`
`groups`.`name`
`groups`.`description`
`holidays`.*
`holidays`.`id`
`holidays`.`doctor`
`holidays`.`date`
`holidays`.`x`
`holidays`.`y`
`holidays`.`hospital_id`
`hospital`.*
`hospital`.`id`
`hospital`.`name`
`hospital`.`email`
`hospital`.`password`
`hospital`.`address`
`hospital`.`phone`
`hospital`.`package`
`hospital`.`p_limit`
`hospital`.`d_limit`
`hospital`.`module`
`hospital`.`ion_user_id`
`hospital`.`country`
`hospital`.`from_where`
`hospital_deposit`.*
`hospital_deposit`.`id`
`hospital_deposit`.`payment_id`
`hospital_deposit`.`date`
`hospital_deposit`.`deposited_amount`
`hospital_deposit`.`deposited_amount_id`
`hospital_deposit`.`gateway`
`hospital_deposit`.`hospital_user_id`
`hospital_deposit`.`next_due_date_stamp`
`hospital_deposit`.`next_due_date`
`hospital_deposit`.`add_date_stamp`
`hospital_deposit`.`add_date`
`hospital_payment`.*
`hospital_payment`.`id`
`hospital_payment`.`hospital_user_id`
`hospital_payment`.`price`
`hospital_payment`.`package_duration`
`hospital_payment`.`next_due_date_stamp`
`hospital_payment`.`next_due_date`
`hospital_payment`.`add_date_stamp`
`hospital_payment`.`add_date`
`hospital_payment`.`package`
`hospital_payment`.`status`
`lab`.*
`lab`.`id`
`lab`.`category`
`lab`.`patient`
`lab`.`doctor`
`lab`.`date`
`lab`.`category_name`
`lab`.`report`
`lab`.`status`
`lab`.`user`
`lab`.`patient_name`
`lab`.`patient_phone`
`lab`.`patient_address`
`lab`.`doctor_name`
`lab`.`date_string`
`lab`.`hospital_id`
`lab`.`invoice_id`
`lab`.`category_id`
`lab`.`test_status`
`lab`.`test_status_date`
`lab`.`delivery_status`
`lab`.`delivery_status_date`
`lab`.`receiver_name`
`lab`.`updated_on`
`lab`.`reported_by`
`lab`.`done_by`
`lab`.`signed_by`
`lab_category`.*
`lab_category`.`id`
`lab_category`.`category`
`lab_category`.`description`
`lab_category`.`reference_value`
`lab_category`.`hospital_id`
`laboratorist`.*
`laboratorist`.`id`
`laboratorist`.`img_url`
`laboratorist`.`name`
`laboratorist`.`email`
`laboratorist`.`address`
`laboratorist`.`phone`
`laboratorist`.`x`
`laboratorist`.`y`
`laboratorist`.`ion_user_id`
`laboratorist`.`hospital_id`
`laboratorist`.`profile`
`laboratorist`.`signature`
`leave_type`.*
`leave_type`.`id`
`leave_type`.`name`
`leave_type`.`status`
`leave_type`.`hospital_id`
`leaves`.*
`leaves`.`id`
`leaves`.`type`
`leaves`.`duration`
`leaves`.`date`
`leaves`.`staff`
`leaves`.`reason`
`leaves`.`status`
`leaves`.`hospital_id`
`leaves`.`created_on`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`ip_address`
`login_attempts`.`login`
`login_attempts`.`time`
`logs`.*
`logs`.`id`
`logs`.`name`
`logs`.`email`
`logs`.`role`
`logs`.`ip_address`
`logs`.`hospital_id`
`logs`.`date_time`
`macro`.*
`macro`.`id`
`macro`.`short_name`
`macro`.`description`
`macro`.`created_by`
`macro`.`created_by_name`
`macro`.`date_time`
`macro`.`hospital_id`
`manual_email_template`.*
`manual_email_template`.`id`
`manual_email_template`.`name`
`manual_email_template`.`message`
`manual_email_template`.`type`
`manual_email_template`.`hospital_id`
`manual_email_template`.`added_by`
`manual_sms_template`.*
`manual_sms_template`.`id`
`manual_sms_template`.`name`
`manual_sms_template`.`message`
`manual_sms_template`.`type`
`manual_sms_template`.`hospital_id`
`manualemailshortcode`.*
`manualemailshortcode`.`id`
`manualemailshortcode`.`name`
`manualemailshortcode`.`type`
`manualsmsshortcode`.*
`manualsmsshortcode`.`id`
`manualsmsshortcode`.`name`
`manualsmsshortcode`.`type`
`medical_history`.*
`medical_history`.`id`
`medical_history`.`patient_id`
`medical_history`.`title`
`medical_history`.`description`
`medical_history`.`patient_name`
`medical_history`.`patient_address`
`medical_history`.`patient_phone`
`medical_history`.`img_url`
`medical_history`.`date`
`medical_history`.`registration_time`
`medical_history`.`hospital_id`
`medicine`.*
`medicine`.`id`
`medicine`.`name`
`medicine`.`category`
`medicine`.`price`
`medicine`.`box`
`medicine`.`s_price`
`medicine`.`quantity`
`medicine`.`generic`
`medicine`.`company`
`medicine`.`effects`
`medicine`.`e_date`
`medicine`.`add_date`
`medicine`.`hospital_id`
`medicine_category`.*
`medicine_category`.`id`
`medicine_category`.`category`
`medicine_category`.`description`
`medicine_category`.`hospital_id`
`meeting`.*
`meeting`.`id`
`meeting`.`patient`
`meeting`.`doctor`
`meeting`.`topic`
`meeting`.`type`
`meeting`.`start_time`
`meeting`.`duration`
`meeting`.`timezone`
`meeting`.`meeting_id`
`meeting`.`meeting_password`
`meeting`.`date`
`meeting`.`time_slot`
`meeting`.`s_time`
`meeting`.`e_time`
`meeting`.`remarks`
`meeting`.`add_date`
`meeting`.`registration_time`
`meeting`.`s_time_key`
`meeting`.`status`
`meeting`.`user`
`meeting`.`request`
`meeting`.`patientname`
`meeting`.`doctorname`
`meeting`.`ion_user_id`
`meeting`.`doctor_ion_id`
`meeting`.`patient_ion_id`
`meeting`.`hospital_id`
`meeting_settings`.*
`meeting_settings`.`id`
`meeting_settings`.`api_key`
`meeting_settings`.`secret_key`
`meeting_settings`.`ion_user_id`
`meeting_settings`.`y`
`meeting_settings`.`hospital_id`
`module`.*
`module`.`id`
`module`.`hospital_id`
`module`.`modules`
`module`.`x`
`module`.`y`
`notice`.*
`notice`.`id`
`notice`.`title`
`notice`.`description`
`notice`.`date`
`notice`.`type`
`notice`.`hospital_id`
`nurse`.*
`nurse`.`id`
`nurse`.`img_url`
`nurse`.`name`
`nurse`.`email`
`nurse`.`address`
`nurse`.`phone`
`nurse`.`x`
`nurse`.`y`
`nurse`.`z`
`nurse`.`ion_user_id`
`nurse`.`hospital_id`
`nurse`.`profile`
`nurse`.`signature`
`odontogram`.*
`odontogram`.`id`
`odontogram`.`patient_id`
`odontogram`.`Tooth32`
`odontogram`.`Tooth31`
`odontogram`.`Tooth30`
`odontogram`.`Tooth29`
`odontogram`.`Tooth28`
`odontogram`.`Tooth27`
`odontogram`.`Tooth26`
`odontogram`.`Tooth25`
`odontogram`.`Tooth24`
`odontogram`.`Tooth23`
`odontogram`.`Tooth22`
`odontogram`.`Tooth21`
`odontogram`.`Tooth20`
`odontogram`.`Tooth19`
`odontogram`.`Tooth18`
`odontogram`.`Tooth17`
`odontogram`.`Tooth16`
`odontogram`.`Tooth15`
`odontogram`.`Tooth14`
`odontogram`.`Tooth13`
`odontogram`.`Tooth12`
`odontogram`.`Tooth11`
`odontogram`.`Tooth10`
`odontogram`.`Tooth9`
`odontogram`.`Tooth8`
`odontogram`.`Tooth7`
`odontogram`.`Tooth6`
`odontogram`.`Tooth5`
`odontogram`.`Tooth4`
`odontogram`.`Tooth3`
`odontogram`.`Tooth2`
`odontogram`.`Tooth1`
`odontogram`.`description`
`ot_payment`.*
`ot_payment`.`id`
`ot_payment`.`patient`
`ot_payment`.`doctor_c_s`
`ot_payment`.`doctor_a_s_1`
`ot_payment`.`doctor_a_s_2`
`ot_payment`.`doctor_anaes`
`ot_payment`.`n_o_o`
`ot_payment`.`c_s_f`
`ot_payment`.`a_s_f_1`
`ot_payment`.`a_s_f_2`
`ot_payment`.`anaes_f`
`ot_payment`.`ot_charge`
`ot_payment`.`cab_rent`
`ot_payment`.`seat_rent`
`ot_payment`.`others`
`ot_payment`.`discount`
`ot_payment`.`date`
`ot_payment`.`amount`
`ot_payment`.`doctor_fees`
`ot_payment`.`hospital_fees`
`ot_payment`.`gross_total`
`ot_payment`.`flat_discount`
`ot_payment`.`amount_received`
`ot_payment`.`status`
`ot_payment`.`user`
`ot_payment`.`hospital_id`
`package`.*
`package`.`id`
`package`.`name`
`package`.`monthly_price`
`package`.`p_limit`
`package`.`d_limit`
`package`.`module`
`package`.`show_in_frontend`
`package`.`frontend_order`
`package`.`set_as_default`
`package`.`yearly_price`
`package`.`recommended`
`patient`.*
`patient`.`id`
`patient`.`img_url`
`patient`.`name`
`patient`.`email`
`patient`.`doctor`
`patient`.`address`
`patient`.`phone`
`patient`.`sex`
`patient`.`disease`
`patient`.`birthdate`
`patient`.`age`
`patient`.`bloodgroup`
`patient`.`ion_user_id`
`patient`.`patient_id`
`patient`.`add_date`
`patient`.`registration_time`
`patient`.`how_added`
`patient`.`hospital_id`
`patient`.`appointment_confirmation`
`patient`.`appointment_creation`
`patient`.`payment_confirmation`
`patient`.`meeting_schedule`
`patient`.`body_mass_index`
`patient`.`weight`
`patient`.`height`
`patient`.`habits`
`patient`.`do_you_use_tobacco`
`patient`.`do_you_use_alcohol`
`patient`.`do_you_use_drugs`
`patient`.`physical_activity`
`patient`.`allergies`
`patient`.`cardiovascular_risk_factors`
`patient`.`previous_illnesses`
`patient`.`are_you_on_medication`
`patient`.`surgical_interventions`
`patient`.`vaccination_status`
`patient`.`family_history`
`patient`.`marital_status`
`patient`.`children`
`patient`.`morbid_history`
`patient`.`diseases`
`patient`.`nutrition`
`patient`.`emotional_status`
`patient`.`reproductive_status`
`patient`.`date_of_last_menstrual_period`
`patient`.`date_of_last_gynecological_examination`
`patient`.`pregnancies`
`patient`.`contraceptive_method`
`patient`.`previous_jobs`
`patient`.`length_of_last_employment`
`patient`.`risk_factors_for_last_employment`
`patient`.`hours_covered_for_last_employment`
`patient`.`current_position`
`patient`.`seniority_of_current_position`
`patient`.`current_risk_factors`
`patient`.`schedule_of_current_position`
`patient`.`days_off_from_current_position`
`patient`.`custom_fields`
`patient_deposit`.*
`patient_deposit`.`id`
`patient_deposit`.`patient`
`patient_deposit`.`payment_id`
`patient_deposit`.`date`
`patient_deposit`.`deposited_amount`
`patient_deposit`.`amount_received_id`
`patient_deposit`.`deposit_type`
`patient_deposit`.`gateway`
`patient_deposit`.`user`
`patient_deposit`.`hospital_id`
`patient_deposit`.`payment_from`
`patient_material`.*
`patient_material`.`id`
`patient_material`.`date`
`patient_material`.`title`
`patient_material`.`category`
`patient_material`.`patient`
`patient_material`.`patient_name`
`patient_material`.`patient_address`
`patient_material`.`patient_phone`
`patient_material`.`url`
`patient_material`.`date_string`
`patient_material`.`hospital_id`
`patient_material`.`folder`
`patient_material`.`type`
`payment`.*
`payment`.`id`
`payment`.`category`
`payment`.`patient`
`payment`.`doctor`
`payment`.`date`
`payment`.`amount`
`payment`.`vat`
`payment`.`x_ray`
`payment`.`flat_vat`
`payment`.`discount`
`payment`.`flat_discount`
`payment`.`gross_total`
`payment`.`remarks`
`payment`.`hospital_amount`
`payment`.`doctor_amount`
`payment`.`category_amount`
`payment`.`category_name`
`payment`.`amount_received`
`payment`.`deposit_type`
`payment`.`status`
`payment`.`user`
`payment`.`patient_name`
`payment`.`patient_phone`
`payment`.`patient_address`
`payment`.`doctor_name`
`payment`.`date_string`
`payment`.`hospital_id`
`payment`.`payment_from`
`payment`.`date_delivery`
`payment`.`time_delivery`
`payment`.`percent_discount`
`payment`.`vat_amount_percent`
`payment`.`appointment_id`
`payment_category`.*
`payment_category`.`id`
`payment_category`.`category`
`payment_category`.`description`
`payment_category`.`c_price`
`payment_category`.`type`
`payment_category`.`d_commission`
`payment_category`.`h_commission`
`payment_category`.`hospital_id`
`payment_category`.`code`
`payment_category`.`payment_category`
`payment_category`.`payment_category_name`
`payment_category`.`report`
`paymentgateway`.*
`paymentgateway`.`id`
`paymentgateway`.`name`
`paymentgateway`.`merchant_key`
`paymentgateway`.`salt`
`paymentgateway`.`x`
`paymentgateway`.`y`
`paymentgateway`.`APIUsername`
`paymentgateway`.`APIPassword`
`paymentgateway`.`APISignature`
`paymentgateway`.`status`
`paymentgateway`.`publish`
`paymentgateway`.`secret`
`paymentgateway`.`hospital_id`
`paymentgateway`.`public_key`
`payroll`.*
`payroll`.`id`
`payroll`.`staff`
`payroll`.`month`
`payroll`.`year`
`payroll`.`paid_on`
`payroll`.`expense`
`payroll`.`earning`
`payroll`.`deduction`
`payroll`.`status`
`payroll`.`hospital_id`
`pharmacist`.*
`pharmacist`.`id`
`pharmacist`.`img_url`
`pharmacist`.`name`
`pharmacist`.`email`
`pharmacist`.`address`
`pharmacist`.`phone`
`pharmacist`.`x`
`pharmacist`.`y`
`pharmacist`.`ion_user_id`
`pharmacist`.`hospital_id`
`pharmacist`.`profile`
`pharmacist`.`signature`
`pharmacy_expense`.*
`pharmacy_expense`.`id`
`pharmacy_expense`.`category`
`pharmacy_expense`.`date`
`pharmacy_expense`.`amount`
`pharmacy_expense`.`user`
`pharmacy_expense`.`hospital_id`
`pharmacy_expense_category`.*
`pharmacy_expense_category`.`id`
`pharmacy_expense_category`.`category`
`pharmacy_expense_category`.`description`
`pharmacy_expense_category`.`x`
`pharmacy_expense_category`.`y`
`pharmacy_expense_category`.`hospital_id`
`pharmacy_payment`.*
`pharmacy_payment`.`id`
`pharmacy_payment`.`category`
`pharmacy_payment`.`patient`
`pharmacy_payment`.`doctor`
`pharmacy_payment`.`date`
`pharmacy_payment`.`amount`
`pharmacy_payment`.`vat`
`pharmacy_payment`.`x_ray`
`pharmacy_payment`.`flat_vat`
`pharmacy_payment`.`discount`
`pharmacy_payment`.`flat_discount`
`pharmacy_payment`.`gross_total`
`pharmacy_payment`.`hospital_amount`
`pharmacy_payment`.`doctor_amount`
`pharmacy_payment`.`category_amount`
`pharmacy_payment`.`category_name`
`pharmacy_payment`.`amount_received`
`pharmacy_payment`.`status`
`pharmacy_payment`.`hospital_id`
`pharmacy_payment_category`.*
`pharmacy_payment_category`.`id`
`pharmacy_payment_category`.`category`
`pharmacy_payment_category`.`description`
`pharmacy_payment_category`.`c_price`
`pharmacy_payment_category`.`d_commission`
`pharmacy_payment_category`.`h_commission`
`pharmacy_payment_category`.`hospital_id`
`prescription`.*
`prescription`.`id`
`prescription`.`date`
`prescription`.`patient`
`prescription`.`doctor`
`prescription`.`symptom`
`prescription`.`advice`
`prescription`.`state`
`prescription`.`dd`
`prescription`.`medicine`
`prescription`.`validity`
`prescription`.`note`
`prescription`.`patientname`
`prescription`.`doctorname`
`prescription`.`signed_by`
`prescription`.`hospital_id`
`pservice`.*
`pservice`.`id`
`pservice`.`name`
`pservice`.`code`
`pservice`.`alpha_code`
`pservice`.`price`
`pservice`.`active`
`pservice`.`hospital_id`
`receptionist`.*
`receptionist`.`id`
`receptionist`.`img_url`
`receptionist`.`name`
`receptionist`.`email`
`receptionist`.`address`
`receptionist`.`phone`
`receptionist`.`x`
`receptionist`.`ion_user_id`
`receptionist`.`hospital_id`
`receptionist`.`signature`
`receptionist`.`profile`
`report`.*
`report`.`id`
`report`.`report_type`
`report`.`patient`
`report`.`description`
`report`.`doctor`
`report`.`date`
`report`.`add_date`
`report`.`hospital_id`
`request`.*
`request`.`id`
`request`.`name`
`request`.`address`
`request`.`email`
`request`.`phone`
`request`.`other`
`request`.`package`
`request`.`language`
`request`.`remarks`
`request`.`status`
`review`.*
`review`.`id`
`review`.`name`
`review`.`designation`
`review`.`review`
`review`.`img`
`review`.`status`
`salary`.*
`salary`.`id`
`salary`.`staff`
`salary`.`salary`
`salary`.`hospital_id`
`service`.*
`service`.`id`
`service`.`img_url`
`service`.`title`
`service`.`description`
`settings`.*
`settings`.`id`
`settings`.`system_vendor`
`settings`.`title`
`settings`.`address`
`settings`.`phone`
`settings`.`email`
`settings`.`facebook_id`
`settings`.`currency`
`settings`.`language`
`settings`.`discount`
`settings`.`live_appointment_type`
`settings`.`vat`
`settings`.`login_title`
`settings`.`logo`
`settings`.`invoice_logo`
`settings`.`payment_gateway`
`settings`.`sms_gateway`
`settings`.`codec_username`
`settings`.`codec_purchase_code`
`settings`.`hospital_id`
`settings`.`emailtype`
`settings`.`remainder_appointment`
`settings`.`footer_message`
`settings`.`show_odontogram_in_history`
`settings`.`invoice_choose`
`settings`.`discount_percent`
`settings`.`footer_invoice_message`
`single_website_settings`.*
`single_website_settings`.`id`
`single_website_settings`.`title`
`single_website_settings`.`description`
`single_website_settings`.`logo`
`single_website_settings`.`address`
`single_website_settings`.`phone`
`single_website_settings`.`emergency`
`single_website_settings`.`support`
`single_website_settings`.`email`
`single_website_settings`.`currency`
`single_website_settings`.`block_1_text_under_title`
`single_website_settings`.`service_block__text_under_title`
`single_website_settings`.`doctor_block__text_under_title`
`single_website_settings`.`facebook_id`
`single_website_settings`.`twitter_id`
`single_website_settings`.`google_id`
`single_website_settings`.`youtube_id`
`single_website_settings`.`skype_id`
`single_website_settings`.`x`
`single_website_settings`.`twitter_username`
`single_website_settings`.`appointment_title`
`single_website_settings`.`appointment_subtitle`
`single_website_settings`.`appointment_description`
`single_website_settings`.`appointment_img_url`
`single_website_settings`.`url_hospital`
`single_website_settings`.`hospital_id`
`site_gallery`.*
`site_gallery`.`id`
`site_gallery`.`img`
`site_gallery`.`position`
`site_gallery`.`status`
`site_gallery`.`hospital_id`
`site_grid`.*
`site_grid`.`id`
`site_grid`.`category`
`site_grid`.`title`
`site_grid`.`description`
`site_grid`.`img`
`site_grid`.`position`
`site_grid`.`status`
`site_grid`.`hospital_id`
`site_map`.*
`site_map`.`id`
`site_map`.`name`
`site_map`.`url`
`site_map`.`for_login`
`site_review`.*
`site_review`.`id`
`site_review`.`name`
`site_review`.`designation`
`site_review`.`review`
`site_review`.`img`
`site_review`.`status`
`site_review`.`hospital_id`
`site_service`.*
`site_service`.`id`
`site_service`.`img_url`
`site_service`.`title`
`site_service`.`description`
`site_service`.`hospital_id`
`site_slide`.*
`site_slide`.`id`
`site_slide`.`title`
`site_slide`.`img_url`
`site_slide`.`text1`
`site_slide`.`text2`
`site_slide`.`text3`
`site_slide`.`position`
`site_slide`.`status`
`site_slide`.`hospital_id`
`slide`.*
`slide`.`id`
`slide`.`title`
`slide`.`img_url`
`slide`.`text1`
`slide`.`text2`
`slide`.`text3`
`slide`.`position`
`slide`.`status`
`sms`.*
`sms`.`id`
`sms`.`date`
`sms`.`message`
`sms`.`recipient`
`sms`.`user`
`sms`.`hospital_id`
`sms_settings`.*
`sms_settings`.`id`
`sms_settings`.`name`
`sms_settings`.`username`
`sms_settings`.`password`
`sms_settings`.`api_id`
`sms_settings`.`sender`
`sms_settings`.`authkey`
`sms_settings`.`user`
`sms_settings`.`sid`
`sms_settings`.`token`
`sms_settings`.`sendernumber`
`sms_settings`.`hospital_id`
`sms_settings`.`email`
`sms_settings`.`sender_name`
`superadmin`.*
`superadmin`.`id`
`superadmin`.`name`
`superadmin`.`email`
`superadmin`.`phone`
`superadmin`.`address`
`superadmin`.`img_url`
`superadmin`.`ion_user_id`
`superadmin`.`module`
`template`.*
`template`.`id`
`template`.`name`
`template`.`template`
`template`.`user`
`template`.`x`
`template`.`hospital_id`
`template`.`category_id`
`time_schedule`.*
`time_schedule`.`id`
`time_schedule`.`doctor`
`time_schedule`.`weekday`
`time_schedule`.`s_time`
`time_schedule`.`e_time`
`time_schedule`.`s_time_key`
`time_schedule`.`duration`
`time_schedule`.`hospital_id`
`time_slot`.*
`time_slot`.`id`
`time_slot`.`doctor`
`time_slot`.`s_time`
`time_slot`.`e_time`
`time_slot`.`weekday`
`time_slot`.`s_time_key`
`time_slot`.`hospital_id`
`transaction_logs`.*
`transaction_logs`.`id`
`transaction_logs`.`date_time`
`transaction_logs`.`invoice_id`
`transaction_logs`.`patientname`
`transaction_logs`.`deposit_type`
`transaction_logs`.`payment_gateway`
`transaction_logs`.`action`
`transaction_logs`.`hospital_id`
`transaction_logs`.`amount`
`transaction_logs`.`user`
`users`.*
`users`.`id`
`users`.`ip_address`
`users`.`username`
`users`.`password`
`users`.`salt`
`users`.`email`
`users`.`activation_code`
`users`.`forgotten_password_code`
`users`.`forgotten_password_time`
`users`.`remember_code`
`users`.`created_on`
`users`.`last_login`
`users`.`active`
`users`.`first_name`
`users`.`last_name`
`users`.`company`
`users`.`phone`
`users`.`hospital_ion_id`
`users_groups`.*
`users_groups`.`id`
`users_groups`.`user_id`
`users_groups`.`group_id`
`vital_signs`.*
`vital_signs`.`id`
`vital_signs`.`patient_id`
`vital_signs`.`bmi_height`
`vital_signs`.`bmi_weight`
`vital_signs`.`respiratory_rate`
`vital_signs`.`oxygen_saturation`
`vital_signs`.`temperature`
`vital_signs`.`diastolic_blood_pressure`
`vital_signs`.`systolic_blood_pressure`
`vital_signs`.`add_date_time`
`vital_signs`.`heart_rate`
`vital_signs`.`hospital_id`
`website_settings`.*
`website_settings`.`id`
`website_settings`.`title`
`website_settings`.`logo`
`website_settings`.`address`
`website_settings`.`phone`
`website_settings`.`emergency`
`website_settings`.`support`
`website_settings`.`email`
`website_settings`.`currency`
`website_settings`.`block_1_text_under_title`
`website_settings`.`service_block__text_under_title`
`website_settings`.`doctor_block__text_under_title`
`website_settings`.`facebook_id`
`website_settings`.`twitter_id`
`website_settings`.`google_id`
`website_settings`.`youtube_id`
`website_settings`.`skype_id`
`website_settings`.`x`
`website_settings`.`twitter_username`
`website_settings`.`block_img_url`
`website_settings`.`comment_1`
`website_settings`.`comment_2`
`website_settings`.`verified_1`
`website_settings`.`verified_2`
`website_settings`.`comment_logo_1`
`website_settings`.`comment_logo_2`
`website_settings`.`partner_header_title`
`website_settings`.`partner_header_description`
`website_settings`.`section_title_1`
`website_settings`.`section_title_2`
`website_settings`.`section_title_3`
`website_settings`.`section_description_1`
`website_settings`.`section_description_2`
`website_settings`.`section_description_3`
`website_settings`.`section_1_text_1`
`website_settings`.`section_2_text_1`
`website_settings`.`section_3_text_1`
`website_settings`.`section_1_text_2`
`website_settings`.`section_2_text_2`
`website_settings`.`section_3_text_2`
`website_settings`.`section_1_text_3`
`website_settings`.`section_2_text_3`
`website_settings`.`section_3_text_3`
`website_settings`.`partner_image_1`
`website_settings`.`partner_image_2`
`website_settings`.`partner_image_3`
`website_settings`.`market_title`
`website_settings`.`market_description`
`website_settings`.`market_button_link`
`website_settings`.`market_image`
`website_settings`.`market_commentator_name`
`website_settings`.`market_commentator_designation`
`website_settings`.`market_comment`
`website_settings`.`commentator_profile_image`
`website_settings`.`commentator_logo_1`
`website_settings`.`commentator_logo_2`
`website_settings`.`commentator_logo_3`
`website_settings`.`team_title`
`website_settings`.`team_description`
`website_settings`.`team_button_link`
`website_settings`.`team_commentator_name`
`website_settings`.`team_commentator_designation`
`website_settings`.`team_comment`
`website_settings`.`team_verified`
`website_settings`.`team_review_logo`
`website_settings`.`team_commentator_image`
`website_settings`.`registration_block_text`
`website_settings`.`contact_us`
`website_settings`.`contact_us_email`
`website_settings`.`chat_js`
`accountant`.*
`accountant`.`id`
`accountant`.`img_url`
`accountant`.`name`
`accountant`.`email`
`accountant`.`address`
`accountant`.`phone`
`accountant`.`x`
`accountant`.`ion_user_id`
`accountant`.`hospital_id`
`accountant`.`signature`
`accountant`.`profile`
`alloted_bed`.*
`alloted_bed`.`id`
`alloted_bed`.`number`
`alloted_bed`.`category`
`alloted_bed`.`patient`
`alloted_bed`.`a_time`
`alloted_bed`.`d_time`
`alloted_bed`.`status`
`alloted_bed`.`x`
`alloted_bed`.`bed_id`
`alloted_bed`.`patientname`
`alloted_bed`.`category_status`
`alloted_bed`.`reaksione`
`alloted_bed`.`covid_19`
`alloted_bed`.`transferred_from`
`alloted_bed`.`anamneza`
`alloted_bed`.`accepting_doctor`
`alloted_bed`.`doctor`
`alloted_bed`.`diagnosis`
`alloted_bed`.`diagnoza_a_shtrimit`
`alloted_bed`.`blood_group`
`alloted_bed`.`other_illnesses`
`alloted_bed`.`a_timestamp`
`alloted_bed`.`d_timestamp`
`alloted_bed`.`hospital_id`
`appointment`.*
`appointment`.`id`
`appointment`.`patient`
`appointment`.`doctor`
`appointment`.`date`
`appointment`.`time_slot`
`appointment`.`s_time`
`appointment`.`e_time`
`appointment`.`remarks`
`appointment`.`add_date`
`appointment`.`registration_time`
`appointment`.`s_time_key`
`appointment`.`status`
`appointment`.`user`
`appointment`.`request`
`appointment`.`patientname`
`appointment`.`doctorname`
`appointment`.`room_id`
`appointment`.`live_meeting_link`
`appointment`.`cron_job`
`appointment`.`hospital_id`
`appointment`.`app_time`
`appointment`.`app_time_full_format`
`appointment`.`payment_status`
`appointment`.`visit_description`
`appointment`.`visit_charges`
`appointment`.`payment_id`
`appointment`.`discount`
`appointment`.`grand_total`
`attendance`.*
`attendance`.`id`
`attendance`.`staff`
`attendance`.`month`
`attendance`.`year`
`attendance`.`log`
`attendance`.`details`
`autoemailshortcode`.*
`autoemailshortcode`.`id`
`autoemailshortcode`.`name`
`autoemailshortcode`.`type`
`autoemailtemplate`.*
`autoemailtemplate`.`id`
`autoemailtemplate`.`name`
`autoemailtemplate`.`message`
`autoemailtemplate`.`type`
`autoemailtemplate`.`status`
`autoemailtemplate`.`hospital_id`
`autosmsshortcode`.*
`autosmsshortcode`.`id`
`autosmsshortcode`.`name`
`autosmsshortcode`.`type`
`autosmstemplate`.*
`autosmstemplate`.`id`
`autosmstemplate`.`name`
`autosmstemplate`.`message`
`autosmstemplate`.`type`
`autosmstemplate`.`status`
`autosmstemplate`.`hospital_id`
`bankb`.*
`bankb`.`id`
`bankb`.`group`
`bankb`.`status`
`bankb`.`hospital_id`
`bed`.*
`bed`.`id`
`bed`.`category`
`bed`.`number`
`bed`.`description`
`bed`.`last_a_time`
`bed`.`last_d_time`
`bed`.`status`
`bed`.`bed_id`
`bed`.`hospital_id`
`bed_category`.*
`bed_category`.`id`
`bed_category`.`category`
`bed_category`.`description`
`bed_category`.`hospital_id`
`bed_checkout`.*
`bed_checkout`.`id`
`bed_checkout`.`date`
`bed_checkout`.`final_diagnosis`
`bed_checkout`.`anatomopatologic_diagnosis`
`bed_checkout`.`dikordance`
`bed_checkout`.`alloted_bed_id`
`bed_checkout`.`doctor`
`bed_checkout`.`epicrisis`
`bed_checkout`.`checkout_state`
`bed_checkout`.`checkout_diagnosis`
`bed_checkout`.`instruction`
`bed_checkout`.`medicine_to_take`
`bed_checkout`.`hospital_id`
`bed_medicine`.*
`bed_medicine`.`id`
`bed_medicine`.`generic_name`
`bed_medicine`.`medicine_name`
`bed_medicine`.`medicine_id`
`bed_medicine`.`s_price`
`bed_medicine`.`hospital_id`
`bed_medicine`.`quantity`
`bed_medicine`.`total`
`bed_medicine`.`alloted_bed_id`
`bed_medicine`.`date`
`bed_medicine`.`payment_id`
`bed_medicine`.`medicine_pharmacy_id`
`bed_service`.*
`bed_service`.`id`
`bed_service`.`date`
`bed_service`.`nurse`
`bed_service`.`service`
`bed_service`.`price`
`bed_service`.`alloted_bed_id`
`bed_service`.`payment_id`
`bed_service`.`hospital_id`
`blood_group`.*
`blood_group`.`id`
`blood_group`.`bloodgroup`
`category`.*
`category`.`id`
`category`.`category`
`category`.`description`
`category`.`hospital_id`
`chat`.*
`chat`.`id`
`chat`.`sender_id`
`chat`.`receiver_id`
`chat`.`chat_text`
`chat`.`status`
`chat`.`date_time`
`chat`.`chat_group_id`
`chat_group`.*
`chat_group`.`id`
`chat_group`.`title`
`chat_group`.`employee`
`chat_group`.`hospital_id`
`daily_progress`.*
`daily_progress`.`id`
`daily_progress`.`date`
`daily_progress`.`datestamp`
`daily_progress`.`daily_description`
`daily_progress`.`description`
`daily_progress`.`alloted_bed_id`
`daily_progress`.`hospital_id`
`daily_progress`.`time`
`daily_progress`.`nurse`
`department`.*
`department`.`id`
`department`.`name`
`department`.`description`
`department`.`x`
`department`.`y`
`department`.`hospital_id`
`diagnostic_report`.*
`diagnostic_report`.`id`
`diagnostic_report`.`date`
`diagnostic_report`.`invoice`
`diagnostic_report`.`report`
`diagnostic_report`.`status`
`diagnostic_report`.`hospital_id`
`doctor`.*
`doctor`.`id`
`doctor`.`img_url`
`doctor`.`name`
`doctor`.`email`
`doctor`.`address`
`doctor`.`phone`
`doctor`.`department`
`doctor`.`profile`
`doctor`.`x`
`doctor`.`y`
`doctor`.`ion_user_id`
`doctor`.`hospital_id`
`doctor`.`department_name`
`doctor`.`appointment_confirmation`
`doctor`.`signature`
`doctor_visit`.*
`doctor_visit`.`id`
`doctor_visit`.`doctor_id`
`doctor_visit`.`doctor_name`
`doctor_visit`.`visit_description`
`doctor_visit`.`visit_charges`
`doctor_visit`.`status`
`doctor_visit`.`hospital_id`
`donor`.*
`donor`.`id`
`donor`.`name`
`donor`.`group`
`donor`.`age`
`donor`.`sex`
`donor`.`ldd`
`donor`.`phone`
`donor`.`email`
`donor`.`add_date`
`donor`.`hospital_id`
`draft_payment`.*
`draft_payment`.`id`
`draft_payment`.`category_name`
`draft_payment`.`patient`
`draft_payment`.`date`
`draft_payment`.`amount`
`draft_payment`.`doctor`
`draft_payment`.`discount`
`draft_payment`.`flat_discount`
`draft_payment`.`gross_total`
`draft_payment`.`user`
`draft_payment`.`patient_name`
`draft_payment`.`patient_phone`
`draft_payment`.`patient_address`
`draft_payment`.`patient_email`
`draft_payment`.`patient_gender`
`draft_payment`.`date_string`
`draft_payment`.`remarks`
`draft_payment`.`date_delivery`
`draft_payment`.`doctor_phone`
`draft_payment`.`age`
`draft_payment`.`birthdate`
`draft_payment`.`deposit_type`
`draft_payment`.`doctor_name`
`draft_payment`.`doctor_email`
`draft_payment`.`time_delivery`
`draft_payment`.`hospital_id`
`draft_payment`.`amount_received`
`draft_payment`.`vat`
`draft_payment`.`percent_discount`
`draft_payment`.`vat_amount_percent`
`email`.*
`email`.`id`
`email`.`subject`
`email`.`date`
`email`.`message`
`email`.`reciepient`
`email`.`user`
`email`.`hospital_id`
`email_settings`.*
`email_settings`.`id`
`email_settings`.`admin_email`
`email_settings`.`type`
`email_settings`.`user`
`email_settings`.`password`
`email_settings`.`hospital_id`
`email_settings`.`smtp_host`
`email_settings`.`smtp_port`
`email_settings`.`send_multipart`
`email_settings`.`mail_provider`
`expense`.*
`expense`.`id`
`expense`.`category`
`expense`.`date`
`expense`.`note`
`expense`.`amount`
`expense`.`user`
`expense`.`datestring`
`expense`.`hospital_id`
`expense_category`.*
`expense_category`.`id`
`expense_category`.`category`
`expense_category`.`description`
`expense_category`.`x`
`expense_category`.`y`
`expense_category`.`hospital_id`
`featured`.*
`featured`.`id`
`featured`.`img_url`
`featured`.`name`
`featured`.`profile`
`featured`.`description`
`featured`.`hospital_id`
`file`.*
`file`.`id`
`file`.`title`
`file`.`img_url`
`file`.`module`
`file`.`hospital_id`
`folder`.*
`folder`.`id`
`folder`.`folder_name`
`folder`.`patient`
`folder`.`add_date`
`folder`.`folder_path`
`folder`.`hospital_id`
`gallery`.*
`gallery`.`id`
`gallery`.`img`
`gallery`.`position`
`gallery`.`status`
`google_captcha`.*
`google_captcha`.`id`
`google_captcha`.`site_key`
`google_captcha`.`secret_key`
`google_captcha`.`hospital_id`
`grid`.*
`grid`.`id`
`grid`.`category`
`grid`.`title`
`grid`.`description`
`grid`.`img`
`grid`.`position`
`grid`.`status`
`groups`.*
`groups`.`id`
`groups`.`name`
`groups`.`description`
`holidays`.*
`holidays`.`id`
`holidays`.`doctor`
`holidays`.`date`
`holidays`.`x`
`holidays`.`y`
`holidays`.`hospital_id`
`hospital`.*
`hospital`.`id`
`hospital`.`name`
`hospital`.`email`
`hospital`.`password`
`hospital`.`address`
`hospital`.`phone`
`hospital`.`package`
`hospital`.`p_limit`
`hospital`.`d_limit`
`hospital`.`module`
`hospital`.`ion_user_id`
`hospital`.`country`
`hospital`.`from_where`
`hospital_deposit`.*
`hospital_deposit`.`id`
`hospital_deposit`.`payment_id`
`hospital_deposit`.`date`
`hospital_deposit`.`deposited_amount`
`hospital_deposit`.`deposited_amount_id`
`hospital_deposit`.`gateway`
`hospital_deposit`.`hospital_user_id`
`hospital_deposit`.`next_due_date_stamp`
`hospital_deposit`.`next_due_date`
`hospital_deposit`.`add_date_stamp`
`hospital_deposit`.`add_date`
`hospital_payment`.*
`hospital_payment`.`id`
`hospital_payment`.`hospital_user_id`
`hospital_payment`.`price`
`hospital_payment`.`package_duration`
`hospital_payment`.`next_due_date_stamp`
`hospital_payment`.`next_due_date`
`hospital_payment`.`add_date_stamp`
`hospital_payment`.`add_date`
`hospital_payment`.`package`
`hospital_payment`.`status`
`lab`.*
`lab`.`id`
`lab`.`category`
`lab`.`patient`
`lab`.`doctor`
`lab`.`date`
`lab`.`category_name`
`lab`.`report`
`lab`.`status`
`lab`.`user`
`lab`.`patient_name`
`lab`.`patient_phone`
`lab`.`patient_address`
`lab`.`doctor_name`
`lab`.`date_string`
`lab`.`hospital_id`
`lab`.`invoice_id`
`lab`.`category_id`
`lab`.`test_status`
`lab`.`test_status_date`
`lab`.`delivery_status`
`lab`.`delivery_status_date`
`lab`.`receiver_name`
`lab`.`updated_on`
`lab`.`reported_by`
`lab`.`done_by`
`lab`.`signed_by`
`lab_category`.*
`lab_category`.`id`
`lab_category`.`category`
`lab_category`.`description`
`lab_category`.`reference_value`
`lab_category`.`hospital_id`
`laboratorist`.*
`laboratorist`.`id`
`laboratorist`.`img_url`
`laboratorist`.`name`
`laboratorist`.`email`
`laboratorist`.`address`
`laboratorist`.`phone`
`laboratorist`.`x`
`laboratorist`.`y`
`laboratorist`.`ion_user_id`
`laboratorist`.`hospital_id`
`laboratorist`.`profile`
`laboratorist`.`signature`
`leave_type`.*
`leave_type`.`id`
`leave_type`.`name`
`leave_type`.`status`
`leave_type`.`hospital_id`
`leaves`.*
`leaves`.`id`
`leaves`.`type`
`leaves`.`duration`
`leaves`.`date`
`leaves`.`staff`
`leaves`.`reason`
`leaves`.`status`
`leaves`.`hospital_id`
`leaves`.`created_on`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`ip_address`
`login_attempts`.`login`
`login_attempts`.`time`
`logs`.*
`logs`.`id`
`logs`.`name`
`logs`.`email`
`logs`.`role`
`logs`.`ip_address`
`logs`.`hospital_id`
`logs`.`date_time`
`macro`.*
`macro`.`id`
`macro`.`short_name`
`macro`.`description`
`macro`.`created_by`
`macro`.`created_by_name`
`macro`.`date_time`
`macro`.`hospital_id`
`manual_email_template`.*
`manual_email_template`.`id`
`manual_email_template`.`name`
`manual_email_template`.`message`
`manual_email_template`.`type`
`manual_email_template`.`hospital_id`
`manual_email_template`.`added_by`
`manual_sms_template`.*
`manual_sms_template`.`id`
`manual_sms_template`.`name`
`manual_sms_template`.`message`
`manual_sms_template`.`type`
`manual_sms_template`.`hospital_id`
`manualemailshortcode`.*
`manualemailshortcode`.`id`
`manualemailshortcode`.`name`
`manualemailshortcode`.`type`
`manualsmsshortcode`.*
`manualsmsshortcode`.`id`
`manualsmsshortcode`.`name`
`manualsmsshortcode`.`type`
`medical_history`.*
`medical_history`.`id`
`medical_history`.`patient_id`
`medical_history`.`title`
`medical_history`.`description`
`medical_history`.`patient_name`
`medical_history`.`patient_address`
`medical_history`.`patient_phone`
`medical_history`.`img_url`
`medical_history`.`date`
`medical_history`.`registration_time`
`medical_history`.`hospital_id`
`medicine`.*
`medicine`.`id`
`medicine`.`name`
`medicine`.`category`
`medicine`.`price`
`medicine`.`box`
`medicine`.`s_price`
`medicine`.`quantity`
`medicine`.`generic`
`medicine`.`company`
`medicine`.`effects`
`medicine`.`e_date`
`medicine`.`add_date`
`medicine`.`hospital_id`
`medicine_category`.*
`medicine_category`.`id`
`medicine_category`.`category`
`medicine_category`.`description`
`medicine_category`.`hospital_id`
`meeting`.*
`meeting`.`id`
`meeting`.`patient`
`meeting`.`doctor`
`meeting`.`topic`
`meeting`.`type`
`meeting`.`start_time`
`meeting`.`duration`
`meeting`.`timezone`
`meeting`.`meeting_id`
`meeting`.`meeting_password`
`meeting`.`date`
`meeting`.`time_slot`
`meeting`.`s_time`
`meeting`.`e_time`
`meeting`.`remarks`
`meeting`.`add_date`
`meeting`.`registration_time`
`meeting`.`s_time_key`
`meeting`.`status`
`meeting`.`user`
`meeting`.`request`
`meeting`.`patientname`
`meeting`.`doctorname`
`meeting`.`ion_user_id`
`meeting`.`doctor_ion_id`
`meeting`.`patient_ion_id`
`meeting`.`hospital_id`
`meeting_settings`.*
`meeting_settings`.`id`
`meeting_settings`.`api_key`
`meeting_settings`.`secret_key`
`meeting_settings`.`ion_user_id`
`meeting_settings`.`y`
`meeting_settings`.`hospital_id`
`module`.*
`module`.`id`
`module`.`hospital_id`
`module`.`modules`
`module`.`x`
`module`.`y`
`notice`.*
`notice`.`id`
`notice`.`title`
`notice`.`description`
`notice`.`date`
`notice`.`type`
`notice`.`hospital_id`
`nurse`.*
`nurse`.`id`
`nurse`.`img_url`
`nurse`.`name`
`nurse`.`email`
`nurse`.`address`
`nurse`.`phone`
`nurse`.`x`
`nurse`.`y`
`nurse`.`z`
`nurse`.`ion_user_id`
`nurse`.`hospital_id`
`nurse`.`profile`
`nurse`.`signature`
`odontogram`.*
`odontogram`.`id`
`odontogram`.`patient_id`
`odontogram`.`Tooth32`
`odontogram`.`Tooth31`
`odontogram`.`Tooth30`
`odontogram`.`Tooth29`
`odontogram`.`Tooth28`
`odontogram`.`Tooth27`
`odontogram`.`Tooth26`
`odontogram`.`Tooth25`
`odontogram`.`Tooth24`
`odontogram`.`Tooth23`
`odontogram`.`Tooth22`
`odontogram`.`Tooth21`
`odontogram`.`Tooth20`
`odontogram`.`Tooth19`
`odontogram`.`Tooth18`
`odontogram`.`Tooth17`
`odontogram`.`Tooth16`
`odontogram`.`Tooth15`
`odontogram`.`Tooth14`
`odontogram`.`Tooth13`
`odontogram`.`Tooth12`
`odontogram`.`Tooth11`
`odontogram`.`Tooth10`
`odontogram`.`Tooth9`
`odontogram`.`Tooth8`
`odontogram`.`Tooth7`
`odontogram`.`Tooth6`
`odontogram`.`Tooth5`
`odontogram`.`Tooth4`
`odontogram`.`Tooth3`
`odontogram`.`Tooth2`
`odontogram`.`Tooth1`
`odontogram`.`description`
`ot_payment`.*
`ot_payment`.`id`
`ot_payment`.`patient`
`ot_payment`.`doctor_c_s`
`ot_payment`.`doctor_a_s_1`
`ot_payment`.`doctor_a_s_2`
`ot_payment`.`doctor_anaes`
`ot_payment`.`n_o_o`
`ot_payment`.`c_s_f`
`ot_payment`.`a_s_f_1`
`ot_payment`.`a_s_f_2`
`ot_payment`.`anaes_f`
`ot_payment`.`ot_charge`
`ot_payment`.`cab_rent`
`ot_payment`.`seat_rent`
`ot_payment`.`others`
`ot_payment`.`discount`
`ot_payment`.`date`
`ot_payment`.`amount`
`ot_payment`.`doctor_fees`
`ot_payment`.`hospital_fees`
`ot_payment`.`gross_total`
`ot_payment`.`flat_discount`
`ot_payment`.`amount_received`
`ot_payment`.`status`
`ot_payment`.`user`
`ot_payment`.`hospital_id`
`package`.*
`package`.`id`
`package`.`name`
`package`.`monthly_price`
`package`.`p_limit`
`package`.`d_limit`
`package`.`module`
`package`.`show_in_frontend`
`package`.`frontend_order`
`package`.`set_as_default`
`package`.`yearly_price`
`package`.`recommended`
`patient`.*
`patient`.`id`
`patient`.`img_url`
`patient`.`name`
`patient`.`email`
`patient`.`doctor`
`patient`.`address`
`patient`.`phone`
`patient`.`sex`
`patient`.`disease`
`patient`.`birthdate`
`patient`.`age`
`patient`.`bloodgroup`
`patient`.`ion_user_id`
`patient`.`patient_id`
`patient`.`add_date`
`patient`.`registration_time`
`patient`.`how_added`
`patient`.`hospital_id`
`patient`.`appointment_confirmation`
`patient`.`appointment_creation`
`patient`.`payment_confirmation`
`patient`.`meeting_schedule`
`patient`.`body_mass_index`
`patient`.`weight`
`patient`.`height`
`patient`.`habits`
`patient`.`do_you_use_tobacco`
`patient`.`do_you_use_alcohol`
`patient`.`do_you_use_drugs`
`patient`.`physical_activity`
`patient`.`allergies`
`patient`.`cardiovascular_risk_factors`
`patient`.`previous_illnesses`
`patient`.`are_you_on_medication`
`patient`.`surgical_interventions`
`patient`.`vaccination_status`
`patient`.`family_history`
`patient`.`marital_status`
`patient`.`children`
`patient`.`morbid_history`
`patient`.`diseases`
`patient`.`nutrition`
`patient`.`emotional_status`
`patient`.`reproductive_status`
`patient`.`date_of_last_menstrual_period`
`patient`.`date_of_last_gynecological_examination`
`patient`.`pregnancies`
`patient`.`contraceptive_method`
`patient`.`previous_jobs`
`patient`.`length_of_last_employment`
`patient`.`risk_factors_for_last_employment`
`patient`.`hours_covered_for_last_employment`
`patient`.`current_position`
`patient`.`seniority_of_current_position`
`patient`.`current_risk_factors`
`patient`.`schedule_of_current_position`
`patient`.`days_off_from_current_position`
`patient`.`custom_fields`
`patient_deposit`.*
`patient_deposit`.`id`
`patient_deposit`.`patient`
`patient_deposit`.`payment_id`
`patient_deposit`.`date`
`patient_deposit`.`deposited_amount`
`patient_deposit`.`amount_received_id`
`patient_deposit`.`deposit_type`
`patient_deposit`.`gateway`
`patient_deposit`.`user`
`patient_deposit`.`hospital_id`
`patient_deposit`.`payment_from`
`patient_material`.*
`patient_material`.`id`
`patient_material`.`date`
`patient_material`.`title`
`patient_material`.`category`
`patient_material`.`patient`
`patient_material`.`patient_name`
`patient_material`.`patient_address`
`patient_material`.`patient_phone`
`patient_material`.`url`
`patient_material`.`date_string`
`patient_material`.`hospital_id`
`patient_material`.`folder`
`patient_material`.`type`
`payment`.*
`payment`.`id`
`payment`.`category`
`payment`.`patient`
`payment`.`doctor`
`payment`.`date`
`payment`.`amount`
`payment`.`vat`
`payment`.`x_ray`
`payment`.`flat_vat`
`payment`.`discount`
`payment`.`flat_discount`
`payment`.`gross_total`
`payment`.`remarks`
`payment`.`hospital_amount`
`payment`.`doctor_amount`
`payment`.`category_amount`
`payment`.`category_name`
`payment`.`amount_received`
`payment`.`deposit_type`
`payment`.`status`
`payment`.`user`
`payment`.`patient_name`
`payment`.`patient_phone`
`payment`.`patient_address`
`payment`.`doctor_name`
`payment`.`date_string`
`payment`.`hospital_id`
`payment`.`payment_from`
`payment`.`date_delivery`
`payment`.`time_delivery`
`payment`.`percent_discount`
`payment`.`vat_amount_percent`
`payment`.`appointment_id`
`payment_category`.*
`payment_category`.`id`
`payment_category`.`category`
`payment_category`.`description`
`payment_category`.`c_price`
`payment_category`.`type`
`payment_category`.`d_commission`
`payment_category`.`h_commission`
`payment_category`.`hospital_id`
`payment_category`.`code`
`payment_category`.`payment_category`
`payment_category`.`payment_category_name`
`payment_category`.`report`
`paymentgateway`.*
`paymentgateway`.`id`
`paymentgateway`.`name`
`paymentgateway`.`merchant_key`
`paymentgateway`.`salt`
`paymentgateway`.`x`
`paymentgateway`.`y`
`paymentgateway`.`APIUsername`
`paymentgateway`.`APIPassword`
`paymentgateway`.`APISignature`
`paymentgateway`.`status`
`paymentgateway`.`publish`
`paymentgateway`.`secret`
`paymentgateway`.`hospital_id`
`paymentgateway`.`public_key`
`payroll`.*
`payroll`.`id`
`payroll`.`staff`
`payroll`.`month`
`payroll`.`year`
`payroll`.`paid_on`
`payroll`.`expense`
`payroll`.`earning`
`payroll`.`deduction`
`payroll`.`status`
`payroll`.`hospital_id`
`pharmacist`.*
`pharmacist`.`id`
`pharmacist`.`img_url`
`pharmacist`.`name`
`pharmacist`.`email`
`pharmacist`.`address`
`pharmacist`.`phone`
`pharmacist`.`x`
`pharmacist`.`y`
`pharmacist`.`ion_user_id`
`pharmacist`.`hospital_id`
`pharmacist`.`profile`
`pharmacist`.`signature`
`pharmacy_expense`.*
`pharmacy_expense`.`id`
`pharmacy_expense`.`category`
`pharmacy_expense`.`date`
`pharmacy_expense`.`amount`
`pharmacy_expense`.`user`
`pharmacy_expense`.`hospital_id`
`pharmacy_expense_category`.*
`pharmacy_expense_category`.`id`
`pharmacy_expense_category`.`category`
`pharmacy_expense_category`.`description`
`pharmacy_expense_category`.`x`
`pharmacy_expense_category`.`y`
`pharmacy_expense_category`.`hospital_id`
`pharmacy_payment`.*
`pharmacy_payment`.`id`
`pharmacy_payment`.`category`
`pharmacy_payment`.`patient`
`pharmacy_payment`.`doctor`
`pharmacy_payment`.`date`
`pharmacy_payment`.`amount`
`pharmacy_payment`.`vat`
`pharmacy_payment`.`x_ray`
`pharmacy_payment`.`flat_vat`
`pharmacy_payment`.`discount`
`pharmacy_payment`.`flat_discount`
`pharmacy_payment`.`gross_total`
`pharmacy_payment`.`hospital_amount`
`pharmacy_payment`.`doctor_amount`
`pharmacy_payment`.`category_amount`
`pharmacy_payment`.`category_name`
`pharmacy_payment`.`amount_received`
`pharmacy_payment`.`status`
`pharmacy_payment`.`hospital_id`
`pharmacy_payment_category`.*
`pharmacy_payment_category`.`id`
`pharmacy_payment_category`.`category`
`pharmacy_payment_category`.`description`
`pharmacy_payment_category`.`c_price`
`pharmacy_payment_category`.`d_commission`
`pharmacy_payment_category`.`h_commission`
`pharmacy_payment_category`.`hospital_id`
`prescription`.*
`prescription`.`id`
`prescription`.`date`
`prescription`.`patient`
`prescription`.`doctor`
`prescription`.`symptom`
`prescription`.`advice`
`prescription`.`state`
`prescription`.`dd`
`prescription`.`medicine`
`prescription`.`validity`
`prescription`.`note`
`prescription`.`patientname`
`prescription`.`doctorname`
`prescription`.`signed_by`
`prescription`.`hospital_id`
`pservice`.*
`pservice`.`id`
`pservice`.`name`
`pservice`.`code`
`pservice`.`alpha_code`
`pservice`.`price`
`pservice`.`active`
`pservice`.`hospital_id`
`receptionist`.*
`receptionist`.`id`
`receptionist`.`img_url`
`receptionist`.`name`
`receptionist`.`email`
`receptionist`.`address`
`receptionist`.`phone`
`receptionist`.`x`
`receptionist`.`ion_user_id`
`receptionist`.`hospital_id`
`receptionist`.`signature`
`receptionist`.`profile`
`report`.*
`report`.`id`
`report`.`report_type`
`report`.`patient`
`report`.`description`
`report`.`doctor`
`report`.`date`
`report`.`add_date`
`report`.`hospital_id`
`request`.*
`request`.`id`
`request`.`name`
`request`.`address`
`request`.`email`
`request`.`phone`
`request`.`other`
`request`.`package`
`request`.`language`
`request`.`remarks`
`request`.`status`
`review`.*
`review`.`id`
`review`.`name`
`review`.`designation`
`review`.`review`
`review`.`img`
`review`.`status`
`salary`.*
`salary`.`id`
`salary`.`staff`
`salary`.`salary`
`salary`.`hospital_id`
`service`.*
`service`.`id`
`service`.`img_url`
`service`.`title`
`service`.`description`
`settings`.*
`settings`.`id`
`settings`.`system_vendor`
`settings`.`title`
`settings`.`address`
`settings`.`phone`
`settings`.`email`
`settings`.`facebook_id`
`settings`.`currency`
`settings`.`language`
`settings`.`discount`
`settings`.`live_appointment_type`
`settings`.`vat`
`settings`.`login_title`
`settings`.`logo`
`settings`.`invoice_logo`
`settings`.`payment_gateway`
`settings`.`sms_gateway`
`settings`.`codec_username`
`settings`.`codec_purchase_code`
`settings`.`hospital_id`
`settings`.`emailtype`
`settings`.`remainder_appointment`
`settings`.`footer_message`
`settings`.`show_odontogram_in_history`
`settings`.`invoice_choose`
`settings`.`discount_percent`
`settings`.`footer_invoice_message`
`single_website_settings`.*
`single_website_settings`.`id`
`single_website_settings`.`title`
`single_website_settings`.`description`
`single_website_settings`.`logo`
`single_website_settings`.`address`
`single_website_settings`.`phone`
`single_website_settings`.`emergency`
`single_website_settings`.`support`
`single_website_settings`.`email`
`single_website_settings`.`currency`
`single_website_settings`.`block_1_text_under_title`
`single_website_settings`.`service_block__text_under_title`
`single_website_settings`.`doctor_block__text_under_title`
`single_website_settings`.`facebook_id`
`single_website_settings`.`twitter_id`
`single_website_settings`.`google_id`
`single_website_settings`.`youtube_id`
`single_website_settings`.`skype_id`
`single_website_settings`.`x`
`single_website_settings`.`twitter_username`
`single_website_settings`.`appointment_title`
`single_website_settings`.`appointment_subtitle`
`single_website_settings`.`appointment_description`
`single_website_settings`.`appointment_img_url`
`single_website_settings`.`url_hospital`
`single_website_settings`.`hospital_id`
`site_gallery`.*
`site_gallery`.`id`
`site_gallery`.`img`
`site_gallery`.`position`
`site_gallery`.`status`
`site_gallery`.`hospital_id`
`site_grid`.*
`site_grid`.`id`
`site_grid`.`category`
`site_grid`.`title`
`site_grid`.`description`
`site_grid`.`img`
`site_grid`.`position`
`site_grid`.`status`
`site_grid`.`hospital_id`
`site_map`.*
`site_map`.`id`
`site_map`.`name`
`site_map`.`url`
`site_map`.`for_login`
`site_review`.*
`site_review`.`id`
`site_review`.`name`
`site_review`.`designation`
`site_review`.`review`
`site_review`.`img`
`site_review`.`status`
`site_review`.`hospital_id`
`site_service`.*
`site_service`.`id`
`site_service`.`img_url`
`site_service`.`title`
`site_service`.`description`
`site_service`.`hospital_id`
`site_slide`.*
`site_slide`.`id`
`site_slide`.`title`
`site_slide`.`img_url`
`site_slide`.`text1`
`site_slide`.`text2`
`site_slide`.`text3`
`site_slide`.`position`
`site_slide`.`status`
`site_slide`.`hospital_id`
`slide`.*
`slide`.`id`
`slide`.`title`
`slide`.`img_url`
`slide`.`text1`
`slide`.`text2`
`slide`.`text3`
`slide`.`position`
`slide`.`status`
`sms`.*
`sms`.`id`
`sms`.`date`
`sms`.`message`
`sms`.`recipient`
`sms`.`user`
`sms`.`hospital_id`
`sms_settings`.*
`sms_settings`.`id`
`sms_settings`.`name`
`sms_settings`.`username`
`sms_settings`.`password`
`sms_settings`.`api_id`
`sms_settings`.`sender`
`sms_settings`.`authkey`
`sms_settings`.`user`
`sms_settings`.`sid`
`sms_settings`.`token`
`sms_settings`.`sendernumber`
`sms_settings`.`hospital_id`
`sms_settings`.`email`
`sms_settings`.`sender_name`
`superadmin`.*
`superadmin`.`id`
`superadmin`.`name`
`superadmin`.`email`
`superadmin`.`phone`
`superadmin`.`address`
`superadmin`.`img_url`
`superadmin`.`ion_user_id`
`superadmin`.`module`
`template`.*
`template`.`id`
`template`.`name`
`template`.`template`
`template`.`user`
`template`.`x`
`template`.`hospital_id`
`template`.`category_id`
`time_schedule`.*
`time_schedule`.`id`
`time_schedule`.`doctor`
`time_schedule`.`weekday`
`time_schedule`.`s_time`
`time_schedule`.`e_time`
`time_schedule`.`s_time_key`
`time_schedule`.`duration`
`time_schedule`.`hospital_id`
`time_slot`.*
`time_slot`.`id`
`time_slot`.`doctor`
`time_slot`.`s_time`
`time_slot`.`e_time`
`time_slot`.`weekday`
`time_slot`.`s_time_key`
`time_slot`.`hospital_id`
`transaction_logs`.*
`transaction_logs`.`id`
`transaction_logs`.`date_time`
`transaction_logs`.`invoice_id`
`transaction_logs`.`patientname`
`transaction_logs`.`deposit_type`
`transaction_logs`.`payment_gateway`
`transaction_logs`.`action`
`transaction_logs`.`hospital_id`
`transaction_logs`.`amount`
`transaction_logs`.`user`
`users`.*
`users`.`id`
`users`.`ip_address`
`users`.`username`
`users`.`password`
`users`.`salt`
`users`.`email`
`users`.`activation_code`
`users`.`forgotten_password_code`
`users`.`forgotten_password_time`
`users`.`remember_code`
`users`.`created_on`
`users`.`last_login`
`users`.`active`
`users`.`first_name`
`users`.`last_name`
`users`.`company`
`users`.`phone`
`users`.`hospital_ion_id`
`users_groups`.*
`users_groups`.`id`
`users_groups`.`user_id`
`users_groups`.`group_id`
`vital_signs`.*
`vital_signs`.`id`
`vital_signs`.`patient_id`
`vital_signs`.`bmi_height`
`vital_signs`.`bmi_weight`
`vital_signs`.`respiratory_rate`
`vital_signs`.`oxygen_saturation`
`vital_signs`.`temperature`
`vital_signs`.`diastolic_blood_pressure`
`vital_signs`.`systolic_blood_pressure`
`vital_signs`.`add_date_time`
`vital_signs`.`heart_rate`
`vital_signs`.`hospital_id`
`website_settings`.*
`website_settings`.`id`
`website_settings`.`title`
`website_settings`.`logo`
`website_settings`.`address`
`website_settings`.`phone`
`website_settings`.`emergency`
`website_settings`.`support`
`website_settings`.`email`
`website_settings`.`currency`
`website_settings`.`block_1_text_under_title`
`website_settings`.`service_block__text_under_title`
`website_settings`.`doctor_block__text_under_title`
`website_settings`.`facebook_id`
`website_settings`.`twitter_id`
`website_settings`.`google_id`
`website_settings`.`youtube_id`
`website_settings`.`skype_id`
`website_settings`.`x`
`website_settings`.`twitter_username`
`website_settings`.`block_img_url`
`website_settings`.`comment_1`
`website_settings`.`comment_2`
`website_settings`.`verified_1`
`website_settings`.`verified_2`
`website_settings`.`comment_logo_1`
`website_settings`.`comment_logo_2`
`website_settings`.`partner_header_title`
`website_settings`.`partner_header_description`
`website_settings`.`section_title_1`
`website_settings`.`section_title_2`
`website_settings`.`section_title_3`
`website_settings`.`section_description_1`
`website_settings`.`section_description_2`
`website_settings`.`section_description_3`
`website_settings`.`section_1_text_1`
`website_settings`.`section_2_text_1`
`website_settings`.`section_3_text_1`
`website_settings`.`section_1_text_2`
`website_settings`.`section_2_text_2`
`website_settings`.`section_3_text_2`
`website_settings`.`section_1_text_3`
`website_settings`.`section_2_text_3`
`website_settings`.`section_3_text_3`
`website_settings`.`partner_image_1`
`website_settings`.`partner_image_2`
`website_settings`.`partner_image_3`
`website_settings`.`market_title`
`website_settings`.`market_description`
`website_settings`.`market_button_link`
`website_settings`.`market_image`
`website_settings`.`market_commentator_name`
`website_settings`.`market_commentator_designation`
`website_settings`.`market_comment`
`website_settings`.`commentator_profile_image`
`website_settings`.`commentator_logo_1`
`website_settings`.`commentator_logo_2`
`website_settings`.`commentator_logo_3`
`website_settings`.`team_title`
`website_settings`.`team_description`
`website_settings`.`team_button_link`
`website_settings`.`team_commentator_name`
`website_settings`.`team_commentator_designation`
`website_settings`.`team_comment`
`website_settings`.`team_verified`
`website_settings`.`team_review_logo`
`website_settings`.`team_commentator_image`
`website_settings`.`registration_block_text`
`website_settings`.`contact_us`
`website_settings`.`contact_us_email`
`website_settings`.`chat_js`
`accountant`.*
`accountant`.`id`
`accountant`.`img_url`
`accountant`.`name`
`accountant`.`email`
`accountant`.`address`
`accountant`.`phone`
`accountant`.`x`
`accountant`.`ion_user_id`
`accountant`.`hospital_id`
`accountant`.`signature`
`accountant`.`profile`
`alloted_bed`.*
`alloted_bed`.`id`
`alloted_bed`.`number`
`alloted_bed`.`category`
`alloted_bed`.`patient`
`alloted_bed`.`a_time`
`alloted_bed`.`d_time`
`alloted_bed`.`status`
`alloted_bed`.`x`
`alloted_bed`.`bed_id`
`alloted_bed`.`patientname`
`alloted_bed`.`category_status`
`alloted_bed`.`reaksione`
`alloted_bed`.`covid_19`
`alloted_bed`.`transferred_from`
`alloted_bed`.`anamneza`
`alloted_bed`.`accepting_doctor`
`alloted_bed`.`doctor`
`alloted_bed`.`diagnosis`
`alloted_bed`.`diagnoza_a_shtrimit`
`alloted_bed`.`blood_group`
`alloted_bed`.`other_illnesses`
`alloted_bed`.`a_timestamp`
`alloted_bed`.`d_timestamp`
`alloted_bed`.`hospital_id`
`appointment`.*
`appointment`.`id`
`appointment`.`patient`
`appointment`.`doctor`
`appointment`.`date`
`appointment`.`time_slot`
`appointment`.`s_time`
`appointment`.`e_time`
`appointment`.`remarks`
`appointment`.`add_date`
`appointment`.`registration_time`
`appointment`.`s_time_key`
`appointment`.`status`
`appointment`.`user`
`appointment`.`request`
`appointment`.`patientname`
`appointment`.`doctorname`
`appointment`.`room_id`
`appointment`.`live_meeting_link`
`appointment`.`cron_job`
`appointment`.`hospital_id`
`appointment`.`app_time`
`appointment`.`app_time_full_format`
`appointment`.`payment_status`
`appointment`.`visit_description`
`appointment`.`visit_charges`
`appointment`.`payment_id`
`appointment`.`discount`
`appointment`.`grand_total`
`attendance`.*
`attendance`.`id`
`attendance`.`staff`
`attendance`.`month`
`attendance`.`year`
`attendance`.`log`
`attendance`.`details`
`autoemailshortcode`.*
`autoemailshortcode`.`id`
`autoemailshortcode`.`name`
`autoemailshortcode`.`type`
`autoemailtemplate`.*
`autoemailtemplate`.`id`
`autoemailtemplate`.`name`
`autoemailtemplate`.`message`
`autoemailtemplate`.`type`
`autoemailtemplate`.`status`
`autoemailtemplate`.`hospital_id`
`autosmsshortcode`.*
`autosmsshortcode`.`id`
`autosmsshortcode`.`name`
`autosmsshortcode`.`type`
`autosmstemplate`.*
`autosmstemplate`.`id`
`autosmstemplate`.`name`
`autosmstemplate`.`message`
`autosmstemplate`.`type`
`autosmstemplate`.`status`
`autosmstemplate`.`hospital_id`
`bankb`.*
`bankb`.`id`
`bankb`.`group`
`bankb`.`status`
`bankb`.`hospital_id`
`bed`.*
`bed`.`id`
`bed`.`category`
`bed`.`number`
`bed`.`description`
`bed`.`last_a_time`
`bed`.`last_d_time`
`bed`.`status`
`bed`.`bed_id`
`bed`.`hospital_id`
`bed_category`.*
`bed_category`.`id`
`bed_category`.`category`
`bed_category`.`description`
`bed_category`.`hospital_id`
`bed_checkout`.*
`bed_checkout`.`id`
`bed_checkout`.`date`
`bed_checkout`.`final_diagnosis`
`bed_checkout`.`anatomopatologic_diagnosis`
`bed_checkout`.`dikordance`
`bed_checkout`.`alloted_bed_id`
`bed_checkout`.`doctor`
`bed_checkout`.`epicrisis`
`bed_checkout`.`checkout_state`
`bed_checkout`.`checkout_diagnosis`
`bed_checkout`.`instruction`
`bed_checkout`.`medicine_to_take`
`bed_checkout`.`hospital_id`
`bed_medicine`.*
`bed_medicine`.`id`
`bed_medicine`.`generic_name`
`bed_medicine`.`medicine_name`
`bed_medicine`.`medicine_id`
`bed_medicine`.`s_price`
`bed_medicine`.`hospital_id`
`bed_medicine`.`quantity`
`bed_medicine`.`total`
`bed_medicine`.`alloted_bed_id`
`bed_medicine`.`date`
`bed_medicine`.`payment_id`
`bed_medicine`.`medicine_pharmacy_id`
`bed_service`.*
`bed_service`.`id`
`bed_service`.`date`
`bed_service`.`nurse`
`bed_service`.`service`
`bed_service`.`price`
`bed_service`.`alloted_bed_id`
`bed_service`.`payment_id`
`bed_service`.`hospital_id`
`blood_group`.*
`blood_group`.`id`
`blood_group`.`bloodgroup`
`category`.*
`category`.`id`
`category`.`category`
`category`.`description`
`category`.`hospital_id`
`chat`.*
`chat`.`id`
`chat`.`sender_id`
`chat`.`receiver_id`
`chat`.`chat_text`
`chat`.`status`
`chat`.`date_time`
`chat`.`chat_group_id`
`chat_group`.*
`chat_group`.`id`
`chat_group`.`title`
`chat_group`.`employee`
`chat_group`.`hospital_id`
`daily_progress`.*
`daily_progress`.`id`
`daily_progress`.`date`
`daily_progress`.`datestamp`
`daily_progress`.`daily_description`
`daily_progress`.`description`
`daily_progress`.`alloted_bed_id`
`daily_progress`.`hospital_id`
`daily_progress`.`time`
`daily_progress`.`nurse`
`department`.*
`department`.`id`
`department`.`name`
`department`.`description`
`department`.`x`
`department`.`y`
`department`.`hospital_id`
`diagnostic_report`.*
`diagnostic_report`.`id`
`diagnostic_report`.`date`
`diagnostic_report`.`invoice`
`diagnostic_report`.`report`
`diagnostic_report`.`status`
`diagnostic_report`.`hospital_id`
`doctor`.*
`doctor`.`id`
`doctor`.`img_url`
`doctor`.`name`
`doctor`.`email`
`doctor`.`address`
`doctor`.`phone`
`doctor`.`department`
`doctor`.`profile`
`doctor`.`x`
`doctor`.`y`
`doctor`.`ion_user_id`
`doctor`.`hospital_id`
`doctor`.`department_name`
`doctor`.`appointment_confirmation`
`doctor`.`signature`
`doctor_visit`.*
`doctor_visit`.`id`
`doctor_visit`.`doctor_id`
`doctor_visit`.`doctor_name`
`doctor_visit`.`visit_description`
`doctor_visit`.`visit_charges`
`doctor_visit`.`status`
`doctor_visit`.`hospital_id`
`donor`.*
`donor`.`id`
`donor`.`name`
`donor`.`group`
`donor`.`age`
`donor`.`sex`
`donor`.`ldd`
`donor`.`phone`
`donor`.`email`
`donor`.`add_date`
`donor`.`hospital_id`
`draft_payment`.*
`draft_payment`.`id`
`draft_payment`.`category_name`
`draft_payment`.`patient`
`draft_payment`.`date`
`draft_payment`.`amount`
`draft_payment`.`doctor`
`draft_payment`.`discount`
`draft_payment`.`flat_discount`
`draft_payment`.`gross_total`
`draft_payment`.`user`
`draft_payment`.`patient_name`
`draft_payment`.`patient_phone`
`draft_payment`.`patient_address`
`draft_payment`.`patient_email`
`draft_payment`.`patient_gender`
`draft_payment`.`date_string`
`draft_payment`.`remarks`
`draft_payment`.`date_delivery`
`draft_payment`.`doctor_phone`
`draft_payment`.`age`
`draft_payment`.`birthdate`
`draft_payment`.`deposit_type`
`draft_payment`.`doctor_name`
`draft_payment`.`doctor_email`
`draft_payment`.`time_delivery`
`draft_payment`.`hospital_id`
`draft_payment`.`amount_received`
`draft_payment`.`vat`
`draft_payment`.`percent_discount`
`draft_payment`.`vat_amount_percent`
`email`.*
`email`.`id`
`email`.`subject`
`email`.`date`
`email`.`message`
`email`.`reciepient`
`email`.`user`
`email`.`hospital_id`
`email_settings`.*
`email_settings`.`id`
`email_settings`.`admin_email`
`email_settings`.`type`
`email_settings`.`user`
`email_settings`.`password`
`email_settings`.`hospital_id`
`email_settings`.`smtp_host`
`email_settings`.`smtp_port`
`email_settings`.`send_multipart`
`email_settings`.`mail_provider`
`expense`.*
`expense`.`id`
`expense`.`category`
`expense`.`date`
`expense`.`note`
`expense`.`amount`
`expense`.`user`
`expense`.`datestring`
`expense`.`hospital_id`
`expense_category`.*
`expense_category`.`id`
`expense_category`.`category`
`expense_category`.`description`
`expense_category`.`x`
`expense_category`.`y`
`expense_category`.`hospital_id`
`featured`.*
`featured`.`id`
`featured`.`img_url`
`featured`.`name`
`featured`.`profile`
`featured`.`description`
`featured`.`hospital_id`
`file`.*
`file`.`id`
`file`.`title`
`file`.`img_url`
`file`.`module`
`file`.`hospital_id`
`folder`.*
`folder`.`id`
`folder`.`folder_name`
`folder`.`patient`
`folder`.`add_date`
`folder`.`folder_path`
`folder`.`hospital_id`
`gallery`.*
`gallery`.`id`
`gallery`.`img`
`gallery`.`position`
`gallery`.`status`
`google_captcha`.*
`google_captcha`.`id`
`google_captcha`.`site_key`
`google_captcha`.`secret_key`
`google_captcha`.`hospital_id`
`grid`.*
`grid`.`id`
`grid`.`category`
`grid`.`title`
`grid`.`description`
`grid`.`img`
`grid`.`position`
`grid`.`status`
`groups`.*
`groups`.`id`
`groups`.`name`
`groups`.`description`
`holidays`.*
`holidays`.`id`
`holidays`.`doctor`
`holidays`.`date`
`holidays`.`x`
`holidays`.`y`
`holidays`.`hospital_id`
`hospital`.*
`hospital`.`id`
`hospital`.`name`
`hospital`.`email`
`hospital`.`password`
`hospital`.`address`
`hospital`.`phone`
`hospital`.`package`
`hospital`.`p_limit`
`hospital`.`d_limit`
`hospital`.`module`
`hospital`.`ion_user_id`
`hospital`.`country`
`hospital`.`from_where`
`hospital_deposit`.*
`hospital_deposit`.`id`
`hospital_deposit`.`payment_id`
`hospital_deposit`.`date`
`hospital_deposit`.`deposited_amount`
`hospital_deposit`.`deposited_amount_id`
`hospital_deposit`.`gateway`
`hospital_deposit`.`hospital_user_id`
`hospital_deposit`.`next_due_date_stamp`
`hospital_deposit`.`next_due_date`
`hospital_deposit`.`add_date_stamp`
`hospital_deposit`.`add_date`
`hospital_payment`.*
`hospital_payment`.`id`
`hospital_payment`.`hospital_user_id`
`hospital_payment`.`price`
`hospital_payment`.`package_duration`
`hospital_payment`.`next_due_date_stamp`
`hospital_payment`.`next_due_date`
`hospital_payment`.`add_date_stamp`
`hospital_payment`.`add_date`
`hospital_payment`.`package`
`hospital_payment`.`status`
`lab`.*
`lab`.`id`
`lab`.`category`
`lab`.`patient`
`lab`.`doctor`
`lab`.`date`
`lab`.`category_name`
`lab`.`report`
`lab`.`status`
`lab`.`user`
`lab`.`patient_name`
`lab`.`patient_phone`
`lab`.`patient_address`
`lab`.`doctor_name`
`lab`.`date_string`
`lab`.`hospital_id`
`lab`.`invoice_id`
`lab`.`category_id`
`lab`.`test_status`
`lab`.`test_status_date`
`lab`.`delivery_status`
`lab`.`delivery_status_date`
`lab`.`receiver_name`
`lab`.`updated_on`
`lab`.`reported_by`
`lab`.`done_by`
`lab`.`signed_by`
`lab_category`.*
`lab_category`.`id`
`lab_category`.`category`
`lab_category`.`description`
`lab_category`.`reference_value`
`lab_category`.`hospital_id`
`laboratorist`.*
`laboratorist`.`id`
`laboratorist`.`img_url`
`laboratorist`.`name`
`laboratorist`.`email`
`laboratorist`.`address`
`laboratorist`.`phone`
`laboratorist`.`x`
`laboratorist`.`y`
`laboratorist`.`ion_user_id`
`laboratorist`.`hospital_id`
`laboratorist`.`profile`
`laboratorist`.`signature`
`leave_type`.*
`leave_type`.`id`
`leave_type`.`name`
`leave_type`.`status`
`leave_type`.`hospital_id`
`leaves`.*
`leaves`.`id`
`leaves`.`type`
`leaves`.`duration`
`leaves`.`date`
`leaves`.`staff`
`leaves`.`reason`
`leaves`.`status`
`leaves`.`hospital_id`
`leaves`.`created_on`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`ip_address`
`login_attempts`.`login`
`login_attempts`.`time`
`logs`.*
`logs`.`id`
`logs`.`name`
`logs`.`email`
`logs`.`role`
`logs`.`ip_address`
`logs`.`hospital_id`
`logs`.`date_time`
`macro`.*
`macro`.`id`
`macro`.`short_name`
`macro`.`description`
`macro`.`created_by`
`macro`.`created_by_name`
`macro`.`date_time`
`macro`.`hospital_id`
`manual_email_template`.*
`manual_email_template`.`id`
`manual_email_template`.`name`
`manual_email_template`.`message`
`manual_email_template`.`type`
`manual_email_template`.`hospital_id`
`manual_email_template`.`added_by`
`manual_sms_template`.*
`manual_sms_template`.`id`
`manual_sms_template`.`name`
`manual_sms_template`.`message`
`manual_sms_template`.`type`
`manual_sms_template`.`hospital_id`
`manualemailshortcode`.*
`manualemailshortcode`.`id`
`manualemailshortcode`.`name`
`manualemailshortcode`.`type`
`manualsmsshortcode`.*
`manualsmsshortcode`.`id`
`manualsmsshortcode`.`name`
`manualsmsshortcode`.`type`
`medical_history`.*
`medical_history`.`id`
`medical_history`.`patient_id`
`medical_history`.`title`
`medical_history`.`description`
`medical_history`.`patient_name`
`medical_history`.`patient_address`
`medical_history`.`patient_phone`
`medical_history`.`img_url`
`medical_history`.`date`
`medical_history`.`registration_time`
`medical_history`.`hospital_id`
`medicine`.*
`medicine`.`id`
`medicine`.`name`
`medicine`.`category`
`medicine`.`price`
`medicine`.`box`
`medicine`.`s_price`
`medicine`.`quantity`
`medicine`.`generic`
`medicine`.`company`
`medicine`.`effects`
`medicine`.`e_date`
`medicine`.`add_date`
`medicine`.`hospital_id`
`medicine_category`.*
`medicine_category`.`id`
`medicine_category`.`category`
`medicine_category`.`description`
`medicine_category`.`hospital_id`
`meeting`.*
`meeting`.`id`
`meeting`.`patient`
`meeting`.`doctor`
`meeting`.`topic`
`meeting`.`type`
`meeting`.`start_time`
`meeting`.`duration`
`meeting`.`timezone`
`meeting`.`meeting_id`
`meeting`.`meeting_password`
`meeting`.`date`
`meeting`.`time_slot`
`meeting`.`s_time`
`meeting`.`e_time`
`meeting`.`remarks`
`meeting`.`add_date`
`meeting`.`registration_time`
`meeting`.`s_time_key`
`meeting`.`status`
`meeting`.`user`
`meeting`.`request`
`meeting`.`patientname`
`meeting`.`doctorname`
`meeting`.`ion_user_id`
`meeting`.`doctor_ion_id`
`meeting`.`patient_ion_id`
`meeting`.`hospital_id`
`meeting_settings`.*
`meeting_settings`.`id`
`meeting_settings`.`api_key`
`meeting_settings`.`secret_key`
`meeting_settings`.`ion_user_id`
`meeting_settings`.`y`
`meeting_settings`.`hospital_id`
`module`.*
`module`.`id`
`module`.`hospital_id`
`module`.`modules`
`module`.`x`
`module`.`y`
`notice`.*
`notice`.`id`
`notice`.`title`
`notice`.`description`
`notice`.`date`
`notice`.`type`
`notice`.`hospital_id`
`nurse`.*
`nurse`.`id`
`nurse`.`img_url`
`nurse`.`name`
`nurse`.`email`
`nurse`.`address`
`nurse`.`phone`
`nurse`.`x`
`nurse`.`y`
`nurse`.`z`
`nurse`.`ion_user_id`
`nurse`.`hospital_id`
`nurse`.`profile`
`nurse`.`signature`
`odontogram`.*
`odontogram`.`id`
`odontogram`.`patient_id`
`odontogram`.`Tooth32`
`odontogram`.`Tooth31`
`odontogram`.`Tooth30`
`odontogram`.`Tooth29`
`odontogram`.`Tooth28`
`odontogram`.`Tooth27`
`odontogram`.`Tooth26`
`odontogram`.`Tooth25`
`odontogram`.`Tooth24`
`odontogram`.`Tooth23`
`odontogram`.`Tooth22`
`odontogram`.`Tooth21`
`odontogram`.`Tooth20`
`odontogram`.`Tooth19`
`odontogram`.`Tooth18`
`odontogram`.`Tooth17`
`odontogram`.`Tooth16`
`odontogram`.`Tooth15`
`odontogram`.`Tooth14`
`odontogram`.`Tooth13`
`odontogram`.`Tooth12`
`odontogram`.`Tooth11`
`odontogram`.`Tooth10`
`odontogram`.`Tooth9`
`odontogram`.`Tooth8`
`odontogram`.`Tooth7`
`odontogram`.`Tooth6`
`odontogram`.`Tooth5`
`odontogram`.`Tooth4`
`odontogram`.`Tooth3`
`odontogram`.`Tooth2`
`odontogram`.`Tooth1`
`odontogram`.`description`
`ot_payment`.*
`ot_payment`.`id`
`ot_payment`.`patient`
`ot_payment`.`doctor_c_s`
`ot_payment`.`doctor_a_s_1`
`ot_payment`.`doctor_a_s_2`
`ot_payment`.`doctor_anaes`
`ot_payment`.`n_o_o`
`ot_payment`.`c_s_f`
`ot_payment`.`a_s_f_1`
`ot_payment`.`a_s_f_2`
`ot_payment`.`anaes_f`
`ot_payment`.`ot_charge`
`ot_payment`.`cab_rent`
`ot_payment`.`seat_rent`
`ot_payment`.`others`
`ot_payment`.`discount`
`ot_payment`.`date`
`ot_payment`.`amount`
`ot_payment`.`doctor_fees`
`ot_payment`.`hospital_fees`
`ot_payment`.`gross_total`
`ot_payment`.`flat_discount`
`ot_payment`.`amount_received`
`ot_payment`.`status`
`ot_payment`.`user`
`ot_payment`.`hospital_id`
`package`.*
`package`.`id`
`package`.`name`
`package`.`monthly_price`
`package`.`p_limit`
`package`.`d_limit`
`package`.`module`
`package`.`show_in_frontend`
`package`.`frontend_order`
`package`.`set_as_default`
`package`.`yearly_price`
`package`.`recommended`
`patient`.*
`patient`.`id`
`patient`.`img_url`
`patient`.`name`
`patient`.`email`
`patient`.`doctor`
`patient`.`address`
`patient`.`phone`
`patient`.`sex`
`patient`.`disease`
`patient`.`birthdate`
`patient`.`age`
`patient`.`bloodgroup`
`patient`.`ion_user_id`
`patient`.`patient_id`
`patient`.`add_date`
`patient`.`registration_time`
`patient`.`how_added`
`patient`.`hospital_id`
`patient`.`appointment_confirmation`
`patient`.`appointment_creation`
`patient`.`payment_confirmation`
`patient`.`meeting_schedule`
`patient`.`body_mass_index`
`patient`.`weight`
`patient`.`height`
`patient`.`habits`
`patient`.`do_you_use_tobacco`
`patient`.`do_you_use_alcohol`
`patient`.`do_you_use_drugs`
`patient`.`physical_activity`
`patient`.`allergies`
`patient`.`cardiovascular_risk_factors`
`patient`.`previous_illnesses`
`patient`.`are_you_on_medication`
`patient`.`surgical_interventions`
`patient`.`vaccination_status`
`patient`.`family_history`
`patient`.`marital_status`
`patient`.`children`
`patient`.`morbid_history`
`patient`.`diseases`
`patient`.`nutrition`
`patient`.`emotional_status`
`patient`.`reproductive_status`
`patient`.`date_of_last_menstrual_period`
`patient`.`date_of_last_gynecological_examination`
`patient`.`pregnancies`
`patient`.`contraceptive_method`
`patient`.`previous_jobs`
`patient`.`length_of_last_employment`
`patient`.`risk_factors_for_last_employment`
`patient`.`hours_covered_for_last_employment`
`patient`.`current_position`
`patient`.`seniority_of_current_position`
`patient`.`current_risk_factors`
`patient`.`schedule_of_current_position`
`patient`.`days_off_from_current_position`
`patient`.`custom_fields`
`patient_deposit`.*
`patient_deposit`.`id`
`patient_deposit`.`patient`
`patient_deposit`.`payment_id`
`patient_deposit`.`date`
`patient_deposit`.`deposited_amount`
`patient_deposit`.`amount_received_id`
`patient_deposit`.`deposit_type`
`patient_deposit`.`gateway`
`patient_deposit`.`user`
`patient_deposit`.`hospital_id`
`patient_deposit`.`payment_from`
`patient_material`.*
`patient_material`.`id`
`patient_material`.`date`
`patient_material`.`title`
`patient_material`.`category`
`patient_material`.`patient`
`patient_material`.`patient_name`
`patient_material`.`patient_address`
`patient_material`.`patient_phone`
`patient_material`.`url`
`patient_material`.`date_string`
`patient_material`.`hospital_id`
`patient_material`.`folder`
`patient_material`.`type`
`payment`.*
`payment`.`id`
`payment`.`category`
`payment`.`patient`
`payment`.`doctor`
`payment`.`date`
`payment`.`amount`
`payment`.`vat`
`payment`.`x_ray`
`payment`.`flat_vat`
`payment`.`discount`
`payment`.`flat_discount`
`payment`.`gross_total`
`payment`.`remarks`
`payment`.`hospital_amount`
`payment`.`doctor_amount`
`payment`.`category_amount`
`payment`.`category_name`
`payment`.`amount_received`
`payment`.`deposit_type`
`payment`.`status`
`payment`.`user`
`payment`.`patient_name`
`payment`.`patient_phone`
`payment`.`patient_address`
`payment`.`doctor_name`
`payment`.`date_string`
`payment`.`hospital_id`
`payment`.`payment_from`
`payment`.`date_delivery`
`payment`.`time_delivery`
`payment`.`percent_discount`
`payment`.`vat_amount_percent`
`payment`.`appointment_id`
`payment_category`.*
`payment_category`.`id`
`payment_category`.`category`
`payment_category`.`description`
`payment_category`.`c_price`
`payment_category`.`type`
`payment_category`.`d_commission`
`payment_category`.`h_commission`
`payment_category`.`hospital_id`
`payment_category`.`code`
`payment_category`.`payment_category`
`payment_category`.`payment_category_name`
`payment_category`.`report`
`paymentgateway`.*
`paymentgateway`.`id`
`paymentgateway`.`name`
`paymentgateway`.`merchant_key`
`paymentgateway`.`salt`
`paymentgateway`.`x`
`paymentgateway`.`y`
`paymentgateway`.`APIUsername`
`paymentgateway`.`APIPassword`
`paymentgateway`.`APISignature`
`paymentgateway`.`status`
`paymentgateway`.`publish`
`paymentgateway`.`secret`
`paymentgateway`.`hospital_id`
`paymentgateway`.`public_key`
`payroll`.*
`payroll`.`id`
`payroll`.`staff`
`payroll`.`month`
`payroll`.`year`
`payroll`.`paid_on`
`payroll`.`expense`
`payroll`.`earning`
`payroll`.`deduction`
`payroll`.`status`
`payroll`.`hospital_id`
`pharmacist`.*
`pharmacist`.`id`
`pharmacist`.`img_url`
`pharmacist`.`name`
`pharmacist`.`email`
`pharmacist`.`address`
`pharmacist`.`phone`
`pharmacist`.`x`
`pharmacist`.`y`
`pharmacist`.`ion_user_id`
`pharmacist`.`hospital_id`
`pharmacist`.`profile`
`pharmacist`.`signature`
`pharmacy_expense`.*
`pharmacy_expense`.`id`
`pharmacy_expense`.`category`
`pharmacy_expense`.`date`
`pharmacy_expense`.`amount`
`pharmacy_expense`.`user`
`pharmacy_expense`.`hospital_id`
`pharmacy_expense_category`.*
`pharmacy_expense_category`.`id`
`pharmacy_expense_category`.`category`
`pharmacy_expense_category`.`description`
`pharmacy_expense_category`.`x`
`pharmacy_expense_category`.`y`
`pharmacy_expense_category`.`hospital_id`
`pharmacy_payment`.*
`pharmacy_payment`.`id`
`pharmacy_payment`.`category`
`pharmacy_payment`.`patient`
`pharmacy_payment`.`doctor`
`pharmacy_payment`.`date`
`pharmacy_payment`.`amount`
`pharmacy_payment`.`vat`
`pharmacy_payment`.`x_ray`
`pharmacy_payment`.`flat_vat`
`pharmacy_payment`.`discount`
`pharmacy_payment`.`flat_discount`
`pharmacy_payment`.`gross_total`
`pharmacy_payment`.`hospital_amount`
`pharmacy_payment`.`doctor_amount`
`pharmacy_payment`.`category_amount`
`pharmacy_payment`.`category_name`
`pharmacy_payment`.`amount_received`
`pharmacy_payment`.`status`
`pharmacy_payment`.`hospital_id`
`pharmacy_payment_category`.*
`pharmacy_payment_category`.`id`
`pharmacy_payment_category`.`category`
`pharmacy_payment_category`.`description`
`pharmacy_payment_category`.`c_price`
`pharmacy_payment_category`.`d_commission`
`pharmacy_payment_category`.`h_commission`
`pharmacy_payment_category`.`hospital_id`
`prescription`.*
`prescription`.`id`
`prescription`.`date`
`prescription`.`patient`
`prescription`.`doctor`
`prescription`.`symptom`
`prescription`.`advice`
`prescription`.`state`
`prescription`.`dd`
`prescription`.`medicine`
`prescription`.`validity`
`prescription`.`note`
`prescription`.`patientname`
`prescription`.`doctorname`
`prescription`.`signed_by`
`prescription`.`hospital_id`
`pservice`.*
`pservice`.`id`
`pservice`.`name`
`pservice`.`code`
`pservice`.`alpha_code`
`pservice`.`price`
`pservice`.`active`
`pservice`.`hospital_id`
`receptionist`.*
`receptionist`.`id`
`receptionist`.`img_url`
`receptionist`.`name`
`receptionist`.`email`
`receptionist`.`address`
`receptionist`.`phone`
`receptionist`.`x`
`receptionist`.`ion_user_id`
`receptionist`.`hospital_id`
`receptionist`.`signature`
`receptionist`.`profile`
`report`.*
`report`.`id`
`report`.`report_type`
`report`.`patient`
`report`.`description`
`report`.`doctor`
`report`.`date`
`report`.`add_date`
`report`.`hospital_id`
`request`.*
`request`.`id`
`request`.`name`
`request`.`address`
`request`.`email`
`request`.`phone`
`request`.`other`
`request`.`package`
`request`.`language`
`request`.`remarks`
`request`.`status`
`review`.*
`review`.`id`
`review`.`name`
`review`.`designation`
`review`.`review`
`review`.`img`
`review`.`status`
`salary`.*
`salary`.`id`
`salary`.`staff`
`salary`.`salary`
`salary`.`hospital_id`
`service`.*
`service`.`id`
`service`.`img_url`
`service`.`title`
`service`.`description`
`settings`.*
`settings`.`id`
`settings`.`system_vendor`
`settings`.`title`
`settings`.`address`
`settings`.`phone`
`settings`.`email`
`settings`.`facebook_id`
`settings`.`currency`
`settings`.`language`
`settings`.`discount`
`settings`.`live_appointment_type`
`settings`.`vat`
`settings`.`login_title`
`settings`.`logo`
`settings`.`invoice_logo`
`settings`.`payment_gateway`
`settings`.`sms_gateway`
`settings`.`codec_username`
`settings`.`codec_purchase_code`
`settings`.`hospital_id`
`settings`.`emailtype`
`settings`.`remainder_appointment`
`settings`.`footer_message`
`settings`.`show_odontogram_in_history`
`settings`.`invoice_choose`
`settings`.`discount_percent`
`settings`.`footer_invoice_message`
`single_website_settings`.*
`single_website_settings`.`id`
`single_website_settings`.`title`
`single_website_settings`.`description`
`single_website_settings`.`logo`
`single_website_settings`.`address`
`single_website_settings`.`phone`
`single_website_settings`.`emergency`
`single_website_settings`.`support`
`single_website_settings`.`email`
`single_website_settings`.`currency`
`single_website_settings`.`block_1_text_under_title`
`single_website_settings`.`service_block__text_under_title`
`single_website_settings`.`doctor_block__text_under_title`
`single_website_settings`.`facebook_id`
`single_website_settings`.`twitter_id`
`single_website_settings`.`google_id`
`single_website_settings`.`youtube_id`
`single_website_settings`.`skype_id`
`single_website_settings`.`x`
`single_website_settings`.`twitter_username`
`single_website_settings`.`appointment_title`
`single_website_settings`.`appointment_subtitle`
`single_website_settings`.`appointment_description`
`single_website_settings`.`appointment_img_url`
`single_website_settings`.`url_hospital`
`single_website_settings`.`hospital_id`
`site_gallery`.*
`site_gallery`.`id`
`site_gallery`.`img`
`site_gallery`.`position`
`site_gallery`.`status`
`site_gallery`.`hospital_id`
`site_grid`.*
`site_grid`.`id`
`site_grid`.`category`
`site_grid`.`title`
`site_grid`.`description`
`site_grid`.`img`
`site_grid`.`position`
`site_grid`.`status`
`site_grid`.`hospital_id`
`site_map`.*
`site_map`.`id`
`site_map`.`name`
`site_map`.`url`
`site_map`.`for_login`
`site_review`.*
`site_review`.`id`
`site_review`.`name`
`site_review`.`designation`
`site_review`.`review`
`site_review`.`img`
`site_review`.`status`
`site_review`.`hospital_id`
`site_service`.*
`site_service`.`id`
`site_service`.`img_url`
`site_service`.`title`
`site_service`.`description`
`site_service`.`hospital_id`
`site_slide`.*
`site_slide`.`id`
`site_slide`.`title`
`site_slide`.`img_url`
`site_slide`.`text1`
`site_slide`.`text2`
`site_slide`.`text3`
`site_slide`.`position`
`site_slide`.`status`
`site_slide`.`hospital_id`
`slide`.*
`slide`.`id`
`slide`.`title`
`slide`.`img_url`
`slide`.`text1`
`slide`.`text2`
`slide`.`text3`
`slide`.`position`
`slide`.`status`
`sms`.*
`sms`.`id`
`sms`.`date`
`sms`.`message`
`sms`.`recipient`
`sms`.`user`
`sms`.`hospital_id`
`sms_settings`.*
`sms_settings`.`id`
`sms_settings`.`name`
`sms_settings`.`username`
`sms_settings`.`password`
`sms_settings`.`api_id`
`sms_settings`.`sender`
`sms_settings`.`authkey`
`sms_settings`.`user`
`sms_settings`.`sid`
`sms_settings`.`token`
`sms_settings`.`sendernumber`
`sms_settings`.`hospital_id`
`sms_settings`.`email`
`sms_settings`.`sender_name`
`superadmin`.*
`superadmin`.`id`
`superadmin`.`name`
`superadmin`.`email`
`superadmin`.`phone`
`superadmin`.`address`
`superadmin`.`img_url`
`superadmin`.`ion_user_id`
`superadmin`.`module`
`template`.*
`template`.`id`
`template`.`name`
`template`.`template`
`template`.`user`
`template`.`x`
`template`.`hospital_id`
`template`.`category_id`
`time_schedule`.*
`time_schedule`.`id`
`time_schedule`.`doctor`
`time_schedule`.`weekday`
`time_schedule`.`s_time`
`time_schedule`.`e_time`
`time_schedule`.`s_time_key`
`time_schedule`.`duration`
`time_schedule`.`hospital_id`
`time_slot`.*
`time_slot`.`id`
`time_slot`.`doctor`
`time_slot`.`s_time`
`time_slot`.`e_time`
`time_slot`.`weekday`
`time_slot`.`s_time_key`
`time_slot`.`hospital_id`
`transaction_logs`.*
`transaction_logs`.`id`
`transaction_logs`.`date_time`
`transaction_logs`.`invoice_id`
`transaction_logs`.`patientname`
`transaction_logs`.`deposit_type`
`transaction_logs`.`payment_gateway`
`transaction_logs`.`action`
`transaction_logs`.`hospital_id`
`transaction_logs`.`amount`
`transaction_logs`.`user`
`users`.*
`users`.`id`
`users`.`ip_address`
`users`.`username`
`users`.`password`
`users`.`salt`
`users`.`email`
`users`.`activation_code`
`users`.`forgotten_password_code`
`users`.`forgotten_password_time`
`users`.`remember_code`
`users`.`created_on`
`users`.`last_login`
`users`.`active`
`users`.`first_name`
`users`.`last_name`
`users`.`company`
`users`.`phone`
`users`.`hospital_ion_id`
`users_groups`.*
`users_groups`.`id`
`users_groups`.`user_id`
`users_groups`.`group_id`
`vital_signs`.*
`vital_signs`.`id`
`vital_signs`.`patient_id`
`vital_signs`.`bmi_height`
`vital_signs`.`bmi_weight`
`vital_signs`.`respiratory_rate`
`vital_signs`.`oxygen_saturation`
`vital_signs`.`temperature`
`vital_signs`.`diastolic_blood_pressure`
`vital_signs`.`systolic_blood_pressure`
`vital_signs`.`add_date_time`
`vital_signs`.`heart_rate`
`vital_signs`.`hospital_id`
`website_settings`.*
`website_settings`.`id`
`website_settings`.`title`
`website_settings`.`logo`
`website_settings`.`address`
`website_settings`.`phone`
`website_settings`.`emergency`
`website_settings`.`support`
`website_settings`.`email`
`website_settings`.`currency`
`website_settings`.`block_1_text_under_title`
`website_settings`.`service_block__text_under_title`
`website_settings`.`doctor_block__text_under_title`
`website_settings`.`facebook_id`
`website_settings`.`twitter_id`
`website_settings`.`google_id`
`website_settings`.`youtube_id`
`website_settings`.`skype_id`
`website_settings`.`x`
`website_settings`.`twitter_username`
`website_settings`.`block_img_url`
`website_settings`.`comment_1`
`website_settings`.`comment_2`
`website_settings`.`verified_1`
`website_settings`.`verified_2`
`website_settings`.`comment_logo_1`
`website_settings`.`comment_logo_2`
`website_settings`.`partner_header_title`
`website_settings`.`partner_header_description`
`website_settings`.`section_title_1`
`website_settings`.`section_title_2`
`website_settings`.`section_title_3`
`website_settings`.`section_description_1`
`website_settings`.`section_description_2`
`website_settings`.`section_description_3`
`website_settings`.`section_1_text_1`
`website_settings`.`section_2_text_1`
`website_settings`.`section_3_text_1`
`website_settings`.`section_1_text_2`
`website_settings`.`section_2_text_2`
`website_settings`.`section_3_text_2`
`website_settings`.`section_1_text_3`
`website_settings`.`section_2_text_3`
`website_settings`.`section_3_text_3`
`website_settings`.`partner_image_1`
`website_settings`.`partner_image_2`
`website_settings`.`partner_image_3`
`website_settings`.`market_title`
`website_settings`.`market_description`
`website_settings`.`market_button_link`
`website_settings`.`market_image`
`website_settings`.`market_commentator_name`
`website_settings`.`market_commentator_designation`
`website_settings`.`market_comment`
`website_settings`.`commentator_profile_image`
`website_settings`.`commentator_logo_1`
`website_settings`.`commentator_logo_2`
`website_settings`.`commentator_logo_3`
`website_settings`.`team_title`
`website_settings`.`team_description`
`website_settings`.`team_button_link`
`website_settings`.`team_commentator_name`
`website_settings`.`team_commentator_designation`
`website_settings`.`team_comment`
`website_settings`.`team_verified`
`website_settings`.`team_review_logo`
`website_settings`.`team_commentator_image`
`website_settings`.`registration_block_text`
`website_settings`.`contact_us`
`website_settings`.`contact_us_email`
`website_settings`.`chat_js`
Alias:
Mostrar:
Ordenar:
Ascendente
Descendente
Ascendente
Descendente
Ascendente
Descendente
Orden de clasificación:
1
2
3
1
2
3
1
2
3
Criterio:
Agregar:
Y:
Borrar:
O:
Modificar:
O:
Y:
Insertar
Borrar
O:
Y:
Insertar
Borrar
Insertar
Borrar
Añadir/Eliminar filas de criterio:
-3
-2
-1
0
1
2
3
Añadir/Eliminar columnas:
-3
-2
-1
0
1
2
3
Usar tablas
accountant
alloted_bed
appointment
attendance
autoemailshortcode
autoemailtemplate
autosmsshortcode
autosmstemplate
bankb
bed
bed_category
bed_checkout
bed_medicine
bed_service
blood_group
category
chat
chat_group
daily_progress
department
diagnostic_report
doctor
doctor_visit
donor
draft_payment
email
email_settings
expense
expense_category
featured
file
folder
gallery
google_captcha
grid
groups
holidays
hospital
hospital_deposit
hospital_payment
lab
lab_category
laboratorist
leave_type
leaves
login_attempts
logs
macro
manual_email_template
manual_sms_template
manualemailshortcode
manualsmsshortcode
medical_history
medicine
medicine_category
meeting
meeting_settings
module
notice
nurse
odontogram
ot_payment
package
patient
patient_deposit
patient_material
payment
payment_category
paymentgateway
payroll
pharmacist
pharmacy_expense
pharmacy_expense_category
pharmacy_payment
pharmacy_payment_category
prescription
pservice
receptionist
report
request
review
salary
service
settings
single_website_settings
site_gallery
site_grid
site_map
site_review
site_service
site_slide
slide
sms
sms_settings
superadmin
template
time_schedule
time_slot
transaction_logs
users
users_groups
vital_signs
website_settings
Consulta a la base de datos
farmamedi_hms0971mico
: