* id course_code name_ar name_en department_id faculty_id academic_dept_id year_level credit_hours theory_hours practical_hours level is_active notes created_at

* id name_ar name_en code faculty_id head_staff_id established_year is_active created_at

* id staff_id semester_id month year theory_hours practical_hours extra_hours theory_amount practical_amount extra_amount gross_salary deductions net_salary status journal_entry_id payment_entry_id notes created_by created_at

* id name_ar name_en code sort_order base_hourly_theory base_hourly_practical base_hourly_extra min_hours_required max_hours_allowed is_active notes created_at

* id academic_year_id semester_id name gender max_students current_students space_id is_active created_at

* id name_ar academic_year semester_number start_date end_date status created_at

* id staff_code full_name full_name_en rank_id department_id faculty_id academic_dept_id section_name office_location specialization secondary_specialization academic_degree graduation_university graduation_year national_id email phone hire_date photo salary_basic staff_type custom_hourly_theory custom_hourly_practical custom_hourly_extra portal_username portal_password portal_active status notes created_by created_at

* id name_ar year_number faculty_id dept_id total_students is_active created_at

* id fiscal_year fiscal_period period_name start_date end_date status closed_by closed_at opening_entry_id closing_notes total_debit total_credit entries_count created_at

* id code name_ar name_en parent_id account_type account_class level is_parent normal_balance opening_balance is_active notes created_by created_at updated_at

* id invoice_number debtor_type debtor_name debtor_code account_code description invoice_date due_date amount paid_amount status revenue_account journal_entry_id payment_entry_id notes created_by created_at updated_at

* id token name user_id permissions last_used_at expires_at is_active created_at

* id ar_id payment_date amount payment_method reference journal_entry_id notes created_by created_at

* id asset_code serial_number category_id name description addition_number added_date quantity unit_price total_value depreciation_rate warehouse_id space_id current_location supplier supplier_id warranty_expiry status image notes created_by created_at updated_at depreciation_method useful_life_years salvage_value accumulated_depreciation last_depreciation_date journal_entry_id

* id asset_id file_path file_type uploaded_at

* id asset_id booking_number employee_id department_id purpose booking_date start_time end_time return_time status approved_by approved_at notes condition_on_return created_at

* id asset_id fiscal_year annual_depreciation accumulated_depreciation book_value calculated_at

* id asset_id depreciation_year depreciation_month depreciation_amount book_value_before book_value_after journal_entry_id status created_at

* id asset_id disposal_type disposal_date disposal_value reason recipient receipt_number approved_by notes created_by created_at

* id asset_id image_path uploaded_at

* id asset_id maintenance_date next_due_date description cost performed_by status

* id employee_id attend_date check_in check_out status late_minutes early_minutes work_hours notes recorded_by created_at

* id slot_id session_date qr_token expires_at created_by created_at

* id user_id action module record_id details ip_address created_at

* id consumable_id current_stock reorder_quantity status created_at approved_by approved_at notes

* id account_code period_month period_year statement_date statement_balance book_balance difference status notes reconciled_by reconciled_at journal_entry_id created_by created_at

* id reconciliation_id item_type description amount transaction_date journal_entry_id is_cleared cleared_date created_at

* id fiscal_year department_id budget_type title planned_amount notes status approved_by approved_at created_by created_at account_code committed_amount actual_amount journal_entry_id

* id budget_id transaction_date amount transaction_type reference_id reference_number description created_by created_at

* id code name name_en address floors_count year_built area_sqm description is_active created_by created_at

* id building_id floor_num name description is_active fp_width fp_height fp_bg

* id code name_ar parent_id book_type depreciation_min depreciation_max level

* id request_id step_id status notes approved_by approved_at created_at

* id request_number person_type person_id reason reason_notes last_working_day status notes created_by completed_at rejected_by rejected_at created_at updated_at journal_entry_id

* id step_name step_name_en responsible_dept step_order applies_to is_required is_active notes

* id item_code category_id name description unit current_stock min_stock_alert reorder_point reorder_quantity avg_daily_consumption last_reorder_date warehouse_id supplier_id image is_active created_at account_code

* id contract_number title supplier_id contract_type start_date end_date total_value paid_value status description attachment created_by created_at journal_entry_id expense_account notes

* id contract_id payment_number title due_date amount paid_date paid_amount status notes created_at journal_entry_id account_code

* id ref_number type direction subject category_id priority status sender_name sender_entity sender_ref sender_date receiver_name receiver_entity department_id employee_id assigned_to correspondence_date received_date due_date reply_date summary notes tags replied_by reply_ref parent_id created_by created_at updated_at

* id correspondence_id file_name file_path file_type file_size is_primary uploaded_by uploaded_at

* id name color icon sort_order is_active

* id correspondence_id action notes done_by done_at

* id correspondence_id employee_id department_id recipient_name read_at acknowledged_at notes

* id journal_entry_id journal_line_id department_id account_code amount allocation_pct fiscal_year fiscal_period notes created_by created_at

* id account_code department_id percentage is_active

* id semester_id course_id section_name student_count max_capacity gender assignment_id space_id notes created_by created_at

* id employee_id item_type item_id voucher_number custody_date quantity item_condition movement_type transferred_to_employee_id signature_path verification_qr balance_after notes created_by created_at

* id employee_id item_type item_id quantity unit_codes reason status reviewed_by reviewed_at review_notes warehouse_id created_at journal_entry_id

* id custody_id unit_id unit_code status returned_at notes

* id name department_type cost_center_code budget_amount parent_id

* id department_id category_id quantity_entitled quantity_actual notes created_by created_at updated_at

* id name_ar is_active

* id title description file_path file_name file_size file_type doc_type entity_type entity_id tags is_confidential uploaded_by created_at

* id employee_code national_id full_name job_title department_id hire_date email phone gender birth_date basic_salary bank_account address emergency_contact emergency_phone notes status photo created_at

* id employee_id entitlement_type title amount is_recurring period_month period_year status payment_date notes created_by created_at journal_entry_id account_code

* id employee_id leave_type_id year total_days used_days pending_days

* id employee_id month year basic_salary allowances bonuses deductions penalties social_insurance medical_insurance income_tax employer_social net_salary notes status paid_at created_by created_at journal_entry_id payment_entry_id gross_salary

* id employee_id penalty_type reason amount penalty_date notes issued_by created_at journal_entry_id

* id rule_name applies_to rank_id staff_id rate_theory rate_practical rate_extra min_hours_extra effective_from effective_to is_active notes created_by created_at

* id name_ar name_en code dean_name established_year is_active created_at

* id fiscal_year status total_revenue total_expense net_profit_loss closing_entry_id transfer_entry_id closed_by closed_at notes created_at

* id gr_number po_id receipt_date warehouse_id total_received journal_entry_id notes created_by created_at

* id gr_id poi_id received_qty unit_price total_price

* id name card_type width_mm height_mm orientation cards_per_row cards_per_page margin_mm gap_mm show_photo show_barcode show_qr show_back show_natid color_primary color_secondary printer_name paper_size is_default created_by created_at

* id sender_id receiver_id subject body priority label is_starred broadcast_dept_id attachment is_read read_at is_deleted_sender is_deleted_receiver parent_id created_at

* id invoice_id payment_date amount payment_method reference_number notes created_by created_at journal_entry_id revenue_account

* id item_type item_id unit_code warehouse_id status assigned_to_employee_id last_scanned_at notes created_at

* id entry_id action user_id notes created_at

* id entry_number entry_date description reference_type reference_id reference_number fiscal_year fiscal_period total_debit total_credit status approval_status approval_required reviewed_by reviewed_at review_notes posted_by posted_at reversed_entry notes created_by created_at updated_at

* id entry_id line_number account_id description debit_amount credit_amount cost_center

* id request_number employee_id leave_type_id start_date end_date days_count reason status manager_id manager_notes manager_decided_at hr_id hr_notes hr_decided_at created_by created_at updated_at

* id name_ar name_en days_per_year is_paid color is_active created_at

* id slot_id staff_id notify_type notify_date sent_at is_sent

* id user_id title message is_read link created_at type

* id name holiday_date year is_recurring

* id user_id code expires_at is_used created_at

* id setting_key value description updated_at

* id template_id name description max_score weight category sort_order

* id employee_id template_id evaluator_id period_year period_quarter period_month eval_date total_score max_score percentage grade notes strengths improvements status approved_by approved_at created_at

* id evaluation_id criteria_id score notes

* id name description period is_active created_by created_at

* id module action

* id po_id receipt_date received_by notes created_at

* id receipt_id po_item_id quantity_received condition_notes

* id prepaid_id period_year period_month amount journal_entry_id status posted_at

* id entry_number description vendor_name expense_account total_amount start_date end_date months_total monthly_amount amortized_amount remaining_amount status initial_entry_id notes created_by created_at

* id project_id asset_id consumable_id quantity assigned_date return_date notes

* id project_id expense_date category description amount reference_id reference_type created_by created_at journal_entry_id account_code

* id project_id staff_id role_in_project join_date

* id po_number supplier_id warehouse_id department_id order_date expected_delivery actual_delivery total_amount status notes tender_id invoice_id created_by approved_by approved_at created_at updated_at budget_id journal_entry_id payment_entry_id item_type received_amount paid_amount

* id po_id item_type item_id item_name item_code quantity_ordered quantity_received unit_price total_price notes

* id reg_number title category_id description content file_path file_name version status effective_date expiry_date related_module requires_ack tags views_count created_by updated_by created_at updated_at

* id regulation_id user_id employee_id acknowledged_at notes

* id name_ar name_en icon color sort_order is_active created_at

* id regulation_id user_id employee_id read_at

* id request_number employee_id warehouse_id reason priority status created_at updated_at

* id requisition_id approver_id approval_level decision comments decided_at

* id requisition_id item_type item_id quantity_requested quantity_approved space_id quantity_delivered

* id requisition_id item_id unit_id unit_code created_at

* id project_code title_ar title_en project_type department_id principal_investigator_id start_date end_date budget funding_source status description created_by created_at journal_entry_id expense_account actual_spent

* id entry_number revenue_date revenue_type account_code payer_name payer_type description amount vat_amount total_amount payment_method reference_number bank_account journal_entry_id fiscal_year fiscal_period status notes created_by created_at

* id name description created_at

* role_id permission_id

* id space_id academic_course_id assignment_id semester_id allocated_to purpose day_of_week start_time end_time start_date end_date recurrence capacity notes status created_by created_at

* id name report_type frequency send_day send_time recipients last_sent next_send is_active parameters created_by created_at

* id assignment_id semester_id space_id day_of_week start_time end_time slot_type group_name notes created_by created_at

* id code name space_type_id space_category department_id responsible_id building building_id floor floor_id capacity notes equipment is_active created_at fp_x fp_y fp_w fp_h fp_color fp_floor_id has_projector has_ac has_internet has_smartboard computer_count status

* id asset_id space_id assigned_date moved_out_date assigned_by notes created_at

* id name_ar category icon color description is_active

* id staff_id semester_id month year total_theory_hours total_practical_hours total_extra_hours rate_theory rate_practical rate_extra amount_theory amount_practical amount_extra deductions net_amount status notes approved_by approved_at paid_at created_at

* id consumable_id consumed_qty log_date created_at

* id warehouse_id count_date performed_by status count_type

* id stock_count_id item_type item_id expected_quantity actual_quantity difference notes

* id item_type item_id warehouse_id movement_date voucher_number source_destination quantity_in quantity_out_actual quantity_out_other disposal_reason_id item_condition balance_after notes created_by created_at

* id student_code full_name full_name_en national_id faculty_id dept_id academic_year_id section_id gender email phone enrollment_year gpa photo status notes created_at

* id slot_id attendance_date student_name student_id student_db_id status section_name scan_time ip_address selfie_photo device_fingerprint

* id student_id course_id semester_id section_id assignment_id midterm_grade final_grade practical_grade total_grade grade_letter attendance_pct status registered_at

* id name contact_person phone email address tax_number notes is_active created_at rating eval_count category bank_name bank_account payment_terms

* id supplier_id po_id eval_date evaluator_id quality_score delivery_score price_score service_score docs_score total_score percentage grade notes created_at

* id supplier_id invoice_number invoice_date due_date amount paid_amount currency status related_asset_id related_po notes attachment created_by created_at updated_at

* id invoice_number supplier_id po_id gr_id invoice_date due_date amount vat_amount total_amount paid_amount status journal_entry_id payment_entry_id notes created_by created_at

* id payment_number supplier_id invoice_id payment_date amount payment_method bank_account reference_number journal_entry_id notes created_by created_at

* id supplier_id item_name item_code unit_price currency price_date source source_id notes created_by created_at

* setting_key setting_value setting_type label_ar group_name updated_at

* id min_amount max_amount rate description

* id staff_id course_id semester_id section_name student_count teaching_type weekly_theory_hours weekly_practical_hours is_extra notes created_by created_at

* id assignment_id session_date status actual_hours notes recorded_by created_at

* id tender_number title description tender_type department_id estimated_value publish_date submission_deadline opening_date status winner_supplier_id awarded_amount notes created_by created_at

* id tender_id item_name quantity unit specifications

* id tender_id supplier_id submission_date total_amount delivery_days warranty_months technical_score financial_score final_score status notes created_at

* id offer_id tender_item_id unit_price total_price notes

* id username password_hash employee_id academic_staff_id role_id warehouse_id is_active two_factor_enabled two_factor_secret last_login created_at api_token fcm_token

* slot1_id slot2_id day_of_week start_time end_time room_name slot1_label slot2_label conflict_type

* id name location building_id manager_id is_active

* id item_type item_id from_warehouse_id to_warehouse_id quantity transfer_date approved_by notes created_at

* id assignment_id semester_id day_of_week start_time end_time room schedule_type notes

* id workflow_type step_number step_name approver_role_id approver_user_id condition_field condition_operator condition_value is_active notify_on_reach created_at

* id name work_start work_end late_tolerance work_days is_default created_at

选择表 academic_courses academic_departments academic_payroll academic_ranks academic_sections academic_semesters academic_staff academic_years accounting_periods accounts accounts_receivable api_tokens ar_payments assets asset_attachments asset_bookings asset_depreciation_log asset_depreciation_schedule asset_disposals asset_images asset_maintenance attendance attendance_sessions audit_log auto_reorder_requests bank_reconciliation bank_reconciliation_items budgets budget_transactions buildings building_floors categories clearance_approvals clearance_requests clearance_steps consumables contracts contract_payments correspondence correspondence_attachments correspondence_categories correspondence_log correspondence_recipients cost_center_allocations cost_center_distribution_keys course_sections custody_records custody_return_requests custody_unit_items departments department_asset_entitlements disposal_reasons documents employees employee_entitlements employee_leave_balance employee_payroll employee_penalties entitlement_rules faculties fiscal_year_closing goods_receipts goods_receipt_items id_card_settings internal_messages invoice_payments item_units journal_approval_log journal_entries journal_entry_lines leave_requests leave_types lecture_notifications notifications official_holidays otp_codes payroll_settings performance_criteria performance_evaluations performance_scores performance_templates permissions po_receipts po_receipt_items prepaid_amortization prepaid_expenses project_assets project_expenses project_team purchase_orders purchase_order_items regulations regulation_acknowledgments regulation_categories regulation_reads requisitions requisition_approvals requisition_items requisition_unit_items research_projects revenue_entries roles role_permissions room_allocations scheduled_reports schedule_slots spaces space_assignment_log space_types staff_monthly_entitlements stock_consumption_log stock_counts stock_count_items stock_movements students student_attendance student_courses suppliers supplier_evaluations supplier_invoices supplier_invoices_acc supplier_payments supplier_price_history system_settings tax_brackets teaching_assignments teaching_attendance tenders tender_items tender_offers tender_offer_items users v_schedule_conflicts warehouses warehouse_transfers weekly_schedule workflow_configs work_schedule . 选择字段
显示

条件

排序	递增	递减
添加为	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	文字 另一个字段
	选择表 academic_courses academic_departments academic_payroll academic_ranks academic_sections academic_semesters academic_staff academic_years accounting_periods accounts accounts_receivable api_tokens ar_payments assets asset_attachments asset_bookings asset_depreciation_log asset_depreciation_schedule asset_disposals asset_images asset_maintenance attendance attendance_sessions audit_log auto_reorder_requests bank_reconciliation bank_reconciliation_items budgets budget_transactions buildings building_floors categories clearance_approvals clearance_requests clearance_steps consumables contracts contract_payments correspondence correspondence_attachments correspondence_categories correspondence_log correspondence_recipients cost_center_allocations cost_center_distribution_keys course_sections custody_records custody_return_requests custody_unit_items departments department_asset_entitlements disposal_reasons documents employees employee_entitlements employee_leave_balance employee_payroll employee_penalties entitlement_rules faculties fiscal_year_closing goods_receipts goods_receipt_items id_card_settings internal_messages invoice_payments item_units journal_approval_log journal_entries journal_entry_lines leave_requests leave_types lecture_notifications notifications official_holidays otp_codes payroll_settings performance_criteria performance_evaluations performance_scores performance_templates permissions po_receipts po_receipt_items prepaid_amortization prepaid_expenses project_assets project_expenses project_team purchase_orders purchase_order_items regulations regulation_acknowledgments regulation_categories regulation_reads requisitions requisition_approvals requisition_items requisition_unit_items research_projects revenue_entries roles role_permissions room_allocations scheduled_reports schedule_slots spaces space_assignment_log space_types staff_monthly_entitlements stock_consumption_log stock_counts stock_count_items stock_movements students student_attendance student_courses suppliers supplier_evaluations supplier_invoices supplier_invoices_acc supplier_payments supplier_price_history system_settings tax_brackets teaching_assignments teaching_attendance tenders tender_items tender_offers tender_offer_items users v_schedule_conflicts warehouses warehouse_transfers weekly_schedule workflow_configs work_schedule .	选择字段