Recent
`information_schema`.`VIEWS`
`warehouse_assets_system`.`users`
`performance_schema`.`table_io_waits_summary_by_table`
`phpmyadmin`.`pma__relation`
`performance_schema`.`events_waits_current`
`information_schema`.`KEYWORDS`
`inventory`.`str`
`warehouse_assets_system`.`custody_unit_items`
`library_access_db`.`clearance_requests`
`warehouse_assets_system`.`workflow_configs`
Favorites
There are no favorite tables.
New
college_timetable
cu_theses
digital_repository
information_schema
inventory
law_attendance
library_access_db
mysql
performance_schema
phpmyadmin
README_TO_RECOVER_AAGB
test
university_management
warehouse_assets_system
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: localhost
Database: warehouse_assets_system
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Saved bookmarked search:
New bookmark
Column:
`academic_courses`.*
`academic_courses`.`id`
`academic_courses`.`course_code`
`academic_courses`.`name_ar`
`academic_courses`.`name_en`
`academic_courses`.`department_id`
`academic_courses`.`credit_hours`
`academic_courses`.`theory_hours`
`academic_courses`.`practical_hours`
`academic_courses`.`level`
`academic_courses`.`is_active`
`academic_courses`.`notes`
`academic_courses`.`created_at`
`academic_payroll`.*
`academic_payroll`.`id`
`academic_payroll`.`staff_id`
`academic_payroll`.`semester_id`
`academic_payroll`.`month`
`academic_payroll`.`year`
`academic_payroll`.`theory_hours`
`academic_payroll`.`practical_hours`
`academic_payroll`.`extra_hours`
`academic_payroll`.`theory_amount`
`academic_payroll`.`practical_amount`
`academic_payroll`.`extra_amount`
`academic_payroll`.`gross_salary`
`academic_payroll`.`deductions`
`academic_payroll`.`net_salary`
`academic_payroll`.`status`
`academic_payroll`.`journal_entry_id`
`academic_payroll`.`payment_entry_id`
`academic_payroll`.`notes`
`academic_payroll`.`created_by`
`academic_payroll`.`created_at`
`academic_ranks`.*
`academic_ranks`.`id`
`academic_ranks`.`name_ar`
`academic_ranks`.`name_en`
`academic_ranks`.`code`
`academic_ranks`.`sort_order`
`academic_ranks`.`base_hourly_theory`
`academic_ranks`.`base_hourly_practical`
`academic_ranks`.`base_hourly_extra`
`academic_ranks`.`min_hours_required`
`academic_ranks`.`max_hours_allowed`
`academic_ranks`.`is_active`
`academic_ranks`.`notes`
`academic_ranks`.`created_at`
`academic_semesters`.*
`academic_semesters`.`id`
`academic_semesters`.`name_ar`
`academic_semesters`.`academic_year`
`academic_semesters`.`semester_number`
`academic_semesters`.`start_date`
`academic_semesters`.`end_date`
`academic_semesters`.`status`
`academic_semesters`.`created_at`
`academic_staff`.*
`academic_staff`.`id`
`academic_staff`.`staff_code`
`academic_staff`.`full_name`
`academic_staff`.`full_name_en`
`academic_staff`.`rank_id`
`academic_staff`.`department_id`
`academic_staff`.`national_id`
`academic_staff`.`email`
`academic_staff`.`phone`
`academic_staff`.`hire_date`
`academic_staff`.`photo`
`academic_staff`.`salary_basic`
`academic_staff`.`staff_type`
`academic_staff`.`custom_hourly_theory`
`academic_staff`.`custom_hourly_practical`
`academic_staff`.`custom_hourly_extra`
`academic_staff`.`portal_username`
`academic_staff`.`portal_password`
`academic_staff`.`portal_active`
`academic_staff`.`status`
`academic_staff`.`notes`
`academic_staff`.`created_by`
`academic_staff`.`created_at`
`accounting_periods`.*
`accounting_periods`.`id`
`accounting_periods`.`fiscal_year`
`accounting_periods`.`fiscal_period`
`accounting_periods`.`period_name`
`accounting_periods`.`start_date`
`accounting_periods`.`end_date`
`accounting_periods`.`status`
`accounting_periods`.`closed_by`
`accounting_periods`.`closed_at`
`accounting_periods`.`opening_entry_id`
`accounting_periods`.`closing_notes`
`accounting_periods`.`total_debit`
`accounting_periods`.`total_credit`
`accounting_periods`.`entries_count`
`accounting_periods`.`created_at`
`accounts`.*
`accounts`.`id`
`accounts`.`code`
`accounts`.`name_ar`
`accounts`.`name_en`
`accounts`.`parent_id`
`accounts`.`account_type`
`accounts`.`account_class`
`accounts`.`level`
`accounts`.`is_parent`
`accounts`.`normal_balance`
`accounts`.`opening_balance`
`accounts`.`is_active`
`accounts`.`notes`
`accounts`.`created_by`
`accounts`.`created_at`
`accounts`.`updated_at`
`accounts_receivable`.*
`accounts_receivable`.`id`
`accounts_receivable`.`invoice_number`
`accounts_receivable`.`debtor_type`
`accounts_receivable`.`debtor_name`
`accounts_receivable`.`debtor_code`
`accounts_receivable`.`account_code`
`accounts_receivable`.`description`
`accounts_receivable`.`invoice_date`
`accounts_receivable`.`due_date`
`accounts_receivable`.`amount`
`accounts_receivable`.`paid_amount`
`accounts_receivable`.`status`
`accounts_receivable`.`revenue_account`
`accounts_receivable`.`journal_entry_id`
`accounts_receivable`.`payment_entry_id`
`accounts_receivable`.`notes`
`accounts_receivable`.`created_by`
`accounts_receivable`.`created_at`
`accounts_receivable`.`updated_at`
`api_tokens`.*
`api_tokens`.`id`
`api_tokens`.`token`
`api_tokens`.`name`
`api_tokens`.`user_id`
`api_tokens`.`permissions`
`api_tokens`.`last_used_at`
`api_tokens`.`expires_at`
`api_tokens`.`is_active`
`api_tokens`.`created_at`
`ar_payments`.*
`ar_payments`.`id`
`ar_payments`.`ar_id`
`ar_payments`.`payment_date`
`ar_payments`.`amount`
`ar_payments`.`payment_method`
`ar_payments`.`reference`
`ar_payments`.`journal_entry_id`
`ar_payments`.`notes`
`ar_payments`.`created_by`
`ar_payments`.`created_at`
`asset_attachments`.*
`asset_attachments`.`id`
`asset_attachments`.`asset_id`
`asset_attachments`.`file_path`
`asset_attachments`.`file_type`
`asset_attachments`.`uploaded_at`
`asset_bookings`.*
`asset_bookings`.`id`
`asset_bookings`.`asset_id`
`asset_bookings`.`booking_number`
`asset_bookings`.`employee_id`
`asset_bookings`.`department_id`
`asset_bookings`.`purpose`
`asset_bookings`.`booking_date`
`asset_bookings`.`start_time`
`asset_bookings`.`end_time`
`asset_bookings`.`return_time`
`asset_bookings`.`status`
`asset_bookings`.`approved_by`
`asset_bookings`.`approved_at`
`asset_bookings`.`notes`
`asset_bookings`.`condition_on_return`
`asset_bookings`.`created_at`
`asset_depreciation_log`.*
`asset_depreciation_log`.`id`
`asset_depreciation_log`.`asset_id`
`asset_depreciation_log`.`fiscal_year`
`asset_depreciation_log`.`annual_depreciation`
`asset_depreciation_log`.`accumulated_depreciation`
`asset_depreciation_log`.`book_value`
`asset_depreciation_log`.`calculated_at`
`asset_depreciation_schedule`.*
`asset_depreciation_schedule`.`id`
`asset_depreciation_schedule`.`asset_id`
`asset_depreciation_schedule`.`depreciation_year`
`asset_depreciation_schedule`.`depreciation_month`
`asset_depreciation_schedule`.`depreciation_amount`
`asset_depreciation_schedule`.`book_value_before`
`asset_depreciation_schedule`.`book_value_after`
`asset_depreciation_schedule`.`journal_entry_id`
`asset_depreciation_schedule`.`status`
`asset_depreciation_schedule`.`created_at`
`asset_disposals`.*
`asset_disposals`.`id`
`asset_disposals`.`asset_id`
`asset_disposals`.`disposal_type`
`asset_disposals`.`disposal_date`
`asset_disposals`.`disposal_value`
`asset_disposals`.`reason`
`asset_disposals`.`recipient`
`asset_disposals`.`receipt_number`
`asset_disposals`.`approved_by`
`asset_disposals`.`notes`
`asset_disposals`.`created_by`
`asset_disposals`.`created_at`
`asset_images`.*
`asset_images`.`id`
`asset_images`.`asset_id`
`asset_images`.`image_path`
`asset_images`.`uploaded_at`
`asset_maintenance`.*
`asset_maintenance`.`id`
`asset_maintenance`.`asset_id`
`asset_maintenance`.`maintenance_date`
`asset_maintenance`.`next_due_date`
`asset_maintenance`.`description`
`asset_maintenance`.`cost`
`asset_maintenance`.`performed_by`
`asset_maintenance`.`status`
`assets`.*
`assets`.`id`
`assets`.`asset_code`
`assets`.`serial_number`
`assets`.`category_id`
`assets`.`name`
`assets`.`description`
`assets`.`addition_number`
`assets`.`added_date`
`assets`.`quantity`
`assets`.`unit_price`
`assets`.`total_value`
`assets`.`depreciation_rate`
`assets`.`warehouse_id`
`assets`.`space_id`
`assets`.`current_location`
`assets`.`supplier`
`assets`.`supplier_id`
`assets`.`warranty_expiry`
`assets`.`status`
`assets`.`image`
`assets`.`notes`
`assets`.`created_by`
`assets`.`created_at`
`assets`.`updated_at`
`assets`.`depreciation_method`
`assets`.`useful_life_years`
`assets`.`salvage_value`
`assets`.`accumulated_depreciation`
`assets`.`last_depreciation_date`
`assets`.`journal_entry_id`
`attendance`.*
`attendance`.`id`
`attendance`.`employee_id`
`attendance`.`attend_date`
`attendance`.`check_in`
`attendance`.`check_out`
`attendance`.`status`
`attendance`.`late_minutes`
`attendance`.`early_minutes`
`attendance`.`work_hours`
`attendance`.`notes`
`attendance`.`recorded_by`
`attendance`.`created_at`
`audit_log`.*
`audit_log`.`id`
`audit_log`.`user_id`
`audit_log`.`action`
`audit_log`.`module`
`audit_log`.`record_id`
`audit_log`.`details`
`audit_log`.`ip_address`
`audit_log`.`created_at`
`bank_reconciliation`.*
`bank_reconciliation`.`id`
`bank_reconciliation`.`account_code`
`bank_reconciliation`.`period_month`
`bank_reconciliation`.`period_year`
`bank_reconciliation`.`statement_date`
`bank_reconciliation`.`statement_balance`
`bank_reconciliation`.`book_balance`
`bank_reconciliation`.`difference`
`bank_reconciliation`.`status`
`bank_reconciliation`.`notes`
`bank_reconciliation`.`reconciled_by`
`bank_reconciliation`.`reconciled_at`
`bank_reconciliation`.`journal_entry_id`
`bank_reconciliation`.`created_by`
`bank_reconciliation`.`created_at`
`bank_reconciliation_items`.*
`bank_reconciliation_items`.`id`
`bank_reconciliation_items`.`reconciliation_id`
`bank_reconciliation_items`.`item_type`
`bank_reconciliation_items`.`description`
`bank_reconciliation_items`.`amount`
`bank_reconciliation_items`.`transaction_date`
`bank_reconciliation_items`.`journal_entry_id`
`bank_reconciliation_items`.`is_cleared`
`bank_reconciliation_items`.`cleared_date`
`bank_reconciliation_items`.`created_at`
`budget_transactions`.*
`budget_transactions`.`id`
`budget_transactions`.`budget_id`
`budget_transactions`.`transaction_date`
`budget_transactions`.`amount`
`budget_transactions`.`transaction_type`
`budget_transactions`.`reference_id`
`budget_transactions`.`reference_number`
`budget_transactions`.`description`
`budget_transactions`.`created_by`
`budget_transactions`.`created_at`
`budgets`.*
`budgets`.`id`
`budgets`.`fiscal_year`
`budgets`.`department_id`
`budgets`.`budget_type`
`budgets`.`title`
`budgets`.`planned_amount`
`budgets`.`notes`
`budgets`.`status`
`budgets`.`approved_by`
`budgets`.`approved_at`
`budgets`.`created_by`
`budgets`.`created_at`
`budgets`.`account_code`
`budgets`.`committed_amount`
`budgets`.`actual_amount`
`budgets`.`journal_entry_id`
`building_floors`.*
`building_floors`.`id`
`building_floors`.`building_id`
`building_floors`.`floor_num`
`building_floors`.`name`
`building_floors`.`description`
`building_floors`.`is_active`
`building_floors`.`fp_width`
`building_floors`.`fp_height`
`building_floors`.`fp_bg`
`buildings`.*
`buildings`.`id`
`buildings`.`code`
`buildings`.`name`
`buildings`.`name_en`
`buildings`.`address`
`buildings`.`floors_count`
`buildings`.`year_built`
`buildings`.`area_sqm`
`buildings`.`description`
`buildings`.`is_active`
`buildings`.`created_by`
`buildings`.`created_at`
`categories`.*
`categories`.`id`
`categories`.`code`
`categories`.`name_ar`
`categories`.`parent_id`
`categories`.`book_type`
`categories`.`depreciation_min`
`categories`.`depreciation_max`
`categories`.`level`
`clearance_approvals`.*
`clearance_approvals`.`id`
`clearance_approvals`.`request_id`
`clearance_approvals`.`step_id`
`clearance_approvals`.`status`
`clearance_approvals`.`notes`
`clearance_approvals`.`approved_by`
`clearance_approvals`.`approved_at`
`clearance_approvals`.`created_at`
`clearance_requests`.*
`clearance_requests`.`id`
`clearance_requests`.`request_number`
`clearance_requests`.`person_type`
`clearance_requests`.`person_id`
`clearance_requests`.`reason`
`clearance_requests`.`reason_notes`
`clearance_requests`.`last_working_day`
`clearance_requests`.`status`
`clearance_requests`.`notes`
`clearance_requests`.`created_by`
`clearance_requests`.`completed_at`
`clearance_requests`.`rejected_by`
`clearance_requests`.`rejected_at`
`clearance_requests`.`created_at`
`clearance_requests`.`updated_at`
`clearance_requests`.`journal_entry_id`
`clearance_steps`.*
`clearance_steps`.`id`
`clearance_steps`.`step_name`
`clearance_steps`.`step_name_en`
`clearance_steps`.`responsible_dept`
`clearance_steps`.`step_order`
`clearance_steps`.`applies_to`
`clearance_steps`.`is_required`
`clearance_steps`.`is_active`
`clearance_steps`.`notes`
`consumables`.*
`consumables`.`id`
`consumables`.`item_code`
`consumables`.`category_id`
`consumables`.`name`
`consumables`.`description`
`consumables`.`unit`
`consumables`.`current_stock`
`consumables`.`min_stock_alert`
`consumables`.`warehouse_id`
`consumables`.`supplier_id`
`consumables`.`image`
`consumables`.`is_active`
`consumables`.`created_at`
`consumables`.`account_code`
`contract_payments`.*
`contract_payments`.`id`
`contract_payments`.`contract_id`
`contract_payments`.`payment_number`
`contract_payments`.`title`
`contract_payments`.`due_date`
`contract_payments`.`amount`
`contract_payments`.`paid_date`
`contract_payments`.`paid_amount`
`contract_payments`.`status`
`contract_payments`.`notes`
`contract_payments`.`created_at`
`contract_payments`.`journal_entry_id`
`contract_payments`.`account_code`
`contracts`.*
`contracts`.`id`
`contracts`.`contract_number`
`contracts`.`title`
`contracts`.`supplier_id`
`contracts`.`contract_type`
`contracts`.`start_date`
`contracts`.`end_date`
`contracts`.`total_value`
`contracts`.`paid_value`
`contracts`.`status`
`contracts`.`description`
`contracts`.`attachment`
`contracts`.`created_by`
`contracts`.`created_at`
`contracts`.`journal_entry_id`
`contracts`.`expense_account`
`contracts`.`notes`
`correspondence`.*
`correspondence`.`id`
`correspondence`.`ref_number`
`correspondence`.`type`
`correspondence`.`direction`
`correspondence`.`subject`
`correspondence`.`category_id`
`correspondence`.`priority`
`correspondence`.`status`
`correspondence`.`sender_name`
`correspondence`.`sender_entity`
`correspondence`.`sender_ref`
`correspondence`.`sender_date`
`correspondence`.`receiver_name`
`correspondence`.`receiver_entity`
`correspondence`.`department_id`
`correspondence`.`employee_id`
`correspondence`.`assigned_to`
`correspondence`.`correspondence_date`
`correspondence`.`received_date`
`correspondence`.`due_date`
`correspondence`.`reply_date`
`correspondence`.`summary`
`correspondence`.`notes`
`correspondence`.`tags`
`correspondence`.`replied_by`
`correspondence`.`reply_ref`
`correspondence`.`parent_id`
`correspondence`.`created_by`
`correspondence`.`created_at`
`correspondence`.`updated_at`
`correspondence_attachments`.*
`correspondence_attachments`.`id`
`correspondence_attachments`.`correspondence_id`
`correspondence_attachments`.`file_name`
`correspondence_attachments`.`file_path`
`correspondence_attachments`.`file_type`
`correspondence_attachments`.`file_size`
`correspondence_attachments`.`is_primary`
`correspondence_attachments`.`uploaded_by`
`correspondence_attachments`.`uploaded_at`
`correspondence_categories`.*
`correspondence_categories`.`id`
`correspondence_categories`.`name`
`correspondence_categories`.`color`
`correspondence_categories`.`icon`
`correspondence_categories`.`sort_order`
`correspondence_categories`.`is_active`
`correspondence_log`.*
`correspondence_log`.`id`
`correspondence_log`.`correspondence_id`
`correspondence_log`.`action`
`correspondence_log`.`notes`
`correspondence_log`.`done_by`
`correspondence_log`.`done_at`
`correspondence_recipients`.*
`correspondence_recipients`.`id`
`correspondence_recipients`.`correspondence_id`
`correspondence_recipients`.`employee_id`
`correspondence_recipients`.`department_id`
`correspondence_recipients`.`recipient_name`
`correspondence_recipients`.`read_at`
`correspondence_recipients`.`acknowledged_at`
`correspondence_recipients`.`notes`
`cost_center_allocations`.*
`cost_center_allocations`.`id`
`cost_center_allocations`.`journal_entry_id`
`cost_center_allocations`.`journal_line_id`
`cost_center_allocations`.`department_id`
`cost_center_allocations`.`account_code`
`cost_center_allocations`.`amount`
`cost_center_allocations`.`allocation_pct`
`cost_center_allocations`.`fiscal_year`
`cost_center_allocations`.`fiscal_period`
`cost_center_allocations`.`notes`
`cost_center_allocations`.`created_by`
`cost_center_allocations`.`created_at`
`cost_center_distribution_keys`.*
`cost_center_distribution_keys`.`id`
`cost_center_distribution_keys`.`account_code`
`cost_center_distribution_keys`.`department_id`
`cost_center_distribution_keys`.`percentage`
`cost_center_distribution_keys`.`is_active`
`custody_records`.*
`custody_records`.`id`
`custody_records`.`employee_id`
`custody_records`.`item_type`
`custody_records`.`item_id`
`custody_records`.`voucher_number`
`custody_records`.`custody_date`
`custody_records`.`quantity`
`custody_records`.`item_condition`
`custody_records`.`movement_type`
`custody_records`.`transferred_to_employee_id`
`custody_records`.`signature_path`
`custody_records`.`verification_qr`
`custody_records`.`balance_after`
`custody_records`.`notes`
`custody_records`.`created_by`
`custody_records`.`created_at`
`custody_return_requests`.*
`custody_return_requests`.`id`
`custody_return_requests`.`employee_id`
`custody_return_requests`.`item_type`
`custody_return_requests`.`item_id`
`custody_return_requests`.`quantity`
`custody_return_requests`.`unit_codes`
`custody_return_requests`.`reason`
`custody_return_requests`.`status`
`custody_return_requests`.`reviewed_by`
`custody_return_requests`.`reviewed_at`
`custody_return_requests`.`review_notes`
`custody_return_requests`.`warehouse_id`
`custody_return_requests`.`created_at`
`custody_return_requests`.`journal_entry_id`
`custody_unit_items`.*
`custody_unit_items`.`id`
`custody_unit_items`.`custody_id`
`custody_unit_items`.`unit_id`
`custody_unit_items`.`unit_code`
`custody_unit_items`.`status`
`custody_unit_items`.`returned_at`
`custody_unit_items`.`notes`
`department_asset_entitlements`.*
`department_asset_entitlements`.`id`
`department_asset_entitlements`.`department_id`
`department_asset_entitlements`.`category_id`
`department_asset_entitlements`.`quantity_entitled`
`department_asset_entitlements`.`quantity_actual`
`department_asset_entitlements`.`notes`
`department_asset_entitlements`.`created_by`
`department_asset_entitlements`.`created_at`
`department_asset_entitlements`.`updated_at`
`departments`.*
`departments`.`id`
`departments`.`name`
`departments`.`cost_center_code`
`departments`.`budget_amount`
`departments`.`parent_id`
`disposal_reasons`.*
`disposal_reasons`.`id`
`disposal_reasons`.`name_ar`
`disposal_reasons`.`is_active`
`documents`.*
`documents`.`id`
`documents`.`title`
`documents`.`description`
`documents`.`file_path`
`documents`.`file_name`
`documents`.`file_size`
`documents`.`file_type`
`documents`.`doc_type`
`documents`.`entity_type`
`documents`.`entity_id`
`documents`.`tags`
`documents`.`is_confidential`
`documents`.`uploaded_by`
`documents`.`created_at`
`employee_entitlements`.*
`employee_entitlements`.`id`
`employee_entitlements`.`employee_id`
`employee_entitlements`.`entitlement_type`
`employee_entitlements`.`title`
`employee_entitlements`.`amount`
`employee_entitlements`.`is_recurring`
`employee_entitlements`.`period_month`
`employee_entitlements`.`period_year`
`employee_entitlements`.`status`
`employee_entitlements`.`payment_date`
`employee_entitlements`.`notes`
`employee_entitlements`.`created_by`
`employee_entitlements`.`created_at`
`employee_entitlements`.`journal_entry_id`
`employee_entitlements`.`account_code`
`employee_leave_balance`.*
`employee_leave_balance`.`id`
`employee_leave_balance`.`employee_id`
`employee_leave_balance`.`leave_type_id`
`employee_leave_balance`.`year`
`employee_leave_balance`.`total_days`
`employee_leave_balance`.`used_days`
`employee_leave_balance`.`pending_days`
`employee_payroll`.*
`employee_payroll`.`id`
`employee_payroll`.`employee_id`
`employee_payroll`.`month`
`employee_payroll`.`year`
`employee_payroll`.`basic_salary`
`employee_payroll`.`allowances`
`employee_payroll`.`bonuses`
`employee_payroll`.`deductions`
`employee_payroll`.`penalties`
`employee_payroll`.`social_insurance`
`employee_payroll`.`medical_insurance`
`employee_payroll`.`income_tax`
`employee_payroll`.`employer_social`
`employee_payroll`.`net_salary`
`employee_payroll`.`notes`
`employee_payroll`.`status`
`employee_payroll`.`paid_at`
`employee_payroll`.`created_by`
`employee_payroll`.`created_at`
`employee_payroll`.`journal_entry_id`
`employee_payroll`.`payment_entry_id`
`employee_payroll`.`gross_salary`
`employee_penalties`.*
`employee_penalties`.`id`
`employee_penalties`.`employee_id`
`employee_penalties`.`penalty_type`
`employee_penalties`.`reason`
`employee_penalties`.`amount`
`employee_penalties`.`penalty_date`
`employee_penalties`.`notes`
`employee_penalties`.`issued_by`
`employee_penalties`.`created_at`
`employee_penalties`.`journal_entry_id`
`employees`.*
`employees`.`id`
`employees`.`employee_code`
`employees`.`national_id`
`employees`.`full_name`
`employees`.`job_title`
`employees`.`department_id`
`employees`.`hire_date`
`employees`.`email`
`employees`.`phone`
`employees`.`gender`
`employees`.`birth_date`
`employees`.`basic_salary`
`employees`.`bank_account`
`employees`.`address`
`employees`.`emergency_contact`
`employees`.`emergency_phone`
`employees`.`notes`
`employees`.`status`
`employees`.`photo`
`employees`.`created_at`
`entitlement_rules`.*
`entitlement_rules`.`id`
`entitlement_rules`.`rule_name`
`entitlement_rules`.`applies_to`
`entitlement_rules`.`rank_id`
`entitlement_rules`.`staff_id`
`entitlement_rules`.`rate_theory`
`entitlement_rules`.`rate_practical`
`entitlement_rules`.`rate_extra`
`entitlement_rules`.`min_hours_extra`
`entitlement_rules`.`effective_from`
`entitlement_rules`.`effective_to`
`entitlement_rules`.`is_active`
`entitlement_rules`.`notes`
`entitlement_rules`.`created_by`
`entitlement_rules`.`created_at`
`fiscal_year_closing`.*
`fiscal_year_closing`.`id`
`fiscal_year_closing`.`fiscal_year`
`fiscal_year_closing`.`status`
`fiscal_year_closing`.`total_revenue`
`fiscal_year_closing`.`total_expense`
`fiscal_year_closing`.`net_profit_loss`
`fiscal_year_closing`.`closing_entry_id`
`fiscal_year_closing`.`transfer_entry_id`
`fiscal_year_closing`.`closed_by`
`fiscal_year_closing`.`closed_at`
`fiscal_year_closing`.`notes`
`fiscal_year_closing`.`created_at`
`goods_receipt_items`.*
`goods_receipt_items`.`id`
`goods_receipt_items`.`gr_id`
`goods_receipt_items`.`poi_id`
`goods_receipt_items`.`received_qty`
`goods_receipt_items`.`unit_price`
`goods_receipt_items`.`total_price`
`goods_receipts`.*
`goods_receipts`.`id`
`goods_receipts`.`gr_number`
`goods_receipts`.`po_id`
`goods_receipts`.`receipt_date`
`goods_receipts`.`warehouse_id`
`goods_receipts`.`total_received`
`goods_receipts`.`journal_entry_id`
`goods_receipts`.`notes`
`goods_receipts`.`created_by`
`goods_receipts`.`created_at`
`id_card_settings`.*
`id_card_settings`.`id`
`id_card_settings`.`name`
`id_card_settings`.`card_type`
`id_card_settings`.`width_mm`
`id_card_settings`.`height_mm`
`id_card_settings`.`orientation`
`id_card_settings`.`cards_per_row`
`id_card_settings`.`cards_per_page`
`id_card_settings`.`margin_mm`
`id_card_settings`.`gap_mm`
`id_card_settings`.`show_photo`
`id_card_settings`.`show_barcode`
`id_card_settings`.`show_qr`
`id_card_settings`.`show_back`
`id_card_settings`.`show_natid`
`id_card_settings`.`color_primary`
`id_card_settings`.`color_secondary`
`id_card_settings`.`printer_name`
`id_card_settings`.`paper_size`
`id_card_settings`.`is_default`
`id_card_settings`.`created_by`
`id_card_settings`.`created_at`
`invoice_payments`.*
`invoice_payments`.`id`
`invoice_payments`.`invoice_id`
`invoice_payments`.`payment_date`
`invoice_payments`.`amount`
`invoice_payments`.`payment_method`
`invoice_payments`.`reference_number`
`invoice_payments`.`notes`
`invoice_payments`.`created_by`
`invoice_payments`.`created_at`
`invoice_payments`.`journal_entry_id`
`invoice_payments`.`revenue_account`
`item_units`.*
`item_units`.`id`
`item_units`.`item_type`
`item_units`.`item_id`
`item_units`.`unit_code`
`item_units`.`warehouse_id`
`item_units`.`status`
`item_units`.`assigned_to_employee_id`
`item_units`.`last_scanned_at`
`item_units`.`notes`
`item_units`.`created_at`
`journal_approval_log`.*
`journal_approval_log`.`id`
`journal_approval_log`.`entry_id`
`journal_approval_log`.`action`
`journal_approval_log`.`user_id`
`journal_approval_log`.`notes`
`journal_approval_log`.`created_at`
`journal_entries`.*
`journal_entries`.`id`
`journal_entries`.`entry_number`
`journal_entries`.`entry_date`
`journal_entries`.`description`
`journal_entries`.`reference_type`
`journal_entries`.`reference_id`
`journal_entries`.`reference_number`
`journal_entries`.`fiscal_year`
`journal_entries`.`fiscal_period`
`journal_entries`.`total_debit`
`journal_entries`.`total_credit`
`journal_entries`.`status`
`journal_entries`.`approval_status`
`journal_entries`.`approval_required`
`journal_entries`.`reviewed_by`
`journal_entries`.`reviewed_at`
`journal_entries`.`review_notes`
`journal_entries`.`posted_by`
`journal_entries`.`posted_at`
`journal_entries`.`reversed_entry`
`journal_entries`.`notes`
`journal_entries`.`created_by`
`journal_entries`.`created_at`
`journal_entries`.`updated_at`
`journal_entry_lines`.*
`journal_entry_lines`.`id`
`journal_entry_lines`.`entry_id`
`journal_entry_lines`.`line_number`
`journal_entry_lines`.`account_id`
`journal_entry_lines`.`description`
`journal_entry_lines`.`debit_amount`
`journal_entry_lines`.`credit_amount`
`journal_entry_lines`.`cost_center`
`leave_requests`.*
`leave_requests`.`id`
`leave_requests`.`request_number`
`leave_requests`.`employee_id`
`leave_requests`.`leave_type_id`
`leave_requests`.`start_date`
`leave_requests`.`end_date`
`leave_requests`.`days_count`
`leave_requests`.`reason`
`leave_requests`.`status`
`leave_requests`.`manager_id`
`leave_requests`.`manager_notes`
`leave_requests`.`manager_decided_at`
`leave_requests`.`hr_id`
`leave_requests`.`hr_notes`
`leave_requests`.`hr_decided_at`
`leave_requests`.`created_by`
`leave_requests`.`created_at`
`leave_requests`.`updated_at`
`leave_types`.*
`leave_types`.`id`
`leave_types`.`name_ar`
`leave_types`.`name_en`
`leave_types`.`days_per_year`
`leave_types`.`is_paid`
`leave_types`.`color`
`leave_types`.`is_active`
`leave_types`.`created_at`
`notifications`.*
`notifications`.`id`
`notifications`.`user_id`
`notifications`.`title`
`notifications`.`message`
`notifications`.`is_read`
`notifications`.`link`
`notifications`.`created_at`
`notifications`.`type`
`official_holidays`.*
`official_holidays`.`id`
`official_holidays`.`name`
`official_holidays`.`holiday_date`
`official_holidays`.`year`
`official_holidays`.`is_recurring`
`payroll_settings`.*
`payroll_settings`.`id`
`payroll_settings`.`setting_key`
`payroll_settings`.`value`
`payroll_settings`.`description`
`payroll_settings`.`updated_at`
`performance_criteria`.*
`performance_criteria`.`id`
`performance_criteria`.`template_id`
`performance_criteria`.`name`
`performance_criteria`.`description`
`performance_criteria`.`max_score`
`performance_criteria`.`weight`
`performance_criteria`.`category`
`performance_criteria`.`sort_order`
`performance_evaluations`.*
`performance_evaluations`.`id`
`performance_evaluations`.`employee_id`
`performance_evaluations`.`template_id`
`performance_evaluations`.`evaluator_id`
`performance_evaluations`.`period_year`
`performance_evaluations`.`period_quarter`
`performance_evaluations`.`period_month`
`performance_evaluations`.`eval_date`
`performance_evaluations`.`total_score`
`performance_evaluations`.`max_score`
`performance_evaluations`.`percentage`
`performance_evaluations`.`grade`
`performance_evaluations`.`notes`
`performance_evaluations`.`strengths`
`performance_evaluations`.`improvements`
`performance_evaluations`.`status`
`performance_evaluations`.`approved_by`
`performance_evaluations`.`approved_at`
`performance_evaluations`.`created_at`
`performance_scores`.*
`performance_scores`.`id`
`performance_scores`.`evaluation_id`
`performance_scores`.`criteria_id`
`performance_scores`.`score`
`performance_scores`.`notes`
`performance_templates`.*
`performance_templates`.`id`
`performance_templates`.`name`
`performance_templates`.`description`
`performance_templates`.`period`
`performance_templates`.`is_active`
`performance_templates`.`created_by`
`performance_templates`.`created_at`
`permissions`.*
`permissions`.`id`
`permissions`.`module`
`permissions`.`action`
`po_receipt_items`.*
`po_receipt_items`.`id`
`po_receipt_items`.`receipt_id`
`po_receipt_items`.`po_item_id`
`po_receipt_items`.`quantity_received`
`po_receipt_items`.`condition_notes`
`po_receipts`.*
`po_receipts`.`id`
`po_receipts`.`po_id`
`po_receipts`.`receipt_date`
`po_receipts`.`received_by`
`po_receipts`.`notes`
`po_receipts`.`created_at`
`prepaid_amortization`.*
`prepaid_amortization`.`id`
`prepaid_amortization`.`prepaid_id`
`prepaid_amortization`.`period_year`
`prepaid_amortization`.`period_month`
`prepaid_amortization`.`amount`
`prepaid_amortization`.`journal_entry_id`
`prepaid_amortization`.`status`
`prepaid_amortization`.`posted_at`
`prepaid_expenses`.*
`prepaid_expenses`.`id`
`prepaid_expenses`.`entry_number`
`prepaid_expenses`.`description`
`prepaid_expenses`.`vendor_name`
`prepaid_expenses`.`expense_account`
`prepaid_expenses`.`total_amount`
`prepaid_expenses`.`start_date`
`prepaid_expenses`.`end_date`
`prepaid_expenses`.`months_total`
`prepaid_expenses`.`monthly_amount`
`prepaid_expenses`.`amortized_amount`
`prepaid_expenses`.`remaining_amount`
`prepaid_expenses`.`status`
`prepaid_expenses`.`initial_entry_id`
`prepaid_expenses`.`notes`
`prepaid_expenses`.`created_by`
`prepaid_expenses`.`created_at`
`project_assets`.*
`project_assets`.`id`
`project_assets`.`project_id`
`project_assets`.`asset_id`
`project_assets`.`consumable_id`
`project_assets`.`quantity`
`project_assets`.`assigned_date`
`project_assets`.`return_date`
`project_assets`.`notes`
`project_expenses`.*
`project_expenses`.`id`
`project_expenses`.`project_id`
`project_expenses`.`expense_date`
`project_expenses`.`category`
`project_expenses`.`description`
`project_expenses`.`amount`
`project_expenses`.`reference_id`
`project_expenses`.`reference_type`
`project_expenses`.`created_by`
`project_expenses`.`created_at`
`project_expenses`.`journal_entry_id`
`project_expenses`.`account_code`
`project_team`.*
`project_team`.`id`
`project_team`.`project_id`
`project_team`.`staff_id`
`project_team`.`role_in_project`
`project_team`.`join_date`
`purchase_order_items`.*
`purchase_order_items`.`id`
`purchase_order_items`.`po_id`
`purchase_order_items`.`item_type`
`purchase_order_items`.`item_id`
`purchase_order_items`.`item_name`
`purchase_order_items`.`item_code`
`purchase_order_items`.`quantity_ordered`
`purchase_order_items`.`quantity_received`
`purchase_order_items`.`unit_price`
`purchase_order_items`.`total_price`
`purchase_order_items`.`notes`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`po_number`
`purchase_orders`.`supplier_id`
`purchase_orders`.`warehouse_id`
`purchase_orders`.`department_id`
`purchase_orders`.`order_date`
`purchase_orders`.`expected_delivery`
`purchase_orders`.`actual_delivery`
`purchase_orders`.`total_amount`
`purchase_orders`.`status`
`purchase_orders`.`notes`
`purchase_orders`.`tender_id`
`purchase_orders`.`invoice_id`
`purchase_orders`.`created_by`
`purchase_orders`.`approved_by`
`purchase_orders`.`approved_at`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_orders`.`budget_id`
`purchase_orders`.`journal_entry_id`
`purchase_orders`.`payment_entry_id`
`purchase_orders`.`item_type`
`purchase_orders`.`received_amount`
`purchase_orders`.`paid_amount`
`regulation_acknowledgments`.*
`regulation_acknowledgments`.`id`
`regulation_acknowledgments`.`regulation_id`
`regulation_acknowledgments`.`user_id`
`regulation_acknowledgments`.`employee_id`
`regulation_acknowledgments`.`acknowledged_at`
`regulation_acknowledgments`.`notes`
`regulation_categories`.*
`regulation_categories`.`id`
`regulation_categories`.`name_ar`
`regulation_categories`.`name_en`
`regulation_categories`.`icon`
`regulation_categories`.`color`
`regulation_categories`.`sort_order`
`regulation_categories`.`is_active`
`regulation_categories`.`created_at`
`regulation_reads`.*
`regulation_reads`.`id`
`regulation_reads`.`regulation_id`
`regulation_reads`.`user_id`
`regulation_reads`.`employee_id`
`regulation_reads`.`read_at`
`regulations`.*
`regulations`.`id`
`regulations`.`reg_number`
`regulations`.`title`
`regulations`.`category_id`
`regulations`.`description`
`regulations`.`content`
`regulations`.`file_path`
`regulations`.`file_name`
`regulations`.`version`
`regulations`.`status`
`regulations`.`effective_date`
`regulations`.`expiry_date`
`regulations`.`related_module`
`regulations`.`requires_ack`
`regulations`.`tags`
`regulations`.`views_count`
`regulations`.`created_by`
`regulations`.`updated_by`
`regulations`.`created_at`
`regulations`.`updated_at`
`requisition_approvals`.*
`requisition_approvals`.`id`
`requisition_approvals`.`requisition_id`
`requisition_approvals`.`approver_id`
`requisition_approvals`.`approval_level`
`requisition_approvals`.`decision`
`requisition_approvals`.`comments`
`requisition_approvals`.`decided_at`
`requisition_items`.*
`requisition_items`.`id`
`requisition_items`.`requisition_id`
`requisition_items`.`item_type`
`requisition_items`.`item_id`
`requisition_items`.`quantity_requested`
`requisition_items`.`quantity_approved`
`requisition_items`.`space_id`
`requisition_items`.`quantity_delivered`
`requisition_unit_items`.*
`requisition_unit_items`.`id`
`requisition_unit_items`.`requisition_id`
`requisition_unit_items`.`item_id`
`requisition_unit_items`.`unit_id`
`requisition_unit_items`.`unit_code`
`requisition_unit_items`.`created_at`
`requisitions`.*
`requisitions`.`id`
`requisitions`.`request_number`
`requisitions`.`employee_id`
`requisitions`.`warehouse_id`
`requisitions`.`reason`
`requisitions`.`priority`
`requisitions`.`status`
`requisitions`.`created_at`
`requisitions`.`updated_at`
`research_projects`.*
`research_projects`.`id`
`research_projects`.`project_code`
`research_projects`.`title_ar`
`research_projects`.`title_en`
`research_projects`.`project_type`
`research_projects`.`department_id`
`research_projects`.`principal_investigator_id`
`research_projects`.`start_date`
`research_projects`.`end_date`
`research_projects`.`budget`
`research_projects`.`funding_source`
`research_projects`.`status`
`research_projects`.`description`
`research_projects`.`created_by`
`research_projects`.`created_at`
`research_projects`.`journal_entry_id`
`research_projects`.`expense_account`
`research_projects`.`actual_spent`
`revenue_entries`.*
`revenue_entries`.`id`
`revenue_entries`.`entry_number`
`revenue_entries`.`revenue_date`
`revenue_entries`.`revenue_type`
`revenue_entries`.`account_code`
`revenue_entries`.`payer_name`
`revenue_entries`.`payer_type`
`revenue_entries`.`description`
`revenue_entries`.`amount`
`revenue_entries`.`vat_amount`
`revenue_entries`.`total_amount`
`revenue_entries`.`payment_method`
`revenue_entries`.`reference_number`
`revenue_entries`.`bank_account`
`revenue_entries`.`journal_entry_id`
`revenue_entries`.`fiscal_year`
`revenue_entries`.`fiscal_period`
`revenue_entries`.`status`
`revenue_entries`.`notes`
`revenue_entries`.`created_by`
`revenue_entries`.`created_at`
`role_permissions`.*
`role_permissions`.`role_id`
`role_permissions`.`permission_id`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`description`
`roles`.`created_at`
`room_allocations`.*
`room_allocations`.`id`
`room_allocations`.`space_id`
`room_allocations`.`academic_course_id`
`room_allocations`.`assignment_id`
`room_allocations`.`semester_id`
`room_allocations`.`allocated_to`
`room_allocations`.`purpose`
`room_allocations`.`day_of_week`
`room_allocations`.`start_time`
`room_allocations`.`end_time`
`room_allocations`.`start_date`
`room_allocations`.`end_date`
`room_allocations`.`recurrence`
`room_allocations`.`capacity`
`room_allocations`.`notes`
`room_allocations`.`status`
`room_allocations`.`created_by`
`room_allocations`.`created_at`
`scheduled_reports`.*
`scheduled_reports`.`id`
`scheduled_reports`.`name`
`scheduled_reports`.`report_type`
`scheduled_reports`.`frequency`
`scheduled_reports`.`send_day`
`scheduled_reports`.`send_time`
`scheduled_reports`.`recipients`
`scheduled_reports`.`last_sent`
`scheduled_reports`.`next_send`
`scheduled_reports`.`is_active`
`scheduled_reports`.`parameters`
`scheduled_reports`.`created_by`
`scheduled_reports`.`created_at`
`space_assignment_log`.*
`space_assignment_log`.`id`
`space_assignment_log`.`asset_id`
`space_assignment_log`.`space_id`
`space_assignment_log`.`assigned_date`
`space_assignment_log`.`moved_out_date`
`space_assignment_log`.`assigned_by`
`space_assignment_log`.`notes`
`space_assignment_log`.`created_at`
`space_types`.*
`space_types`.`id`
`space_types`.`name_ar`
`space_types`.`is_active`
`spaces`.*
`spaces`.`id`
`spaces`.`code`
`spaces`.`name`
`spaces`.`space_type_id`
`spaces`.`building`
`spaces`.`building_id`
`spaces`.`floor`
`spaces`.`floor_id`
`spaces`.`capacity`
`spaces`.`notes`
`spaces`.`is_active`
`spaces`.`created_at`
`spaces`.`fp_x`
`spaces`.`fp_y`
`spaces`.`fp_w`
`spaces`.`fp_h`
`spaces`.`fp_color`
`spaces`.`fp_floor_id`
`staff_monthly_entitlements`.*
`staff_monthly_entitlements`.`id`
`staff_monthly_entitlements`.`staff_id`
`staff_monthly_entitlements`.`semester_id`
`staff_monthly_entitlements`.`month`
`staff_monthly_entitlements`.`year`
`staff_monthly_entitlements`.`total_theory_hours`
`staff_monthly_entitlements`.`total_practical_hours`
`staff_monthly_entitlements`.`total_extra_hours`
`staff_monthly_entitlements`.`rate_theory`
`staff_monthly_entitlements`.`rate_practical`
`staff_monthly_entitlements`.`rate_extra`
`staff_monthly_entitlements`.`amount_theory`
`staff_monthly_entitlements`.`amount_practical`
`staff_monthly_entitlements`.`amount_extra`
`staff_monthly_entitlements`.`deductions`
`staff_monthly_entitlements`.`net_amount`
`staff_monthly_entitlements`.`status`
`staff_monthly_entitlements`.`notes`
`staff_monthly_entitlements`.`approved_by`
`staff_monthly_entitlements`.`approved_at`
`staff_monthly_entitlements`.`paid_at`
`staff_monthly_entitlements`.`created_at`
`stock_count_items`.*
`stock_count_items`.`id`
`stock_count_items`.`stock_count_id`
`stock_count_items`.`item_type`
`stock_count_items`.`item_id`
`stock_count_items`.`expected_quantity`
`stock_count_items`.`actual_quantity`
`stock_count_items`.`difference`
`stock_count_items`.`notes`
`stock_counts`.*
`stock_counts`.`id`
`stock_counts`.`warehouse_id`
`stock_counts`.`count_date`
`stock_counts`.`performed_by`
`stock_counts`.`status`
`stock_counts`.`count_type`
`stock_movements`.*
`stock_movements`.`id`
`stock_movements`.`item_type`
`stock_movements`.`item_id`
`stock_movements`.`warehouse_id`
`stock_movements`.`movement_date`
`stock_movements`.`voucher_number`
`stock_movements`.`source_destination`
`stock_movements`.`quantity_in`
`stock_movements`.`quantity_out_actual`
`stock_movements`.`quantity_out_other`
`stock_movements`.`disposal_reason_id`
`stock_movements`.`item_condition`
`stock_movements`.`balance_after`
`stock_movements`.`notes`
`stock_movements`.`created_by`
`stock_movements`.`created_at`
`supplier_evaluations`.*
`supplier_evaluations`.`id`
`supplier_evaluations`.`supplier_id`
`supplier_evaluations`.`po_id`
`supplier_evaluations`.`eval_date`
`supplier_evaluations`.`evaluator_id`
`supplier_evaluations`.`quality_score`
`supplier_evaluations`.`delivery_score`
`supplier_evaluations`.`price_score`
`supplier_evaluations`.`service_score`
`supplier_evaluations`.`docs_score`
`supplier_evaluations`.`total_score`
`supplier_evaluations`.`percentage`
`supplier_evaluations`.`grade`
`supplier_evaluations`.`notes`
`supplier_evaluations`.`created_at`
`supplier_invoices`.*
`supplier_invoices`.`id`
`supplier_invoices`.`supplier_id`
`supplier_invoices`.`invoice_number`
`supplier_invoices`.`invoice_date`
`supplier_invoices`.`due_date`
`supplier_invoices`.`amount`
`supplier_invoices`.`paid_amount`
`supplier_invoices`.`currency`
`supplier_invoices`.`status`
`supplier_invoices`.`related_asset_id`
`supplier_invoices`.`related_po`
`supplier_invoices`.`notes`
`supplier_invoices`.`attachment`
`supplier_invoices`.`created_by`
`supplier_invoices`.`created_at`
`supplier_invoices`.`updated_at`
`supplier_invoices_acc`.*
`supplier_invoices_acc`.`id`
`supplier_invoices_acc`.`invoice_number`
`supplier_invoices_acc`.`supplier_id`
`supplier_invoices_acc`.`po_id`
`supplier_invoices_acc`.`gr_id`
`supplier_invoices_acc`.`invoice_date`
`supplier_invoices_acc`.`due_date`
`supplier_invoices_acc`.`amount`
`supplier_invoices_acc`.`vat_amount`
`supplier_invoices_acc`.`total_amount`
`supplier_invoices_acc`.`paid_amount`
`supplier_invoices_acc`.`status`
`supplier_invoices_acc`.`journal_entry_id`
`supplier_invoices_acc`.`payment_entry_id`
`supplier_invoices_acc`.`notes`
`supplier_invoices_acc`.`created_by`
`supplier_invoices_acc`.`created_at`
`supplier_payments`.*
`supplier_payments`.`id`
`supplier_payments`.`payment_number`
`supplier_payments`.`supplier_id`
`supplier_payments`.`invoice_id`
`supplier_payments`.`payment_date`
`supplier_payments`.`amount`
`supplier_payments`.`payment_method`
`supplier_payments`.`bank_account`
`supplier_payments`.`reference_number`
`supplier_payments`.`journal_entry_id`
`supplier_payments`.`notes`
`supplier_payments`.`created_by`
`supplier_payments`.`created_at`
`supplier_price_history`.*
`supplier_price_history`.`id`
`supplier_price_history`.`supplier_id`
`supplier_price_history`.`item_name`
`supplier_price_history`.`item_code`
`supplier_price_history`.`unit_price`
`supplier_price_history`.`currency`
`supplier_price_history`.`price_date`
`supplier_price_history`.`source`
`supplier_price_history`.`source_id`
`supplier_price_history`.`notes`
`supplier_price_history`.`created_by`
`supplier_price_history`.`created_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`contact_person`
`suppliers`.`phone`
`suppliers`.`email`
`suppliers`.`address`
`suppliers`.`tax_number`
`suppliers`.`notes`
`suppliers`.`is_active`
`suppliers`.`created_at`
`suppliers`.`rating`
`suppliers`.`eval_count`
`suppliers`.`category`
`suppliers`.`bank_name`
`suppliers`.`bank_account`
`suppliers`.`payment_terms`
`system_settings`.*
`system_settings`.`setting_key`
`system_settings`.`setting_value`
`system_settings`.`setting_type`
`system_settings`.`label_ar`
`system_settings`.`group_name`
`system_settings`.`updated_at`
`tax_brackets`.*
`tax_brackets`.`id`
`tax_brackets`.`min_amount`
`tax_brackets`.`max_amount`
`tax_brackets`.`rate`
`tax_brackets`.`description`
`teaching_assignments`.*
`teaching_assignments`.`id`
`teaching_assignments`.`staff_id`
`teaching_assignments`.`course_id`
`teaching_assignments`.`semester_id`
`teaching_assignments`.`section_name`
`teaching_assignments`.`student_count`
`teaching_assignments`.`teaching_type`
`teaching_assignments`.`weekly_theory_hours`
`teaching_assignments`.`weekly_practical_hours`
`teaching_assignments`.`is_extra`
`teaching_assignments`.`notes`
`teaching_assignments`.`created_by`
`teaching_assignments`.`created_at`
`teaching_attendance`.*
`teaching_attendance`.`id`
`teaching_attendance`.`assignment_id`
`teaching_attendance`.`session_date`
`teaching_attendance`.`status`
`teaching_attendance`.`actual_hours`
`teaching_attendance`.`notes`
`teaching_attendance`.`recorded_by`
`teaching_attendance`.`created_at`
`tender_items`.*
`tender_items`.`id`
`tender_items`.`tender_id`
`tender_items`.`item_name`
`tender_items`.`quantity`
`tender_items`.`unit`
`tender_items`.`specifications`
`tender_offer_items`.*
`tender_offer_items`.`id`
`tender_offer_items`.`offer_id`
`tender_offer_items`.`tender_item_id`
`tender_offer_items`.`unit_price`
`tender_offer_items`.`total_price`
`tender_offer_items`.`notes`
`tender_offers`.*
`tender_offers`.`id`
`tender_offers`.`tender_id`
`tender_offers`.`supplier_id`
`tender_offers`.`submission_date`
`tender_offers`.`total_amount`
`tender_offers`.`delivery_days`
`tender_offers`.`warranty_months`
`tender_offers`.`technical_score`
`tender_offers`.`financial_score`
`tender_offers`.`final_score`
`tender_offers`.`status`
`tender_offers`.`notes`
`tender_offers`.`created_at`
`tenders`.*
`tenders`.`id`
`tenders`.`tender_number`
`tenders`.`title`
`tenders`.`description`
`tenders`.`tender_type`
`tenders`.`department_id`
`tenders`.`estimated_value`
`tenders`.`publish_date`
`tenders`.`submission_deadline`
`tenders`.`opening_date`
`tenders`.`status`
`tenders`.`winner_supplier_id`
`tenders`.`awarded_amount`
`tenders`.`notes`
`tenders`.`created_by`
`tenders`.`created_at`
`users`.*
`users`.`id`
`users`.`username`
`users`.`password_hash`
`users`.`employee_id`
`users`.`role_id`
`users`.`warehouse_id`
`users`.`is_active`
`users`.`two_factor_enabled`
`users`.`two_factor_secret`
`users`.`last_login`
`users`.`created_at`
`users`.`api_token`
`users`.`fcm_token`
`warehouse_transfers`.*
`warehouse_transfers`.`id`
`warehouse_transfers`.`item_type`
`warehouse_transfers`.`item_id`
`warehouse_transfers`.`from_warehouse_id`
`warehouse_transfers`.`to_warehouse_id`
`warehouse_transfers`.`quantity`
`warehouse_transfers`.`transfer_date`
`warehouse_transfers`.`approved_by`
`warehouse_transfers`.`notes`
`warehouse_transfers`.`created_at`
`warehouses`.*
`warehouses`.`id`
`warehouses`.`name`
`warehouses`.`location`
`warehouses`.`building_id`
`warehouses`.`manager_id`
`warehouses`.`is_active`
`weekly_schedule`.*
`weekly_schedule`.`id`
`weekly_schedule`.`assignment_id`
`weekly_schedule`.`semester_id`
`weekly_schedule`.`day_of_week`
`weekly_schedule`.`start_time`
`weekly_schedule`.`end_time`
`weekly_schedule`.`room`
`weekly_schedule`.`schedule_type`
`weekly_schedule`.`notes`
`work_schedule`.*
`work_schedule`.`id`
`work_schedule`.`name`
`work_schedule`.`work_start`
`work_schedule`.`work_end`
`work_schedule`.`late_tolerance`
`work_schedule`.`work_days`
`work_schedule`.`is_default`
`work_schedule`.`created_at`
`workflow_configs`.*
`workflow_configs`.`id`
`workflow_configs`.`workflow_type`
`workflow_configs`.`step_number`
`workflow_configs`.`step_name`
`workflow_configs`.`approver_role_id`
`workflow_configs`.`approver_user_id`
`workflow_configs`.`condition_field`
`workflow_configs`.`condition_operator`
`workflow_configs`.`condition_value`
`workflow_configs`.`is_active`
`workflow_configs`.`notify_on_reach`
`workflow_configs`.`created_at`
`academic_courses`.*
`academic_courses`.`id`
`academic_courses`.`course_code`
`academic_courses`.`name_ar`
`academic_courses`.`name_en`
`academic_courses`.`department_id`
`academic_courses`.`credit_hours`
`academic_courses`.`theory_hours`
`academic_courses`.`practical_hours`
`academic_courses`.`level`
`academic_courses`.`is_active`
`academic_courses`.`notes`
`academic_courses`.`created_at`
`academic_payroll`.*
`academic_payroll`.`id`
`academic_payroll`.`staff_id`
`academic_payroll`.`semester_id`
`academic_payroll`.`month`
`academic_payroll`.`year`
`academic_payroll`.`theory_hours`
`academic_payroll`.`practical_hours`
`academic_payroll`.`extra_hours`
`academic_payroll`.`theory_amount`
`academic_payroll`.`practical_amount`
`academic_payroll`.`extra_amount`
`academic_payroll`.`gross_salary`
`academic_payroll`.`deductions`
`academic_payroll`.`net_salary`
`academic_payroll`.`status`
`academic_payroll`.`journal_entry_id`
`academic_payroll`.`payment_entry_id`
`academic_payroll`.`notes`
`academic_payroll`.`created_by`
`academic_payroll`.`created_at`
`academic_ranks`.*
`academic_ranks`.`id`
`academic_ranks`.`name_ar`
`academic_ranks`.`name_en`
`academic_ranks`.`code`
`academic_ranks`.`sort_order`
`academic_ranks`.`base_hourly_theory`
`academic_ranks`.`base_hourly_practical`
`academic_ranks`.`base_hourly_extra`
`academic_ranks`.`min_hours_required`
`academic_ranks`.`max_hours_allowed`
`academic_ranks`.`is_active`
`academic_ranks`.`notes`
`academic_ranks`.`created_at`
`academic_semesters`.*
`academic_semesters`.`id`
`academic_semesters`.`name_ar`
`academic_semesters`.`academic_year`
`academic_semesters`.`semester_number`
`academic_semesters`.`start_date`
`academic_semesters`.`end_date`
`academic_semesters`.`status`
`academic_semesters`.`created_at`
`academic_staff`.*
`academic_staff`.`id`
`academic_staff`.`staff_code`
`academic_staff`.`full_name`
`academic_staff`.`full_name_en`
`academic_staff`.`rank_id`
`academic_staff`.`department_id`
`academic_staff`.`national_id`
`academic_staff`.`email`
`academic_staff`.`phone`
`academic_staff`.`hire_date`
`academic_staff`.`photo`
`academic_staff`.`salary_basic`
`academic_staff`.`staff_type`
`academic_staff`.`custom_hourly_theory`
`academic_staff`.`custom_hourly_practical`
`academic_staff`.`custom_hourly_extra`
`academic_staff`.`portal_username`
`academic_staff`.`portal_password`
`academic_staff`.`portal_active`
`academic_staff`.`status`
`academic_staff`.`notes`
`academic_staff`.`created_by`
`academic_staff`.`created_at`
`accounting_periods`.*
`accounting_periods`.`id`
`accounting_periods`.`fiscal_year`
`accounting_periods`.`fiscal_period`
`accounting_periods`.`period_name`
`accounting_periods`.`start_date`
`accounting_periods`.`end_date`
`accounting_periods`.`status`
`accounting_periods`.`closed_by`
`accounting_periods`.`closed_at`
`accounting_periods`.`opening_entry_id`
`accounting_periods`.`closing_notes`
`accounting_periods`.`total_debit`
`accounting_periods`.`total_credit`
`accounting_periods`.`entries_count`
`accounting_periods`.`created_at`
`accounts`.*
`accounts`.`id`
`accounts`.`code`
`accounts`.`name_ar`
`accounts`.`name_en`
`accounts`.`parent_id`
`accounts`.`account_type`
`accounts`.`account_class`
`accounts`.`level`
`accounts`.`is_parent`
`accounts`.`normal_balance`
`accounts`.`opening_balance`
`accounts`.`is_active`
`accounts`.`notes`
`accounts`.`created_by`
`accounts`.`created_at`
`accounts`.`updated_at`
`accounts_receivable`.*
`accounts_receivable`.`id`
`accounts_receivable`.`invoice_number`
`accounts_receivable`.`debtor_type`
`accounts_receivable`.`debtor_name`
`accounts_receivable`.`debtor_code`
`accounts_receivable`.`account_code`
`accounts_receivable`.`description`
`accounts_receivable`.`invoice_date`
`accounts_receivable`.`due_date`
`accounts_receivable`.`amount`
`accounts_receivable`.`paid_amount`
`accounts_receivable`.`status`
`accounts_receivable`.`revenue_account`
`accounts_receivable`.`journal_entry_id`
`accounts_receivable`.`payment_entry_id`
`accounts_receivable`.`notes`
`accounts_receivable`.`created_by`
`accounts_receivable`.`created_at`
`accounts_receivable`.`updated_at`
`api_tokens`.*
`api_tokens`.`id`
`api_tokens`.`token`
`api_tokens`.`name`
`api_tokens`.`user_id`
`api_tokens`.`permissions`
`api_tokens`.`last_used_at`
`api_tokens`.`expires_at`
`api_tokens`.`is_active`
`api_tokens`.`created_at`
`ar_payments`.*
`ar_payments`.`id`
`ar_payments`.`ar_id`
`ar_payments`.`payment_date`
`ar_payments`.`amount`
`ar_payments`.`payment_method`
`ar_payments`.`reference`
`ar_payments`.`journal_entry_id`
`ar_payments`.`notes`
`ar_payments`.`created_by`
`ar_payments`.`created_at`
`asset_attachments`.*
`asset_attachments`.`id`
`asset_attachments`.`asset_id`
`asset_attachments`.`file_path`
`asset_attachments`.`file_type`
`asset_attachments`.`uploaded_at`
`asset_bookings`.*
`asset_bookings`.`id`
`asset_bookings`.`asset_id`
`asset_bookings`.`booking_number`
`asset_bookings`.`employee_id`
`asset_bookings`.`department_id`
`asset_bookings`.`purpose`
`asset_bookings`.`booking_date`
`asset_bookings`.`start_time`
`asset_bookings`.`end_time`
`asset_bookings`.`return_time`
`asset_bookings`.`status`
`asset_bookings`.`approved_by`
`asset_bookings`.`approved_at`
`asset_bookings`.`notes`
`asset_bookings`.`condition_on_return`
`asset_bookings`.`created_at`
`asset_depreciation_log`.*
`asset_depreciation_log`.`id`
`asset_depreciation_log`.`asset_id`
`asset_depreciation_log`.`fiscal_year`
`asset_depreciation_log`.`annual_depreciation`
`asset_depreciation_log`.`accumulated_depreciation`
`asset_depreciation_log`.`book_value`
`asset_depreciation_log`.`calculated_at`
`asset_depreciation_schedule`.*
`asset_depreciation_schedule`.`id`
`asset_depreciation_schedule`.`asset_id`
`asset_depreciation_schedule`.`depreciation_year`
`asset_depreciation_schedule`.`depreciation_month`
`asset_depreciation_schedule`.`depreciation_amount`
`asset_depreciation_schedule`.`book_value_before`
`asset_depreciation_schedule`.`book_value_after`
`asset_depreciation_schedule`.`journal_entry_id`
`asset_depreciation_schedule`.`status`
`asset_depreciation_schedule`.`created_at`
`asset_disposals`.*
`asset_disposals`.`id`
`asset_disposals`.`asset_id`
`asset_disposals`.`disposal_type`
`asset_disposals`.`disposal_date`
`asset_disposals`.`disposal_value`
`asset_disposals`.`reason`
`asset_disposals`.`recipient`
`asset_disposals`.`receipt_number`
`asset_disposals`.`approved_by`
`asset_disposals`.`notes`
`asset_disposals`.`created_by`
`asset_disposals`.`created_at`
`asset_images`.*
`asset_images`.`id`
`asset_images`.`asset_id`
`asset_images`.`image_path`
`asset_images`.`uploaded_at`
`asset_maintenance`.*
`asset_maintenance`.`id`
`asset_maintenance`.`asset_id`
`asset_maintenance`.`maintenance_date`
`asset_maintenance`.`next_due_date`
`asset_maintenance`.`description`
`asset_maintenance`.`cost`
`asset_maintenance`.`performed_by`
`asset_maintenance`.`status`
`assets`.*
`assets`.`id`
`assets`.`asset_code`
`assets`.`serial_number`
`assets`.`category_id`
`assets`.`name`
`assets`.`description`
`assets`.`addition_number`
`assets`.`added_date`
`assets`.`quantity`
`assets`.`unit_price`
`assets`.`total_value`
`assets`.`depreciation_rate`
`assets`.`warehouse_id`
`assets`.`space_id`
`assets`.`current_location`
`assets`.`supplier`
`assets`.`supplier_id`
`assets`.`warranty_expiry`
`assets`.`status`
`assets`.`image`
`assets`.`notes`
`assets`.`created_by`
`assets`.`created_at`
`assets`.`updated_at`
`assets`.`depreciation_method`
`assets`.`useful_life_years`
`assets`.`salvage_value`
`assets`.`accumulated_depreciation`
`assets`.`last_depreciation_date`
`assets`.`journal_entry_id`
`attendance`.*
`attendance`.`id`
`attendance`.`employee_id`
`attendance`.`attend_date`
`attendance`.`check_in`
`attendance`.`check_out`
`attendance`.`status`
`attendance`.`late_minutes`
`attendance`.`early_minutes`
`attendance`.`work_hours`
`attendance`.`notes`
`attendance`.`recorded_by`
`attendance`.`created_at`
`audit_log`.*
`audit_log`.`id`
`audit_log`.`user_id`
`audit_log`.`action`
`audit_log`.`module`
`audit_log`.`record_id`
`audit_log`.`details`
`audit_log`.`ip_address`
`audit_log`.`created_at`
`bank_reconciliation`.*
`bank_reconciliation`.`id`
`bank_reconciliation`.`account_code`
`bank_reconciliation`.`period_month`
`bank_reconciliation`.`period_year`
`bank_reconciliation`.`statement_date`
`bank_reconciliation`.`statement_balance`
`bank_reconciliation`.`book_balance`
`bank_reconciliation`.`difference`
`bank_reconciliation`.`status`
`bank_reconciliation`.`notes`
`bank_reconciliation`.`reconciled_by`
`bank_reconciliation`.`reconciled_at`
`bank_reconciliation`.`journal_entry_id`
`bank_reconciliation`.`created_by`
`bank_reconciliation`.`created_at`
`bank_reconciliation_items`.*
`bank_reconciliation_items`.`id`
`bank_reconciliation_items`.`reconciliation_id`
`bank_reconciliation_items`.`item_type`
`bank_reconciliation_items`.`description`
`bank_reconciliation_items`.`amount`
`bank_reconciliation_items`.`transaction_date`
`bank_reconciliation_items`.`journal_entry_id`
`bank_reconciliation_items`.`is_cleared`
`bank_reconciliation_items`.`cleared_date`
`bank_reconciliation_items`.`created_at`
`budget_transactions`.*
`budget_transactions`.`id`
`budget_transactions`.`budget_id`
`budget_transactions`.`transaction_date`
`budget_transactions`.`amount`
`budget_transactions`.`transaction_type`
`budget_transactions`.`reference_id`
`budget_transactions`.`reference_number`
`budget_transactions`.`description`
`budget_transactions`.`created_by`
`budget_transactions`.`created_at`
`budgets`.*
`budgets`.`id`
`budgets`.`fiscal_year`
`budgets`.`department_id`
`budgets`.`budget_type`
`budgets`.`title`
`budgets`.`planned_amount`
`budgets`.`notes`
`budgets`.`status`
`budgets`.`approved_by`
`budgets`.`approved_at`
`budgets`.`created_by`
`budgets`.`created_at`
`budgets`.`account_code`
`budgets`.`committed_amount`
`budgets`.`actual_amount`
`budgets`.`journal_entry_id`
`building_floors`.*
`building_floors`.`id`
`building_floors`.`building_id`
`building_floors`.`floor_num`
`building_floors`.`name`
`building_floors`.`description`
`building_floors`.`is_active`
`building_floors`.`fp_width`
`building_floors`.`fp_height`
`building_floors`.`fp_bg`
`buildings`.*
`buildings`.`id`
`buildings`.`code`
`buildings`.`name`
`buildings`.`name_en`
`buildings`.`address`
`buildings`.`floors_count`
`buildings`.`year_built`
`buildings`.`area_sqm`
`buildings`.`description`
`buildings`.`is_active`
`buildings`.`created_by`
`buildings`.`created_at`
`categories`.*
`categories`.`id`
`categories`.`code`
`categories`.`name_ar`
`categories`.`parent_id`
`categories`.`book_type`
`categories`.`depreciation_min`
`categories`.`depreciation_max`
`categories`.`level`
`clearance_approvals`.*
`clearance_approvals`.`id`
`clearance_approvals`.`request_id`
`clearance_approvals`.`step_id`
`clearance_approvals`.`status`
`clearance_approvals`.`notes`
`clearance_approvals`.`approved_by`
`clearance_approvals`.`approved_at`
`clearance_approvals`.`created_at`
`clearance_requests`.*
`clearance_requests`.`id`
`clearance_requests`.`request_number`
`clearance_requests`.`person_type`
`clearance_requests`.`person_id`
`clearance_requests`.`reason`
`clearance_requests`.`reason_notes`
`clearance_requests`.`last_working_day`
`clearance_requests`.`status`
`clearance_requests`.`notes`
`clearance_requests`.`created_by`
`clearance_requests`.`completed_at`
`clearance_requests`.`rejected_by`
`clearance_requests`.`rejected_at`
`clearance_requests`.`created_at`
`clearance_requests`.`updated_at`
`clearance_requests`.`journal_entry_id`
`clearance_steps`.*
`clearance_steps`.`id`
`clearance_steps`.`step_name`
`clearance_steps`.`step_name_en`
`clearance_steps`.`responsible_dept`
`clearance_steps`.`step_order`
`clearance_steps`.`applies_to`
`clearance_steps`.`is_required`
`clearance_steps`.`is_active`
`clearance_steps`.`notes`
`consumables`.*
`consumables`.`id`
`consumables`.`item_code`
`consumables`.`category_id`
`consumables`.`name`
`consumables`.`description`
`consumables`.`unit`
`consumables`.`current_stock`
`consumables`.`min_stock_alert`
`consumables`.`warehouse_id`
`consumables`.`supplier_id`
`consumables`.`image`
`consumables`.`is_active`
`consumables`.`created_at`
`consumables`.`account_code`
`contract_payments`.*
`contract_payments`.`id`
`contract_payments`.`contract_id`
`contract_payments`.`payment_number`
`contract_payments`.`title`
`contract_payments`.`due_date`
`contract_payments`.`amount`
`contract_payments`.`paid_date`
`contract_payments`.`paid_amount`
`contract_payments`.`status`
`contract_payments`.`notes`
`contract_payments`.`created_at`
`contract_payments`.`journal_entry_id`
`contract_payments`.`account_code`
`contracts`.*
`contracts`.`id`
`contracts`.`contract_number`
`contracts`.`title`
`contracts`.`supplier_id`
`contracts`.`contract_type`
`contracts`.`start_date`
`contracts`.`end_date`
`contracts`.`total_value`
`contracts`.`paid_value`
`contracts`.`status`
`contracts`.`description`
`contracts`.`attachment`
`contracts`.`created_by`
`contracts`.`created_at`
`contracts`.`journal_entry_id`
`contracts`.`expense_account`
`contracts`.`notes`
`correspondence`.*
`correspondence`.`id`
`correspondence`.`ref_number`
`correspondence`.`type`
`correspondence`.`direction`
`correspondence`.`subject`
`correspondence`.`category_id`
`correspondence`.`priority`
`correspondence`.`status`
`correspondence`.`sender_name`
`correspondence`.`sender_entity`
`correspondence`.`sender_ref`
`correspondence`.`sender_date`
`correspondence`.`receiver_name`
`correspondence`.`receiver_entity`
`correspondence`.`department_id`
`correspondence`.`employee_id`
`correspondence`.`assigned_to`
`correspondence`.`correspondence_date`
`correspondence`.`received_date`
`correspondence`.`due_date`
`correspondence`.`reply_date`
`correspondence`.`summary`
`correspondence`.`notes`
`correspondence`.`tags`
`correspondence`.`replied_by`
`correspondence`.`reply_ref`
`correspondence`.`parent_id`
`correspondence`.`created_by`
`correspondence`.`created_at`
`correspondence`.`updated_at`
`correspondence_attachments`.*
`correspondence_attachments`.`id`
`correspondence_attachments`.`correspondence_id`
`correspondence_attachments`.`file_name`
`correspondence_attachments`.`file_path`
`correspondence_attachments`.`file_type`
`correspondence_attachments`.`file_size`
`correspondence_attachments`.`is_primary`
`correspondence_attachments`.`uploaded_by`
`correspondence_attachments`.`uploaded_at`
`correspondence_categories`.*
`correspondence_categories`.`id`
`correspondence_categories`.`name`
`correspondence_categories`.`color`
`correspondence_categories`.`icon`
`correspondence_categories`.`sort_order`
`correspondence_categories`.`is_active`
`correspondence_log`.*
`correspondence_log`.`id`
`correspondence_log`.`correspondence_id`
`correspondence_log`.`action`
`correspondence_log`.`notes`
`correspondence_log`.`done_by`
`correspondence_log`.`done_at`
`correspondence_recipients`.*
`correspondence_recipients`.`id`
`correspondence_recipients`.`correspondence_id`
`correspondence_recipients`.`employee_id`
`correspondence_recipients`.`department_id`
`correspondence_recipients`.`recipient_name`
`correspondence_recipients`.`read_at`
`correspondence_recipients`.`acknowledged_at`
`correspondence_recipients`.`notes`
`cost_center_allocations`.*
`cost_center_allocations`.`id`
`cost_center_allocations`.`journal_entry_id`
`cost_center_allocations`.`journal_line_id`
`cost_center_allocations`.`department_id`
`cost_center_allocations`.`account_code`
`cost_center_allocations`.`amount`
`cost_center_allocations`.`allocation_pct`
`cost_center_allocations`.`fiscal_year`
`cost_center_allocations`.`fiscal_period`
`cost_center_allocations`.`notes`
`cost_center_allocations`.`created_by`
`cost_center_allocations`.`created_at`
`cost_center_distribution_keys`.*
`cost_center_distribution_keys`.`id`
`cost_center_distribution_keys`.`account_code`
`cost_center_distribution_keys`.`department_id`
`cost_center_distribution_keys`.`percentage`
`cost_center_distribution_keys`.`is_active`
`custody_records`.*
`custody_records`.`id`
`custody_records`.`employee_id`
`custody_records`.`item_type`
`custody_records`.`item_id`
`custody_records`.`voucher_number`
`custody_records`.`custody_date`
`custody_records`.`quantity`
`custody_records`.`item_condition`
`custody_records`.`movement_type`
`custody_records`.`transferred_to_employee_id`
`custody_records`.`signature_path`
`custody_records`.`verification_qr`
`custody_records`.`balance_after`
`custody_records`.`notes`
`custody_records`.`created_by`
`custody_records`.`created_at`
`custody_return_requests`.*
`custody_return_requests`.`id`
`custody_return_requests`.`employee_id`
`custody_return_requests`.`item_type`
`custody_return_requests`.`item_id`
`custody_return_requests`.`quantity`
`custody_return_requests`.`unit_codes`
`custody_return_requests`.`reason`
`custody_return_requests`.`status`
`custody_return_requests`.`reviewed_by`
`custody_return_requests`.`reviewed_at`
`custody_return_requests`.`review_notes`
`custody_return_requests`.`warehouse_id`
`custody_return_requests`.`created_at`
`custody_return_requests`.`journal_entry_id`
`custody_unit_items`.*
`custody_unit_items`.`id`
`custody_unit_items`.`custody_id`
`custody_unit_items`.`unit_id`
`custody_unit_items`.`unit_code`
`custody_unit_items`.`status`
`custody_unit_items`.`returned_at`
`custody_unit_items`.`notes`
`department_asset_entitlements`.*
`department_asset_entitlements`.`id`
`department_asset_entitlements`.`department_id`
`department_asset_entitlements`.`category_id`
`department_asset_entitlements`.`quantity_entitled`
`department_asset_entitlements`.`quantity_actual`
`department_asset_entitlements`.`notes`
`department_asset_entitlements`.`created_by`
`department_asset_entitlements`.`created_at`
`department_asset_entitlements`.`updated_at`
`departments`.*
`departments`.`id`
`departments`.`name`
`departments`.`cost_center_code`
`departments`.`budget_amount`
`departments`.`parent_id`
`disposal_reasons`.*
`disposal_reasons`.`id`
`disposal_reasons`.`name_ar`
`disposal_reasons`.`is_active`
`documents`.*
`documents`.`id`
`documents`.`title`
`documents`.`description`
`documents`.`file_path`
`documents`.`file_name`
`documents`.`file_size`
`documents`.`file_type`
`documents`.`doc_type`
`documents`.`entity_type`
`documents`.`entity_id`
`documents`.`tags`
`documents`.`is_confidential`
`documents`.`uploaded_by`
`documents`.`created_at`
`employee_entitlements`.*
`employee_entitlements`.`id`
`employee_entitlements`.`employee_id`
`employee_entitlements`.`entitlement_type`
`employee_entitlements`.`title`
`employee_entitlements`.`amount`
`employee_entitlements`.`is_recurring`
`employee_entitlements`.`period_month`
`employee_entitlements`.`period_year`
`employee_entitlements`.`status`
`employee_entitlements`.`payment_date`
`employee_entitlements`.`notes`
`employee_entitlements`.`created_by`
`employee_entitlements`.`created_at`
`employee_entitlements`.`journal_entry_id`
`employee_entitlements`.`account_code`
`employee_leave_balance`.*
`employee_leave_balance`.`id`
`employee_leave_balance`.`employee_id`
`employee_leave_balance`.`leave_type_id`
`employee_leave_balance`.`year`
`employee_leave_balance`.`total_days`
`employee_leave_balance`.`used_days`
`employee_leave_balance`.`pending_days`
`employee_payroll`.*
`employee_payroll`.`id`
`employee_payroll`.`employee_id`
`employee_payroll`.`month`
`employee_payroll`.`year`
`employee_payroll`.`basic_salary`
`employee_payroll`.`allowances`
`employee_payroll`.`bonuses`
`employee_payroll`.`deductions`
`employee_payroll`.`penalties`
`employee_payroll`.`social_insurance`
`employee_payroll`.`medical_insurance`
`employee_payroll`.`income_tax`
`employee_payroll`.`employer_social`
`employee_payroll`.`net_salary`
`employee_payroll`.`notes`
`employee_payroll`.`status`
`employee_payroll`.`paid_at`
`employee_payroll`.`created_by`
`employee_payroll`.`created_at`
`employee_payroll`.`journal_entry_id`
`employee_payroll`.`payment_entry_id`
`employee_payroll`.`gross_salary`
`employee_penalties`.*
`employee_penalties`.`id`
`employee_penalties`.`employee_id`
`employee_penalties`.`penalty_type`
`employee_penalties`.`reason`
`employee_penalties`.`amount`
`employee_penalties`.`penalty_date`
`employee_penalties`.`notes`
`employee_penalties`.`issued_by`
`employee_penalties`.`created_at`
`employee_penalties`.`journal_entry_id`
`employees`.*
`employees`.`id`
`employees`.`employee_code`
`employees`.`national_id`
`employees`.`full_name`
`employees`.`job_title`
`employees`.`department_id`
`employees`.`hire_date`
`employees`.`email`
`employees`.`phone`
`employees`.`gender`
`employees`.`birth_date`
`employees`.`basic_salary`
`employees`.`bank_account`
`employees`.`address`
`employees`.`emergency_contact`
`employees`.`emergency_phone`
`employees`.`notes`
`employees`.`status`
`employees`.`photo`
`employees`.`created_at`
`entitlement_rules`.*
`entitlement_rules`.`id`
`entitlement_rules`.`rule_name`
`entitlement_rules`.`applies_to`
`entitlement_rules`.`rank_id`
`entitlement_rules`.`staff_id`
`entitlement_rules`.`rate_theory`
`entitlement_rules`.`rate_practical`
`entitlement_rules`.`rate_extra`
`entitlement_rules`.`min_hours_extra`
`entitlement_rules`.`effective_from`
`entitlement_rules`.`effective_to`
`entitlement_rules`.`is_active`
`entitlement_rules`.`notes`
`entitlement_rules`.`created_by`
`entitlement_rules`.`created_at`
`fiscal_year_closing`.*
`fiscal_year_closing`.`id`
`fiscal_year_closing`.`fiscal_year`
`fiscal_year_closing`.`status`
`fiscal_year_closing`.`total_revenue`
`fiscal_year_closing`.`total_expense`
`fiscal_year_closing`.`net_profit_loss`
`fiscal_year_closing`.`closing_entry_id`
`fiscal_year_closing`.`transfer_entry_id`
`fiscal_year_closing`.`closed_by`
`fiscal_year_closing`.`closed_at`
`fiscal_year_closing`.`notes`
`fiscal_year_closing`.`created_at`
`goods_receipt_items`.*
`goods_receipt_items`.`id`
`goods_receipt_items`.`gr_id`
`goods_receipt_items`.`poi_id`
`goods_receipt_items`.`received_qty`
`goods_receipt_items`.`unit_price`
`goods_receipt_items`.`total_price`
`goods_receipts`.*
`goods_receipts`.`id`
`goods_receipts`.`gr_number`
`goods_receipts`.`po_id`
`goods_receipts`.`receipt_date`
`goods_receipts`.`warehouse_id`
`goods_receipts`.`total_received`
`goods_receipts`.`journal_entry_id`
`goods_receipts`.`notes`
`goods_receipts`.`created_by`
`goods_receipts`.`created_at`
`id_card_settings`.*
`id_card_settings`.`id`
`id_card_settings`.`name`
`id_card_settings`.`card_type`
`id_card_settings`.`width_mm`
`id_card_settings`.`height_mm`
`id_card_settings`.`orientation`
`id_card_settings`.`cards_per_row`
`id_card_settings`.`cards_per_page`
`id_card_settings`.`margin_mm`
`id_card_settings`.`gap_mm`
`id_card_settings`.`show_photo`
`id_card_settings`.`show_barcode`
`id_card_settings`.`show_qr`
`id_card_settings`.`show_back`
`id_card_settings`.`show_natid`
`id_card_settings`.`color_primary`
`id_card_settings`.`color_secondary`
`id_card_settings`.`printer_name`
`id_card_settings`.`paper_size`
`id_card_settings`.`is_default`
`id_card_settings`.`created_by`
`id_card_settings`.`created_at`
`invoice_payments`.*
`invoice_payments`.`id`
`invoice_payments`.`invoice_id`
`invoice_payments`.`payment_date`
`invoice_payments`.`amount`
`invoice_payments`.`payment_method`
`invoice_payments`.`reference_number`
`invoice_payments`.`notes`
`invoice_payments`.`created_by`
`invoice_payments`.`created_at`
`invoice_payments`.`journal_entry_id`
`invoice_payments`.`revenue_account`
`item_units`.*
`item_units`.`id`
`item_units`.`item_type`
`item_units`.`item_id`
`item_units`.`unit_code`
`item_units`.`warehouse_id`
`item_units`.`status`
`item_units`.`assigned_to_employee_id`
`item_units`.`last_scanned_at`
`item_units`.`notes`
`item_units`.`created_at`
`journal_approval_log`.*
`journal_approval_log`.`id`
`journal_approval_log`.`entry_id`
`journal_approval_log`.`action`
`journal_approval_log`.`user_id`
`journal_approval_log`.`notes`
`journal_approval_log`.`created_at`
`journal_entries`.*
`journal_entries`.`id`
`journal_entries`.`entry_number`
`journal_entries`.`entry_date`
`journal_entries`.`description`
`journal_entries`.`reference_type`
`journal_entries`.`reference_id`
`journal_entries`.`reference_number`
`journal_entries`.`fiscal_year`
`journal_entries`.`fiscal_period`
`journal_entries`.`total_debit`
`journal_entries`.`total_credit`
`journal_entries`.`status`
`journal_entries`.`approval_status`
`journal_entries`.`approval_required`
`journal_entries`.`reviewed_by`
`journal_entries`.`reviewed_at`
`journal_entries`.`review_notes`
`journal_entries`.`posted_by`
`journal_entries`.`posted_at`
`journal_entries`.`reversed_entry`
`journal_entries`.`notes`
`journal_entries`.`created_by`
`journal_entries`.`created_at`
`journal_entries`.`updated_at`
`journal_entry_lines`.*
`journal_entry_lines`.`id`
`journal_entry_lines`.`entry_id`
`journal_entry_lines`.`line_number`
`journal_entry_lines`.`account_id`
`journal_entry_lines`.`description`
`journal_entry_lines`.`debit_amount`
`journal_entry_lines`.`credit_amount`
`journal_entry_lines`.`cost_center`
`leave_requests`.*
`leave_requests`.`id`
`leave_requests`.`request_number`
`leave_requests`.`employee_id`
`leave_requests`.`leave_type_id`
`leave_requests`.`start_date`
`leave_requests`.`end_date`
`leave_requests`.`days_count`
`leave_requests`.`reason`
`leave_requests`.`status`
`leave_requests`.`manager_id`
`leave_requests`.`manager_notes`
`leave_requests`.`manager_decided_at`
`leave_requests`.`hr_id`
`leave_requests`.`hr_notes`
`leave_requests`.`hr_decided_at`
`leave_requests`.`created_by`
`leave_requests`.`created_at`
`leave_requests`.`updated_at`
`leave_types`.*
`leave_types`.`id`
`leave_types`.`name_ar`
`leave_types`.`name_en`
`leave_types`.`days_per_year`
`leave_types`.`is_paid`
`leave_types`.`color`
`leave_types`.`is_active`
`leave_types`.`created_at`
`notifications`.*
`notifications`.`id`
`notifications`.`user_id`
`notifications`.`title`
`notifications`.`message`
`notifications`.`is_read`
`notifications`.`link`
`notifications`.`created_at`
`notifications`.`type`
`official_holidays`.*
`official_holidays`.`id`
`official_holidays`.`name`
`official_holidays`.`holiday_date`
`official_holidays`.`year`
`official_holidays`.`is_recurring`
`payroll_settings`.*
`payroll_settings`.`id`
`payroll_settings`.`setting_key`
`payroll_settings`.`value`
`payroll_settings`.`description`
`payroll_settings`.`updated_at`
`performance_criteria`.*
`performance_criteria`.`id`
`performance_criteria`.`template_id`
`performance_criteria`.`name`
`performance_criteria`.`description`
`performance_criteria`.`max_score`
`performance_criteria`.`weight`
`performance_criteria`.`category`
`performance_criteria`.`sort_order`
`performance_evaluations`.*
`performance_evaluations`.`id`
`performance_evaluations`.`employee_id`
`performance_evaluations`.`template_id`
`performance_evaluations`.`evaluator_id`
`performance_evaluations`.`period_year`
`performance_evaluations`.`period_quarter`
`performance_evaluations`.`period_month`
`performance_evaluations`.`eval_date`
`performance_evaluations`.`total_score`
`performance_evaluations`.`max_score`
`performance_evaluations`.`percentage`
`performance_evaluations`.`grade`
`performance_evaluations`.`notes`
`performance_evaluations`.`strengths`
`performance_evaluations`.`improvements`
`performance_evaluations`.`status`
`performance_evaluations`.`approved_by`
`performance_evaluations`.`approved_at`
`performance_evaluations`.`created_at`
`performance_scores`.*
`performance_scores`.`id`
`performance_scores`.`evaluation_id`
`performance_scores`.`criteria_id`
`performance_scores`.`score`
`performance_scores`.`notes`
`performance_templates`.*
`performance_templates`.`id`
`performance_templates`.`name`
`performance_templates`.`description`
`performance_templates`.`period`
`performance_templates`.`is_active`
`performance_templates`.`created_by`
`performance_templates`.`created_at`
`permissions`.*
`permissions`.`id`
`permissions`.`module`
`permissions`.`action`
`po_receipt_items`.*
`po_receipt_items`.`id`
`po_receipt_items`.`receipt_id`
`po_receipt_items`.`po_item_id`
`po_receipt_items`.`quantity_received`
`po_receipt_items`.`condition_notes`
`po_receipts`.*
`po_receipts`.`id`
`po_receipts`.`po_id`
`po_receipts`.`receipt_date`
`po_receipts`.`received_by`
`po_receipts`.`notes`
`po_receipts`.`created_at`
`prepaid_amortization`.*
`prepaid_amortization`.`id`
`prepaid_amortization`.`prepaid_id`
`prepaid_amortization`.`period_year`
`prepaid_amortization`.`period_month`
`prepaid_amortization`.`amount`
`prepaid_amortization`.`journal_entry_id`
`prepaid_amortization`.`status`
`prepaid_amortization`.`posted_at`
`prepaid_expenses`.*
`prepaid_expenses`.`id`
`prepaid_expenses`.`entry_number`
`prepaid_expenses`.`description`
`prepaid_expenses`.`vendor_name`
`prepaid_expenses`.`expense_account`
`prepaid_expenses`.`total_amount`
`prepaid_expenses`.`start_date`
`prepaid_expenses`.`end_date`
`prepaid_expenses`.`months_total`
`prepaid_expenses`.`monthly_amount`
`prepaid_expenses`.`amortized_amount`
`prepaid_expenses`.`remaining_amount`
`prepaid_expenses`.`status`
`prepaid_expenses`.`initial_entry_id`
`prepaid_expenses`.`notes`
`prepaid_expenses`.`created_by`
`prepaid_expenses`.`created_at`
`project_assets`.*
`project_assets`.`id`
`project_assets`.`project_id`
`project_assets`.`asset_id`
`project_assets`.`consumable_id`
`project_assets`.`quantity`
`project_assets`.`assigned_date`
`project_assets`.`return_date`
`project_assets`.`notes`
`project_expenses`.*
`project_expenses`.`id`
`project_expenses`.`project_id`
`project_expenses`.`expense_date`
`project_expenses`.`category`
`project_expenses`.`description`
`project_expenses`.`amount`
`project_expenses`.`reference_id`
`project_expenses`.`reference_type`
`project_expenses`.`created_by`
`project_expenses`.`created_at`
`project_expenses`.`journal_entry_id`
`project_expenses`.`account_code`
`project_team`.*
`project_team`.`id`
`project_team`.`project_id`
`project_team`.`staff_id`
`project_team`.`role_in_project`
`project_team`.`join_date`
`purchase_order_items`.*
`purchase_order_items`.`id`
`purchase_order_items`.`po_id`
`purchase_order_items`.`item_type`
`purchase_order_items`.`item_id`
`purchase_order_items`.`item_name`
`purchase_order_items`.`item_code`
`purchase_order_items`.`quantity_ordered`
`purchase_order_items`.`quantity_received`
`purchase_order_items`.`unit_price`
`purchase_order_items`.`total_price`
`purchase_order_items`.`notes`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`po_number`
`purchase_orders`.`supplier_id`
`purchase_orders`.`warehouse_id`
`purchase_orders`.`department_id`
`purchase_orders`.`order_date`
`purchase_orders`.`expected_delivery`
`purchase_orders`.`actual_delivery`
`purchase_orders`.`total_amount`
`purchase_orders`.`status`
`purchase_orders`.`notes`
`purchase_orders`.`tender_id`
`purchase_orders`.`invoice_id`
`purchase_orders`.`created_by`
`purchase_orders`.`approved_by`
`purchase_orders`.`approved_at`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_orders`.`budget_id`
`purchase_orders`.`journal_entry_id`
`purchase_orders`.`payment_entry_id`
`purchase_orders`.`item_type`
`purchase_orders`.`received_amount`
`purchase_orders`.`paid_amount`
`regulation_acknowledgments`.*
`regulation_acknowledgments`.`id`
`regulation_acknowledgments`.`regulation_id`
`regulation_acknowledgments`.`user_id`
`regulation_acknowledgments`.`employee_id`
`regulation_acknowledgments`.`acknowledged_at`
`regulation_acknowledgments`.`notes`
`regulation_categories`.*
`regulation_categories`.`id`
`regulation_categories`.`name_ar`
`regulation_categories`.`name_en`
`regulation_categories`.`icon`
`regulation_categories`.`color`
`regulation_categories`.`sort_order`
`regulation_categories`.`is_active`
`regulation_categories`.`created_at`
`regulation_reads`.*
`regulation_reads`.`id`
`regulation_reads`.`regulation_id`
`regulation_reads`.`user_id`
`regulation_reads`.`employee_id`
`regulation_reads`.`read_at`
`regulations`.*
`regulations`.`id`
`regulations`.`reg_number`
`regulations`.`title`
`regulations`.`category_id`
`regulations`.`description`
`regulations`.`content`
`regulations`.`file_path`
`regulations`.`file_name`
`regulations`.`version`
`regulations`.`status`
`regulations`.`effective_date`
`regulations`.`expiry_date`
`regulations`.`related_module`
`regulations`.`requires_ack`
`regulations`.`tags`
`regulations`.`views_count`
`regulations`.`created_by`
`regulations`.`updated_by`
`regulations`.`created_at`
`regulations`.`updated_at`
`requisition_approvals`.*
`requisition_approvals`.`id`
`requisition_approvals`.`requisition_id`
`requisition_approvals`.`approver_id`
`requisition_approvals`.`approval_level`
`requisition_approvals`.`decision`
`requisition_approvals`.`comments`
`requisition_approvals`.`decided_at`
`requisition_items`.*
`requisition_items`.`id`
`requisition_items`.`requisition_id`
`requisition_items`.`item_type`
`requisition_items`.`item_id`
`requisition_items`.`quantity_requested`
`requisition_items`.`quantity_approved`
`requisition_items`.`space_id`
`requisition_items`.`quantity_delivered`
`requisition_unit_items`.*
`requisition_unit_items`.`id`
`requisition_unit_items`.`requisition_id`
`requisition_unit_items`.`item_id`
`requisition_unit_items`.`unit_id`
`requisition_unit_items`.`unit_code`
`requisition_unit_items`.`created_at`
`requisitions`.*
`requisitions`.`id`
`requisitions`.`request_number`
`requisitions`.`employee_id`
`requisitions`.`warehouse_id`
`requisitions`.`reason`
`requisitions`.`priority`
`requisitions`.`status`
`requisitions`.`created_at`
`requisitions`.`updated_at`
`research_projects`.*
`research_projects`.`id`
`research_projects`.`project_code`
`research_projects`.`title_ar`
`research_projects`.`title_en`
`research_projects`.`project_type`
`research_projects`.`department_id`
`research_projects`.`principal_investigator_id`
`research_projects`.`start_date`
`research_projects`.`end_date`
`research_projects`.`budget`
`research_projects`.`funding_source`
`research_projects`.`status`
`research_projects`.`description`
`research_projects`.`created_by`
`research_projects`.`created_at`
`research_projects`.`journal_entry_id`
`research_projects`.`expense_account`
`research_projects`.`actual_spent`
`revenue_entries`.*
`revenue_entries`.`id`
`revenue_entries`.`entry_number`
`revenue_entries`.`revenue_date`
`revenue_entries`.`revenue_type`
`revenue_entries`.`account_code`
`revenue_entries`.`payer_name`
`revenue_entries`.`payer_type`
`revenue_entries`.`description`
`revenue_entries`.`amount`
`revenue_entries`.`vat_amount`
`revenue_entries`.`total_amount`
`revenue_entries`.`payment_method`
`revenue_entries`.`reference_number`
`revenue_entries`.`bank_account`
`revenue_entries`.`journal_entry_id`
`revenue_entries`.`fiscal_year`
`revenue_entries`.`fiscal_period`
`revenue_entries`.`status`
`revenue_entries`.`notes`
`revenue_entries`.`created_by`
`revenue_entries`.`created_at`
`role_permissions`.*
`role_permissions`.`role_id`
`role_permissions`.`permission_id`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`description`
`roles`.`created_at`
`room_allocations`.*
`room_allocations`.`id`
`room_allocations`.`space_id`
`room_allocations`.`academic_course_id`
`room_allocations`.`assignment_id`
`room_allocations`.`semester_id`
`room_allocations`.`allocated_to`
`room_allocations`.`purpose`
`room_allocations`.`day_of_week`
`room_allocations`.`start_time`
`room_allocations`.`end_time`
`room_allocations`.`start_date`
`room_allocations`.`end_date`
`room_allocations`.`recurrence`
`room_allocations`.`capacity`
`room_allocations`.`notes`
`room_allocations`.`status`
`room_allocations`.`created_by`
`room_allocations`.`created_at`
`scheduled_reports`.*
`scheduled_reports`.`id`
`scheduled_reports`.`name`
`scheduled_reports`.`report_type`
`scheduled_reports`.`frequency`
`scheduled_reports`.`send_day`
`scheduled_reports`.`send_time`
`scheduled_reports`.`recipients`
`scheduled_reports`.`last_sent`
`scheduled_reports`.`next_send`
`scheduled_reports`.`is_active`
`scheduled_reports`.`parameters`
`scheduled_reports`.`created_by`
`scheduled_reports`.`created_at`
`space_assignment_log`.*
`space_assignment_log`.`id`
`space_assignment_log`.`asset_id`
`space_assignment_log`.`space_id`
`space_assignment_log`.`assigned_date`
`space_assignment_log`.`moved_out_date`
`space_assignment_log`.`assigned_by`
`space_assignment_log`.`notes`
`space_assignment_log`.`created_at`
`space_types`.*
`space_types`.`id`
`space_types`.`name_ar`
`space_types`.`is_active`
`spaces`.*
`spaces`.`id`
`spaces`.`code`
`spaces`.`name`
`spaces`.`space_type_id`
`spaces`.`building`
`spaces`.`building_id`
`spaces`.`floor`
`spaces`.`floor_id`
`spaces`.`capacity`
`spaces`.`notes`
`spaces`.`is_active`
`spaces`.`created_at`
`spaces`.`fp_x`
`spaces`.`fp_y`
`spaces`.`fp_w`
`spaces`.`fp_h`
`spaces`.`fp_color`
`spaces`.`fp_floor_id`
`staff_monthly_entitlements`.*
`staff_monthly_entitlements`.`id`
`staff_monthly_entitlements`.`staff_id`
`staff_monthly_entitlements`.`semester_id`
`staff_monthly_entitlements`.`month`
`staff_monthly_entitlements`.`year`
`staff_monthly_entitlements`.`total_theory_hours`
`staff_monthly_entitlements`.`total_practical_hours`
`staff_monthly_entitlements`.`total_extra_hours`
`staff_monthly_entitlements`.`rate_theory`
`staff_monthly_entitlements`.`rate_practical`
`staff_monthly_entitlements`.`rate_extra`
`staff_monthly_entitlements`.`amount_theory`
`staff_monthly_entitlements`.`amount_practical`
`staff_monthly_entitlements`.`amount_extra`
`staff_monthly_entitlements`.`deductions`
`staff_monthly_entitlements`.`net_amount`
`staff_monthly_entitlements`.`status`
`staff_monthly_entitlements`.`notes`
`staff_monthly_entitlements`.`approved_by`
`staff_monthly_entitlements`.`approved_at`
`staff_monthly_entitlements`.`paid_at`
`staff_monthly_entitlements`.`created_at`
`stock_count_items`.*
`stock_count_items`.`id`
`stock_count_items`.`stock_count_id`
`stock_count_items`.`item_type`
`stock_count_items`.`item_id`
`stock_count_items`.`expected_quantity`
`stock_count_items`.`actual_quantity`
`stock_count_items`.`difference`
`stock_count_items`.`notes`
`stock_counts`.*
`stock_counts`.`id`
`stock_counts`.`warehouse_id`
`stock_counts`.`count_date`
`stock_counts`.`performed_by`
`stock_counts`.`status`
`stock_counts`.`count_type`
`stock_movements`.*
`stock_movements`.`id`
`stock_movements`.`item_type`
`stock_movements`.`item_id`
`stock_movements`.`warehouse_id`
`stock_movements`.`movement_date`
`stock_movements`.`voucher_number`
`stock_movements`.`source_destination`
`stock_movements`.`quantity_in`
`stock_movements`.`quantity_out_actual`
`stock_movements`.`quantity_out_other`
`stock_movements`.`disposal_reason_id`
`stock_movements`.`item_condition`
`stock_movements`.`balance_after`
`stock_movements`.`notes`
`stock_movements`.`created_by`
`stock_movements`.`created_at`
`supplier_evaluations`.*
`supplier_evaluations`.`id`
`supplier_evaluations`.`supplier_id`
`supplier_evaluations`.`po_id`
`supplier_evaluations`.`eval_date`
`supplier_evaluations`.`evaluator_id`
`supplier_evaluations`.`quality_score`
`supplier_evaluations`.`delivery_score`
`supplier_evaluations`.`price_score`
`supplier_evaluations`.`service_score`
`supplier_evaluations`.`docs_score`
`supplier_evaluations`.`total_score`
`supplier_evaluations`.`percentage`
`supplier_evaluations`.`grade`
`supplier_evaluations`.`notes`
`supplier_evaluations`.`created_at`
`supplier_invoices`.*
`supplier_invoices`.`id`
`supplier_invoices`.`supplier_id`
`supplier_invoices`.`invoice_number`
`supplier_invoices`.`invoice_date`
`supplier_invoices`.`due_date`
`supplier_invoices`.`amount`
`supplier_invoices`.`paid_amount`
`supplier_invoices`.`currency`
`supplier_invoices`.`status`
`supplier_invoices`.`related_asset_id`
`supplier_invoices`.`related_po`
`supplier_invoices`.`notes`
`supplier_invoices`.`attachment`
`supplier_invoices`.`created_by`
`supplier_invoices`.`created_at`
`supplier_invoices`.`updated_at`
`supplier_invoices_acc`.*
`supplier_invoices_acc`.`id`
`supplier_invoices_acc`.`invoice_number`
`supplier_invoices_acc`.`supplier_id`
`supplier_invoices_acc`.`po_id`
`supplier_invoices_acc`.`gr_id`
`supplier_invoices_acc`.`invoice_date`
`supplier_invoices_acc`.`due_date`
`supplier_invoices_acc`.`amount`
`supplier_invoices_acc`.`vat_amount`
`supplier_invoices_acc`.`total_amount`
`supplier_invoices_acc`.`paid_amount`
`supplier_invoices_acc`.`status`
`supplier_invoices_acc`.`journal_entry_id`
`supplier_invoices_acc`.`payment_entry_id`
`supplier_invoices_acc`.`notes`
`supplier_invoices_acc`.`created_by`
`supplier_invoices_acc`.`created_at`
`supplier_payments`.*
`supplier_payments`.`id`
`supplier_payments`.`payment_number`
`supplier_payments`.`supplier_id`
`supplier_payments`.`invoice_id`
`supplier_payments`.`payment_date`
`supplier_payments`.`amount`
`supplier_payments`.`payment_method`
`supplier_payments`.`bank_account`
`supplier_payments`.`reference_number`
`supplier_payments`.`journal_entry_id`
`supplier_payments`.`notes`
`supplier_payments`.`created_by`
`supplier_payments`.`created_at`
`supplier_price_history`.*
`supplier_price_history`.`id`
`supplier_price_history`.`supplier_id`
`supplier_price_history`.`item_name`
`supplier_price_history`.`item_code`
`supplier_price_history`.`unit_price`
`supplier_price_history`.`currency`
`supplier_price_history`.`price_date`
`supplier_price_history`.`source`
`supplier_price_history`.`source_id`
`supplier_price_history`.`notes`
`supplier_price_history`.`created_by`
`supplier_price_history`.`created_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`contact_person`
`suppliers`.`phone`
`suppliers`.`email`
`suppliers`.`address`
`suppliers`.`tax_number`
`suppliers`.`notes`
`suppliers`.`is_active`
`suppliers`.`created_at`
`suppliers`.`rating`
`suppliers`.`eval_count`
`suppliers`.`category`
`suppliers`.`bank_name`
`suppliers`.`bank_account`
`suppliers`.`payment_terms`
`system_settings`.*
`system_settings`.`setting_key`
`system_settings`.`setting_value`
`system_settings`.`setting_type`
`system_settings`.`label_ar`
`system_settings`.`group_name`
`system_settings`.`updated_at`
`tax_brackets`.*
`tax_brackets`.`id`
`tax_brackets`.`min_amount`
`tax_brackets`.`max_amount`
`tax_brackets`.`rate`
`tax_brackets`.`description`
`teaching_assignments`.*
`teaching_assignments`.`id`
`teaching_assignments`.`staff_id`
`teaching_assignments`.`course_id`
`teaching_assignments`.`semester_id`
`teaching_assignments`.`section_name`
`teaching_assignments`.`student_count`
`teaching_assignments`.`teaching_type`
`teaching_assignments`.`weekly_theory_hours`
`teaching_assignments`.`weekly_practical_hours`
`teaching_assignments`.`is_extra`
`teaching_assignments`.`notes`
`teaching_assignments`.`created_by`
`teaching_assignments`.`created_at`
`teaching_attendance`.*
`teaching_attendance`.`id`
`teaching_attendance`.`assignment_id`
`teaching_attendance`.`session_date`
`teaching_attendance`.`status`
`teaching_attendance`.`actual_hours`
`teaching_attendance`.`notes`
`teaching_attendance`.`recorded_by`
`teaching_attendance`.`created_at`
`tender_items`.*
`tender_items`.`id`
`tender_items`.`tender_id`
`tender_items`.`item_name`
`tender_items`.`quantity`
`tender_items`.`unit`
`tender_items`.`specifications`
`tender_offer_items`.*
`tender_offer_items`.`id`
`tender_offer_items`.`offer_id`
`tender_offer_items`.`tender_item_id`
`tender_offer_items`.`unit_price`
`tender_offer_items`.`total_price`
`tender_offer_items`.`notes`
`tender_offers`.*
`tender_offers`.`id`
`tender_offers`.`tender_id`
`tender_offers`.`supplier_id`
`tender_offers`.`submission_date`
`tender_offers`.`total_amount`
`tender_offers`.`delivery_days`
`tender_offers`.`warranty_months`
`tender_offers`.`technical_score`
`tender_offers`.`financial_score`
`tender_offers`.`final_score`
`tender_offers`.`status`
`tender_offers`.`notes`
`tender_offers`.`created_at`
`tenders`.*
`tenders`.`id`
`tenders`.`tender_number`
`tenders`.`title`
`tenders`.`description`
`tenders`.`tender_type`
`tenders`.`department_id`
`tenders`.`estimated_value`
`tenders`.`publish_date`
`tenders`.`submission_deadline`
`tenders`.`opening_date`
`tenders`.`status`
`tenders`.`winner_supplier_id`
`tenders`.`awarded_amount`
`tenders`.`notes`
`tenders`.`created_by`
`tenders`.`created_at`
`users`.*
`users`.`id`
`users`.`username`
`users`.`password_hash`
`users`.`employee_id`
`users`.`role_id`
`users`.`warehouse_id`
`users`.`is_active`
`users`.`two_factor_enabled`
`users`.`two_factor_secret`
`users`.`last_login`
`users`.`created_at`
`users`.`api_token`
`users`.`fcm_token`
`warehouse_transfers`.*
`warehouse_transfers`.`id`
`warehouse_transfers`.`item_type`
`warehouse_transfers`.`item_id`
`warehouse_transfers`.`from_warehouse_id`
`warehouse_transfers`.`to_warehouse_id`
`warehouse_transfers`.`quantity`
`warehouse_transfers`.`transfer_date`
`warehouse_transfers`.`approved_by`
`warehouse_transfers`.`notes`
`warehouse_transfers`.`created_at`
`warehouses`.*
`warehouses`.`id`
`warehouses`.`name`
`warehouses`.`location`
`warehouses`.`building_id`
`warehouses`.`manager_id`
`warehouses`.`is_active`
`weekly_schedule`.*
`weekly_schedule`.`id`
`weekly_schedule`.`assignment_id`
`weekly_schedule`.`semester_id`
`weekly_schedule`.`day_of_week`
`weekly_schedule`.`start_time`
`weekly_schedule`.`end_time`
`weekly_schedule`.`room`
`weekly_schedule`.`schedule_type`
`weekly_schedule`.`notes`
`work_schedule`.*
`work_schedule`.`id`
`work_schedule`.`name`
`work_schedule`.`work_start`
`work_schedule`.`work_end`
`work_schedule`.`late_tolerance`
`work_schedule`.`work_days`
`work_schedule`.`is_default`
`work_schedule`.`created_at`
`workflow_configs`.*
`workflow_configs`.`id`
`workflow_configs`.`workflow_type`
`workflow_configs`.`step_number`
`workflow_configs`.`step_name`
`workflow_configs`.`approver_role_id`
`workflow_configs`.`approver_user_id`
`workflow_configs`.`condition_field`
`workflow_configs`.`condition_operator`
`workflow_configs`.`condition_value`
`workflow_configs`.`is_active`
`workflow_configs`.`notify_on_reach`
`workflow_configs`.`created_at`
`academic_courses`.*
`academic_courses`.`id`
`academic_courses`.`course_code`
`academic_courses`.`name_ar`
`academic_courses`.`name_en`
`academic_courses`.`department_id`
`academic_courses`.`credit_hours`
`academic_courses`.`theory_hours`
`academic_courses`.`practical_hours`
`academic_courses`.`level`
`academic_courses`.`is_active`
`academic_courses`.`notes`
`academic_courses`.`created_at`
`academic_payroll`.*
`academic_payroll`.`id`
`academic_payroll`.`staff_id`
`academic_payroll`.`semester_id`
`academic_payroll`.`month`
`academic_payroll`.`year`
`academic_payroll`.`theory_hours`
`academic_payroll`.`practical_hours`
`academic_payroll`.`extra_hours`
`academic_payroll`.`theory_amount`
`academic_payroll`.`practical_amount`
`academic_payroll`.`extra_amount`
`academic_payroll`.`gross_salary`
`academic_payroll`.`deductions`
`academic_payroll`.`net_salary`
`academic_payroll`.`status`
`academic_payroll`.`journal_entry_id`
`academic_payroll`.`payment_entry_id`
`academic_payroll`.`notes`
`academic_payroll`.`created_by`
`academic_payroll`.`created_at`
`academic_ranks`.*
`academic_ranks`.`id`
`academic_ranks`.`name_ar`
`academic_ranks`.`name_en`
`academic_ranks`.`code`
`academic_ranks`.`sort_order`
`academic_ranks`.`base_hourly_theory`
`academic_ranks`.`base_hourly_practical`
`academic_ranks`.`base_hourly_extra`
`academic_ranks`.`min_hours_required`
`academic_ranks`.`max_hours_allowed`
`academic_ranks`.`is_active`
`academic_ranks`.`notes`
`academic_ranks`.`created_at`
`academic_semesters`.*
`academic_semesters`.`id`
`academic_semesters`.`name_ar`
`academic_semesters`.`academic_year`
`academic_semesters`.`semester_number`
`academic_semesters`.`start_date`
`academic_semesters`.`end_date`
`academic_semesters`.`status`
`academic_semesters`.`created_at`
`academic_staff`.*
`academic_staff`.`id`
`academic_staff`.`staff_code`
`academic_staff`.`full_name`
`academic_staff`.`full_name_en`
`academic_staff`.`rank_id`
`academic_staff`.`department_id`
`academic_staff`.`national_id`
`academic_staff`.`email`
`academic_staff`.`phone`
`academic_staff`.`hire_date`
`academic_staff`.`photo`
`academic_staff`.`salary_basic`
`academic_staff`.`staff_type`
`academic_staff`.`custom_hourly_theory`
`academic_staff`.`custom_hourly_practical`
`academic_staff`.`custom_hourly_extra`
`academic_staff`.`portal_username`
`academic_staff`.`portal_password`
`academic_staff`.`portal_active`
`academic_staff`.`status`
`academic_staff`.`notes`
`academic_staff`.`created_by`
`academic_staff`.`created_at`
`accounting_periods`.*
`accounting_periods`.`id`
`accounting_periods`.`fiscal_year`
`accounting_periods`.`fiscal_period`
`accounting_periods`.`period_name`
`accounting_periods`.`start_date`
`accounting_periods`.`end_date`
`accounting_periods`.`status`
`accounting_periods`.`closed_by`
`accounting_periods`.`closed_at`
`accounting_periods`.`opening_entry_id`
`accounting_periods`.`closing_notes`
`accounting_periods`.`total_debit`
`accounting_periods`.`total_credit`
`accounting_periods`.`entries_count`
`accounting_periods`.`created_at`
`accounts`.*
`accounts`.`id`
`accounts`.`code`
`accounts`.`name_ar`
`accounts`.`name_en`
`accounts`.`parent_id`
`accounts`.`account_type`
`accounts`.`account_class`
`accounts`.`level`
`accounts`.`is_parent`
`accounts`.`normal_balance`
`accounts`.`opening_balance`
`accounts`.`is_active`
`accounts`.`notes`
`accounts`.`created_by`
`accounts`.`created_at`
`accounts`.`updated_at`
`accounts_receivable`.*
`accounts_receivable`.`id`
`accounts_receivable`.`invoice_number`
`accounts_receivable`.`debtor_type`
`accounts_receivable`.`debtor_name`
`accounts_receivable`.`debtor_code`
`accounts_receivable`.`account_code`
`accounts_receivable`.`description`
`accounts_receivable`.`invoice_date`
`accounts_receivable`.`due_date`
`accounts_receivable`.`amount`
`accounts_receivable`.`paid_amount`
`accounts_receivable`.`status`
`accounts_receivable`.`revenue_account`
`accounts_receivable`.`journal_entry_id`
`accounts_receivable`.`payment_entry_id`
`accounts_receivable`.`notes`
`accounts_receivable`.`created_by`
`accounts_receivable`.`created_at`
`accounts_receivable`.`updated_at`
`api_tokens`.*
`api_tokens`.`id`
`api_tokens`.`token`
`api_tokens`.`name`
`api_tokens`.`user_id`
`api_tokens`.`permissions`
`api_tokens`.`last_used_at`
`api_tokens`.`expires_at`
`api_tokens`.`is_active`
`api_tokens`.`created_at`
`ar_payments`.*
`ar_payments`.`id`
`ar_payments`.`ar_id`
`ar_payments`.`payment_date`
`ar_payments`.`amount`
`ar_payments`.`payment_method`
`ar_payments`.`reference`
`ar_payments`.`journal_entry_id`
`ar_payments`.`notes`
`ar_payments`.`created_by`
`ar_payments`.`created_at`
`asset_attachments`.*
`asset_attachments`.`id`
`asset_attachments`.`asset_id`
`asset_attachments`.`file_path`
`asset_attachments`.`file_type`
`asset_attachments`.`uploaded_at`
`asset_bookings`.*
`asset_bookings`.`id`
`asset_bookings`.`asset_id`
`asset_bookings`.`booking_number`
`asset_bookings`.`employee_id`
`asset_bookings`.`department_id`
`asset_bookings`.`purpose`
`asset_bookings`.`booking_date`
`asset_bookings`.`start_time`
`asset_bookings`.`end_time`
`asset_bookings`.`return_time`
`asset_bookings`.`status`
`asset_bookings`.`approved_by`
`asset_bookings`.`approved_at`
`asset_bookings`.`notes`
`asset_bookings`.`condition_on_return`
`asset_bookings`.`created_at`
`asset_depreciation_log`.*
`asset_depreciation_log`.`id`
`asset_depreciation_log`.`asset_id`
`asset_depreciation_log`.`fiscal_year`
`asset_depreciation_log`.`annual_depreciation`
`asset_depreciation_log`.`accumulated_depreciation`
`asset_depreciation_log`.`book_value`
`asset_depreciation_log`.`calculated_at`
`asset_depreciation_schedule`.*
`asset_depreciation_schedule`.`id`
`asset_depreciation_schedule`.`asset_id`
`asset_depreciation_schedule`.`depreciation_year`
`asset_depreciation_schedule`.`depreciation_month`
`asset_depreciation_schedule`.`depreciation_amount`
`asset_depreciation_schedule`.`book_value_before`
`asset_depreciation_schedule`.`book_value_after`
`asset_depreciation_schedule`.`journal_entry_id`
`asset_depreciation_schedule`.`status`
`asset_depreciation_schedule`.`created_at`
`asset_disposals`.*
`asset_disposals`.`id`
`asset_disposals`.`asset_id`
`asset_disposals`.`disposal_type`
`asset_disposals`.`disposal_date`
`asset_disposals`.`disposal_value`
`asset_disposals`.`reason`
`asset_disposals`.`recipient`
`asset_disposals`.`receipt_number`
`asset_disposals`.`approved_by`
`asset_disposals`.`notes`
`asset_disposals`.`created_by`
`asset_disposals`.`created_at`
`asset_images`.*
`asset_images`.`id`
`asset_images`.`asset_id`
`asset_images`.`image_path`
`asset_images`.`uploaded_at`
`asset_maintenance`.*
`asset_maintenance`.`id`
`asset_maintenance`.`asset_id`
`asset_maintenance`.`maintenance_date`
`asset_maintenance`.`next_due_date`
`asset_maintenance`.`description`
`asset_maintenance`.`cost`
`asset_maintenance`.`performed_by`
`asset_maintenance`.`status`
`assets`.*
`assets`.`id`
`assets`.`asset_code`
`assets`.`serial_number`
`assets`.`category_id`
`assets`.`name`
`assets`.`description`
`assets`.`addition_number`
`assets`.`added_date`
`assets`.`quantity`
`assets`.`unit_price`
`assets`.`total_value`
`assets`.`depreciation_rate`
`assets`.`warehouse_id`
`assets`.`space_id`
`assets`.`current_location`
`assets`.`supplier`
`assets`.`supplier_id`
`assets`.`warranty_expiry`
`assets`.`status`
`assets`.`image`
`assets`.`notes`
`assets`.`created_by`
`assets`.`created_at`
`assets`.`updated_at`
`assets`.`depreciation_method`
`assets`.`useful_life_years`
`assets`.`salvage_value`
`assets`.`accumulated_depreciation`
`assets`.`last_depreciation_date`
`assets`.`journal_entry_id`
`attendance`.*
`attendance`.`id`
`attendance`.`employee_id`
`attendance`.`attend_date`
`attendance`.`check_in`
`attendance`.`check_out`
`attendance`.`status`
`attendance`.`late_minutes`
`attendance`.`early_minutes`
`attendance`.`work_hours`
`attendance`.`notes`
`attendance`.`recorded_by`
`attendance`.`created_at`
`audit_log`.*
`audit_log`.`id`
`audit_log`.`user_id`
`audit_log`.`action`
`audit_log`.`module`
`audit_log`.`record_id`
`audit_log`.`details`
`audit_log`.`ip_address`
`audit_log`.`created_at`
`bank_reconciliation`.*
`bank_reconciliation`.`id`
`bank_reconciliation`.`account_code`
`bank_reconciliation`.`period_month`
`bank_reconciliation`.`period_year`
`bank_reconciliation`.`statement_date`
`bank_reconciliation`.`statement_balance`
`bank_reconciliation`.`book_balance`
`bank_reconciliation`.`difference`
`bank_reconciliation`.`status`
`bank_reconciliation`.`notes`
`bank_reconciliation`.`reconciled_by`
`bank_reconciliation`.`reconciled_at`
`bank_reconciliation`.`journal_entry_id`
`bank_reconciliation`.`created_by`
`bank_reconciliation`.`created_at`
`bank_reconciliation_items`.*
`bank_reconciliation_items`.`id`
`bank_reconciliation_items`.`reconciliation_id`
`bank_reconciliation_items`.`item_type`
`bank_reconciliation_items`.`description`
`bank_reconciliation_items`.`amount`
`bank_reconciliation_items`.`transaction_date`
`bank_reconciliation_items`.`journal_entry_id`
`bank_reconciliation_items`.`is_cleared`
`bank_reconciliation_items`.`cleared_date`
`bank_reconciliation_items`.`created_at`
`budget_transactions`.*
`budget_transactions`.`id`
`budget_transactions`.`budget_id`
`budget_transactions`.`transaction_date`
`budget_transactions`.`amount`
`budget_transactions`.`transaction_type`
`budget_transactions`.`reference_id`
`budget_transactions`.`reference_number`
`budget_transactions`.`description`
`budget_transactions`.`created_by`
`budget_transactions`.`created_at`
`budgets`.*
`budgets`.`id`
`budgets`.`fiscal_year`
`budgets`.`department_id`
`budgets`.`budget_type`
`budgets`.`title`
`budgets`.`planned_amount`
`budgets`.`notes`
`budgets`.`status`
`budgets`.`approved_by`
`budgets`.`approved_at`
`budgets`.`created_by`
`budgets`.`created_at`
`budgets`.`account_code`
`budgets`.`committed_amount`
`budgets`.`actual_amount`
`budgets`.`journal_entry_id`
`building_floors`.*
`building_floors`.`id`
`building_floors`.`building_id`
`building_floors`.`floor_num`
`building_floors`.`name`
`building_floors`.`description`
`building_floors`.`is_active`
`building_floors`.`fp_width`
`building_floors`.`fp_height`
`building_floors`.`fp_bg`
`buildings`.*
`buildings`.`id`
`buildings`.`code`
`buildings`.`name`
`buildings`.`name_en`
`buildings`.`address`
`buildings`.`floors_count`
`buildings`.`year_built`
`buildings`.`area_sqm`
`buildings`.`description`
`buildings`.`is_active`
`buildings`.`created_by`
`buildings`.`created_at`
`categories`.*
`categories`.`id`
`categories`.`code`
`categories`.`name_ar`
`categories`.`parent_id`
`categories`.`book_type`
`categories`.`depreciation_min`
`categories`.`depreciation_max`
`categories`.`level`
`clearance_approvals`.*
`clearance_approvals`.`id`
`clearance_approvals`.`request_id`
`clearance_approvals`.`step_id`
`clearance_approvals`.`status`
`clearance_approvals`.`notes`
`clearance_approvals`.`approved_by`
`clearance_approvals`.`approved_at`
`clearance_approvals`.`created_at`
`clearance_requests`.*
`clearance_requests`.`id`
`clearance_requests`.`request_number`
`clearance_requests`.`person_type`
`clearance_requests`.`person_id`
`clearance_requests`.`reason`
`clearance_requests`.`reason_notes`
`clearance_requests`.`last_working_day`
`clearance_requests`.`status`
`clearance_requests`.`notes`
`clearance_requests`.`created_by`
`clearance_requests`.`completed_at`
`clearance_requests`.`rejected_by`
`clearance_requests`.`rejected_at`
`clearance_requests`.`created_at`
`clearance_requests`.`updated_at`
`clearance_requests`.`journal_entry_id`
`clearance_steps`.*
`clearance_steps`.`id`
`clearance_steps`.`step_name`
`clearance_steps`.`step_name_en`
`clearance_steps`.`responsible_dept`
`clearance_steps`.`step_order`
`clearance_steps`.`applies_to`
`clearance_steps`.`is_required`
`clearance_steps`.`is_active`
`clearance_steps`.`notes`
`consumables`.*
`consumables`.`id`
`consumables`.`item_code`
`consumables`.`category_id`
`consumables`.`name`
`consumables`.`description`
`consumables`.`unit`
`consumables`.`current_stock`
`consumables`.`min_stock_alert`
`consumables`.`warehouse_id`
`consumables`.`supplier_id`
`consumables`.`image`
`consumables`.`is_active`
`consumables`.`created_at`
`consumables`.`account_code`
`contract_payments`.*
`contract_payments`.`id`
`contract_payments`.`contract_id`
`contract_payments`.`payment_number`
`contract_payments`.`title`
`contract_payments`.`due_date`
`contract_payments`.`amount`
`contract_payments`.`paid_date`
`contract_payments`.`paid_amount`
`contract_payments`.`status`
`contract_payments`.`notes`
`contract_payments`.`created_at`
`contract_payments`.`journal_entry_id`
`contract_payments`.`account_code`
`contracts`.*
`contracts`.`id`
`contracts`.`contract_number`
`contracts`.`title`
`contracts`.`supplier_id`
`contracts`.`contract_type`
`contracts`.`start_date`
`contracts`.`end_date`
`contracts`.`total_value`
`contracts`.`paid_value`
`contracts`.`status`
`contracts`.`description`
`contracts`.`attachment`
`contracts`.`created_by`
`contracts`.`created_at`
`contracts`.`journal_entry_id`
`contracts`.`expense_account`
`contracts`.`notes`
`correspondence`.*
`correspondence`.`id`
`correspondence`.`ref_number`
`correspondence`.`type`
`correspondence`.`direction`
`correspondence`.`subject`
`correspondence`.`category_id`
`correspondence`.`priority`
`correspondence`.`status`
`correspondence`.`sender_name`
`correspondence`.`sender_entity`
`correspondence`.`sender_ref`
`correspondence`.`sender_date`
`correspondence`.`receiver_name`
`correspondence`.`receiver_entity`
`correspondence`.`department_id`
`correspondence`.`employee_id`
`correspondence`.`assigned_to`
`correspondence`.`correspondence_date`
`correspondence`.`received_date`
`correspondence`.`due_date`
`correspondence`.`reply_date`
`correspondence`.`summary`
`correspondence`.`notes`
`correspondence`.`tags`
`correspondence`.`replied_by`
`correspondence`.`reply_ref`
`correspondence`.`parent_id`
`correspondence`.`created_by`
`correspondence`.`created_at`
`correspondence`.`updated_at`
`correspondence_attachments`.*
`correspondence_attachments`.`id`
`correspondence_attachments`.`correspondence_id`
`correspondence_attachments`.`file_name`
`correspondence_attachments`.`file_path`
`correspondence_attachments`.`file_type`
`correspondence_attachments`.`file_size`
`correspondence_attachments`.`is_primary`
`correspondence_attachments`.`uploaded_by`
`correspondence_attachments`.`uploaded_at`
`correspondence_categories`.*
`correspondence_categories`.`id`
`correspondence_categories`.`name`
`correspondence_categories`.`color`
`correspondence_categories`.`icon`
`correspondence_categories`.`sort_order`
`correspondence_categories`.`is_active`
`correspondence_log`.*
`correspondence_log`.`id`
`correspondence_log`.`correspondence_id`
`correspondence_log`.`action`
`correspondence_log`.`notes`
`correspondence_log`.`done_by`
`correspondence_log`.`done_at`
`correspondence_recipients`.*
`correspondence_recipients`.`id`
`correspondence_recipients`.`correspondence_id`
`correspondence_recipients`.`employee_id`
`correspondence_recipients`.`department_id`
`correspondence_recipients`.`recipient_name`
`correspondence_recipients`.`read_at`
`correspondence_recipients`.`acknowledged_at`
`correspondence_recipients`.`notes`
`cost_center_allocations`.*
`cost_center_allocations`.`id`
`cost_center_allocations`.`journal_entry_id`
`cost_center_allocations`.`journal_line_id`
`cost_center_allocations`.`department_id`
`cost_center_allocations`.`account_code`
`cost_center_allocations`.`amount`
`cost_center_allocations`.`allocation_pct`
`cost_center_allocations`.`fiscal_year`
`cost_center_allocations`.`fiscal_period`
`cost_center_allocations`.`notes`
`cost_center_allocations`.`created_by`
`cost_center_allocations`.`created_at`
`cost_center_distribution_keys`.*
`cost_center_distribution_keys`.`id`
`cost_center_distribution_keys`.`account_code`
`cost_center_distribution_keys`.`department_id`
`cost_center_distribution_keys`.`percentage`
`cost_center_distribution_keys`.`is_active`
`custody_records`.*
`custody_records`.`id`
`custody_records`.`employee_id`
`custody_records`.`item_type`
`custody_records`.`item_id`
`custody_records`.`voucher_number`
`custody_records`.`custody_date`
`custody_records`.`quantity`
`custody_records`.`item_condition`
`custody_records`.`movement_type`
`custody_records`.`transferred_to_employee_id`
`custody_records`.`signature_path`
`custody_records`.`verification_qr`
`custody_records`.`balance_after`
`custody_records`.`notes`
`custody_records`.`created_by`
`custody_records`.`created_at`
`custody_return_requests`.*
`custody_return_requests`.`id`
`custody_return_requests`.`employee_id`
`custody_return_requests`.`item_type`
`custody_return_requests`.`item_id`
`custody_return_requests`.`quantity`
`custody_return_requests`.`unit_codes`
`custody_return_requests`.`reason`
`custody_return_requests`.`status`
`custody_return_requests`.`reviewed_by`
`custody_return_requests`.`reviewed_at`
`custody_return_requests`.`review_notes`
`custody_return_requests`.`warehouse_id`
`custody_return_requests`.`created_at`
`custody_return_requests`.`journal_entry_id`
`custody_unit_items`.*
`custody_unit_items`.`id`
`custody_unit_items`.`custody_id`
`custody_unit_items`.`unit_id`
`custody_unit_items`.`unit_code`
`custody_unit_items`.`status`
`custody_unit_items`.`returned_at`
`custody_unit_items`.`notes`
`department_asset_entitlements`.*
`department_asset_entitlements`.`id`
`department_asset_entitlements`.`department_id`
`department_asset_entitlements`.`category_id`
`department_asset_entitlements`.`quantity_entitled`
`department_asset_entitlements`.`quantity_actual`
`department_asset_entitlements`.`notes`
`department_asset_entitlements`.`created_by`
`department_asset_entitlements`.`created_at`
`department_asset_entitlements`.`updated_at`
`departments`.*
`departments`.`id`
`departments`.`name`
`departments`.`cost_center_code`
`departments`.`budget_amount`
`departments`.`parent_id`
`disposal_reasons`.*
`disposal_reasons`.`id`
`disposal_reasons`.`name_ar`
`disposal_reasons`.`is_active`
`documents`.*
`documents`.`id`
`documents`.`title`
`documents`.`description`
`documents`.`file_path`
`documents`.`file_name`
`documents`.`file_size`
`documents`.`file_type`
`documents`.`doc_type`
`documents`.`entity_type`
`documents`.`entity_id`
`documents`.`tags`
`documents`.`is_confidential`
`documents`.`uploaded_by`
`documents`.`created_at`
`employee_entitlements`.*
`employee_entitlements`.`id`
`employee_entitlements`.`employee_id`
`employee_entitlements`.`entitlement_type`
`employee_entitlements`.`title`
`employee_entitlements`.`amount`
`employee_entitlements`.`is_recurring`
`employee_entitlements`.`period_month`
`employee_entitlements`.`period_year`
`employee_entitlements`.`status`
`employee_entitlements`.`payment_date`
`employee_entitlements`.`notes`
`employee_entitlements`.`created_by`
`employee_entitlements`.`created_at`
`employee_entitlements`.`journal_entry_id`
`employee_entitlements`.`account_code`
`employee_leave_balance`.*
`employee_leave_balance`.`id`
`employee_leave_balance`.`employee_id`
`employee_leave_balance`.`leave_type_id`
`employee_leave_balance`.`year`
`employee_leave_balance`.`total_days`
`employee_leave_balance`.`used_days`
`employee_leave_balance`.`pending_days`
`employee_payroll`.*
`employee_payroll`.`id`
`employee_payroll`.`employee_id`
`employee_payroll`.`month`
`employee_payroll`.`year`
`employee_payroll`.`basic_salary`
`employee_payroll`.`allowances`
`employee_payroll`.`bonuses`
`employee_payroll`.`deductions`
`employee_payroll`.`penalties`
`employee_payroll`.`social_insurance`
`employee_payroll`.`medical_insurance`
`employee_payroll`.`income_tax`
`employee_payroll`.`employer_social`
`employee_payroll`.`net_salary`
`employee_payroll`.`notes`
`employee_payroll`.`status`
`employee_payroll`.`paid_at`
`employee_payroll`.`created_by`
`employee_payroll`.`created_at`
`employee_payroll`.`journal_entry_id`
`employee_payroll`.`payment_entry_id`
`employee_payroll`.`gross_salary`
`employee_penalties`.*
`employee_penalties`.`id`
`employee_penalties`.`employee_id`
`employee_penalties`.`penalty_type`
`employee_penalties`.`reason`
`employee_penalties`.`amount`
`employee_penalties`.`penalty_date`
`employee_penalties`.`notes`
`employee_penalties`.`issued_by`
`employee_penalties`.`created_at`
`employee_penalties`.`journal_entry_id`
`employees`.*
`employees`.`id`
`employees`.`employee_code`
`employees`.`national_id`
`employees`.`full_name`
`employees`.`job_title`
`employees`.`department_id`
`employees`.`hire_date`
`employees`.`email`
`employees`.`phone`
`employees`.`gender`
`employees`.`birth_date`
`employees`.`basic_salary`
`employees`.`bank_account`
`employees`.`address`
`employees`.`emergency_contact`
`employees`.`emergency_phone`
`employees`.`notes`
`employees`.`status`
`employees`.`photo`
`employees`.`created_at`
`entitlement_rules`.*
`entitlement_rules`.`id`
`entitlement_rules`.`rule_name`
`entitlement_rules`.`applies_to`
`entitlement_rules`.`rank_id`
`entitlement_rules`.`staff_id`
`entitlement_rules`.`rate_theory`
`entitlement_rules`.`rate_practical`
`entitlement_rules`.`rate_extra`
`entitlement_rules`.`min_hours_extra`
`entitlement_rules`.`effective_from`
`entitlement_rules`.`effective_to`
`entitlement_rules`.`is_active`
`entitlement_rules`.`notes`
`entitlement_rules`.`created_by`
`entitlement_rules`.`created_at`
`fiscal_year_closing`.*
`fiscal_year_closing`.`id`
`fiscal_year_closing`.`fiscal_year`
`fiscal_year_closing`.`status`
`fiscal_year_closing`.`total_revenue`
`fiscal_year_closing`.`total_expense`
`fiscal_year_closing`.`net_profit_loss`
`fiscal_year_closing`.`closing_entry_id`
`fiscal_year_closing`.`transfer_entry_id`
`fiscal_year_closing`.`closed_by`
`fiscal_year_closing`.`closed_at`
`fiscal_year_closing`.`notes`
`fiscal_year_closing`.`created_at`
`goods_receipt_items`.*
`goods_receipt_items`.`id`
`goods_receipt_items`.`gr_id`
`goods_receipt_items`.`poi_id`
`goods_receipt_items`.`received_qty`
`goods_receipt_items`.`unit_price`
`goods_receipt_items`.`total_price`
`goods_receipts`.*
`goods_receipts`.`id`
`goods_receipts`.`gr_number`
`goods_receipts`.`po_id`
`goods_receipts`.`receipt_date`
`goods_receipts`.`warehouse_id`
`goods_receipts`.`total_received`
`goods_receipts`.`journal_entry_id`
`goods_receipts`.`notes`
`goods_receipts`.`created_by`
`goods_receipts`.`created_at`
`id_card_settings`.*
`id_card_settings`.`id`
`id_card_settings`.`name`
`id_card_settings`.`card_type`
`id_card_settings`.`width_mm`
`id_card_settings`.`height_mm`
`id_card_settings`.`orientation`
`id_card_settings`.`cards_per_row`
`id_card_settings`.`cards_per_page`
`id_card_settings`.`margin_mm`
`id_card_settings`.`gap_mm`
`id_card_settings`.`show_photo`
`id_card_settings`.`show_barcode`
`id_card_settings`.`show_qr`
`id_card_settings`.`show_back`
`id_card_settings`.`show_natid`
`id_card_settings`.`color_primary`
`id_card_settings`.`color_secondary`
`id_card_settings`.`printer_name`
`id_card_settings`.`paper_size`
`id_card_settings`.`is_default`
`id_card_settings`.`created_by`
`id_card_settings`.`created_at`
`invoice_payments`.*
`invoice_payments`.`id`
`invoice_payments`.`invoice_id`
`invoice_payments`.`payment_date`
`invoice_payments`.`amount`
`invoice_payments`.`payment_method`
`invoice_payments`.`reference_number`
`invoice_payments`.`notes`
`invoice_payments`.`created_by`
`invoice_payments`.`created_at`
`invoice_payments`.`journal_entry_id`
`invoice_payments`.`revenue_account`
`item_units`.*
`item_units`.`id`
`item_units`.`item_type`
`item_units`.`item_id`
`item_units`.`unit_code`
`item_units`.`warehouse_id`
`item_units`.`status`
`item_units`.`assigned_to_employee_id`
`item_units`.`last_scanned_at`
`item_units`.`notes`
`item_units`.`created_at`
`journal_approval_log`.*
`journal_approval_log`.`id`
`journal_approval_log`.`entry_id`
`journal_approval_log`.`action`
`journal_approval_log`.`user_id`
`journal_approval_log`.`notes`
`journal_approval_log`.`created_at`
`journal_entries`.*
`journal_entries`.`id`
`journal_entries`.`entry_number`
`journal_entries`.`entry_date`
`journal_entries`.`description`
`journal_entries`.`reference_type`
`journal_entries`.`reference_id`
`journal_entries`.`reference_number`
`journal_entries`.`fiscal_year`
`journal_entries`.`fiscal_period`
`journal_entries`.`total_debit`
`journal_entries`.`total_credit`
`journal_entries`.`status`
`journal_entries`.`approval_status`
`journal_entries`.`approval_required`
`journal_entries`.`reviewed_by`
`journal_entries`.`reviewed_at`
`journal_entries`.`review_notes`
`journal_entries`.`posted_by`
`journal_entries`.`posted_at`
`journal_entries`.`reversed_entry`
`journal_entries`.`notes`
`journal_entries`.`created_by`
`journal_entries`.`created_at`
`journal_entries`.`updated_at`
`journal_entry_lines`.*
`journal_entry_lines`.`id`
`journal_entry_lines`.`entry_id`
`journal_entry_lines`.`line_number`
`journal_entry_lines`.`account_id`
`journal_entry_lines`.`description`
`journal_entry_lines`.`debit_amount`
`journal_entry_lines`.`credit_amount`
`journal_entry_lines`.`cost_center`
`leave_requests`.*
`leave_requests`.`id`
`leave_requests`.`request_number`
`leave_requests`.`employee_id`
`leave_requests`.`leave_type_id`
`leave_requests`.`start_date`
`leave_requests`.`end_date`
`leave_requests`.`days_count`
`leave_requests`.`reason`
`leave_requests`.`status`
`leave_requests`.`manager_id`
`leave_requests`.`manager_notes`
`leave_requests`.`manager_decided_at`
`leave_requests`.`hr_id`
`leave_requests`.`hr_notes`
`leave_requests`.`hr_decided_at`
`leave_requests`.`created_by`
`leave_requests`.`created_at`
`leave_requests`.`updated_at`
`leave_types`.*
`leave_types`.`id`
`leave_types`.`name_ar`
`leave_types`.`name_en`
`leave_types`.`days_per_year`
`leave_types`.`is_paid`
`leave_types`.`color`
`leave_types`.`is_active`
`leave_types`.`created_at`
`notifications`.*
`notifications`.`id`
`notifications`.`user_id`
`notifications`.`title`
`notifications`.`message`
`notifications`.`is_read`
`notifications`.`link`
`notifications`.`created_at`
`notifications`.`type`
`official_holidays`.*
`official_holidays`.`id`
`official_holidays`.`name`
`official_holidays`.`holiday_date`
`official_holidays`.`year`
`official_holidays`.`is_recurring`
`payroll_settings`.*
`payroll_settings`.`id`
`payroll_settings`.`setting_key`
`payroll_settings`.`value`
`payroll_settings`.`description`
`payroll_settings`.`updated_at`
`performance_criteria`.*
`performance_criteria`.`id`
`performance_criteria`.`template_id`
`performance_criteria`.`name`
`performance_criteria`.`description`
`performance_criteria`.`max_score`
`performance_criteria`.`weight`
`performance_criteria`.`category`
`performance_criteria`.`sort_order`
`performance_evaluations`.*
`performance_evaluations`.`id`
`performance_evaluations`.`employee_id`
`performance_evaluations`.`template_id`
`performance_evaluations`.`evaluator_id`
`performance_evaluations`.`period_year`
`performance_evaluations`.`period_quarter`
`performance_evaluations`.`period_month`
`performance_evaluations`.`eval_date`
`performance_evaluations`.`total_score`
`performance_evaluations`.`max_score`
`performance_evaluations`.`percentage`
`performance_evaluations`.`grade`
`performance_evaluations`.`notes`
`performance_evaluations`.`strengths`
`performance_evaluations`.`improvements`
`performance_evaluations`.`status`
`performance_evaluations`.`approved_by`
`performance_evaluations`.`approved_at`
`performance_evaluations`.`created_at`
`performance_scores`.*
`performance_scores`.`id`
`performance_scores`.`evaluation_id`
`performance_scores`.`criteria_id`
`performance_scores`.`score`
`performance_scores`.`notes`
`performance_templates`.*
`performance_templates`.`id`
`performance_templates`.`name`
`performance_templates`.`description`
`performance_templates`.`period`
`performance_templates`.`is_active`
`performance_templates`.`created_by`
`performance_templates`.`created_at`
`permissions`.*
`permissions`.`id`
`permissions`.`module`
`permissions`.`action`
`po_receipt_items`.*
`po_receipt_items`.`id`
`po_receipt_items`.`receipt_id`
`po_receipt_items`.`po_item_id`
`po_receipt_items`.`quantity_received`
`po_receipt_items`.`condition_notes`
`po_receipts`.*
`po_receipts`.`id`
`po_receipts`.`po_id`
`po_receipts`.`receipt_date`
`po_receipts`.`received_by`
`po_receipts`.`notes`
`po_receipts`.`created_at`
`prepaid_amortization`.*
`prepaid_amortization`.`id`
`prepaid_amortization`.`prepaid_id`
`prepaid_amortization`.`period_year`
`prepaid_amortization`.`period_month`
`prepaid_amortization`.`amount`
`prepaid_amortization`.`journal_entry_id`
`prepaid_amortization`.`status`
`prepaid_amortization`.`posted_at`
`prepaid_expenses`.*
`prepaid_expenses`.`id`
`prepaid_expenses`.`entry_number`
`prepaid_expenses`.`description`
`prepaid_expenses`.`vendor_name`
`prepaid_expenses`.`expense_account`
`prepaid_expenses`.`total_amount`
`prepaid_expenses`.`start_date`
`prepaid_expenses`.`end_date`
`prepaid_expenses`.`months_total`
`prepaid_expenses`.`monthly_amount`
`prepaid_expenses`.`amortized_amount`
`prepaid_expenses`.`remaining_amount`
`prepaid_expenses`.`status`
`prepaid_expenses`.`initial_entry_id`
`prepaid_expenses`.`notes`
`prepaid_expenses`.`created_by`
`prepaid_expenses`.`created_at`
`project_assets`.*
`project_assets`.`id`
`project_assets`.`project_id`
`project_assets`.`asset_id`
`project_assets`.`consumable_id`
`project_assets`.`quantity`
`project_assets`.`assigned_date`
`project_assets`.`return_date`
`project_assets`.`notes`
`project_expenses`.*
`project_expenses`.`id`
`project_expenses`.`project_id`
`project_expenses`.`expense_date`
`project_expenses`.`category`
`project_expenses`.`description`
`project_expenses`.`amount`
`project_expenses`.`reference_id`
`project_expenses`.`reference_type`
`project_expenses`.`created_by`
`project_expenses`.`created_at`
`project_expenses`.`journal_entry_id`
`project_expenses`.`account_code`
`project_team`.*
`project_team`.`id`
`project_team`.`project_id`
`project_team`.`staff_id`
`project_team`.`role_in_project`
`project_team`.`join_date`
`purchase_order_items`.*
`purchase_order_items`.`id`
`purchase_order_items`.`po_id`
`purchase_order_items`.`item_type`
`purchase_order_items`.`item_id`
`purchase_order_items`.`item_name`
`purchase_order_items`.`item_code`
`purchase_order_items`.`quantity_ordered`
`purchase_order_items`.`quantity_received`
`purchase_order_items`.`unit_price`
`purchase_order_items`.`total_price`
`purchase_order_items`.`notes`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`po_number`
`purchase_orders`.`supplier_id`
`purchase_orders`.`warehouse_id`
`purchase_orders`.`department_id`
`purchase_orders`.`order_date`
`purchase_orders`.`expected_delivery`
`purchase_orders`.`actual_delivery`
`purchase_orders`.`total_amount`
`purchase_orders`.`status`
`purchase_orders`.`notes`
`purchase_orders`.`tender_id`
`purchase_orders`.`invoice_id`
`purchase_orders`.`created_by`
`purchase_orders`.`approved_by`
`purchase_orders`.`approved_at`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_orders`.`budget_id`
`purchase_orders`.`journal_entry_id`
`purchase_orders`.`payment_entry_id`
`purchase_orders`.`item_type`
`purchase_orders`.`received_amount`
`purchase_orders`.`paid_amount`
`regulation_acknowledgments`.*
`regulation_acknowledgments`.`id`
`regulation_acknowledgments`.`regulation_id`
`regulation_acknowledgments`.`user_id`
`regulation_acknowledgments`.`employee_id`
`regulation_acknowledgments`.`acknowledged_at`
`regulation_acknowledgments`.`notes`
`regulation_categories`.*
`regulation_categories`.`id`
`regulation_categories`.`name_ar`
`regulation_categories`.`name_en`
`regulation_categories`.`icon`
`regulation_categories`.`color`
`regulation_categories`.`sort_order`
`regulation_categories`.`is_active`
`regulation_categories`.`created_at`
`regulation_reads`.*
`regulation_reads`.`id`
`regulation_reads`.`regulation_id`
`regulation_reads`.`user_id`
`regulation_reads`.`employee_id`
`regulation_reads`.`read_at`
`regulations`.*
`regulations`.`id`
`regulations`.`reg_number`
`regulations`.`title`
`regulations`.`category_id`
`regulations`.`description`
`regulations`.`content`
`regulations`.`file_path`
`regulations`.`file_name`
`regulations`.`version`
`regulations`.`status`
`regulations`.`effective_date`
`regulations`.`expiry_date`
`regulations`.`related_module`
`regulations`.`requires_ack`
`regulations`.`tags`
`regulations`.`views_count`
`regulations`.`created_by`
`regulations`.`updated_by`
`regulations`.`created_at`
`regulations`.`updated_at`
`requisition_approvals`.*
`requisition_approvals`.`id`
`requisition_approvals`.`requisition_id`
`requisition_approvals`.`approver_id`
`requisition_approvals`.`approval_level`
`requisition_approvals`.`decision`
`requisition_approvals`.`comments`
`requisition_approvals`.`decided_at`
`requisition_items`.*
`requisition_items`.`id`
`requisition_items`.`requisition_id`
`requisition_items`.`item_type`
`requisition_items`.`item_id`
`requisition_items`.`quantity_requested`
`requisition_items`.`quantity_approved`
`requisition_items`.`space_id`
`requisition_items`.`quantity_delivered`
`requisition_unit_items`.*
`requisition_unit_items`.`id`
`requisition_unit_items`.`requisition_id`
`requisition_unit_items`.`item_id`
`requisition_unit_items`.`unit_id`
`requisition_unit_items`.`unit_code`
`requisition_unit_items`.`created_at`
`requisitions`.*
`requisitions`.`id`
`requisitions`.`request_number`
`requisitions`.`employee_id`
`requisitions`.`warehouse_id`
`requisitions`.`reason`
`requisitions`.`priority`
`requisitions`.`status`
`requisitions`.`created_at`
`requisitions`.`updated_at`
`research_projects`.*
`research_projects`.`id`
`research_projects`.`project_code`
`research_projects`.`title_ar`
`research_projects`.`title_en`
`research_projects`.`project_type`
`research_projects`.`department_id`
`research_projects`.`principal_investigator_id`
`research_projects`.`start_date`
`research_projects`.`end_date`
`research_projects`.`budget`
`research_projects`.`funding_source`
`research_projects`.`status`
`research_projects`.`description`
`research_projects`.`created_by`
`research_projects`.`created_at`
`research_projects`.`journal_entry_id`
`research_projects`.`expense_account`
`research_projects`.`actual_spent`
`revenue_entries`.*
`revenue_entries`.`id`
`revenue_entries`.`entry_number`
`revenue_entries`.`revenue_date`
`revenue_entries`.`revenue_type`
`revenue_entries`.`account_code`
`revenue_entries`.`payer_name`
`revenue_entries`.`payer_type`
`revenue_entries`.`description`
`revenue_entries`.`amount`
`revenue_entries`.`vat_amount`
`revenue_entries`.`total_amount`
`revenue_entries`.`payment_method`
`revenue_entries`.`reference_number`
`revenue_entries`.`bank_account`
`revenue_entries`.`journal_entry_id`
`revenue_entries`.`fiscal_year`
`revenue_entries`.`fiscal_period`
`revenue_entries`.`status`
`revenue_entries`.`notes`
`revenue_entries`.`created_by`
`revenue_entries`.`created_at`
`role_permissions`.*
`role_permissions`.`role_id`
`role_permissions`.`permission_id`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`description`
`roles`.`created_at`
`room_allocations`.*
`room_allocations`.`id`
`room_allocations`.`space_id`
`room_allocations`.`academic_course_id`
`room_allocations`.`assignment_id`
`room_allocations`.`semester_id`
`room_allocations`.`allocated_to`
`room_allocations`.`purpose`
`room_allocations`.`day_of_week`
`room_allocations`.`start_time`
`room_allocations`.`end_time`
`room_allocations`.`start_date`
`room_allocations`.`end_date`
`room_allocations`.`recurrence`
`room_allocations`.`capacity`
`room_allocations`.`notes`
`room_allocations`.`status`
`room_allocations`.`created_by`
`room_allocations`.`created_at`
`scheduled_reports`.*
`scheduled_reports`.`id`
`scheduled_reports`.`name`
`scheduled_reports`.`report_type`
`scheduled_reports`.`frequency`
`scheduled_reports`.`send_day`
`scheduled_reports`.`send_time`
`scheduled_reports`.`recipients`
`scheduled_reports`.`last_sent`
`scheduled_reports`.`next_send`
`scheduled_reports`.`is_active`
`scheduled_reports`.`parameters`
`scheduled_reports`.`created_by`
`scheduled_reports`.`created_at`
`space_assignment_log`.*
`space_assignment_log`.`id`
`space_assignment_log`.`asset_id`
`space_assignment_log`.`space_id`
`space_assignment_log`.`assigned_date`
`space_assignment_log`.`moved_out_date`
`space_assignment_log`.`assigned_by`
`space_assignment_log`.`notes`
`space_assignment_log`.`created_at`
`space_types`.*
`space_types`.`id`
`space_types`.`name_ar`
`space_types`.`is_active`
`spaces`.*
`spaces`.`id`
`spaces`.`code`
`spaces`.`name`
`spaces`.`space_type_id`
`spaces`.`building`
`spaces`.`building_id`
`spaces`.`floor`
`spaces`.`floor_id`
`spaces`.`capacity`
`spaces`.`notes`
`spaces`.`is_active`
`spaces`.`created_at`
`spaces`.`fp_x`
`spaces`.`fp_y`
`spaces`.`fp_w`
`spaces`.`fp_h`
`spaces`.`fp_color`
`spaces`.`fp_floor_id`
`staff_monthly_entitlements`.*
`staff_monthly_entitlements`.`id`
`staff_monthly_entitlements`.`staff_id`
`staff_monthly_entitlements`.`semester_id`
`staff_monthly_entitlements`.`month`
`staff_monthly_entitlements`.`year`
`staff_monthly_entitlements`.`total_theory_hours`
`staff_monthly_entitlements`.`total_practical_hours`
`staff_monthly_entitlements`.`total_extra_hours`
`staff_monthly_entitlements`.`rate_theory`
`staff_monthly_entitlements`.`rate_practical`
`staff_monthly_entitlements`.`rate_extra`
`staff_monthly_entitlements`.`amount_theory`
`staff_monthly_entitlements`.`amount_practical`
`staff_monthly_entitlements`.`amount_extra`
`staff_monthly_entitlements`.`deductions`
`staff_monthly_entitlements`.`net_amount`
`staff_monthly_entitlements`.`status`
`staff_monthly_entitlements`.`notes`
`staff_monthly_entitlements`.`approved_by`
`staff_monthly_entitlements`.`approved_at`
`staff_monthly_entitlements`.`paid_at`
`staff_monthly_entitlements`.`created_at`
`stock_count_items`.*
`stock_count_items`.`id`
`stock_count_items`.`stock_count_id`
`stock_count_items`.`item_type`
`stock_count_items`.`item_id`
`stock_count_items`.`expected_quantity`
`stock_count_items`.`actual_quantity`
`stock_count_items`.`difference`
`stock_count_items`.`notes`
`stock_counts`.*
`stock_counts`.`id`
`stock_counts`.`warehouse_id`
`stock_counts`.`count_date`
`stock_counts`.`performed_by`
`stock_counts`.`status`
`stock_counts`.`count_type`
`stock_movements`.*
`stock_movements`.`id`
`stock_movements`.`item_type`
`stock_movements`.`item_id`
`stock_movements`.`warehouse_id`
`stock_movements`.`movement_date`
`stock_movements`.`voucher_number`
`stock_movements`.`source_destination`
`stock_movements`.`quantity_in`
`stock_movements`.`quantity_out_actual`
`stock_movements`.`quantity_out_other`
`stock_movements`.`disposal_reason_id`
`stock_movements`.`item_condition`
`stock_movements`.`balance_after`
`stock_movements`.`notes`
`stock_movements`.`created_by`
`stock_movements`.`created_at`
`supplier_evaluations`.*
`supplier_evaluations`.`id`
`supplier_evaluations`.`supplier_id`
`supplier_evaluations`.`po_id`
`supplier_evaluations`.`eval_date`
`supplier_evaluations`.`evaluator_id`
`supplier_evaluations`.`quality_score`
`supplier_evaluations`.`delivery_score`
`supplier_evaluations`.`price_score`
`supplier_evaluations`.`service_score`
`supplier_evaluations`.`docs_score`
`supplier_evaluations`.`total_score`
`supplier_evaluations`.`percentage`
`supplier_evaluations`.`grade`
`supplier_evaluations`.`notes`
`supplier_evaluations`.`created_at`
`supplier_invoices`.*
`supplier_invoices`.`id`
`supplier_invoices`.`supplier_id`
`supplier_invoices`.`invoice_number`
`supplier_invoices`.`invoice_date`
`supplier_invoices`.`due_date`
`supplier_invoices`.`amount`
`supplier_invoices`.`paid_amount`
`supplier_invoices`.`currency`
`supplier_invoices`.`status`
`supplier_invoices`.`related_asset_id`
`supplier_invoices`.`related_po`
`supplier_invoices`.`notes`
`supplier_invoices`.`attachment`
`supplier_invoices`.`created_by`
`supplier_invoices`.`created_at`
`supplier_invoices`.`updated_at`
`supplier_invoices_acc`.*
`supplier_invoices_acc`.`id`
`supplier_invoices_acc`.`invoice_number`
`supplier_invoices_acc`.`supplier_id`
`supplier_invoices_acc`.`po_id`
`supplier_invoices_acc`.`gr_id`
`supplier_invoices_acc`.`invoice_date`
`supplier_invoices_acc`.`due_date`
`supplier_invoices_acc`.`amount`
`supplier_invoices_acc`.`vat_amount`
`supplier_invoices_acc`.`total_amount`
`supplier_invoices_acc`.`paid_amount`
`supplier_invoices_acc`.`status`
`supplier_invoices_acc`.`journal_entry_id`
`supplier_invoices_acc`.`payment_entry_id`
`supplier_invoices_acc`.`notes`
`supplier_invoices_acc`.`created_by`
`supplier_invoices_acc`.`created_at`
`supplier_payments`.*
`supplier_payments`.`id`
`supplier_payments`.`payment_number`
`supplier_payments`.`supplier_id`
`supplier_payments`.`invoice_id`
`supplier_payments`.`payment_date`
`supplier_payments`.`amount`
`supplier_payments`.`payment_method`
`supplier_payments`.`bank_account`
`supplier_payments`.`reference_number`
`supplier_payments`.`journal_entry_id`
`supplier_payments`.`notes`
`supplier_payments`.`created_by`
`supplier_payments`.`created_at`
`supplier_price_history`.*
`supplier_price_history`.`id`
`supplier_price_history`.`supplier_id`
`supplier_price_history`.`item_name`
`supplier_price_history`.`item_code`
`supplier_price_history`.`unit_price`
`supplier_price_history`.`currency`
`supplier_price_history`.`price_date`
`supplier_price_history`.`source`
`supplier_price_history`.`source_id`
`supplier_price_history`.`notes`
`supplier_price_history`.`created_by`
`supplier_price_history`.`created_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`contact_person`
`suppliers`.`phone`
`suppliers`.`email`
`suppliers`.`address`
`suppliers`.`tax_number`
`suppliers`.`notes`
`suppliers`.`is_active`
`suppliers`.`created_at`
`suppliers`.`rating`
`suppliers`.`eval_count`
`suppliers`.`category`
`suppliers`.`bank_name`
`suppliers`.`bank_account`
`suppliers`.`payment_terms`
`system_settings`.*
`system_settings`.`setting_key`
`system_settings`.`setting_value`
`system_settings`.`setting_type`
`system_settings`.`label_ar`
`system_settings`.`group_name`
`system_settings`.`updated_at`
`tax_brackets`.*
`tax_brackets`.`id`
`tax_brackets`.`min_amount`
`tax_brackets`.`max_amount`
`tax_brackets`.`rate`
`tax_brackets`.`description`
`teaching_assignments`.*
`teaching_assignments`.`id`
`teaching_assignments`.`staff_id`
`teaching_assignments`.`course_id`
`teaching_assignments`.`semester_id`
`teaching_assignments`.`section_name`
`teaching_assignments`.`student_count`
`teaching_assignments`.`teaching_type`
`teaching_assignments`.`weekly_theory_hours`
`teaching_assignments`.`weekly_practical_hours`
`teaching_assignments`.`is_extra`
`teaching_assignments`.`notes`
`teaching_assignments`.`created_by`
`teaching_assignments`.`created_at`
`teaching_attendance`.*
`teaching_attendance`.`id`
`teaching_attendance`.`assignment_id`
`teaching_attendance`.`session_date`
`teaching_attendance`.`status`
`teaching_attendance`.`actual_hours`
`teaching_attendance`.`notes`
`teaching_attendance`.`recorded_by`
`teaching_attendance`.`created_at`
`tender_items`.*
`tender_items`.`id`
`tender_items`.`tender_id`
`tender_items`.`item_name`
`tender_items`.`quantity`
`tender_items`.`unit`
`tender_items`.`specifications`
`tender_offer_items`.*
`tender_offer_items`.`id`
`tender_offer_items`.`offer_id`
`tender_offer_items`.`tender_item_id`
`tender_offer_items`.`unit_price`
`tender_offer_items`.`total_price`
`tender_offer_items`.`notes`
`tender_offers`.*
`tender_offers`.`id`
`tender_offers`.`tender_id`
`tender_offers`.`supplier_id`
`tender_offers`.`submission_date`
`tender_offers`.`total_amount`
`tender_offers`.`delivery_days`
`tender_offers`.`warranty_months`
`tender_offers`.`technical_score`
`tender_offers`.`financial_score`
`tender_offers`.`final_score`
`tender_offers`.`status`
`tender_offers`.`notes`
`tender_offers`.`created_at`
`tenders`.*
`tenders`.`id`
`tenders`.`tender_number`
`tenders`.`title`
`tenders`.`description`
`tenders`.`tender_type`
`tenders`.`department_id`
`tenders`.`estimated_value`
`tenders`.`publish_date`
`tenders`.`submission_deadline`
`tenders`.`opening_date`
`tenders`.`status`
`tenders`.`winner_supplier_id`
`tenders`.`awarded_amount`
`tenders`.`notes`
`tenders`.`created_by`
`tenders`.`created_at`
`users`.*
`users`.`id`
`users`.`username`
`users`.`password_hash`
`users`.`employee_id`
`users`.`role_id`
`users`.`warehouse_id`
`users`.`is_active`
`users`.`two_factor_enabled`
`users`.`two_factor_secret`
`users`.`last_login`
`users`.`created_at`
`users`.`api_token`
`users`.`fcm_token`
`warehouse_transfers`.*
`warehouse_transfers`.`id`
`warehouse_transfers`.`item_type`
`warehouse_transfers`.`item_id`
`warehouse_transfers`.`from_warehouse_id`
`warehouse_transfers`.`to_warehouse_id`
`warehouse_transfers`.`quantity`
`warehouse_transfers`.`transfer_date`
`warehouse_transfers`.`approved_by`
`warehouse_transfers`.`notes`
`warehouse_transfers`.`created_at`
`warehouses`.*
`warehouses`.`id`
`warehouses`.`name`
`warehouses`.`location`
`warehouses`.`building_id`
`warehouses`.`manager_id`
`warehouses`.`is_active`
`weekly_schedule`.*
`weekly_schedule`.`id`
`weekly_schedule`.`assignment_id`
`weekly_schedule`.`semester_id`
`weekly_schedule`.`day_of_week`
`weekly_schedule`.`start_time`
`weekly_schedule`.`end_time`
`weekly_schedule`.`room`
`weekly_schedule`.`schedule_type`
`weekly_schedule`.`notes`
`work_schedule`.*
`work_schedule`.`id`
`work_schedule`.`name`
`work_schedule`.`work_start`
`work_schedule`.`work_end`
`work_schedule`.`late_tolerance`
`work_schedule`.`work_days`
`work_schedule`.`is_default`
`work_schedule`.`created_at`
`workflow_configs`.*
`workflow_configs`.`id`
`workflow_configs`.`workflow_type`
`workflow_configs`.`step_number`
`workflow_configs`.`step_name`
`workflow_configs`.`approver_role_id`
`workflow_configs`.`approver_user_id`
`workflow_configs`.`condition_field`
`workflow_configs`.`condition_operator`
`workflow_configs`.`condition_value`
`workflow_configs`.`is_active`
`workflow_configs`.`notify_on_reach`
`workflow_configs`.`created_at`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
academic_courses
academic_payroll
academic_ranks
academic_semesters
academic_staff
accounting_periods
accounts
accounts_receivable
api_tokens
ar_payments
asset_attachments
asset_bookings
asset_depreciation_log
asset_depreciation_schedule
asset_disposals
asset_images
asset_maintenance
assets
attendance
audit_log
bank_reconciliation
bank_reconciliation_items
budget_transactions
budgets
building_floors
buildings
categories
clearance_approvals
clearance_requests
clearance_steps
consumables
contract_payments
contracts
correspondence
correspondence_attachments
correspondence_categories
correspondence_log
correspondence_recipients
cost_center_allocations
cost_center_distribution_keys
custody_records
custody_return_requests
custody_unit_items
department_asset_entitlements
departments
disposal_reasons
documents
employee_entitlements
employee_leave_balance
employee_payroll
employee_penalties
employees
entitlement_rules
fiscal_year_closing
goods_receipt_items
goods_receipts
id_card_settings
invoice_payments
item_units
journal_approval_log
journal_entries
journal_entry_lines
leave_requests
leave_types
notifications
official_holidays
payroll_settings
performance_criteria
performance_evaluations
performance_scores
performance_templates
permissions
po_receipt_items
po_receipts
prepaid_amortization
prepaid_expenses
project_assets
project_expenses
project_team
purchase_order_items
purchase_orders
regulation_acknowledgments
regulation_categories
regulation_reads
regulations
requisition_approvals
requisition_items
requisition_unit_items
requisitions
research_projects
revenue_entries
role_permissions
roles
room_allocations
scheduled_reports
space_assignment_log
space_types
spaces
staff_monthly_entitlements
stock_count_items
stock_counts
stock_movements
supplier_evaluations
supplier_invoices
supplier_invoices_acc
supplier_payments
supplier_price_history
suppliers
system_settings
tax_brackets
teaching_assignments
teaching_attendance
tender_items
tender_offer_items
tender_offers
tenders
users
warehouse_transfers
warehouses
weekly_schedule
work_schedule
workflow_configs
SQL query on database
warehouse_assets_system
: