* id opd_patient_id doctor_id service_id appointment_datetime duration_minutes end_datetime status notes created_at updated_at created_by

* id form_title form_content is_active created_at updated_at

* id transaction_date type amount category_id description payee_or_source payment_method reference_number notes created_by created_at updated_at payment_id invoice_id

* id name description type is_active

* id invoice_number opd_patient_id issue_date due_date sub_total discount_amount tax_amount grand_total amount_paid status notes terms created_at updated_at created_by

* id invoice_id related_treatment_item_id description quantity unit_price item_total

* id token patient_name patient_contact status expires_at created_by created_at completed_opd_id

* id opd_number first_name last_name nickname date_of_birth gender phone_number email contact_channel contact_details address_line1 address_line2 city postcode country referral_source medical_conditions allergies current_medications created_at updated_at created_by is_deleted

* id opd_patient_id consent_form_id signing_doctor_id signed_datetime status generated_pdf_path created_by created_at updated_at

* id opd_patient_id treatment_id image_type image_path description uploaded_at uploaded_by

* id treatment_id invoice_id payment_datetime amount payment_method payment_method_other reference_number notes received_by created_at

* id sku product_name description unit_name current_stock reorder_level cost_price is_active created_at updated_at

* id rule_id treatment_id patient_id sent_at channel_used status error_message

* id rule_name months_after is_active channels telegram_bot_token telegram_chat_id email_recipients frequency send_time day_of_week day_of_month filter_doctor_id filter_service_ids include_patient_phone include_patient_email include_treatment_notes include_treatment_amount last_run_at created_at updated_at

* id role_name description

* id category_id service_name description duration_minutes price product_id doctor_commission_percentage staff_commission_percentage is_active created_at updated_at

* id name description created_at updated_at

* id setting_key setting_value

* id product_id movement_type quantity_change stock_after_move related_treatment_item_id movement_datetime notes user_id created_at

* id opd_patient_id doctor_id appointment_id treatment_datetime total_amount total_doctor_commission total_staff_commission payment_method payment_method_other payment_status invoice_id amount_paid notes created_at updated_at created_by

* id treatment_id service_id item_description quantity unit_price total_price doctor_commission_amount staff_commission_amount

* id treatment_id patient_consent_id linked_at

* id username password_hash email full_name nickname phone contact_channel role_id is_active created_at updated_at

select table appointments consent_forms financial_transactions financial_transaction_categories invoices invoice_items opd_invitations opd_patients patient_consents patient_images payments products reminder_logs reminder_rules roles services service_categories settings stock_movements treatments treatment_items treatment_linked_consents users . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table appointments consent_forms financial_transactions financial_transaction_categories invoices invoice_items opd_invitations opd_patients patient_consents patient_images payments products reminder_logs reminder_rules roles services service_categories settings stock_movements treatments treatment_items treatment_linked_consents users .	select column