* id tenant_id facility_id user_id action module_name record_table record_id description ip_address created_at

* id tenant_id employee_id doctor_name sip_number str_number specialization is_active

* id tenant_id employee_number full_name profession phone email is_active

* id tenant_id facility_code facility_name facility_type address phone email is_active created_at

* id tenant_id medical_record_number national_id_number full_name birth_place birth_date gender blood_type mother_name is_active created_at updated_at

* id tenant_id patient_id address_type address village district city_regency province postal_code is_primary

* id tenant_id patient_id contact_type contact_value contact_person relationship_to_patient is_primary

* id permission_code permission_name module_name

* id full_name email password_hash is_active last_login_at created_at

* id platform_admin_id action target_type target_id description ip_address created_at

* id tenant_id facility_id registration_number patient_id visit_type_id service_unit_id doctor_id registration_date payment_method registration_status complaint created_by created_at

* id role_code role_name description

* role_id permission_id

* id tenant_id facility_id unit_code unit_name unit_type is_active

* id tenant_id plan_id billing_cycle status starts_at ends_at trial_ends_at grace_ends_at cancelled_at created_at updated_at

* id tenant_id subscription_id invoice_number amount currency status issued_at due_at paid_at created_at

* id tenant_id invoice_id payment_reference payment_method amount status paid_at gateway_payload created_at

* id plan_code plan_name description price_monthly price_yearly max_facilities max_users max_storage_gb features_json is_active sort_order created_at

* id tenant_code tenant_name legal_name email phone status trial_ends_at created_at updated_at

* id tenant_id hostname domain_type is_primary is_verified is_active created_at

* id tenant_id setting_key setting_value updated_at

* id username password_hash full_name email is_active last_login_at created_at

* user_id tenant_id facility_id is_active

* id user_id role_id tenant_id facility_id created_at

* id visit_type_code visit_type_name is_active

select table audit_logs doctors employees facilities patients patient_addresses patient_contacts permissions platform_admins platform_audit_logs registrations roles role_permissions service_units subscriptions subscription_invoices subscription_payments subscription_plans tenants tenant_domains tenant_settings users user_facilities user_roles visit_types . 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 audit_logs doctors employees facilities patients patient_addresses patient_contacts permissions platform_admins platform_audit_logs registrations roles role_permissions service_units subscriptions subscription_invoices subscription_payments subscription_plans tenants tenant_domains tenant_settings users user_facilities user_roles visit_types .	select column