Recent
`nldsignc_2025`.`categories`
`phpmyadmin`.`pma__history`
`nldsignc_2025`.`pending_contacts`
`nldsignc_2025`.`qa_in_store`
`nldsignc_2025`.`purchase_orders`
`nldsignc_2025`.`warehouse_column_settings`
`nldsignc_2025`.`admin_logs`
`nldsignc_2025`.`warehouse_scan_log`
`information_schema`.`TABLE_STATISTICS`
`nldsignc_2025`.`users`
Favorites
There are no favorite tables.
New
information_schema
media_store
mysql
nldsignc_2025
performance_schema
phpmyadmin
survey_db
test
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: nldsignc_2025
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:
`activity_logs`.*
`activity_logs`.`log_id`
`activity_logs`.`user_id`
`activity_logs`.`action`
`activity_logs`.`affected_user_id`
`activity_logs`.`created_at`
`activity_logs`.`log_type`
`ad_user`.*
`ad_user`.`id`
`ad_user`.`username`
`ad_user`.`user_id`
`ad_user`.`password`
`ad_user`.`full_name`
`ad_user`.`phone`
`ad_user`.`email`
`ad_user`.`created_date`
`ad_user`.`updated_date`
`ad_user`.`last_login`
`ad_user`.`status`
`ad_user`.`role`
`ad_user`.`profile_image`
`ad_user`.`login_attempts`
`ad_user`.`locked_until`
`admin_logs`.*
`admin_logs`.`log_id`
`admin_logs`.`admin_id`
`admin_logs`.`action`
`admin_logs`.`user_id`
`admin_logs`.`details`
`admin_logs`.`created_at`
`admin_users`.*
`admin_users`.`id`
`admin_users`.`username`
`admin_users`.`password`
`admin_users`.`created_at`
`borrow_transactions`.*
`borrow_transactions`.`id`
`borrow_transactions`.`equipment_id`
`borrow_transactions`.`transaction_type`
`borrow_transactions`.`quantity`
`borrow_transactions`.`user_name`
`borrow_transactions`.`notes`
`borrow_transactions`.`attachment`
`borrow_transactions`.`approver_name`
`borrow_transactions`.`return_signature`
`borrow_transactions`.`borrow_signature`
`borrow_transactions`.`borrower_name`
`borrow_transactions`.`borrower_department`
`borrow_transactions`.`borrower_phone`
`borrow_transactions`.`borrowed_date`
`borrow_transactions`.`purpose`
`borrow_transactions`.`borrow_date`
`borrow_transactions`.`due_date`
`borrow_transactions`.`expected_return_date`
`borrow_transactions`.`actual_return_date`
`borrow_transactions`.`borrow_request_id`
`borrow_transactions`.`status`
`borrow_transactions`.`user_id`
`borrow_transactions`.`condition_on_return`
`borrow_transactions`.`return_notes`
`borrow_transactions`.`created_at`
`borrower_blacklist`.*
`borrower_blacklist`.`id`
`borrower_blacklist`.`borrower_name`
`borrower_blacklist`.`borrower_department`
`borrower_blacklist`.`reason`
`borrower_blacklist`.`blacklist_date`
`borrower_blacklist`.`expiry_date`
`borrower_blacklist`.`status`
`borrower_blacklist`.`created_by`
`borrower_blacklist`.`notes`
`car_reservation_photos`.*
`car_reservation_photos`.`id`
`car_reservation_photos`.`reservation_id`
`car_reservation_photos`.`filename`
`car_reservation_photos`.`uploaded_by`
`car_reservation_photos`.`created_at`
`car_reservations`.*
`car_reservations`.`id`
`car_reservations`.`doc_no`
`car_reservations`.`book_date`
`car_reservations`.`work_time`
`car_reservations`.`use_date`
`car_reservations`.`return_date`
`car_reservations`.`depart_time`
`car_reservations`.`return_time`
`car_reservations`.`car_type`
`car_reservations`.`destination`
`car_reservations`.`map_url`
`car_reservations`.`contact_name`
`car_reservations`.`job_no`
`car_reservations`.`has_map`
`car_reservations`.`contact_tel`
`car_reservations`.`pickup_location`
`car_reservations`.`pickup_datetime`
`car_reservations`.`has_staff`
`car_reservations`.`staff_data`
`car_reservations`.`job_type`
`car_reservations`.`detail`
`car_reservations`.`detail2`
`car_reservations`.`return_type`
`car_reservations`.`return_location`
`car_reservations`.`car_plate`
`car_reservations`.`vehicle_id`
`car_reservations`.`driver_name`
`car_reservations`.`requester_sign`
`car_reservations`.`requester_tel`
`car_reservations`.`status`
`car_reservations`.`created_by`
`car_reservations`.`created_at`
`car_reservations`.`updated_at`
`categories`.*
`categories`.`id`
`categories`.`name`
`contact_summary`.*
`contact_summary`.`status`
`contact_summary`.`priority`
`contact_summary`.`total_contacts`
`contact_summary`.`this_week`
`contact_summary`.`this_month`
`data_user`.*
`data_user`.`id`
`data_user`.`username`
`data_user`.`fullname`
`data_user`.`department`
`data_user`.`password`
`data_user`.`email`
`data_user`.`role`
`data_user`.`status`
`data_user`.`created_at`
`drivers`.*
`drivers`.`id`
`drivers`.`user_id`
`drivers`.`password`
`drivers`.`driver_name`
`drivers`.`nickname`
`drivers`.`contact_number`
`drivers`.`license_type`
`drivers`.`skills`
`drivers`.`photo`
`drivers`.`gps_consent`
`drivers`.`status`
`drivers`.`created_at`
`employees`.*
`employees`.`id`
`employees`.`team_name`
`employees`.`employee_id`
`employees`.`full_name`
`employees`.`department`
`employees`.`photo`
`employees`.`created_at`
`employees`.`team_color`
`employees`.`status`
`employees`.`daily_wage`
`employees`.`ot_wage`
`equipment_categories`.*
`equipment_categories`.`id`
`equipment_categories`.`name`
`equipment_categories`.`description`
`equipment_categories`.`color`
`equipment_categories`.`status`
`equipment_categories`.`created_at`
`equipment_categories`.`updated_at`
`equipment_condition_history`.*
`equipment_condition_history`.`id`
`equipment_condition_history`.`equipment_id`
`equipment_condition_history`.`transaction_id`
`equipment_condition_history`.`condition_before`
`equipment_condition_history`.`condition_after`
`equipment_condition_history`.`damage_description`
`equipment_condition_history`.`repair_needed`
`equipment_condition_history`.`repair_cost`
`equipment_condition_history`.`inspector_name`
`equipment_condition_history`.`inspection_date`
`equipment_condition_history`.`notes`
`equipment_maintenance`.*
`equipment_maintenance`.`id`
`equipment_maintenance`.`equipment_id`
`equipment_maintenance`.`maintenance_type`
`equipment_maintenance`.`maintenance_date`
`equipment_maintenance`.`next_maintenance_date`
`equipment_maintenance`.`cost`
`equipment_maintenance`.`description`
`equipment_maintenance`.`status`
`equipment_maintenance`.`technician`
`equipment_maintenance`.`notes`
`equipment_maintenance`.`created_at`
`equipment_transactions`.*
`equipment_transactions`.`id`
`equipment_transactions`.`equipment_id`
`equipment_transactions`.`transaction_type`
`equipment_transactions`.`quantity`
`equipment_transactions`.`user_name`
`equipment_transactions`.`notes`
`equipment_transactions`.`created_at`
`equipment_transactions`.`attachment`
`equipment_transactions`.`approver_name`
`equipment_transactions`.`return_signature`
`equipment_transactions`.`borrow_signature`
`equipment_transactions`.`borrower_name`
`equipment_transactions`.`borrower_department`
`equipment_transactions`.`borrower_phone`
`equipment_transactions`.`returner_name`
`equipment_transactions`.`returner_department`
`equipment_transactions`.`returner_position`
`equipment_transactions`.`returner_code`
`equipment_transactions`.`purpose`
`equipment_transactions`.`borrow_date`
`equipment_transactions`.`expected_return_date`
`equipment_transactions`.`actual_return_date`
`equipment_transactions`.`borrow_request_id`
`equipment_transactions`.`status`
`equipment_transactions`.`user_id`
`equipment_transactions`.`condition_on_return`
`equipment_transactions`.`return_notes`
`equipment_transactions`.`receiver_name`
`equipment_transactions`.`receiver_role`
`equipment_transactions`.`signature_borrower`
`equipment_transactions`.`signature_receiver`
`equipment_transactions`.`related_borrow_id`
`equipment_usage_stats`.*
`equipment_usage_stats`.`id`
`equipment_usage_stats`.`equipment_id`
`equipment_usage_stats`.`total_borrows`
`equipment_usage_stats`.`total_returns`
`equipment_usage_stats`.`overdue_count`
`equipment_usage_stats`.`damage_count`
`equipment_usage_stats`.`total_usage_hours`
`equipment_usage_stats`.`average_rating`
`equipment_usage_stats`.`last_borrowed_date`
`equipment_usage_stats`.`last_returned_date`
`equipment_usage_stats`.`updated_at`
`equipments`.*
`equipments`.`id`
`equipments`.`img`
`equipments`.`name`
`equipments`.`model`
`equipments`.`brand`
`equipments`.`serial_number`
`equipments`.`serial`
`equipments`.`quantity`
`equipments`.`category_id`
`equipments`.`description`
`equipments`.`status`
`equipments`.`condition_status`
`equipments`.`location`
`equipments`.`purchase_date`
`equipments`.`purchase_price`
`equipments`.`warranty_expiry`
`equipments`.`last_maintenance`
`equipments`.`image_path`
`equipments`.`created_at`
`equipments`.`updated_at`
`foreman_approvers`.*
`foreman_approvers`.`id`
`foreman_approvers`.`user_id`
`foreman_approvers`.`user_name`
`foreman_approvers`.`role`
`foreman_approvers`.`department`
`foreman_approvers`.`max_approval_amount`
`foreman_approvers`.`is_active`
`foreman_approvers`.`created_at`
`foreman_approvers`.`updated_at`
`foreman_material_attachments`.*
`foreman_material_attachments`.`id`
`foreman_material_attachments`.`breakdown_id`
`foreman_material_attachments`.`file_name`
`foreman_material_attachments`.`file_path`
`foreman_material_attachments`.`file_type`
`foreman_material_attachments`.`file_size`
`foreman_material_attachments`.`description`
`foreman_material_attachments`.`uploaded_by`
`foreman_material_attachments`.`uploaded_by_name`
`foreman_material_attachments`.`created_at`
`foreman_material_breakdown`.*
`foreman_material_breakdown`.`id`
`foreman_material_breakdown`.`foreman_id`
`foreman_material_breakdown`.`foreman_name`
`foreman_material_breakdown`.`project_name`
`foreman_material_breakdown`.`job_number`
`foreman_material_breakdown`.`customer`
`foreman_material_breakdown`.`project_owner`
`foreman_material_breakdown`.`location`
`foreman_material_breakdown`.`required_date`
`foreman_material_breakdown`.`installation_date`
`foreman_material_breakdown`.`status`
`foreman_material_breakdown`.`remarks`
`foreman_material_breakdown`.`created_at`
`foreman_material_breakdown`.`updated_at`
`foreman_material_breakdown`.`submitted_at`
`foreman_material_breakdown`.`approved_at`
`foreman_material_breakdown`.`approved_by`
`foreman_material_breakdown`.`approved_by_name`
`foreman_material_breakdown`.`rejected_at`
`foreman_material_breakdown`.`rejected_by`
`foreman_material_breakdown`.`rejected_by_name`
`foreman_material_breakdown`.`rejection_reason`
`foreman_material_breakdown`.`store_confirmed_by`
`foreman_material_breakdown`.`store_confirmed_by_name`
`foreman_material_breakdown`.`store_confirmed_at`
`foreman_material_items`.*
`foreman_material_items`.`id`
`foreman_material_items`.`breakdown_id`
`foreman_material_items`.`material_id`
`foreman_material_items`.`material_code`
`foreman_material_items`.`material_name`
`foreman_material_items`.`brand`
`foreman_material_items`.`order_date`
`foreman_material_items`.`required_qty`
`foreman_material_items`.`required_unit`
`foreman_material_items`.`stock_qty`
`foreman_material_items`.`stock_unit`
`foreman_material_items`.`order_qty`
`foreman_material_items`.`approved_qty`
`foreman_material_items`.`actual_qty`
`foreman_material_items`.`received_qty`
`foreman_material_items`.`received_date`
`foreman_material_items`.`received_by`
`foreman_material_items`.`item_remarks`
`foreman_material_items`.`is_paid`
`foreman_material_items`.`is_checked`
`foreman_material_items`.`checked_by`
`foreman_material_items`.`checked_at`
`foreman_material_items`.`paid_by`
`foreman_material_items`.`paid_at`
`foreman_material_items`.`created_at`
`foreman_material_items`.`updated_at`
`foreman_material_items`.`sort_order`
`foreman_material_logs`.*
`foreman_material_logs`.`id`
`foreman_material_logs`.`breakdown_id`
`foreman_material_logs`.`action`
`foreman_material_logs`.`user_id`
`foreman_material_logs`.`user_name`
`foreman_material_logs`.`user_role`
`foreman_material_logs`.`old_status`
`foreman_material_logs`.`new_status`
`foreman_material_logs`.`remarks`
`foreman_material_logs`.`ip_address`
`foreman_material_logs`.`created_at`
`foreman_material_received`.*
`foreman_material_received`.`id`
`foreman_material_received`.`item_id`
`foreman_material_received`.`received_no`
`foreman_material_received`.`received_qty`
`foreman_material_received`.`received_date`
`foreman_material_received`.`received_by`
`foreman_material_received`.`issued_by`
`foreman_material_received`.`warehouse_history_id`
`foreman_material_received`.`remarks`
`foreman_material_received`.`created_at`
`foreman_material_received`.`updated_at`
`foreman_users`.*
`foreman_users`.`id`
`foreman_users`.`password`
`foreman_users`.`full_name`
`foreman_users`.`nickname`
`foreman_users`.`department`
`foreman_users`.`photo`
`foreman_users`.`photo_filename`
`foreman_users`.`signature`
`foreman_users`.`created_at`
`foreman_users`.`updated_at`
`holidays`.*
`holidays`.`id`
`holidays`.`holiday_name`
`holidays`.`holiday_date`
`holidays`.`description`
`incoming_items`.*
`incoming_items`.`id`
`incoming_items`.`date`
`incoming_items`.`category`
`incoming_items`.`item_name`
`incoming_items`.`required_date`
`incoming_items`.`product_code`
`incoming_items`.`brand`
`incoming_items`.`size`
`incoming_items`.`note`
`incoming_items`.`quantity`
`incoming_items`.`unit`
`incoming_items`.`price_before_vat`
`incoming_items`.`price_with_vat`
`incoming_items`.`total_price`
`incoming_items`.`pr_number`
`incoming_items`.`foreman`
`incoming_items`.`job_number`
`incoming_items`.`job_name`
`incoming_items`.`vendor`
`incoming_items`.`vendor_phone`
`incoming_items`.`po_number`
`incoming_items`.`order_by`
`incoming_items`.`order_date`
`incoming_items`.`appointment_date`
`incoming_items`.`received_date`
`incoming_items`.`received_by`
`incoming_items`.`invoice_number`
`incoming_items`.`status`
`incoming_items`.`created_by`
`incoming_items`.`created_date`
`incoming_items`.`updated_at`
`led_item`.*
`led_item`.`id`
`led_item`.`name_item`
`led_item`.`detail`
`led_item`.`Rem_Amt`
`led_item`.`type`
`led_item`.`img`
`led_transactions`.*
`led_transactions`.`id`
`led_transactions`.`item_id`
`led_transactions`.`job_number`
`led_transactions`.`operator`
`led_transactions`.`type`
`led_transactions`.`quantity`
`led_transactions`.`remark`
`led_transactions`.`transaction_date`
`led_types`.*
`led_types`.`type_id`
`led_types`.`type_name`
`loan_members`.*
`loan_members`.`id`
`loan_members`.`name`
`loan_members`.`department`
`loan_members`.`position`
`loan_members`.`name_leader`
`loan_members`.`phone`
`loan_members`.`email`
`loan_members`.`image`
`loan_members`.`status`
`loan_members`.`approval_status`
`loan_members`.`approved_by`
`loan_members`.`approved_date`
`loan_members`.`member_code`
`loan_members`.`notes`
`loan_members`.`created_at`
`loan_members`.`updated_at`
`media_equipment`.*
`media_equipment`.`id`
`media_equipment`.`equipment_code`
`media_equipment`.`equipment_name`
`media_equipment`.`equipment_type`
`media_equipment`.`brand`
`media_equipment`.`model`
`media_equipment`.`serial_number`
`media_equipment`.`size`
`media_equipment`.`location`
`media_equipment`.`status`
`media_equipment`.`stock_quantity`
`media_equipment`.`min_quantity`
`media_equipment`.`image_path`
`media_equipment`.`notes`
`media_equipment`.`created_at`
`media_equipment`.`updated_at`
`media_equipment`.`last_stock_update`
`pending_contacts`.*
`pending_contacts`.`id`
`pending_contacts`.`name`
`pending_contacts`.`email`
`pending_contacts`.`subject`
`pending_contacts`.`company`
`pending_contacts`.`project_type`
`pending_contacts`.`priority`
`pending_contacts`.`days_waiting`
`pending_contacts`.`created_at`
`purchase_items`.*
`purchase_items`.`id`
`purchase_items`.`purchase_order_id`
`purchase_items`.`category`
`purchase_items`.`item_name`
`purchase_items`.`product_code`
`purchase_items`.`brand`
`purchase_items`.`quantity`
`purchase_items`.`unit`
`purchase_items`.`unit_price`
`purchase_items`.`unit_price_vat`
`purchase_items`.`total_price`
`purchase_items`.`remarks`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`order_date`
`purchase_orders`.`product_type`
`purchase_orders`.`item_name`
`purchase_orders`.`required_date`
`purchase_orders`.`product_code`
`purchase_orders`.`brand`
`purchase_orders`.`size`
`purchase_orders`.`remark`
`purchase_orders`.`quantity`
`purchase_orders`.`unit`
`purchase_orders`.`price_before_vat`
`purchase_orders`.`price_with_vat`
`purchase_orders`.`total_amount`
`purchase_orders`.`pr_number`
`purchase_orders`.`foreman`
`purchase_orders`.`job_number`
`purchase_orders`.`job_name`
`purchase_orders`.`vendor`
`purchase_orders`.`phone`
`purchase_orders`.`po_number`
`purchase_orders`.`ordered_by`
`purchase_orders`.`order_date_time`
`purchase_orders`.`expected_date`
`purchase_orders`.`received_date`
`purchase_orders`.`received_by`
`purchase_orders`.`invoice_no`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`qa_in_store`.*
`qa_in_store`.`id`
`qa_in_store`.`update_date`
`qa_in_store`.`category`
`qa_in_store`.`product_name`
`qa_in_store`.`required_date`
`qa_in_store`.`product_code`
`qa_in_store`.`brand`
`qa_in_store`.`size`
`qa_in_store`.`note`
`qa_in_store`.`quantity`
`qa_in_store`.`unit`
`qa_in_store`.`price_before_vat`
`qa_in_store`.`price_with_vat`
`qa_in_store`.`total_amount`
`qa_in_store`.`pr_number`
`qa_in_store`.`foreman`
`qa_in_store`.`job`
`qa_in_store`.`remarks`
`qa_in_store`.`vendor`
`qa_in_store`.`phone_number`
`qa_in_store`.`po`
`qa_in_store`.`order_person`
`qa_in_store`.`order_date`
`qa_in_store`.`delivery_date`
`qa_in_store`.`received_date`
`qa_in_store`.`receiver`
`qa_in_store`.`invoice_bill`
`qa_in_store`.`image`
`qa_in_store`.`created_at`
`qa_in_store`.`updated_at`
`qa_in_store_images`.*
`qa_in_store_images`.`id`
`qa_in_store_images`.`qa_store_id`
`qa_in_store_images`.`image_name`
`qa_in_store_images`.`original_name`
`qa_in_store_images`.`file_path`
`qa_in_store_images`.`file_size`
`qa_in_store_images`.`mime_type`
`qa_in_store_images`.`image_type`
`qa_in_store_images`.`upload_order`
`qa_in_store_images`.`uploaded_at`
`qa_in_store_images`.`updated_at`
`recent_contacts`.*
`recent_contacts`.`id`
`recent_contacts`.`name`
`recent_contacts`.`email`
`recent_contacts`.`phone`
`recent_contacts`.`subject`
`recent_contacts`.`message_preview`
`recent_contacts`.`company`
`recent_contacts`.`project_type`
`recent_contacts`.`status`
`recent_contacts`.`priority`
`recent_contacts`.`created_at`
`return_evidence`.*
`return_evidence`.`id`
`return_evidence`.`transaction_id`
`return_evidence`.`evidence_type`
`return_evidence`.`file_path`
`return_evidence`.`file_name`
`return_evidence`.`file_size`
`return_evidence`.`description`
`return_evidence`.`uploaded_by`
`return_evidence`.`created_at`
`return_feedback`.*
`return_feedback`.`id`
`return_feedback`.`transaction_id`
`return_feedback`.`borrower_rating`
`return_feedback`.`service_rating`
`return_feedback`.`equipment_quality_rating`
`return_feedback`.`feedback_message`
`return_feedback`.`suggestions`
`return_feedback`.`submitted_at`
`return_logs`.*
`return_logs`.`id`
`return_logs`.`borrow_id`
`return_logs`.`equipment_id`
`return_logs`.`quantity_returned`
`return_logs`.`return_date`
`return_logs`.`condition_on_return`
`return_logs`.`return_notes`
`return_logs`.`return_signature`
`return_logs`.`attachment_file`
`return_logs`.`processed_by`
`return_logs`.`created_at`
`return_notifications`.*
`return_notifications`.`id`
`return_notifications`.`transaction_id`
`return_notifications`.`notification_type`
`return_notifications`.`message`
`return_notifications`.`sent_at`
`return_notifications`.`read_at`
`return_notifications`.`created_at`
`return_signatures`.*
`return_signatures`.`id`
`return_signatures`.`transaction_id`
`return_signatures`.`returner_signature`
`return_signatures`.`receiver_signature`
`return_signatures`.`return_condition`
`return_signatures`.`return_notes`
`return_signatures`.`created_at`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`permissions`
`roles`.`created_at`
`roles`.`updated_at`
`stock_logs`.*
`stock_logs`.`id`
`stock_logs`.`equipment_id`
`stock_logs`.`action`
`stock_logs`.`quantity`
`stock_logs`.`notes`
`stock_logs`.`created_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`contact_info`
`system_permissions`.*
`system_permissions`.`id`
`system_permissions`.`role_id`
`system_permissions`.`system_key`
`system_permissions`.`can_access`
`system_permissions`.`created_at`
`system_permissions`.`updated_at`
`system_settings`.*
`system_settings`.`id`
`system_settings`.`setting_key`
`system_settings`.`setting_value`
`system_settings`.`setting_type`
`system_settings`.`description`
`system_settings`.`is_public`
`system_settings`.`created_at`
`system_settings`.`updated_at`
`team_members`.*
`team_members`.`id`
`team_members`.`team_id`
`team_members`.`member_name`
`team_members`.`member_photo`
`team_members`.`created_at`
`teams`.*
`teams`.`id`
`teams`.`department`
`teams`.`team_name`
`teams`.`team_leader`
`teams`.`leader_photo`
`teams`.`created_at`
`teams`.`updated_at`
`tool_categories`.*
`tool_categories`.`id`
`tool_categories`.`category_name`
`tool_categories`.`description`
`tool_categories`.`created_at`
`tools_new`.*
`tools_new`.`id`
`tools_new`.`img`
`tools_new`.`name`
`tools_new`.`model`
`tools_new`.`brand`
`tools_new`.`serial`
`tools_new`.`quantity`
`tools_new`.`description`
`tools_new`.`status`
`tools_new`.`location`
`tools_new`.`created_at`
`traffic_report_photos`.*
`traffic_report_photos`.`id`
`traffic_report_photos`.`traffic_report_id`
`traffic_report_photos`.`filename`
`traffic_report_photos`.`uploaded_by`
`traffic_report_photos`.`uploaded_at`
`traffic_reports`.*
`traffic_reports`.`id`
`traffic_reports`.`reservation_id`
`traffic_reports`.`driver_name`
`traffic_reports`.`status`
`traffic_reports`.`lat`
`traffic_reports`.`lng`
`traffic_reports`.`location_text`
`traffic_reports`.`note`
`traffic_reports`.`reported_at`
`traffic_reports`.`mileage`
`user_activity_logs`.*
`user_activity_logs`.`id`
`user_activity_logs`.`user_id`
`user_activity_logs`.`username`
`user_activity_logs`.`action_type`
`user_activity_logs`.`module`
`user_activity_logs`.`action_description`
`user_activity_logs`.`ip_address`
`user_activity_logs`.`user_agent`
`user_activity_logs`.`additional_data`
`user_activity_logs`.`created_at`
`user_sessions`.*
`user_sessions`.`id`
`user_sessions`.`user_id`
`user_sessions`.`session_id`
`user_sessions`.`ip_address`
`user_sessions`.`user_agent`
`user_sessions`.`created_at`
`user_sessions`.`last_activity`
`user_sessions`.`is_active`
`users`.*
`users`.`user_id`
`users`.`username`
`users`.`password`
`users`.`email`
`users`.`role_id`
`users`.`created_at`
`users`.`status`
`users`.`approved_by`
`users`.`approved_at`
`v_all_borrowing`.*
`v_all_borrowing`.`source_table`
`v_all_borrowing`.`id`
`v_all_borrowing`.`equipment_id`
`v_all_borrowing`.`equipment_name`
`v_all_borrowing`.`category`
`v_all_borrowing`.`borrower_name`
`v_all_borrowing`.`borrower_department`
`v_all_borrowing`.`borrower_phone`
`v_all_borrowing`.`quantity`
`v_all_borrowing`.`borrow_date`
`v_all_borrowing`.`expected_return_date`
`v_all_borrowing`.`actual_return_date`
`v_all_borrowing`.`status`
`v_all_borrowing`.`purpose`
`v_all_borrowing`.`days_overdue`
`v_borrow_summary`.*
`v_borrow_summary`.`equipment_id`
`v_borrow_summary`.`equipment_name`
`v_borrow_summary`.`model`
`v_borrow_summary`.`brand`
`v_borrow_summary`.`quantity`
`v_borrow_summary`.`equipment_status`
`v_borrow_summary`.`total_borrows`
`v_borrow_summary`.`currently_borrowed`
`v_borrow_summary`.`last_borrow_date`
`v_borrow_summary`.`last_return_date`
`v_borrow_summary`.`availability_status`
`v_borrowing_stats`.*
`v_borrowing_stats`.`borrower_name`
`v_borrowing_stats`.`borrower_department`
`v_borrowing_stats`.`borrower_phone`
`v_borrowing_stats`.`total_items`
`v_borrowing_stats`.`overdue_items`
`v_borrowing_stats`.`first_borrow_date`
`v_borrowing_stats`.`last_expected_return`
`vehicle_photos`.*
`vehicle_photos`.`id`
`vehicle_photos`.`vehicle_id`
`vehicle_photos`.`filename`
`vehicle_photos`.`sort_order`
`vehicle_photos`.`created_at`
`vehicle_repairs`.*
`vehicle_repairs`.`id`
`vehicle_repairs`.`vehicle_id`
`vehicle_repairs`.`car_plate`
`vehicle_repairs`.`repair_date`
`vehicle_repairs`.`repair_type`
`vehicle_repairs`.`description`
`vehicle_repairs`.`cost`
`vehicle_repairs`.`garage`
`vehicle_repairs`.`mileage_at_repair`
`vehicle_repairs`.`next_repair_km`
`vehicle_repairs`.`next_repair_date`
`vehicle_repairs`.`note`
`vehicle_repairs`.`created_by`
`vehicle_repairs`.`created_at`
`vehicles`.*
`vehicles`.`id`
`vehicles`.`car_plate`
`vehicles`.`car_type`
`vehicles`.`res_car_type`
`vehicles`.`vehicle_kind`
`vehicles`.`brand`
`vehicles`.`model`
`vehicles`.`car_year`
`vehicles`.`color`
`vehicles`.`fuel_type`
`vehicles`.`engine_cc`
`vehicles`.`engine_cylinders`
`vehicles`.`horsepower_hp`
`vehicles`.`cargo_width_m`
`vehicles`.`cargo_length_m`
`vehicles`.`cargo_height_m`
`vehicles`.`timing_system`
`vehicles`.`timing_note`
`vehicles`.`chassis_no`
`vehicles`.`engine_no`
`vehicles`.`reg_date`
`vehicles`.`reg_date_text`
`vehicles`.`vehicle_age_years`
`vehicles`.`reg_expire`
`vehicles`.`insurance_co`
`vehicles`.`insurance_no`
`vehicles`.`insurance_expire`
`vehicles`.`inspect_expire`
`vehicles`.`last_service_km`
`vehicles`.`last_service_date`
`vehicles`.`next_service_km`
`vehicles`.`next_service_date`
`vehicles`.`current_km`
`vehicles`.`gross_weight_kg`
`vehicles`.`curb_weight_kg`
`vehicles`.`payload_weight_kg`
`vehicles`.`department`
`vehicles`.`assigned_driver`
`vehicles`.`remark`
`vehicles`.`status`
`vehicles`.`created_at`
`warehouse_categories`.*
`warehouse_categories`.`id`
`warehouse_categories`.`category_name`
`warehouse_categories`.`created_at`
`warehouse_categories`.`is_active`
`warehouse_column_settings`.*
`warehouse_column_settings`.`id`
`warehouse_column_settings`.`user_id`
`warehouse_column_settings`.`setting_name`
`warehouse_column_settings`.`column_order`
`warehouse_column_settings`.`created_at`
`warehouse_column_settings`.`updated_at`
`warehouse_products`.*
`warehouse_products`.`id`
`warehouse_products`.`product_code`
`warehouse_products`.`brand`
`warehouse_products`.`category`
`warehouse_products`.`product_name`
`warehouse_products`.`quantity`
`warehouse_products`.`unit`
`warehouse_products`.`barcode`
`warehouse_products`.`shelf`
`warehouse_products`.`location`
`warehouse_products`.`created_by`
`warehouse_products`.`image`
`warehouse_products`.`created_at`
`warehouse_products`.`updated_at`
`warehouse_products`.`price`
`warehouse_products`.`cost`
`warehouse_products`.`supplier`
`warehouse_products`.`minimum_stock`
`warehouse_products`.`status`
`warehouse_products`.`description`
`warehouse_receive_history`.*
`warehouse_receive_history`.`id`
`warehouse_receive_history`.`product_id`
`warehouse_receive_history`.`receive_date`
`warehouse_receive_history`.`status`
`warehouse_receive_history`.`transaction_type`
`warehouse_receive_history`.`quantity`
`warehouse_receive_history`.`job_number`
`warehouse_receive_history`.`job_name`
`warehouse_receive_history`.`supplier`
`warehouse_receive_history`.`foreman`
`warehouse_receive_history`.`recorder`
`warehouse_receive_history`.`created_at`
`warehouse_receive_history`.`po_id`
`warehouse_scan_log`.*
`warehouse_scan_log`.`id`
`warehouse_scan_log`.`logged_at`
`warehouse_scan_log`.`action`
`warehouse_scan_log`.`username`
`warehouse_scan_log`.`product_id`
`warehouse_scan_log`.`product_name`
`warehouse_scan_log`.`product_code`
`warehouse_scan_log`.`barcode`
`warehouse_scan_log`.`field`
`warehouse_scan_log`.`new_value`
`warehouse_scan_log`.`query_text`
`warehouse_units`.*
`warehouse_units`.`id`
`warehouse_units`.`unit_name`
`warehouse_units`.`created_at`
`warehouse_units`.`is_active`
`wep_contact`.*
`wep_contact`.`id`
`wep_contact`.`name`
`wep_contact`.`email`
`wep_contact`.`phone`
`wep_contact`.`subject`
`wep_contact`.`message`
`wep_contact`.`company`
`wep_contact`.`project_type`
`wep_contact`.`budget_range`
`wep_contact`.`status`
`wep_contact`.`priority`
`wep_contact`.`ip_address`
`wep_contact`.`user_agent`
`wep_contact`.`source_page`
`wep_contact`.`admin_notes`
`wep_contact`.`replied_by`
`wep_contact`.`replied_at`
`wep_contact`.`created_at`
`wep_contact`.`updated_at`
`wep_news`.*
`wep_news`.`id`
`wep_news`.`title`
`wep_news`.`content`
`wep_news`.`image`
`wep_news`.`author_id`
`wep_news`.`author_name`
`wep_news`.`status`
`wep_news`.`priority`
`wep_news`.`views`
`wep_news`.`created_date`
`wep_news`.`updated_date`
`wep_news`.`published_date`
`wep_performances`.*
`wep_performances`.`id`
`wep_performances`.`job_number`
`wep_performances`.`name_job`
`wep_performances`.`detail`
`wep_performances`.`images`
`wep_performances`.`status`
`wep_performances`.`created_by`
`wep_performances`.`created_at`
`wep_performances`.`updated_at`
`wep_performances`.`view_count`
`wep_products`.*
`wep_products`.`id`
`wep_products`.`product_name`
`wep_products`.`main_image`
`wep_products`.`secondary_images`
`wep_products`.`product_video`
`wep_products`.`price`
`wep_products`.`description`
`wep_products`.`status`
`wep_products`.`created_by`
`wep_products`.`created_at`
`wep_products`.`updated_at`
`wep_products`.`view_count`
`withdrawal_items`.*
`withdrawal_items`.`id`
`withdrawal_items`.`withdrawal_id`
`withdrawal_items`.`item_name`
`withdrawal_items`.`quantity`
`withdrawal_items`.`unit`
`withdrawal_items`.`remarks`
`withdrawals`.*
`withdrawals`.`id`
`withdrawals`.`withdrawal_number`
`withdrawals`.`withdrawal_date`
`withdrawals`.`job_number`
`withdrawals`.`project_name`
`withdrawals`.`requester`
`withdrawals`.`remarks`
`withdrawals`.`created_at`
`work_plan_files`.*
`work_plan_files`.`id`
`work_plan_files`.`work_plan_id`
`work_plan_files`.`file_name`
`work_plan_files`.`original_name`
`work_plan_files`.`file_type`
`work_plan_files`.`file_size`
`work_plan_files`.`uploaded_by`
`work_plan_files`.`uploaded_at`
`work_plans`.*
`work_plans`.`id`
`work_plans`.`parent_id`
`work_plans`.`team_id`
`work_plans`.`team_name`
`work_plans`.`department`
`work_plans`.`job_number`
`work_plans`.`job_title`
`work_plans`.`supervisor`
`work_plans`.`team_leader`
`work_plans`.`work_type`
`work_plans`.`work_type_label`
`work_plans`.`start_date`
`work_plans`.`start_time`
`work_plans`.`end_date`
`work_plans`.`end_time`
`work_plans`.`location`
`work_plans`.`province`
`work_plans`.`description`
`work_plans`.`members`
`work_plans`.`status`
`work_plans`.`created_by`
`work_plans`.`created_at`
`work_plans`.`updated_at`
`activity_logs`.*
`activity_logs`.`log_id`
`activity_logs`.`user_id`
`activity_logs`.`action`
`activity_logs`.`affected_user_id`
`activity_logs`.`created_at`
`activity_logs`.`log_type`
`ad_user`.*
`ad_user`.`id`
`ad_user`.`username`
`ad_user`.`user_id`
`ad_user`.`password`
`ad_user`.`full_name`
`ad_user`.`phone`
`ad_user`.`email`
`ad_user`.`created_date`
`ad_user`.`updated_date`
`ad_user`.`last_login`
`ad_user`.`status`
`ad_user`.`role`
`ad_user`.`profile_image`
`ad_user`.`login_attempts`
`ad_user`.`locked_until`
`admin_logs`.*
`admin_logs`.`log_id`
`admin_logs`.`admin_id`
`admin_logs`.`action`
`admin_logs`.`user_id`
`admin_logs`.`details`
`admin_logs`.`created_at`
`admin_users`.*
`admin_users`.`id`
`admin_users`.`username`
`admin_users`.`password`
`admin_users`.`created_at`
`borrow_transactions`.*
`borrow_transactions`.`id`
`borrow_transactions`.`equipment_id`
`borrow_transactions`.`transaction_type`
`borrow_transactions`.`quantity`
`borrow_transactions`.`user_name`
`borrow_transactions`.`notes`
`borrow_transactions`.`attachment`
`borrow_transactions`.`approver_name`
`borrow_transactions`.`return_signature`
`borrow_transactions`.`borrow_signature`
`borrow_transactions`.`borrower_name`
`borrow_transactions`.`borrower_department`
`borrow_transactions`.`borrower_phone`
`borrow_transactions`.`borrowed_date`
`borrow_transactions`.`purpose`
`borrow_transactions`.`borrow_date`
`borrow_transactions`.`due_date`
`borrow_transactions`.`expected_return_date`
`borrow_transactions`.`actual_return_date`
`borrow_transactions`.`borrow_request_id`
`borrow_transactions`.`status`
`borrow_transactions`.`user_id`
`borrow_transactions`.`condition_on_return`
`borrow_transactions`.`return_notes`
`borrow_transactions`.`created_at`
`borrower_blacklist`.*
`borrower_blacklist`.`id`
`borrower_blacklist`.`borrower_name`
`borrower_blacklist`.`borrower_department`
`borrower_blacklist`.`reason`
`borrower_blacklist`.`blacklist_date`
`borrower_blacklist`.`expiry_date`
`borrower_blacklist`.`status`
`borrower_blacklist`.`created_by`
`borrower_blacklist`.`notes`
`car_reservation_photos`.*
`car_reservation_photos`.`id`
`car_reservation_photos`.`reservation_id`
`car_reservation_photos`.`filename`
`car_reservation_photos`.`uploaded_by`
`car_reservation_photos`.`created_at`
`car_reservations`.*
`car_reservations`.`id`
`car_reservations`.`doc_no`
`car_reservations`.`book_date`
`car_reservations`.`work_time`
`car_reservations`.`use_date`
`car_reservations`.`return_date`
`car_reservations`.`depart_time`
`car_reservations`.`return_time`
`car_reservations`.`car_type`
`car_reservations`.`destination`
`car_reservations`.`map_url`
`car_reservations`.`contact_name`
`car_reservations`.`job_no`
`car_reservations`.`has_map`
`car_reservations`.`contact_tel`
`car_reservations`.`pickup_location`
`car_reservations`.`pickup_datetime`
`car_reservations`.`has_staff`
`car_reservations`.`staff_data`
`car_reservations`.`job_type`
`car_reservations`.`detail`
`car_reservations`.`detail2`
`car_reservations`.`return_type`
`car_reservations`.`return_location`
`car_reservations`.`car_plate`
`car_reservations`.`vehicle_id`
`car_reservations`.`driver_name`
`car_reservations`.`requester_sign`
`car_reservations`.`requester_tel`
`car_reservations`.`status`
`car_reservations`.`created_by`
`car_reservations`.`created_at`
`car_reservations`.`updated_at`
`categories`.*
`categories`.`id`
`categories`.`name`
`contact_summary`.*
`contact_summary`.`status`
`contact_summary`.`priority`
`contact_summary`.`total_contacts`
`contact_summary`.`this_week`
`contact_summary`.`this_month`
`data_user`.*
`data_user`.`id`
`data_user`.`username`
`data_user`.`fullname`
`data_user`.`department`
`data_user`.`password`
`data_user`.`email`
`data_user`.`role`
`data_user`.`status`
`data_user`.`created_at`
`drivers`.*
`drivers`.`id`
`drivers`.`user_id`
`drivers`.`password`
`drivers`.`driver_name`
`drivers`.`nickname`
`drivers`.`contact_number`
`drivers`.`license_type`
`drivers`.`skills`
`drivers`.`photo`
`drivers`.`gps_consent`
`drivers`.`status`
`drivers`.`created_at`
`employees`.*
`employees`.`id`
`employees`.`team_name`
`employees`.`employee_id`
`employees`.`full_name`
`employees`.`department`
`employees`.`photo`
`employees`.`created_at`
`employees`.`team_color`
`employees`.`status`
`employees`.`daily_wage`
`employees`.`ot_wage`
`equipment_categories`.*
`equipment_categories`.`id`
`equipment_categories`.`name`
`equipment_categories`.`description`
`equipment_categories`.`color`
`equipment_categories`.`status`
`equipment_categories`.`created_at`
`equipment_categories`.`updated_at`
`equipment_condition_history`.*
`equipment_condition_history`.`id`
`equipment_condition_history`.`equipment_id`
`equipment_condition_history`.`transaction_id`
`equipment_condition_history`.`condition_before`
`equipment_condition_history`.`condition_after`
`equipment_condition_history`.`damage_description`
`equipment_condition_history`.`repair_needed`
`equipment_condition_history`.`repair_cost`
`equipment_condition_history`.`inspector_name`
`equipment_condition_history`.`inspection_date`
`equipment_condition_history`.`notes`
`equipment_maintenance`.*
`equipment_maintenance`.`id`
`equipment_maintenance`.`equipment_id`
`equipment_maintenance`.`maintenance_type`
`equipment_maintenance`.`maintenance_date`
`equipment_maintenance`.`next_maintenance_date`
`equipment_maintenance`.`cost`
`equipment_maintenance`.`description`
`equipment_maintenance`.`status`
`equipment_maintenance`.`technician`
`equipment_maintenance`.`notes`
`equipment_maintenance`.`created_at`
`equipment_transactions`.*
`equipment_transactions`.`id`
`equipment_transactions`.`equipment_id`
`equipment_transactions`.`transaction_type`
`equipment_transactions`.`quantity`
`equipment_transactions`.`user_name`
`equipment_transactions`.`notes`
`equipment_transactions`.`created_at`
`equipment_transactions`.`attachment`
`equipment_transactions`.`approver_name`
`equipment_transactions`.`return_signature`
`equipment_transactions`.`borrow_signature`
`equipment_transactions`.`borrower_name`
`equipment_transactions`.`borrower_department`
`equipment_transactions`.`borrower_phone`
`equipment_transactions`.`returner_name`
`equipment_transactions`.`returner_department`
`equipment_transactions`.`returner_position`
`equipment_transactions`.`returner_code`
`equipment_transactions`.`purpose`
`equipment_transactions`.`borrow_date`
`equipment_transactions`.`expected_return_date`
`equipment_transactions`.`actual_return_date`
`equipment_transactions`.`borrow_request_id`
`equipment_transactions`.`status`
`equipment_transactions`.`user_id`
`equipment_transactions`.`condition_on_return`
`equipment_transactions`.`return_notes`
`equipment_transactions`.`receiver_name`
`equipment_transactions`.`receiver_role`
`equipment_transactions`.`signature_borrower`
`equipment_transactions`.`signature_receiver`
`equipment_transactions`.`related_borrow_id`
`equipment_usage_stats`.*
`equipment_usage_stats`.`id`
`equipment_usage_stats`.`equipment_id`
`equipment_usage_stats`.`total_borrows`
`equipment_usage_stats`.`total_returns`
`equipment_usage_stats`.`overdue_count`
`equipment_usage_stats`.`damage_count`
`equipment_usage_stats`.`total_usage_hours`
`equipment_usage_stats`.`average_rating`
`equipment_usage_stats`.`last_borrowed_date`
`equipment_usage_stats`.`last_returned_date`
`equipment_usage_stats`.`updated_at`
`equipments`.*
`equipments`.`id`
`equipments`.`img`
`equipments`.`name`
`equipments`.`model`
`equipments`.`brand`
`equipments`.`serial_number`
`equipments`.`serial`
`equipments`.`quantity`
`equipments`.`category_id`
`equipments`.`description`
`equipments`.`status`
`equipments`.`condition_status`
`equipments`.`location`
`equipments`.`purchase_date`
`equipments`.`purchase_price`
`equipments`.`warranty_expiry`
`equipments`.`last_maintenance`
`equipments`.`image_path`
`equipments`.`created_at`
`equipments`.`updated_at`
`foreman_approvers`.*
`foreman_approvers`.`id`
`foreman_approvers`.`user_id`
`foreman_approvers`.`user_name`
`foreman_approvers`.`role`
`foreman_approvers`.`department`
`foreman_approvers`.`max_approval_amount`
`foreman_approvers`.`is_active`
`foreman_approvers`.`created_at`
`foreman_approvers`.`updated_at`
`foreman_material_attachments`.*
`foreman_material_attachments`.`id`
`foreman_material_attachments`.`breakdown_id`
`foreman_material_attachments`.`file_name`
`foreman_material_attachments`.`file_path`
`foreman_material_attachments`.`file_type`
`foreman_material_attachments`.`file_size`
`foreman_material_attachments`.`description`
`foreman_material_attachments`.`uploaded_by`
`foreman_material_attachments`.`uploaded_by_name`
`foreman_material_attachments`.`created_at`
`foreman_material_breakdown`.*
`foreman_material_breakdown`.`id`
`foreman_material_breakdown`.`foreman_id`
`foreman_material_breakdown`.`foreman_name`
`foreman_material_breakdown`.`project_name`
`foreman_material_breakdown`.`job_number`
`foreman_material_breakdown`.`customer`
`foreman_material_breakdown`.`project_owner`
`foreman_material_breakdown`.`location`
`foreman_material_breakdown`.`required_date`
`foreman_material_breakdown`.`installation_date`
`foreman_material_breakdown`.`status`
`foreman_material_breakdown`.`remarks`
`foreman_material_breakdown`.`created_at`
`foreman_material_breakdown`.`updated_at`
`foreman_material_breakdown`.`submitted_at`
`foreman_material_breakdown`.`approved_at`
`foreman_material_breakdown`.`approved_by`
`foreman_material_breakdown`.`approved_by_name`
`foreman_material_breakdown`.`rejected_at`
`foreman_material_breakdown`.`rejected_by`
`foreman_material_breakdown`.`rejected_by_name`
`foreman_material_breakdown`.`rejection_reason`
`foreman_material_breakdown`.`store_confirmed_by`
`foreman_material_breakdown`.`store_confirmed_by_name`
`foreman_material_breakdown`.`store_confirmed_at`
`foreman_material_items`.*
`foreman_material_items`.`id`
`foreman_material_items`.`breakdown_id`
`foreman_material_items`.`material_id`
`foreman_material_items`.`material_code`
`foreman_material_items`.`material_name`
`foreman_material_items`.`brand`
`foreman_material_items`.`order_date`
`foreman_material_items`.`required_qty`
`foreman_material_items`.`required_unit`
`foreman_material_items`.`stock_qty`
`foreman_material_items`.`stock_unit`
`foreman_material_items`.`order_qty`
`foreman_material_items`.`approved_qty`
`foreman_material_items`.`actual_qty`
`foreman_material_items`.`received_qty`
`foreman_material_items`.`received_date`
`foreman_material_items`.`received_by`
`foreman_material_items`.`item_remarks`
`foreman_material_items`.`is_paid`
`foreman_material_items`.`is_checked`
`foreman_material_items`.`checked_by`
`foreman_material_items`.`checked_at`
`foreman_material_items`.`paid_by`
`foreman_material_items`.`paid_at`
`foreman_material_items`.`created_at`
`foreman_material_items`.`updated_at`
`foreman_material_items`.`sort_order`
`foreman_material_logs`.*
`foreman_material_logs`.`id`
`foreman_material_logs`.`breakdown_id`
`foreman_material_logs`.`action`
`foreman_material_logs`.`user_id`
`foreman_material_logs`.`user_name`
`foreman_material_logs`.`user_role`
`foreman_material_logs`.`old_status`
`foreman_material_logs`.`new_status`
`foreman_material_logs`.`remarks`
`foreman_material_logs`.`ip_address`
`foreman_material_logs`.`created_at`
`foreman_material_received`.*
`foreman_material_received`.`id`
`foreman_material_received`.`item_id`
`foreman_material_received`.`received_no`
`foreman_material_received`.`received_qty`
`foreman_material_received`.`received_date`
`foreman_material_received`.`received_by`
`foreman_material_received`.`issued_by`
`foreman_material_received`.`warehouse_history_id`
`foreman_material_received`.`remarks`
`foreman_material_received`.`created_at`
`foreman_material_received`.`updated_at`
`foreman_users`.*
`foreman_users`.`id`
`foreman_users`.`password`
`foreman_users`.`full_name`
`foreman_users`.`nickname`
`foreman_users`.`department`
`foreman_users`.`photo`
`foreman_users`.`photo_filename`
`foreman_users`.`signature`
`foreman_users`.`created_at`
`foreman_users`.`updated_at`
`holidays`.*
`holidays`.`id`
`holidays`.`holiday_name`
`holidays`.`holiday_date`
`holidays`.`description`
`incoming_items`.*
`incoming_items`.`id`
`incoming_items`.`date`
`incoming_items`.`category`
`incoming_items`.`item_name`
`incoming_items`.`required_date`
`incoming_items`.`product_code`
`incoming_items`.`brand`
`incoming_items`.`size`
`incoming_items`.`note`
`incoming_items`.`quantity`
`incoming_items`.`unit`
`incoming_items`.`price_before_vat`
`incoming_items`.`price_with_vat`
`incoming_items`.`total_price`
`incoming_items`.`pr_number`
`incoming_items`.`foreman`
`incoming_items`.`job_number`
`incoming_items`.`job_name`
`incoming_items`.`vendor`
`incoming_items`.`vendor_phone`
`incoming_items`.`po_number`
`incoming_items`.`order_by`
`incoming_items`.`order_date`
`incoming_items`.`appointment_date`
`incoming_items`.`received_date`
`incoming_items`.`received_by`
`incoming_items`.`invoice_number`
`incoming_items`.`status`
`incoming_items`.`created_by`
`incoming_items`.`created_date`
`incoming_items`.`updated_at`
`led_item`.*
`led_item`.`id`
`led_item`.`name_item`
`led_item`.`detail`
`led_item`.`Rem_Amt`
`led_item`.`type`
`led_item`.`img`
`led_transactions`.*
`led_transactions`.`id`
`led_transactions`.`item_id`
`led_transactions`.`job_number`
`led_transactions`.`operator`
`led_transactions`.`type`
`led_transactions`.`quantity`
`led_transactions`.`remark`
`led_transactions`.`transaction_date`
`led_types`.*
`led_types`.`type_id`
`led_types`.`type_name`
`loan_members`.*
`loan_members`.`id`
`loan_members`.`name`
`loan_members`.`department`
`loan_members`.`position`
`loan_members`.`name_leader`
`loan_members`.`phone`
`loan_members`.`email`
`loan_members`.`image`
`loan_members`.`status`
`loan_members`.`approval_status`
`loan_members`.`approved_by`
`loan_members`.`approved_date`
`loan_members`.`member_code`
`loan_members`.`notes`
`loan_members`.`created_at`
`loan_members`.`updated_at`
`media_equipment`.*
`media_equipment`.`id`
`media_equipment`.`equipment_code`
`media_equipment`.`equipment_name`
`media_equipment`.`equipment_type`
`media_equipment`.`brand`
`media_equipment`.`model`
`media_equipment`.`serial_number`
`media_equipment`.`size`
`media_equipment`.`location`
`media_equipment`.`status`
`media_equipment`.`stock_quantity`
`media_equipment`.`min_quantity`
`media_equipment`.`image_path`
`media_equipment`.`notes`
`media_equipment`.`created_at`
`media_equipment`.`updated_at`
`media_equipment`.`last_stock_update`
`pending_contacts`.*
`pending_contacts`.`id`
`pending_contacts`.`name`
`pending_contacts`.`email`
`pending_contacts`.`subject`
`pending_contacts`.`company`
`pending_contacts`.`project_type`
`pending_contacts`.`priority`
`pending_contacts`.`days_waiting`
`pending_contacts`.`created_at`
`purchase_items`.*
`purchase_items`.`id`
`purchase_items`.`purchase_order_id`
`purchase_items`.`category`
`purchase_items`.`item_name`
`purchase_items`.`product_code`
`purchase_items`.`brand`
`purchase_items`.`quantity`
`purchase_items`.`unit`
`purchase_items`.`unit_price`
`purchase_items`.`unit_price_vat`
`purchase_items`.`total_price`
`purchase_items`.`remarks`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`order_date`
`purchase_orders`.`product_type`
`purchase_orders`.`item_name`
`purchase_orders`.`required_date`
`purchase_orders`.`product_code`
`purchase_orders`.`brand`
`purchase_orders`.`size`
`purchase_orders`.`remark`
`purchase_orders`.`quantity`
`purchase_orders`.`unit`
`purchase_orders`.`price_before_vat`
`purchase_orders`.`price_with_vat`
`purchase_orders`.`total_amount`
`purchase_orders`.`pr_number`
`purchase_orders`.`foreman`
`purchase_orders`.`job_number`
`purchase_orders`.`job_name`
`purchase_orders`.`vendor`
`purchase_orders`.`phone`
`purchase_orders`.`po_number`
`purchase_orders`.`ordered_by`
`purchase_orders`.`order_date_time`
`purchase_orders`.`expected_date`
`purchase_orders`.`received_date`
`purchase_orders`.`received_by`
`purchase_orders`.`invoice_no`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`qa_in_store`.*
`qa_in_store`.`id`
`qa_in_store`.`update_date`
`qa_in_store`.`category`
`qa_in_store`.`product_name`
`qa_in_store`.`required_date`
`qa_in_store`.`product_code`
`qa_in_store`.`brand`
`qa_in_store`.`size`
`qa_in_store`.`note`
`qa_in_store`.`quantity`
`qa_in_store`.`unit`
`qa_in_store`.`price_before_vat`
`qa_in_store`.`price_with_vat`
`qa_in_store`.`total_amount`
`qa_in_store`.`pr_number`
`qa_in_store`.`foreman`
`qa_in_store`.`job`
`qa_in_store`.`remarks`
`qa_in_store`.`vendor`
`qa_in_store`.`phone_number`
`qa_in_store`.`po`
`qa_in_store`.`order_person`
`qa_in_store`.`order_date`
`qa_in_store`.`delivery_date`
`qa_in_store`.`received_date`
`qa_in_store`.`receiver`
`qa_in_store`.`invoice_bill`
`qa_in_store`.`image`
`qa_in_store`.`created_at`
`qa_in_store`.`updated_at`
`qa_in_store_images`.*
`qa_in_store_images`.`id`
`qa_in_store_images`.`qa_store_id`
`qa_in_store_images`.`image_name`
`qa_in_store_images`.`original_name`
`qa_in_store_images`.`file_path`
`qa_in_store_images`.`file_size`
`qa_in_store_images`.`mime_type`
`qa_in_store_images`.`image_type`
`qa_in_store_images`.`upload_order`
`qa_in_store_images`.`uploaded_at`
`qa_in_store_images`.`updated_at`
`recent_contacts`.*
`recent_contacts`.`id`
`recent_contacts`.`name`
`recent_contacts`.`email`
`recent_contacts`.`phone`
`recent_contacts`.`subject`
`recent_contacts`.`message_preview`
`recent_contacts`.`company`
`recent_contacts`.`project_type`
`recent_contacts`.`status`
`recent_contacts`.`priority`
`recent_contacts`.`created_at`
`return_evidence`.*
`return_evidence`.`id`
`return_evidence`.`transaction_id`
`return_evidence`.`evidence_type`
`return_evidence`.`file_path`
`return_evidence`.`file_name`
`return_evidence`.`file_size`
`return_evidence`.`description`
`return_evidence`.`uploaded_by`
`return_evidence`.`created_at`
`return_feedback`.*
`return_feedback`.`id`
`return_feedback`.`transaction_id`
`return_feedback`.`borrower_rating`
`return_feedback`.`service_rating`
`return_feedback`.`equipment_quality_rating`
`return_feedback`.`feedback_message`
`return_feedback`.`suggestions`
`return_feedback`.`submitted_at`
`return_logs`.*
`return_logs`.`id`
`return_logs`.`borrow_id`
`return_logs`.`equipment_id`
`return_logs`.`quantity_returned`
`return_logs`.`return_date`
`return_logs`.`condition_on_return`
`return_logs`.`return_notes`
`return_logs`.`return_signature`
`return_logs`.`attachment_file`
`return_logs`.`processed_by`
`return_logs`.`created_at`
`return_notifications`.*
`return_notifications`.`id`
`return_notifications`.`transaction_id`
`return_notifications`.`notification_type`
`return_notifications`.`message`
`return_notifications`.`sent_at`
`return_notifications`.`read_at`
`return_notifications`.`created_at`
`return_signatures`.*
`return_signatures`.`id`
`return_signatures`.`transaction_id`
`return_signatures`.`returner_signature`
`return_signatures`.`receiver_signature`
`return_signatures`.`return_condition`
`return_signatures`.`return_notes`
`return_signatures`.`created_at`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`permissions`
`roles`.`created_at`
`roles`.`updated_at`
`stock_logs`.*
`stock_logs`.`id`
`stock_logs`.`equipment_id`
`stock_logs`.`action`
`stock_logs`.`quantity`
`stock_logs`.`notes`
`stock_logs`.`created_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`contact_info`
`system_permissions`.*
`system_permissions`.`id`
`system_permissions`.`role_id`
`system_permissions`.`system_key`
`system_permissions`.`can_access`
`system_permissions`.`created_at`
`system_permissions`.`updated_at`
`system_settings`.*
`system_settings`.`id`
`system_settings`.`setting_key`
`system_settings`.`setting_value`
`system_settings`.`setting_type`
`system_settings`.`description`
`system_settings`.`is_public`
`system_settings`.`created_at`
`system_settings`.`updated_at`
`team_members`.*
`team_members`.`id`
`team_members`.`team_id`
`team_members`.`member_name`
`team_members`.`member_photo`
`team_members`.`created_at`
`teams`.*
`teams`.`id`
`teams`.`department`
`teams`.`team_name`
`teams`.`team_leader`
`teams`.`leader_photo`
`teams`.`created_at`
`teams`.`updated_at`
`tool_categories`.*
`tool_categories`.`id`
`tool_categories`.`category_name`
`tool_categories`.`description`
`tool_categories`.`created_at`
`tools_new`.*
`tools_new`.`id`
`tools_new`.`img`
`tools_new`.`name`
`tools_new`.`model`
`tools_new`.`brand`
`tools_new`.`serial`
`tools_new`.`quantity`
`tools_new`.`description`
`tools_new`.`status`
`tools_new`.`location`
`tools_new`.`created_at`
`traffic_report_photos`.*
`traffic_report_photos`.`id`
`traffic_report_photos`.`traffic_report_id`
`traffic_report_photos`.`filename`
`traffic_report_photos`.`uploaded_by`
`traffic_report_photos`.`uploaded_at`
`traffic_reports`.*
`traffic_reports`.`id`
`traffic_reports`.`reservation_id`
`traffic_reports`.`driver_name`
`traffic_reports`.`status`
`traffic_reports`.`lat`
`traffic_reports`.`lng`
`traffic_reports`.`location_text`
`traffic_reports`.`note`
`traffic_reports`.`reported_at`
`traffic_reports`.`mileage`
`user_activity_logs`.*
`user_activity_logs`.`id`
`user_activity_logs`.`user_id`
`user_activity_logs`.`username`
`user_activity_logs`.`action_type`
`user_activity_logs`.`module`
`user_activity_logs`.`action_description`
`user_activity_logs`.`ip_address`
`user_activity_logs`.`user_agent`
`user_activity_logs`.`additional_data`
`user_activity_logs`.`created_at`
`user_sessions`.*
`user_sessions`.`id`
`user_sessions`.`user_id`
`user_sessions`.`session_id`
`user_sessions`.`ip_address`
`user_sessions`.`user_agent`
`user_sessions`.`created_at`
`user_sessions`.`last_activity`
`user_sessions`.`is_active`
`users`.*
`users`.`user_id`
`users`.`username`
`users`.`password`
`users`.`email`
`users`.`role_id`
`users`.`created_at`
`users`.`status`
`users`.`approved_by`
`users`.`approved_at`
`v_all_borrowing`.*
`v_all_borrowing`.`source_table`
`v_all_borrowing`.`id`
`v_all_borrowing`.`equipment_id`
`v_all_borrowing`.`equipment_name`
`v_all_borrowing`.`category`
`v_all_borrowing`.`borrower_name`
`v_all_borrowing`.`borrower_department`
`v_all_borrowing`.`borrower_phone`
`v_all_borrowing`.`quantity`
`v_all_borrowing`.`borrow_date`
`v_all_borrowing`.`expected_return_date`
`v_all_borrowing`.`actual_return_date`
`v_all_borrowing`.`status`
`v_all_borrowing`.`purpose`
`v_all_borrowing`.`days_overdue`
`v_borrow_summary`.*
`v_borrow_summary`.`equipment_id`
`v_borrow_summary`.`equipment_name`
`v_borrow_summary`.`model`
`v_borrow_summary`.`brand`
`v_borrow_summary`.`quantity`
`v_borrow_summary`.`equipment_status`
`v_borrow_summary`.`total_borrows`
`v_borrow_summary`.`currently_borrowed`
`v_borrow_summary`.`last_borrow_date`
`v_borrow_summary`.`last_return_date`
`v_borrow_summary`.`availability_status`
`v_borrowing_stats`.*
`v_borrowing_stats`.`borrower_name`
`v_borrowing_stats`.`borrower_department`
`v_borrowing_stats`.`borrower_phone`
`v_borrowing_stats`.`total_items`
`v_borrowing_stats`.`overdue_items`
`v_borrowing_stats`.`first_borrow_date`
`v_borrowing_stats`.`last_expected_return`
`vehicle_photos`.*
`vehicle_photos`.`id`
`vehicle_photos`.`vehicle_id`
`vehicle_photos`.`filename`
`vehicle_photos`.`sort_order`
`vehicle_photos`.`created_at`
`vehicle_repairs`.*
`vehicle_repairs`.`id`
`vehicle_repairs`.`vehicle_id`
`vehicle_repairs`.`car_plate`
`vehicle_repairs`.`repair_date`
`vehicle_repairs`.`repair_type`
`vehicle_repairs`.`description`
`vehicle_repairs`.`cost`
`vehicle_repairs`.`garage`
`vehicle_repairs`.`mileage_at_repair`
`vehicle_repairs`.`next_repair_km`
`vehicle_repairs`.`next_repair_date`
`vehicle_repairs`.`note`
`vehicle_repairs`.`created_by`
`vehicle_repairs`.`created_at`
`vehicles`.*
`vehicles`.`id`
`vehicles`.`car_plate`
`vehicles`.`car_type`
`vehicles`.`res_car_type`
`vehicles`.`vehicle_kind`
`vehicles`.`brand`
`vehicles`.`model`
`vehicles`.`car_year`
`vehicles`.`color`
`vehicles`.`fuel_type`
`vehicles`.`engine_cc`
`vehicles`.`engine_cylinders`
`vehicles`.`horsepower_hp`
`vehicles`.`cargo_width_m`
`vehicles`.`cargo_length_m`
`vehicles`.`cargo_height_m`
`vehicles`.`timing_system`
`vehicles`.`timing_note`
`vehicles`.`chassis_no`
`vehicles`.`engine_no`
`vehicles`.`reg_date`
`vehicles`.`reg_date_text`
`vehicles`.`vehicle_age_years`
`vehicles`.`reg_expire`
`vehicles`.`insurance_co`
`vehicles`.`insurance_no`
`vehicles`.`insurance_expire`
`vehicles`.`inspect_expire`
`vehicles`.`last_service_km`
`vehicles`.`last_service_date`
`vehicles`.`next_service_km`
`vehicles`.`next_service_date`
`vehicles`.`current_km`
`vehicles`.`gross_weight_kg`
`vehicles`.`curb_weight_kg`
`vehicles`.`payload_weight_kg`
`vehicles`.`department`
`vehicles`.`assigned_driver`
`vehicles`.`remark`
`vehicles`.`status`
`vehicles`.`created_at`
`warehouse_categories`.*
`warehouse_categories`.`id`
`warehouse_categories`.`category_name`
`warehouse_categories`.`created_at`
`warehouse_categories`.`is_active`
`warehouse_column_settings`.*
`warehouse_column_settings`.`id`
`warehouse_column_settings`.`user_id`
`warehouse_column_settings`.`setting_name`
`warehouse_column_settings`.`column_order`
`warehouse_column_settings`.`created_at`
`warehouse_column_settings`.`updated_at`
`warehouse_products`.*
`warehouse_products`.`id`
`warehouse_products`.`product_code`
`warehouse_products`.`brand`
`warehouse_products`.`category`
`warehouse_products`.`product_name`
`warehouse_products`.`quantity`
`warehouse_products`.`unit`
`warehouse_products`.`barcode`
`warehouse_products`.`shelf`
`warehouse_products`.`location`
`warehouse_products`.`created_by`
`warehouse_products`.`image`
`warehouse_products`.`created_at`
`warehouse_products`.`updated_at`
`warehouse_products`.`price`
`warehouse_products`.`cost`
`warehouse_products`.`supplier`
`warehouse_products`.`minimum_stock`
`warehouse_products`.`status`
`warehouse_products`.`description`
`warehouse_receive_history`.*
`warehouse_receive_history`.`id`
`warehouse_receive_history`.`product_id`
`warehouse_receive_history`.`receive_date`
`warehouse_receive_history`.`status`
`warehouse_receive_history`.`transaction_type`
`warehouse_receive_history`.`quantity`
`warehouse_receive_history`.`job_number`
`warehouse_receive_history`.`job_name`
`warehouse_receive_history`.`supplier`
`warehouse_receive_history`.`foreman`
`warehouse_receive_history`.`recorder`
`warehouse_receive_history`.`created_at`
`warehouse_receive_history`.`po_id`
`warehouse_scan_log`.*
`warehouse_scan_log`.`id`
`warehouse_scan_log`.`logged_at`
`warehouse_scan_log`.`action`
`warehouse_scan_log`.`username`
`warehouse_scan_log`.`product_id`
`warehouse_scan_log`.`product_name`
`warehouse_scan_log`.`product_code`
`warehouse_scan_log`.`barcode`
`warehouse_scan_log`.`field`
`warehouse_scan_log`.`new_value`
`warehouse_scan_log`.`query_text`
`warehouse_units`.*
`warehouse_units`.`id`
`warehouse_units`.`unit_name`
`warehouse_units`.`created_at`
`warehouse_units`.`is_active`
`wep_contact`.*
`wep_contact`.`id`
`wep_contact`.`name`
`wep_contact`.`email`
`wep_contact`.`phone`
`wep_contact`.`subject`
`wep_contact`.`message`
`wep_contact`.`company`
`wep_contact`.`project_type`
`wep_contact`.`budget_range`
`wep_contact`.`status`
`wep_contact`.`priority`
`wep_contact`.`ip_address`
`wep_contact`.`user_agent`
`wep_contact`.`source_page`
`wep_contact`.`admin_notes`
`wep_contact`.`replied_by`
`wep_contact`.`replied_at`
`wep_contact`.`created_at`
`wep_contact`.`updated_at`
`wep_news`.*
`wep_news`.`id`
`wep_news`.`title`
`wep_news`.`content`
`wep_news`.`image`
`wep_news`.`author_id`
`wep_news`.`author_name`
`wep_news`.`status`
`wep_news`.`priority`
`wep_news`.`views`
`wep_news`.`created_date`
`wep_news`.`updated_date`
`wep_news`.`published_date`
`wep_performances`.*
`wep_performances`.`id`
`wep_performances`.`job_number`
`wep_performances`.`name_job`
`wep_performances`.`detail`
`wep_performances`.`images`
`wep_performances`.`status`
`wep_performances`.`created_by`
`wep_performances`.`created_at`
`wep_performances`.`updated_at`
`wep_performances`.`view_count`
`wep_products`.*
`wep_products`.`id`
`wep_products`.`product_name`
`wep_products`.`main_image`
`wep_products`.`secondary_images`
`wep_products`.`product_video`
`wep_products`.`price`
`wep_products`.`description`
`wep_products`.`status`
`wep_products`.`created_by`
`wep_products`.`created_at`
`wep_products`.`updated_at`
`wep_products`.`view_count`
`withdrawal_items`.*
`withdrawal_items`.`id`
`withdrawal_items`.`withdrawal_id`
`withdrawal_items`.`item_name`
`withdrawal_items`.`quantity`
`withdrawal_items`.`unit`
`withdrawal_items`.`remarks`
`withdrawals`.*
`withdrawals`.`id`
`withdrawals`.`withdrawal_number`
`withdrawals`.`withdrawal_date`
`withdrawals`.`job_number`
`withdrawals`.`project_name`
`withdrawals`.`requester`
`withdrawals`.`remarks`
`withdrawals`.`created_at`
`work_plan_files`.*
`work_plan_files`.`id`
`work_plan_files`.`work_plan_id`
`work_plan_files`.`file_name`
`work_plan_files`.`original_name`
`work_plan_files`.`file_type`
`work_plan_files`.`file_size`
`work_plan_files`.`uploaded_by`
`work_plan_files`.`uploaded_at`
`work_plans`.*
`work_plans`.`id`
`work_plans`.`parent_id`
`work_plans`.`team_id`
`work_plans`.`team_name`
`work_plans`.`department`
`work_plans`.`job_number`
`work_plans`.`job_title`
`work_plans`.`supervisor`
`work_plans`.`team_leader`
`work_plans`.`work_type`
`work_plans`.`work_type_label`
`work_plans`.`start_date`
`work_plans`.`start_time`
`work_plans`.`end_date`
`work_plans`.`end_time`
`work_plans`.`location`
`work_plans`.`province`
`work_plans`.`description`
`work_plans`.`members`
`work_plans`.`status`
`work_plans`.`created_by`
`work_plans`.`created_at`
`work_plans`.`updated_at`
`activity_logs`.*
`activity_logs`.`log_id`
`activity_logs`.`user_id`
`activity_logs`.`action`
`activity_logs`.`affected_user_id`
`activity_logs`.`created_at`
`activity_logs`.`log_type`
`ad_user`.*
`ad_user`.`id`
`ad_user`.`username`
`ad_user`.`user_id`
`ad_user`.`password`
`ad_user`.`full_name`
`ad_user`.`phone`
`ad_user`.`email`
`ad_user`.`created_date`
`ad_user`.`updated_date`
`ad_user`.`last_login`
`ad_user`.`status`
`ad_user`.`role`
`ad_user`.`profile_image`
`ad_user`.`login_attempts`
`ad_user`.`locked_until`
`admin_logs`.*
`admin_logs`.`log_id`
`admin_logs`.`admin_id`
`admin_logs`.`action`
`admin_logs`.`user_id`
`admin_logs`.`details`
`admin_logs`.`created_at`
`admin_users`.*
`admin_users`.`id`
`admin_users`.`username`
`admin_users`.`password`
`admin_users`.`created_at`
`borrow_transactions`.*
`borrow_transactions`.`id`
`borrow_transactions`.`equipment_id`
`borrow_transactions`.`transaction_type`
`borrow_transactions`.`quantity`
`borrow_transactions`.`user_name`
`borrow_transactions`.`notes`
`borrow_transactions`.`attachment`
`borrow_transactions`.`approver_name`
`borrow_transactions`.`return_signature`
`borrow_transactions`.`borrow_signature`
`borrow_transactions`.`borrower_name`
`borrow_transactions`.`borrower_department`
`borrow_transactions`.`borrower_phone`
`borrow_transactions`.`borrowed_date`
`borrow_transactions`.`purpose`
`borrow_transactions`.`borrow_date`
`borrow_transactions`.`due_date`
`borrow_transactions`.`expected_return_date`
`borrow_transactions`.`actual_return_date`
`borrow_transactions`.`borrow_request_id`
`borrow_transactions`.`status`
`borrow_transactions`.`user_id`
`borrow_transactions`.`condition_on_return`
`borrow_transactions`.`return_notes`
`borrow_transactions`.`created_at`
`borrower_blacklist`.*
`borrower_blacklist`.`id`
`borrower_blacklist`.`borrower_name`
`borrower_blacklist`.`borrower_department`
`borrower_blacklist`.`reason`
`borrower_blacklist`.`blacklist_date`
`borrower_blacklist`.`expiry_date`
`borrower_blacklist`.`status`
`borrower_blacklist`.`created_by`
`borrower_blacklist`.`notes`
`car_reservation_photos`.*
`car_reservation_photos`.`id`
`car_reservation_photos`.`reservation_id`
`car_reservation_photos`.`filename`
`car_reservation_photos`.`uploaded_by`
`car_reservation_photos`.`created_at`
`car_reservations`.*
`car_reservations`.`id`
`car_reservations`.`doc_no`
`car_reservations`.`book_date`
`car_reservations`.`work_time`
`car_reservations`.`use_date`
`car_reservations`.`return_date`
`car_reservations`.`depart_time`
`car_reservations`.`return_time`
`car_reservations`.`car_type`
`car_reservations`.`destination`
`car_reservations`.`map_url`
`car_reservations`.`contact_name`
`car_reservations`.`job_no`
`car_reservations`.`has_map`
`car_reservations`.`contact_tel`
`car_reservations`.`pickup_location`
`car_reservations`.`pickup_datetime`
`car_reservations`.`has_staff`
`car_reservations`.`staff_data`
`car_reservations`.`job_type`
`car_reservations`.`detail`
`car_reservations`.`detail2`
`car_reservations`.`return_type`
`car_reservations`.`return_location`
`car_reservations`.`car_plate`
`car_reservations`.`vehicle_id`
`car_reservations`.`driver_name`
`car_reservations`.`requester_sign`
`car_reservations`.`requester_tel`
`car_reservations`.`status`
`car_reservations`.`created_by`
`car_reservations`.`created_at`
`car_reservations`.`updated_at`
`categories`.*
`categories`.`id`
`categories`.`name`
`contact_summary`.*
`contact_summary`.`status`
`contact_summary`.`priority`
`contact_summary`.`total_contacts`
`contact_summary`.`this_week`
`contact_summary`.`this_month`
`data_user`.*
`data_user`.`id`
`data_user`.`username`
`data_user`.`fullname`
`data_user`.`department`
`data_user`.`password`
`data_user`.`email`
`data_user`.`role`
`data_user`.`status`
`data_user`.`created_at`
`drivers`.*
`drivers`.`id`
`drivers`.`user_id`
`drivers`.`password`
`drivers`.`driver_name`
`drivers`.`nickname`
`drivers`.`contact_number`
`drivers`.`license_type`
`drivers`.`skills`
`drivers`.`photo`
`drivers`.`gps_consent`
`drivers`.`status`
`drivers`.`created_at`
`employees`.*
`employees`.`id`
`employees`.`team_name`
`employees`.`employee_id`
`employees`.`full_name`
`employees`.`department`
`employees`.`photo`
`employees`.`created_at`
`employees`.`team_color`
`employees`.`status`
`employees`.`daily_wage`
`employees`.`ot_wage`
`equipment_categories`.*
`equipment_categories`.`id`
`equipment_categories`.`name`
`equipment_categories`.`description`
`equipment_categories`.`color`
`equipment_categories`.`status`
`equipment_categories`.`created_at`
`equipment_categories`.`updated_at`
`equipment_condition_history`.*
`equipment_condition_history`.`id`
`equipment_condition_history`.`equipment_id`
`equipment_condition_history`.`transaction_id`
`equipment_condition_history`.`condition_before`
`equipment_condition_history`.`condition_after`
`equipment_condition_history`.`damage_description`
`equipment_condition_history`.`repair_needed`
`equipment_condition_history`.`repair_cost`
`equipment_condition_history`.`inspector_name`
`equipment_condition_history`.`inspection_date`
`equipment_condition_history`.`notes`
`equipment_maintenance`.*
`equipment_maintenance`.`id`
`equipment_maintenance`.`equipment_id`
`equipment_maintenance`.`maintenance_type`
`equipment_maintenance`.`maintenance_date`
`equipment_maintenance`.`next_maintenance_date`
`equipment_maintenance`.`cost`
`equipment_maintenance`.`description`
`equipment_maintenance`.`status`
`equipment_maintenance`.`technician`
`equipment_maintenance`.`notes`
`equipment_maintenance`.`created_at`
`equipment_transactions`.*
`equipment_transactions`.`id`
`equipment_transactions`.`equipment_id`
`equipment_transactions`.`transaction_type`
`equipment_transactions`.`quantity`
`equipment_transactions`.`user_name`
`equipment_transactions`.`notes`
`equipment_transactions`.`created_at`
`equipment_transactions`.`attachment`
`equipment_transactions`.`approver_name`
`equipment_transactions`.`return_signature`
`equipment_transactions`.`borrow_signature`
`equipment_transactions`.`borrower_name`
`equipment_transactions`.`borrower_department`
`equipment_transactions`.`borrower_phone`
`equipment_transactions`.`returner_name`
`equipment_transactions`.`returner_department`
`equipment_transactions`.`returner_position`
`equipment_transactions`.`returner_code`
`equipment_transactions`.`purpose`
`equipment_transactions`.`borrow_date`
`equipment_transactions`.`expected_return_date`
`equipment_transactions`.`actual_return_date`
`equipment_transactions`.`borrow_request_id`
`equipment_transactions`.`status`
`equipment_transactions`.`user_id`
`equipment_transactions`.`condition_on_return`
`equipment_transactions`.`return_notes`
`equipment_transactions`.`receiver_name`
`equipment_transactions`.`receiver_role`
`equipment_transactions`.`signature_borrower`
`equipment_transactions`.`signature_receiver`
`equipment_transactions`.`related_borrow_id`
`equipment_usage_stats`.*
`equipment_usage_stats`.`id`
`equipment_usage_stats`.`equipment_id`
`equipment_usage_stats`.`total_borrows`
`equipment_usage_stats`.`total_returns`
`equipment_usage_stats`.`overdue_count`
`equipment_usage_stats`.`damage_count`
`equipment_usage_stats`.`total_usage_hours`
`equipment_usage_stats`.`average_rating`
`equipment_usage_stats`.`last_borrowed_date`
`equipment_usage_stats`.`last_returned_date`
`equipment_usage_stats`.`updated_at`
`equipments`.*
`equipments`.`id`
`equipments`.`img`
`equipments`.`name`
`equipments`.`model`
`equipments`.`brand`
`equipments`.`serial_number`
`equipments`.`serial`
`equipments`.`quantity`
`equipments`.`category_id`
`equipments`.`description`
`equipments`.`status`
`equipments`.`condition_status`
`equipments`.`location`
`equipments`.`purchase_date`
`equipments`.`purchase_price`
`equipments`.`warranty_expiry`
`equipments`.`last_maintenance`
`equipments`.`image_path`
`equipments`.`created_at`
`equipments`.`updated_at`
`foreman_approvers`.*
`foreman_approvers`.`id`
`foreman_approvers`.`user_id`
`foreman_approvers`.`user_name`
`foreman_approvers`.`role`
`foreman_approvers`.`department`
`foreman_approvers`.`max_approval_amount`
`foreman_approvers`.`is_active`
`foreman_approvers`.`created_at`
`foreman_approvers`.`updated_at`
`foreman_material_attachments`.*
`foreman_material_attachments`.`id`
`foreman_material_attachments`.`breakdown_id`
`foreman_material_attachments`.`file_name`
`foreman_material_attachments`.`file_path`
`foreman_material_attachments`.`file_type`
`foreman_material_attachments`.`file_size`
`foreman_material_attachments`.`description`
`foreman_material_attachments`.`uploaded_by`
`foreman_material_attachments`.`uploaded_by_name`
`foreman_material_attachments`.`created_at`
`foreman_material_breakdown`.*
`foreman_material_breakdown`.`id`
`foreman_material_breakdown`.`foreman_id`
`foreman_material_breakdown`.`foreman_name`
`foreman_material_breakdown`.`project_name`
`foreman_material_breakdown`.`job_number`
`foreman_material_breakdown`.`customer`
`foreman_material_breakdown`.`project_owner`
`foreman_material_breakdown`.`location`
`foreman_material_breakdown`.`required_date`
`foreman_material_breakdown`.`installation_date`
`foreman_material_breakdown`.`status`
`foreman_material_breakdown`.`remarks`
`foreman_material_breakdown`.`created_at`
`foreman_material_breakdown`.`updated_at`
`foreman_material_breakdown`.`submitted_at`
`foreman_material_breakdown`.`approved_at`
`foreman_material_breakdown`.`approved_by`
`foreman_material_breakdown`.`approved_by_name`
`foreman_material_breakdown`.`rejected_at`
`foreman_material_breakdown`.`rejected_by`
`foreman_material_breakdown`.`rejected_by_name`
`foreman_material_breakdown`.`rejection_reason`
`foreman_material_breakdown`.`store_confirmed_by`
`foreman_material_breakdown`.`store_confirmed_by_name`
`foreman_material_breakdown`.`store_confirmed_at`
`foreman_material_items`.*
`foreman_material_items`.`id`
`foreman_material_items`.`breakdown_id`
`foreman_material_items`.`material_id`
`foreman_material_items`.`material_code`
`foreman_material_items`.`material_name`
`foreman_material_items`.`brand`
`foreman_material_items`.`order_date`
`foreman_material_items`.`required_qty`
`foreman_material_items`.`required_unit`
`foreman_material_items`.`stock_qty`
`foreman_material_items`.`stock_unit`
`foreman_material_items`.`order_qty`
`foreman_material_items`.`approved_qty`
`foreman_material_items`.`actual_qty`
`foreman_material_items`.`received_qty`
`foreman_material_items`.`received_date`
`foreman_material_items`.`received_by`
`foreman_material_items`.`item_remarks`
`foreman_material_items`.`is_paid`
`foreman_material_items`.`is_checked`
`foreman_material_items`.`checked_by`
`foreman_material_items`.`checked_at`
`foreman_material_items`.`paid_by`
`foreman_material_items`.`paid_at`
`foreman_material_items`.`created_at`
`foreman_material_items`.`updated_at`
`foreman_material_items`.`sort_order`
`foreman_material_logs`.*
`foreman_material_logs`.`id`
`foreman_material_logs`.`breakdown_id`
`foreman_material_logs`.`action`
`foreman_material_logs`.`user_id`
`foreman_material_logs`.`user_name`
`foreman_material_logs`.`user_role`
`foreman_material_logs`.`old_status`
`foreman_material_logs`.`new_status`
`foreman_material_logs`.`remarks`
`foreman_material_logs`.`ip_address`
`foreman_material_logs`.`created_at`
`foreman_material_received`.*
`foreman_material_received`.`id`
`foreman_material_received`.`item_id`
`foreman_material_received`.`received_no`
`foreman_material_received`.`received_qty`
`foreman_material_received`.`received_date`
`foreman_material_received`.`received_by`
`foreman_material_received`.`issued_by`
`foreman_material_received`.`warehouse_history_id`
`foreman_material_received`.`remarks`
`foreman_material_received`.`created_at`
`foreman_material_received`.`updated_at`
`foreman_users`.*
`foreman_users`.`id`
`foreman_users`.`password`
`foreman_users`.`full_name`
`foreman_users`.`nickname`
`foreman_users`.`department`
`foreman_users`.`photo`
`foreman_users`.`photo_filename`
`foreman_users`.`signature`
`foreman_users`.`created_at`
`foreman_users`.`updated_at`
`holidays`.*
`holidays`.`id`
`holidays`.`holiday_name`
`holidays`.`holiday_date`
`holidays`.`description`
`incoming_items`.*
`incoming_items`.`id`
`incoming_items`.`date`
`incoming_items`.`category`
`incoming_items`.`item_name`
`incoming_items`.`required_date`
`incoming_items`.`product_code`
`incoming_items`.`brand`
`incoming_items`.`size`
`incoming_items`.`note`
`incoming_items`.`quantity`
`incoming_items`.`unit`
`incoming_items`.`price_before_vat`
`incoming_items`.`price_with_vat`
`incoming_items`.`total_price`
`incoming_items`.`pr_number`
`incoming_items`.`foreman`
`incoming_items`.`job_number`
`incoming_items`.`job_name`
`incoming_items`.`vendor`
`incoming_items`.`vendor_phone`
`incoming_items`.`po_number`
`incoming_items`.`order_by`
`incoming_items`.`order_date`
`incoming_items`.`appointment_date`
`incoming_items`.`received_date`
`incoming_items`.`received_by`
`incoming_items`.`invoice_number`
`incoming_items`.`status`
`incoming_items`.`created_by`
`incoming_items`.`created_date`
`incoming_items`.`updated_at`
`led_item`.*
`led_item`.`id`
`led_item`.`name_item`
`led_item`.`detail`
`led_item`.`Rem_Amt`
`led_item`.`type`
`led_item`.`img`
`led_transactions`.*
`led_transactions`.`id`
`led_transactions`.`item_id`
`led_transactions`.`job_number`
`led_transactions`.`operator`
`led_transactions`.`type`
`led_transactions`.`quantity`
`led_transactions`.`remark`
`led_transactions`.`transaction_date`
`led_types`.*
`led_types`.`type_id`
`led_types`.`type_name`
`loan_members`.*
`loan_members`.`id`
`loan_members`.`name`
`loan_members`.`department`
`loan_members`.`position`
`loan_members`.`name_leader`
`loan_members`.`phone`
`loan_members`.`email`
`loan_members`.`image`
`loan_members`.`status`
`loan_members`.`approval_status`
`loan_members`.`approved_by`
`loan_members`.`approved_date`
`loan_members`.`member_code`
`loan_members`.`notes`
`loan_members`.`created_at`
`loan_members`.`updated_at`
`media_equipment`.*
`media_equipment`.`id`
`media_equipment`.`equipment_code`
`media_equipment`.`equipment_name`
`media_equipment`.`equipment_type`
`media_equipment`.`brand`
`media_equipment`.`model`
`media_equipment`.`serial_number`
`media_equipment`.`size`
`media_equipment`.`location`
`media_equipment`.`status`
`media_equipment`.`stock_quantity`
`media_equipment`.`min_quantity`
`media_equipment`.`image_path`
`media_equipment`.`notes`
`media_equipment`.`created_at`
`media_equipment`.`updated_at`
`media_equipment`.`last_stock_update`
`pending_contacts`.*
`pending_contacts`.`id`
`pending_contacts`.`name`
`pending_contacts`.`email`
`pending_contacts`.`subject`
`pending_contacts`.`company`
`pending_contacts`.`project_type`
`pending_contacts`.`priority`
`pending_contacts`.`days_waiting`
`pending_contacts`.`created_at`
`purchase_items`.*
`purchase_items`.`id`
`purchase_items`.`purchase_order_id`
`purchase_items`.`category`
`purchase_items`.`item_name`
`purchase_items`.`product_code`
`purchase_items`.`brand`
`purchase_items`.`quantity`
`purchase_items`.`unit`
`purchase_items`.`unit_price`
`purchase_items`.`unit_price_vat`
`purchase_items`.`total_price`
`purchase_items`.`remarks`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`order_date`
`purchase_orders`.`product_type`
`purchase_orders`.`item_name`
`purchase_orders`.`required_date`
`purchase_orders`.`product_code`
`purchase_orders`.`brand`
`purchase_orders`.`size`
`purchase_orders`.`remark`
`purchase_orders`.`quantity`
`purchase_orders`.`unit`
`purchase_orders`.`price_before_vat`
`purchase_orders`.`price_with_vat`
`purchase_orders`.`total_amount`
`purchase_orders`.`pr_number`
`purchase_orders`.`foreman`
`purchase_orders`.`job_number`
`purchase_orders`.`job_name`
`purchase_orders`.`vendor`
`purchase_orders`.`phone`
`purchase_orders`.`po_number`
`purchase_orders`.`ordered_by`
`purchase_orders`.`order_date_time`
`purchase_orders`.`expected_date`
`purchase_orders`.`received_date`
`purchase_orders`.`received_by`
`purchase_orders`.`invoice_no`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`qa_in_store`.*
`qa_in_store`.`id`
`qa_in_store`.`update_date`
`qa_in_store`.`category`
`qa_in_store`.`product_name`
`qa_in_store`.`required_date`
`qa_in_store`.`product_code`
`qa_in_store`.`brand`
`qa_in_store`.`size`
`qa_in_store`.`note`
`qa_in_store`.`quantity`
`qa_in_store`.`unit`
`qa_in_store`.`price_before_vat`
`qa_in_store`.`price_with_vat`
`qa_in_store`.`total_amount`
`qa_in_store`.`pr_number`
`qa_in_store`.`foreman`
`qa_in_store`.`job`
`qa_in_store`.`remarks`
`qa_in_store`.`vendor`
`qa_in_store`.`phone_number`
`qa_in_store`.`po`
`qa_in_store`.`order_person`
`qa_in_store`.`order_date`
`qa_in_store`.`delivery_date`
`qa_in_store`.`received_date`
`qa_in_store`.`receiver`
`qa_in_store`.`invoice_bill`
`qa_in_store`.`image`
`qa_in_store`.`created_at`
`qa_in_store`.`updated_at`
`qa_in_store_images`.*
`qa_in_store_images`.`id`
`qa_in_store_images`.`qa_store_id`
`qa_in_store_images`.`image_name`
`qa_in_store_images`.`original_name`
`qa_in_store_images`.`file_path`
`qa_in_store_images`.`file_size`
`qa_in_store_images`.`mime_type`
`qa_in_store_images`.`image_type`
`qa_in_store_images`.`upload_order`
`qa_in_store_images`.`uploaded_at`
`qa_in_store_images`.`updated_at`
`recent_contacts`.*
`recent_contacts`.`id`
`recent_contacts`.`name`
`recent_contacts`.`email`
`recent_contacts`.`phone`
`recent_contacts`.`subject`
`recent_contacts`.`message_preview`
`recent_contacts`.`company`
`recent_contacts`.`project_type`
`recent_contacts`.`status`
`recent_contacts`.`priority`
`recent_contacts`.`created_at`
`return_evidence`.*
`return_evidence`.`id`
`return_evidence`.`transaction_id`
`return_evidence`.`evidence_type`
`return_evidence`.`file_path`
`return_evidence`.`file_name`
`return_evidence`.`file_size`
`return_evidence`.`description`
`return_evidence`.`uploaded_by`
`return_evidence`.`created_at`
`return_feedback`.*
`return_feedback`.`id`
`return_feedback`.`transaction_id`
`return_feedback`.`borrower_rating`
`return_feedback`.`service_rating`
`return_feedback`.`equipment_quality_rating`
`return_feedback`.`feedback_message`
`return_feedback`.`suggestions`
`return_feedback`.`submitted_at`
`return_logs`.*
`return_logs`.`id`
`return_logs`.`borrow_id`
`return_logs`.`equipment_id`
`return_logs`.`quantity_returned`
`return_logs`.`return_date`
`return_logs`.`condition_on_return`
`return_logs`.`return_notes`
`return_logs`.`return_signature`
`return_logs`.`attachment_file`
`return_logs`.`processed_by`
`return_logs`.`created_at`
`return_notifications`.*
`return_notifications`.`id`
`return_notifications`.`transaction_id`
`return_notifications`.`notification_type`
`return_notifications`.`message`
`return_notifications`.`sent_at`
`return_notifications`.`read_at`
`return_notifications`.`created_at`
`return_signatures`.*
`return_signatures`.`id`
`return_signatures`.`transaction_id`
`return_signatures`.`returner_signature`
`return_signatures`.`receiver_signature`
`return_signatures`.`return_condition`
`return_signatures`.`return_notes`
`return_signatures`.`created_at`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`permissions`
`roles`.`created_at`
`roles`.`updated_at`
`stock_logs`.*
`stock_logs`.`id`
`stock_logs`.`equipment_id`
`stock_logs`.`action`
`stock_logs`.`quantity`
`stock_logs`.`notes`
`stock_logs`.`created_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`contact_info`
`system_permissions`.*
`system_permissions`.`id`
`system_permissions`.`role_id`
`system_permissions`.`system_key`
`system_permissions`.`can_access`
`system_permissions`.`created_at`
`system_permissions`.`updated_at`
`system_settings`.*
`system_settings`.`id`
`system_settings`.`setting_key`
`system_settings`.`setting_value`
`system_settings`.`setting_type`
`system_settings`.`description`
`system_settings`.`is_public`
`system_settings`.`created_at`
`system_settings`.`updated_at`
`team_members`.*
`team_members`.`id`
`team_members`.`team_id`
`team_members`.`member_name`
`team_members`.`member_photo`
`team_members`.`created_at`
`teams`.*
`teams`.`id`
`teams`.`department`
`teams`.`team_name`
`teams`.`team_leader`
`teams`.`leader_photo`
`teams`.`created_at`
`teams`.`updated_at`
`tool_categories`.*
`tool_categories`.`id`
`tool_categories`.`category_name`
`tool_categories`.`description`
`tool_categories`.`created_at`
`tools_new`.*
`tools_new`.`id`
`tools_new`.`img`
`tools_new`.`name`
`tools_new`.`model`
`tools_new`.`brand`
`tools_new`.`serial`
`tools_new`.`quantity`
`tools_new`.`description`
`tools_new`.`status`
`tools_new`.`location`
`tools_new`.`created_at`
`traffic_report_photos`.*
`traffic_report_photos`.`id`
`traffic_report_photos`.`traffic_report_id`
`traffic_report_photos`.`filename`
`traffic_report_photos`.`uploaded_by`
`traffic_report_photos`.`uploaded_at`
`traffic_reports`.*
`traffic_reports`.`id`
`traffic_reports`.`reservation_id`
`traffic_reports`.`driver_name`
`traffic_reports`.`status`
`traffic_reports`.`lat`
`traffic_reports`.`lng`
`traffic_reports`.`location_text`
`traffic_reports`.`note`
`traffic_reports`.`reported_at`
`traffic_reports`.`mileage`
`user_activity_logs`.*
`user_activity_logs`.`id`
`user_activity_logs`.`user_id`
`user_activity_logs`.`username`
`user_activity_logs`.`action_type`
`user_activity_logs`.`module`
`user_activity_logs`.`action_description`
`user_activity_logs`.`ip_address`
`user_activity_logs`.`user_agent`
`user_activity_logs`.`additional_data`
`user_activity_logs`.`created_at`
`user_sessions`.*
`user_sessions`.`id`
`user_sessions`.`user_id`
`user_sessions`.`session_id`
`user_sessions`.`ip_address`
`user_sessions`.`user_agent`
`user_sessions`.`created_at`
`user_sessions`.`last_activity`
`user_sessions`.`is_active`
`users`.*
`users`.`user_id`
`users`.`username`
`users`.`password`
`users`.`email`
`users`.`role_id`
`users`.`created_at`
`users`.`status`
`users`.`approved_by`
`users`.`approved_at`
`v_all_borrowing`.*
`v_all_borrowing`.`source_table`
`v_all_borrowing`.`id`
`v_all_borrowing`.`equipment_id`
`v_all_borrowing`.`equipment_name`
`v_all_borrowing`.`category`
`v_all_borrowing`.`borrower_name`
`v_all_borrowing`.`borrower_department`
`v_all_borrowing`.`borrower_phone`
`v_all_borrowing`.`quantity`
`v_all_borrowing`.`borrow_date`
`v_all_borrowing`.`expected_return_date`
`v_all_borrowing`.`actual_return_date`
`v_all_borrowing`.`status`
`v_all_borrowing`.`purpose`
`v_all_borrowing`.`days_overdue`
`v_borrow_summary`.*
`v_borrow_summary`.`equipment_id`
`v_borrow_summary`.`equipment_name`
`v_borrow_summary`.`model`
`v_borrow_summary`.`brand`
`v_borrow_summary`.`quantity`
`v_borrow_summary`.`equipment_status`
`v_borrow_summary`.`total_borrows`
`v_borrow_summary`.`currently_borrowed`
`v_borrow_summary`.`last_borrow_date`
`v_borrow_summary`.`last_return_date`
`v_borrow_summary`.`availability_status`
`v_borrowing_stats`.*
`v_borrowing_stats`.`borrower_name`
`v_borrowing_stats`.`borrower_department`
`v_borrowing_stats`.`borrower_phone`
`v_borrowing_stats`.`total_items`
`v_borrowing_stats`.`overdue_items`
`v_borrowing_stats`.`first_borrow_date`
`v_borrowing_stats`.`last_expected_return`
`vehicle_photos`.*
`vehicle_photos`.`id`
`vehicle_photos`.`vehicle_id`
`vehicle_photos`.`filename`
`vehicle_photos`.`sort_order`
`vehicle_photos`.`created_at`
`vehicle_repairs`.*
`vehicle_repairs`.`id`
`vehicle_repairs`.`vehicle_id`
`vehicle_repairs`.`car_plate`
`vehicle_repairs`.`repair_date`
`vehicle_repairs`.`repair_type`
`vehicle_repairs`.`description`
`vehicle_repairs`.`cost`
`vehicle_repairs`.`garage`
`vehicle_repairs`.`mileage_at_repair`
`vehicle_repairs`.`next_repair_km`
`vehicle_repairs`.`next_repair_date`
`vehicle_repairs`.`note`
`vehicle_repairs`.`created_by`
`vehicle_repairs`.`created_at`
`vehicles`.*
`vehicles`.`id`
`vehicles`.`car_plate`
`vehicles`.`car_type`
`vehicles`.`res_car_type`
`vehicles`.`vehicle_kind`
`vehicles`.`brand`
`vehicles`.`model`
`vehicles`.`car_year`
`vehicles`.`color`
`vehicles`.`fuel_type`
`vehicles`.`engine_cc`
`vehicles`.`engine_cylinders`
`vehicles`.`horsepower_hp`
`vehicles`.`cargo_width_m`
`vehicles`.`cargo_length_m`
`vehicles`.`cargo_height_m`
`vehicles`.`timing_system`
`vehicles`.`timing_note`
`vehicles`.`chassis_no`
`vehicles`.`engine_no`
`vehicles`.`reg_date`
`vehicles`.`reg_date_text`
`vehicles`.`vehicle_age_years`
`vehicles`.`reg_expire`
`vehicles`.`insurance_co`
`vehicles`.`insurance_no`
`vehicles`.`insurance_expire`
`vehicles`.`inspect_expire`
`vehicles`.`last_service_km`
`vehicles`.`last_service_date`
`vehicles`.`next_service_km`
`vehicles`.`next_service_date`
`vehicles`.`current_km`
`vehicles`.`gross_weight_kg`
`vehicles`.`curb_weight_kg`
`vehicles`.`payload_weight_kg`
`vehicles`.`department`
`vehicles`.`assigned_driver`
`vehicles`.`remark`
`vehicles`.`status`
`vehicles`.`created_at`
`warehouse_categories`.*
`warehouse_categories`.`id`
`warehouse_categories`.`category_name`
`warehouse_categories`.`created_at`
`warehouse_categories`.`is_active`
`warehouse_column_settings`.*
`warehouse_column_settings`.`id`
`warehouse_column_settings`.`user_id`
`warehouse_column_settings`.`setting_name`
`warehouse_column_settings`.`column_order`
`warehouse_column_settings`.`created_at`
`warehouse_column_settings`.`updated_at`
`warehouse_products`.*
`warehouse_products`.`id`
`warehouse_products`.`product_code`
`warehouse_products`.`brand`
`warehouse_products`.`category`
`warehouse_products`.`product_name`
`warehouse_products`.`quantity`
`warehouse_products`.`unit`
`warehouse_products`.`barcode`
`warehouse_products`.`shelf`
`warehouse_products`.`location`
`warehouse_products`.`created_by`
`warehouse_products`.`image`
`warehouse_products`.`created_at`
`warehouse_products`.`updated_at`
`warehouse_products`.`price`
`warehouse_products`.`cost`
`warehouse_products`.`supplier`
`warehouse_products`.`minimum_stock`
`warehouse_products`.`status`
`warehouse_products`.`description`
`warehouse_receive_history`.*
`warehouse_receive_history`.`id`
`warehouse_receive_history`.`product_id`
`warehouse_receive_history`.`receive_date`
`warehouse_receive_history`.`status`
`warehouse_receive_history`.`transaction_type`
`warehouse_receive_history`.`quantity`
`warehouse_receive_history`.`job_number`
`warehouse_receive_history`.`job_name`
`warehouse_receive_history`.`supplier`
`warehouse_receive_history`.`foreman`
`warehouse_receive_history`.`recorder`
`warehouse_receive_history`.`created_at`
`warehouse_receive_history`.`po_id`
`warehouse_scan_log`.*
`warehouse_scan_log`.`id`
`warehouse_scan_log`.`logged_at`
`warehouse_scan_log`.`action`
`warehouse_scan_log`.`username`
`warehouse_scan_log`.`product_id`
`warehouse_scan_log`.`product_name`
`warehouse_scan_log`.`product_code`
`warehouse_scan_log`.`barcode`
`warehouse_scan_log`.`field`
`warehouse_scan_log`.`new_value`
`warehouse_scan_log`.`query_text`
`warehouse_units`.*
`warehouse_units`.`id`
`warehouse_units`.`unit_name`
`warehouse_units`.`created_at`
`warehouse_units`.`is_active`
`wep_contact`.*
`wep_contact`.`id`
`wep_contact`.`name`
`wep_contact`.`email`
`wep_contact`.`phone`
`wep_contact`.`subject`
`wep_contact`.`message`
`wep_contact`.`company`
`wep_contact`.`project_type`
`wep_contact`.`budget_range`
`wep_contact`.`status`
`wep_contact`.`priority`
`wep_contact`.`ip_address`
`wep_contact`.`user_agent`
`wep_contact`.`source_page`
`wep_contact`.`admin_notes`
`wep_contact`.`replied_by`
`wep_contact`.`replied_at`
`wep_contact`.`created_at`
`wep_contact`.`updated_at`
`wep_news`.*
`wep_news`.`id`
`wep_news`.`title`
`wep_news`.`content`
`wep_news`.`image`
`wep_news`.`author_id`
`wep_news`.`author_name`
`wep_news`.`status`
`wep_news`.`priority`
`wep_news`.`views`
`wep_news`.`created_date`
`wep_news`.`updated_date`
`wep_news`.`published_date`
`wep_performances`.*
`wep_performances`.`id`
`wep_performances`.`job_number`
`wep_performances`.`name_job`
`wep_performances`.`detail`
`wep_performances`.`images`
`wep_performances`.`status`
`wep_performances`.`created_by`
`wep_performances`.`created_at`
`wep_performances`.`updated_at`
`wep_performances`.`view_count`
`wep_products`.*
`wep_products`.`id`
`wep_products`.`product_name`
`wep_products`.`main_image`
`wep_products`.`secondary_images`
`wep_products`.`product_video`
`wep_products`.`price`
`wep_products`.`description`
`wep_products`.`status`
`wep_products`.`created_by`
`wep_products`.`created_at`
`wep_products`.`updated_at`
`wep_products`.`view_count`
`withdrawal_items`.*
`withdrawal_items`.`id`
`withdrawal_items`.`withdrawal_id`
`withdrawal_items`.`item_name`
`withdrawal_items`.`quantity`
`withdrawal_items`.`unit`
`withdrawal_items`.`remarks`
`withdrawals`.*
`withdrawals`.`id`
`withdrawals`.`withdrawal_number`
`withdrawals`.`withdrawal_date`
`withdrawals`.`job_number`
`withdrawals`.`project_name`
`withdrawals`.`requester`
`withdrawals`.`remarks`
`withdrawals`.`created_at`
`work_plan_files`.*
`work_plan_files`.`id`
`work_plan_files`.`work_plan_id`
`work_plan_files`.`file_name`
`work_plan_files`.`original_name`
`work_plan_files`.`file_type`
`work_plan_files`.`file_size`
`work_plan_files`.`uploaded_by`
`work_plan_files`.`uploaded_at`
`work_plans`.*
`work_plans`.`id`
`work_plans`.`parent_id`
`work_plans`.`team_id`
`work_plans`.`team_name`
`work_plans`.`department`
`work_plans`.`job_number`
`work_plans`.`job_title`
`work_plans`.`supervisor`
`work_plans`.`team_leader`
`work_plans`.`work_type`
`work_plans`.`work_type_label`
`work_plans`.`start_date`
`work_plans`.`start_time`
`work_plans`.`end_date`
`work_plans`.`end_time`
`work_plans`.`location`
`work_plans`.`province`
`work_plans`.`description`
`work_plans`.`members`
`work_plans`.`status`
`work_plans`.`created_by`
`work_plans`.`created_at`
`work_plans`.`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
activity_logs
ad_user
admin_logs
admin_users
borrow_transactions
borrower_blacklist
car_reservation_photos
car_reservations
categories
contact_summary
data_user
drivers
employees
equipment_categories
equipment_condition_history
equipment_maintenance
equipment_transactions
equipment_usage_stats
equipments
foreman_approvers
foreman_material_attachments
foreman_material_breakdown
foreman_material_items
foreman_material_logs
foreman_material_received
foreman_users
holidays
incoming_items
led_item
led_transactions
led_types
loan_members
media_equipment
pending_contacts
purchase_items
purchase_orders
qa_in_store
qa_in_store_images
recent_contacts
return_evidence
return_feedback
return_logs
return_notifications
return_signatures
roles
stock_logs
suppliers
system_permissions
system_settings
team_members
teams
tool_categories
tools_new
traffic_report_photos
traffic_reports
user_activity_logs
user_sessions
users
v_all_borrowing
v_borrow_summary
v_borrowing_stats
vehicle_photos
vehicle_repairs
vehicles
warehouse_categories
warehouse_column_settings
warehouse_products
warehouse_receive_history
warehouse_scan_log
warehouse_units
wep_contact
wep_news
wep_performances
wep_products
withdrawal_items
withdrawals
work_plan_files
work_plans
SQL query on database
nldsignc_2025
: