Recent
`information_schema`.`TABLE_CONSTRAINTS`
`top1movers`.`recruitment_applicants`
`information_schema`.`KEYWORDS`
`performance_schema`.`setup_consumers`
`information_schema`.`INNODB_CMP`
`top1movers`.`recruitment_positions`
`performance_schema`.`threads`
`top1movers`.`stores`
`information_schema`.`CHECK_CONSTRAINTS`
`top1movers`.`schedule_change_logs`
Favorites
There are no favorite tables.
New
information_schema
mysql
performance_schema
phpmyadmin
test
top1movers
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: 127.0.0.1
Database: top1movers
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:
`accounting_transactions`.*
`accounting_transactions`.`id`
`accounting_transactions`.`transaction_no`
`accounting_transactions`.`transaction_date`
`accounting_transactions`.`reference_no`
`accounting_transactions`.`transaction_type`
`accounting_transactions`.`party_type`
`accounting_transactions`.`party_name`
`accounting_transactions`.`description`
`accounting_transactions`.`status`
`accounting_transactions`.`source_module`
`accounting_transactions`.`source_record_id`
`accounting_transactions`.`total_debit`
`accounting_transactions`.`total_credit`
`accounting_transactions`.`created_by`
`accounting_transactions`.`updated_by`
`accounting_transactions`.`created_at`
`accounting_transactions`.`updated_at`
`accounts`.*
`accounts`.`id`
`accounts`.`account_code`
`accounts`.`account_name`
`accounts`.`account_type`
`accounts`.`parent_account_id`
`accounts`.`normal_balance`
`accounts`.`is_cash_account`
`accounts`.`is_active`
`accounts`.`notes`
`accounts`.`created_by`
`accounts`.`updated_by`
`accounts`.`created_at`
`accounts`.`updated_at`
`api_mobile_tokens`.*
`api_mobile_tokens`.`id`
`api_mobile_tokens`.`user_id`
`api_mobile_tokens`.`employee_id`
`api_mobile_tokens`.`token_hash`
`api_mobile_tokens`.`device_name`
`api_mobile_tokens`.`ip_address`
`api_mobile_tokens`.`user_agent`
`api_mobile_tokens`.`created_at`
`api_mobile_tokens`.`last_used_at`
`api_mobile_tokens`.`expires_at`
`api_mobile_tokens`.`revoked_at`
`app_rate_limits`.*
`app_rate_limits`.`id`
`app_rate_limits`.`scope`
`app_rate_limits`.`identifier_hash`
`app_rate_limits`.`identifier_label`
`app_rate_limits`.`window_started_at`
`app_rate_limits`.`attempts`
`app_rate_limits`.`blocked_until`
`app_rate_limits`.`last_attempt_at`
`app_rate_limits`.`created_at`
`app_rate_limits`.`updated_at`
`asset_accountability_form_items`.*
`asset_accountability_form_items`.`id`
`asset_accountability_form_items`.`form_id`
`asset_accountability_form_items`.`asset_id`
`asset_accountability_form_items`.`assignment_id`
`asset_accountability_form_items`.`asset_tag`
`asset_accountability_form_items`.`asset_snapshot`
`asset_accountability_form_items`.`created_at`
`asset_accountability_forms`.*
`asset_accountability_forms`.`id`
`asset_accountability_forms`.`form_control_no`
`asset_accountability_forms`.`employee_id`
`asset_accountability_forms`.`revision_no`
`asset_accountability_forms`.`status`
`asset_accountability_forms`.`generated_by`
`asset_accountability_forms`.`printed_by`
`asset_accountability_forms`.`printed_at`
`asset_accountability_forms`.`remarks`
`asset_accountability_forms`.`created_at`
`asset_accountability_forms`.`updated_at`
`asset_assignments`.*
`asset_assignments`.`id`
`asset_assignments`.`asset_id`
`asset_assignments`.`employee_id`
`asset_assignments`.`assigned_at`
`asset_assignments`.`expected_return_at`
`asset_assignments`.`condition_upon_issue`
`asset_assignments`.`accessories_included`
`asset_assignments`.`issued_by_user_id`
`asset_assignments`.`acknowledged_by`
`asset_assignments`.`returned_at`
`asset_assignments`.`return_condition`
`asset_assignments`.`assignment_notes`
`asset_assignments`.`received_by_user_id`
`asset_assignments`.`returned_to_user_id`
`asset_assignments`.`status`
`asset_assignments`.`clearance_status`
`asset_assignments`.`created_at`
`asset_audit_logs`.*
`asset_audit_logs`.`id`
`asset_audit_logs`.`asset_id`
`asset_audit_logs`.`action_type`
`asset_audit_logs`.`employee_id`
`asset_audit_logs`.`reference_table`
`asset_audit_logs`.`reference_id`
`asset_audit_logs`.`remarks`
`asset_audit_logs`.`performed_by`
`asset_audit_logs`.`created_at`
`asset_categories`.*
`asset_categories`.`id`
`asset_categories`.`category_name`
`asset_categories`.`description`
`asset_categories`.`asset_tag_prefix`
`asset_categories`.`is_active`
`asset_categories`.`created_at`
`asset_categories`.`updated_at`
`asset_label_print_logs`.*
`asset_label_print_logs`.`id`
`asset_label_print_logs`.`asset_id`
`asset_label_print_logs`.`template_id`
`asset_label_print_logs`.`label_type`
`asset_label_print_logs`.`reprint_reason`
`asset_label_print_logs`.`printer_used`
`asset_label_print_logs`.`printed_by`
`asset_label_print_logs`.`printed_at`
`asset_label_print_logs`.`ip_address`
`asset_label_print_logs`.`user_agent`
`asset_label_templates`.*
`asset_label_templates`.`id`
`asset_label_templates`.`template_name`
`asset_label_templates`.`label_size`
`asset_label_templates`.`width_mm`
`asset_label_templates`.`height_mm`
`asset_label_templates`.`include_brand_model`
`asset_label_templates`.`include_serial`
`asset_label_templates`.`include_qr`
`asset_label_templates`.`status`
`asset_label_templates`.`created_at`
`asset_label_templates`.`updated_at`
`asset_maintenance_logs`.*
`asset_maintenance_logs`.`id`
`asset_maintenance_logs`.`asset_id`
`asset_maintenance_logs`.`maintenance_date`
`asset_maintenance_logs`.`maintenance_type`
`asset_maintenance_logs`.`vendor_name`
`asset_maintenance_logs`.`cost`
`asset_maintenance_logs`.`details`
`asset_maintenance_logs`.`status`
`asset_maintenance_logs`.`performed_by_user_id`
`asset_maintenance_logs`.`resolved_at`
`asset_maintenance_logs`.`created_at`
`asset_print_logs`.*
`asset_print_logs`.`id`
`asset_print_logs`.`employee_id`
`asset_print_logs`.`asset_id`
`asset_print_logs`.`print_type`
`asset_print_logs`.`reference_id`
`asset_print_logs`.`label_type`
`asset_print_logs`.`assets_included`
`asset_print_logs`.`reprint_reason`
`asset_print_logs`.`printer_used`
`asset_print_logs`.`printed_by`
`asset_print_logs`.`printed_at`
`asset_print_logs`.`ip_address`
`asset_print_logs`.`user_agent`
`asset_transfers`.*
`asset_transfers`.`id`
`asset_transfers`.`asset_id`
`asset_transfers`.`from_employee_id`
`asset_transfers`.`to_employee_id`
`asset_transfers`.`from_location`
`asset_transfers`.`to_location`
`asset_transfers`.`transfer_date`
`asset_transfers`.`reason`
`asset_transfers`.`processed_by`
`asset_transfers`.`related_assignment_id`
`asset_transfers`.`created_at`
`assets`.*
`assets`.`id`
`assets`.`asset_tag`
`assets`.`asset_code`
`assets`.`asset_category_id`
`assets`.`item_name`
`assets`.`brand`
`assets`.`model`
`assets`.`serial_number`
`assets`.`imei_1`
`assets`.`imei_2`
`assets`.`sim_number`
`assets`.`mobile_number`
`assets`.`plan_type`
`assets`.`processor`
`assets`.`ram`
`assets`.`storage`
`assets`.`operating_system`
`assets`.`charger_serial_number`
`assets`.`accessories_included`
`assets`.`purchase_date`
`assets`.`supplier`
`assets`.`warranty_date`
`assets`.`asset_condition`
`assets`.`status`
`assets`.`assigned_employee_id`
`assets`.`location`
`assets`.`purchase_cost`
`assets`.`accountability_form_no`
`assets`.`notes`
`assets`.`asset_photo`
`assets`.`public_view_token`
`assets`.`created_by`
`assets`.`updated_by`
`assets`.`created_at`
`assets`.`updated_at`
`attendance_corrections`.*
`attendance_corrections`.`id`
`attendance_corrections`.`employee_id`
`attendance_corrections`.`attendance_id`
`attendance_corrections`.`attendance_date`
`attendance_corrections`.`requested_time_in`
`attendance_corrections`.`requested_time_out`
`attendance_corrections`.`reason`
`attendance_corrections`.`attachment`
`attendance_corrections`.`status`
`attendance_corrections`.`created_by`
`attendance_corrections`.`approved_by`
`attendance_corrections`.`approved_at`
`attendance_corrections`.`remarks`
`attendance_corrections`.`created_at`
`attendance_corrections`.`updated_at`
`attribute_value`.*
`attribute_value`.`id`
`attribute_value`.`value`
`attribute_value`.`attribute_parent_id`
`attributes`.*
`attributes`.`id`
`attributes`.`name`
`attributes`.`active`
`audit_logs`.*
`audit_logs`.`id`
`audit_logs`.`user_id`
`audit_logs`.`user_name`
`audit_logs`.`module`
`audit_logs`.`record_type`
`audit_logs`.`record_id`
`audit_logs`.`action`
`audit_logs`.`old_value`
`audit_logs`.`new_value`
`audit_logs`.`remarks`
`audit_logs`.`ip_address`
`audit_logs`.`user_agent`
`audit_logs`.`created_at`
`auth_access_logs`.*
`auth_access_logs`.`id`
`auth_access_logs`.`user_id`
`auth_access_logs`.`username`
`auth_access_logs`.`event_type`
`auth_access_logs`.`status`
`auth_access_logs`.`ip_address`
`auth_access_logs`.`ip_source`
`auth_access_logs`.`is_internal_ip`
`auth_access_logs`.`is_whitelisted_ip`
`auth_access_logs`.`network_label`
`auth_access_logs`.`user_agent`
`auth_access_logs`.`browser_name`
`auth_access_logs`.`platform`
`auth_access_logs`.`device_hash`
`auth_access_logs`.`session_id`
`auth_access_logs`.`request_uri`
`auth_access_logs`.`notes`
`auth_access_logs`.`metadata_text`
`auth_access_logs`.`created_at`
`brands`.*
`brands`.`id`
`brands`.`name`
`brands`.`active`
`categories`.*
`categories`.`id`
`categories`.`name`
`categories`.`active`
`clearance_items`.*
`clearance_items`.`id`
`clearance_items`.`offboarding_id`
`clearance_items`.`clearance_area`
`clearance_items`.`item_label`
`clearance_items`.`assigned_to`
`clearance_items`.`status`
`clearance_items`.`remarks`
`clearance_items`.`cleared_by`
`clearance_items`.`cleared_at`
`clearance_items`.`created_at`
`clearance_items`.`updated_at`
`company`.*
`company`.`id`
`company`.`company_name`
`company`.`service_charge_value`
`company`.`vat_charge_value`
`company`.`address`
`company`.`phone`
`company`.`payroll_funding_account`
`company`.`country`
`company`.`message`
`company`.`currency`
`deliveries`.*
`deliveries`.`id`
`deliveries`.`delivery_no`
`deliveries`.`supplier_name`
`deliveries`.`remarks`
`deliveries`.`created_at`
`deliveries`.`user_id`
`deliveries`.`status`
`deliveries`.`cancel_reason`
`deliveries`.`cancelled_at`
`deliveries`.`cancelled_by`
`deliveries`.`attachment_path`
`delivery_items`.*
`delivery_items`.`id`
`delivery_items`.`delivery_id`
`delivery_items`.`product_id`
`delivery_items`.`qty`
`departments`.*
`departments`.`id`
`departments`.`department_name`
`departments`.`department_code`
`departments`.`department_head_id`
`departments`.`status`
`departments`.`created_at`
`departments`.`updated_at`
`disciplinary_cases`.*
`disciplinary_cases`.`id`
`disciplinary_cases`.`employee_id`
`disciplinary_cases`.`case_type`
`disciplinary_cases`.`incident_date`
`disciplinary_cases`.`description`
`disciplinary_cases`.`attachment`
`disciplinary_cases`.`issued_by`
`disciplinary_cases`.`employee_response`
`disciplinary_cases`.`hr_remarks`
`disciplinary_cases`.`final_action`
`disciplinary_cases`.`acknowledgment_date`
`disciplinary_cases`.`status`
`disciplinary_cases`.`created_at`
`disciplinary_cases`.`updated_at`
`document_approval_logs`.*
`document_approval_logs`.`id`
`document_approval_logs`.`document_id`
`document_approval_logs`.`action`
`document_approval_logs`.`user_id`
`document_approval_logs`.`old_status`
`document_approval_logs`.`new_status`
`document_approval_logs`.`remarks`
`document_approval_logs`.`ip_address`
`document_approval_logs`.`user_agent`
`document_approval_logs`.`created_at`
`document_approval_remarks`.*
`document_approval_remarks`.`id`
`document_approval_remarks`.`document_id`
`document_approval_remarks`.`step_id`
`document_approval_remarks`.`user_id`
`document_approval_remarks`.`remarks_type`
`document_approval_remarks`.`remarks`
`document_approval_remarks`.`is_private`
`document_approval_remarks`.`page_number`
`document_approval_remarks`.`created_at`
`document_approval_signatures`.*
`document_approval_signatures`.`id`
`document_approval_signatures`.`document_id`
`document_approval_signatures`.`step_id`
`document_approval_signatures`.`approver_id`
`document_approval_signatures`.`signature_file_path`
`document_approval_signatures`.`page_number`
`document_approval_signatures`.`x_position`
`document_approval_signatures`.`y_position`
`document_approval_signatures`.`width`
`document_approval_signatures`.`height`
`document_approval_signatures`.`signed_at`
`document_approval_signatures`.`created_at`
`document_approval_steps`.*
`document_approval_steps`.`id`
`document_approval_steps`.`document_id`
`document_approval_steps`.`step_order`
`document_approval_steps`.`approver_id`
`document_approval_steps`.`approver_role`
`document_approval_steps`.`status`
`document_approval_steps`.`remarks`
`document_approval_steps`.`signature_required`
`document_approval_steps`.`signed_at`
`document_approval_steps`.`approved_at`
`document_approval_steps`.`returned_at`
`document_approval_steps`.`rejected_at`
`document_approval_steps`.`created_at`
`document_approval_steps`.`updated_at`
`document_approval_versions`.*
`document_approval_versions`.`id`
`document_approval_versions`.`document_id`
`document_approval_versions`.`version_number`
`document_approval_versions`.`version_type`
`document_approval_versions`.`filename`
`document_approval_versions`.`file_path`
`document_approval_versions`.`file_size`
`document_approval_versions`.`mime_type`
`document_approval_versions`.`uploaded_by`
`document_approval_versions`.`created_at`
`document_approvals`.*
`document_approvals`.`id`
`document_approvals`.`document_code`
`document_approvals`.`title`
`document_approvals`.`company`
`document_approvals`.`department_id`
`document_approvals`.`document_type_id`
`document_approvals`.`other_document_type`
`document_approvals`.`category`
`document_approvals`.`uploaded_by`
`document_approvals`.`current_approver_id`
`document_approvals`.`additional_reviewer_id`
`document_approvals`.`priority`
`document_approvals`.`due_date`
`document_approvals`.`original_filename`
`document_approvals`.`stored_filename`
`document_approvals`.`file_path`
`document_approvals`.`file_size`
`document_approvals`.`mime_type`
`document_approvals`.`is_confidential`
`document_approvals`.`status`
`document_approvals`.`remarks`
`document_approvals`.`submitted_at`
`document_approvals`.`approved_at`
`document_approvals`.`returned_at`
`document_approvals`.`rejected_at`
`document_approvals`.`archived_at`
`document_approvals`.`created_at`
`document_approvals`.`updated_at`
`document_department_users`.*
`document_department_users`.`id`
`document_department_users`.`department_id`
`document_department_users`.`user_id`
`document_department_users`.`can_upload`
`document_department_users`.`can_view_department`
`document_department_users`.`can_approve`
`document_department_users`.`can_view_confidential`
`document_department_users`.`can_view_private_remarks`
`document_department_users`.`status`
`document_department_users`.`created_at`
`document_department_users`.`updated_at`
`document_types`.*
`document_types`.`id`
`document_types`.`department_id`
`document_types`.`type_name`
`document_types`.`type_code`
`document_types`.`category`
`document_types`.`requires_signature`
`document_types`.`requires_approval`
`document_types`.`default_workflow_id`
`document_types`.`default_approver_id`
`document_types`.`allowed_file_types`
`document_types`.`max_file_size`
`document_types`.`status`
`document_types`.`created_at`
`document_types`.`updated_at`
`document_workflow_steps`.*
`document_workflow_steps`.`id`
`document_workflow_steps`.`workflow_id`
`document_workflow_steps`.`step_order`
`document_workflow_steps`.`approver_role`
`document_workflow_steps`.`approver_user_id`
`document_workflow_steps`.`require_signature`
`document_workflow_steps`.`require_remarks`
`document_workflow_steps`.`created_at`
`document_workflow_steps`.`updated_at`
`document_workflows`.*
`document_workflows`.`id`
`document_workflows`.`workflow_name`
`document_workflows`.`department_id`
`document_workflows`.`document_type_id`
`document_workflows`.`status`
`document_workflows`.`created_at`
`document_workflows`.`updated_at`
`employee_201_files`.*
`employee_201_files`.`id`
`employee_201_files`.`employee_id`
`employee_201_files`.`completion_percent`
`employee_201_files`.`status`
`employee_201_files`.`last_reviewed_by`
`employee_201_files`.`last_reviewed_at`
`employee_201_files`.`remarks`
`employee_201_files`.`created_at`
`employee_201_files`.`updated_at`
`employee_aliases`.*
`employee_aliases`.`id`
`employee_aliases`.`raw_name`
`employee_aliases`.`employee_id`
`employee_aliases`.`corrected_name`
`employee_aliases`.`created_at`
`employee_aliases`.`updated_at`
`employee_certifications`.*
`employee_certifications`.`id`
`employee_certifications`.`employee_id`
`employee_certifications`.`skill_name`
`employee_certifications`.`certification_name`
`employee_certifications`.`issuing_organization`
`employee_certifications`.`issue_date`
`employee_certifications`.`expiry_date`
`employee_certifications`.`attachment`
`employee_certifications`.`status`
`employee_certifications`.`created_at`
`employee_certifications`.`updated_at`
`employee_document_access_logs`.*
`employee_document_access_logs`.`id`
`employee_document_access_logs`.`document_id`
`employee_document_access_logs`.`employee_id`
`employee_document_access_logs`.`action_type`
`employee_document_access_logs`.`user_id`
`employee_document_access_logs`.`user_name`
`employee_document_access_logs`.`ip_address`
`employee_document_access_logs`.`user_agent`
`employee_document_access_logs`.`remarks`
`employee_document_access_logs`.`created_at`
`employee_document_types`.*
`employee_document_types`.`id`
`employee_document_types`.`section`
`employee_document_types`.`category`
`employee_document_types`.`document_name`
`employee_document_types`.`is_required`
`employee_document_types`.`requires_expiry`
`employee_document_types`.`sort_order`
`employee_document_types`.`status`
`employee_document_types`.`created_at`
`employee_document_types`.`updated_at`
`employee_document_versions`.*
`employee_document_versions`.`id`
`employee_document_versions`.`document_id`
`employee_document_versions`.`employee_id`
`employee_document_versions`.`version_no`
`employee_document_versions`.`document_type_id`
`employee_document_versions`.`category`
`employee_document_versions`.`section`
`employee_document_versions`.`document_title`
`employee_document_versions`.`original_filename`
`employee_document_versions`.`stored_filename`
`employee_document_versions`.`file_path`
`employee_document_versions`.`file_extension`
`employee_document_versions`.`mime_type`
`employee_document_versions`.`file_size`
`employee_document_versions`.`issue_date`
`employee_document_versions`.`expiry_date`
`employee_document_versions`.`is_required`
`employee_document_versions`.`is_confidential`
`employee_document_versions`.`remarks`
`employee_document_versions`.`replaced_by`
`employee_document_versions`.`replaced_at`
`employee_document_versions`.`created_at`
`employee_documents`.*
`employee_documents`.`id`
`employee_documents`.`employee_id`
`employee_documents`.`document_type_id`
`employee_documents`.`category`
`employee_documents`.`section`
`employee_documents`.`is_required`
`employee_documents`.`is_confidential`
`employee_documents`.`document_title`
`employee_documents`.`file_path`
`employee_documents`.`original_filename`
`employee_documents`.`stored_filename`
`employee_documents`.`file_extension`
`employee_documents`.`mime_type`
`employee_documents`.`file_size`
`employee_documents`.`issue_date`
`employee_documents`.`version_no`
`employee_documents`.`expiry_date`
`employee_documents`.`remarks`
`employee_documents`.`status`
`employee_documents`.`uploaded_by`
`employee_documents`.`last_updated_by`
`employee_documents`.`updated_by`
`employee_documents`.`replaced_document_id`
`employee_documents`.`archived_by`
`employee_documents`.`archived_at`
`employee_documents`.`created_at`
`employee_documents`.`updated_at`
`employee_education`.*
`employee_education`.`id`
`employee_education`.`employee_id`
`employee_education`.`school`
`employee_education`.`course`
`employee_education`.`year_graduated`
`employee_education`.`awards`
`employee_education`.`document_path`
`employee_education`.`status`
`employee_education`.`created_at`
`employee_education`.`updated_at`
`employee_employment_history`.*
`employee_employment_history`.`id`
`employee_employment_history`.`employee_id`
`employee_employment_history`.`previous_employer`
`employee_employment_history`.`position`
`employee_employment_history`.`start_date`
`employee_employment_history`.`end_date`
`employee_employment_history`.`reason_for_leaving`
`employee_employment_history`.`status`
`employee_employment_history`.`created_at`
`employee_employment_history`.`updated_at`
`employee_family_dependents`.*
`employee_family_dependents`.`id`
`employee_family_dependents`.`employee_id`
`employee_family_dependents`.`full_name`
`employee_family_dependents`.`relationship`
`employee_family_dependents`.`birthdate`
`employee_family_dependents`.`contact_no`
`employee_family_dependents`.`is_dependent`
`employee_family_dependents`.`status`
`employee_family_dependents`.`created_at`
`employee_family_dependents`.`updated_at`
`employee_medical_records`.*
`employee_medical_records`.`id`
`employee_medical_records`.`employee_id`
`employee_medical_records`.`medical_exam_date`
`employee_medical_records`.`fit_to_work_status`
`employee_medical_records`.`medical_expiry_date`
`employee_medical_records`.`certificate_path`
`employee_medical_records`.`remarks`
`employee_medical_records`.`status`
`employee_medical_records`.`created_at`
`employee_medical_records`.`updated_at`
`employee_movements`.*
`employee_movements`.`id`
`employee_movements`.`employee_id`
`employee_movements`.`movement_type`
`employee_movements`.`field_name`
`employee_movements`.`old_value`
`employee_movements`.`new_value`
`employee_movements`.`effective_date`
`employee_movements`.`reason`
`employee_movements`.`attachment`
`employee_movements`.`status`
`employee_movements`.`created_by`
`employee_movements`.`approved_by`
`employee_movements`.`approved_at`
`employee_movements`.`created_at`
`employee_movements`.`updated_at`
`employee_onboarding_items`.*
`employee_onboarding_items`.`id`
`employee_onboarding_items`.`employee_id`
`employee_onboarding_items`.`item_key`
`employee_onboarding_items`.`item_label`
`employee_onboarding_items`.`status`
`employee_onboarding_items`.`completed_by`
`employee_onboarding_items`.`completed_at`
`employee_onboarding_items`.`remarks`
`employee_onboarding_items`.`created_at`
`employee_onboarding_items`.`updated_at`
`employee_schedule_assignments`.*
`employee_schedule_assignments`.`id`
`employee_schedule_assignments`.`employee_id`
`employee_schedule_assignments`.`schedule_id`
`employee_schedule_assignments`.`effective_date`
`employee_schedule_assignments`.`end_date`
`employee_schedule_assignments`.`assigned_by`
`employee_schedule_assignments`.`remarks`
`employee_schedule_assignments`.`status`
`employee_schedule_assignments`.`created_at`
`employee_schedule_assignments`.`updated_at`
`expenses`.*
`expenses`.`id`
`expenses`.`transaction_id`
`expenses`.`expense_date`
`expenses`.`expense_type`
`expenses`.`vendor_name`
`expenses`.`amount`
`expenses`.`payment_status`
`expenses`.`related_inventory_reference`
`expenses`.`notes`
`expenses`.`created_by`
`expenses`.`updated_by`
`expenses`.`created_at`
`expenses`.`updated_at`
`groups`.*
`groups`.`id`
`groups`.`group_name`
`groups`.`permission`
`holidays`.*
`holidays`.`id`
`holidays`.`holiday_name`
`holidays`.`holiday_date`
`holidays`.`holiday_type`
`holidays`.`created_at`
`hr_attendance`.*
`hr_attendance`.`id`
`hr_attendance`.`employee_id`
`hr_attendance`.`cutoff_id`
`hr_attendance`.`schedule_id`
`hr_attendance`.`scheduled_start_at`
`hr_attendance`.`scheduled_end_at`
`hr_attendance`.`required_work_minutes`
`hr_attendance`.`break_minutes`
`hr_attendance`.`grace_period_minutes`
`hr_attendance`.`attendance_date`
`hr_attendance`.`time_in`
`hr_attendance`.`time_in_device_time`
`hr_attendance`.`time_in_server_time`
`hr_attendance`.`time_in_time_difference_seconds`
`hr_attendance`.`time_in_flagged_time_mismatch`
`hr_attendance`.`time_in_face_distance`
`hr_attendance`.`time_in_face_confidence`
`hr_attendance`.`time_in_face_source`
`hr_attendance`.`time_out`
`hr_attendance`.`time_out_device_time`
`hr_attendance`.`time_out_server_time`
`hr_attendance`.`time_out_time_difference_seconds`
`hr_attendance`.`time_out_flagged_time_mismatch`
`hr_attendance`.`time_out_face_distance`
`hr_attendance`.`time_out_face_confidence`
`hr_attendance`.`time_out_face_source`
`hr_attendance`.`latitude`
`hr_attendance`.`longitude`
`hr_attendance`.`photo`
`hr_attendance`.`time_in_latitude`
`hr_attendance`.`time_in_longitude`
`hr_attendance`.`time_in_photo`
`hr_attendance`.`time_out_latitude`
`hr_attendance`.`time_out_longitude`
`hr_attendance`.`time_out_photo`
`hr_attendance`.`hours_worked`
`hr_attendance`.`late_minutes`
`hr_attendance`.`undertime_minutes`
`hr_attendance`.`regular_work_minutes`
`hr_attendance`.`auto_overtime_hours`
`hr_attendance`.`rest_day_work`
`hr_attendance`.`rest_day_validated`
`hr_attendance`.`schedule_snapshot_json`
`hr_attendance`.`manual_overtime_hours`
`hr_attendance`.`manual_overtime_override`
`hr_attendance`.`status`
`hr_attendance`.`created_at`
`hr_attendance`.`updated_at`
`hr_attendance_edit_logs`.*
`hr_attendance_edit_logs`.`id`
`hr_attendance_edit_logs`.`attendance_id`
`hr_attendance_edit_logs`.`employee_id`
`hr_attendance_edit_logs`.`attendance_date`
`hr_attendance_edit_logs`.`old_time_in`
`hr_attendance_edit_logs`.`old_time_out`
`hr_attendance_edit_logs`.`new_time_in`
`hr_attendance_edit_logs`.`new_time_out`
`hr_attendance_edit_logs`.`old_hours_worked`
`hr_attendance_edit_logs`.`new_hours_worked`
`hr_attendance_edit_logs`.`edited_by`
`hr_attendance_edit_logs`.`ip_address`
`hr_attendance_edit_logs`.`user_agent`
`hr_attendance_edit_logs`.`edit_reason`
`hr_attendance_edit_logs`.`created_at`
`hr_attendance_time_security_logs`.*
`hr_attendance_time_security_logs`.`id`
`hr_attendance_time_security_logs`.`employee_id`
`hr_attendance_time_security_logs`.`action_key`
`hr_attendance_time_security_logs`.`source`
`hr_attendance_time_security_logs`.`device_time_raw`
`hr_attendance_time_security_logs`.`device_time`
`hr_attendance_time_security_logs`.`server_time`
`hr_attendance_time_security_logs`.`time_difference_seconds`
`hr_attendance_time_security_logs`.`threshold_seconds`
`hr_attendance_time_security_logs`.`flagged_time_mismatch`
`hr_attendance_time_security_logs`.`blocked`
`hr_attendance_time_security_logs`.`warning_message`
`hr_attendance_time_security_logs`.`ip_address`
`hr_attendance_time_security_logs`.`user_agent`
`hr_attendance_time_security_logs`.`extra_json`
`hr_attendance_time_security_logs`.`created_at`
`hr_checklist_items`.*
`hr_checklist_items`.`id`
`hr_checklist_items`.`checklist_id`
`hr_checklist_items`.`item_label`
`hr_checklist_items`.`assigned_to`
`hr_checklist_items`.`due_date`
`hr_checklist_items`.`status`
`hr_checklist_items`.`remarks`
`hr_checklist_items`.`attachment`
`hr_checklist_items`.`completed_by`
`hr_checklist_items`.`completed_at`
`hr_checklist_items`.`created_at`
`hr_checklist_items`.`updated_at`
`hr_checklists`.*
`hr_checklists`.`id`
`hr_checklists`.`employee_id`
`hr_checklists`.`checklist_type`
`hr_checklists`.`title`
`hr_checklists`.`status`
`hr_checklists`.`completion_percent`
`hr_checklists`.`created_by`
`hr_checklists`.`created_at`
`hr_checklists`.`updated_at`
`hr_employees`.*
`hr_employees`.`id`
`hr_employees`.`employee_code`
`hr_employees`.`bank_account_no`
`hr_employees`.`bank_account_name`
`hr_employees`.`payroll_account_status`
`hr_employees`.`bank_name`
`hr_employees`.`first_name`
`hr_employees`.`middle_name`
`hr_employees`.`last_name`
`hr_employees`.`suffix`
`hr_employees`.`nickname`
`hr_employees`.`position`
`hr_employees`.`job_title`
`hr_employees`.`branch_location`
`hr_employees`.`department`
`hr_employees`.`payroll_type`
`hr_employees`.`shift_id`
`hr_employees`.`rest_day`
`hr_employees`.`daily_rate`
`hr_employees`.`salary_type`
`hr_employees`.`monthly_salary`
`hr_employees`.`hourly_rate`
`hr_employees`.`date_hired`
`hr_employees`.`date_regularized`
`hr_employees`.`contract_start_date`
`hr_employees`.`contract_end_date`
`hr_employees`.`probationary_end_date`
`hr_employees`.`supervisor_id`
`hr_employees`.`birthdate`
`hr_employees`.`gender`
`hr_employees`.`civil_status`
`hr_employees`.`nationality`
`hr_employees`.`religion`
`hr_employees`.`contact_no`
`hr_employees`.`personal_email`
`hr_employees`.`emergency_contact_name`
`hr_employees`.`emergency_contact_no`
`hr_employees`.`emergency_relationship`
`hr_employees`.`emergency_contact_address`
`hr_employees`.`address`
`hr_employees`.`sss_no`
`hr_employees`.`philhealth_no`
`hr_employees`.`pagibig_no`
`hr_employees`.`tin_no`
`hr_employees`.`bir_tax_status`
`hr_employees`.`rdo_code`
`hr_employees`.`status`
`hr_employees`.`employment_status`
`hr_employees`.`active_flag`
`hr_employees`.`face_image`
`hr_employees`.`employee_photo`
`hr_employees`.`face_descriptor`
`hr_employees`.`created_at`
`hr_employees`.`updated_at`
`hr_payroll_batch_logs`.*
`hr_payroll_batch_logs`.`id`
`hr_payroll_batch_logs`.`batch_id`
`hr_payroll_batch_logs`.`week_start`
`hr_payroll_batch_logs`.`week_end`
`hr_payroll_batch_logs`.`from_status`
`hr_payroll_batch_logs`.`to_status`
`hr_payroll_batch_logs`.`action_by`
`hr_payroll_batch_logs`.`note`
`hr_payroll_batch_logs`.`created_at`
`hr_payroll_batches`.*
`hr_payroll_batches`.`id`
`hr_payroll_batches`.`week_start`
`hr_payroll_batches`.`week_end`
`hr_payroll_batches`.`payroll_type`
`hr_payroll_batches`.`status`
`hr_payroll_batches`.`reviewed_by`
`hr_payroll_batches`.`reviewed_at`
`hr_payroll_batches`.`approved_by`
`hr_payroll_batches`.`approved_at`
`hr_payroll_batches`.`released_by`
`hr_payroll_batches`.`released_at`
`hr_payroll_batches`.`locked_by`
`hr_payroll_batches`.`locked_at`
`hr_payroll_batches`.`is_finalized`
`hr_payroll_batches`.`is_locked`
`hr_payroll_batches`.`finalized_by`
`hr_payroll_batches`.`finalized_at`
`hr_payroll_batches`.`note`
`hr_payroll_batches`.`created_by`
`hr_payroll_batches`.`created_at`
`hr_payroll_batches`.`updated_at`
`hr_payrolls`.*
`hr_payrolls`.`id`
`hr_payrolls`.`employee_id`
`hr_payrolls`.`cutoff_id`
`hr_payrolls`.`week_start`
`hr_payrolls`.`week_end`
`hr_payrolls`.`days_worked`
`hr_payrolls`.`paid_leave_days`
`hr_payrolls`.`lwop_days`
`hr_payrolls`.`regular_holiday_worked`
`hr_payrolls`.`special_holiday_worked`
`hr_payrolls`.`rate_per_day`
`hr_payrolls`.`rate_per_min`
`hr_payrolls`.`late_ut_minutes`
`hr_payrolls`.`total_tardy`
`hr_payrolls`.`basic_pay`
`hr_payrolls`.`gross_pay`
`hr_payrolls`.`holiday_pay`
`hr_payrolls`.`leave_pay`
`hr_payrolls`.`overtime_pay`
`hr_payrolls`.`total_gp`
`hr_payrolls`.`cash_advance`
`hr_payrolls`.`sss_employee`
`hr_payrolls`.`philhealth_employee`
`hr_payrolls`.`pagibig_employee`
`hr_payrolls`.`withholding_tax`
`hr_payrolls`.`statutory_total`
`hr_payrolls`.`taxable_income`
`hr_payrolls`.`formula_version`
`hr_payrolls`.`payroll_breakdown_json`
`hr_payrolls`.`remarks`
`hr_payrolls`.`benefits`
`hr_payrolls`.`deductions`
`hr_payrolls`.`net_pay`
`hr_payrolls`.`adjustment`
`hr_payrolls`.`total_net`
`hr_payrolls`.`created_at`
`hr_payrolls`.`updated_at`
`hr_payrolls`.`regular_overtime_hours`
`hr_payrolls`.`regular_overtime_pay`
`hr_payrolls`.`holiday_overtime_hours`
`hr_payrolls`.`holiday_overtime_pay`
`hr_payrolls`.`approved_ot_hours`
`hr_payrolls`.`rest_day_hours`
`hr_payrolls`.`rest_day_pay`
`hr_payrolls`.`night_diff_hours`
`hr_payrolls`.`night_diff_pay`
`hr_payrolls`.`ob_hours`
`hr_shifts`.*
`hr_shifts`.`id`
`hr_shifts`.`work_schedule_id`
`hr_shifts`.`shift_code`
`hr_shifts`.`shift_name`
`hr_shifts`.`schedule_type`
`hr_shifts`.`start_time`
`hr_shifts`.`end_time`
`hr_shifts`.`break_minutes`
`hr_shifts`.`paid_hours`
`hr_shifts`.`late_grace_minutes`
`hr_shifts`.`is_active`
`hr_shifts`.`remarks`
`hr_shifts`.`created_at`
`hr_shifts`.`updated_at`
`hr_statutory_pagibig`.*
`hr_statutory_pagibig`.`id`
`hr_statutory_pagibig`.`effective_start`
`hr_statutory_pagibig`.`effective_end`
`hr_statutory_pagibig`.`monthly_salary_from`
`hr_statutory_pagibig`.`monthly_salary_to`
`hr_statutory_pagibig`.`employee_rate`
`hr_statutory_pagibig`.`max_employee_contribution`
`hr_statutory_pagibig`.`notes`
`hr_statutory_pagibig`.`created_at`
`hr_statutory_philhealth`.*
`hr_statutory_philhealth`.`id`
`hr_statutory_philhealth`.`effective_start`
`hr_statutory_philhealth`.`effective_end`
`hr_statutory_philhealth`.`premium_rate`
`hr_statutory_philhealth`.`monthly_salary_floor`
`hr_statutory_philhealth`.`monthly_salary_ceiling`
`hr_statutory_philhealth`.`employee_share_ratio`
`hr_statutory_philhealth`.`notes`
`hr_statutory_philhealth`.`created_at`
`hr_statutory_sss`.*
`hr_statutory_sss`.`id`
`hr_statutory_sss`.`effective_start`
`hr_statutory_sss`.`effective_end`
`hr_statutory_sss`.`monthly_salary_from`
`hr_statutory_sss`.`monthly_salary_to`
`hr_statutory_sss`.`employee_share`
`hr_statutory_sss`.`employer_share`
`hr_statutory_sss`.`ec_share`
`hr_statutory_sss`.`notes`
`hr_statutory_sss`.`created_at`
`hr_statutory_withholding`.*
`hr_statutory_withholding`.`id`
`hr_statutory_withholding`.`effective_start`
`hr_statutory_withholding`.`effective_end`
`hr_statutory_withholding`.`annual_taxable_from`
`hr_statutory_withholding`.`annual_taxable_to`
`hr_statutory_withholding`.`base_tax`
`hr_statutory_withholding`.`over_percent`
`hr_statutory_withholding`.`notes`
`hr_statutory_withholding`.`created_at`
`hr_thirteenth_month_batches`.*
`hr_thirteenth_month_batches`.`id`
`hr_thirteenth_month_batches`.`payout_year`
`hr_thirteenth_month_batches`.`status`
`hr_thirteenth_month_batches`.`note`
`hr_thirteenth_month_batches`.`generated_by`
`hr_thirteenth_month_batches`.`generated_at`
`hr_thirteenth_month_batches`.`released_by`
`hr_thirteenth_month_batches`.`released_at`
`hr_thirteenth_month_batches`.`created_at`
`hr_thirteenth_month_batches`.`updated_at`
`hr_thirteenth_month_rows`.*
`hr_thirteenth_month_rows`.`id`
`hr_thirteenth_month_rows`.`batch_id`
`hr_thirteenth_month_rows`.`employee_id`
`hr_thirteenth_month_rows`.`payout_year`
`hr_thirteenth_month_rows`.`coverage_start`
`hr_thirteenth_month_rows`.`coverage_end`
`hr_thirteenth_month_rows`.`payroll_rows_count`
`hr_thirteenth_month_rows`.`qualifying_days`
`hr_thirteenth_month_rows`.`basic_salary_base`
`hr_thirteenth_month_rows`.`thirteenth_month_pay`
`hr_thirteenth_month_rows`.`taxable_excess`
`hr_thirteenth_month_rows`.`withholding_tax`
`hr_thirteenth_month_rows`.`net_amount`
`hr_thirteenth_month_rows`.`remarks`
`hr_thirteenth_month_rows`.`created_at`
`hr_thirteenth_month_rows`.`updated_at`
`leave_balances`.*
`leave_balances`.`id`
`leave_balances`.`employee_id`
`leave_balances`.`leave_type_id`
`leave_balances`.`year`
`leave_balances`.`allocated_days`
`leave_balances`.`used_days`
`leave_balances`.`created_at`
`leave_balances`.`updated_at`
`leave_request_audit_logs`.*
`leave_request_audit_logs`.`id`
`leave_request_audit_logs`.`leave_request_id`
`leave_request_audit_logs`.`action`
`leave_request_audit_logs`.`from_status`
`leave_request_audit_logs`.`to_status`
`leave_request_audit_logs`.`acted_by`
`leave_request_audit_logs`.`remarks`
`leave_request_audit_logs`.`ip_address`
`leave_request_audit_logs`.`user_agent`
`leave_request_audit_logs`.`created_at`
`leave_requests`.*
`leave_requests`.`id`
`leave_requests`.`employee_id`
`leave_requests`.`leave_type_id`
`leave_requests`.`start_date`
`leave_requests`.`end_date`
`leave_requests`.`total_days`
`leave_requests`.`reason`
`leave_requests`.`attachment`
`leave_requests`.`status`
`leave_requests`.`approved_by`
`leave_requests`.`approved_date`
`leave_requests`.`remarks`
`leave_requests`.`balance_applied`
`leave_requests`.`created_at`
`leave_types`.*
`leave_types`.`id`
`leave_types`.`leave_name`
`leave_types`.`description`
`leave_types`.`is_paid`
`leave_types`.`default_days`
`logistics_audit_logs`.*
`logistics_audit_logs`.`id`
`logistics_audit_logs`.`module`
`logistics_audit_logs`.`record_id`
`logistics_audit_logs`.`action`
`logistics_audit_logs`.`old_value`
`logistics_audit_logs`.`new_value`
`logistics_audit_logs`.`remarks`
`logistics_audit_logs`.`created_by`
`logistics_audit_logs`.`created_at`
`logistics_billing`.*
`logistics_billing`.`id`
`logistics_billing`.`invoice_no`
`logistics_billing`.`client_id`
`logistics_billing`.`shipment_id`
`logistics_billing`.`dispatch_id`
`logistics_billing`.`billing_type`
`logistics_billing`.`income_amount`
`logistics_billing`.`expense_amount`
`logistics_billing`.`billing_status`
`logistics_billing`.`due_date`
`logistics_billing`.`notes`
`logistics_billing`.`posted_to_accounting`
`logistics_billing`.`accounting_reference`
`logistics_billing`.`created_by`
`logistics_billing`.`updated_by`
`logistics_billing`.`created_at`
`logistics_billing`.`updated_at`
`logistics_clients`.*
`logistics_clients`.`id`
`logistics_clients`.`client_code`
`logistics_clients`.`company_name`
`logistics_clients`.`contact_person`
`logistics_clients`.`contact_number`
`logistics_clients`.`email`
`logistics_clients`.`address`
`logistics_clients`.`status`
`logistics_clients`.`created_by`
`logistics_clients`.`updated_by`
`logistics_clients`.`created_at`
`logistics_clients`.`updated_at`
`logistics_consolidation_batches`.*
`logistics_consolidation_batches`.`id`
`logistics_consolidation_batches`.`batch_no`
`logistics_consolidation_batches`.`batch_name`
`logistics_consolidation_batches`.`status`
`logistics_consolidation_batches`.`dispatch_ref_no`
`logistics_consolidation_batches`.`remarks`
`logistics_consolidation_batches`.`created_by`
`logistics_consolidation_batches`.`updated_by`
`logistics_consolidation_batches`.`created_at`
`logistics_consolidation_batches`.`updated_at`
`logistics_consolidation_items`.*
`logistics_consolidation_items`.`id`
`logistics_consolidation_items`.`batch_id`
`logistics_consolidation_items`.`shipment_id`
`logistics_consolidation_items`.`created_at`
`logistics_customs_clearances`.*
`logistics_customs_clearances`.`id`
`logistics_customs_clearances`.`shipment_id`
`logistics_customs_clearances`.`customs_status`
`logistics_customs_clearances`.`document_checklist`
`logistics_customs_clearances`.`remarks`
`logistics_customs_clearances`.`created_by`
`logistics_customs_clearances`.`updated_by`
`logistics_customs_clearances`.`created_at`
`logistics_customs_clearances`.`updated_at`
`logistics_customs_logs`.*
`logistics_customs_logs`.`id`
`logistics_customs_logs`.`clearance_id`
`logistics_customs_logs`.`shipment_id`
`logistics_customs_logs`.`old_status`
`logistics_customs_logs`.`new_status`
`logistics_customs_logs`.`remarks`
`logistics_customs_logs`.`updated_by`
`logistics_customs_logs`.`created_at`
`logistics_dispatches`.*
`logistics_dispatches`.`id`
`logistics_dispatches`.`dispatch_no`
`logistics_dispatches`.`batch_id`
`logistics_dispatches`.`shipment_id`
`logistics_dispatches`.`delivery_schedule`
`logistics_dispatches`.`truck_id`
`logistics_dispatches`.`driver_employee_id`
`logistics_dispatches`.`pickup_location`
`logistics_dispatches`.`delivery_address`
`logistics_dispatches`.`delivery_status`
`logistics_dispatches`.`proof_of_delivery`
`logistics_dispatches`.`delivery_photo`
`logistics_dispatches`.`signature_image`
`logistics_dispatches`.`remarks`
`logistics_dispatches`.`created_by`
`logistics_dispatches`.`updated_by`
`logistics_dispatches`.`created_at`
`logistics_dispatches`.`updated_at`
`logistics_shipments`.*
`logistics_shipments`.`id`
`logistics_shipments`.`shipment_ref_no`
`logistics_shipments`.`client_id`
`logistics_shipments`.`transaction_type`
`logistics_shipments`.`container_no`
`logistics_shipments`.`bl_awb_no`
`logistics_shipments`.`cargo_description`
`logistics_shipments`.`quantity`
`logistics_shipments`.`weight_kg`
`logistics_shipments`.`cbm`
`logistics_shipments`.`date_received`
`logistics_shipments`.`warehouse_location`
`logistics_shipments`.`current_status`
`logistics_shipments`.`remarks`
`logistics_shipments`.`created_by`
`logistics_shipments`.`updated_by`
`logistics_shipments`.`created_at`
`logistics_shipments`.`updated_at`
`logistics_warehouse_movements`.*
`logistics_warehouse_movements`.`id`
`logistics_warehouse_movements`.`shipment_id`
`logistics_warehouse_movements`.`movement_type`
`logistics_warehouse_movements`.`from_location`
`logistics_warehouse_movements`.`to_location`
`logistics_warehouse_movements`.`status_from`
`logistics_warehouse_movements`.`status_to`
`logistics_warehouse_movements`.`remarks`
`logistics_warehouse_movements`.`moved_by`
`logistics_warehouse_movements`.`created_at`
`mobile_push_tokens`.*
`mobile_push_tokens`.`id`
`mobile_push_tokens`.`user_id`
`mobile_push_tokens`.`employee_id`
`mobile_push_tokens`.`expo_push_token`
`mobile_push_tokens`.`platform`
`mobile_push_tokens`.`device_name`
`mobile_push_tokens`.`app_mode`
`mobile_push_tokens`.`is_active`
`mobile_push_tokens`.`last_seen_at`
`mobile_push_tokens`.`created_at`
`mobile_push_tokens`.`updated_at`
`offboarding_records`.*
`offboarding_records`.`id`
`offboarding_records`.`employee_id`
`offboarding_records`.`trigger_type`
`offboarding_records`.`resignation_date`
`offboarding_records`.`last_working_day`
`offboarding_records`.`reason`
`offboarding_records`.`final_pay_request_status`
`offboarding_records`.`status`
`offboarding_records`.`created_by`
`offboarding_records`.`created_at`
`offboarding_records`.`updated_at`
`official_business_requests`.*
`official_business_requests`.`id`
`official_business_requests`.`employee_id`
`official_business_requests`.`ob_date`
`official_business_requests`.`start_time`
`official_business_requests`.`end_time`
`official_business_requests`.`location`
`official_business_requests`.`client_company`
`official_business_requests`.`purpose`
`official_business_requests`.`attachment`
`official_business_requests`.`credited_hours`
`official_business_requests`.`status`
`official_business_requests`.`supervisor_by`
`official_business_requests`.`supervisor_at`
`official_business_requests`.`approved_by`
`official_business_requests`.`approved_at`
`official_business_requests`.`remarks`
`official_business_requests`.`created_by`
`official_business_requests`.`created_at`
`official_business_requests`.`updated_at`
`order_deliveries`.*
`order_deliveries`.`id`
`order_deliveries`.`allocation_no`
`order_deliveries`.`order_id`
`order_deliveries`.`truck_id`
`order_deliveries`.`scheduled_date`
`order_deliveries`.`route_sequence`
`order_deliveries`.`payment_mode`
`order_deliveries`.`cash_to_collect`
`order_deliveries`.`pickup_location`
`order_deliveries`.`dropoff_location`
`order_deliveries`.`trip_type`
`order_deliveries`.`route_profile`
`order_deliveries`.`estimated_one_way_distance_km`
`order_deliveries`.`estimated_total_distance_km`
`order_deliveries`.`estimated_cargo_weight_kg`
`order_deliveries`.`load_utilization_percent`
`order_deliveries`.`truck_km_per_liter`
`order_deliveries`.`recommended_km_per_liter`
`order_deliveries`.`diesel_price_per_liter`
`order_deliveries`.`cost_per_km`
`order_deliveries`.`estimated_fuel_liters`
`order_deliveries`.`estimated_fuel_cost`
`order_deliveries`.`actual_start_odometer`
`order_deliveries`.`actual_end_odometer`
`order_deliveries`.`actual_distance_km`
`order_deliveries`.`actual_fuel_liters`
`order_deliveries`.`actual_km_per_liter`
`order_deliveries`.`actual_fuel_cost`
`order_deliveries`.`fuel_variance`
`order_deliveries`.`distance_variance`
`order_deliveries`.`status`
`order_deliveries`.`notes`
`order_deliveries`.`cancel_reason`
`order_deliveries`.`canceled_at`
`order_deliveries`.`canceled_by`
`order_deliveries`.`proof_path`
`order_deliveries`.`user_id`
`order_deliveries`.`created_at`
`order_delivery_expenses`.*
`order_delivery_expenses`.`id`
`order_delivery_expenses`.`order_delivery_id`
`order_delivery_expenses`.`expense_name`
`order_delivery_expenses`.`amount`
`order_delivery_expenses`.`created_at`
`order_delivery_item_returns`.*
`order_delivery_item_returns`.`id`
`order_delivery_item_returns`.`order_delivery_id`
`order_delivery_item_returns`.`order_delivery_item_id`
`order_delivery_item_returns`.`product_id`
`order_delivery_item_returns`.`qty_returned`
`order_delivery_item_returns`.`reason`
`order_delivery_item_returns`.`returned_by`
`order_delivery_item_returns`.`returned_at`
`order_delivery_items`.*
`order_delivery_items`.`id`
`order_delivery_items`.`order_delivery_id`
`order_delivery_items`.`order_item_id`
`order_delivery_items`.`product_id`
`order_delivery_items`.`qty_allocated`
`order_delivery_itinerary`.*
`order_delivery_itinerary`.`id`
`order_delivery_itinerary`.`order_delivery_id`
`order_delivery_itinerary`.`stop_no`
`order_delivery_itinerary`.`stop_name`
`order_delivery_itinerary`.`created_at`
`order_delivery_status_logs`.*
`order_delivery_status_logs`.`id`
`order_delivery_status_logs`.`order_delivery_id`
`order_delivery_status_logs`.`from_status`
`order_delivery_status_logs`.`to_status`
`order_delivery_status_logs`.`note`
`order_delivery_status_logs`.`changed_by`
`order_delivery_status_logs`.`changed_at`
`orders`.*
`orders`.`id`
`orders`.`bill_no`
`orders`.`company_name`
`orders`.`customer_name`
`orders`.`customer_address`
`orders`.`customer_phone`
`orders`.`delivery_date`
`orders`.`delivery_type`
`orders`.`date_time`
`orders`.`gross_amount`
`orders`.`service_charge_rate`
`orders`.`service_charge`
`orders`.`vat_charge_rate`
`orders`.`vat_charge`
`orders`.`tax_inclusive`
`orders`.`tax_exclusive`
`orders`.`net_amount`
`orders`.`deliveryfee`
`orders`.`discount`
`orders`.`paid_status`
`orders`.`return_note`
`orders`.`payment_proof`
`orders`.`modeofpayment`
`orders`.`record_type`
`orders`.`approval_status`
`orders`.`approved_at`
`orders`.`approved_by`
`orders`.`source_quotation_id`
`orders`.`quotation_valid_until`
`orders`.`user_id`
`orders`.`created_at`
`orders_item`.*
`orders_item`.`id`
`orders_item`.`order_id`
`orders_item`.`product_id`
`orders_item`.`product_name`
`orders_item`.`qty`
`orders_item`.`rate`
`orders_item`.`amount`
`overtime_requests`.*
`overtime_requests`.`id`
`overtime_requests`.`employee_id`
`overtime_requests`.`ot_date`
`overtime_requests`.`start_time`
`overtime_requests`.`end_time`
`overtime_requests`.`reason`
`overtime_requests`.`attachment`
`overtime_requests`.`requested_hours`
`overtime_requests`.`approved_hours`
`overtime_requests`.`payable_hours`
`overtime_requests`.`is_pre_shift`
`overtime_requests`.`status`
`overtime_requests`.`supervisor_by`
`overtime_requests`.`supervisor_at`
`overtime_requests`.`approved_by`
`overtime_requests`.`approved_at`
`overtime_requests`.`remarks`
`overtime_requests`.`created_by`
`overtime_requests`.`created_at`
`overtime_requests`.`updated_at`
`payables`.*
`payables`.`id`
`payables`.`supplier_name`
`payables`.`reference_no`
`payables`.`delivery_id`
`payables`.`due_date`
`payables`.`amount`
`payables`.`balance`
`payables`.`status`
`payables`.`notes`
`payables`.`created_by`
`payables`.`updated_by`
`payables`.`created_at`
`payables`.`updated_at`
`payments`.*
`payments`.`id`
`payments`.`payment_no`
`payments`.`payment_date`
`payments`.`direction`
`payments`.`payer_type`
`payments`.`payer_name`
`payments`.`reference_type`
`payments`.`reference_id`
`payments`.`cash_account_id`
`payments`.`counter_account_id`
`payments`.`amount`
`payments`.`payment_method`
`payments`.`reference_no`
`payments`.`notes`
`payments`.`transaction_id`
`payments`.`created_by`
`payments`.`updated_by`
`payments`.`created_at`
`payments`.`updated_at`
`payroll_activity_logs`.*
`payroll_activity_logs`.`id`
`payroll_activity_logs`.`cutoff_id`
`payroll_activity_logs`.`record_type`
`payroll_activity_logs`.`record_id`
`payroll_activity_logs`.`action`
`payroll_activity_logs`.`user_id`
`payroll_activity_logs`.`details_json`
`payroll_activity_logs`.`created_at`
`payroll_adjustments`.*
`payroll_adjustments`.`id`
`payroll_adjustments`.`payroll_id`
`payroll_adjustments`.`cutoff_id`
`payroll_adjustments`.`employee_id`
`payroll_adjustments`.`adjustment_type`
`payroll_adjustments`.`amount`
`payroll_adjustments`.`reason`
`payroll_adjustments`.`status`
`payroll_adjustments`.`created_by`
`payroll_adjustments`.`approved_by`
`payroll_adjustments`.`approved_at`
`payroll_adjustments`.`created_at`
`payroll_adjustments`.`updated_at`
`payroll_details`.*
`payroll_details`.`id`
`payroll_details`.`payroll_id`
`payroll_details`.`detail_type`
`payroll_details`.`label`
`payroll_details`.`quantity`
`payroll_details`.`rate`
`payroll_details`.`amount`
`payroll_details`.`metadata_json`
`payroll_details`.`created_at`
`payroll_office_entries`.*
`payroll_office_entries`.`id`
`payroll_office_entries`.`cutoff_id`
`payroll_office_entries`.`employee_id`
`payroll_office_entries`.`daily_rate`
`payroll_office_entries`.`paid_days`
`payroll_office_entries`.`late_undertime_deduction`
`payroll_office_entries`.`overtime`
`payroll_office_entries`.`allowance`
`payroll_office_entries`.`incentive`
`payroll_office_entries`.`deduction`
`payroll_office_entries`.`remarks`
`payroll_office_entries`.`encoded_by`
`payroll_office_entries`.`created_at`
`payroll_office_entries`.`updated_at`
`payroll_settings`.*
`payroll_settings`.`id`
`payroll_settings`.`setting_key`
`payroll_settings`.`setting_value`
`payroll_settings`.`value_type`
`payroll_settings`.`effective_start`
`payroll_settings`.`effective_end`
`payroll_settings`.`description`
`payroll_settings`.`updated_by`
`payroll_settings`.`created_at`
`payroll_settings`.`updated_at`
`payroll_trip_entries`.*
`payroll_trip_entries`.`id`
`payroll_trip_entries`.`cutoff_id`
`payroll_trip_entries`.`employee_id`
`payroll_trip_entries`.`raw_name`
`payroll_trip_entries`.`corrected_name`
`payroll_trip_entries`.`position`
`payroll_trip_entries`.`truck_number`
`payroll_trip_entries`.`container_number`
`payroll_trip_entries`.`area_destination`
`payroll_trip_entries`.`rate`
`payroll_trip_entries`.`entry_type`
`payroll_trip_entries`.`remarks`
`payroll_trip_entries`.`encoded_by`
`payroll_trip_entries`.`created_at`
`payroll_trip_entries`.`updated_at`
`payroll_trip_rates`.*
`payroll_trip_rates`.`id`
`payroll_trip_rates`.`destination_area`
`payroll_trip_rates`.`truck_type`
`payroll_trip_rates`.`km`
`payroll_trip_rates`.`customer`
`payroll_trip_rates`.`standard_trip_rate`
`payroll_trip_rates`.`driver_rate_type`
`payroll_trip_rates`.`driver_rate_value`
`payroll_trip_rates`.`helper_rate_type`
`payroll_trip_rates`.`helper_rate_value`
`payroll_trip_rates`.`checker_rate_type`
`payroll_trip_rates`.`checker_rate_value`
`payroll_trip_rates`.`food_allowance`
`payroll_trip_rates`.`toll_other_expense`
`payroll_trip_rates`.`status`
`payroll_trip_rates`.`created_at`
`payroll_trip_rates`.`updated_at`
`payslips`.*
`payslips`.`id`
`payslips`.`payroll_id`
`payslips`.`employee_id`
`payslips`.`cutoff_id`
`payslips`.`token_hash`
`payslips`.`generated_by`
`payslips`.`generated_at`
`payslips`.`viewed_at`
`payslips`.`status`
`performance_evaluations`.*
`performance_evaluations`.`id`
`performance_evaluations`.`employee_id`
`performance_evaluations`.`evaluation_type`
`performance_evaluations`.`period_start`
`performance_evaluations`.`period_end`
`performance_evaluations`.`evaluator_id`
`performance_evaluations`.`final_score`
`performance_evaluations`.`comments`
`performance_evaluations`.`strengths`
`performance_evaluations`.`areas_for_improvement`
`performance_evaluations`.`recommendation`
`performance_evaluations`.`attachment`
`performance_evaluations`.`status`
`performance_evaluations`.`created_at`
`performance_evaluations`.`updated_at`
`product_history`.*
`product_history`.`id`
`product_history`.`product_id`
`product_history`.`user_id`
`product_history`.`before_data`
`product_history`.`after_data`
`product_history`.`created_at`
`product_history`.`action`
`product_history`.`reference`
`product_history`.`qty_change`
`products`.*
`products`.`id`
`products`.`name`
`products`.`sku`
`products`.`price`
`products`.`qty`
`products`.`image`
`products`.`description`
`products`.`attribute_value_id`
`products`.`brand_id`
`products`.`category_id`
`products`.`store_id`
`products`.`availability`
`products`.`kilogram`
`products`.`unit_item`
`products`.`dealerprice`
`products`.`pricing_type`
`products`.`dealer_price_per_kg`
`profile_update_requests`.*
`profile_update_requests`.`id`
`profile_update_requests`.`employee_id`
`profile_update_requests`.`field_name`
`profile_update_requests`.`old_value`
`profile_update_requests`.`new_value`
`profile_update_requests`.`proof_attachment`
`profile_update_requests`.`reason`
`profile_update_requests`.`status`
`profile_update_requests`.`created_by`
`profile_update_requests`.`reviewed_by`
`profile_update_requests`.`reviewed_at`
`profile_update_requests`.`remarks`
`profile_update_requests`.`created_at`
`profile_update_requests`.`updated_at`
`receivables`.*
`receivables`.`id`
`receivables`.`customer_name`
`receivables`.`reference_no`
`receivables`.`order_id`
`receivables`.`due_date`
`receivables`.`amount`
`receivables`.`balance`
`receivables`.`status`
`receivables`.`notes`
`receivables`.`created_by`
`receivables`.`updated_by`
`receivables`.`created_at`
`receivables`.`updated_at`
`recruitment_applicant_documents`.*
`recruitment_applicant_documents`.`id`
`recruitment_applicant_documents`.`applicant_id`
`recruitment_applicant_documents`.`document_type`
`recruitment_applicant_documents`.`title`
`recruitment_applicant_documents`.`original_filename`
`recruitment_applicant_documents`.`stored_filename`
`recruitment_applicant_documents`.`file_path`
`recruitment_applicant_documents`.`file_extension`
`recruitment_applicant_documents`.`mime_type`
`recruitment_applicant_documents`.`file_size`
`recruitment_applicant_documents`.`status`
`recruitment_applicant_documents`.`uploaded_by`
`recruitment_applicant_documents`.`created_at`
`recruitment_applicant_documents`.`updated_at`
`recruitment_applicants`.*
`recruitment_applicants`.`id`
`recruitment_applicants`.`applicant_code`
`recruitment_applicants`.`first_name`
`recruitment_applicants`.`middle_name`
`recruitment_applicants`.`last_name`
`recruitment_applicants`.`suffix`
`recruitment_applicants`.`birthdate`
`recruitment_applicants`.`gender`
`recruitment_applicants`.`civil_status`
`recruitment_applicants`.`contact_number`
`recruitment_applicants`.`email`
`recruitment_applicants`.`address`
`recruitment_applicants`.`position_id`
`recruitment_applicants`.`preferred_company`
`recruitment_applicants`.`expected_salary`
`recruitment_applicants`.`availability_date`
`recruitment_applicants`.`employment_history`
`recruitment_applicants`.`educational_background`
`recruitment_applicants`.`skills`
`recruitment_applicants`.`certifications`
`recruitment_applicants`.`driver_license_details`
`recruitment_applicants`.`work_experience`
`recruitment_applicants`.`referral_source`
`recruitment_applicants`.`remarks`
`recruitment_applicants`.`status`
`recruitment_applicants`.`consent_accepted`
`recruitment_applicants`.`consent_accepted_at`
`recruitment_applicants`.`consent_ip`
`recruitment_applicants`.`consent_version`
`recruitment_applicants`.`converted_employee_id`
`recruitment_applicants`.`created_at`
`recruitment_applicants`.`updated_at`
`recruitment_consent_logs`.*
`recruitment_consent_logs`.`id`
`recruitment_consent_logs`.`applicant_id`
`recruitment_consent_logs`.`interview_session_id`
`recruitment_consent_logs`.`consent_type`
`recruitment_consent_logs`.`consent_version`
`recruitment_consent_logs`.`consent_text`
`recruitment_consent_logs`.`ip_address`
`recruitment_consent_logs`.`user_agent`
`recruitment_consent_logs`.`accepted_at`
`recruitment_email_logs`.*
`recruitment_email_logs`.`id`
`recruitment_email_logs`.`applicant_id`
`recruitment_email_logs`.`email_type`
`recruitment_email_logs`.`recipient_email`
`recruitment_email_logs`.`subject`
`recruitment_email_logs`.`body_snapshot`
`recruitment_email_logs`.`status`
`recruitment_email_logs`.`error_message`
`recruitment_email_logs`.`sent_by`
`recruitment_email_logs`.`sent_at`
`recruitment_email_logs`.`created_at`
`recruitment_email_templates`.*
`recruitment_email_templates`.`id`
`recruitment_email_templates`.`template_name`
`recruitment_email_templates`.`stage`
`recruitment_email_templates`.`subject`
`recruitment_email_templates`.`body`
`recruitment_email_templates`.`status`
`recruitment_email_templates`.`created_by`
`recruitment_email_templates`.`updated_by`
`recruitment_email_templates`.`created_at`
`recruitment_email_templates`.`updated_at`
`recruitment_final_interviews`.*
`recruitment_final_interviews`.`id`
`recruitment_final_interviews`.`applicant_id`
`recruitment_final_interviews`.`interview_date`
`recruitment_final_interviews`.`interview_time`
`recruitment_final_interviews`.`interview_type`
`recruitment_final_interviews`.`location_or_link`
`recruitment_final_interviews`.`interviewer_id`
`recruitment_final_interviews`.`remarks`
`recruitment_final_interviews`.`status`
`recruitment_final_interviews`.`created_by`
`recruitment_final_interviews`.`created_at`
`recruitment_final_interviews`.`updated_at`
`recruitment_interview_event_logs`.*
`recruitment_interview_event_logs`.`id`
`recruitment_interview_event_logs`.`interview_session_id`
`recruitment_interview_event_logs`.`applicant_id`
`recruitment_interview_event_logs`.`question_id`
`recruitment_interview_event_logs`.`event_type`
`recruitment_interview_event_logs`.`event_time`
`recruitment_interview_event_logs`.`duration_seconds`
`recruitment_interview_event_logs`.`metadata`
`recruitment_interview_event_logs`.`ip_address`
`recruitment_interview_event_logs`.`user_agent`
`recruitment_interview_event_logs`.`created_at`
`recruitment_interview_integrity_summary`.*
`recruitment_interview_integrity_summary`.`id`
`recruitment_interview_integrity_summary`.`interview_session_id`
`recruitment_interview_integrity_summary`.`applicant_id`
`recruitment_interview_integrity_summary`.`tab_switch_count`
`recruitment_interview_integrity_summary`.`total_away_seconds`
`recruitment_interview_integrity_summary`.`fullscreen_exit_count`
`recruitment_interview_integrity_summary`.`copy_attempt_count`
`recruitment_interview_integrity_summary`.`right_click_attempt_count`
`recruitment_interview_integrity_summary`.`suspicious_key_count`
`recruitment_interview_integrity_summary`.`device_interruption_count`
`recruitment_interview_integrity_summary`.`duplicate_session_count`
`recruitment_interview_integrity_summary`.`early_stop_count`
`recruitment_interview_integrity_summary`.`too_short_answer_count`
`recruitment_interview_integrity_summary`.`failed_upload_count`
`recruitment_interview_integrity_summary`.`invalid_step_count`
`recruitment_interview_integrity_summary`.`no_face_count`
`recruitment_interview_integrity_summary`.`multiple_face_count`
`recruitment_interview_integrity_summary`.`risk_score`
`recruitment_interview_integrity_summary`.`risk_level`
`recruitment_interview_integrity_summary`.`hr_review_status`
`recruitment_interview_integrity_summary`.`hr_integrity_remarks`
`recruitment_interview_integrity_summary`.`first_ip_address`
`recruitment_interview_integrity_summary`.`last_ip_address`
`recruitment_interview_integrity_summary`.`first_user_agent`
`recruitment_interview_integrity_summary`.`last_user_agent`
`recruitment_interview_integrity_summary`.`browser_name`
`recruitment_interview_integrity_summary`.`operating_system`
`recruitment_interview_integrity_summary`.`device_type`
`recruitment_interview_integrity_summary`.`screen_size`
`recruitment_interview_integrity_summary`.`timezone`
`recruitment_interview_integrity_summary`.`started_at`
`recruitment_interview_integrity_summary`.`completed_at`
`recruitment_interview_integrity_summary`.`created_at`
`recruitment_interview_integrity_summary`.`updated_at`
`recruitment_interview_progress`.*
`recruitment_interview_progress`.`id`
`recruitment_interview_progress`.`interview_session_id`
`recruitment_interview_progress`.`applicant_id`
`recruitment_interview_progress`.`current_question_id`
`recruitment_interview_progress`.`current_question_order`
`recruitment_interview_progress`.`completed_questions_count`
`recruitment_interview_progress`.`status`
`recruitment_interview_progress`.`current_step`
`recruitment_interview_progress`.`current_question_started_at`
`recruitment_interview_progress`.`recording_state`
`recruitment_interview_progress`.`last_activity_at`
`recruitment_interview_progress`.`updated_at`
`recruitment_interview_sessions`.*
`recruitment_interview_sessions`.`id`
`recruitment_interview_sessions`.`applicant_id`
`recruitment_interview_sessions`.`position_id`
`recruitment_interview_sessions`.`token`
`recruitment_interview_sessions`.`token_expires_at`
`recruitment_interview_sessions`.`status`
`recruitment_interview_sessions`.`expires_at`
`recruitment_interview_sessions`.`allow_retake`
`recruitment_interview_sessions`.`retakes_allowed`
`recruitment_interview_sessions`.`allow_preview`
`recruitment_interview_sessions`.`require_all_questions`
`recruitment_interview_sessions`.`consent_accepted`
`recruitment_interview_sessions`.`consent_accepted_at`
`recruitment_interview_sessions`.`consent_ip`
`recruitment_interview_sessions`.`consent_user_agent`
`recruitment_interview_sessions`.`applicant_agreed_interview_rules`
`recruitment_interview_sessions`.`rules_agreed_at`
`recruitment_interview_sessions`.`rules_agreed_ip`
`recruitment_interview_sessions`.`rules_agreed_user_agent`
`recruitment_interview_sessions`.`first_client_id`
`recruitment_interview_sessions`.`active_client_id`
`recruitment_interview_sessions`.`active_client_seen_at`
`recruitment_interview_sessions`.`last_device_info`
`recruitment_interview_sessions`.`created_by`
`recruitment_interview_sessions`.`started_at`
`recruitment_interview_sessions`.`completed_at`
`recruitment_interview_sessions`.`created_at`
`recruitment_interview_sessions`.`updated_at`
`recruitment_management_review_logs`.*
`recruitment_management_review_logs`.`id`
`recruitment_management_review_logs`.`applicant_id`
`recruitment_management_review_logs`.`token_id`
`recruitment_management_review_logs`.`action`
`recruitment_management_review_logs`.`reviewer_name`
`recruitment_management_review_logs`.`rating`
`recruitment_management_review_logs`.`remarks`
`recruitment_management_review_logs`.`recommendation`
`recruitment_management_review_logs`.`ip_address`
`recruitment_management_review_logs`.`user_agent`
`recruitment_management_review_logs`.`created_at`
`recruitment_management_review_tokens`.*
`recruitment_management_review_tokens`.`id`
`recruitment_management_review_tokens`.`applicant_id`
`recruitment_management_review_tokens`.`token`
`recruitment_management_review_tokens`.`expires_at`
`recruitment_management_review_tokens`.`status`
`recruitment_management_review_tokens`.`allow_rating`
`recruitment_management_review_tokens`.`allow_remarks`
`recruitment_management_review_tokens`.`show_question_videos`
`recruitment_management_review_tokens`.`show_applicant_details`
`recruitment_management_review_tokens`.`show_documents`
`recruitment_management_review_tokens`.`created_by`
`recruitment_management_review_tokens`.`revoked_by`
`recruitment_management_review_tokens`.`revoked_at`
`recruitment_management_review_tokens`.`created_at`
`recruitment_management_review_tokens`.`updated_at`
`recruitment_positions`.*
`recruitment_positions`.`id`
`recruitment_positions`.`position_title`
`recruitment_positions`.`company`
`recruitment_positions`.`department`
`recruitment_positions`.`job_description`
`recruitment_positions`.`qualifications`
`recruitment_positions`.`requirements`
`recruitment_positions`.`employment_type`
`recruitment_positions`.`vacancy_count`
`recruitment_positions`.`status`
`recruitment_positions`.`created_by`
`recruitment_positions`.`created_at`
`recruitment_positions`.`updated_at`
`recruitment_question_video_versions`.*
`recruitment_question_video_versions`.`id`
`recruitment_question_video_versions`.`question_id`
`recruitment_question_video_versions`.`question_video_path`
`recruitment_question_video_versions`.`question_video_original_filename`
`recruitment_question_video_versions`.`question_video_stored_filename`
`recruitment_question_video_versions`.`question_video_mime_type`
`recruitment_question_video_versions`.`question_video_size`
`recruitment_question_video_versions`.`question_video_duration_seconds`
`recruitment_question_video_versions`.`replaced_by`
`recruitment_question_video_versions`.`replaced_at`
`recruitment_question_view_logs`.*
`recruitment_question_view_logs`.`id`
`recruitment_question_view_logs`.`interview_session_id`
`recruitment_question_view_logs`.`applicant_id`
`recruitment_question_view_logs`.`question_id`
`recruitment_question_view_logs`.`viewed_at`
`recruitment_question_view_logs`.`completed_full_watch`
`recruitment_question_view_logs`.`replay_count`
`recruitment_question_view_logs`.`ip_address`
`recruitment_question_view_logs`.`user_agent`
`recruitment_question_view_logs`.`created_at`
`recruitment_questions`.*
`recruitment_questions`.`id`
`recruitment_questions`.`position_id`
`recruitment_questions`.`company`
`recruitment_questions`.`question_text`
`recruitment_questions`.`question_type`
`recruitment_questions`.`question_mode`
`recruitment_questions`.`question_video_path`
`recruitment_questions`.`question_video_original_filename`
`recruitment_questions`.`question_video_stored_filename`
`recruitment_questions`.`question_video_mime_type`
`recruitment_questions`.`question_video_size`
`recruitment_questions`.`question_video_duration_seconds`
`recruitment_questions`.`show_text_overlay`
`recruitment_questions`.`text_overlay_position`
`recruitment_questions`.`answer_time_limit_seconds`
`recruitment_questions`.`allow_replay`
`recruitment_questions`.`max_replay_count`
`recruitment_questions`.`require_full_watch_before_answer`
`recruitment_questions`.`allow_answer_retake`
`recruitment_questions`.`max_answer_retake_count`
`recruitment_questions`.`time_limit_seconds`
`recruitment_questions`.`sort_order`
`recruitment_questions`.`is_required`
`recruitment_questions`.`status`
`recruitment_questions`.`created_by`
`recruitment_questions`.`updated_by`
`recruitment_questions`.`created_at`
`recruitment_questions`.`updated_at`
`recruitment_review_scores`.*
`recruitment_review_scores`.`id`
`recruitment_review_scores`.`review_id`
`recruitment_review_scores`.`applicant_id`
`recruitment_review_scores`.`interview_session_id`
`recruitment_review_scores`.`reviewer_id`
`recruitment_review_scores`.`question_id`
`recruitment_review_scores`.`rating`
`recruitment_review_scores`.`remarks`
`recruitment_review_scores`.`pass_fail_status`
`recruitment_review_scores`.`created_at`
`recruitment_review_scores`.`updated_at`
`recruitment_reviews`.*
`recruitment_reviews`.`id`
`recruitment_reviews`.`applicant_id`
`recruitment_reviews`.`reviewer_id`
`recruitment_reviews`.`technical_rating`
`recruitment_reviews`.`communication_rating`
`recruitment_reviews`.`experience_rating`
`recruitment_reviews`.`professionalism_rating`
`recruitment_reviews`.`overall_rating`
`recruitment_reviews`.`recommendation`
`recruitment_reviews`.`remarks`
`recruitment_reviews`.`created_at`
`recruitment_reviews`.`updated_at`
`recruitment_settings`.*
`recruitment_settings`.`id`
`recruitment_settings`.`setting_key`
`recruitment_settings`.`setting_value`
`recruitment_settings`.`value_type`
`recruitment_settings`.`description`
`recruitment_settings`.`updated_by`
`recruitment_settings`.`created_at`
`recruitment_settings`.`updated_at`
`recruitment_status_logs`.*
`recruitment_status_logs`.`id`
`recruitment_status_logs`.`applicant_id`
`recruitment_status_logs`.`old_status`
`recruitment_status_logs`.`new_status`
`recruitment_status_logs`.`changed_by`
`recruitment_status_logs`.`remarks`
`recruitment_status_logs`.`created_at`
`recruitment_video_answers`.*
`recruitment_video_answers`.`id`
`recruitment_video_answers`.`interview_session_id`
`recruitment_video_answers`.`applicant_id`
`recruitment_video_answers`.`question_id`
`recruitment_video_answers`.`question_shown_at`
`recruitment_video_answers`.`question_video_started_at`
`recruitment_video_answers`.`question_video_ended_at`
`recruitment_video_answers`.`countdown_started_at`
`recruitment_video_answers`.`recording_started_at`
`recruitment_video_answers`.`recording_ended_at`
`recruitment_video_answers`.`auto_started_recording`
`recruitment_video_answers`.`recording_stop_reason`
`recruitment_video_answers`.`upload_started_at`
`recruitment_video_answers`.`upload_completed_at`
`recruitment_video_answers`.`uploaded_at`
`recruitment_video_answers`.`is_early_submitted`
`recruitment_video_answers`.`confirmed_short_answer`
`recruitment_video_answers`.`answer_video_path`
`recruitment_video_answers`.`answer_video_original_filename`
`recruitment_video_answers`.`answer_video_stored_filename`
`recruitment_video_answers`.`answer_video_mime_type`
`recruitment_video_answers`.`answer_video_size`
`recruitment_video_answers`.`answer_duration_seconds`
`recruitment_video_answers`.`retake_count`
`recruitment_video_answers`.`video_file_path`
`recruitment_video_answers`.`video_filename`
`recruitment_video_answers`.`video_size`
`recruitment_video_answers`.`mime_type`
`recruitment_video_answers`.`duration_seconds`
`recruitment_video_answers`.`attempt_no`
`recruitment_video_answers`.`recorded_at`
`recruitment_video_answers`.`submitted_at`
`recruitment_video_answers`.`upload_status`
`recruitment_video_answers`.`status`
`recruitment_video_answers`.`created_at`
`recruitment_video_answers`.`updated_at`
`schedule_change_logs`.*
`schedule_change_logs`.`id`
`schedule_change_logs`.`employee_id`
`schedule_change_logs`.`scope_type`
`schedule_change_logs`.`scope_value`
`schedule_change_logs`.`old_schedule_id`
`schedule_change_logs`.`new_schedule_id`
`schedule_change_logs`.`effective_date`
`schedule_change_logs`.`changed_by`
`schedule_change_logs`.`reason`
`schedule_change_logs`.`created_at`
`schedule_scope_assignments`.*
`schedule_scope_assignments`.`id`
`schedule_scope_assignments`.`scope_type`
`schedule_scope_assignments`.`scope_value`
`schedule_scope_assignments`.`schedule_id`
`schedule_scope_assignments`.`effective_date`
`schedule_scope_assignments`.`end_date`
`schedule_scope_assignments`.`assigned_by`
`schedule_scope_assignments`.`remarks`
`schedule_scope_assignments`.`status`
`schedule_scope_assignments`.`created_at`
`schedule_scope_assignments`.`updated_at`
`stock_adjustments`.*
`stock_adjustments`.`id`
`stock_adjustments`.`product_id`
`stock_adjustments`.`old_qty`
`stock_adjustments`.`new_qty`
`stock_adjustments`.`difference`
`stock_adjustments`.`reason`
`stock_adjustments`.`user_id`
`stock_adjustments`.`created_at`
`stores`.*
`stores`.`id`
`stores`.`name`
`stores`.`active`
`system_settings`.*
`system_settings`.`id`
`system_settings`.`setting_key`
`system_settings`.`setting_value`
`system_settings`.`value_type`
`system_settings`.`description`
`system_settings`.`updated_by`
`system_settings`.`created_at`
`system_settings`.`updated_at`
`transaction_lines`.*
`transaction_lines`.`id`
`transaction_lines`.`transaction_id`
`transaction_lines`.`account_id`
`transaction_lines`.`line_type`
`transaction_lines`.`amount`
`transaction_lines`.`memo`
`transaction_lines`.`created_at`
`truck_locations`.*
`truck_locations`.`id`
`truck_locations`.`truck_id`
`truck_locations`.`latitude`
`truck_locations`.`longitude`
`truck_locations`.`speed_kph`
`truck_locations`.`captured_at`
`truck_locations`.`source`
`truck_locations`.`created_at`
`trucks`.*
`trucks`.`id`
`trucks`.`name`
`trucks`.`plate_no`
`trucks`.`capacity_kg`
`trucks`.`capacity_cbm`
`trucks`.`gps_device_id`
`trucks`.`active`
`trucks`.`created_at`
`user_group`.*
`user_group`.`id`
`user_group`.`user_id`
`user_group`.`group_id`
`user_notifications`.*
`user_notifications`.`id`
`user_notifications`.`user_id`
`user_notifications`.`type`
`user_notifications`.`title`
`user_notifications`.`message`
`user_notifications`.`link_url`
`user_notifications`.`payload_json`
`user_notifications`.`is_read`
`user_notifications`.`created_at`
`user_notifications`.`read_at`
`users`.*
`users`.`id`
`users`.`username`
`users`.`password`
`users`.`must_change_password`
`users`.`email`
`users`.`employee_id`
`users`.`firstname`
`users`.`lastname`
`users`.`phone`
`users`.`gender`
`website_inquiries`.*
`website_inquiries`.`id`
`website_inquiries`.`product_id`
`website_inquiries`.`product_name`
`website_inquiries`.`client_name`
`website_inquiries`.`company_name`
`website_inquiries`.`email`
`website_inquiries`.`phone`
`website_inquiries`.`subject`
`website_inquiries`.`message`
`website_inquiries`.`source_page`
`website_inquiries`.`ip_address`
`website_inquiries`.`user_agent`
`website_inquiries`.`status`
`website_inquiries`.`created_at`
`website_inquiries`.`updated_at`
`work_schedule_days`.*
`work_schedule_days`.`id`
`work_schedule_days`.`schedule_id`
`work_schedule_days`.`day_of_week`
`work_schedule_days`.`is_working_day`
`work_schedule_days`.`is_rest_day`
`work_schedules`.*
`work_schedules`.`id`
`work_schedules`.`schedule_code`
`work_schedules`.`schedule_name`
`work_schedules`.`schedule_type`
`work_schedules`.`start_time`
`work_schedules`.`end_time`
`work_schedules`.`break_minutes`
`work_schedules`.`required_work_minutes`
`work_schedules`.`grace_period_minutes`
`work_schedules`.`is_overnight`
`work_schedules`.`effective_date`
`work_schedules`.`status`
`work_schedules`.`remarks`
`work_schedules`.`legacy_shift_id`
`work_schedules`.`created_by`
`work_schedules`.`updated_by`
`work_schedules`.`created_at`
`work_schedules`.`updated_at`
`accounting_transactions`.*
`accounting_transactions`.`id`
`accounting_transactions`.`transaction_no`
`accounting_transactions`.`transaction_date`
`accounting_transactions`.`reference_no`
`accounting_transactions`.`transaction_type`
`accounting_transactions`.`party_type`
`accounting_transactions`.`party_name`
`accounting_transactions`.`description`
`accounting_transactions`.`status`
`accounting_transactions`.`source_module`
`accounting_transactions`.`source_record_id`
`accounting_transactions`.`total_debit`
`accounting_transactions`.`total_credit`
`accounting_transactions`.`created_by`
`accounting_transactions`.`updated_by`
`accounting_transactions`.`created_at`
`accounting_transactions`.`updated_at`
`accounts`.*
`accounts`.`id`
`accounts`.`account_code`
`accounts`.`account_name`
`accounts`.`account_type`
`accounts`.`parent_account_id`
`accounts`.`normal_balance`
`accounts`.`is_cash_account`
`accounts`.`is_active`
`accounts`.`notes`
`accounts`.`created_by`
`accounts`.`updated_by`
`accounts`.`created_at`
`accounts`.`updated_at`
`api_mobile_tokens`.*
`api_mobile_tokens`.`id`
`api_mobile_tokens`.`user_id`
`api_mobile_tokens`.`employee_id`
`api_mobile_tokens`.`token_hash`
`api_mobile_tokens`.`device_name`
`api_mobile_tokens`.`ip_address`
`api_mobile_tokens`.`user_agent`
`api_mobile_tokens`.`created_at`
`api_mobile_tokens`.`last_used_at`
`api_mobile_tokens`.`expires_at`
`api_mobile_tokens`.`revoked_at`
`app_rate_limits`.*
`app_rate_limits`.`id`
`app_rate_limits`.`scope`
`app_rate_limits`.`identifier_hash`
`app_rate_limits`.`identifier_label`
`app_rate_limits`.`window_started_at`
`app_rate_limits`.`attempts`
`app_rate_limits`.`blocked_until`
`app_rate_limits`.`last_attempt_at`
`app_rate_limits`.`created_at`
`app_rate_limits`.`updated_at`
`asset_accountability_form_items`.*
`asset_accountability_form_items`.`id`
`asset_accountability_form_items`.`form_id`
`asset_accountability_form_items`.`asset_id`
`asset_accountability_form_items`.`assignment_id`
`asset_accountability_form_items`.`asset_tag`
`asset_accountability_form_items`.`asset_snapshot`
`asset_accountability_form_items`.`created_at`
`asset_accountability_forms`.*
`asset_accountability_forms`.`id`
`asset_accountability_forms`.`form_control_no`
`asset_accountability_forms`.`employee_id`
`asset_accountability_forms`.`revision_no`
`asset_accountability_forms`.`status`
`asset_accountability_forms`.`generated_by`
`asset_accountability_forms`.`printed_by`
`asset_accountability_forms`.`printed_at`
`asset_accountability_forms`.`remarks`
`asset_accountability_forms`.`created_at`
`asset_accountability_forms`.`updated_at`
`asset_assignments`.*
`asset_assignments`.`id`
`asset_assignments`.`asset_id`
`asset_assignments`.`employee_id`
`asset_assignments`.`assigned_at`
`asset_assignments`.`expected_return_at`
`asset_assignments`.`condition_upon_issue`
`asset_assignments`.`accessories_included`
`asset_assignments`.`issued_by_user_id`
`asset_assignments`.`acknowledged_by`
`asset_assignments`.`returned_at`
`asset_assignments`.`return_condition`
`asset_assignments`.`assignment_notes`
`asset_assignments`.`received_by_user_id`
`asset_assignments`.`returned_to_user_id`
`asset_assignments`.`status`
`asset_assignments`.`clearance_status`
`asset_assignments`.`created_at`
`asset_audit_logs`.*
`asset_audit_logs`.`id`
`asset_audit_logs`.`asset_id`
`asset_audit_logs`.`action_type`
`asset_audit_logs`.`employee_id`
`asset_audit_logs`.`reference_table`
`asset_audit_logs`.`reference_id`
`asset_audit_logs`.`remarks`
`asset_audit_logs`.`performed_by`
`asset_audit_logs`.`created_at`
`asset_categories`.*
`asset_categories`.`id`
`asset_categories`.`category_name`
`asset_categories`.`description`
`asset_categories`.`asset_tag_prefix`
`asset_categories`.`is_active`
`asset_categories`.`created_at`
`asset_categories`.`updated_at`
`asset_label_print_logs`.*
`asset_label_print_logs`.`id`
`asset_label_print_logs`.`asset_id`
`asset_label_print_logs`.`template_id`
`asset_label_print_logs`.`label_type`
`asset_label_print_logs`.`reprint_reason`
`asset_label_print_logs`.`printer_used`
`asset_label_print_logs`.`printed_by`
`asset_label_print_logs`.`printed_at`
`asset_label_print_logs`.`ip_address`
`asset_label_print_logs`.`user_agent`
`asset_label_templates`.*
`asset_label_templates`.`id`
`asset_label_templates`.`template_name`
`asset_label_templates`.`label_size`
`asset_label_templates`.`width_mm`
`asset_label_templates`.`height_mm`
`asset_label_templates`.`include_brand_model`
`asset_label_templates`.`include_serial`
`asset_label_templates`.`include_qr`
`asset_label_templates`.`status`
`asset_label_templates`.`created_at`
`asset_label_templates`.`updated_at`
`asset_maintenance_logs`.*
`asset_maintenance_logs`.`id`
`asset_maintenance_logs`.`asset_id`
`asset_maintenance_logs`.`maintenance_date`
`asset_maintenance_logs`.`maintenance_type`
`asset_maintenance_logs`.`vendor_name`
`asset_maintenance_logs`.`cost`
`asset_maintenance_logs`.`details`
`asset_maintenance_logs`.`status`
`asset_maintenance_logs`.`performed_by_user_id`
`asset_maintenance_logs`.`resolved_at`
`asset_maintenance_logs`.`created_at`
`asset_print_logs`.*
`asset_print_logs`.`id`
`asset_print_logs`.`employee_id`
`asset_print_logs`.`asset_id`
`asset_print_logs`.`print_type`
`asset_print_logs`.`reference_id`
`asset_print_logs`.`label_type`
`asset_print_logs`.`assets_included`
`asset_print_logs`.`reprint_reason`
`asset_print_logs`.`printer_used`
`asset_print_logs`.`printed_by`
`asset_print_logs`.`printed_at`
`asset_print_logs`.`ip_address`
`asset_print_logs`.`user_agent`
`asset_transfers`.*
`asset_transfers`.`id`
`asset_transfers`.`asset_id`
`asset_transfers`.`from_employee_id`
`asset_transfers`.`to_employee_id`
`asset_transfers`.`from_location`
`asset_transfers`.`to_location`
`asset_transfers`.`transfer_date`
`asset_transfers`.`reason`
`asset_transfers`.`processed_by`
`asset_transfers`.`related_assignment_id`
`asset_transfers`.`created_at`
`assets`.*
`assets`.`id`
`assets`.`asset_tag`
`assets`.`asset_code`
`assets`.`asset_category_id`
`assets`.`item_name`
`assets`.`brand`
`assets`.`model`
`assets`.`serial_number`
`assets`.`imei_1`
`assets`.`imei_2`
`assets`.`sim_number`
`assets`.`mobile_number`
`assets`.`plan_type`
`assets`.`processor`
`assets`.`ram`
`assets`.`storage`
`assets`.`operating_system`
`assets`.`charger_serial_number`
`assets`.`accessories_included`
`assets`.`purchase_date`
`assets`.`supplier`
`assets`.`warranty_date`
`assets`.`asset_condition`
`assets`.`status`
`assets`.`assigned_employee_id`
`assets`.`location`
`assets`.`purchase_cost`
`assets`.`accountability_form_no`
`assets`.`notes`
`assets`.`asset_photo`
`assets`.`public_view_token`
`assets`.`created_by`
`assets`.`updated_by`
`assets`.`created_at`
`assets`.`updated_at`
`attendance_corrections`.*
`attendance_corrections`.`id`
`attendance_corrections`.`employee_id`
`attendance_corrections`.`attendance_id`
`attendance_corrections`.`attendance_date`
`attendance_corrections`.`requested_time_in`
`attendance_corrections`.`requested_time_out`
`attendance_corrections`.`reason`
`attendance_corrections`.`attachment`
`attendance_corrections`.`status`
`attendance_corrections`.`created_by`
`attendance_corrections`.`approved_by`
`attendance_corrections`.`approved_at`
`attendance_corrections`.`remarks`
`attendance_corrections`.`created_at`
`attendance_corrections`.`updated_at`
`attribute_value`.*
`attribute_value`.`id`
`attribute_value`.`value`
`attribute_value`.`attribute_parent_id`
`attributes`.*
`attributes`.`id`
`attributes`.`name`
`attributes`.`active`
`audit_logs`.*
`audit_logs`.`id`
`audit_logs`.`user_id`
`audit_logs`.`user_name`
`audit_logs`.`module`
`audit_logs`.`record_type`
`audit_logs`.`record_id`
`audit_logs`.`action`
`audit_logs`.`old_value`
`audit_logs`.`new_value`
`audit_logs`.`remarks`
`audit_logs`.`ip_address`
`audit_logs`.`user_agent`
`audit_logs`.`created_at`
`auth_access_logs`.*
`auth_access_logs`.`id`
`auth_access_logs`.`user_id`
`auth_access_logs`.`username`
`auth_access_logs`.`event_type`
`auth_access_logs`.`status`
`auth_access_logs`.`ip_address`
`auth_access_logs`.`ip_source`
`auth_access_logs`.`is_internal_ip`
`auth_access_logs`.`is_whitelisted_ip`
`auth_access_logs`.`network_label`
`auth_access_logs`.`user_agent`
`auth_access_logs`.`browser_name`
`auth_access_logs`.`platform`
`auth_access_logs`.`device_hash`
`auth_access_logs`.`session_id`
`auth_access_logs`.`request_uri`
`auth_access_logs`.`notes`
`auth_access_logs`.`metadata_text`
`auth_access_logs`.`created_at`
`brands`.*
`brands`.`id`
`brands`.`name`
`brands`.`active`
`categories`.*
`categories`.`id`
`categories`.`name`
`categories`.`active`
`clearance_items`.*
`clearance_items`.`id`
`clearance_items`.`offboarding_id`
`clearance_items`.`clearance_area`
`clearance_items`.`item_label`
`clearance_items`.`assigned_to`
`clearance_items`.`status`
`clearance_items`.`remarks`
`clearance_items`.`cleared_by`
`clearance_items`.`cleared_at`
`clearance_items`.`created_at`
`clearance_items`.`updated_at`
`company`.*
`company`.`id`
`company`.`company_name`
`company`.`service_charge_value`
`company`.`vat_charge_value`
`company`.`address`
`company`.`phone`
`company`.`payroll_funding_account`
`company`.`country`
`company`.`message`
`company`.`currency`
`deliveries`.*
`deliveries`.`id`
`deliveries`.`delivery_no`
`deliveries`.`supplier_name`
`deliveries`.`remarks`
`deliveries`.`created_at`
`deliveries`.`user_id`
`deliveries`.`status`
`deliveries`.`cancel_reason`
`deliveries`.`cancelled_at`
`deliveries`.`cancelled_by`
`deliveries`.`attachment_path`
`delivery_items`.*
`delivery_items`.`id`
`delivery_items`.`delivery_id`
`delivery_items`.`product_id`
`delivery_items`.`qty`
`departments`.*
`departments`.`id`
`departments`.`department_name`
`departments`.`department_code`
`departments`.`department_head_id`
`departments`.`status`
`departments`.`created_at`
`departments`.`updated_at`
`disciplinary_cases`.*
`disciplinary_cases`.`id`
`disciplinary_cases`.`employee_id`
`disciplinary_cases`.`case_type`
`disciplinary_cases`.`incident_date`
`disciplinary_cases`.`description`
`disciplinary_cases`.`attachment`
`disciplinary_cases`.`issued_by`
`disciplinary_cases`.`employee_response`
`disciplinary_cases`.`hr_remarks`
`disciplinary_cases`.`final_action`
`disciplinary_cases`.`acknowledgment_date`
`disciplinary_cases`.`status`
`disciplinary_cases`.`created_at`
`disciplinary_cases`.`updated_at`
`document_approval_logs`.*
`document_approval_logs`.`id`
`document_approval_logs`.`document_id`
`document_approval_logs`.`action`
`document_approval_logs`.`user_id`
`document_approval_logs`.`old_status`
`document_approval_logs`.`new_status`
`document_approval_logs`.`remarks`
`document_approval_logs`.`ip_address`
`document_approval_logs`.`user_agent`
`document_approval_logs`.`created_at`
`document_approval_remarks`.*
`document_approval_remarks`.`id`
`document_approval_remarks`.`document_id`
`document_approval_remarks`.`step_id`
`document_approval_remarks`.`user_id`
`document_approval_remarks`.`remarks_type`
`document_approval_remarks`.`remarks`
`document_approval_remarks`.`is_private`
`document_approval_remarks`.`page_number`
`document_approval_remarks`.`created_at`
`document_approval_signatures`.*
`document_approval_signatures`.`id`
`document_approval_signatures`.`document_id`
`document_approval_signatures`.`step_id`
`document_approval_signatures`.`approver_id`
`document_approval_signatures`.`signature_file_path`
`document_approval_signatures`.`page_number`
`document_approval_signatures`.`x_position`
`document_approval_signatures`.`y_position`
`document_approval_signatures`.`width`
`document_approval_signatures`.`height`
`document_approval_signatures`.`signed_at`
`document_approval_signatures`.`created_at`
`document_approval_steps`.*
`document_approval_steps`.`id`
`document_approval_steps`.`document_id`
`document_approval_steps`.`step_order`
`document_approval_steps`.`approver_id`
`document_approval_steps`.`approver_role`
`document_approval_steps`.`status`
`document_approval_steps`.`remarks`
`document_approval_steps`.`signature_required`
`document_approval_steps`.`signed_at`
`document_approval_steps`.`approved_at`
`document_approval_steps`.`returned_at`
`document_approval_steps`.`rejected_at`
`document_approval_steps`.`created_at`
`document_approval_steps`.`updated_at`
`document_approval_versions`.*
`document_approval_versions`.`id`
`document_approval_versions`.`document_id`
`document_approval_versions`.`version_number`
`document_approval_versions`.`version_type`
`document_approval_versions`.`filename`
`document_approval_versions`.`file_path`
`document_approval_versions`.`file_size`
`document_approval_versions`.`mime_type`
`document_approval_versions`.`uploaded_by`
`document_approval_versions`.`created_at`
`document_approvals`.*
`document_approvals`.`id`
`document_approvals`.`document_code`
`document_approvals`.`title`
`document_approvals`.`company`
`document_approvals`.`department_id`
`document_approvals`.`document_type_id`
`document_approvals`.`other_document_type`
`document_approvals`.`category`
`document_approvals`.`uploaded_by`
`document_approvals`.`current_approver_id`
`document_approvals`.`additional_reviewer_id`
`document_approvals`.`priority`
`document_approvals`.`due_date`
`document_approvals`.`original_filename`
`document_approvals`.`stored_filename`
`document_approvals`.`file_path`
`document_approvals`.`file_size`
`document_approvals`.`mime_type`
`document_approvals`.`is_confidential`
`document_approvals`.`status`
`document_approvals`.`remarks`
`document_approvals`.`submitted_at`
`document_approvals`.`approved_at`
`document_approvals`.`returned_at`
`document_approvals`.`rejected_at`
`document_approvals`.`archived_at`
`document_approvals`.`created_at`
`document_approvals`.`updated_at`
`document_department_users`.*
`document_department_users`.`id`
`document_department_users`.`department_id`
`document_department_users`.`user_id`
`document_department_users`.`can_upload`
`document_department_users`.`can_view_department`
`document_department_users`.`can_approve`
`document_department_users`.`can_view_confidential`
`document_department_users`.`can_view_private_remarks`
`document_department_users`.`status`
`document_department_users`.`created_at`
`document_department_users`.`updated_at`
`document_types`.*
`document_types`.`id`
`document_types`.`department_id`
`document_types`.`type_name`
`document_types`.`type_code`
`document_types`.`category`
`document_types`.`requires_signature`
`document_types`.`requires_approval`
`document_types`.`default_workflow_id`
`document_types`.`default_approver_id`
`document_types`.`allowed_file_types`
`document_types`.`max_file_size`
`document_types`.`status`
`document_types`.`created_at`
`document_types`.`updated_at`
`document_workflow_steps`.*
`document_workflow_steps`.`id`
`document_workflow_steps`.`workflow_id`
`document_workflow_steps`.`step_order`
`document_workflow_steps`.`approver_role`
`document_workflow_steps`.`approver_user_id`
`document_workflow_steps`.`require_signature`
`document_workflow_steps`.`require_remarks`
`document_workflow_steps`.`created_at`
`document_workflow_steps`.`updated_at`
`document_workflows`.*
`document_workflows`.`id`
`document_workflows`.`workflow_name`
`document_workflows`.`department_id`
`document_workflows`.`document_type_id`
`document_workflows`.`status`
`document_workflows`.`created_at`
`document_workflows`.`updated_at`
`employee_201_files`.*
`employee_201_files`.`id`
`employee_201_files`.`employee_id`
`employee_201_files`.`completion_percent`
`employee_201_files`.`status`
`employee_201_files`.`last_reviewed_by`
`employee_201_files`.`last_reviewed_at`
`employee_201_files`.`remarks`
`employee_201_files`.`created_at`
`employee_201_files`.`updated_at`
`employee_aliases`.*
`employee_aliases`.`id`
`employee_aliases`.`raw_name`
`employee_aliases`.`employee_id`
`employee_aliases`.`corrected_name`
`employee_aliases`.`created_at`
`employee_aliases`.`updated_at`
`employee_certifications`.*
`employee_certifications`.`id`
`employee_certifications`.`employee_id`
`employee_certifications`.`skill_name`
`employee_certifications`.`certification_name`
`employee_certifications`.`issuing_organization`
`employee_certifications`.`issue_date`
`employee_certifications`.`expiry_date`
`employee_certifications`.`attachment`
`employee_certifications`.`status`
`employee_certifications`.`created_at`
`employee_certifications`.`updated_at`
`employee_document_access_logs`.*
`employee_document_access_logs`.`id`
`employee_document_access_logs`.`document_id`
`employee_document_access_logs`.`employee_id`
`employee_document_access_logs`.`action_type`
`employee_document_access_logs`.`user_id`
`employee_document_access_logs`.`user_name`
`employee_document_access_logs`.`ip_address`
`employee_document_access_logs`.`user_agent`
`employee_document_access_logs`.`remarks`
`employee_document_access_logs`.`created_at`
`employee_document_types`.*
`employee_document_types`.`id`
`employee_document_types`.`section`
`employee_document_types`.`category`
`employee_document_types`.`document_name`
`employee_document_types`.`is_required`
`employee_document_types`.`requires_expiry`
`employee_document_types`.`sort_order`
`employee_document_types`.`status`
`employee_document_types`.`created_at`
`employee_document_types`.`updated_at`
`employee_document_versions`.*
`employee_document_versions`.`id`
`employee_document_versions`.`document_id`
`employee_document_versions`.`employee_id`
`employee_document_versions`.`version_no`
`employee_document_versions`.`document_type_id`
`employee_document_versions`.`category`
`employee_document_versions`.`section`
`employee_document_versions`.`document_title`
`employee_document_versions`.`original_filename`
`employee_document_versions`.`stored_filename`
`employee_document_versions`.`file_path`
`employee_document_versions`.`file_extension`
`employee_document_versions`.`mime_type`
`employee_document_versions`.`file_size`
`employee_document_versions`.`issue_date`
`employee_document_versions`.`expiry_date`
`employee_document_versions`.`is_required`
`employee_document_versions`.`is_confidential`
`employee_document_versions`.`remarks`
`employee_document_versions`.`replaced_by`
`employee_document_versions`.`replaced_at`
`employee_document_versions`.`created_at`
`employee_documents`.*
`employee_documents`.`id`
`employee_documents`.`employee_id`
`employee_documents`.`document_type_id`
`employee_documents`.`category`
`employee_documents`.`section`
`employee_documents`.`is_required`
`employee_documents`.`is_confidential`
`employee_documents`.`document_title`
`employee_documents`.`file_path`
`employee_documents`.`original_filename`
`employee_documents`.`stored_filename`
`employee_documents`.`file_extension`
`employee_documents`.`mime_type`
`employee_documents`.`file_size`
`employee_documents`.`issue_date`
`employee_documents`.`version_no`
`employee_documents`.`expiry_date`
`employee_documents`.`remarks`
`employee_documents`.`status`
`employee_documents`.`uploaded_by`
`employee_documents`.`last_updated_by`
`employee_documents`.`updated_by`
`employee_documents`.`replaced_document_id`
`employee_documents`.`archived_by`
`employee_documents`.`archived_at`
`employee_documents`.`created_at`
`employee_documents`.`updated_at`
`employee_education`.*
`employee_education`.`id`
`employee_education`.`employee_id`
`employee_education`.`school`
`employee_education`.`course`
`employee_education`.`year_graduated`
`employee_education`.`awards`
`employee_education`.`document_path`
`employee_education`.`status`
`employee_education`.`created_at`
`employee_education`.`updated_at`
`employee_employment_history`.*
`employee_employment_history`.`id`
`employee_employment_history`.`employee_id`
`employee_employment_history`.`previous_employer`
`employee_employment_history`.`position`
`employee_employment_history`.`start_date`
`employee_employment_history`.`end_date`
`employee_employment_history`.`reason_for_leaving`
`employee_employment_history`.`status`
`employee_employment_history`.`created_at`
`employee_employment_history`.`updated_at`
`employee_family_dependents`.*
`employee_family_dependents`.`id`
`employee_family_dependents`.`employee_id`
`employee_family_dependents`.`full_name`
`employee_family_dependents`.`relationship`
`employee_family_dependents`.`birthdate`
`employee_family_dependents`.`contact_no`
`employee_family_dependents`.`is_dependent`
`employee_family_dependents`.`status`
`employee_family_dependents`.`created_at`
`employee_family_dependents`.`updated_at`
`employee_medical_records`.*
`employee_medical_records`.`id`
`employee_medical_records`.`employee_id`
`employee_medical_records`.`medical_exam_date`
`employee_medical_records`.`fit_to_work_status`
`employee_medical_records`.`medical_expiry_date`
`employee_medical_records`.`certificate_path`
`employee_medical_records`.`remarks`
`employee_medical_records`.`status`
`employee_medical_records`.`created_at`
`employee_medical_records`.`updated_at`
`employee_movements`.*
`employee_movements`.`id`
`employee_movements`.`employee_id`
`employee_movements`.`movement_type`
`employee_movements`.`field_name`
`employee_movements`.`old_value`
`employee_movements`.`new_value`
`employee_movements`.`effective_date`
`employee_movements`.`reason`
`employee_movements`.`attachment`
`employee_movements`.`status`
`employee_movements`.`created_by`
`employee_movements`.`approved_by`
`employee_movements`.`approved_at`
`employee_movements`.`created_at`
`employee_movements`.`updated_at`
`employee_onboarding_items`.*
`employee_onboarding_items`.`id`
`employee_onboarding_items`.`employee_id`
`employee_onboarding_items`.`item_key`
`employee_onboarding_items`.`item_label`
`employee_onboarding_items`.`status`
`employee_onboarding_items`.`completed_by`
`employee_onboarding_items`.`completed_at`
`employee_onboarding_items`.`remarks`
`employee_onboarding_items`.`created_at`
`employee_onboarding_items`.`updated_at`
`employee_schedule_assignments`.*
`employee_schedule_assignments`.`id`
`employee_schedule_assignments`.`employee_id`
`employee_schedule_assignments`.`schedule_id`
`employee_schedule_assignments`.`effective_date`
`employee_schedule_assignments`.`end_date`
`employee_schedule_assignments`.`assigned_by`
`employee_schedule_assignments`.`remarks`
`employee_schedule_assignments`.`status`
`employee_schedule_assignments`.`created_at`
`employee_schedule_assignments`.`updated_at`
`expenses`.*
`expenses`.`id`
`expenses`.`transaction_id`
`expenses`.`expense_date`
`expenses`.`expense_type`
`expenses`.`vendor_name`
`expenses`.`amount`
`expenses`.`payment_status`
`expenses`.`related_inventory_reference`
`expenses`.`notes`
`expenses`.`created_by`
`expenses`.`updated_by`
`expenses`.`created_at`
`expenses`.`updated_at`
`groups`.*
`groups`.`id`
`groups`.`group_name`
`groups`.`permission`
`holidays`.*
`holidays`.`id`
`holidays`.`holiday_name`
`holidays`.`holiday_date`
`holidays`.`holiday_type`
`holidays`.`created_at`
`hr_attendance`.*
`hr_attendance`.`id`
`hr_attendance`.`employee_id`
`hr_attendance`.`cutoff_id`
`hr_attendance`.`schedule_id`
`hr_attendance`.`scheduled_start_at`
`hr_attendance`.`scheduled_end_at`
`hr_attendance`.`required_work_minutes`
`hr_attendance`.`break_minutes`
`hr_attendance`.`grace_period_minutes`
`hr_attendance`.`attendance_date`
`hr_attendance`.`time_in`
`hr_attendance`.`time_in_device_time`
`hr_attendance`.`time_in_server_time`
`hr_attendance`.`time_in_time_difference_seconds`
`hr_attendance`.`time_in_flagged_time_mismatch`
`hr_attendance`.`time_in_face_distance`
`hr_attendance`.`time_in_face_confidence`
`hr_attendance`.`time_in_face_source`
`hr_attendance`.`time_out`
`hr_attendance`.`time_out_device_time`
`hr_attendance`.`time_out_server_time`
`hr_attendance`.`time_out_time_difference_seconds`
`hr_attendance`.`time_out_flagged_time_mismatch`
`hr_attendance`.`time_out_face_distance`
`hr_attendance`.`time_out_face_confidence`
`hr_attendance`.`time_out_face_source`
`hr_attendance`.`latitude`
`hr_attendance`.`longitude`
`hr_attendance`.`photo`
`hr_attendance`.`time_in_latitude`
`hr_attendance`.`time_in_longitude`
`hr_attendance`.`time_in_photo`
`hr_attendance`.`time_out_latitude`
`hr_attendance`.`time_out_longitude`
`hr_attendance`.`time_out_photo`
`hr_attendance`.`hours_worked`
`hr_attendance`.`late_minutes`
`hr_attendance`.`undertime_minutes`
`hr_attendance`.`regular_work_minutes`
`hr_attendance`.`auto_overtime_hours`
`hr_attendance`.`rest_day_work`
`hr_attendance`.`rest_day_validated`
`hr_attendance`.`schedule_snapshot_json`
`hr_attendance`.`manual_overtime_hours`
`hr_attendance`.`manual_overtime_override`
`hr_attendance`.`status`
`hr_attendance`.`created_at`
`hr_attendance`.`updated_at`
`hr_attendance_edit_logs`.*
`hr_attendance_edit_logs`.`id`
`hr_attendance_edit_logs`.`attendance_id`
`hr_attendance_edit_logs`.`employee_id`
`hr_attendance_edit_logs`.`attendance_date`
`hr_attendance_edit_logs`.`old_time_in`
`hr_attendance_edit_logs`.`old_time_out`
`hr_attendance_edit_logs`.`new_time_in`
`hr_attendance_edit_logs`.`new_time_out`
`hr_attendance_edit_logs`.`old_hours_worked`
`hr_attendance_edit_logs`.`new_hours_worked`
`hr_attendance_edit_logs`.`edited_by`
`hr_attendance_edit_logs`.`ip_address`
`hr_attendance_edit_logs`.`user_agent`
`hr_attendance_edit_logs`.`edit_reason`
`hr_attendance_edit_logs`.`created_at`
`hr_attendance_time_security_logs`.*
`hr_attendance_time_security_logs`.`id`
`hr_attendance_time_security_logs`.`employee_id`
`hr_attendance_time_security_logs`.`action_key`
`hr_attendance_time_security_logs`.`source`
`hr_attendance_time_security_logs`.`device_time_raw`
`hr_attendance_time_security_logs`.`device_time`
`hr_attendance_time_security_logs`.`server_time`
`hr_attendance_time_security_logs`.`time_difference_seconds`
`hr_attendance_time_security_logs`.`threshold_seconds`
`hr_attendance_time_security_logs`.`flagged_time_mismatch`
`hr_attendance_time_security_logs`.`blocked`
`hr_attendance_time_security_logs`.`warning_message`
`hr_attendance_time_security_logs`.`ip_address`
`hr_attendance_time_security_logs`.`user_agent`
`hr_attendance_time_security_logs`.`extra_json`
`hr_attendance_time_security_logs`.`created_at`
`hr_checklist_items`.*
`hr_checklist_items`.`id`
`hr_checklist_items`.`checklist_id`
`hr_checklist_items`.`item_label`
`hr_checklist_items`.`assigned_to`
`hr_checklist_items`.`due_date`
`hr_checklist_items`.`status`
`hr_checklist_items`.`remarks`
`hr_checklist_items`.`attachment`
`hr_checklist_items`.`completed_by`
`hr_checklist_items`.`completed_at`
`hr_checklist_items`.`created_at`
`hr_checklist_items`.`updated_at`
`hr_checklists`.*
`hr_checklists`.`id`
`hr_checklists`.`employee_id`
`hr_checklists`.`checklist_type`
`hr_checklists`.`title`
`hr_checklists`.`status`
`hr_checklists`.`completion_percent`
`hr_checklists`.`created_by`
`hr_checklists`.`created_at`
`hr_checklists`.`updated_at`
`hr_employees`.*
`hr_employees`.`id`
`hr_employees`.`employee_code`
`hr_employees`.`bank_account_no`
`hr_employees`.`bank_account_name`
`hr_employees`.`payroll_account_status`
`hr_employees`.`bank_name`
`hr_employees`.`first_name`
`hr_employees`.`middle_name`
`hr_employees`.`last_name`
`hr_employees`.`suffix`
`hr_employees`.`nickname`
`hr_employees`.`position`
`hr_employees`.`job_title`
`hr_employees`.`branch_location`
`hr_employees`.`department`
`hr_employees`.`payroll_type`
`hr_employees`.`shift_id`
`hr_employees`.`rest_day`
`hr_employees`.`daily_rate`
`hr_employees`.`salary_type`
`hr_employees`.`monthly_salary`
`hr_employees`.`hourly_rate`
`hr_employees`.`date_hired`
`hr_employees`.`date_regularized`
`hr_employees`.`contract_start_date`
`hr_employees`.`contract_end_date`
`hr_employees`.`probationary_end_date`
`hr_employees`.`supervisor_id`
`hr_employees`.`birthdate`
`hr_employees`.`gender`
`hr_employees`.`civil_status`
`hr_employees`.`nationality`
`hr_employees`.`religion`
`hr_employees`.`contact_no`
`hr_employees`.`personal_email`
`hr_employees`.`emergency_contact_name`
`hr_employees`.`emergency_contact_no`
`hr_employees`.`emergency_relationship`
`hr_employees`.`emergency_contact_address`
`hr_employees`.`address`
`hr_employees`.`sss_no`
`hr_employees`.`philhealth_no`
`hr_employees`.`pagibig_no`
`hr_employees`.`tin_no`
`hr_employees`.`bir_tax_status`
`hr_employees`.`rdo_code`
`hr_employees`.`status`
`hr_employees`.`employment_status`
`hr_employees`.`active_flag`
`hr_employees`.`face_image`
`hr_employees`.`employee_photo`
`hr_employees`.`face_descriptor`
`hr_employees`.`created_at`
`hr_employees`.`updated_at`
`hr_payroll_batch_logs`.*
`hr_payroll_batch_logs`.`id`
`hr_payroll_batch_logs`.`batch_id`
`hr_payroll_batch_logs`.`week_start`
`hr_payroll_batch_logs`.`week_end`
`hr_payroll_batch_logs`.`from_status`
`hr_payroll_batch_logs`.`to_status`
`hr_payroll_batch_logs`.`action_by`
`hr_payroll_batch_logs`.`note`
`hr_payroll_batch_logs`.`created_at`
`hr_payroll_batches`.*
`hr_payroll_batches`.`id`
`hr_payroll_batches`.`week_start`
`hr_payroll_batches`.`week_end`
`hr_payroll_batches`.`payroll_type`
`hr_payroll_batches`.`status`
`hr_payroll_batches`.`reviewed_by`
`hr_payroll_batches`.`reviewed_at`
`hr_payroll_batches`.`approved_by`
`hr_payroll_batches`.`approved_at`
`hr_payroll_batches`.`released_by`
`hr_payroll_batches`.`released_at`
`hr_payroll_batches`.`locked_by`
`hr_payroll_batches`.`locked_at`
`hr_payroll_batches`.`is_finalized`
`hr_payroll_batches`.`is_locked`
`hr_payroll_batches`.`finalized_by`
`hr_payroll_batches`.`finalized_at`
`hr_payroll_batches`.`note`
`hr_payroll_batches`.`created_by`
`hr_payroll_batches`.`created_at`
`hr_payroll_batches`.`updated_at`
`hr_payrolls`.*
`hr_payrolls`.`id`
`hr_payrolls`.`employee_id`
`hr_payrolls`.`cutoff_id`
`hr_payrolls`.`week_start`
`hr_payrolls`.`week_end`
`hr_payrolls`.`days_worked`
`hr_payrolls`.`paid_leave_days`
`hr_payrolls`.`lwop_days`
`hr_payrolls`.`regular_holiday_worked`
`hr_payrolls`.`special_holiday_worked`
`hr_payrolls`.`rate_per_day`
`hr_payrolls`.`rate_per_min`
`hr_payrolls`.`late_ut_minutes`
`hr_payrolls`.`total_tardy`
`hr_payrolls`.`basic_pay`
`hr_payrolls`.`gross_pay`
`hr_payrolls`.`holiday_pay`
`hr_payrolls`.`leave_pay`
`hr_payrolls`.`overtime_pay`
`hr_payrolls`.`total_gp`
`hr_payrolls`.`cash_advance`
`hr_payrolls`.`sss_employee`
`hr_payrolls`.`philhealth_employee`
`hr_payrolls`.`pagibig_employee`
`hr_payrolls`.`withholding_tax`
`hr_payrolls`.`statutory_total`
`hr_payrolls`.`taxable_income`
`hr_payrolls`.`formula_version`
`hr_payrolls`.`payroll_breakdown_json`
`hr_payrolls`.`remarks`
`hr_payrolls`.`benefits`
`hr_payrolls`.`deductions`
`hr_payrolls`.`net_pay`
`hr_payrolls`.`adjustment`
`hr_payrolls`.`total_net`
`hr_payrolls`.`created_at`
`hr_payrolls`.`updated_at`
`hr_payrolls`.`regular_overtime_hours`
`hr_payrolls`.`regular_overtime_pay`
`hr_payrolls`.`holiday_overtime_hours`
`hr_payrolls`.`holiday_overtime_pay`
`hr_payrolls`.`approved_ot_hours`
`hr_payrolls`.`rest_day_hours`
`hr_payrolls`.`rest_day_pay`
`hr_payrolls`.`night_diff_hours`
`hr_payrolls`.`night_diff_pay`
`hr_payrolls`.`ob_hours`
`hr_shifts`.*
`hr_shifts`.`id`
`hr_shifts`.`work_schedule_id`
`hr_shifts`.`shift_code`
`hr_shifts`.`shift_name`
`hr_shifts`.`schedule_type`
`hr_shifts`.`start_time`
`hr_shifts`.`end_time`
`hr_shifts`.`break_minutes`
`hr_shifts`.`paid_hours`
`hr_shifts`.`late_grace_minutes`
`hr_shifts`.`is_active`
`hr_shifts`.`remarks`
`hr_shifts`.`created_at`
`hr_shifts`.`updated_at`
`hr_statutory_pagibig`.*
`hr_statutory_pagibig`.`id`
`hr_statutory_pagibig`.`effective_start`
`hr_statutory_pagibig`.`effective_end`
`hr_statutory_pagibig`.`monthly_salary_from`
`hr_statutory_pagibig`.`monthly_salary_to`
`hr_statutory_pagibig`.`employee_rate`
`hr_statutory_pagibig`.`max_employee_contribution`
`hr_statutory_pagibig`.`notes`
`hr_statutory_pagibig`.`created_at`
`hr_statutory_philhealth`.*
`hr_statutory_philhealth`.`id`
`hr_statutory_philhealth`.`effective_start`
`hr_statutory_philhealth`.`effective_end`
`hr_statutory_philhealth`.`premium_rate`
`hr_statutory_philhealth`.`monthly_salary_floor`
`hr_statutory_philhealth`.`monthly_salary_ceiling`
`hr_statutory_philhealth`.`employee_share_ratio`
`hr_statutory_philhealth`.`notes`
`hr_statutory_philhealth`.`created_at`
`hr_statutory_sss`.*
`hr_statutory_sss`.`id`
`hr_statutory_sss`.`effective_start`
`hr_statutory_sss`.`effective_end`
`hr_statutory_sss`.`monthly_salary_from`
`hr_statutory_sss`.`monthly_salary_to`
`hr_statutory_sss`.`employee_share`
`hr_statutory_sss`.`employer_share`
`hr_statutory_sss`.`ec_share`
`hr_statutory_sss`.`notes`
`hr_statutory_sss`.`created_at`
`hr_statutory_withholding`.*
`hr_statutory_withholding`.`id`
`hr_statutory_withholding`.`effective_start`
`hr_statutory_withholding`.`effective_end`
`hr_statutory_withholding`.`annual_taxable_from`
`hr_statutory_withholding`.`annual_taxable_to`
`hr_statutory_withholding`.`base_tax`
`hr_statutory_withholding`.`over_percent`
`hr_statutory_withholding`.`notes`
`hr_statutory_withholding`.`created_at`
`hr_thirteenth_month_batches`.*
`hr_thirteenth_month_batches`.`id`
`hr_thirteenth_month_batches`.`payout_year`
`hr_thirteenth_month_batches`.`status`
`hr_thirteenth_month_batches`.`note`
`hr_thirteenth_month_batches`.`generated_by`
`hr_thirteenth_month_batches`.`generated_at`
`hr_thirteenth_month_batches`.`released_by`
`hr_thirteenth_month_batches`.`released_at`
`hr_thirteenth_month_batches`.`created_at`
`hr_thirteenth_month_batches`.`updated_at`
`hr_thirteenth_month_rows`.*
`hr_thirteenth_month_rows`.`id`
`hr_thirteenth_month_rows`.`batch_id`
`hr_thirteenth_month_rows`.`employee_id`
`hr_thirteenth_month_rows`.`payout_year`
`hr_thirteenth_month_rows`.`coverage_start`
`hr_thirteenth_month_rows`.`coverage_end`
`hr_thirteenth_month_rows`.`payroll_rows_count`
`hr_thirteenth_month_rows`.`qualifying_days`
`hr_thirteenth_month_rows`.`basic_salary_base`
`hr_thirteenth_month_rows`.`thirteenth_month_pay`
`hr_thirteenth_month_rows`.`taxable_excess`
`hr_thirteenth_month_rows`.`withholding_tax`
`hr_thirteenth_month_rows`.`net_amount`
`hr_thirteenth_month_rows`.`remarks`
`hr_thirteenth_month_rows`.`created_at`
`hr_thirteenth_month_rows`.`updated_at`
`leave_balances`.*
`leave_balances`.`id`
`leave_balances`.`employee_id`
`leave_balances`.`leave_type_id`
`leave_balances`.`year`
`leave_balances`.`allocated_days`
`leave_balances`.`used_days`
`leave_balances`.`created_at`
`leave_balances`.`updated_at`
`leave_request_audit_logs`.*
`leave_request_audit_logs`.`id`
`leave_request_audit_logs`.`leave_request_id`
`leave_request_audit_logs`.`action`
`leave_request_audit_logs`.`from_status`
`leave_request_audit_logs`.`to_status`
`leave_request_audit_logs`.`acted_by`
`leave_request_audit_logs`.`remarks`
`leave_request_audit_logs`.`ip_address`
`leave_request_audit_logs`.`user_agent`
`leave_request_audit_logs`.`created_at`
`leave_requests`.*
`leave_requests`.`id`
`leave_requests`.`employee_id`
`leave_requests`.`leave_type_id`
`leave_requests`.`start_date`
`leave_requests`.`end_date`
`leave_requests`.`total_days`
`leave_requests`.`reason`
`leave_requests`.`attachment`
`leave_requests`.`status`
`leave_requests`.`approved_by`
`leave_requests`.`approved_date`
`leave_requests`.`remarks`
`leave_requests`.`balance_applied`
`leave_requests`.`created_at`
`leave_types`.*
`leave_types`.`id`
`leave_types`.`leave_name`
`leave_types`.`description`
`leave_types`.`is_paid`
`leave_types`.`default_days`
`logistics_audit_logs`.*
`logistics_audit_logs`.`id`
`logistics_audit_logs`.`module`
`logistics_audit_logs`.`record_id`
`logistics_audit_logs`.`action`
`logistics_audit_logs`.`old_value`
`logistics_audit_logs`.`new_value`
`logistics_audit_logs`.`remarks`
`logistics_audit_logs`.`created_by`
`logistics_audit_logs`.`created_at`
`logistics_billing`.*
`logistics_billing`.`id`
`logistics_billing`.`invoice_no`
`logistics_billing`.`client_id`
`logistics_billing`.`shipment_id`
`logistics_billing`.`dispatch_id`
`logistics_billing`.`billing_type`
`logistics_billing`.`income_amount`
`logistics_billing`.`expense_amount`
`logistics_billing`.`billing_status`
`logistics_billing`.`due_date`
`logistics_billing`.`notes`
`logistics_billing`.`posted_to_accounting`
`logistics_billing`.`accounting_reference`
`logistics_billing`.`created_by`
`logistics_billing`.`updated_by`
`logistics_billing`.`created_at`
`logistics_billing`.`updated_at`
`logistics_clients`.*
`logistics_clients`.`id`
`logistics_clients`.`client_code`
`logistics_clients`.`company_name`
`logistics_clients`.`contact_person`
`logistics_clients`.`contact_number`
`logistics_clients`.`email`
`logistics_clients`.`address`
`logistics_clients`.`status`
`logistics_clients`.`created_by`
`logistics_clients`.`updated_by`
`logistics_clients`.`created_at`
`logistics_clients`.`updated_at`
`logistics_consolidation_batches`.*
`logistics_consolidation_batches`.`id`
`logistics_consolidation_batches`.`batch_no`
`logistics_consolidation_batches`.`batch_name`
`logistics_consolidation_batches`.`status`
`logistics_consolidation_batches`.`dispatch_ref_no`
`logistics_consolidation_batches`.`remarks`
`logistics_consolidation_batches`.`created_by`
`logistics_consolidation_batches`.`updated_by`
`logistics_consolidation_batches`.`created_at`
`logistics_consolidation_batches`.`updated_at`
`logistics_consolidation_items`.*
`logistics_consolidation_items`.`id`
`logistics_consolidation_items`.`batch_id`
`logistics_consolidation_items`.`shipment_id`
`logistics_consolidation_items`.`created_at`
`logistics_customs_clearances`.*
`logistics_customs_clearances`.`id`
`logistics_customs_clearances`.`shipment_id`
`logistics_customs_clearances`.`customs_status`
`logistics_customs_clearances`.`document_checklist`
`logistics_customs_clearances`.`remarks`
`logistics_customs_clearances`.`created_by`
`logistics_customs_clearances`.`updated_by`
`logistics_customs_clearances`.`created_at`
`logistics_customs_clearances`.`updated_at`
`logistics_customs_logs`.*
`logistics_customs_logs`.`id`
`logistics_customs_logs`.`clearance_id`
`logistics_customs_logs`.`shipment_id`
`logistics_customs_logs`.`old_status`
`logistics_customs_logs`.`new_status`
`logistics_customs_logs`.`remarks`
`logistics_customs_logs`.`updated_by`
`logistics_customs_logs`.`created_at`
`logistics_dispatches`.*
`logistics_dispatches`.`id`
`logistics_dispatches`.`dispatch_no`
`logistics_dispatches`.`batch_id`
`logistics_dispatches`.`shipment_id`
`logistics_dispatches`.`delivery_schedule`
`logistics_dispatches`.`truck_id`
`logistics_dispatches`.`driver_employee_id`
`logistics_dispatches`.`pickup_location`
`logistics_dispatches`.`delivery_address`
`logistics_dispatches`.`delivery_status`
`logistics_dispatches`.`proof_of_delivery`
`logistics_dispatches`.`delivery_photo`
`logistics_dispatches`.`signature_image`
`logistics_dispatches`.`remarks`
`logistics_dispatches`.`created_by`
`logistics_dispatches`.`updated_by`
`logistics_dispatches`.`created_at`
`logistics_dispatches`.`updated_at`
`logistics_shipments`.*
`logistics_shipments`.`id`
`logistics_shipments`.`shipment_ref_no`
`logistics_shipments`.`client_id`
`logistics_shipments`.`transaction_type`
`logistics_shipments`.`container_no`
`logistics_shipments`.`bl_awb_no`
`logistics_shipments`.`cargo_description`
`logistics_shipments`.`quantity`
`logistics_shipments`.`weight_kg`
`logistics_shipments`.`cbm`
`logistics_shipments`.`date_received`
`logistics_shipments`.`warehouse_location`
`logistics_shipments`.`current_status`
`logistics_shipments`.`remarks`
`logistics_shipments`.`created_by`
`logistics_shipments`.`updated_by`
`logistics_shipments`.`created_at`
`logistics_shipments`.`updated_at`
`logistics_warehouse_movements`.*
`logistics_warehouse_movements`.`id`
`logistics_warehouse_movements`.`shipment_id`
`logistics_warehouse_movements`.`movement_type`
`logistics_warehouse_movements`.`from_location`
`logistics_warehouse_movements`.`to_location`
`logistics_warehouse_movements`.`status_from`
`logistics_warehouse_movements`.`status_to`
`logistics_warehouse_movements`.`remarks`
`logistics_warehouse_movements`.`moved_by`
`logistics_warehouse_movements`.`created_at`
`mobile_push_tokens`.*
`mobile_push_tokens`.`id`
`mobile_push_tokens`.`user_id`
`mobile_push_tokens`.`employee_id`
`mobile_push_tokens`.`expo_push_token`
`mobile_push_tokens`.`platform`
`mobile_push_tokens`.`device_name`
`mobile_push_tokens`.`app_mode`
`mobile_push_tokens`.`is_active`
`mobile_push_tokens`.`last_seen_at`
`mobile_push_tokens`.`created_at`
`mobile_push_tokens`.`updated_at`
`offboarding_records`.*
`offboarding_records`.`id`
`offboarding_records`.`employee_id`
`offboarding_records`.`trigger_type`
`offboarding_records`.`resignation_date`
`offboarding_records`.`last_working_day`
`offboarding_records`.`reason`
`offboarding_records`.`final_pay_request_status`
`offboarding_records`.`status`
`offboarding_records`.`created_by`
`offboarding_records`.`created_at`
`offboarding_records`.`updated_at`
`official_business_requests`.*
`official_business_requests`.`id`
`official_business_requests`.`employee_id`
`official_business_requests`.`ob_date`
`official_business_requests`.`start_time`
`official_business_requests`.`end_time`
`official_business_requests`.`location`
`official_business_requests`.`client_company`
`official_business_requests`.`purpose`
`official_business_requests`.`attachment`
`official_business_requests`.`credited_hours`
`official_business_requests`.`status`
`official_business_requests`.`supervisor_by`
`official_business_requests`.`supervisor_at`
`official_business_requests`.`approved_by`
`official_business_requests`.`approved_at`
`official_business_requests`.`remarks`
`official_business_requests`.`created_by`
`official_business_requests`.`created_at`
`official_business_requests`.`updated_at`
`order_deliveries`.*
`order_deliveries`.`id`
`order_deliveries`.`allocation_no`
`order_deliveries`.`order_id`
`order_deliveries`.`truck_id`
`order_deliveries`.`scheduled_date`
`order_deliveries`.`route_sequence`
`order_deliveries`.`payment_mode`
`order_deliveries`.`cash_to_collect`
`order_deliveries`.`pickup_location`
`order_deliveries`.`dropoff_location`
`order_deliveries`.`trip_type`
`order_deliveries`.`route_profile`
`order_deliveries`.`estimated_one_way_distance_km`
`order_deliveries`.`estimated_total_distance_km`
`order_deliveries`.`estimated_cargo_weight_kg`
`order_deliveries`.`load_utilization_percent`
`order_deliveries`.`truck_km_per_liter`
`order_deliveries`.`recommended_km_per_liter`
`order_deliveries`.`diesel_price_per_liter`
`order_deliveries`.`cost_per_km`
`order_deliveries`.`estimated_fuel_liters`
`order_deliveries`.`estimated_fuel_cost`
`order_deliveries`.`actual_start_odometer`
`order_deliveries`.`actual_end_odometer`
`order_deliveries`.`actual_distance_km`
`order_deliveries`.`actual_fuel_liters`
`order_deliveries`.`actual_km_per_liter`
`order_deliveries`.`actual_fuel_cost`
`order_deliveries`.`fuel_variance`
`order_deliveries`.`distance_variance`
`order_deliveries`.`status`
`order_deliveries`.`notes`
`order_deliveries`.`cancel_reason`
`order_deliveries`.`canceled_at`
`order_deliveries`.`canceled_by`
`order_deliveries`.`proof_path`
`order_deliveries`.`user_id`
`order_deliveries`.`created_at`
`order_delivery_expenses`.*
`order_delivery_expenses`.`id`
`order_delivery_expenses`.`order_delivery_id`
`order_delivery_expenses`.`expense_name`
`order_delivery_expenses`.`amount`
`order_delivery_expenses`.`created_at`
`order_delivery_item_returns`.*
`order_delivery_item_returns`.`id`
`order_delivery_item_returns`.`order_delivery_id`
`order_delivery_item_returns`.`order_delivery_item_id`
`order_delivery_item_returns`.`product_id`
`order_delivery_item_returns`.`qty_returned`
`order_delivery_item_returns`.`reason`
`order_delivery_item_returns`.`returned_by`
`order_delivery_item_returns`.`returned_at`
`order_delivery_items`.*
`order_delivery_items`.`id`
`order_delivery_items`.`order_delivery_id`
`order_delivery_items`.`order_item_id`
`order_delivery_items`.`product_id`
`order_delivery_items`.`qty_allocated`
`order_delivery_itinerary`.*
`order_delivery_itinerary`.`id`
`order_delivery_itinerary`.`order_delivery_id`
`order_delivery_itinerary`.`stop_no`
`order_delivery_itinerary`.`stop_name`
`order_delivery_itinerary`.`created_at`
`order_delivery_status_logs`.*
`order_delivery_status_logs`.`id`
`order_delivery_status_logs`.`order_delivery_id`
`order_delivery_status_logs`.`from_status`
`order_delivery_status_logs`.`to_status`
`order_delivery_status_logs`.`note`
`order_delivery_status_logs`.`changed_by`
`order_delivery_status_logs`.`changed_at`
`orders`.*
`orders`.`id`
`orders`.`bill_no`
`orders`.`company_name`
`orders`.`customer_name`
`orders`.`customer_address`
`orders`.`customer_phone`
`orders`.`delivery_date`
`orders`.`delivery_type`
`orders`.`date_time`
`orders`.`gross_amount`
`orders`.`service_charge_rate`
`orders`.`service_charge`
`orders`.`vat_charge_rate`
`orders`.`vat_charge`
`orders`.`tax_inclusive`
`orders`.`tax_exclusive`
`orders`.`net_amount`
`orders`.`deliveryfee`
`orders`.`discount`
`orders`.`paid_status`
`orders`.`return_note`
`orders`.`payment_proof`
`orders`.`modeofpayment`
`orders`.`record_type`
`orders`.`approval_status`
`orders`.`approved_at`
`orders`.`approved_by`
`orders`.`source_quotation_id`
`orders`.`quotation_valid_until`
`orders`.`user_id`
`orders`.`created_at`
`orders_item`.*
`orders_item`.`id`
`orders_item`.`order_id`
`orders_item`.`product_id`
`orders_item`.`product_name`
`orders_item`.`qty`
`orders_item`.`rate`
`orders_item`.`amount`
`overtime_requests`.*
`overtime_requests`.`id`
`overtime_requests`.`employee_id`
`overtime_requests`.`ot_date`
`overtime_requests`.`start_time`
`overtime_requests`.`end_time`
`overtime_requests`.`reason`
`overtime_requests`.`attachment`
`overtime_requests`.`requested_hours`
`overtime_requests`.`approved_hours`
`overtime_requests`.`payable_hours`
`overtime_requests`.`is_pre_shift`
`overtime_requests`.`status`
`overtime_requests`.`supervisor_by`
`overtime_requests`.`supervisor_at`
`overtime_requests`.`approved_by`
`overtime_requests`.`approved_at`
`overtime_requests`.`remarks`
`overtime_requests`.`created_by`
`overtime_requests`.`created_at`
`overtime_requests`.`updated_at`
`payables`.*
`payables`.`id`
`payables`.`supplier_name`
`payables`.`reference_no`
`payables`.`delivery_id`
`payables`.`due_date`
`payables`.`amount`
`payables`.`balance`
`payables`.`status`
`payables`.`notes`
`payables`.`created_by`
`payables`.`updated_by`
`payables`.`created_at`
`payables`.`updated_at`
`payments`.*
`payments`.`id`
`payments`.`payment_no`
`payments`.`payment_date`
`payments`.`direction`
`payments`.`payer_type`
`payments`.`payer_name`
`payments`.`reference_type`
`payments`.`reference_id`
`payments`.`cash_account_id`
`payments`.`counter_account_id`
`payments`.`amount`
`payments`.`payment_method`
`payments`.`reference_no`
`payments`.`notes`
`payments`.`transaction_id`
`payments`.`created_by`
`payments`.`updated_by`
`payments`.`created_at`
`payments`.`updated_at`
`payroll_activity_logs`.*
`payroll_activity_logs`.`id`
`payroll_activity_logs`.`cutoff_id`
`payroll_activity_logs`.`record_type`
`payroll_activity_logs`.`record_id`
`payroll_activity_logs`.`action`
`payroll_activity_logs`.`user_id`
`payroll_activity_logs`.`details_json`
`payroll_activity_logs`.`created_at`
`payroll_adjustments`.*
`payroll_adjustments`.`id`
`payroll_adjustments`.`payroll_id`
`payroll_adjustments`.`cutoff_id`
`payroll_adjustments`.`employee_id`
`payroll_adjustments`.`adjustment_type`
`payroll_adjustments`.`amount`
`payroll_adjustments`.`reason`
`payroll_adjustments`.`status`
`payroll_adjustments`.`created_by`
`payroll_adjustments`.`approved_by`
`payroll_adjustments`.`approved_at`
`payroll_adjustments`.`created_at`
`payroll_adjustments`.`updated_at`
`payroll_details`.*
`payroll_details`.`id`
`payroll_details`.`payroll_id`
`payroll_details`.`detail_type`
`payroll_details`.`label`
`payroll_details`.`quantity`
`payroll_details`.`rate`
`payroll_details`.`amount`
`payroll_details`.`metadata_json`
`payroll_details`.`created_at`
`payroll_office_entries`.*
`payroll_office_entries`.`id`
`payroll_office_entries`.`cutoff_id`
`payroll_office_entries`.`employee_id`
`payroll_office_entries`.`daily_rate`
`payroll_office_entries`.`paid_days`
`payroll_office_entries`.`late_undertime_deduction`
`payroll_office_entries`.`overtime`
`payroll_office_entries`.`allowance`
`payroll_office_entries`.`incentive`
`payroll_office_entries`.`deduction`
`payroll_office_entries`.`remarks`
`payroll_office_entries`.`encoded_by`
`payroll_office_entries`.`created_at`
`payroll_office_entries`.`updated_at`
`payroll_settings`.*
`payroll_settings`.`id`
`payroll_settings`.`setting_key`
`payroll_settings`.`setting_value`
`payroll_settings`.`value_type`
`payroll_settings`.`effective_start`
`payroll_settings`.`effective_end`
`payroll_settings`.`description`
`payroll_settings`.`updated_by`
`payroll_settings`.`created_at`
`payroll_settings`.`updated_at`
`payroll_trip_entries`.*
`payroll_trip_entries`.`id`
`payroll_trip_entries`.`cutoff_id`
`payroll_trip_entries`.`employee_id`
`payroll_trip_entries`.`raw_name`
`payroll_trip_entries`.`corrected_name`
`payroll_trip_entries`.`position`
`payroll_trip_entries`.`truck_number`
`payroll_trip_entries`.`container_number`
`payroll_trip_entries`.`area_destination`
`payroll_trip_entries`.`rate`
`payroll_trip_entries`.`entry_type`
`payroll_trip_entries`.`remarks`
`payroll_trip_entries`.`encoded_by`
`payroll_trip_entries`.`created_at`
`payroll_trip_entries`.`updated_at`
`payroll_trip_rates`.*
`payroll_trip_rates`.`id`
`payroll_trip_rates`.`destination_area`
`payroll_trip_rates`.`truck_type`
`payroll_trip_rates`.`km`
`payroll_trip_rates`.`customer`
`payroll_trip_rates`.`standard_trip_rate`
`payroll_trip_rates`.`driver_rate_type`
`payroll_trip_rates`.`driver_rate_value`
`payroll_trip_rates`.`helper_rate_type`
`payroll_trip_rates`.`helper_rate_value`
`payroll_trip_rates`.`checker_rate_type`
`payroll_trip_rates`.`checker_rate_value`
`payroll_trip_rates`.`food_allowance`
`payroll_trip_rates`.`toll_other_expense`
`payroll_trip_rates`.`status`
`payroll_trip_rates`.`created_at`
`payroll_trip_rates`.`updated_at`
`payslips`.*
`payslips`.`id`
`payslips`.`payroll_id`
`payslips`.`employee_id`
`payslips`.`cutoff_id`
`payslips`.`token_hash`
`payslips`.`generated_by`
`payslips`.`generated_at`
`payslips`.`viewed_at`
`payslips`.`status`
`performance_evaluations`.*
`performance_evaluations`.`id`
`performance_evaluations`.`employee_id`
`performance_evaluations`.`evaluation_type`
`performance_evaluations`.`period_start`
`performance_evaluations`.`period_end`
`performance_evaluations`.`evaluator_id`
`performance_evaluations`.`final_score`
`performance_evaluations`.`comments`
`performance_evaluations`.`strengths`
`performance_evaluations`.`areas_for_improvement`
`performance_evaluations`.`recommendation`
`performance_evaluations`.`attachment`
`performance_evaluations`.`status`
`performance_evaluations`.`created_at`
`performance_evaluations`.`updated_at`
`product_history`.*
`product_history`.`id`
`product_history`.`product_id`
`product_history`.`user_id`
`product_history`.`before_data`
`product_history`.`after_data`
`product_history`.`created_at`
`product_history`.`action`
`product_history`.`reference`
`product_history`.`qty_change`
`products`.*
`products`.`id`
`products`.`name`
`products`.`sku`
`products`.`price`
`products`.`qty`
`products`.`image`
`products`.`description`
`products`.`attribute_value_id`
`products`.`brand_id`
`products`.`category_id`
`products`.`store_id`
`products`.`availability`
`products`.`kilogram`
`products`.`unit_item`
`products`.`dealerprice`
`products`.`pricing_type`
`products`.`dealer_price_per_kg`
`profile_update_requests`.*
`profile_update_requests`.`id`
`profile_update_requests`.`employee_id`
`profile_update_requests`.`field_name`
`profile_update_requests`.`old_value`
`profile_update_requests`.`new_value`
`profile_update_requests`.`proof_attachment`
`profile_update_requests`.`reason`
`profile_update_requests`.`status`
`profile_update_requests`.`created_by`
`profile_update_requests`.`reviewed_by`
`profile_update_requests`.`reviewed_at`
`profile_update_requests`.`remarks`
`profile_update_requests`.`created_at`
`profile_update_requests`.`updated_at`
`receivables`.*
`receivables`.`id`
`receivables`.`customer_name`
`receivables`.`reference_no`
`receivables`.`order_id`
`receivables`.`due_date`
`receivables`.`amount`
`receivables`.`balance`
`receivables`.`status`
`receivables`.`notes`
`receivables`.`created_by`
`receivables`.`updated_by`
`receivables`.`created_at`
`receivables`.`updated_at`
`recruitment_applicant_documents`.*
`recruitment_applicant_documents`.`id`
`recruitment_applicant_documents`.`applicant_id`
`recruitment_applicant_documents`.`document_type`
`recruitment_applicant_documents`.`title`
`recruitment_applicant_documents`.`original_filename`
`recruitment_applicant_documents`.`stored_filename`
`recruitment_applicant_documents`.`file_path`
`recruitment_applicant_documents`.`file_extension`
`recruitment_applicant_documents`.`mime_type`
`recruitment_applicant_documents`.`file_size`
`recruitment_applicant_documents`.`status`
`recruitment_applicant_documents`.`uploaded_by`
`recruitment_applicant_documents`.`created_at`
`recruitment_applicant_documents`.`updated_at`
`recruitment_applicants`.*
`recruitment_applicants`.`id`
`recruitment_applicants`.`applicant_code`
`recruitment_applicants`.`first_name`
`recruitment_applicants`.`middle_name`
`recruitment_applicants`.`last_name`
`recruitment_applicants`.`suffix`
`recruitment_applicants`.`birthdate`
`recruitment_applicants`.`gender`
`recruitment_applicants`.`civil_status`
`recruitment_applicants`.`contact_number`
`recruitment_applicants`.`email`
`recruitment_applicants`.`address`
`recruitment_applicants`.`position_id`
`recruitment_applicants`.`preferred_company`
`recruitment_applicants`.`expected_salary`
`recruitment_applicants`.`availability_date`
`recruitment_applicants`.`employment_history`
`recruitment_applicants`.`educational_background`
`recruitment_applicants`.`skills`
`recruitment_applicants`.`certifications`
`recruitment_applicants`.`driver_license_details`
`recruitment_applicants`.`work_experience`
`recruitment_applicants`.`referral_source`
`recruitment_applicants`.`remarks`
`recruitment_applicants`.`status`
`recruitment_applicants`.`consent_accepted`
`recruitment_applicants`.`consent_accepted_at`
`recruitment_applicants`.`consent_ip`
`recruitment_applicants`.`consent_version`
`recruitment_applicants`.`converted_employee_id`
`recruitment_applicants`.`created_at`
`recruitment_applicants`.`updated_at`
`recruitment_consent_logs`.*
`recruitment_consent_logs`.`id`
`recruitment_consent_logs`.`applicant_id`
`recruitment_consent_logs`.`interview_session_id`
`recruitment_consent_logs`.`consent_type`
`recruitment_consent_logs`.`consent_version`
`recruitment_consent_logs`.`consent_text`
`recruitment_consent_logs`.`ip_address`
`recruitment_consent_logs`.`user_agent`
`recruitment_consent_logs`.`accepted_at`
`recruitment_email_logs`.*
`recruitment_email_logs`.`id`
`recruitment_email_logs`.`applicant_id`
`recruitment_email_logs`.`email_type`
`recruitment_email_logs`.`recipient_email`
`recruitment_email_logs`.`subject`
`recruitment_email_logs`.`body_snapshot`
`recruitment_email_logs`.`status`
`recruitment_email_logs`.`error_message`
`recruitment_email_logs`.`sent_by`
`recruitment_email_logs`.`sent_at`
`recruitment_email_logs`.`created_at`
`recruitment_email_templates`.*
`recruitment_email_templates`.`id`
`recruitment_email_templates`.`template_name`
`recruitment_email_templates`.`stage`
`recruitment_email_templates`.`subject`
`recruitment_email_templates`.`body`
`recruitment_email_templates`.`status`
`recruitment_email_templates`.`created_by`
`recruitment_email_templates`.`updated_by`
`recruitment_email_templates`.`created_at`
`recruitment_email_templates`.`updated_at`
`recruitment_final_interviews`.*
`recruitment_final_interviews`.`id`
`recruitment_final_interviews`.`applicant_id`
`recruitment_final_interviews`.`interview_date`
`recruitment_final_interviews`.`interview_time`
`recruitment_final_interviews`.`interview_type`
`recruitment_final_interviews`.`location_or_link`
`recruitment_final_interviews`.`interviewer_id`
`recruitment_final_interviews`.`remarks`
`recruitment_final_interviews`.`status`
`recruitment_final_interviews`.`created_by`
`recruitment_final_interviews`.`created_at`
`recruitment_final_interviews`.`updated_at`
`recruitment_interview_event_logs`.*
`recruitment_interview_event_logs`.`id`
`recruitment_interview_event_logs`.`interview_session_id`
`recruitment_interview_event_logs`.`applicant_id`
`recruitment_interview_event_logs`.`question_id`
`recruitment_interview_event_logs`.`event_type`
`recruitment_interview_event_logs`.`event_time`
`recruitment_interview_event_logs`.`duration_seconds`
`recruitment_interview_event_logs`.`metadata`
`recruitment_interview_event_logs`.`ip_address`
`recruitment_interview_event_logs`.`user_agent`
`recruitment_interview_event_logs`.`created_at`
`recruitment_interview_integrity_summary`.*
`recruitment_interview_integrity_summary`.`id`
`recruitment_interview_integrity_summary`.`interview_session_id`
`recruitment_interview_integrity_summary`.`applicant_id`
`recruitment_interview_integrity_summary`.`tab_switch_count`
`recruitment_interview_integrity_summary`.`total_away_seconds`
`recruitment_interview_integrity_summary`.`fullscreen_exit_count`
`recruitment_interview_integrity_summary`.`copy_attempt_count`
`recruitment_interview_integrity_summary`.`right_click_attempt_count`
`recruitment_interview_integrity_summary`.`suspicious_key_count`
`recruitment_interview_integrity_summary`.`device_interruption_count`
`recruitment_interview_integrity_summary`.`duplicate_session_count`
`recruitment_interview_integrity_summary`.`early_stop_count`
`recruitment_interview_integrity_summary`.`too_short_answer_count`
`recruitment_interview_integrity_summary`.`failed_upload_count`
`recruitment_interview_integrity_summary`.`invalid_step_count`
`recruitment_interview_integrity_summary`.`no_face_count`
`recruitment_interview_integrity_summary`.`multiple_face_count`
`recruitment_interview_integrity_summary`.`risk_score`
`recruitment_interview_integrity_summary`.`risk_level`
`recruitment_interview_integrity_summary`.`hr_review_status`
`recruitment_interview_integrity_summary`.`hr_integrity_remarks`
`recruitment_interview_integrity_summary`.`first_ip_address`
`recruitment_interview_integrity_summary`.`last_ip_address`
`recruitment_interview_integrity_summary`.`first_user_agent`
`recruitment_interview_integrity_summary`.`last_user_agent`
`recruitment_interview_integrity_summary`.`browser_name`
`recruitment_interview_integrity_summary`.`operating_system`
`recruitment_interview_integrity_summary`.`device_type`
`recruitment_interview_integrity_summary`.`screen_size`
`recruitment_interview_integrity_summary`.`timezone`
`recruitment_interview_integrity_summary`.`started_at`
`recruitment_interview_integrity_summary`.`completed_at`
`recruitment_interview_integrity_summary`.`created_at`
`recruitment_interview_integrity_summary`.`updated_at`
`recruitment_interview_progress`.*
`recruitment_interview_progress`.`id`
`recruitment_interview_progress`.`interview_session_id`
`recruitment_interview_progress`.`applicant_id`
`recruitment_interview_progress`.`current_question_id`
`recruitment_interview_progress`.`current_question_order`
`recruitment_interview_progress`.`completed_questions_count`
`recruitment_interview_progress`.`status`
`recruitment_interview_progress`.`current_step`
`recruitment_interview_progress`.`current_question_started_at`
`recruitment_interview_progress`.`recording_state`
`recruitment_interview_progress`.`last_activity_at`
`recruitment_interview_progress`.`updated_at`
`recruitment_interview_sessions`.*
`recruitment_interview_sessions`.`id`
`recruitment_interview_sessions`.`applicant_id`
`recruitment_interview_sessions`.`position_id`
`recruitment_interview_sessions`.`token`
`recruitment_interview_sessions`.`token_expires_at`
`recruitment_interview_sessions`.`status`
`recruitment_interview_sessions`.`expires_at`
`recruitment_interview_sessions`.`allow_retake`
`recruitment_interview_sessions`.`retakes_allowed`
`recruitment_interview_sessions`.`allow_preview`
`recruitment_interview_sessions`.`require_all_questions`
`recruitment_interview_sessions`.`consent_accepted`
`recruitment_interview_sessions`.`consent_accepted_at`
`recruitment_interview_sessions`.`consent_ip`
`recruitment_interview_sessions`.`consent_user_agent`
`recruitment_interview_sessions`.`applicant_agreed_interview_rules`
`recruitment_interview_sessions`.`rules_agreed_at`
`recruitment_interview_sessions`.`rules_agreed_ip`
`recruitment_interview_sessions`.`rules_agreed_user_agent`
`recruitment_interview_sessions`.`first_client_id`
`recruitment_interview_sessions`.`active_client_id`
`recruitment_interview_sessions`.`active_client_seen_at`
`recruitment_interview_sessions`.`last_device_info`
`recruitment_interview_sessions`.`created_by`
`recruitment_interview_sessions`.`started_at`
`recruitment_interview_sessions`.`completed_at`
`recruitment_interview_sessions`.`created_at`
`recruitment_interview_sessions`.`updated_at`
`recruitment_management_review_logs`.*
`recruitment_management_review_logs`.`id`
`recruitment_management_review_logs`.`applicant_id`
`recruitment_management_review_logs`.`token_id`
`recruitment_management_review_logs`.`action`
`recruitment_management_review_logs`.`reviewer_name`
`recruitment_management_review_logs`.`rating`
`recruitment_management_review_logs`.`remarks`
`recruitment_management_review_logs`.`recommendation`
`recruitment_management_review_logs`.`ip_address`
`recruitment_management_review_logs`.`user_agent`
`recruitment_management_review_logs`.`created_at`
`recruitment_management_review_tokens`.*
`recruitment_management_review_tokens`.`id`
`recruitment_management_review_tokens`.`applicant_id`
`recruitment_management_review_tokens`.`token`
`recruitment_management_review_tokens`.`expires_at`
`recruitment_management_review_tokens`.`status`
`recruitment_management_review_tokens`.`allow_rating`
`recruitment_management_review_tokens`.`allow_remarks`
`recruitment_management_review_tokens`.`show_question_videos`
`recruitment_management_review_tokens`.`show_applicant_details`
`recruitment_management_review_tokens`.`show_documents`
`recruitment_management_review_tokens`.`created_by`
`recruitment_management_review_tokens`.`revoked_by`
`recruitment_management_review_tokens`.`revoked_at`
`recruitment_management_review_tokens`.`created_at`
`recruitment_management_review_tokens`.`updated_at`
`recruitment_positions`.*
`recruitment_positions`.`id`
`recruitment_positions`.`position_title`
`recruitment_positions`.`company`
`recruitment_positions`.`department`
`recruitment_positions`.`job_description`
`recruitment_positions`.`qualifications`
`recruitment_positions`.`requirements`
`recruitment_positions`.`employment_type`
`recruitment_positions`.`vacancy_count`
`recruitment_positions`.`status`
`recruitment_positions`.`created_by`
`recruitment_positions`.`created_at`
`recruitment_positions`.`updated_at`
`recruitment_question_video_versions`.*
`recruitment_question_video_versions`.`id`
`recruitment_question_video_versions`.`question_id`
`recruitment_question_video_versions`.`question_video_path`
`recruitment_question_video_versions`.`question_video_original_filename`
`recruitment_question_video_versions`.`question_video_stored_filename`
`recruitment_question_video_versions`.`question_video_mime_type`
`recruitment_question_video_versions`.`question_video_size`
`recruitment_question_video_versions`.`question_video_duration_seconds`
`recruitment_question_video_versions`.`replaced_by`
`recruitment_question_video_versions`.`replaced_at`
`recruitment_question_view_logs`.*
`recruitment_question_view_logs`.`id`
`recruitment_question_view_logs`.`interview_session_id`
`recruitment_question_view_logs`.`applicant_id`
`recruitment_question_view_logs`.`question_id`
`recruitment_question_view_logs`.`viewed_at`
`recruitment_question_view_logs`.`completed_full_watch`
`recruitment_question_view_logs`.`replay_count`
`recruitment_question_view_logs`.`ip_address`
`recruitment_question_view_logs`.`user_agent`
`recruitment_question_view_logs`.`created_at`
`recruitment_questions`.*
`recruitment_questions`.`id`
`recruitment_questions`.`position_id`
`recruitment_questions`.`company`
`recruitment_questions`.`question_text`
`recruitment_questions`.`question_type`
`recruitment_questions`.`question_mode`
`recruitment_questions`.`question_video_path`
`recruitment_questions`.`question_video_original_filename`
`recruitment_questions`.`question_video_stored_filename`
`recruitment_questions`.`question_video_mime_type`
`recruitment_questions`.`question_video_size`
`recruitment_questions`.`question_video_duration_seconds`
`recruitment_questions`.`show_text_overlay`
`recruitment_questions`.`text_overlay_position`
`recruitment_questions`.`answer_time_limit_seconds`
`recruitment_questions`.`allow_replay`
`recruitment_questions`.`max_replay_count`
`recruitment_questions`.`require_full_watch_before_answer`
`recruitment_questions`.`allow_answer_retake`
`recruitment_questions`.`max_answer_retake_count`
`recruitment_questions`.`time_limit_seconds`
`recruitment_questions`.`sort_order`
`recruitment_questions`.`is_required`
`recruitment_questions`.`status`
`recruitment_questions`.`created_by`
`recruitment_questions`.`updated_by`
`recruitment_questions`.`created_at`
`recruitment_questions`.`updated_at`
`recruitment_review_scores`.*
`recruitment_review_scores`.`id`
`recruitment_review_scores`.`review_id`
`recruitment_review_scores`.`applicant_id`
`recruitment_review_scores`.`interview_session_id`
`recruitment_review_scores`.`reviewer_id`
`recruitment_review_scores`.`question_id`
`recruitment_review_scores`.`rating`
`recruitment_review_scores`.`remarks`
`recruitment_review_scores`.`pass_fail_status`
`recruitment_review_scores`.`created_at`
`recruitment_review_scores`.`updated_at`
`recruitment_reviews`.*
`recruitment_reviews`.`id`
`recruitment_reviews`.`applicant_id`
`recruitment_reviews`.`reviewer_id`
`recruitment_reviews`.`technical_rating`
`recruitment_reviews`.`communication_rating`
`recruitment_reviews`.`experience_rating`
`recruitment_reviews`.`professionalism_rating`
`recruitment_reviews`.`overall_rating`
`recruitment_reviews`.`recommendation`
`recruitment_reviews`.`remarks`
`recruitment_reviews`.`created_at`
`recruitment_reviews`.`updated_at`
`recruitment_settings`.*
`recruitment_settings`.`id`
`recruitment_settings`.`setting_key`
`recruitment_settings`.`setting_value`
`recruitment_settings`.`value_type`
`recruitment_settings`.`description`
`recruitment_settings`.`updated_by`
`recruitment_settings`.`created_at`
`recruitment_settings`.`updated_at`
`recruitment_status_logs`.*
`recruitment_status_logs`.`id`
`recruitment_status_logs`.`applicant_id`
`recruitment_status_logs`.`old_status`
`recruitment_status_logs`.`new_status`
`recruitment_status_logs`.`changed_by`
`recruitment_status_logs`.`remarks`
`recruitment_status_logs`.`created_at`
`recruitment_video_answers`.*
`recruitment_video_answers`.`id`
`recruitment_video_answers`.`interview_session_id`
`recruitment_video_answers`.`applicant_id`
`recruitment_video_answers`.`question_id`
`recruitment_video_answers`.`question_shown_at`
`recruitment_video_answers`.`question_video_started_at`
`recruitment_video_answers`.`question_video_ended_at`
`recruitment_video_answers`.`countdown_started_at`
`recruitment_video_answers`.`recording_started_at`
`recruitment_video_answers`.`recording_ended_at`
`recruitment_video_answers`.`auto_started_recording`
`recruitment_video_answers`.`recording_stop_reason`
`recruitment_video_answers`.`upload_started_at`
`recruitment_video_answers`.`upload_completed_at`
`recruitment_video_answers`.`uploaded_at`
`recruitment_video_answers`.`is_early_submitted`
`recruitment_video_answers`.`confirmed_short_answer`
`recruitment_video_answers`.`answer_video_path`
`recruitment_video_answers`.`answer_video_original_filename`
`recruitment_video_answers`.`answer_video_stored_filename`
`recruitment_video_answers`.`answer_video_mime_type`
`recruitment_video_answers`.`answer_video_size`
`recruitment_video_answers`.`answer_duration_seconds`
`recruitment_video_answers`.`retake_count`
`recruitment_video_answers`.`video_file_path`
`recruitment_video_answers`.`video_filename`
`recruitment_video_answers`.`video_size`
`recruitment_video_answers`.`mime_type`
`recruitment_video_answers`.`duration_seconds`
`recruitment_video_answers`.`attempt_no`
`recruitment_video_answers`.`recorded_at`
`recruitment_video_answers`.`submitted_at`
`recruitment_video_answers`.`upload_status`
`recruitment_video_answers`.`status`
`recruitment_video_answers`.`created_at`
`recruitment_video_answers`.`updated_at`
`schedule_change_logs`.*
`schedule_change_logs`.`id`
`schedule_change_logs`.`employee_id`
`schedule_change_logs`.`scope_type`
`schedule_change_logs`.`scope_value`
`schedule_change_logs`.`old_schedule_id`
`schedule_change_logs`.`new_schedule_id`
`schedule_change_logs`.`effective_date`
`schedule_change_logs`.`changed_by`
`schedule_change_logs`.`reason`
`schedule_change_logs`.`created_at`
`schedule_scope_assignments`.*
`schedule_scope_assignments`.`id`
`schedule_scope_assignments`.`scope_type`
`schedule_scope_assignments`.`scope_value`
`schedule_scope_assignments`.`schedule_id`
`schedule_scope_assignments`.`effective_date`
`schedule_scope_assignments`.`end_date`
`schedule_scope_assignments`.`assigned_by`
`schedule_scope_assignments`.`remarks`
`schedule_scope_assignments`.`status`
`schedule_scope_assignments`.`created_at`
`schedule_scope_assignments`.`updated_at`
`stock_adjustments`.*
`stock_adjustments`.`id`
`stock_adjustments`.`product_id`
`stock_adjustments`.`old_qty`
`stock_adjustments`.`new_qty`
`stock_adjustments`.`difference`
`stock_adjustments`.`reason`
`stock_adjustments`.`user_id`
`stock_adjustments`.`created_at`
`stores`.*
`stores`.`id`
`stores`.`name`
`stores`.`active`
`system_settings`.*
`system_settings`.`id`
`system_settings`.`setting_key`
`system_settings`.`setting_value`
`system_settings`.`value_type`
`system_settings`.`description`
`system_settings`.`updated_by`
`system_settings`.`created_at`
`system_settings`.`updated_at`
`transaction_lines`.*
`transaction_lines`.`id`
`transaction_lines`.`transaction_id`
`transaction_lines`.`account_id`
`transaction_lines`.`line_type`
`transaction_lines`.`amount`
`transaction_lines`.`memo`
`transaction_lines`.`created_at`
`truck_locations`.*
`truck_locations`.`id`
`truck_locations`.`truck_id`
`truck_locations`.`latitude`
`truck_locations`.`longitude`
`truck_locations`.`speed_kph`
`truck_locations`.`captured_at`
`truck_locations`.`source`
`truck_locations`.`created_at`
`trucks`.*
`trucks`.`id`
`trucks`.`name`
`trucks`.`plate_no`
`trucks`.`capacity_kg`
`trucks`.`capacity_cbm`
`trucks`.`gps_device_id`
`trucks`.`active`
`trucks`.`created_at`
`user_group`.*
`user_group`.`id`
`user_group`.`user_id`
`user_group`.`group_id`
`user_notifications`.*
`user_notifications`.`id`
`user_notifications`.`user_id`
`user_notifications`.`type`
`user_notifications`.`title`
`user_notifications`.`message`
`user_notifications`.`link_url`
`user_notifications`.`payload_json`
`user_notifications`.`is_read`
`user_notifications`.`created_at`
`user_notifications`.`read_at`
`users`.*
`users`.`id`
`users`.`username`
`users`.`password`
`users`.`must_change_password`
`users`.`email`
`users`.`employee_id`
`users`.`firstname`
`users`.`lastname`
`users`.`phone`
`users`.`gender`
`website_inquiries`.*
`website_inquiries`.`id`
`website_inquiries`.`product_id`
`website_inquiries`.`product_name`
`website_inquiries`.`client_name`
`website_inquiries`.`company_name`
`website_inquiries`.`email`
`website_inquiries`.`phone`
`website_inquiries`.`subject`
`website_inquiries`.`message`
`website_inquiries`.`source_page`
`website_inquiries`.`ip_address`
`website_inquiries`.`user_agent`
`website_inquiries`.`status`
`website_inquiries`.`created_at`
`website_inquiries`.`updated_at`
`work_schedule_days`.*
`work_schedule_days`.`id`
`work_schedule_days`.`schedule_id`
`work_schedule_days`.`day_of_week`
`work_schedule_days`.`is_working_day`
`work_schedule_days`.`is_rest_day`
`work_schedules`.*
`work_schedules`.`id`
`work_schedules`.`schedule_code`
`work_schedules`.`schedule_name`
`work_schedules`.`schedule_type`
`work_schedules`.`start_time`
`work_schedules`.`end_time`
`work_schedules`.`break_minutes`
`work_schedules`.`required_work_minutes`
`work_schedules`.`grace_period_minutes`
`work_schedules`.`is_overnight`
`work_schedules`.`effective_date`
`work_schedules`.`status`
`work_schedules`.`remarks`
`work_schedules`.`legacy_shift_id`
`work_schedules`.`created_by`
`work_schedules`.`updated_by`
`work_schedules`.`created_at`
`work_schedules`.`updated_at`
`accounting_transactions`.*
`accounting_transactions`.`id`
`accounting_transactions`.`transaction_no`
`accounting_transactions`.`transaction_date`
`accounting_transactions`.`reference_no`
`accounting_transactions`.`transaction_type`
`accounting_transactions`.`party_type`
`accounting_transactions`.`party_name`
`accounting_transactions`.`description`
`accounting_transactions`.`status`
`accounting_transactions`.`source_module`
`accounting_transactions`.`source_record_id`
`accounting_transactions`.`total_debit`
`accounting_transactions`.`total_credit`
`accounting_transactions`.`created_by`
`accounting_transactions`.`updated_by`
`accounting_transactions`.`created_at`
`accounting_transactions`.`updated_at`
`accounts`.*
`accounts`.`id`
`accounts`.`account_code`
`accounts`.`account_name`
`accounts`.`account_type`
`accounts`.`parent_account_id`
`accounts`.`normal_balance`
`accounts`.`is_cash_account`
`accounts`.`is_active`
`accounts`.`notes`
`accounts`.`created_by`
`accounts`.`updated_by`
`accounts`.`created_at`
`accounts`.`updated_at`
`api_mobile_tokens`.*
`api_mobile_tokens`.`id`
`api_mobile_tokens`.`user_id`
`api_mobile_tokens`.`employee_id`
`api_mobile_tokens`.`token_hash`
`api_mobile_tokens`.`device_name`
`api_mobile_tokens`.`ip_address`
`api_mobile_tokens`.`user_agent`
`api_mobile_tokens`.`created_at`
`api_mobile_tokens`.`last_used_at`
`api_mobile_tokens`.`expires_at`
`api_mobile_tokens`.`revoked_at`
`app_rate_limits`.*
`app_rate_limits`.`id`
`app_rate_limits`.`scope`
`app_rate_limits`.`identifier_hash`
`app_rate_limits`.`identifier_label`
`app_rate_limits`.`window_started_at`
`app_rate_limits`.`attempts`
`app_rate_limits`.`blocked_until`
`app_rate_limits`.`last_attempt_at`
`app_rate_limits`.`created_at`
`app_rate_limits`.`updated_at`
`asset_accountability_form_items`.*
`asset_accountability_form_items`.`id`
`asset_accountability_form_items`.`form_id`
`asset_accountability_form_items`.`asset_id`
`asset_accountability_form_items`.`assignment_id`
`asset_accountability_form_items`.`asset_tag`
`asset_accountability_form_items`.`asset_snapshot`
`asset_accountability_form_items`.`created_at`
`asset_accountability_forms`.*
`asset_accountability_forms`.`id`
`asset_accountability_forms`.`form_control_no`
`asset_accountability_forms`.`employee_id`
`asset_accountability_forms`.`revision_no`
`asset_accountability_forms`.`status`
`asset_accountability_forms`.`generated_by`
`asset_accountability_forms`.`printed_by`
`asset_accountability_forms`.`printed_at`
`asset_accountability_forms`.`remarks`
`asset_accountability_forms`.`created_at`
`asset_accountability_forms`.`updated_at`
`asset_assignments`.*
`asset_assignments`.`id`
`asset_assignments`.`asset_id`
`asset_assignments`.`employee_id`
`asset_assignments`.`assigned_at`
`asset_assignments`.`expected_return_at`
`asset_assignments`.`condition_upon_issue`
`asset_assignments`.`accessories_included`
`asset_assignments`.`issued_by_user_id`
`asset_assignments`.`acknowledged_by`
`asset_assignments`.`returned_at`
`asset_assignments`.`return_condition`
`asset_assignments`.`assignment_notes`
`asset_assignments`.`received_by_user_id`
`asset_assignments`.`returned_to_user_id`
`asset_assignments`.`status`
`asset_assignments`.`clearance_status`
`asset_assignments`.`created_at`
`asset_audit_logs`.*
`asset_audit_logs`.`id`
`asset_audit_logs`.`asset_id`
`asset_audit_logs`.`action_type`
`asset_audit_logs`.`employee_id`
`asset_audit_logs`.`reference_table`
`asset_audit_logs`.`reference_id`
`asset_audit_logs`.`remarks`
`asset_audit_logs`.`performed_by`
`asset_audit_logs`.`created_at`
`asset_categories`.*
`asset_categories`.`id`
`asset_categories`.`category_name`
`asset_categories`.`description`
`asset_categories`.`asset_tag_prefix`
`asset_categories`.`is_active`
`asset_categories`.`created_at`
`asset_categories`.`updated_at`
`asset_label_print_logs`.*
`asset_label_print_logs`.`id`
`asset_label_print_logs`.`asset_id`
`asset_label_print_logs`.`template_id`
`asset_label_print_logs`.`label_type`
`asset_label_print_logs`.`reprint_reason`
`asset_label_print_logs`.`printer_used`
`asset_label_print_logs`.`printed_by`
`asset_label_print_logs`.`printed_at`
`asset_label_print_logs`.`ip_address`
`asset_label_print_logs`.`user_agent`
`asset_label_templates`.*
`asset_label_templates`.`id`
`asset_label_templates`.`template_name`
`asset_label_templates`.`label_size`
`asset_label_templates`.`width_mm`
`asset_label_templates`.`height_mm`
`asset_label_templates`.`include_brand_model`
`asset_label_templates`.`include_serial`
`asset_label_templates`.`include_qr`
`asset_label_templates`.`status`
`asset_label_templates`.`created_at`
`asset_label_templates`.`updated_at`
`asset_maintenance_logs`.*
`asset_maintenance_logs`.`id`
`asset_maintenance_logs`.`asset_id`
`asset_maintenance_logs`.`maintenance_date`
`asset_maintenance_logs`.`maintenance_type`
`asset_maintenance_logs`.`vendor_name`
`asset_maintenance_logs`.`cost`
`asset_maintenance_logs`.`details`
`asset_maintenance_logs`.`status`
`asset_maintenance_logs`.`performed_by_user_id`
`asset_maintenance_logs`.`resolved_at`
`asset_maintenance_logs`.`created_at`
`asset_print_logs`.*
`asset_print_logs`.`id`
`asset_print_logs`.`employee_id`
`asset_print_logs`.`asset_id`
`asset_print_logs`.`print_type`
`asset_print_logs`.`reference_id`
`asset_print_logs`.`label_type`
`asset_print_logs`.`assets_included`
`asset_print_logs`.`reprint_reason`
`asset_print_logs`.`printer_used`
`asset_print_logs`.`printed_by`
`asset_print_logs`.`printed_at`
`asset_print_logs`.`ip_address`
`asset_print_logs`.`user_agent`
`asset_transfers`.*
`asset_transfers`.`id`
`asset_transfers`.`asset_id`
`asset_transfers`.`from_employee_id`
`asset_transfers`.`to_employee_id`
`asset_transfers`.`from_location`
`asset_transfers`.`to_location`
`asset_transfers`.`transfer_date`
`asset_transfers`.`reason`
`asset_transfers`.`processed_by`
`asset_transfers`.`related_assignment_id`
`asset_transfers`.`created_at`
`assets`.*
`assets`.`id`
`assets`.`asset_tag`
`assets`.`asset_code`
`assets`.`asset_category_id`
`assets`.`item_name`
`assets`.`brand`
`assets`.`model`
`assets`.`serial_number`
`assets`.`imei_1`
`assets`.`imei_2`
`assets`.`sim_number`
`assets`.`mobile_number`
`assets`.`plan_type`
`assets`.`processor`
`assets`.`ram`
`assets`.`storage`
`assets`.`operating_system`
`assets`.`charger_serial_number`
`assets`.`accessories_included`
`assets`.`purchase_date`
`assets`.`supplier`
`assets`.`warranty_date`
`assets`.`asset_condition`
`assets`.`status`
`assets`.`assigned_employee_id`
`assets`.`location`
`assets`.`purchase_cost`
`assets`.`accountability_form_no`
`assets`.`notes`
`assets`.`asset_photo`
`assets`.`public_view_token`
`assets`.`created_by`
`assets`.`updated_by`
`assets`.`created_at`
`assets`.`updated_at`
`attendance_corrections`.*
`attendance_corrections`.`id`
`attendance_corrections`.`employee_id`
`attendance_corrections`.`attendance_id`
`attendance_corrections`.`attendance_date`
`attendance_corrections`.`requested_time_in`
`attendance_corrections`.`requested_time_out`
`attendance_corrections`.`reason`
`attendance_corrections`.`attachment`
`attendance_corrections`.`status`
`attendance_corrections`.`created_by`
`attendance_corrections`.`approved_by`
`attendance_corrections`.`approved_at`
`attendance_corrections`.`remarks`
`attendance_corrections`.`created_at`
`attendance_corrections`.`updated_at`
`attribute_value`.*
`attribute_value`.`id`
`attribute_value`.`value`
`attribute_value`.`attribute_parent_id`
`attributes`.*
`attributes`.`id`
`attributes`.`name`
`attributes`.`active`
`audit_logs`.*
`audit_logs`.`id`
`audit_logs`.`user_id`
`audit_logs`.`user_name`
`audit_logs`.`module`
`audit_logs`.`record_type`
`audit_logs`.`record_id`
`audit_logs`.`action`
`audit_logs`.`old_value`
`audit_logs`.`new_value`
`audit_logs`.`remarks`
`audit_logs`.`ip_address`
`audit_logs`.`user_agent`
`audit_logs`.`created_at`
`auth_access_logs`.*
`auth_access_logs`.`id`
`auth_access_logs`.`user_id`
`auth_access_logs`.`username`
`auth_access_logs`.`event_type`
`auth_access_logs`.`status`
`auth_access_logs`.`ip_address`
`auth_access_logs`.`ip_source`
`auth_access_logs`.`is_internal_ip`
`auth_access_logs`.`is_whitelisted_ip`
`auth_access_logs`.`network_label`
`auth_access_logs`.`user_agent`
`auth_access_logs`.`browser_name`
`auth_access_logs`.`platform`
`auth_access_logs`.`device_hash`
`auth_access_logs`.`session_id`
`auth_access_logs`.`request_uri`
`auth_access_logs`.`notes`
`auth_access_logs`.`metadata_text`
`auth_access_logs`.`created_at`
`brands`.*
`brands`.`id`
`brands`.`name`
`brands`.`active`
`categories`.*
`categories`.`id`
`categories`.`name`
`categories`.`active`
`clearance_items`.*
`clearance_items`.`id`
`clearance_items`.`offboarding_id`
`clearance_items`.`clearance_area`
`clearance_items`.`item_label`
`clearance_items`.`assigned_to`
`clearance_items`.`status`
`clearance_items`.`remarks`
`clearance_items`.`cleared_by`
`clearance_items`.`cleared_at`
`clearance_items`.`created_at`
`clearance_items`.`updated_at`
`company`.*
`company`.`id`
`company`.`company_name`
`company`.`service_charge_value`
`company`.`vat_charge_value`
`company`.`address`
`company`.`phone`
`company`.`payroll_funding_account`
`company`.`country`
`company`.`message`
`company`.`currency`
`deliveries`.*
`deliveries`.`id`
`deliveries`.`delivery_no`
`deliveries`.`supplier_name`
`deliveries`.`remarks`
`deliveries`.`created_at`
`deliveries`.`user_id`
`deliveries`.`status`
`deliveries`.`cancel_reason`
`deliveries`.`cancelled_at`
`deliveries`.`cancelled_by`
`deliveries`.`attachment_path`
`delivery_items`.*
`delivery_items`.`id`
`delivery_items`.`delivery_id`
`delivery_items`.`product_id`
`delivery_items`.`qty`
`departments`.*
`departments`.`id`
`departments`.`department_name`
`departments`.`department_code`
`departments`.`department_head_id`
`departments`.`status`
`departments`.`created_at`
`departments`.`updated_at`
`disciplinary_cases`.*
`disciplinary_cases`.`id`
`disciplinary_cases`.`employee_id`
`disciplinary_cases`.`case_type`
`disciplinary_cases`.`incident_date`
`disciplinary_cases`.`description`
`disciplinary_cases`.`attachment`
`disciplinary_cases`.`issued_by`
`disciplinary_cases`.`employee_response`
`disciplinary_cases`.`hr_remarks`
`disciplinary_cases`.`final_action`
`disciplinary_cases`.`acknowledgment_date`
`disciplinary_cases`.`status`
`disciplinary_cases`.`created_at`
`disciplinary_cases`.`updated_at`
`document_approval_logs`.*
`document_approval_logs`.`id`
`document_approval_logs`.`document_id`
`document_approval_logs`.`action`
`document_approval_logs`.`user_id`
`document_approval_logs`.`old_status`
`document_approval_logs`.`new_status`
`document_approval_logs`.`remarks`
`document_approval_logs`.`ip_address`
`document_approval_logs`.`user_agent`
`document_approval_logs`.`created_at`
`document_approval_remarks`.*
`document_approval_remarks`.`id`
`document_approval_remarks`.`document_id`
`document_approval_remarks`.`step_id`
`document_approval_remarks`.`user_id`
`document_approval_remarks`.`remarks_type`
`document_approval_remarks`.`remarks`
`document_approval_remarks`.`is_private`
`document_approval_remarks`.`page_number`
`document_approval_remarks`.`created_at`
`document_approval_signatures`.*
`document_approval_signatures`.`id`
`document_approval_signatures`.`document_id`
`document_approval_signatures`.`step_id`
`document_approval_signatures`.`approver_id`
`document_approval_signatures`.`signature_file_path`
`document_approval_signatures`.`page_number`
`document_approval_signatures`.`x_position`
`document_approval_signatures`.`y_position`
`document_approval_signatures`.`width`
`document_approval_signatures`.`height`
`document_approval_signatures`.`signed_at`
`document_approval_signatures`.`created_at`
`document_approval_steps`.*
`document_approval_steps`.`id`
`document_approval_steps`.`document_id`
`document_approval_steps`.`step_order`
`document_approval_steps`.`approver_id`
`document_approval_steps`.`approver_role`
`document_approval_steps`.`status`
`document_approval_steps`.`remarks`
`document_approval_steps`.`signature_required`
`document_approval_steps`.`signed_at`
`document_approval_steps`.`approved_at`
`document_approval_steps`.`returned_at`
`document_approval_steps`.`rejected_at`
`document_approval_steps`.`created_at`
`document_approval_steps`.`updated_at`
`document_approval_versions`.*
`document_approval_versions`.`id`
`document_approval_versions`.`document_id`
`document_approval_versions`.`version_number`
`document_approval_versions`.`version_type`
`document_approval_versions`.`filename`
`document_approval_versions`.`file_path`
`document_approval_versions`.`file_size`
`document_approval_versions`.`mime_type`
`document_approval_versions`.`uploaded_by`
`document_approval_versions`.`created_at`
`document_approvals`.*
`document_approvals`.`id`
`document_approvals`.`document_code`
`document_approvals`.`title`
`document_approvals`.`company`
`document_approvals`.`department_id`
`document_approvals`.`document_type_id`
`document_approvals`.`other_document_type`
`document_approvals`.`category`
`document_approvals`.`uploaded_by`
`document_approvals`.`current_approver_id`
`document_approvals`.`additional_reviewer_id`
`document_approvals`.`priority`
`document_approvals`.`due_date`
`document_approvals`.`original_filename`
`document_approvals`.`stored_filename`
`document_approvals`.`file_path`
`document_approvals`.`file_size`
`document_approvals`.`mime_type`
`document_approvals`.`is_confidential`
`document_approvals`.`status`
`document_approvals`.`remarks`
`document_approvals`.`submitted_at`
`document_approvals`.`approved_at`
`document_approvals`.`returned_at`
`document_approvals`.`rejected_at`
`document_approvals`.`archived_at`
`document_approvals`.`created_at`
`document_approvals`.`updated_at`
`document_department_users`.*
`document_department_users`.`id`
`document_department_users`.`department_id`
`document_department_users`.`user_id`
`document_department_users`.`can_upload`
`document_department_users`.`can_view_department`
`document_department_users`.`can_approve`
`document_department_users`.`can_view_confidential`
`document_department_users`.`can_view_private_remarks`
`document_department_users`.`status`
`document_department_users`.`created_at`
`document_department_users`.`updated_at`
`document_types`.*
`document_types`.`id`
`document_types`.`department_id`
`document_types`.`type_name`
`document_types`.`type_code`
`document_types`.`category`
`document_types`.`requires_signature`
`document_types`.`requires_approval`
`document_types`.`default_workflow_id`
`document_types`.`default_approver_id`
`document_types`.`allowed_file_types`
`document_types`.`max_file_size`
`document_types`.`status`
`document_types`.`created_at`
`document_types`.`updated_at`
`document_workflow_steps`.*
`document_workflow_steps`.`id`
`document_workflow_steps`.`workflow_id`
`document_workflow_steps`.`step_order`
`document_workflow_steps`.`approver_role`
`document_workflow_steps`.`approver_user_id`
`document_workflow_steps`.`require_signature`
`document_workflow_steps`.`require_remarks`
`document_workflow_steps`.`created_at`
`document_workflow_steps`.`updated_at`
`document_workflows`.*
`document_workflows`.`id`
`document_workflows`.`workflow_name`
`document_workflows`.`department_id`
`document_workflows`.`document_type_id`
`document_workflows`.`status`
`document_workflows`.`created_at`
`document_workflows`.`updated_at`
`employee_201_files`.*
`employee_201_files`.`id`
`employee_201_files`.`employee_id`
`employee_201_files`.`completion_percent`
`employee_201_files`.`status`
`employee_201_files`.`last_reviewed_by`
`employee_201_files`.`last_reviewed_at`
`employee_201_files`.`remarks`
`employee_201_files`.`created_at`
`employee_201_files`.`updated_at`
`employee_aliases`.*
`employee_aliases`.`id`
`employee_aliases`.`raw_name`
`employee_aliases`.`employee_id`
`employee_aliases`.`corrected_name`
`employee_aliases`.`created_at`
`employee_aliases`.`updated_at`
`employee_certifications`.*
`employee_certifications`.`id`
`employee_certifications`.`employee_id`
`employee_certifications`.`skill_name`
`employee_certifications`.`certification_name`
`employee_certifications`.`issuing_organization`
`employee_certifications`.`issue_date`
`employee_certifications`.`expiry_date`
`employee_certifications`.`attachment`
`employee_certifications`.`status`
`employee_certifications`.`created_at`
`employee_certifications`.`updated_at`
`employee_document_access_logs`.*
`employee_document_access_logs`.`id`
`employee_document_access_logs`.`document_id`
`employee_document_access_logs`.`employee_id`
`employee_document_access_logs`.`action_type`
`employee_document_access_logs`.`user_id`
`employee_document_access_logs`.`user_name`
`employee_document_access_logs`.`ip_address`
`employee_document_access_logs`.`user_agent`
`employee_document_access_logs`.`remarks`
`employee_document_access_logs`.`created_at`
`employee_document_types`.*
`employee_document_types`.`id`
`employee_document_types`.`section`
`employee_document_types`.`category`
`employee_document_types`.`document_name`
`employee_document_types`.`is_required`
`employee_document_types`.`requires_expiry`
`employee_document_types`.`sort_order`
`employee_document_types`.`status`
`employee_document_types`.`created_at`
`employee_document_types`.`updated_at`
`employee_document_versions`.*
`employee_document_versions`.`id`
`employee_document_versions`.`document_id`
`employee_document_versions`.`employee_id`
`employee_document_versions`.`version_no`
`employee_document_versions`.`document_type_id`
`employee_document_versions`.`category`
`employee_document_versions`.`section`
`employee_document_versions`.`document_title`
`employee_document_versions`.`original_filename`
`employee_document_versions`.`stored_filename`
`employee_document_versions`.`file_path`
`employee_document_versions`.`file_extension`
`employee_document_versions`.`mime_type`
`employee_document_versions`.`file_size`
`employee_document_versions`.`issue_date`
`employee_document_versions`.`expiry_date`
`employee_document_versions`.`is_required`
`employee_document_versions`.`is_confidential`
`employee_document_versions`.`remarks`
`employee_document_versions`.`replaced_by`
`employee_document_versions`.`replaced_at`
`employee_document_versions`.`created_at`
`employee_documents`.*
`employee_documents`.`id`
`employee_documents`.`employee_id`
`employee_documents`.`document_type_id`
`employee_documents`.`category`
`employee_documents`.`section`
`employee_documents`.`is_required`
`employee_documents`.`is_confidential`
`employee_documents`.`document_title`
`employee_documents`.`file_path`
`employee_documents`.`original_filename`
`employee_documents`.`stored_filename`
`employee_documents`.`file_extension`
`employee_documents`.`mime_type`
`employee_documents`.`file_size`
`employee_documents`.`issue_date`
`employee_documents`.`version_no`
`employee_documents`.`expiry_date`
`employee_documents`.`remarks`
`employee_documents`.`status`
`employee_documents`.`uploaded_by`
`employee_documents`.`last_updated_by`
`employee_documents`.`updated_by`
`employee_documents`.`replaced_document_id`
`employee_documents`.`archived_by`
`employee_documents`.`archived_at`
`employee_documents`.`created_at`
`employee_documents`.`updated_at`
`employee_education`.*
`employee_education`.`id`
`employee_education`.`employee_id`
`employee_education`.`school`
`employee_education`.`course`
`employee_education`.`year_graduated`
`employee_education`.`awards`
`employee_education`.`document_path`
`employee_education`.`status`
`employee_education`.`created_at`
`employee_education`.`updated_at`
`employee_employment_history`.*
`employee_employment_history`.`id`
`employee_employment_history`.`employee_id`
`employee_employment_history`.`previous_employer`
`employee_employment_history`.`position`
`employee_employment_history`.`start_date`
`employee_employment_history`.`end_date`
`employee_employment_history`.`reason_for_leaving`
`employee_employment_history`.`status`
`employee_employment_history`.`created_at`
`employee_employment_history`.`updated_at`
`employee_family_dependents`.*
`employee_family_dependents`.`id`
`employee_family_dependents`.`employee_id`
`employee_family_dependents`.`full_name`
`employee_family_dependents`.`relationship`
`employee_family_dependents`.`birthdate`
`employee_family_dependents`.`contact_no`
`employee_family_dependents`.`is_dependent`
`employee_family_dependents`.`status`
`employee_family_dependents`.`created_at`
`employee_family_dependents`.`updated_at`
`employee_medical_records`.*
`employee_medical_records`.`id`
`employee_medical_records`.`employee_id`
`employee_medical_records`.`medical_exam_date`
`employee_medical_records`.`fit_to_work_status`
`employee_medical_records`.`medical_expiry_date`
`employee_medical_records`.`certificate_path`
`employee_medical_records`.`remarks`
`employee_medical_records`.`status`
`employee_medical_records`.`created_at`
`employee_medical_records`.`updated_at`
`employee_movements`.*
`employee_movements`.`id`
`employee_movements`.`employee_id`
`employee_movements`.`movement_type`
`employee_movements`.`field_name`
`employee_movements`.`old_value`
`employee_movements`.`new_value`
`employee_movements`.`effective_date`
`employee_movements`.`reason`
`employee_movements`.`attachment`
`employee_movements`.`status`
`employee_movements`.`created_by`
`employee_movements`.`approved_by`
`employee_movements`.`approved_at`
`employee_movements`.`created_at`
`employee_movements`.`updated_at`
`employee_onboarding_items`.*
`employee_onboarding_items`.`id`
`employee_onboarding_items`.`employee_id`
`employee_onboarding_items`.`item_key`
`employee_onboarding_items`.`item_label`
`employee_onboarding_items`.`status`
`employee_onboarding_items`.`completed_by`
`employee_onboarding_items`.`completed_at`
`employee_onboarding_items`.`remarks`
`employee_onboarding_items`.`created_at`
`employee_onboarding_items`.`updated_at`
`employee_schedule_assignments`.*
`employee_schedule_assignments`.`id`
`employee_schedule_assignments`.`employee_id`
`employee_schedule_assignments`.`schedule_id`
`employee_schedule_assignments`.`effective_date`
`employee_schedule_assignments`.`end_date`
`employee_schedule_assignments`.`assigned_by`
`employee_schedule_assignments`.`remarks`
`employee_schedule_assignments`.`status`
`employee_schedule_assignments`.`created_at`
`employee_schedule_assignments`.`updated_at`
`expenses`.*
`expenses`.`id`
`expenses`.`transaction_id`
`expenses`.`expense_date`
`expenses`.`expense_type`
`expenses`.`vendor_name`
`expenses`.`amount`
`expenses`.`payment_status`
`expenses`.`related_inventory_reference`
`expenses`.`notes`
`expenses`.`created_by`
`expenses`.`updated_by`
`expenses`.`created_at`
`expenses`.`updated_at`
`groups`.*
`groups`.`id`
`groups`.`group_name`
`groups`.`permission`
`holidays`.*
`holidays`.`id`
`holidays`.`holiday_name`
`holidays`.`holiday_date`
`holidays`.`holiday_type`
`holidays`.`created_at`
`hr_attendance`.*
`hr_attendance`.`id`
`hr_attendance`.`employee_id`
`hr_attendance`.`cutoff_id`
`hr_attendance`.`schedule_id`
`hr_attendance`.`scheduled_start_at`
`hr_attendance`.`scheduled_end_at`
`hr_attendance`.`required_work_minutes`
`hr_attendance`.`break_minutes`
`hr_attendance`.`grace_period_minutes`
`hr_attendance`.`attendance_date`
`hr_attendance`.`time_in`
`hr_attendance`.`time_in_device_time`
`hr_attendance`.`time_in_server_time`
`hr_attendance`.`time_in_time_difference_seconds`
`hr_attendance`.`time_in_flagged_time_mismatch`
`hr_attendance`.`time_in_face_distance`
`hr_attendance`.`time_in_face_confidence`
`hr_attendance`.`time_in_face_source`
`hr_attendance`.`time_out`
`hr_attendance`.`time_out_device_time`
`hr_attendance`.`time_out_server_time`
`hr_attendance`.`time_out_time_difference_seconds`
`hr_attendance`.`time_out_flagged_time_mismatch`
`hr_attendance`.`time_out_face_distance`
`hr_attendance`.`time_out_face_confidence`
`hr_attendance`.`time_out_face_source`
`hr_attendance`.`latitude`
`hr_attendance`.`longitude`
`hr_attendance`.`photo`
`hr_attendance`.`time_in_latitude`
`hr_attendance`.`time_in_longitude`
`hr_attendance`.`time_in_photo`
`hr_attendance`.`time_out_latitude`
`hr_attendance`.`time_out_longitude`
`hr_attendance`.`time_out_photo`
`hr_attendance`.`hours_worked`
`hr_attendance`.`late_minutes`
`hr_attendance`.`undertime_minutes`
`hr_attendance`.`regular_work_minutes`
`hr_attendance`.`auto_overtime_hours`
`hr_attendance`.`rest_day_work`
`hr_attendance`.`rest_day_validated`
`hr_attendance`.`schedule_snapshot_json`
`hr_attendance`.`manual_overtime_hours`
`hr_attendance`.`manual_overtime_override`
`hr_attendance`.`status`
`hr_attendance`.`created_at`
`hr_attendance`.`updated_at`
`hr_attendance_edit_logs`.*
`hr_attendance_edit_logs`.`id`
`hr_attendance_edit_logs`.`attendance_id`
`hr_attendance_edit_logs`.`employee_id`
`hr_attendance_edit_logs`.`attendance_date`
`hr_attendance_edit_logs`.`old_time_in`
`hr_attendance_edit_logs`.`old_time_out`
`hr_attendance_edit_logs`.`new_time_in`
`hr_attendance_edit_logs`.`new_time_out`
`hr_attendance_edit_logs`.`old_hours_worked`
`hr_attendance_edit_logs`.`new_hours_worked`
`hr_attendance_edit_logs`.`edited_by`
`hr_attendance_edit_logs`.`ip_address`
`hr_attendance_edit_logs`.`user_agent`
`hr_attendance_edit_logs`.`edit_reason`
`hr_attendance_edit_logs`.`created_at`
`hr_attendance_time_security_logs`.*
`hr_attendance_time_security_logs`.`id`
`hr_attendance_time_security_logs`.`employee_id`
`hr_attendance_time_security_logs`.`action_key`
`hr_attendance_time_security_logs`.`source`
`hr_attendance_time_security_logs`.`device_time_raw`
`hr_attendance_time_security_logs`.`device_time`
`hr_attendance_time_security_logs`.`server_time`
`hr_attendance_time_security_logs`.`time_difference_seconds`
`hr_attendance_time_security_logs`.`threshold_seconds`
`hr_attendance_time_security_logs`.`flagged_time_mismatch`
`hr_attendance_time_security_logs`.`blocked`
`hr_attendance_time_security_logs`.`warning_message`
`hr_attendance_time_security_logs`.`ip_address`
`hr_attendance_time_security_logs`.`user_agent`
`hr_attendance_time_security_logs`.`extra_json`
`hr_attendance_time_security_logs`.`created_at`
`hr_checklist_items`.*
`hr_checklist_items`.`id`
`hr_checklist_items`.`checklist_id`
`hr_checklist_items`.`item_label`
`hr_checklist_items`.`assigned_to`
`hr_checklist_items`.`due_date`
`hr_checklist_items`.`status`
`hr_checklist_items`.`remarks`
`hr_checklist_items`.`attachment`
`hr_checklist_items`.`completed_by`
`hr_checklist_items`.`completed_at`
`hr_checklist_items`.`created_at`
`hr_checklist_items`.`updated_at`
`hr_checklists`.*
`hr_checklists`.`id`
`hr_checklists`.`employee_id`
`hr_checklists`.`checklist_type`
`hr_checklists`.`title`
`hr_checklists`.`status`
`hr_checklists`.`completion_percent`
`hr_checklists`.`created_by`
`hr_checklists`.`created_at`
`hr_checklists`.`updated_at`
`hr_employees`.*
`hr_employees`.`id`
`hr_employees`.`employee_code`
`hr_employees`.`bank_account_no`
`hr_employees`.`bank_account_name`
`hr_employees`.`payroll_account_status`
`hr_employees`.`bank_name`
`hr_employees`.`first_name`
`hr_employees`.`middle_name`
`hr_employees`.`last_name`
`hr_employees`.`suffix`
`hr_employees`.`nickname`
`hr_employees`.`position`
`hr_employees`.`job_title`
`hr_employees`.`branch_location`
`hr_employees`.`department`
`hr_employees`.`payroll_type`
`hr_employees`.`shift_id`
`hr_employees`.`rest_day`
`hr_employees`.`daily_rate`
`hr_employees`.`salary_type`
`hr_employees`.`monthly_salary`
`hr_employees`.`hourly_rate`
`hr_employees`.`date_hired`
`hr_employees`.`date_regularized`
`hr_employees`.`contract_start_date`
`hr_employees`.`contract_end_date`
`hr_employees`.`probationary_end_date`
`hr_employees`.`supervisor_id`
`hr_employees`.`birthdate`
`hr_employees`.`gender`
`hr_employees`.`civil_status`
`hr_employees`.`nationality`
`hr_employees`.`religion`
`hr_employees`.`contact_no`
`hr_employees`.`personal_email`
`hr_employees`.`emergency_contact_name`
`hr_employees`.`emergency_contact_no`
`hr_employees`.`emergency_relationship`
`hr_employees`.`emergency_contact_address`
`hr_employees`.`address`
`hr_employees`.`sss_no`
`hr_employees`.`philhealth_no`
`hr_employees`.`pagibig_no`
`hr_employees`.`tin_no`
`hr_employees`.`bir_tax_status`
`hr_employees`.`rdo_code`
`hr_employees`.`status`
`hr_employees`.`employment_status`
`hr_employees`.`active_flag`
`hr_employees`.`face_image`
`hr_employees`.`employee_photo`
`hr_employees`.`face_descriptor`
`hr_employees`.`created_at`
`hr_employees`.`updated_at`
`hr_payroll_batch_logs`.*
`hr_payroll_batch_logs`.`id`
`hr_payroll_batch_logs`.`batch_id`
`hr_payroll_batch_logs`.`week_start`
`hr_payroll_batch_logs`.`week_end`
`hr_payroll_batch_logs`.`from_status`
`hr_payroll_batch_logs`.`to_status`
`hr_payroll_batch_logs`.`action_by`
`hr_payroll_batch_logs`.`note`
`hr_payroll_batch_logs`.`created_at`
`hr_payroll_batches`.*
`hr_payroll_batches`.`id`
`hr_payroll_batches`.`week_start`
`hr_payroll_batches`.`week_end`
`hr_payroll_batches`.`payroll_type`
`hr_payroll_batches`.`status`
`hr_payroll_batches`.`reviewed_by`
`hr_payroll_batches`.`reviewed_at`
`hr_payroll_batches`.`approved_by`
`hr_payroll_batches`.`approved_at`
`hr_payroll_batches`.`released_by`
`hr_payroll_batches`.`released_at`
`hr_payroll_batches`.`locked_by`
`hr_payroll_batches`.`locked_at`
`hr_payroll_batches`.`is_finalized`
`hr_payroll_batches`.`is_locked`
`hr_payroll_batches`.`finalized_by`
`hr_payroll_batches`.`finalized_at`
`hr_payroll_batches`.`note`
`hr_payroll_batches`.`created_by`
`hr_payroll_batches`.`created_at`
`hr_payroll_batches`.`updated_at`
`hr_payrolls`.*
`hr_payrolls`.`id`
`hr_payrolls`.`employee_id`
`hr_payrolls`.`cutoff_id`
`hr_payrolls`.`week_start`
`hr_payrolls`.`week_end`
`hr_payrolls`.`days_worked`
`hr_payrolls`.`paid_leave_days`
`hr_payrolls`.`lwop_days`
`hr_payrolls`.`regular_holiday_worked`
`hr_payrolls`.`special_holiday_worked`
`hr_payrolls`.`rate_per_day`
`hr_payrolls`.`rate_per_min`
`hr_payrolls`.`late_ut_minutes`
`hr_payrolls`.`total_tardy`
`hr_payrolls`.`basic_pay`
`hr_payrolls`.`gross_pay`
`hr_payrolls`.`holiday_pay`
`hr_payrolls`.`leave_pay`
`hr_payrolls`.`overtime_pay`
`hr_payrolls`.`total_gp`
`hr_payrolls`.`cash_advance`
`hr_payrolls`.`sss_employee`
`hr_payrolls`.`philhealth_employee`
`hr_payrolls`.`pagibig_employee`
`hr_payrolls`.`withholding_tax`
`hr_payrolls`.`statutory_total`
`hr_payrolls`.`taxable_income`
`hr_payrolls`.`formula_version`
`hr_payrolls`.`payroll_breakdown_json`
`hr_payrolls`.`remarks`
`hr_payrolls`.`benefits`
`hr_payrolls`.`deductions`
`hr_payrolls`.`net_pay`
`hr_payrolls`.`adjustment`
`hr_payrolls`.`total_net`
`hr_payrolls`.`created_at`
`hr_payrolls`.`updated_at`
`hr_payrolls`.`regular_overtime_hours`
`hr_payrolls`.`regular_overtime_pay`
`hr_payrolls`.`holiday_overtime_hours`
`hr_payrolls`.`holiday_overtime_pay`
`hr_payrolls`.`approved_ot_hours`
`hr_payrolls`.`rest_day_hours`
`hr_payrolls`.`rest_day_pay`
`hr_payrolls`.`night_diff_hours`
`hr_payrolls`.`night_diff_pay`
`hr_payrolls`.`ob_hours`
`hr_shifts`.*
`hr_shifts`.`id`
`hr_shifts`.`work_schedule_id`
`hr_shifts`.`shift_code`
`hr_shifts`.`shift_name`
`hr_shifts`.`schedule_type`
`hr_shifts`.`start_time`
`hr_shifts`.`end_time`
`hr_shifts`.`break_minutes`
`hr_shifts`.`paid_hours`
`hr_shifts`.`late_grace_minutes`
`hr_shifts`.`is_active`
`hr_shifts`.`remarks`
`hr_shifts`.`created_at`
`hr_shifts`.`updated_at`
`hr_statutory_pagibig`.*
`hr_statutory_pagibig`.`id`
`hr_statutory_pagibig`.`effective_start`
`hr_statutory_pagibig`.`effective_end`
`hr_statutory_pagibig`.`monthly_salary_from`
`hr_statutory_pagibig`.`monthly_salary_to`
`hr_statutory_pagibig`.`employee_rate`
`hr_statutory_pagibig`.`max_employee_contribution`
`hr_statutory_pagibig`.`notes`
`hr_statutory_pagibig`.`created_at`
`hr_statutory_philhealth`.*
`hr_statutory_philhealth`.`id`
`hr_statutory_philhealth`.`effective_start`
`hr_statutory_philhealth`.`effective_end`
`hr_statutory_philhealth`.`premium_rate`
`hr_statutory_philhealth`.`monthly_salary_floor`
`hr_statutory_philhealth`.`monthly_salary_ceiling`
`hr_statutory_philhealth`.`employee_share_ratio`
`hr_statutory_philhealth`.`notes`
`hr_statutory_philhealth`.`created_at`
`hr_statutory_sss`.*
`hr_statutory_sss`.`id`
`hr_statutory_sss`.`effective_start`
`hr_statutory_sss`.`effective_end`
`hr_statutory_sss`.`monthly_salary_from`
`hr_statutory_sss`.`monthly_salary_to`
`hr_statutory_sss`.`employee_share`
`hr_statutory_sss`.`employer_share`
`hr_statutory_sss`.`ec_share`
`hr_statutory_sss`.`notes`
`hr_statutory_sss`.`created_at`
`hr_statutory_withholding`.*
`hr_statutory_withholding`.`id`
`hr_statutory_withholding`.`effective_start`
`hr_statutory_withholding`.`effective_end`
`hr_statutory_withholding`.`annual_taxable_from`
`hr_statutory_withholding`.`annual_taxable_to`
`hr_statutory_withholding`.`base_tax`
`hr_statutory_withholding`.`over_percent`
`hr_statutory_withholding`.`notes`
`hr_statutory_withholding`.`created_at`
`hr_thirteenth_month_batches`.*
`hr_thirteenth_month_batches`.`id`
`hr_thirteenth_month_batches`.`payout_year`
`hr_thirteenth_month_batches`.`status`
`hr_thirteenth_month_batches`.`note`
`hr_thirteenth_month_batches`.`generated_by`
`hr_thirteenth_month_batches`.`generated_at`
`hr_thirteenth_month_batches`.`released_by`
`hr_thirteenth_month_batches`.`released_at`
`hr_thirteenth_month_batches`.`created_at`
`hr_thirteenth_month_batches`.`updated_at`
`hr_thirteenth_month_rows`.*
`hr_thirteenth_month_rows`.`id`
`hr_thirteenth_month_rows`.`batch_id`
`hr_thirteenth_month_rows`.`employee_id`
`hr_thirteenth_month_rows`.`payout_year`
`hr_thirteenth_month_rows`.`coverage_start`
`hr_thirteenth_month_rows`.`coverage_end`
`hr_thirteenth_month_rows`.`payroll_rows_count`
`hr_thirteenth_month_rows`.`qualifying_days`
`hr_thirteenth_month_rows`.`basic_salary_base`
`hr_thirteenth_month_rows`.`thirteenth_month_pay`
`hr_thirteenth_month_rows`.`taxable_excess`
`hr_thirteenth_month_rows`.`withholding_tax`
`hr_thirteenth_month_rows`.`net_amount`
`hr_thirteenth_month_rows`.`remarks`
`hr_thirteenth_month_rows`.`created_at`
`hr_thirteenth_month_rows`.`updated_at`
`leave_balances`.*
`leave_balances`.`id`
`leave_balances`.`employee_id`
`leave_balances`.`leave_type_id`
`leave_balances`.`year`
`leave_balances`.`allocated_days`
`leave_balances`.`used_days`
`leave_balances`.`created_at`
`leave_balances`.`updated_at`
`leave_request_audit_logs`.*
`leave_request_audit_logs`.`id`
`leave_request_audit_logs`.`leave_request_id`
`leave_request_audit_logs`.`action`
`leave_request_audit_logs`.`from_status`
`leave_request_audit_logs`.`to_status`
`leave_request_audit_logs`.`acted_by`
`leave_request_audit_logs`.`remarks`
`leave_request_audit_logs`.`ip_address`
`leave_request_audit_logs`.`user_agent`
`leave_request_audit_logs`.`created_at`
`leave_requests`.*
`leave_requests`.`id`
`leave_requests`.`employee_id`
`leave_requests`.`leave_type_id`
`leave_requests`.`start_date`
`leave_requests`.`end_date`
`leave_requests`.`total_days`
`leave_requests`.`reason`
`leave_requests`.`attachment`
`leave_requests`.`status`
`leave_requests`.`approved_by`
`leave_requests`.`approved_date`
`leave_requests`.`remarks`
`leave_requests`.`balance_applied`
`leave_requests`.`created_at`
`leave_types`.*
`leave_types`.`id`
`leave_types`.`leave_name`
`leave_types`.`description`
`leave_types`.`is_paid`
`leave_types`.`default_days`
`logistics_audit_logs`.*
`logistics_audit_logs`.`id`
`logistics_audit_logs`.`module`
`logistics_audit_logs`.`record_id`
`logistics_audit_logs`.`action`
`logistics_audit_logs`.`old_value`
`logistics_audit_logs`.`new_value`
`logistics_audit_logs`.`remarks`
`logistics_audit_logs`.`created_by`
`logistics_audit_logs`.`created_at`
`logistics_billing`.*
`logistics_billing`.`id`
`logistics_billing`.`invoice_no`
`logistics_billing`.`client_id`
`logistics_billing`.`shipment_id`
`logistics_billing`.`dispatch_id`
`logistics_billing`.`billing_type`
`logistics_billing`.`income_amount`
`logistics_billing`.`expense_amount`
`logistics_billing`.`billing_status`
`logistics_billing`.`due_date`
`logistics_billing`.`notes`
`logistics_billing`.`posted_to_accounting`
`logistics_billing`.`accounting_reference`
`logistics_billing`.`created_by`
`logistics_billing`.`updated_by`
`logistics_billing`.`created_at`
`logistics_billing`.`updated_at`
`logistics_clients`.*
`logistics_clients`.`id`
`logistics_clients`.`client_code`
`logistics_clients`.`company_name`
`logistics_clients`.`contact_person`
`logistics_clients`.`contact_number`
`logistics_clients`.`email`
`logistics_clients`.`address`
`logistics_clients`.`status`
`logistics_clients`.`created_by`
`logistics_clients`.`updated_by`
`logistics_clients`.`created_at`
`logistics_clients`.`updated_at`
`logistics_consolidation_batches`.*
`logistics_consolidation_batches`.`id`
`logistics_consolidation_batches`.`batch_no`
`logistics_consolidation_batches`.`batch_name`
`logistics_consolidation_batches`.`status`
`logistics_consolidation_batches`.`dispatch_ref_no`
`logistics_consolidation_batches`.`remarks`
`logistics_consolidation_batches`.`created_by`
`logistics_consolidation_batches`.`updated_by`
`logistics_consolidation_batches`.`created_at`
`logistics_consolidation_batches`.`updated_at`
`logistics_consolidation_items`.*
`logistics_consolidation_items`.`id`
`logistics_consolidation_items`.`batch_id`
`logistics_consolidation_items`.`shipment_id`
`logistics_consolidation_items`.`created_at`
`logistics_customs_clearances`.*
`logistics_customs_clearances`.`id`
`logistics_customs_clearances`.`shipment_id`
`logistics_customs_clearances`.`customs_status`
`logistics_customs_clearances`.`document_checklist`
`logistics_customs_clearances`.`remarks`
`logistics_customs_clearances`.`created_by`
`logistics_customs_clearances`.`updated_by`
`logistics_customs_clearances`.`created_at`
`logistics_customs_clearances`.`updated_at`
`logistics_customs_logs`.*
`logistics_customs_logs`.`id`
`logistics_customs_logs`.`clearance_id`
`logistics_customs_logs`.`shipment_id`
`logistics_customs_logs`.`old_status`
`logistics_customs_logs`.`new_status`
`logistics_customs_logs`.`remarks`
`logistics_customs_logs`.`updated_by`
`logistics_customs_logs`.`created_at`
`logistics_dispatches`.*
`logistics_dispatches`.`id`
`logistics_dispatches`.`dispatch_no`
`logistics_dispatches`.`batch_id`
`logistics_dispatches`.`shipment_id`
`logistics_dispatches`.`delivery_schedule`
`logistics_dispatches`.`truck_id`
`logistics_dispatches`.`driver_employee_id`
`logistics_dispatches`.`pickup_location`
`logistics_dispatches`.`delivery_address`
`logistics_dispatches`.`delivery_status`
`logistics_dispatches`.`proof_of_delivery`
`logistics_dispatches`.`delivery_photo`
`logistics_dispatches`.`signature_image`
`logistics_dispatches`.`remarks`
`logistics_dispatches`.`created_by`
`logistics_dispatches`.`updated_by`
`logistics_dispatches`.`created_at`
`logistics_dispatches`.`updated_at`
`logistics_shipments`.*
`logistics_shipments`.`id`
`logistics_shipments`.`shipment_ref_no`
`logistics_shipments`.`client_id`
`logistics_shipments`.`transaction_type`
`logistics_shipments`.`container_no`
`logistics_shipments`.`bl_awb_no`
`logistics_shipments`.`cargo_description`
`logistics_shipments`.`quantity`
`logistics_shipments`.`weight_kg`
`logistics_shipments`.`cbm`
`logistics_shipments`.`date_received`
`logistics_shipments`.`warehouse_location`
`logistics_shipments`.`current_status`
`logistics_shipments`.`remarks`
`logistics_shipments`.`created_by`
`logistics_shipments`.`updated_by`
`logistics_shipments`.`created_at`
`logistics_shipments`.`updated_at`
`logistics_warehouse_movements`.*
`logistics_warehouse_movements`.`id`
`logistics_warehouse_movements`.`shipment_id`
`logistics_warehouse_movements`.`movement_type`
`logistics_warehouse_movements`.`from_location`
`logistics_warehouse_movements`.`to_location`
`logistics_warehouse_movements`.`status_from`
`logistics_warehouse_movements`.`status_to`
`logistics_warehouse_movements`.`remarks`
`logistics_warehouse_movements`.`moved_by`
`logistics_warehouse_movements`.`created_at`
`mobile_push_tokens`.*
`mobile_push_tokens`.`id`
`mobile_push_tokens`.`user_id`
`mobile_push_tokens`.`employee_id`
`mobile_push_tokens`.`expo_push_token`
`mobile_push_tokens`.`platform`
`mobile_push_tokens`.`device_name`
`mobile_push_tokens`.`app_mode`
`mobile_push_tokens`.`is_active`
`mobile_push_tokens`.`last_seen_at`
`mobile_push_tokens`.`created_at`
`mobile_push_tokens`.`updated_at`
`offboarding_records`.*
`offboarding_records`.`id`
`offboarding_records`.`employee_id`
`offboarding_records`.`trigger_type`
`offboarding_records`.`resignation_date`
`offboarding_records`.`last_working_day`
`offboarding_records`.`reason`
`offboarding_records`.`final_pay_request_status`
`offboarding_records`.`status`
`offboarding_records`.`created_by`
`offboarding_records`.`created_at`
`offboarding_records`.`updated_at`
`official_business_requests`.*
`official_business_requests`.`id`
`official_business_requests`.`employee_id`
`official_business_requests`.`ob_date`
`official_business_requests`.`start_time`
`official_business_requests`.`end_time`
`official_business_requests`.`location`
`official_business_requests`.`client_company`
`official_business_requests`.`purpose`
`official_business_requests`.`attachment`
`official_business_requests`.`credited_hours`
`official_business_requests`.`status`
`official_business_requests`.`supervisor_by`
`official_business_requests`.`supervisor_at`
`official_business_requests`.`approved_by`
`official_business_requests`.`approved_at`
`official_business_requests`.`remarks`
`official_business_requests`.`created_by`
`official_business_requests`.`created_at`
`official_business_requests`.`updated_at`
`order_deliveries`.*
`order_deliveries`.`id`
`order_deliveries`.`allocation_no`
`order_deliveries`.`order_id`
`order_deliveries`.`truck_id`
`order_deliveries`.`scheduled_date`
`order_deliveries`.`route_sequence`
`order_deliveries`.`payment_mode`
`order_deliveries`.`cash_to_collect`
`order_deliveries`.`pickup_location`
`order_deliveries`.`dropoff_location`
`order_deliveries`.`trip_type`
`order_deliveries`.`route_profile`
`order_deliveries`.`estimated_one_way_distance_km`
`order_deliveries`.`estimated_total_distance_km`
`order_deliveries`.`estimated_cargo_weight_kg`
`order_deliveries`.`load_utilization_percent`
`order_deliveries`.`truck_km_per_liter`
`order_deliveries`.`recommended_km_per_liter`
`order_deliveries`.`diesel_price_per_liter`
`order_deliveries`.`cost_per_km`
`order_deliveries`.`estimated_fuel_liters`
`order_deliveries`.`estimated_fuel_cost`
`order_deliveries`.`actual_start_odometer`
`order_deliveries`.`actual_end_odometer`
`order_deliveries`.`actual_distance_km`
`order_deliveries`.`actual_fuel_liters`
`order_deliveries`.`actual_km_per_liter`
`order_deliveries`.`actual_fuel_cost`
`order_deliveries`.`fuel_variance`
`order_deliveries`.`distance_variance`
`order_deliveries`.`status`
`order_deliveries`.`notes`
`order_deliveries`.`cancel_reason`
`order_deliveries`.`canceled_at`
`order_deliveries`.`canceled_by`
`order_deliveries`.`proof_path`
`order_deliveries`.`user_id`
`order_deliveries`.`created_at`
`order_delivery_expenses`.*
`order_delivery_expenses`.`id`
`order_delivery_expenses`.`order_delivery_id`
`order_delivery_expenses`.`expense_name`
`order_delivery_expenses`.`amount`
`order_delivery_expenses`.`created_at`
`order_delivery_item_returns`.*
`order_delivery_item_returns`.`id`
`order_delivery_item_returns`.`order_delivery_id`
`order_delivery_item_returns`.`order_delivery_item_id`
`order_delivery_item_returns`.`product_id`
`order_delivery_item_returns`.`qty_returned`
`order_delivery_item_returns`.`reason`
`order_delivery_item_returns`.`returned_by`
`order_delivery_item_returns`.`returned_at`
`order_delivery_items`.*
`order_delivery_items`.`id`
`order_delivery_items`.`order_delivery_id`
`order_delivery_items`.`order_item_id`
`order_delivery_items`.`product_id`
`order_delivery_items`.`qty_allocated`
`order_delivery_itinerary`.*
`order_delivery_itinerary`.`id`
`order_delivery_itinerary`.`order_delivery_id`
`order_delivery_itinerary`.`stop_no`
`order_delivery_itinerary`.`stop_name`
`order_delivery_itinerary`.`created_at`
`order_delivery_status_logs`.*
`order_delivery_status_logs`.`id`
`order_delivery_status_logs`.`order_delivery_id`
`order_delivery_status_logs`.`from_status`
`order_delivery_status_logs`.`to_status`
`order_delivery_status_logs`.`note`
`order_delivery_status_logs`.`changed_by`
`order_delivery_status_logs`.`changed_at`
`orders`.*
`orders`.`id`
`orders`.`bill_no`
`orders`.`company_name`
`orders`.`customer_name`
`orders`.`customer_address`
`orders`.`customer_phone`
`orders`.`delivery_date`
`orders`.`delivery_type`
`orders`.`date_time`
`orders`.`gross_amount`
`orders`.`service_charge_rate`
`orders`.`service_charge`
`orders`.`vat_charge_rate`
`orders`.`vat_charge`
`orders`.`tax_inclusive`
`orders`.`tax_exclusive`
`orders`.`net_amount`
`orders`.`deliveryfee`
`orders`.`discount`
`orders`.`paid_status`
`orders`.`return_note`
`orders`.`payment_proof`
`orders`.`modeofpayment`
`orders`.`record_type`
`orders`.`approval_status`
`orders`.`approved_at`
`orders`.`approved_by`
`orders`.`source_quotation_id`
`orders`.`quotation_valid_until`
`orders`.`user_id`
`orders`.`created_at`
`orders_item`.*
`orders_item`.`id`
`orders_item`.`order_id`
`orders_item`.`product_id`
`orders_item`.`product_name`
`orders_item`.`qty`
`orders_item`.`rate`
`orders_item`.`amount`
`overtime_requests`.*
`overtime_requests`.`id`
`overtime_requests`.`employee_id`
`overtime_requests`.`ot_date`
`overtime_requests`.`start_time`
`overtime_requests`.`end_time`
`overtime_requests`.`reason`
`overtime_requests`.`attachment`
`overtime_requests`.`requested_hours`
`overtime_requests`.`approved_hours`
`overtime_requests`.`payable_hours`
`overtime_requests`.`is_pre_shift`
`overtime_requests`.`status`
`overtime_requests`.`supervisor_by`
`overtime_requests`.`supervisor_at`
`overtime_requests`.`approved_by`
`overtime_requests`.`approved_at`
`overtime_requests`.`remarks`
`overtime_requests`.`created_by`
`overtime_requests`.`created_at`
`overtime_requests`.`updated_at`
`payables`.*
`payables`.`id`
`payables`.`supplier_name`
`payables`.`reference_no`
`payables`.`delivery_id`
`payables`.`due_date`
`payables`.`amount`
`payables`.`balance`
`payables`.`status`
`payables`.`notes`
`payables`.`created_by`
`payables`.`updated_by`
`payables`.`created_at`
`payables`.`updated_at`
`payments`.*
`payments`.`id`
`payments`.`payment_no`
`payments`.`payment_date`
`payments`.`direction`
`payments`.`payer_type`
`payments`.`payer_name`
`payments`.`reference_type`
`payments`.`reference_id`
`payments`.`cash_account_id`
`payments`.`counter_account_id`
`payments`.`amount`
`payments`.`payment_method`
`payments`.`reference_no`
`payments`.`notes`
`payments`.`transaction_id`
`payments`.`created_by`
`payments`.`updated_by`
`payments`.`created_at`
`payments`.`updated_at`
`payroll_activity_logs`.*
`payroll_activity_logs`.`id`
`payroll_activity_logs`.`cutoff_id`
`payroll_activity_logs`.`record_type`
`payroll_activity_logs`.`record_id`
`payroll_activity_logs`.`action`
`payroll_activity_logs`.`user_id`
`payroll_activity_logs`.`details_json`
`payroll_activity_logs`.`created_at`
`payroll_adjustments`.*
`payroll_adjustments`.`id`
`payroll_adjustments`.`payroll_id`
`payroll_adjustments`.`cutoff_id`
`payroll_adjustments`.`employee_id`
`payroll_adjustments`.`adjustment_type`
`payroll_adjustments`.`amount`
`payroll_adjustments`.`reason`
`payroll_adjustments`.`status`
`payroll_adjustments`.`created_by`
`payroll_adjustments`.`approved_by`
`payroll_adjustments`.`approved_at`
`payroll_adjustments`.`created_at`
`payroll_adjustments`.`updated_at`
`payroll_details`.*
`payroll_details`.`id`
`payroll_details`.`payroll_id`
`payroll_details`.`detail_type`
`payroll_details`.`label`
`payroll_details`.`quantity`
`payroll_details`.`rate`
`payroll_details`.`amount`
`payroll_details`.`metadata_json`
`payroll_details`.`created_at`
`payroll_office_entries`.*
`payroll_office_entries`.`id`
`payroll_office_entries`.`cutoff_id`
`payroll_office_entries`.`employee_id`
`payroll_office_entries`.`daily_rate`
`payroll_office_entries`.`paid_days`
`payroll_office_entries`.`late_undertime_deduction`
`payroll_office_entries`.`overtime`
`payroll_office_entries`.`allowance`
`payroll_office_entries`.`incentive`
`payroll_office_entries`.`deduction`
`payroll_office_entries`.`remarks`
`payroll_office_entries`.`encoded_by`
`payroll_office_entries`.`created_at`
`payroll_office_entries`.`updated_at`
`payroll_settings`.*
`payroll_settings`.`id`
`payroll_settings`.`setting_key`
`payroll_settings`.`setting_value`
`payroll_settings`.`value_type`
`payroll_settings`.`effective_start`
`payroll_settings`.`effective_end`
`payroll_settings`.`description`
`payroll_settings`.`updated_by`
`payroll_settings`.`created_at`
`payroll_settings`.`updated_at`
`payroll_trip_entries`.*
`payroll_trip_entries`.`id`
`payroll_trip_entries`.`cutoff_id`
`payroll_trip_entries`.`employee_id`
`payroll_trip_entries`.`raw_name`
`payroll_trip_entries`.`corrected_name`
`payroll_trip_entries`.`position`
`payroll_trip_entries`.`truck_number`
`payroll_trip_entries`.`container_number`
`payroll_trip_entries`.`area_destination`
`payroll_trip_entries`.`rate`
`payroll_trip_entries`.`entry_type`
`payroll_trip_entries`.`remarks`
`payroll_trip_entries`.`encoded_by`
`payroll_trip_entries`.`created_at`
`payroll_trip_entries`.`updated_at`
`payroll_trip_rates`.*
`payroll_trip_rates`.`id`
`payroll_trip_rates`.`destination_area`
`payroll_trip_rates`.`truck_type`
`payroll_trip_rates`.`km`
`payroll_trip_rates`.`customer`
`payroll_trip_rates`.`standard_trip_rate`
`payroll_trip_rates`.`driver_rate_type`
`payroll_trip_rates`.`driver_rate_value`
`payroll_trip_rates`.`helper_rate_type`
`payroll_trip_rates`.`helper_rate_value`
`payroll_trip_rates`.`checker_rate_type`
`payroll_trip_rates`.`checker_rate_value`
`payroll_trip_rates`.`food_allowance`
`payroll_trip_rates`.`toll_other_expense`
`payroll_trip_rates`.`status`
`payroll_trip_rates`.`created_at`
`payroll_trip_rates`.`updated_at`
`payslips`.*
`payslips`.`id`
`payslips`.`payroll_id`
`payslips`.`employee_id`
`payslips`.`cutoff_id`
`payslips`.`token_hash`
`payslips`.`generated_by`
`payslips`.`generated_at`
`payslips`.`viewed_at`
`payslips`.`status`
`performance_evaluations`.*
`performance_evaluations`.`id`
`performance_evaluations`.`employee_id`
`performance_evaluations`.`evaluation_type`
`performance_evaluations`.`period_start`
`performance_evaluations`.`period_end`
`performance_evaluations`.`evaluator_id`
`performance_evaluations`.`final_score`
`performance_evaluations`.`comments`
`performance_evaluations`.`strengths`
`performance_evaluations`.`areas_for_improvement`
`performance_evaluations`.`recommendation`
`performance_evaluations`.`attachment`
`performance_evaluations`.`status`
`performance_evaluations`.`created_at`
`performance_evaluations`.`updated_at`
`product_history`.*
`product_history`.`id`
`product_history`.`product_id`
`product_history`.`user_id`
`product_history`.`before_data`
`product_history`.`after_data`
`product_history`.`created_at`
`product_history`.`action`
`product_history`.`reference`
`product_history`.`qty_change`
`products`.*
`products`.`id`
`products`.`name`
`products`.`sku`
`products`.`price`
`products`.`qty`
`products`.`image`
`products`.`description`
`products`.`attribute_value_id`
`products`.`brand_id`
`products`.`category_id`
`products`.`store_id`
`products`.`availability`
`products`.`kilogram`
`products`.`unit_item`
`products`.`dealerprice`
`products`.`pricing_type`
`products`.`dealer_price_per_kg`
`profile_update_requests`.*
`profile_update_requests`.`id`
`profile_update_requests`.`employee_id`
`profile_update_requests`.`field_name`
`profile_update_requests`.`old_value`
`profile_update_requests`.`new_value`
`profile_update_requests`.`proof_attachment`
`profile_update_requests`.`reason`
`profile_update_requests`.`status`
`profile_update_requests`.`created_by`
`profile_update_requests`.`reviewed_by`
`profile_update_requests`.`reviewed_at`
`profile_update_requests`.`remarks`
`profile_update_requests`.`created_at`
`profile_update_requests`.`updated_at`
`receivables`.*
`receivables`.`id`
`receivables`.`customer_name`
`receivables`.`reference_no`
`receivables`.`order_id`
`receivables`.`due_date`
`receivables`.`amount`
`receivables`.`balance`
`receivables`.`status`
`receivables`.`notes`
`receivables`.`created_by`
`receivables`.`updated_by`
`receivables`.`created_at`
`receivables`.`updated_at`
`recruitment_applicant_documents`.*
`recruitment_applicant_documents`.`id`
`recruitment_applicant_documents`.`applicant_id`
`recruitment_applicant_documents`.`document_type`
`recruitment_applicant_documents`.`title`
`recruitment_applicant_documents`.`original_filename`
`recruitment_applicant_documents`.`stored_filename`
`recruitment_applicant_documents`.`file_path`
`recruitment_applicant_documents`.`file_extension`
`recruitment_applicant_documents`.`mime_type`
`recruitment_applicant_documents`.`file_size`
`recruitment_applicant_documents`.`status`
`recruitment_applicant_documents`.`uploaded_by`
`recruitment_applicant_documents`.`created_at`
`recruitment_applicant_documents`.`updated_at`
`recruitment_applicants`.*
`recruitment_applicants`.`id`
`recruitment_applicants`.`applicant_code`
`recruitment_applicants`.`first_name`
`recruitment_applicants`.`middle_name`
`recruitment_applicants`.`last_name`
`recruitment_applicants`.`suffix`
`recruitment_applicants`.`birthdate`
`recruitment_applicants`.`gender`
`recruitment_applicants`.`civil_status`
`recruitment_applicants`.`contact_number`
`recruitment_applicants`.`email`
`recruitment_applicants`.`address`
`recruitment_applicants`.`position_id`
`recruitment_applicants`.`preferred_company`
`recruitment_applicants`.`expected_salary`
`recruitment_applicants`.`availability_date`
`recruitment_applicants`.`employment_history`
`recruitment_applicants`.`educational_background`
`recruitment_applicants`.`skills`
`recruitment_applicants`.`certifications`
`recruitment_applicants`.`driver_license_details`
`recruitment_applicants`.`work_experience`
`recruitment_applicants`.`referral_source`
`recruitment_applicants`.`remarks`
`recruitment_applicants`.`status`
`recruitment_applicants`.`consent_accepted`
`recruitment_applicants`.`consent_accepted_at`
`recruitment_applicants`.`consent_ip`
`recruitment_applicants`.`consent_version`
`recruitment_applicants`.`converted_employee_id`
`recruitment_applicants`.`created_at`
`recruitment_applicants`.`updated_at`
`recruitment_consent_logs`.*
`recruitment_consent_logs`.`id`
`recruitment_consent_logs`.`applicant_id`
`recruitment_consent_logs`.`interview_session_id`
`recruitment_consent_logs`.`consent_type`
`recruitment_consent_logs`.`consent_version`
`recruitment_consent_logs`.`consent_text`
`recruitment_consent_logs`.`ip_address`
`recruitment_consent_logs`.`user_agent`
`recruitment_consent_logs`.`accepted_at`
`recruitment_email_logs`.*
`recruitment_email_logs`.`id`
`recruitment_email_logs`.`applicant_id`
`recruitment_email_logs`.`email_type`
`recruitment_email_logs`.`recipient_email`
`recruitment_email_logs`.`subject`
`recruitment_email_logs`.`body_snapshot`
`recruitment_email_logs`.`status`
`recruitment_email_logs`.`error_message`
`recruitment_email_logs`.`sent_by`
`recruitment_email_logs`.`sent_at`
`recruitment_email_logs`.`created_at`
`recruitment_email_templates`.*
`recruitment_email_templates`.`id`
`recruitment_email_templates`.`template_name`
`recruitment_email_templates`.`stage`
`recruitment_email_templates`.`subject`
`recruitment_email_templates`.`body`
`recruitment_email_templates`.`status`
`recruitment_email_templates`.`created_by`
`recruitment_email_templates`.`updated_by`
`recruitment_email_templates`.`created_at`
`recruitment_email_templates`.`updated_at`
`recruitment_final_interviews`.*
`recruitment_final_interviews`.`id`
`recruitment_final_interviews`.`applicant_id`
`recruitment_final_interviews`.`interview_date`
`recruitment_final_interviews`.`interview_time`
`recruitment_final_interviews`.`interview_type`
`recruitment_final_interviews`.`location_or_link`
`recruitment_final_interviews`.`interviewer_id`
`recruitment_final_interviews`.`remarks`
`recruitment_final_interviews`.`status`
`recruitment_final_interviews`.`created_by`
`recruitment_final_interviews`.`created_at`
`recruitment_final_interviews`.`updated_at`
`recruitment_interview_event_logs`.*
`recruitment_interview_event_logs`.`id`
`recruitment_interview_event_logs`.`interview_session_id`
`recruitment_interview_event_logs`.`applicant_id`
`recruitment_interview_event_logs`.`question_id`
`recruitment_interview_event_logs`.`event_type`
`recruitment_interview_event_logs`.`event_time`
`recruitment_interview_event_logs`.`duration_seconds`
`recruitment_interview_event_logs`.`metadata`
`recruitment_interview_event_logs`.`ip_address`
`recruitment_interview_event_logs`.`user_agent`
`recruitment_interview_event_logs`.`created_at`
`recruitment_interview_integrity_summary`.*
`recruitment_interview_integrity_summary`.`id`
`recruitment_interview_integrity_summary`.`interview_session_id`
`recruitment_interview_integrity_summary`.`applicant_id`
`recruitment_interview_integrity_summary`.`tab_switch_count`
`recruitment_interview_integrity_summary`.`total_away_seconds`
`recruitment_interview_integrity_summary`.`fullscreen_exit_count`
`recruitment_interview_integrity_summary`.`copy_attempt_count`
`recruitment_interview_integrity_summary`.`right_click_attempt_count`
`recruitment_interview_integrity_summary`.`suspicious_key_count`
`recruitment_interview_integrity_summary`.`device_interruption_count`
`recruitment_interview_integrity_summary`.`duplicate_session_count`
`recruitment_interview_integrity_summary`.`early_stop_count`
`recruitment_interview_integrity_summary`.`too_short_answer_count`
`recruitment_interview_integrity_summary`.`failed_upload_count`
`recruitment_interview_integrity_summary`.`invalid_step_count`
`recruitment_interview_integrity_summary`.`no_face_count`
`recruitment_interview_integrity_summary`.`multiple_face_count`
`recruitment_interview_integrity_summary`.`risk_score`
`recruitment_interview_integrity_summary`.`risk_level`
`recruitment_interview_integrity_summary`.`hr_review_status`
`recruitment_interview_integrity_summary`.`hr_integrity_remarks`
`recruitment_interview_integrity_summary`.`first_ip_address`
`recruitment_interview_integrity_summary`.`last_ip_address`
`recruitment_interview_integrity_summary`.`first_user_agent`
`recruitment_interview_integrity_summary`.`last_user_agent`
`recruitment_interview_integrity_summary`.`browser_name`
`recruitment_interview_integrity_summary`.`operating_system`
`recruitment_interview_integrity_summary`.`device_type`
`recruitment_interview_integrity_summary`.`screen_size`
`recruitment_interview_integrity_summary`.`timezone`
`recruitment_interview_integrity_summary`.`started_at`
`recruitment_interview_integrity_summary`.`completed_at`
`recruitment_interview_integrity_summary`.`created_at`
`recruitment_interview_integrity_summary`.`updated_at`
`recruitment_interview_progress`.*
`recruitment_interview_progress`.`id`
`recruitment_interview_progress`.`interview_session_id`
`recruitment_interview_progress`.`applicant_id`
`recruitment_interview_progress`.`current_question_id`
`recruitment_interview_progress`.`current_question_order`
`recruitment_interview_progress`.`completed_questions_count`
`recruitment_interview_progress`.`status`
`recruitment_interview_progress`.`current_step`
`recruitment_interview_progress`.`current_question_started_at`
`recruitment_interview_progress`.`recording_state`
`recruitment_interview_progress`.`last_activity_at`
`recruitment_interview_progress`.`updated_at`
`recruitment_interview_sessions`.*
`recruitment_interview_sessions`.`id`
`recruitment_interview_sessions`.`applicant_id`
`recruitment_interview_sessions`.`position_id`
`recruitment_interview_sessions`.`token`
`recruitment_interview_sessions`.`token_expires_at`
`recruitment_interview_sessions`.`status`
`recruitment_interview_sessions`.`expires_at`
`recruitment_interview_sessions`.`allow_retake`
`recruitment_interview_sessions`.`retakes_allowed`
`recruitment_interview_sessions`.`allow_preview`
`recruitment_interview_sessions`.`require_all_questions`
`recruitment_interview_sessions`.`consent_accepted`
`recruitment_interview_sessions`.`consent_accepted_at`
`recruitment_interview_sessions`.`consent_ip`
`recruitment_interview_sessions`.`consent_user_agent`
`recruitment_interview_sessions`.`applicant_agreed_interview_rules`
`recruitment_interview_sessions`.`rules_agreed_at`
`recruitment_interview_sessions`.`rules_agreed_ip`
`recruitment_interview_sessions`.`rules_agreed_user_agent`
`recruitment_interview_sessions`.`first_client_id`
`recruitment_interview_sessions`.`active_client_id`
`recruitment_interview_sessions`.`active_client_seen_at`
`recruitment_interview_sessions`.`last_device_info`
`recruitment_interview_sessions`.`created_by`
`recruitment_interview_sessions`.`started_at`
`recruitment_interview_sessions`.`completed_at`
`recruitment_interview_sessions`.`created_at`
`recruitment_interview_sessions`.`updated_at`
`recruitment_management_review_logs`.*
`recruitment_management_review_logs`.`id`
`recruitment_management_review_logs`.`applicant_id`
`recruitment_management_review_logs`.`token_id`
`recruitment_management_review_logs`.`action`
`recruitment_management_review_logs`.`reviewer_name`
`recruitment_management_review_logs`.`rating`
`recruitment_management_review_logs`.`remarks`
`recruitment_management_review_logs`.`recommendation`
`recruitment_management_review_logs`.`ip_address`
`recruitment_management_review_logs`.`user_agent`
`recruitment_management_review_logs`.`created_at`
`recruitment_management_review_tokens`.*
`recruitment_management_review_tokens`.`id`
`recruitment_management_review_tokens`.`applicant_id`
`recruitment_management_review_tokens`.`token`
`recruitment_management_review_tokens`.`expires_at`
`recruitment_management_review_tokens`.`status`
`recruitment_management_review_tokens`.`allow_rating`
`recruitment_management_review_tokens`.`allow_remarks`
`recruitment_management_review_tokens`.`show_question_videos`
`recruitment_management_review_tokens`.`show_applicant_details`
`recruitment_management_review_tokens`.`show_documents`
`recruitment_management_review_tokens`.`created_by`
`recruitment_management_review_tokens`.`revoked_by`
`recruitment_management_review_tokens`.`revoked_at`
`recruitment_management_review_tokens`.`created_at`
`recruitment_management_review_tokens`.`updated_at`
`recruitment_positions`.*
`recruitment_positions`.`id`
`recruitment_positions`.`position_title`
`recruitment_positions`.`company`
`recruitment_positions`.`department`
`recruitment_positions`.`job_description`
`recruitment_positions`.`qualifications`
`recruitment_positions`.`requirements`
`recruitment_positions`.`employment_type`
`recruitment_positions`.`vacancy_count`
`recruitment_positions`.`status`
`recruitment_positions`.`created_by`
`recruitment_positions`.`created_at`
`recruitment_positions`.`updated_at`
`recruitment_question_video_versions`.*
`recruitment_question_video_versions`.`id`
`recruitment_question_video_versions`.`question_id`
`recruitment_question_video_versions`.`question_video_path`
`recruitment_question_video_versions`.`question_video_original_filename`
`recruitment_question_video_versions`.`question_video_stored_filename`
`recruitment_question_video_versions`.`question_video_mime_type`
`recruitment_question_video_versions`.`question_video_size`
`recruitment_question_video_versions`.`question_video_duration_seconds`
`recruitment_question_video_versions`.`replaced_by`
`recruitment_question_video_versions`.`replaced_at`
`recruitment_question_view_logs`.*
`recruitment_question_view_logs`.`id`
`recruitment_question_view_logs`.`interview_session_id`
`recruitment_question_view_logs`.`applicant_id`
`recruitment_question_view_logs`.`question_id`
`recruitment_question_view_logs`.`viewed_at`
`recruitment_question_view_logs`.`completed_full_watch`
`recruitment_question_view_logs`.`replay_count`
`recruitment_question_view_logs`.`ip_address`
`recruitment_question_view_logs`.`user_agent`
`recruitment_question_view_logs`.`created_at`
`recruitment_questions`.*
`recruitment_questions`.`id`
`recruitment_questions`.`position_id`
`recruitment_questions`.`company`
`recruitment_questions`.`question_text`
`recruitment_questions`.`question_type`
`recruitment_questions`.`question_mode`
`recruitment_questions`.`question_video_path`
`recruitment_questions`.`question_video_original_filename`
`recruitment_questions`.`question_video_stored_filename`
`recruitment_questions`.`question_video_mime_type`
`recruitment_questions`.`question_video_size`
`recruitment_questions`.`question_video_duration_seconds`
`recruitment_questions`.`show_text_overlay`
`recruitment_questions`.`text_overlay_position`
`recruitment_questions`.`answer_time_limit_seconds`
`recruitment_questions`.`allow_replay`
`recruitment_questions`.`max_replay_count`
`recruitment_questions`.`require_full_watch_before_answer`
`recruitment_questions`.`allow_answer_retake`
`recruitment_questions`.`max_answer_retake_count`
`recruitment_questions`.`time_limit_seconds`
`recruitment_questions`.`sort_order`
`recruitment_questions`.`is_required`
`recruitment_questions`.`status`
`recruitment_questions`.`created_by`
`recruitment_questions`.`updated_by`
`recruitment_questions`.`created_at`
`recruitment_questions`.`updated_at`
`recruitment_review_scores`.*
`recruitment_review_scores`.`id`
`recruitment_review_scores`.`review_id`
`recruitment_review_scores`.`applicant_id`
`recruitment_review_scores`.`interview_session_id`
`recruitment_review_scores`.`reviewer_id`
`recruitment_review_scores`.`question_id`
`recruitment_review_scores`.`rating`
`recruitment_review_scores`.`remarks`
`recruitment_review_scores`.`pass_fail_status`
`recruitment_review_scores`.`created_at`
`recruitment_review_scores`.`updated_at`
`recruitment_reviews`.*
`recruitment_reviews`.`id`
`recruitment_reviews`.`applicant_id`
`recruitment_reviews`.`reviewer_id`
`recruitment_reviews`.`technical_rating`
`recruitment_reviews`.`communication_rating`
`recruitment_reviews`.`experience_rating`
`recruitment_reviews`.`professionalism_rating`
`recruitment_reviews`.`overall_rating`
`recruitment_reviews`.`recommendation`
`recruitment_reviews`.`remarks`
`recruitment_reviews`.`created_at`
`recruitment_reviews`.`updated_at`
`recruitment_settings`.*
`recruitment_settings`.`id`
`recruitment_settings`.`setting_key`
`recruitment_settings`.`setting_value`
`recruitment_settings`.`value_type`
`recruitment_settings`.`description`
`recruitment_settings`.`updated_by`
`recruitment_settings`.`created_at`
`recruitment_settings`.`updated_at`
`recruitment_status_logs`.*
`recruitment_status_logs`.`id`
`recruitment_status_logs`.`applicant_id`
`recruitment_status_logs`.`old_status`
`recruitment_status_logs`.`new_status`
`recruitment_status_logs`.`changed_by`
`recruitment_status_logs`.`remarks`
`recruitment_status_logs`.`created_at`
`recruitment_video_answers`.*
`recruitment_video_answers`.`id`
`recruitment_video_answers`.`interview_session_id`
`recruitment_video_answers`.`applicant_id`
`recruitment_video_answers`.`question_id`
`recruitment_video_answers`.`question_shown_at`
`recruitment_video_answers`.`question_video_started_at`
`recruitment_video_answers`.`question_video_ended_at`
`recruitment_video_answers`.`countdown_started_at`
`recruitment_video_answers`.`recording_started_at`
`recruitment_video_answers`.`recording_ended_at`
`recruitment_video_answers`.`auto_started_recording`
`recruitment_video_answers`.`recording_stop_reason`
`recruitment_video_answers`.`upload_started_at`
`recruitment_video_answers`.`upload_completed_at`
`recruitment_video_answers`.`uploaded_at`
`recruitment_video_answers`.`is_early_submitted`
`recruitment_video_answers`.`confirmed_short_answer`
`recruitment_video_answers`.`answer_video_path`
`recruitment_video_answers`.`answer_video_original_filename`
`recruitment_video_answers`.`answer_video_stored_filename`
`recruitment_video_answers`.`answer_video_mime_type`
`recruitment_video_answers`.`answer_video_size`
`recruitment_video_answers`.`answer_duration_seconds`
`recruitment_video_answers`.`retake_count`
`recruitment_video_answers`.`video_file_path`
`recruitment_video_answers`.`video_filename`
`recruitment_video_answers`.`video_size`
`recruitment_video_answers`.`mime_type`
`recruitment_video_answers`.`duration_seconds`
`recruitment_video_answers`.`attempt_no`
`recruitment_video_answers`.`recorded_at`
`recruitment_video_answers`.`submitted_at`
`recruitment_video_answers`.`upload_status`
`recruitment_video_answers`.`status`
`recruitment_video_answers`.`created_at`
`recruitment_video_answers`.`updated_at`
`schedule_change_logs`.*
`schedule_change_logs`.`id`
`schedule_change_logs`.`employee_id`
`schedule_change_logs`.`scope_type`
`schedule_change_logs`.`scope_value`
`schedule_change_logs`.`old_schedule_id`
`schedule_change_logs`.`new_schedule_id`
`schedule_change_logs`.`effective_date`
`schedule_change_logs`.`changed_by`
`schedule_change_logs`.`reason`
`schedule_change_logs`.`created_at`
`schedule_scope_assignments`.*
`schedule_scope_assignments`.`id`
`schedule_scope_assignments`.`scope_type`
`schedule_scope_assignments`.`scope_value`
`schedule_scope_assignments`.`schedule_id`
`schedule_scope_assignments`.`effective_date`
`schedule_scope_assignments`.`end_date`
`schedule_scope_assignments`.`assigned_by`
`schedule_scope_assignments`.`remarks`
`schedule_scope_assignments`.`status`
`schedule_scope_assignments`.`created_at`
`schedule_scope_assignments`.`updated_at`
`stock_adjustments`.*
`stock_adjustments`.`id`
`stock_adjustments`.`product_id`
`stock_adjustments`.`old_qty`
`stock_adjustments`.`new_qty`
`stock_adjustments`.`difference`
`stock_adjustments`.`reason`
`stock_adjustments`.`user_id`
`stock_adjustments`.`created_at`
`stores`.*
`stores`.`id`
`stores`.`name`
`stores`.`active`
`system_settings`.*
`system_settings`.`id`
`system_settings`.`setting_key`
`system_settings`.`setting_value`
`system_settings`.`value_type`
`system_settings`.`description`
`system_settings`.`updated_by`
`system_settings`.`created_at`
`system_settings`.`updated_at`
`transaction_lines`.*
`transaction_lines`.`id`
`transaction_lines`.`transaction_id`
`transaction_lines`.`account_id`
`transaction_lines`.`line_type`
`transaction_lines`.`amount`
`transaction_lines`.`memo`
`transaction_lines`.`created_at`
`truck_locations`.*
`truck_locations`.`id`
`truck_locations`.`truck_id`
`truck_locations`.`latitude`
`truck_locations`.`longitude`
`truck_locations`.`speed_kph`
`truck_locations`.`captured_at`
`truck_locations`.`source`
`truck_locations`.`created_at`
`trucks`.*
`trucks`.`id`
`trucks`.`name`
`trucks`.`plate_no`
`trucks`.`capacity_kg`
`trucks`.`capacity_cbm`
`trucks`.`gps_device_id`
`trucks`.`active`
`trucks`.`created_at`
`user_group`.*
`user_group`.`id`
`user_group`.`user_id`
`user_group`.`group_id`
`user_notifications`.*
`user_notifications`.`id`
`user_notifications`.`user_id`
`user_notifications`.`type`
`user_notifications`.`title`
`user_notifications`.`message`
`user_notifications`.`link_url`
`user_notifications`.`payload_json`
`user_notifications`.`is_read`
`user_notifications`.`created_at`
`user_notifications`.`read_at`
`users`.*
`users`.`id`
`users`.`username`
`users`.`password`
`users`.`must_change_password`
`users`.`email`
`users`.`employee_id`
`users`.`firstname`
`users`.`lastname`
`users`.`phone`
`users`.`gender`
`website_inquiries`.*
`website_inquiries`.`id`
`website_inquiries`.`product_id`
`website_inquiries`.`product_name`
`website_inquiries`.`client_name`
`website_inquiries`.`company_name`
`website_inquiries`.`email`
`website_inquiries`.`phone`
`website_inquiries`.`subject`
`website_inquiries`.`message`
`website_inquiries`.`source_page`
`website_inquiries`.`ip_address`
`website_inquiries`.`user_agent`
`website_inquiries`.`status`
`website_inquiries`.`created_at`
`website_inquiries`.`updated_at`
`work_schedule_days`.*
`work_schedule_days`.`id`
`work_schedule_days`.`schedule_id`
`work_schedule_days`.`day_of_week`
`work_schedule_days`.`is_working_day`
`work_schedule_days`.`is_rest_day`
`work_schedules`.*
`work_schedules`.`id`
`work_schedules`.`schedule_code`
`work_schedules`.`schedule_name`
`work_schedules`.`schedule_type`
`work_schedules`.`start_time`
`work_schedules`.`end_time`
`work_schedules`.`break_minutes`
`work_schedules`.`required_work_minutes`
`work_schedules`.`grace_period_minutes`
`work_schedules`.`is_overnight`
`work_schedules`.`effective_date`
`work_schedules`.`status`
`work_schedules`.`remarks`
`work_schedules`.`legacy_shift_id`
`work_schedules`.`created_by`
`work_schedules`.`updated_by`
`work_schedules`.`created_at`
`work_schedules`.`updated_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
accounting_transactions
accounts
api_mobile_tokens
app_rate_limits
asset_accountability_form_items
asset_accountability_forms
asset_assignments
asset_audit_logs
asset_categories
asset_label_print_logs
asset_label_templates
asset_maintenance_logs
asset_print_logs
asset_transfers
assets
attendance_corrections
attribute_value
attributes
audit_logs
auth_access_logs
brands
categories
clearance_items
company
deliveries
delivery_items
departments
disciplinary_cases
document_approval_logs
document_approval_remarks
document_approval_signatures
document_approval_steps
document_approval_versions
document_approvals
document_department_users
document_types
document_workflow_steps
document_workflows
employee_201_files
employee_aliases
employee_certifications
employee_document_access_logs
employee_document_types
employee_document_versions
employee_documents
employee_education
employee_employment_history
employee_family_dependents
employee_medical_records
employee_movements
employee_onboarding_items
employee_schedule_assignments
expenses
groups
holidays
hr_attendance
hr_attendance_edit_logs
hr_attendance_time_security_logs
hr_checklist_items
hr_checklists
hr_employees
hr_payroll_batch_logs
hr_payroll_batches
hr_payrolls
hr_shifts
hr_statutory_pagibig
hr_statutory_philhealth
hr_statutory_sss
hr_statutory_withholding
hr_thirteenth_month_batches
hr_thirteenth_month_rows
leave_balances
leave_request_audit_logs
leave_requests
leave_types
logistics_audit_logs
logistics_billing
logistics_clients
logistics_consolidation_batches
logistics_consolidation_items
logistics_customs_clearances
logistics_customs_logs
logistics_dispatches
logistics_shipments
logistics_warehouse_movements
mobile_push_tokens
offboarding_records
official_business_requests
order_deliveries
order_delivery_expenses
order_delivery_item_returns
order_delivery_items
order_delivery_itinerary
order_delivery_status_logs
orders
orders_item
overtime_requests
payables
payments
payroll_activity_logs
payroll_adjustments
payroll_details
payroll_office_entries
payroll_settings
payroll_trip_entries
payroll_trip_rates
payslips
performance_evaluations
product_history
products
profile_update_requests
receivables
recruitment_applicant_documents
recruitment_applicants
recruitment_consent_logs
recruitment_email_logs
recruitment_email_templates
recruitment_final_interviews
recruitment_interview_event_logs
recruitment_interview_integrity_summary
recruitment_interview_progress
recruitment_interview_sessions
recruitment_management_review_logs
recruitment_management_review_tokens
recruitment_positions
recruitment_question_video_versions
recruitment_question_view_logs
recruitment_questions
recruitment_review_scores
recruitment_reviews
recruitment_settings
recruitment_status_logs
recruitment_video_answers
schedule_change_logs
schedule_scope_assignments
stock_adjustments
stores
system_settings
transaction_lines
truck_locations
trucks
user_group
user_notifications
users
website_inquiries
work_schedule_days
work_schedules
SQL query on database
top1movers
: