Recent
`fitness_studio`.`client_exit_log`
`schema`.`trips`
`fitness_studio`.`programs`
`schema`.`testimonials`
`fitness_studio`.`studio_tasks`
`918carcare`.`proforma_invoices`
`schema`.`users`
`invoicepro`.`projects`
`saqr_watcher`.`user_settings`
`fitness_studio`.`client_progress`
Favorites
There are no favorite tables.
New
918carcare
alnakeel
dailyplanet
fitness_studio
garagesoftware
gym_db
information_schema
invoicepro
majestic_pump
mysql
performance_schema
phpmyadmin
revline_garage
sacretheartschool
saqrsoftwaredata
saqr_watcher
schema
test
truckingbusiness
ums_garage
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: 918carcare
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:
`advance_salary`.*
`advance_salary`.`id`
`advance_salary`.`user_id`
`advance_salary`.`period_year`
`advance_salary`.`period_month`
`advance_salary`.`amount`
`advance_salary`.`expense_id`
`advance_salary`.`branch_id`
`advance_salary`.`created_at`
`branches`.*
`branches`.`id`
`branches`.`name`
`branches`.`code`
`branches`.`address`
`branches`.`is_active`
`branches`.`created_at`
`branches`.`updated_at`
`bulk_payment_invoices`.*
`bulk_payment_invoices`.`id`
`bulk_payment_invoices`.`customer_payment_id`
`bulk_payment_invoices`.`invoice_id`
`bulk_payment_invoices`.`invoice_number`
`bulk_payment_invoices`.`amount_paid`
`bulk_payment_invoices`.`remaining_before`
`bulk_payment_invoices`.`created_at`
`company_documents`.*
`company_documents`.`id`
`company_documents`.`branch_id`
`company_documents`.`document_type`
`company_documents`.`file_url`
`company_documents`.`label`
`company_documents`.`created_at`
`company_settings`.*
`company_settings`.`id`
`company_settings`.`company_name`
`company_settings`.`tagline`
`company_settings`.`address`
`company_settings`.`phone`
`company_settings`.`email`
`company_settings`.`logo_url`
`company_settings`.`created_at`
`company_settings`.`updated_at`
`company_settings`.`trn`
`company_settings`.`no_trn`
`company_settings`.`vehicle_inspection_enabled`
`company_settings`.`branch_id`
`company_settings`.`signature_terms_and_conditions`
`customer_payments`.*
`customer_payments`.`id`
`customer_payments`.`invoice_id`
`customer_payments`.`job_card_id`
`customer_payments`.`customer_id`
`customer_payments`.`invoice_number`
`customer_payments`.`customer_name`
`customer_payments`.`customer_phone`
`customer_payments`.`vehicle_license_plate`
`customer_payments`.`amount`
`customer_payments`.`payment_method`
`customer_payments`.`payment_date`
`customer_payments`.`advance_applied`
`customer_payments`.`invoice_subtotal`
`customer_payments`.`invoice_tax`
`customer_payments`.`invoice_total`
`customer_payments`.`invoice_remaining_before`
`customer_payments`.`invoice_remaining_after`
`customer_payments`.`notes`
`customer_payments`.`created_at`
`customer_payments`.`payment_type`
`customer_payments`.`branch_id`
`customer_payments`.`is_bulk_payment`
`customers`.*
`customers`.`id`
`customers`.`user_id`
`customers`.`first_name`
`customers`.`last_name`
`customers`.`display_name`
`customers`.`gender`
`customers`.`mobile_number`
`customers`.`email`
`customers`.`password_hash`
`customers`.`date_of_birth`
`customers`.`image_url`
`customers`.`address`
`customers`.`total_spent`
`customers`.`last_visit`
`customers`.`created_at`
`customers`.`updated_at`
`customers`.`is_b2b`
`customers`.`company_name`
`customers`.`trn_number`
`customers`.`credit_terms`
`customers`.`special_discount`
`customers`.`contact_person`
`expenses`.*
`expenses`.`id`
`expenses`.`description`
`expenses`.`amount`
`expenses`.`tax`
`expenses`.`total_amount`
`expenses`.`quantity`
`expenses`.`unit_price`
`expenses`.`category`
`expenses`.`payment_method`
`expenses`.`payment_date`
`expenses`.`status`
`expenses`.`vendor`
`expenses`.`invoice_number`
`expenses`.`notes`
`expenses`.`trn`
`expenses`.`approved_by`
`expenses`.`created_at`
`expenses`.`source_type`
`expenses`.`source_id`
`expenses`.`branch_id`
`income`.*
`income`.`id`
`income`.`customer_name`
`income`.`invoice_number`
`income`.`amount`
`income`.`payment_method`
`income`.`payment_date`
`income`.`status`
`income`.`category`
`income`.`description`
`income`.`received_by`
`income`.`created_at`
`income`.`source`
`income`.`customer_payment_id`
`income`.`branch_id`
`inventory_packages`.*
`inventory_packages`.`id`
`inventory_packages`.`branch_id`
`inventory_packages`.`name`
`inventory_packages`.`supplier_id`
`inventory_packages`.`product_id`
`inventory_packages`.`package_quantity`
`inventory_packages`.`buying_price`
`inventory_packages`.`created_at`
`inventory_packages`.`updated_at`
`invoice_items`.*
`invoice_items`.`id`
`invoice_items`.`invoice_id`
`invoice_items`.`description`
`invoice_items`.`quantity`
`invoice_items`.`unit_price`
`invoice_items`.`total`
`invoice_items`.`cost_price`
`invoice_items`.`vendor_name`
`invoice_items`.`vat_for_expense`
`invoice_items`.`proforma_invoice_item_id`
`invoice_items`.`type`
`invoice_items`.`supplier_id`
`invoice_items`.`product_id`
`invoice_items`.`stock_deducted`
`invoice_items`.`created_at`
`invoice_items`.`discount`
`invoices`.*
`invoices`.`id`
`invoices`.`proforma_invoice_id`
`invoices`.`job_card_id`
`invoices`.`customer_id`
`invoices`.`quotation_id`
`invoices`.`invoice_number`
`invoices`.`subtotal`
`invoices`.`tax`
`invoices`.`total_amount`
`invoices`.`advance_amount`
`invoices`.`remaining_amount`
`invoices`.`status`
`invoices`.`due_date`
`invoices`.`paid_date`
`invoices`.`payment_method`
`invoices`.`notes`
`invoices`.`customer_name`
`invoices`.`customer_email`
`invoices`.`customer_phone`
`invoices`.`vehicle_brand`
`invoices`.`vehicle_name`
`invoices`.`vehicle_year`
`invoices`.`vehicle_license_plate`
`invoices`.`vin_number`
`invoices`.`created_at`
`invoices`.`updated_at`
`invoices`.`branch_id`
`invoices`.`sales_vat_exempt`
`invoices`.`discount`
`job_card_assignments`.*
`job_card_assignments`.`id`
`job_card_assignments`.`job_card_id`
`job_card_assignments`.`user_id`
`job_card_assignments`.`expected_labour_hours`
`job_card_assignments`.`labour_hours`
`job_card_assignments`.`created_at`
`job_card_before_after`.*
`job_card_before_after`.`id`
`job_card_before_after`.`job_card_id`
`job_card_before_after`.`before_file_path`
`job_card_before_after`.`after_file_path`
`job_card_before_after`.`description`
`job_card_before_after`.`sort_order`
`job_card_before_after`.`created_at`
`job_card_hidden_expenses`.*
`job_card_hidden_expenses`.`id`
`job_card_hidden_expenses`.`job_card_id`
`job_card_hidden_expenses`.`description`
`job_card_hidden_expenses`.`amount_aed`
`job_card_hidden_expenses`.`payment_method`
`job_card_hidden_expenses`.`vat_applied`
`job_card_hidden_expenses`.`created_at`
`job_card_hidden_expenses`.`expense_type`
`job_card_hidden_expenses`.`supplier_id`
`job_card_hidden_expenses`.`product_id`
`job_card_hidden_expenses`.`quantity`
`job_card_hidden_expenses`.`unit_price`
`job_card_hidden_expenses`.`cost_price`
`job_card_hidden_expenses`.`vendor_name`
`job_card_items`.*
`job_card_items`.`id`
`job_card_items`.`job_card_id`
`job_card_items`.`description`
`job_card_items`.`quantity`
`job_card_items`.`unit_price`
`job_card_items`.`total`
`job_card_items`.`cost_price`
`job_card_items`.`vendor_name`
`job_card_items`.`vat_for_expense`
`job_card_items`.`type`
`job_card_items`.`supplier_id`
`job_card_items`.`product_id`
`job_card_items`.`created_at`
`job_card_items`.`is_done`
`job_card_items`.`discount`
`job_card_photos`.*
`job_card_photos`.`id`
`job_card_photos`.`job_card_id`
`job_card_photos`.`file_path`
`job_card_photos`.`caption`
`job_card_photos`.`type`
`job_card_photos`.`created_at`
`job_card_signature_links`.*
`job_card_signature_links`.`id`
`job_card_signature_links`.`job_card_id`
`job_card_signature_links`.`token`
`job_card_signature_links`.`expires_at`
`job_card_signature_links`.`signed_at`
`job_card_signature_links`.`signature_data_url`
`job_card_signature_links`.`created_at`
`job_card_signatures`.*
`job_card_signatures`.`id`
`job_card_signatures`.`job_card_id`
`job_card_signatures`.`signature_data_url`
`job_card_signatures`.`signed_at`
`job_card_signatures`.`created_at`
`job_card_tasks`.*
`job_card_tasks`.`id`
`job_card_tasks`.`job_card_id`
`job_card_tasks`.`description`
`job_card_tasks`.`completed`
`job_card_tasks`.`sort_order`
`job_card_tasks`.`created_at`
`job_cards`.*
`job_cards`.`id`
`job_cards`.`job_card_number`
`job_cards`.`quotation_id`
`job_cards`.`customer_id`
`job_cards`.`vehicle_id`
`job_cards`.`assigned_to`
`job_cards`.`status`
`job_cards`.`priority`
`job_cards`.`start_date`
`job_cards`.`completion_date`
`job_cards`.`actual_labor_hours`
`job_cards`.`notes`
`job_cards`.`subtotal`
`job_cards`.`tax`
`job_cards`.`total_amount`
`job_cards`.`created_at`
`job_cards`.`updated_at`
`job_cards`.`advance_amount`
`job_cards`.`vehicle_inspection_report_id`
`job_cards`.`branch_id`
`job_cards`.`sales_vat_exempt`
`job_cards`.`discount`
`job_cards`.`lpo_number`
`job_cards`.`vehicle_km`
`product_branch_stock`.*
`product_branch_stock`.`id`
`product_branch_stock`.`product_id`
`product_branch_stock`.`branch_id`
`product_branch_stock`.`quantity`
`product_branch_stock`.`updated_at`
`product_stock_layers`.*
`product_stock_layers`.`id`
`product_stock_layers`.`product_id`
`product_stock_layers`.`branch_id`
`product_stock_layers`.`quantity`
`product_stock_layers`.`unit_price`
`product_stock_layers`.`vat_applied`
`product_stock_layers`.`created_at`
`products`.*
`products`.`id`
`products`.`supplier_id`
`products`.`name`
`products`.`description`
`products`.`sku`
`products`.`category`
`products`.`unit_price`
`products`.`cost_price`
`products`.`stock_quantity`
`products`.`min_stock_level`
`products`.`max_stock_level`
`products`.`unit`
`products`.`status`
`products`.`created_at`
`products`.`updated_at`
`proforma_invoice_items`.*
`proforma_invoice_items`.`id`
`proforma_invoice_items`.`proforma_invoice_id`
`proforma_invoice_items`.`description`
`proforma_invoice_items`.`quantity`
`proforma_invoice_items`.`unit_price`
`proforma_invoice_items`.`total`
`proforma_invoice_items`.`cost_price`
`proforma_invoice_items`.`vendor_name`
`proforma_invoice_items`.`vat_for_expense`
`proforma_invoice_items`.`type`
`proforma_invoice_items`.`supplier_id`
`proforma_invoice_items`.`product_id`
`proforma_invoice_items`.`created_at`
`proforma_invoice_items`.`discount`
`proforma_invoices`.*
`proforma_invoices`.`id`
`proforma_invoices`.`job_card_id`
`proforma_invoices`.`customer_id`
`proforma_invoices`.`quotation_id`
`proforma_invoices`.`proforma_number`
`proforma_invoices`.`subtotal`
`proforma_invoices`.`tax`
`proforma_invoices`.`total_amount`
`proforma_invoices`.`advance_amount`
`proforma_invoices`.`remaining_amount`
`proforma_invoices`.`status`
`proforma_invoices`.`notes`
`proforma_invoices`.`created_at`
`proforma_invoices`.`updated_at`
`proforma_invoices`.`branch_id`
`proforma_invoices`.`sales_vat_exempt`
`proforma_invoices`.`discount`
`quotation_items`.*
`quotation_items`.`id`
`quotation_items`.`quotation_id`
`quotation_items`.`description`
`quotation_items`.`quantity`
`quotation_items`.`unit_price`
`quotation_items`.`total`
`quotation_items`.`cost_price`
`quotation_items`.`vendor_name`
`quotation_items`.`vat_for_expense`
`quotation_items`.`type`
`quotation_items`.`supplier_id`
`quotation_items`.`product_id`
`quotation_items`.`created_at`
`quotation_items`.`discount`
`quotations`.*
`quotations`.`id`
`quotations`.`quotation_number`
`quotations`.`customer_id`
`quotations`.`vehicle_id`
`quotations`.`customer_name`
`quotations`.`vehicle_info`
`quotations`.`subtotal`
`quotations`.`tax`
`quotations`.`total_amount`
`quotations`.`remaining_amount`
`quotations`.`status`
`quotations`.`valid_until`
`quotations`.`notes`
`quotations`.`created_at`
`quotations`.`updated_at`
`quotations`.`branch_id`
`quotations`.`sales_vat_exempt`
`quotations`.`discount`
`salary_records`.*
`salary_records`.`id`
`salary_records`.`user_id`
`salary_records`.`period_year`
`salary_records`.`period_month`
`salary_records`.`base_amount`
`salary_records`.`overtime_amount`
`salary_records`.`adjustment_amount`
`salary_records`.`bonus_amount`
`salary_records`.`advance_amount`
`salary_records`.`total_amount`
`salary_records`.`expense_id`
`salary_records`.`created_at`
`salary_records`.`branch_id`
`salary_settings`.*
`salary_settings`.`user_id`
`salary_settings`.`base_salary`
`salary_settings`.`overtime_threshold_hours`
`salary_settings`.`overtime_rate_per_hour`
`salary_settings`.`created_at`
`salary_settings`.`updated_at`
`salary_settings`.`branch_id`
`stock_changes`.*
`stock_changes`.`id`
`stock_changes`.`product_id`
`stock_changes`.`type`
`stock_changes`.`quantity`
`stock_changes`.`reference_type`
`stock_changes`.`reference_id`
`stock_changes`.`reference_display`
`stock_changes`.`created_at`
`stock_changes`.`branch_id`
`stock_topup_batch_items`.*
`stock_topup_batch_items`.`id`
`stock_topup_batch_items`.`batch_id`
`stock_topup_batch_items`.`product_id`
`stock_topup_batch_items`.`product_name`
`stock_topup_batch_items`.`quantity`
`stock_topup_batch_items`.`buying_price`
`stock_topup_batch_items`.`amount`
`stock_topup_batch_items`.`vat_applied`
`stock_topup_batch_items`.`created_at`
`stock_topup_batches`.*
`stock_topup_batches`.`id`
`stock_topup_batches`.`vendor_name`
`stock_topup_batches`.`supplier_id`
`stock_topup_batches`.`payment_date`
`stock_topup_batches`.`trn`
`stock_topup_batches`.`payment_method`
`stock_topup_batches`.`payment_status`
`stock_topup_batches`.`invoice_number`
`stock_topup_batches`.`notes`
`stock_topup_batches`.`total_amount`
`stock_topup_batches`.`paid_amount`
`stock_topup_batches`.`item_count`
`stock_topup_batches`.`status`
`stock_topup_batches`.`created_at`
`stock_topup_batches`.`description`
`stock_topup_batches`.`expense_id`
`stock_topup_batches`.`branch_id`
`supplier_payments`.*
`supplier_payments`.`id`
`supplier_payments`.`purchase_id`
`supplier_payments`.`supplier_id`
`supplier_payments`.`vendor_name`
`supplier_payments`.`amount`
`supplier_payments`.`payment_method`
`supplier_payments`.`payment_date`
`supplier_payments`.`is_advance`
`supplier_payments`.`purchase_total`
`supplier_payments`.`purchase_remaining_before`
`supplier_payments`.`purchase_remaining_after`
`supplier_payments`.`notes`
`supplier_payments`.`created_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`email`
`suppliers`.`phone`
`suppliers`.`address`
`suppliers`.`rating`
`suppliers`.`products_count`
`suppliers`.`total_orders`
`suppliers`.`status`
`suppliers`.`category`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`suppliers`.`display_name`
`suppliers`.`trn`
`suppliers`.`work_phone`
`suppliers`.`mobile`
`suppliers`.`address_line_1`
`suppliers`.`bank_name`
`suppliers`.`account_number`
`suppliers`.`iban`
`suppliers`.`swift_code`
`suppliers`.`branch`
`user_branches`.*
`user_branches`.`id`
`user_branches`.`user_id`
`user_branches`.`branch_id`
`user_branches`.`created_at`
`users`.*
`users`.`id`
`users`.`email`
`users`.`password_hash`
`users`.`name`
`users`.`role`
`users`.`branch_id`
`users`.`phone`
`users`.`address`
`users`.`emirates_id_file_path`
`users`.`passport_file_path`
`users`.`created_at`
`users`.`updated_at`
`vehicle_brands`.*
`vehicle_brands`.`id`
`vehicle_brands`.`name`
`vehicle_brands`.`description`
`vehicle_brands`.`logo_url`
`vehicle_brands`.`created_at`
`vehicle_brands`.`updated_at`
`vehicle_documents`.*
`vehicle_documents`.`id`
`vehicle_documents`.`vehicle_id`
`vehicle_documents`.`type`
`vehicle_documents`.`file_path`
`vehicle_documents`.`name`
`vehicle_documents`.`created_at`
`vehicle_inspection_checklist`.*
`vehicle_inspection_checklist`.`id`
`vehicle_inspection_checklist`.`report_id`
`vehicle_inspection_checklist`.`item_code`
`vehicle_inspection_checklist`.`item_name`
`vehicle_inspection_checklist`.`ok`
`vehicle_inspection_checklist`.`scratch`
`vehicle_inspection_checklist`.`rust`
`vehicle_inspection_checklist`.`dent`
`vehicle_inspection_checklist`.`sat_pickup`
`vehicle_inspection_checklist`.`unsat_pickup`
`vehicle_inspection_checklist`.`sat_turnin`
`vehicle_inspection_checklist`.`unsat_turnin`
`vehicle_inspection_checklist`.`remarks`
`vehicle_inspection_damage_marks`.*
`vehicle_inspection_damage_marks`.`id`
`vehicle_inspection_damage_marks`.`report_id`
`vehicle_inspection_damage_marks`.`mark_type`
`vehicle_inspection_damage_marks`.`x_pct`
`vehicle_inspection_damage_marks`.`y_pct`
`vehicle_inspection_damage_marks`.`car_view`
`vehicle_inspection_damage_marks`.`created_at`
`vehicle_inspection_photos`.*
`vehicle_inspection_photos`.`id`
`vehicle_inspection_photos`.`report_id`
`vehicle_inspection_photos`.`file_path`
`vehicle_inspection_photos`.`sort_order`
`vehicle_inspection_photos`.`caption`
`vehicle_inspection_photos`.`created_at`
`vehicle_inspection_reports`.*
`vehicle_inspection_reports`.`id`
`vehicle_inspection_reports`.`job_card_id`
`vehicle_inspection_reports`.`quotation_id`
`vehicle_inspection_reports`.`vehicle_id`
`vehicle_inspection_reports`.`customer_id`
`vehicle_inspection_reports`.`branch_id`
`vehicle_inspection_reports`.`status`
`vehicle_inspection_reports`.`mileage_out`
`vehicle_inspection_reports`.`mileage_in`
`vehicle_inspection_reports`.`mileage`
`vehicle_inspection_reports`.`inspector_name`
`vehicle_inspection_reports`.`inspection_date`
`vehicle_inspection_reports`.`remarks`
`vehicle_inspection_reports`.`created_at`
`vehicle_inspection_reports`.`updated_at`
`vehicle_names`.*
`vehicle_names`.`id`
`vehicle_names`.`brand_id`
`vehicle_names`.`name`
`vehicle_names`.`description`
`vehicle_names`.`category`
`vehicle_names`.`created_at`
`vehicle_names`.`updated_at`
`vehicles`.*
`vehicles`.`id`
`vehicles`.`vehicle_id`
`vehicles`.`customer_id`
`vehicles`.`brand`
`vehicles`.`name`
`vehicles`.`license_plate`
`vehicles`.`vin_number`
`vehicles`.`year`
`vehicles`.`color`
`vehicles`.`odometer_reading`
`vehicles`.`last_service_date`
`vehicles`.`next_service_date`
`vehicles`.`status`
`vehicles`.`fuel_type`
`vehicles`.`engine_size`
`vehicles`.`transmission`
`vehicles`.`images`
`vehicles`.`created_at`
`vehicles`.`updated_at`
`advance_salary`.*
`advance_salary`.`id`
`advance_salary`.`user_id`
`advance_salary`.`period_year`
`advance_salary`.`period_month`
`advance_salary`.`amount`
`advance_salary`.`expense_id`
`advance_salary`.`branch_id`
`advance_salary`.`created_at`
`branches`.*
`branches`.`id`
`branches`.`name`
`branches`.`code`
`branches`.`address`
`branches`.`is_active`
`branches`.`created_at`
`branches`.`updated_at`
`bulk_payment_invoices`.*
`bulk_payment_invoices`.`id`
`bulk_payment_invoices`.`customer_payment_id`
`bulk_payment_invoices`.`invoice_id`
`bulk_payment_invoices`.`invoice_number`
`bulk_payment_invoices`.`amount_paid`
`bulk_payment_invoices`.`remaining_before`
`bulk_payment_invoices`.`created_at`
`company_documents`.*
`company_documents`.`id`
`company_documents`.`branch_id`
`company_documents`.`document_type`
`company_documents`.`file_url`
`company_documents`.`label`
`company_documents`.`created_at`
`company_settings`.*
`company_settings`.`id`
`company_settings`.`company_name`
`company_settings`.`tagline`
`company_settings`.`address`
`company_settings`.`phone`
`company_settings`.`email`
`company_settings`.`logo_url`
`company_settings`.`created_at`
`company_settings`.`updated_at`
`company_settings`.`trn`
`company_settings`.`no_trn`
`company_settings`.`vehicle_inspection_enabled`
`company_settings`.`branch_id`
`company_settings`.`signature_terms_and_conditions`
`customer_payments`.*
`customer_payments`.`id`
`customer_payments`.`invoice_id`
`customer_payments`.`job_card_id`
`customer_payments`.`customer_id`
`customer_payments`.`invoice_number`
`customer_payments`.`customer_name`
`customer_payments`.`customer_phone`
`customer_payments`.`vehicle_license_plate`
`customer_payments`.`amount`
`customer_payments`.`payment_method`
`customer_payments`.`payment_date`
`customer_payments`.`advance_applied`
`customer_payments`.`invoice_subtotal`
`customer_payments`.`invoice_tax`
`customer_payments`.`invoice_total`
`customer_payments`.`invoice_remaining_before`
`customer_payments`.`invoice_remaining_after`
`customer_payments`.`notes`
`customer_payments`.`created_at`
`customer_payments`.`payment_type`
`customer_payments`.`branch_id`
`customer_payments`.`is_bulk_payment`
`customers`.*
`customers`.`id`
`customers`.`user_id`
`customers`.`first_name`
`customers`.`last_name`
`customers`.`display_name`
`customers`.`gender`
`customers`.`mobile_number`
`customers`.`email`
`customers`.`password_hash`
`customers`.`date_of_birth`
`customers`.`image_url`
`customers`.`address`
`customers`.`total_spent`
`customers`.`last_visit`
`customers`.`created_at`
`customers`.`updated_at`
`customers`.`is_b2b`
`customers`.`company_name`
`customers`.`trn_number`
`customers`.`credit_terms`
`customers`.`special_discount`
`customers`.`contact_person`
`expenses`.*
`expenses`.`id`
`expenses`.`description`
`expenses`.`amount`
`expenses`.`tax`
`expenses`.`total_amount`
`expenses`.`quantity`
`expenses`.`unit_price`
`expenses`.`category`
`expenses`.`payment_method`
`expenses`.`payment_date`
`expenses`.`status`
`expenses`.`vendor`
`expenses`.`invoice_number`
`expenses`.`notes`
`expenses`.`trn`
`expenses`.`approved_by`
`expenses`.`created_at`
`expenses`.`source_type`
`expenses`.`source_id`
`expenses`.`branch_id`
`income`.*
`income`.`id`
`income`.`customer_name`
`income`.`invoice_number`
`income`.`amount`
`income`.`payment_method`
`income`.`payment_date`
`income`.`status`
`income`.`category`
`income`.`description`
`income`.`received_by`
`income`.`created_at`
`income`.`source`
`income`.`customer_payment_id`
`income`.`branch_id`
`inventory_packages`.*
`inventory_packages`.`id`
`inventory_packages`.`branch_id`
`inventory_packages`.`name`
`inventory_packages`.`supplier_id`
`inventory_packages`.`product_id`
`inventory_packages`.`package_quantity`
`inventory_packages`.`buying_price`
`inventory_packages`.`created_at`
`inventory_packages`.`updated_at`
`invoice_items`.*
`invoice_items`.`id`
`invoice_items`.`invoice_id`
`invoice_items`.`description`
`invoice_items`.`quantity`
`invoice_items`.`unit_price`
`invoice_items`.`total`
`invoice_items`.`cost_price`
`invoice_items`.`vendor_name`
`invoice_items`.`vat_for_expense`
`invoice_items`.`proforma_invoice_item_id`
`invoice_items`.`type`
`invoice_items`.`supplier_id`
`invoice_items`.`product_id`
`invoice_items`.`stock_deducted`
`invoice_items`.`created_at`
`invoice_items`.`discount`
`invoices`.*
`invoices`.`id`
`invoices`.`proforma_invoice_id`
`invoices`.`job_card_id`
`invoices`.`customer_id`
`invoices`.`quotation_id`
`invoices`.`invoice_number`
`invoices`.`subtotal`
`invoices`.`tax`
`invoices`.`total_amount`
`invoices`.`advance_amount`
`invoices`.`remaining_amount`
`invoices`.`status`
`invoices`.`due_date`
`invoices`.`paid_date`
`invoices`.`payment_method`
`invoices`.`notes`
`invoices`.`customer_name`
`invoices`.`customer_email`
`invoices`.`customer_phone`
`invoices`.`vehicle_brand`
`invoices`.`vehicle_name`
`invoices`.`vehicle_year`
`invoices`.`vehicle_license_plate`
`invoices`.`vin_number`
`invoices`.`created_at`
`invoices`.`updated_at`
`invoices`.`branch_id`
`invoices`.`sales_vat_exempt`
`invoices`.`discount`
`job_card_assignments`.*
`job_card_assignments`.`id`
`job_card_assignments`.`job_card_id`
`job_card_assignments`.`user_id`
`job_card_assignments`.`expected_labour_hours`
`job_card_assignments`.`labour_hours`
`job_card_assignments`.`created_at`
`job_card_before_after`.*
`job_card_before_after`.`id`
`job_card_before_after`.`job_card_id`
`job_card_before_after`.`before_file_path`
`job_card_before_after`.`after_file_path`
`job_card_before_after`.`description`
`job_card_before_after`.`sort_order`
`job_card_before_after`.`created_at`
`job_card_hidden_expenses`.*
`job_card_hidden_expenses`.`id`
`job_card_hidden_expenses`.`job_card_id`
`job_card_hidden_expenses`.`description`
`job_card_hidden_expenses`.`amount_aed`
`job_card_hidden_expenses`.`payment_method`
`job_card_hidden_expenses`.`vat_applied`
`job_card_hidden_expenses`.`created_at`
`job_card_hidden_expenses`.`expense_type`
`job_card_hidden_expenses`.`supplier_id`
`job_card_hidden_expenses`.`product_id`
`job_card_hidden_expenses`.`quantity`
`job_card_hidden_expenses`.`unit_price`
`job_card_hidden_expenses`.`cost_price`
`job_card_hidden_expenses`.`vendor_name`
`job_card_items`.*
`job_card_items`.`id`
`job_card_items`.`job_card_id`
`job_card_items`.`description`
`job_card_items`.`quantity`
`job_card_items`.`unit_price`
`job_card_items`.`total`
`job_card_items`.`cost_price`
`job_card_items`.`vendor_name`
`job_card_items`.`vat_for_expense`
`job_card_items`.`type`
`job_card_items`.`supplier_id`
`job_card_items`.`product_id`
`job_card_items`.`created_at`
`job_card_items`.`is_done`
`job_card_items`.`discount`
`job_card_photos`.*
`job_card_photos`.`id`
`job_card_photos`.`job_card_id`
`job_card_photos`.`file_path`
`job_card_photos`.`caption`
`job_card_photos`.`type`
`job_card_photos`.`created_at`
`job_card_signature_links`.*
`job_card_signature_links`.`id`
`job_card_signature_links`.`job_card_id`
`job_card_signature_links`.`token`
`job_card_signature_links`.`expires_at`
`job_card_signature_links`.`signed_at`
`job_card_signature_links`.`signature_data_url`
`job_card_signature_links`.`created_at`
`job_card_signatures`.*
`job_card_signatures`.`id`
`job_card_signatures`.`job_card_id`
`job_card_signatures`.`signature_data_url`
`job_card_signatures`.`signed_at`
`job_card_signatures`.`created_at`
`job_card_tasks`.*
`job_card_tasks`.`id`
`job_card_tasks`.`job_card_id`
`job_card_tasks`.`description`
`job_card_tasks`.`completed`
`job_card_tasks`.`sort_order`
`job_card_tasks`.`created_at`
`job_cards`.*
`job_cards`.`id`
`job_cards`.`job_card_number`
`job_cards`.`quotation_id`
`job_cards`.`customer_id`
`job_cards`.`vehicle_id`
`job_cards`.`assigned_to`
`job_cards`.`status`
`job_cards`.`priority`
`job_cards`.`start_date`
`job_cards`.`completion_date`
`job_cards`.`actual_labor_hours`
`job_cards`.`notes`
`job_cards`.`subtotal`
`job_cards`.`tax`
`job_cards`.`total_amount`
`job_cards`.`created_at`
`job_cards`.`updated_at`
`job_cards`.`advance_amount`
`job_cards`.`vehicle_inspection_report_id`
`job_cards`.`branch_id`
`job_cards`.`sales_vat_exempt`
`job_cards`.`discount`
`job_cards`.`lpo_number`
`job_cards`.`vehicle_km`
`product_branch_stock`.*
`product_branch_stock`.`id`
`product_branch_stock`.`product_id`
`product_branch_stock`.`branch_id`
`product_branch_stock`.`quantity`
`product_branch_stock`.`updated_at`
`product_stock_layers`.*
`product_stock_layers`.`id`
`product_stock_layers`.`product_id`
`product_stock_layers`.`branch_id`
`product_stock_layers`.`quantity`
`product_stock_layers`.`unit_price`
`product_stock_layers`.`vat_applied`
`product_stock_layers`.`created_at`
`products`.*
`products`.`id`
`products`.`supplier_id`
`products`.`name`
`products`.`description`
`products`.`sku`
`products`.`category`
`products`.`unit_price`
`products`.`cost_price`
`products`.`stock_quantity`
`products`.`min_stock_level`
`products`.`max_stock_level`
`products`.`unit`
`products`.`status`
`products`.`created_at`
`products`.`updated_at`
`proforma_invoice_items`.*
`proforma_invoice_items`.`id`
`proforma_invoice_items`.`proforma_invoice_id`
`proforma_invoice_items`.`description`
`proforma_invoice_items`.`quantity`
`proforma_invoice_items`.`unit_price`
`proforma_invoice_items`.`total`
`proforma_invoice_items`.`cost_price`
`proforma_invoice_items`.`vendor_name`
`proforma_invoice_items`.`vat_for_expense`
`proforma_invoice_items`.`type`
`proforma_invoice_items`.`supplier_id`
`proforma_invoice_items`.`product_id`
`proforma_invoice_items`.`created_at`
`proforma_invoice_items`.`discount`
`proforma_invoices`.*
`proforma_invoices`.`id`
`proforma_invoices`.`job_card_id`
`proforma_invoices`.`customer_id`
`proforma_invoices`.`quotation_id`
`proforma_invoices`.`proforma_number`
`proforma_invoices`.`subtotal`
`proforma_invoices`.`tax`
`proforma_invoices`.`total_amount`
`proforma_invoices`.`advance_amount`
`proforma_invoices`.`remaining_amount`
`proforma_invoices`.`status`
`proforma_invoices`.`notes`
`proforma_invoices`.`created_at`
`proforma_invoices`.`updated_at`
`proforma_invoices`.`branch_id`
`proforma_invoices`.`sales_vat_exempt`
`proforma_invoices`.`discount`
`quotation_items`.*
`quotation_items`.`id`
`quotation_items`.`quotation_id`
`quotation_items`.`description`
`quotation_items`.`quantity`
`quotation_items`.`unit_price`
`quotation_items`.`total`
`quotation_items`.`cost_price`
`quotation_items`.`vendor_name`
`quotation_items`.`vat_for_expense`
`quotation_items`.`type`
`quotation_items`.`supplier_id`
`quotation_items`.`product_id`
`quotation_items`.`created_at`
`quotation_items`.`discount`
`quotations`.*
`quotations`.`id`
`quotations`.`quotation_number`
`quotations`.`customer_id`
`quotations`.`vehicle_id`
`quotations`.`customer_name`
`quotations`.`vehicle_info`
`quotations`.`subtotal`
`quotations`.`tax`
`quotations`.`total_amount`
`quotations`.`remaining_amount`
`quotations`.`status`
`quotations`.`valid_until`
`quotations`.`notes`
`quotations`.`created_at`
`quotations`.`updated_at`
`quotations`.`branch_id`
`quotations`.`sales_vat_exempt`
`quotations`.`discount`
`salary_records`.*
`salary_records`.`id`
`salary_records`.`user_id`
`salary_records`.`period_year`
`salary_records`.`period_month`
`salary_records`.`base_amount`
`salary_records`.`overtime_amount`
`salary_records`.`adjustment_amount`
`salary_records`.`bonus_amount`
`salary_records`.`advance_amount`
`salary_records`.`total_amount`
`salary_records`.`expense_id`
`salary_records`.`created_at`
`salary_records`.`branch_id`
`salary_settings`.*
`salary_settings`.`user_id`
`salary_settings`.`base_salary`
`salary_settings`.`overtime_threshold_hours`
`salary_settings`.`overtime_rate_per_hour`
`salary_settings`.`created_at`
`salary_settings`.`updated_at`
`salary_settings`.`branch_id`
`stock_changes`.*
`stock_changes`.`id`
`stock_changes`.`product_id`
`stock_changes`.`type`
`stock_changes`.`quantity`
`stock_changes`.`reference_type`
`stock_changes`.`reference_id`
`stock_changes`.`reference_display`
`stock_changes`.`created_at`
`stock_changes`.`branch_id`
`stock_topup_batch_items`.*
`stock_topup_batch_items`.`id`
`stock_topup_batch_items`.`batch_id`
`stock_topup_batch_items`.`product_id`
`stock_topup_batch_items`.`product_name`
`stock_topup_batch_items`.`quantity`
`stock_topup_batch_items`.`buying_price`
`stock_topup_batch_items`.`amount`
`stock_topup_batch_items`.`vat_applied`
`stock_topup_batch_items`.`created_at`
`stock_topup_batches`.*
`stock_topup_batches`.`id`
`stock_topup_batches`.`vendor_name`
`stock_topup_batches`.`supplier_id`
`stock_topup_batches`.`payment_date`
`stock_topup_batches`.`trn`
`stock_topup_batches`.`payment_method`
`stock_topup_batches`.`payment_status`
`stock_topup_batches`.`invoice_number`
`stock_topup_batches`.`notes`
`stock_topup_batches`.`total_amount`
`stock_topup_batches`.`paid_amount`
`stock_topup_batches`.`item_count`
`stock_topup_batches`.`status`
`stock_topup_batches`.`created_at`
`stock_topup_batches`.`description`
`stock_topup_batches`.`expense_id`
`stock_topup_batches`.`branch_id`
`supplier_payments`.*
`supplier_payments`.`id`
`supplier_payments`.`purchase_id`
`supplier_payments`.`supplier_id`
`supplier_payments`.`vendor_name`
`supplier_payments`.`amount`
`supplier_payments`.`payment_method`
`supplier_payments`.`payment_date`
`supplier_payments`.`is_advance`
`supplier_payments`.`purchase_total`
`supplier_payments`.`purchase_remaining_before`
`supplier_payments`.`purchase_remaining_after`
`supplier_payments`.`notes`
`supplier_payments`.`created_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`email`
`suppliers`.`phone`
`suppliers`.`address`
`suppliers`.`rating`
`suppliers`.`products_count`
`suppliers`.`total_orders`
`suppliers`.`status`
`suppliers`.`category`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`suppliers`.`display_name`
`suppliers`.`trn`
`suppliers`.`work_phone`
`suppliers`.`mobile`
`suppliers`.`address_line_1`
`suppliers`.`bank_name`
`suppliers`.`account_number`
`suppliers`.`iban`
`suppliers`.`swift_code`
`suppliers`.`branch`
`user_branches`.*
`user_branches`.`id`
`user_branches`.`user_id`
`user_branches`.`branch_id`
`user_branches`.`created_at`
`users`.*
`users`.`id`
`users`.`email`
`users`.`password_hash`
`users`.`name`
`users`.`role`
`users`.`branch_id`
`users`.`phone`
`users`.`address`
`users`.`emirates_id_file_path`
`users`.`passport_file_path`
`users`.`created_at`
`users`.`updated_at`
`vehicle_brands`.*
`vehicle_brands`.`id`
`vehicle_brands`.`name`
`vehicle_brands`.`description`
`vehicle_brands`.`logo_url`
`vehicle_brands`.`created_at`
`vehicle_brands`.`updated_at`
`vehicle_documents`.*
`vehicle_documents`.`id`
`vehicle_documents`.`vehicle_id`
`vehicle_documents`.`type`
`vehicle_documents`.`file_path`
`vehicle_documents`.`name`
`vehicle_documents`.`created_at`
`vehicle_inspection_checklist`.*
`vehicle_inspection_checklist`.`id`
`vehicle_inspection_checklist`.`report_id`
`vehicle_inspection_checklist`.`item_code`
`vehicle_inspection_checklist`.`item_name`
`vehicle_inspection_checklist`.`ok`
`vehicle_inspection_checklist`.`scratch`
`vehicle_inspection_checklist`.`rust`
`vehicle_inspection_checklist`.`dent`
`vehicle_inspection_checklist`.`sat_pickup`
`vehicle_inspection_checklist`.`unsat_pickup`
`vehicle_inspection_checklist`.`sat_turnin`
`vehicle_inspection_checklist`.`unsat_turnin`
`vehicle_inspection_checklist`.`remarks`
`vehicle_inspection_damage_marks`.*
`vehicle_inspection_damage_marks`.`id`
`vehicle_inspection_damage_marks`.`report_id`
`vehicle_inspection_damage_marks`.`mark_type`
`vehicle_inspection_damage_marks`.`x_pct`
`vehicle_inspection_damage_marks`.`y_pct`
`vehicle_inspection_damage_marks`.`car_view`
`vehicle_inspection_damage_marks`.`created_at`
`vehicle_inspection_photos`.*
`vehicle_inspection_photos`.`id`
`vehicle_inspection_photos`.`report_id`
`vehicle_inspection_photos`.`file_path`
`vehicle_inspection_photos`.`sort_order`
`vehicle_inspection_photos`.`caption`
`vehicle_inspection_photos`.`created_at`
`vehicle_inspection_reports`.*
`vehicle_inspection_reports`.`id`
`vehicle_inspection_reports`.`job_card_id`
`vehicle_inspection_reports`.`quotation_id`
`vehicle_inspection_reports`.`vehicle_id`
`vehicle_inspection_reports`.`customer_id`
`vehicle_inspection_reports`.`branch_id`
`vehicle_inspection_reports`.`status`
`vehicle_inspection_reports`.`mileage_out`
`vehicle_inspection_reports`.`mileage_in`
`vehicle_inspection_reports`.`mileage`
`vehicle_inspection_reports`.`inspector_name`
`vehicle_inspection_reports`.`inspection_date`
`vehicle_inspection_reports`.`remarks`
`vehicle_inspection_reports`.`created_at`
`vehicle_inspection_reports`.`updated_at`
`vehicle_names`.*
`vehicle_names`.`id`
`vehicle_names`.`brand_id`
`vehicle_names`.`name`
`vehicle_names`.`description`
`vehicle_names`.`category`
`vehicle_names`.`created_at`
`vehicle_names`.`updated_at`
`vehicles`.*
`vehicles`.`id`
`vehicles`.`vehicle_id`
`vehicles`.`customer_id`
`vehicles`.`brand`
`vehicles`.`name`
`vehicles`.`license_plate`
`vehicles`.`vin_number`
`vehicles`.`year`
`vehicles`.`color`
`vehicles`.`odometer_reading`
`vehicles`.`last_service_date`
`vehicles`.`next_service_date`
`vehicles`.`status`
`vehicles`.`fuel_type`
`vehicles`.`engine_size`
`vehicles`.`transmission`
`vehicles`.`images`
`vehicles`.`created_at`
`vehicles`.`updated_at`
`advance_salary`.*
`advance_salary`.`id`
`advance_salary`.`user_id`
`advance_salary`.`period_year`
`advance_salary`.`period_month`
`advance_salary`.`amount`
`advance_salary`.`expense_id`
`advance_salary`.`branch_id`
`advance_salary`.`created_at`
`branches`.*
`branches`.`id`
`branches`.`name`
`branches`.`code`
`branches`.`address`
`branches`.`is_active`
`branches`.`created_at`
`branches`.`updated_at`
`bulk_payment_invoices`.*
`bulk_payment_invoices`.`id`
`bulk_payment_invoices`.`customer_payment_id`
`bulk_payment_invoices`.`invoice_id`
`bulk_payment_invoices`.`invoice_number`
`bulk_payment_invoices`.`amount_paid`
`bulk_payment_invoices`.`remaining_before`
`bulk_payment_invoices`.`created_at`
`company_documents`.*
`company_documents`.`id`
`company_documents`.`branch_id`
`company_documents`.`document_type`
`company_documents`.`file_url`
`company_documents`.`label`
`company_documents`.`created_at`
`company_settings`.*
`company_settings`.`id`
`company_settings`.`company_name`
`company_settings`.`tagline`
`company_settings`.`address`
`company_settings`.`phone`
`company_settings`.`email`
`company_settings`.`logo_url`
`company_settings`.`created_at`
`company_settings`.`updated_at`
`company_settings`.`trn`
`company_settings`.`no_trn`
`company_settings`.`vehicle_inspection_enabled`
`company_settings`.`branch_id`
`company_settings`.`signature_terms_and_conditions`
`customer_payments`.*
`customer_payments`.`id`
`customer_payments`.`invoice_id`
`customer_payments`.`job_card_id`
`customer_payments`.`customer_id`
`customer_payments`.`invoice_number`
`customer_payments`.`customer_name`
`customer_payments`.`customer_phone`
`customer_payments`.`vehicle_license_plate`
`customer_payments`.`amount`
`customer_payments`.`payment_method`
`customer_payments`.`payment_date`
`customer_payments`.`advance_applied`
`customer_payments`.`invoice_subtotal`
`customer_payments`.`invoice_tax`
`customer_payments`.`invoice_total`
`customer_payments`.`invoice_remaining_before`
`customer_payments`.`invoice_remaining_after`
`customer_payments`.`notes`
`customer_payments`.`created_at`
`customer_payments`.`payment_type`
`customer_payments`.`branch_id`
`customer_payments`.`is_bulk_payment`
`customers`.*
`customers`.`id`
`customers`.`user_id`
`customers`.`first_name`
`customers`.`last_name`
`customers`.`display_name`
`customers`.`gender`
`customers`.`mobile_number`
`customers`.`email`
`customers`.`password_hash`
`customers`.`date_of_birth`
`customers`.`image_url`
`customers`.`address`
`customers`.`total_spent`
`customers`.`last_visit`
`customers`.`created_at`
`customers`.`updated_at`
`customers`.`is_b2b`
`customers`.`company_name`
`customers`.`trn_number`
`customers`.`credit_terms`
`customers`.`special_discount`
`customers`.`contact_person`
`expenses`.*
`expenses`.`id`
`expenses`.`description`
`expenses`.`amount`
`expenses`.`tax`
`expenses`.`total_amount`
`expenses`.`quantity`
`expenses`.`unit_price`
`expenses`.`category`
`expenses`.`payment_method`
`expenses`.`payment_date`
`expenses`.`status`
`expenses`.`vendor`
`expenses`.`invoice_number`
`expenses`.`notes`
`expenses`.`trn`
`expenses`.`approved_by`
`expenses`.`created_at`
`expenses`.`source_type`
`expenses`.`source_id`
`expenses`.`branch_id`
`income`.*
`income`.`id`
`income`.`customer_name`
`income`.`invoice_number`
`income`.`amount`
`income`.`payment_method`
`income`.`payment_date`
`income`.`status`
`income`.`category`
`income`.`description`
`income`.`received_by`
`income`.`created_at`
`income`.`source`
`income`.`customer_payment_id`
`income`.`branch_id`
`inventory_packages`.*
`inventory_packages`.`id`
`inventory_packages`.`branch_id`
`inventory_packages`.`name`
`inventory_packages`.`supplier_id`
`inventory_packages`.`product_id`
`inventory_packages`.`package_quantity`
`inventory_packages`.`buying_price`
`inventory_packages`.`created_at`
`inventory_packages`.`updated_at`
`invoice_items`.*
`invoice_items`.`id`
`invoice_items`.`invoice_id`
`invoice_items`.`description`
`invoice_items`.`quantity`
`invoice_items`.`unit_price`
`invoice_items`.`total`
`invoice_items`.`cost_price`
`invoice_items`.`vendor_name`
`invoice_items`.`vat_for_expense`
`invoice_items`.`proforma_invoice_item_id`
`invoice_items`.`type`
`invoice_items`.`supplier_id`
`invoice_items`.`product_id`
`invoice_items`.`stock_deducted`
`invoice_items`.`created_at`
`invoice_items`.`discount`
`invoices`.*
`invoices`.`id`
`invoices`.`proforma_invoice_id`
`invoices`.`job_card_id`
`invoices`.`customer_id`
`invoices`.`quotation_id`
`invoices`.`invoice_number`
`invoices`.`subtotal`
`invoices`.`tax`
`invoices`.`total_amount`
`invoices`.`advance_amount`
`invoices`.`remaining_amount`
`invoices`.`status`
`invoices`.`due_date`
`invoices`.`paid_date`
`invoices`.`payment_method`
`invoices`.`notes`
`invoices`.`customer_name`
`invoices`.`customer_email`
`invoices`.`customer_phone`
`invoices`.`vehicle_brand`
`invoices`.`vehicle_name`
`invoices`.`vehicle_year`
`invoices`.`vehicle_license_plate`
`invoices`.`vin_number`
`invoices`.`created_at`
`invoices`.`updated_at`
`invoices`.`branch_id`
`invoices`.`sales_vat_exempt`
`invoices`.`discount`
`job_card_assignments`.*
`job_card_assignments`.`id`
`job_card_assignments`.`job_card_id`
`job_card_assignments`.`user_id`
`job_card_assignments`.`expected_labour_hours`
`job_card_assignments`.`labour_hours`
`job_card_assignments`.`created_at`
`job_card_before_after`.*
`job_card_before_after`.`id`
`job_card_before_after`.`job_card_id`
`job_card_before_after`.`before_file_path`
`job_card_before_after`.`after_file_path`
`job_card_before_after`.`description`
`job_card_before_after`.`sort_order`
`job_card_before_after`.`created_at`
`job_card_hidden_expenses`.*
`job_card_hidden_expenses`.`id`
`job_card_hidden_expenses`.`job_card_id`
`job_card_hidden_expenses`.`description`
`job_card_hidden_expenses`.`amount_aed`
`job_card_hidden_expenses`.`payment_method`
`job_card_hidden_expenses`.`vat_applied`
`job_card_hidden_expenses`.`created_at`
`job_card_hidden_expenses`.`expense_type`
`job_card_hidden_expenses`.`supplier_id`
`job_card_hidden_expenses`.`product_id`
`job_card_hidden_expenses`.`quantity`
`job_card_hidden_expenses`.`unit_price`
`job_card_hidden_expenses`.`cost_price`
`job_card_hidden_expenses`.`vendor_name`
`job_card_items`.*
`job_card_items`.`id`
`job_card_items`.`job_card_id`
`job_card_items`.`description`
`job_card_items`.`quantity`
`job_card_items`.`unit_price`
`job_card_items`.`total`
`job_card_items`.`cost_price`
`job_card_items`.`vendor_name`
`job_card_items`.`vat_for_expense`
`job_card_items`.`type`
`job_card_items`.`supplier_id`
`job_card_items`.`product_id`
`job_card_items`.`created_at`
`job_card_items`.`is_done`
`job_card_items`.`discount`
`job_card_photos`.*
`job_card_photos`.`id`
`job_card_photos`.`job_card_id`
`job_card_photos`.`file_path`
`job_card_photos`.`caption`
`job_card_photos`.`type`
`job_card_photos`.`created_at`
`job_card_signature_links`.*
`job_card_signature_links`.`id`
`job_card_signature_links`.`job_card_id`
`job_card_signature_links`.`token`
`job_card_signature_links`.`expires_at`
`job_card_signature_links`.`signed_at`
`job_card_signature_links`.`signature_data_url`
`job_card_signature_links`.`created_at`
`job_card_signatures`.*
`job_card_signatures`.`id`
`job_card_signatures`.`job_card_id`
`job_card_signatures`.`signature_data_url`
`job_card_signatures`.`signed_at`
`job_card_signatures`.`created_at`
`job_card_tasks`.*
`job_card_tasks`.`id`
`job_card_tasks`.`job_card_id`
`job_card_tasks`.`description`
`job_card_tasks`.`completed`
`job_card_tasks`.`sort_order`
`job_card_tasks`.`created_at`
`job_cards`.*
`job_cards`.`id`
`job_cards`.`job_card_number`
`job_cards`.`quotation_id`
`job_cards`.`customer_id`
`job_cards`.`vehicle_id`
`job_cards`.`assigned_to`
`job_cards`.`status`
`job_cards`.`priority`
`job_cards`.`start_date`
`job_cards`.`completion_date`
`job_cards`.`actual_labor_hours`
`job_cards`.`notes`
`job_cards`.`subtotal`
`job_cards`.`tax`
`job_cards`.`total_amount`
`job_cards`.`created_at`
`job_cards`.`updated_at`
`job_cards`.`advance_amount`
`job_cards`.`vehicle_inspection_report_id`
`job_cards`.`branch_id`
`job_cards`.`sales_vat_exempt`
`job_cards`.`discount`
`job_cards`.`lpo_number`
`job_cards`.`vehicle_km`
`product_branch_stock`.*
`product_branch_stock`.`id`
`product_branch_stock`.`product_id`
`product_branch_stock`.`branch_id`
`product_branch_stock`.`quantity`
`product_branch_stock`.`updated_at`
`product_stock_layers`.*
`product_stock_layers`.`id`
`product_stock_layers`.`product_id`
`product_stock_layers`.`branch_id`
`product_stock_layers`.`quantity`
`product_stock_layers`.`unit_price`
`product_stock_layers`.`vat_applied`
`product_stock_layers`.`created_at`
`products`.*
`products`.`id`
`products`.`supplier_id`
`products`.`name`
`products`.`description`
`products`.`sku`
`products`.`category`
`products`.`unit_price`
`products`.`cost_price`
`products`.`stock_quantity`
`products`.`min_stock_level`
`products`.`max_stock_level`
`products`.`unit`
`products`.`status`
`products`.`created_at`
`products`.`updated_at`
`proforma_invoice_items`.*
`proforma_invoice_items`.`id`
`proforma_invoice_items`.`proforma_invoice_id`
`proforma_invoice_items`.`description`
`proforma_invoice_items`.`quantity`
`proforma_invoice_items`.`unit_price`
`proforma_invoice_items`.`total`
`proforma_invoice_items`.`cost_price`
`proforma_invoice_items`.`vendor_name`
`proforma_invoice_items`.`vat_for_expense`
`proforma_invoice_items`.`type`
`proforma_invoice_items`.`supplier_id`
`proforma_invoice_items`.`product_id`
`proforma_invoice_items`.`created_at`
`proforma_invoice_items`.`discount`
`proforma_invoices`.*
`proforma_invoices`.`id`
`proforma_invoices`.`job_card_id`
`proforma_invoices`.`customer_id`
`proforma_invoices`.`quotation_id`
`proforma_invoices`.`proforma_number`
`proforma_invoices`.`subtotal`
`proforma_invoices`.`tax`
`proforma_invoices`.`total_amount`
`proforma_invoices`.`advance_amount`
`proforma_invoices`.`remaining_amount`
`proforma_invoices`.`status`
`proforma_invoices`.`notes`
`proforma_invoices`.`created_at`
`proforma_invoices`.`updated_at`
`proforma_invoices`.`branch_id`
`proforma_invoices`.`sales_vat_exempt`
`proforma_invoices`.`discount`
`quotation_items`.*
`quotation_items`.`id`
`quotation_items`.`quotation_id`
`quotation_items`.`description`
`quotation_items`.`quantity`
`quotation_items`.`unit_price`
`quotation_items`.`total`
`quotation_items`.`cost_price`
`quotation_items`.`vendor_name`
`quotation_items`.`vat_for_expense`
`quotation_items`.`type`
`quotation_items`.`supplier_id`
`quotation_items`.`product_id`
`quotation_items`.`created_at`
`quotation_items`.`discount`
`quotations`.*
`quotations`.`id`
`quotations`.`quotation_number`
`quotations`.`customer_id`
`quotations`.`vehicle_id`
`quotations`.`customer_name`
`quotations`.`vehicle_info`
`quotations`.`subtotal`
`quotations`.`tax`
`quotations`.`total_amount`
`quotations`.`remaining_amount`
`quotations`.`status`
`quotations`.`valid_until`
`quotations`.`notes`
`quotations`.`created_at`
`quotations`.`updated_at`
`quotations`.`branch_id`
`quotations`.`sales_vat_exempt`
`quotations`.`discount`
`salary_records`.*
`salary_records`.`id`
`salary_records`.`user_id`
`salary_records`.`period_year`
`salary_records`.`period_month`
`salary_records`.`base_amount`
`salary_records`.`overtime_amount`
`salary_records`.`adjustment_amount`
`salary_records`.`bonus_amount`
`salary_records`.`advance_amount`
`salary_records`.`total_amount`
`salary_records`.`expense_id`
`salary_records`.`created_at`
`salary_records`.`branch_id`
`salary_settings`.*
`salary_settings`.`user_id`
`salary_settings`.`base_salary`
`salary_settings`.`overtime_threshold_hours`
`salary_settings`.`overtime_rate_per_hour`
`salary_settings`.`created_at`
`salary_settings`.`updated_at`
`salary_settings`.`branch_id`
`stock_changes`.*
`stock_changes`.`id`
`stock_changes`.`product_id`
`stock_changes`.`type`
`stock_changes`.`quantity`
`stock_changes`.`reference_type`
`stock_changes`.`reference_id`
`stock_changes`.`reference_display`
`stock_changes`.`created_at`
`stock_changes`.`branch_id`
`stock_topup_batch_items`.*
`stock_topup_batch_items`.`id`
`stock_topup_batch_items`.`batch_id`
`stock_topup_batch_items`.`product_id`
`stock_topup_batch_items`.`product_name`
`stock_topup_batch_items`.`quantity`
`stock_topup_batch_items`.`buying_price`
`stock_topup_batch_items`.`amount`
`stock_topup_batch_items`.`vat_applied`
`stock_topup_batch_items`.`created_at`
`stock_topup_batches`.*
`stock_topup_batches`.`id`
`stock_topup_batches`.`vendor_name`
`stock_topup_batches`.`supplier_id`
`stock_topup_batches`.`payment_date`
`stock_topup_batches`.`trn`
`stock_topup_batches`.`payment_method`
`stock_topup_batches`.`payment_status`
`stock_topup_batches`.`invoice_number`
`stock_topup_batches`.`notes`
`stock_topup_batches`.`total_amount`
`stock_topup_batches`.`paid_amount`
`stock_topup_batches`.`item_count`
`stock_topup_batches`.`status`
`stock_topup_batches`.`created_at`
`stock_topup_batches`.`description`
`stock_topup_batches`.`expense_id`
`stock_topup_batches`.`branch_id`
`supplier_payments`.*
`supplier_payments`.`id`
`supplier_payments`.`purchase_id`
`supplier_payments`.`supplier_id`
`supplier_payments`.`vendor_name`
`supplier_payments`.`amount`
`supplier_payments`.`payment_method`
`supplier_payments`.`payment_date`
`supplier_payments`.`is_advance`
`supplier_payments`.`purchase_total`
`supplier_payments`.`purchase_remaining_before`
`supplier_payments`.`purchase_remaining_after`
`supplier_payments`.`notes`
`supplier_payments`.`created_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`email`
`suppliers`.`phone`
`suppliers`.`address`
`suppliers`.`rating`
`suppliers`.`products_count`
`suppliers`.`total_orders`
`suppliers`.`status`
`suppliers`.`category`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`suppliers`.`display_name`
`suppliers`.`trn`
`suppliers`.`work_phone`
`suppliers`.`mobile`
`suppliers`.`address_line_1`
`suppliers`.`bank_name`
`suppliers`.`account_number`
`suppliers`.`iban`
`suppliers`.`swift_code`
`suppliers`.`branch`
`user_branches`.*
`user_branches`.`id`
`user_branches`.`user_id`
`user_branches`.`branch_id`
`user_branches`.`created_at`
`users`.*
`users`.`id`
`users`.`email`
`users`.`password_hash`
`users`.`name`
`users`.`role`
`users`.`branch_id`
`users`.`phone`
`users`.`address`
`users`.`emirates_id_file_path`
`users`.`passport_file_path`
`users`.`created_at`
`users`.`updated_at`
`vehicle_brands`.*
`vehicle_brands`.`id`
`vehicle_brands`.`name`
`vehicle_brands`.`description`
`vehicle_brands`.`logo_url`
`vehicle_brands`.`created_at`
`vehicle_brands`.`updated_at`
`vehicle_documents`.*
`vehicle_documents`.`id`
`vehicle_documents`.`vehicle_id`
`vehicle_documents`.`type`
`vehicle_documents`.`file_path`
`vehicle_documents`.`name`
`vehicle_documents`.`created_at`
`vehicle_inspection_checklist`.*
`vehicle_inspection_checklist`.`id`
`vehicle_inspection_checklist`.`report_id`
`vehicle_inspection_checklist`.`item_code`
`vehicle_inspection_checklist`.`item_name`
`vehicle_inspection_checklist`.`ok`
`vehicle_inspection_checklist`.`scratch`
`vehicle_inspection_checklist`.`rust`
`vehicle_inspection_checklist`.`dent`
`vehicle_inspection_checklist`.`sat_pickup`
`vehicle_inspection_checklist`.`unsat_pickup`
`vehicle_inspection_checklist`.`sat_turnin`
`vehicle_inspection_checklist`.`unsat_turnin`
`vehicle_inspection_checklist`.`remarks`
`vehicle_inspection_damage_marks`.*
`vehicle_inspection_damage_marks`.`id`
`vehicle_inspection_damage_marks`.`report_id`
`vehicle_inspection_damage_marks`.`mark_type`
`vehicle_inspection_damage_marks`.`x_pct`
`vehicle_inspection_damage_marks`.`y_pct`
`vehicle_inspection_damage_marks`.`car_view`
`vehicle_inspection_damage_marks`.`created_at`
`vehicle_inspection_photos`.*
`vehicle_inspection_photos`.`id`
`vehicle_inspection_photos`.`report_id`
`vehicle_inspection_photos`.`file_path`
`vehicle_inspection_photos`.`sort_order`
`vehicle_inspection_photos`.`caption`
`vehicle_inspection_photos`.`created_at`
`vehicle_inspection_reports`.*
`vehicle_inspection_reports`.`id`
`vehicle_inspection_reports`.`job_card_id`
`vehicle_inspection_reports`.`quotation_id`
`vehicle_inspection_reports`.`vehicle_id`
`vehicle_inspection_reports`.`customer_id`
`vehicle_inspection_reports`.`branch_id`
`vehicle_inspection_reports`.`status`
`vehicle_inspection_reports`.`mileage_out`
`vehicle_inspection_reports`.`mileage_in`
`vehicle_inspection_reports`.`mileage`
`vehicle_inspection_reports`.`inspector_name`
`vehicle_inspection_reports`.`inspection_date`
`vehicle_inspection_reports`.`remarks`
`vehicle_inspection_reports`.`created_at`
`vehicle_inspection_reports`.`updated_at`
`vehicle_names`.*
`vehicle_names`.`id`
`vehicle_names`.`brand_id`
`vehicle_names`.`name`
`vehicle_names`.`description`
`vehicle_names`.`category`
`vehicle_names`.`created_at`
`vehicle_names`.`updated_at`
`vehicles`.*
`vehicles`.`id`
`vehicles`.`vehicle_id`
`vehicles`.`customer_id`
`vehicles`.`brand`
`vehicles`.`name`
`vehicles`.`license_plate`
`vehicles`.`vin_number`
`vehicles`.`year`
`vehicles`.`color`
`vehicles`.`odometer_reading`
`vehicles`.`last_service_date`
`vehicles`.`next_service_date`
`vehicles`.`status`
`vehicles`.`fuel_type`
`vehicles`.`engine_size`
`vehicles`.`transmission`
`vehicles`.`images`
`vehicles`.`created_at`
`vehicles`.`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
advance_salary
branches
bulk_payment_invoices
company_documents
company_settings
customer_payments
customers
expenses
income
inventory_packages
invoice_items
invoices
job_card_assignments
job_card_before_after
job_card_hidden_expenses
job_card_items
job_card_photos
job_card_signature_links
job_card_signatures
job_card_tasks
job_cards
product_branch_stock
product_stock_layers
products
proforma_invoice_items
proforma_invoices
quotation_items
quotations
salary_records
salary_settings
stock_changes
stock_topup_batch_items
stock_topup_batches
supplier_payments
suppliers
user_branches
users
vehicle_brands
vehicle_documents
vehicle_inspection_checklist
vehicle_inspection_damage_marks
vehicle_inspection_photos
vehicle_inspection_reports
vehicle_names
vehicles
SQL query on database
918carcare
: