حديث
`dawat_studio_db`.`user_account_settings`
`dawat_studio_db`.`orders`
`roveix`.`stock_balances`
`mysql`.`servers`
`mysql`.`help_keyword`
`mysql`.`table_stats`
`performance_schema`.`setup_actors`
`invites_db`.`payments`
`bityusr_db`.`sections`
`roveix`.`part_verification_reviews`
المفضلة
لا توجد جداول مفضلة .
New
bityusr_db
dawat
dawat_stage3_qa_db
dawat_stage4_qa_db
dawat_stage5_qa_db
dawat_stage6_qa_db
dawat_studio_db
information_schema
invites_db
lr_parts_pro
mysql
parts_internal_erp
performance_schema
phpmyadmin
roveix
roveix
roveix_desk
إطار التصفح
Navigation tree
خوادم
قاعدة بيانات
جداول
إطار التصفح
تخصيص مظهر إطار التصفح.
إطار التصفح
Show databases navigation as tree
في لوحة التنقل، استبدل شجرة قاعدة البيانات مع محدد
ربط مع اللوحة الرئيسية
Link with main panel by highlighting the current database or table.
عرض الشعار
عرض تنقل قواعد البيانات على شكل شجرة.
رابط الشعار
URL where logo in the navigation panel will point to.
هدف رابط الشعار
فتح الصفحة المرتبطة في النافذة الرئيسية (
main
) أو في نافذة جديدة (
new
)
main
new
تفعيل التوضيح (highlighting)
توضيح الخادم تحت مؤشر الفأرة.
الحد الأقصى للعناصر على المستوى الأول
عدد العناصر التي يمكن عرضها على كل صفحة على المستوى الأول من شجرة التنقل.
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.
الجداول المستعملة مؤخراً
أكبر عدد للجداول المستعملة مؤخراً ; ضع 0 للتعطيل.
الجداول المفضلة
أكبر عدد للجداول المستعملة مؤخراً ; ضع 0 للتعطيل.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
تخصيص اطار التصفح
Navigation 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.
عرض شجرة الجداول
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
عرض شجرة الوظائف
Whether to show functions under database in the navigation tree
عرض شجرة العمليات
Whether to show procedures under database in the navigation tree
عرض شجرة الاحداث
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
خوادم
خيارات عرض الخوادم.
خوادم
عرض إختيار الخوادم
اختيار خادم العرض أعلى لوحة التنقل.
إظهار الخوادم كقائمة
إظهار الخواديم كقائمة بدلاً من القائمة المنسدلة.
قاعدة بيانات
خيارات عرض قواعد البيانات.
قاعدة بيانات
أقل عدد جداول اللتي تعرض في صندوق ترشيح الجداول
فاصل شجرة قاعدة البيانات
String that separates databases into different tree levels.
جداول
خيارات عرض الجداول.
جداول
الهدف لإيقونة الوصول السريع
بناء
SQL
إبحث
إدخال
استعراض
Target for second quick access icon
بناء
SQL
إبحث
إدخال
استعراض
فاصل شجرة الجدول
String that separates tables into different tree levels.
أقصى عمق لشجرة الجدول
قم إفلات الملفات هنا
SQL upload (
0
)
x
-
إظهار عناصر شجرة التنقل المخفية.
إنشاء عرض
يجب تفعيل Javascript بعد هذه النقطة!
الخادم: 127.0.0.1:3307
Database: roveix
بناء
SQL
إبحث
استعلام بواسطة مثال
(current)
تصدير
استيراد
عمليات
الإمتيازات
روتينات
أحداث
القوادح
تتبع
المصمم
الأعمدة المركزية
المِعراض
Clear
المحفوظات
خيارات
Bookmarks
تصحيح SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
تصحيح SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Bookmarks
تحديث
إضافة
لا توجد إشارات مرجعية
إضافة للمفضلة
Label:
Target database:
Share this bookmark
موافق
خيارات
Set default
Always expand query messages
إظهار محفوظات الاستعلام
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
تعديل
Explain
جانبي
Bookmark
Query failed
قاعدة البيانات :
Queried time :
Loading
محرر ENUM/SET
إنشاء عرض
استعلام جداول متعددة
مثال للاستعلام
التحويل إلى
الباني المرئي
البحث المحفوظ الذي تم وضع إشارة مرجعية له:
إشارة جديدة
عمود :
`activity_logs`.*
`activity_logs`.`id`
`activity_logs`.`user_id`
`activity_logs`.`module`
`activity_logs`.`action`
`activity_logs`.`subject_type`
`activity_logs`.`subject_id`
`activity_logs`.`description`
`activity_logs`.`old_values`
`activity_logs`.`new_values`
`activity_logs`.`ip_address`
`activity_logs`.`user_agent`
`activity_logs`.`created_at`
`activity_logs`.`updated_at`
`ai_part_lookups`.*
`ai_part_lookups`.`id`
`ai_part_lookups`.`vin`
`ai_part_lookups`.`requested_part_name`
`ai_part_lookups`.`normalized_part_name`
`ai_part_lookups`.`vehicle_family`
`ai_part_lookups`.`vehicle_variant`
`ai_part_lookups`.`matched_part_name`
`ai_part_lookups`.`matched_part_number`
`ai_part_lookups`.`confidence`
`ai_part_lookups`.`source_type`
`ai_part_lookups`.`needs_manual_verification`
`ai_part_lookups`.`was_saved_to_parts`
`ai_part_lookups`.`reason`
`ai_part_lookups`.`raw_json`
`ai_part_lookups`.`created_at`
`ai_part_lookups`.`updated_at`
`categories`.*
`categories`.`id`
`categories`.`parent_id`
`categories`.`name_ar`
`categories`.`name_en`
`categories`.`slug`
`categories`.`icon_path`
`categories`.`sort_order`
`categories`.`is_active`
`categories`.`created_at`
`categories`.`updated_at`
`competitor_prices`.*
`competitor_prices`.`id`
`competitor_prices`.`competitor_id`
`competitor_prices`.`part_id`
`competitor_prices`.`price`
`competitor_prices`.`currency`
`competitor_prices`.`checked_at`
`competitor_prices`.`notes`
`competitor_prices`.`created_by`
`competitor_prices`.`created_at`
`competitor_prices`.`updated_at`
`competitors`.*
`competitors`.`id`
`competitors`.`name`
`competitors`.`phone`
`competitors`.`website`
`competitors`.`city`
`competitors`.`notes`
`competitors`.`is_active`
`competitors`.`created_at`
`competitors`.`updated_at`
`customers`.*
`customers`.`id`
`customers`.`customer_type`
`customers`.`name`
`customers`.`contact_name`
`customers`.`phone`
`customers`.`email`
`customers`.`city`
`customers`.`address`
`customers`.`tax_number`
`customers`.`commercial_register`
`customers`.`notes`
`customers`.`is_active`
`customers`.`created_at`
`customers`.`updated_at`
`invoice_templates`.*
`invoice_templates`.`id`
`invoice_templates`.`name`
`invoice_templates`.`code`
`invoice_templates`.`description_text`
`invoice_templates`.`is_default`
`invoice_templates`.`template_path`
`invoice_templates`.`settings_json`
`invoice_templates`.`is_active`
`invoice_templates`.`created_at`
`invoice_templates`.`updated_at`
`manufacturers`.*
`manufacturers`.`id`
`manufacturers`.`name`
`manufacturers`.`country`
`manufacturers`.`notes`
`manufacturers`.`is_active`
`manufacturers`.`created_at`
`manufacturers`.`updated_at`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`part_competitor_prices`.*
`part_competitor_prices`.`id`
`part_competitor_prices`.`part_id`
`part_competitor_prices`.`competitor_id`
`part_competitor_prices`.`price`
`part_competitor_prices`.`notes`
`part_competitor_prices`.`created_at`
`part_competitor_prices`.`updated_at`
`part_fitments`.*
`part_fitments`.`id`
`part_fitments`.`part_id`
`part_fitments`.`brand_id`
`part_fitments`.`line_id`
`part_fitments`.`model_id`
`part_fitments`.`vehicle_year_id`
`part_fitments`.`engine_id`
`part_fitments`.`notes`
`part_fitments`.`created_at`
`part_fitments`.`updated_at`
`part_sales_stats`.*
`part_sales_stats`.`id`
`part_sales_stats`.`part_id`
`part_sales_stats`.`sold_qty`
`part_sales_stats`.`sold_amount`
`part_sales_stats`.`created_at`
`part_sales_stats`.`updated_at`
`part_vehicle_links`.*
`part_vehicle_links`.`id`
`part_vehicle_links`.`part_id`
`part_vehicle_links`.`vehicle_id`
`part_vehicle_links`.`created_at`
`part_vehicle_links`.`updated_at`
`part_vehicle_verifications`.*
`part_vehicle_verifications`.`id`
`part_vehicle_verifications`.`part_id`
`part_vehicle_verifications`.`vehicle_id`
`part_vehicle_verifications`.`verification_status`
`part_vehicle_verifications`.`source_scope`
`part_vehicle_verifications`.`source_flags`
`part_vehicle_verifications`.`reference_groups`
`part_vehicle_verifications`.`is_live_link`
`part_vehicle_verifications`.`is_family_candidate`
`part_vehicle_verifications`.`review_notes`
`part_vehicle_verifications`.`reviewed_by`
`part_vehicle_verifications`.`verified_at`
`part_vehicle_verifications`.`created_at`
`part_vehicle_verifications`.`updated_at`
`part_verification_reviews`.*
`part_verification_reviews`.`id`
`part_verification_reviews`.`part_id`
`part_verification_reviews`.`verification_status`
`part_verification_reviews`.`review_notes`
`part_verification_reviews`.`reviewed_by`
`part_verification_reviews`.`verified_at`
`part_verification_reviews`.`created_at`
`part_verification_reviews`.`updated_at`
`parts`.*
`parts`.`id`
`parts`.`category_id`
`parts`.`manufacturer_id`
`parts`.`part_name_ar`
`parts`.`part_name_en`
`parts`.`brand_name`
`parts`.`part_type`
`parts`.`vehicle_id`
`parts`.`part_number`
`parts`.`alternate_part_number`
`parts`.`sku`
`parts`.`barcode`
`parts`.`description`
`parts`.`cost_price`
`parts`.`sale_price`
`parts`.`wholesale_price`
`parts`.`min_stock_level`
`parts`.`sold_qty_total`
`parts`.`sales_amount_total`
`parts`.`unit_name`
`parts`.`is_active`
`parts`.`unit`
`parts`.`image_path`
`parts`.`status`
`parts`.`reference_status`
`parts`.`reference_verified_at`
`parts`.`reference_verified_by`
`parts`.`reference_notes`
`parts`.`notes`
`parts`.`created_by`
`parts`.`updated_by`
`parts`.`created_at`
`parts`.`updated_at`
`parts`.`warehouse_id`
`parts`.`total_sold_qty`
`parts`.`total_sales_amount`
`parts`.`total_sales_cost`
`parts`.`total_profit_amount`
`payments`.*
`payments`.`id`
`payments`.`paymentable_type`
`payments`.`paymentable_id`
`payments`.`payment_method`
`payments`.`amount`
`payments`.`reference_number`
`payments`.`payment_date`
`payments`.`notes`
`payments`.`received_by`
`payments`.`created_at`
`payments`.`updated_at`
`permission_role`.*
`permission_role`.`id`
`permission_role`.`role_id`
`permission_role`.`permission_id`
`permission_role`.`created_at`
`permission_role`.`updated_at`
`permissions`.*
`permissions`.`id`
`permissions`.`name`
`permissions`.`code`
`permissions`.`module`
`permissions`.`description`
`permissions`.`is_active`
`permissions`.`created_at`
`permissions`.`updated_at`
`purchase_order_items`.*
`purchase_order_items`.`id`
`purchase_order_items`.`purchase_order_id`
`purchase_order_items`.`part_id`
`purchase_order_items`.`description_text`
`purchase_order_items`.`qty`
`purchase_order_items`.`unit_price`
`purchase_order_items`.`description`
`purchase_order_items`.`qty_ordered`
`purchase_order_items`.`qty_received`
`purchase_order_items`.`unit_cost`
`purchase_order_items`.`discount_amount`
`purchase_order_items`.`tax_amount`
`purchase_order_items`.`line_total`
`purchase_order_items`.`created_at`
`purchase_order_items`.`updated_at`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`order_number`
`purchase_orders`.`po_number`
`purchase_orders`.`supplier_id`
`purchase_orders`.`status`
`purchase_orders`.`warehouse_id`
`purchase_orders`.`order_date`
`purchase_orders`.`expected_date`
`purchase_orders`.`subtotal`
`purchase_orders`.`discount_amount`
`purchase_orders`.`tax_amount`
`purchase_orders`.`total_amount`
`purchase_orders`.`currency`
`purchase_orders`.`notes`
`purchase_orders`.`template_code`
`purchase_orders`.`created_by`
`purchase_orders`.`approved_by`
`purchase_orders`.`approved_at`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_receipt_items`.*
`purchase_receipt_items`.`id`
`purchase_receipt_items`.`purchase_receipt_id`
`purchase_receipt_items`.`part_id`
`purchase_receipt_items`.`qty_received`
`purchase_receipt_items`.`unit_cost`
`purchase_receipt_items`.`created_at`
`purchase_receipt_items`.`updated_at`
`purchase_receipts`.*
`purchase_receipts`.`id`
`purchase_receipts`.`purchase_order_id`
`purchase_receipts`.`receipt_number`
`purchase_receipts`.`warehouse_id`
`purchase_receipts`.`received_date`
`purchase_receipts`.`notes`
`purchase_receipts`.`received_by`
`purchase_receipts`.`created_at`
`purchase_receipts`.`updated_at`
`quotation_items`.*
`quotation_items`.`id`
`quotation_items`.`quotation_id`
`quotation_items`.`part_id`
`quotation_items`.`description_text`
`quotation_items`.`description`
`quotation_items`.`qty`
`quotation_items`.`unit_price`
`quotation_items`.`cost_price_snapshot`
`quotation_items`.`discount_amount`
`quotation_items`.`tax_amount`
`quotation_items`.`line_total`
`quotation_items`.`sort_order`
`quotation_items`.`created_at`
`quotation_items`.`updated_at`
`quotations`.*
`quotations`.`id`
`quotations`.`quotation_number`
`quotations`.`customer_id`
`quotations`.`status`
`quotations`.`quotation_date`
`quotations`.`expiry_date`
`quotations`.`warehouse_id`
`quotations`.`vat_enabled`
`quotations`.`vat_rate`
`quotations`.`subtotal`
`quotations`.`discount_amount`
`quotations`.`tax_amount`
`quotations`.`total_amount`
`quotations`.`currency`
`quotations`.`notes`
`quotations`.`template_code`
`quotations`.`converted_sales_invoice_id`
`quotations`.`created_by`
`quotations`.`approved_by`
`quotations`.`approved_at`
`quotations`.`sent_at`
`quotations`.`created_at`
`quotations`.`updated_at`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`code`
`roles`.`description`
`roles`.`is_active`
`roles`.`created_at`
`roles`.`updated_at`
`sales_invoice_items`.*
`sales_invoice_items`.`id`
`sales_invoice_items`.`sales_invoice_id`
`sales_invoice_items`.`warehouse_id`
`sales_invoice_items`.`part_id`
`sales_invoice_items`.`description_text`
`sales_invoice_items`.`description`
`sales_invoice_items`.`qty`
`sales_invoice_items`.`unit_price`
`sales_invoice_items`.`cost_price_snapshot`
`sales_invoice_items`.`discount_amount`
`sales_invoice_items`.`tax_amount`
`sales_invoice_items`.`line_total`
`sales_invoice_items`.`sold_at`
`sales_invoice_items`.`created_at`
`sales_invoice_items`.`updated_at`
`sales_invoices`.*
`sales_invoices`.`id`
`sales_invoices`.`invoice_number`
`sales_invoices`.`customer_id`
`sales_invoices`.`customer_name`
`sales_invoices`.`customer_phone`
`sales_invoices`.`customer_address`
`sales_invoices`.`quotation_id`
`sales_invoices`.`status`
`sales_invoices`.`order_source`
`sales_invoices`.`invoice_date`
`sales_invoices`.`warehouse_id`
`sales_invoices`.`vat_enabled`
`sales_invoices`.`vat_rate`
`sales_invoices`.`subtotal`
`sales_invoices`.`discount_amount`
`sales_invoices`.`tax_amount`
`sales_invoices`.`total_amount`
`sales_invoices`.`paid_amount`
`sales_invoices`.`due_amount`
`sales_invoices`.`currency`
`sales_invoices`.`notes`
`sales_invoices`.`template_code`
`sales_invoices`.`created_by`
`sales_invoices`.`approved_by`
`sales_invoices`.`approved_at`
`sales_invoices`.`created_at`
`sales_invoices`.`updated_at`
`sales_invoices`.`payment_method`
`sales_invoices`.`payment_fee_profile`
`sales_invoices`.`gateway_rate`
`sales_invoices`.`gateway_fee`
`sales_invoices`.`checkout_fee`
`sales_invoices`.`payment_fees_vat`
`sales_invoices`.`payment_fees_total`
`sales_invoices`.`payment_gateway_profile`
`sales_invoices`.`customer_shipping_fee`
`sales_invoices`.`merchant_shipping_cost`
`sales_invoices`.`cod_fee`
`sales_invoices`.`cod_fee_vat`
`sales_invoices`.`shipping_profit_loss`
`sales_invoices`.`cogs_total`
`sales_invoices`.`net_payout_before_cogs`
`sales_invoices`.`net_profit`
`sales_invoices`.`gateway_fee_rate`
`sales_invoices`.`gateway_fee_amount`
`sales_invoices`.`checkout_fee_amount`
`sales_invoices`.`fees_vat_amount`
`sales_invoices`.`payment_fee_amount`
`sales_invoices`.`net_amount_before_cost`
`sales_invoices`.`cost_of_goods_amount`
`sales_invoices`.`net_profit_amount`
`sales_invoices`.`sold_at`
`sessions`.*
`sessions`.`id`
`sessions`.`user_id`
`sessions`.`ip_address`
`sessions`.`user_agent`
`sessions`.`payload`
`sessions`.`last_activity`
`settings`.*
`settings`.`id`
`settings`.`group_name`
`settings`.`setting_key`
`settings`.`setting_value`
`settings`.`setting_type`
`settings`.`notes`
`settings`.`created_at`
`settings`.`updated_at`
`stock_alerts`.*
`stock_alerts`.`id`
`stock_alerts`.`part_id`
`stock_alerts`.`warehouse_id`
`stock_alerts`.`alert_type`
`stock_alerts`.`threshold_qty`
`stock_alerts`.`current_qty`
`stock_alerts`.`is_resolved`
`stock_alerts`.`resolved_at`
`stock_alerts`.`created_at`
`stock_alerts`.`updated_at`
`stock_balances`.*
`stock_balances`.`id`
`stock_balances`.`part_id`
`stock_balances`.`warehouse_id`
`stock_balances`.`quantity`
`stock_balances`.`qty_on_hand`
`stock_balances`.`reserved_quantity`
`stock_balances`.`available_quantity`
`stock_balances`.`avg_cost`
`stock_balances`.`created_at`
`stock_balances`.`updated_at`
`stock_movements`.*
`stock_movements`.`id`
`stock_movements`.`part_id`
`stock_movements`.`warehouse_id`
`stock_movements`.`movement_type`
`stock_movements`.`reference_type`
`stock_movements`.`reference_id`
`stock_movements`.`quantity`
`stock_movements`.`unit_cost`
`stock_movements`.`unit_price`
`stock_movements`.`balance_before`
`stock_movements`.`balance_after`
`stock_movements`.`notes`
`stock_movements`.`performed_by`
`stock_movements`.`created_at`
`stock_movements`.`updated_at`
`supplier_part_prices`.*
`supplier_part_prices`.`id`
`supplier_part_prices`.`supplier_id`
`supplier_part_prices`.`part_id`
`supplier_part_prices`.`supplier_part_number`
`supplier_part_prices`.`last_cost`
`supplier_part_prices`.`currency`
`supplier_part_prices`.`lead_time_days`
`supplier_part_prices`.`minimum_order_qty`
`supplier_part_prices`.`is_preferred`
`supplier_part_prices`.`notes`
`supplier_part_prices`.`created_at`
`supplier_part_prices`.`updated_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`contact_name`
`suppliers`.`phone`
`suppliers`.`email`
`suppliers`.`country`
`suppliers`.`city`
`suppliers`.`address`
`suppliers`.`tax_number`
`suppliers`.`commercial_register`
`suppliers`.`currency`
`suppliers`.`notes`
`suppliers`.`is_active`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`users`.*
`users`.`id`
`users`.`full_name`
`users`.`name`
`users`.`email`
`users`.`role_name`
`users`.`phone`
`users`.`password`
`users`.`role_id`
`users`.`avatar`
`users`.`is_active`
`users`.`email_verified_at`
`users`.`remember_token`
`users`.`last_login_at`
`users`.`created_at`
`users`.`updated_at`
`vehicle_brands`.*
`vehicle_brands`.`id`
`vehicle_brands`.`name_ar`
`vehicle_brands`.`name_en`
`vehicle_brands`.`is_active`
`vehicle_brands`.`created_at`
`vehicle_brands`.`updated_at`
`vehicle_engines`.*
`vehicle_engines`.`id`
`vehicle_engines`.`model_id`
`vehicle_engines`.`engine_name`
`vehicle_engines`.`engine_code`
`vehicle_engines`.`fuel_type`
`vehicle_engines`.`notes`
`vehicle_engines`.`is_active`
`vehicle_engines`.`created_at`
`vehicle_engines`.`updated_at`
`vehicle_lines`.*
`vehicle_lines`.`id`
`vehicle_lines`.`brand_id`
`vehicle_lines`.`name_ar`
`vehicle_lines`.`name_en`
`vehicle_lines`.`sort_order`
`vehicle_lines`.`is_active`
`vehicle_lines`.`created_at`
`vehicle_lines`.`updated_at`
`vehicle_models`.*
`vehicle_models`.`id`
`vehicle_models`.`line_id`
`vehicle_models`.`name_ar`
`vehicle_models`.`name_en`
`vehicle_models`.`code`
`vehicle_models`.`is_active`
`vehicle_models`.`created_at`
`vehicle_models`.`updated_at`
`vehicle_years`.*
`vehicle_years`.`id`
`vehicle_years`.`model_id`
`vehicle_years`.`year_from`
`vehicle_years`.`year_to`
`vehicle_years`.`is_active`
`vehicle_years`.`created_at`
`vehicle_years`.`updated_at`
`vehicles`.*
`vehicles`.`id`
`vehicles`.`brand`
`vehicles`.`model`
`vehicles`.`variant_name`
`vehicles`.`year_from`
`vehicles`.`year_to`
`vehicles`.`engine`
`vehicles`.`notes`
`vehicles`.`created_at`
`vehicles`.`updated_at`
`warehouses`.*
`warehouses`.`id`
`warehouses`.`name`
`warehouses`.`name_ar`
`warehouses`.`name_en`
`warehouses`.`code`
`warehouses`.`location_text`
`warehouses`.`notes`
`warehouses`.`location`
`warehouses`.`manager_name`
`warehouses`.`phone`
`warehouses`.`is_active`
`warehouses`.`created_at`
`warehouses`.`updated_at`
`activity_logs`.*
`activity_logs`.`id`
`activity_logs`.`user_id`
`activity_logs`.`module`
`activity_logs`.`action`
`activity_logs`.`subject_type`
`activity_logs`.`subject_id`
`activity_logs`.`description`
`activity_logs`.`old_values`
`activity_logs`.`new_values`
`activity_logs`.`ip_address`
`activity_logs`.`user_agent`
`activity_logs`.`created_at`
`activity_logs`.`updated_at`
`ai_part_lookups`.*
`ai_part_lookups`.`id`
`ai_part_lookups`.`vin`
`ai_part_lookups`.`requested_part_name`
`ai_part_lookups`.`normalized_part_name`
`ai_part_lookups`.`vehicle_family`
`ai_part_lookups`.`vehicle_variant`
`ai_part_lookups`.`matched_part_name`
`ai_part_lookups`.`matched_part_number`
`ai_part_lookups`.`confidence`
`ai_part_lookups`.`source_type`
`ai_part_lookups`.`needs_manual_verification`
`ai_part_lookups`.`was_saved_to_parts`
`ai_part_lookups`.`reason`
`ai_part_lookups`.`raw_json`
`ai_part_lookups`.`created_at`
`ai_part_lookups`.`updated_at`
`categories`.*
`categories`.`id`
`categories`.`parent_id`
`categories`.`name_ar`
`categories`.`name_en`
`categories`.`slug`
`categories`.`icon_path`
`categories`.`sort_order`
`categories`.`is_active`
`categories`.`created_at`
`categories`.`updated_at`
`competitor_prices`.*
`competitor_prices`.`id`
`competitor_prices`.`competitor_id`
`competitor_prices`.`part_id`
`competitor_prices`.`price`
`competitor_prices`.`currency`
`competitor_prices`.`checked_at`
`competitor_prices`.`notes`
`competitor_prices`.`created_by`
`competitor_prices`.`created_at`
`competitor_prices`.`updated_at`
`competitors`.*
`competitors`.`id`
`competitors`.`name`
`competitors`.`phone`
`competitors`.`website`
`competitors`.`city`
`competitors`.`notes`
`competitors`.`is_active`
`competitors`.`created_at`
`competitors`.`updated_at`
`customers`.*
`customers`.`id`
`customers`.`customer_type`
`customers`.`name`
`customers`.`contact_name`
`customers`.`phone`
`customers`.`email`
`customers`.`city`
`customers`.`address`
`customers`.`tax_number`
`customers`.`commercial_register`
`customers`.`notes`
`customers`.`is_active`
`customers`.`created_at`
`customers`.`updated_at`
`invoice_templates`.*
`invoice_templates`.`id`
`invoice_templates`.`name`
`invoice_templates`.`code`
`invoice_templates`.`description_text`
`invoice_templates`.`is_default`
`invoice_templates`.`template_path`
`invoice_templates`.`settings_json`
`invoice_templates`.`is_active`
`invoice_templates`.`created_at`
`invoice_templates`.`updated_at`
`manufacturers`.*
`manufacturers`.`id`
`manufacturers`.`name`
`manufacturers`.`country`
`manufacturers`.`notes`
`manufacturers`.`is_active`
`manufacturers`.`created_at`
`manufacturers`.`updated_at`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`part_competitor_prices`.*
`part_competitor_prices`.`id`
`part_competitor_prices`.`part_id`
`part_competitor_prices`.`competitor_id`
`part_competitor_prices`.`price`
`part_competitor_prices`.`notes`
`part_competitor_prices`.`created_at`
`part_competitor_prices`.`updated_at`
`part_fitments`.*
`part_fitments`.`id`
`part_fitments`.`part_id`
`part_fitments`.`brand_id`
`part_fitments`.`line_id`
`part_fitments`.`model_id`
`part_fitments`.`vehicle_year_id`
`part_fitments`.`engine_id`
`part_fitments`.`notes`
`part_fitments`.`created_at`
`part_fitments`.`updated_at`
`part_sales_stats`.*
`part_sales_stats`.`id`
`part_sales_stats`.`part_id`
`part_sales_stats`.`sold_qty`
`part_sales_stats`.`sold_amount`
`part_sales_stats`.`created_at`
`part_sales_stats`.`updated_at`
`part_vehicle_links`.*
`part_vehicle_links`.`id`
`part_vehicle_links`.`part_id`
`part_vehicle_links`.`vehicle_id`
`part_vehicle_links`.`created_at`
`part_vehicle_links`.`updated_at`
`part_vehicle_verifications`.*
`part_vehicle_verifications`.`id`
`part_vehicle_verifications`.`part_id`
`part_vehicle_verifications`.`vehicle_id`
`part_vehicle_verifications`.`verification_status`
`part_vehicle_verifications`.`source_scope`
`part_vehicle_verifications`.`source_flags`
`part_vehicle_verifications`.`reference_groups`
`part_vehicle_verifications`.`is_live_link`
`part_vehicle_verifications`.`is_family_candidate`
`part_vehicle_verifications`.`review_notes`
`part_vehicle_verifications`.`reviewed_by`
`part_vehicle_verifications`.`verified_at`
`part_vehicle_verifications`.`created_at`
`part_vehicle_verifications`.`updated_at`
`part_verification_reviews`.*
`part_verification_reviews`.`id`
`part_verification_reviews`.`part_id`
`part_verification_reviews`.`verification_status`
`part_verification_reviews`.`review_notes`
`part_verification_reviews`.`reviewed_by`
`part_verification_reviews`.`verified_at`
`part_verification_reviews`.`created_at`
`part_verification_reviews`.`updated_at`
`parts`.*
`parts`.`id`
`parts`.`category_id`
`parts`.`manufacturer_id`
`parts`.`part_name_ar`
`parts`.`part_name_en`
`parts`.`brand_name`
`parts`.`part_type`
`parts`.`vehicle_id`
`parts`.`part_number`
`parts`.`alternate_part_number`
`parts`.`sku`
`parts`.`barcode`
`parts`.`description`
`parts`.`cost_price`
`parts`.`sale_price`
`parts`.`wholesale_price`
`parts`.`min_stock_level`
`parts`.`sold_qty_total`
`parts`.`sales_amount_total`
`parts`.`unit_name`
`parts`.`is_active`
`parts`.`unit`
`parts`.`image_path`
`parts`.`status`
`parts`.`reference_status`
`parts`.`reference_verified_at`
`parts`.`reference_verified_by`
`parts`.`reference_notes`
`parts`.`notes`
`parts`.`created_by`
`parts`.`updated_by`
`parts`.`created_at`
`parts`.`updated_at`
`parts`.`warehouse_id`
`parts`.`total_sold_qty`
`parts`.`total_sales_amount`
`parts`.`total_sales_cost`
`parts`.`total_profit_amount`
`payments`.*
`payments`.`id`
`payments`.`paymentable_type`
`payments`.`paymentable_id`
`payments`.`payment_method`
`payments`.`amount`
`payments`.`reference_number`
`payments`.`payment_date`
`payments`.`notes`
`payments`.`received_by`
`payments`.`created_at`
`payments`.`updated_at`
`permission_role`.*
`permission_role`.`id`
`permission_role`.`role_id`
`permission_role`.`permission_id`
`permission_role`.`created_at`
`permission_role`.`updated_at`
`permissions`.*
`permissions`.`id`
`permissions`.`name`
`permissions`.`code`
`permissions`.`module`
`permissions`.`description`
`permissions`.`is_active`
`permissions`.`created_at`
`permissions`.`updated_at`
`purchase_order_items`.*
`purchase_order_items`.`id`
`purchase_order_items`.`purchase_order_id`
`purchase_order_items`.`part_id`
`purchase_order_items`.`description_text`
`purchase_order_items`.`qty`
`purchase_order_items`.`unit_price`
`purchase_order_items`.`description`
`purchase_order_items`.`qty_ordered`
`purchase_order_items`.`qty_received`
`purchase_order_items`.`unit_cost`
`purchase_order_items`.`discount_amount`
`purchase_order_items`.`tax_amount`
`purchase_order_items`.`line_total`
`purchase_order_items`.`created_at`
`purchase_order_items`.`updated_at`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`order_number`
`purchase_orders`.`po_number`
`purchase_orders`.`supplier_id`
`purchase_orders`.`status`
`purchase_orders`.`warehouse_id`
`purchase_orders`.`order_date`
`purchase_orders`.`expected_date`
`purchase_orders`.`subtotal`
`purchase_orders`.`discount_amount`
`purchase_orders`.`tax_amount`
`purchase_orders`.`total_amount`
`purchase_orders`.`currency`
`purchase_orders`.`notes`
`purchase_orders`.`template_code`
`purchase_orders`.`created_by`
`purchase_orders`.`approved_by`
`purchase_orders`.`approved_at`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_receipt_items`.*
`purchase_receipt_items`.`id`
`purchase_receipt_items`.`purchase_receipt_id`
`purchase_receipt_items`.`part_id`
`purchase_receipt_items`.`qty_received`
`purchase_receipt_items`.`unit_cost`
`purchase_receipt_items`.`created_at`
`purchase_receipt_items`.`updated_at`
`purchase_receipts`.*
`purchase_receipts`.`id`
`purchase_receipts`.`purchase_order_id`
`purchase_receipts`.`receipt_number`
`purchase_receipts`.`warehouse_id`
`purchase_receipts`.`received_date`
`purchase_receipts`.`notes`
`purchase_receipts`.`received_by`
`purchase_receipts`.`created_at`
`purchase_receipts`.`updated_at`
`quotation_items`.*
`quotation_items`.`id`
`quotation_items`.`quotation_id`
`quotation_items`.`part_id`
`quotation_items`.`description_text`
`quotation_items`.`description`
`quotation_items`.`qty`
`quotation_items`.`unit_price`
`quotation_items`.`cost_price_snapshot`
`quotation_items`.`discount_amount`
`quotation_items`.`tax_amount`
`quotation_items`.`line_total`
`quotation_items`.`sort_order`
`quotation_items`.`created_at`
`quotation_items`.`updated_at`
`quotations`.*
`quotations`.`id`
`quotations`.`quotation_number`
`quotations`.`customer_id`
`quotations`.`status`
`quotations`.`quotation_date`
`quotations`.`expiry_date`
`quotations`.`warehouse_id`
`quotations`.`vat_enabled`
`quotations`.`vat_rate`
`quotations`.`subtotal`
`quotations`.`discount_amount`
`quotations`.`tax_amount`
`quotations`.`total_amount`
`quotations`.`currency`
`quotations`.`notes`
`quotations`.`template_code`
`quotations`.`converted_sales_invoice_id`
`quotations`.`created_by`
`quotations`.`approved_by`
`quotations`.`approved_at`
`quotations`.`sent_at`
`quotations`.`created_at`
`quotations`.`updated_at`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`code`
`roles`.`description`
`roles`.`is_active`
`roles`.`created_at`
`roles`.`updated_at`
`sales_invoice_items`.*
`sales_invoice_items`.`id`
`sales_invoice_items`.`sales_invoice_id`
`sales_invoice_items`.`warehouse_id`
`sales_invoice_items`.`part_id`
`sales_invoice_items`.`description_text`
`sales_invoice_items`.`description`
`sales_invoice_items`.`qty`
`sales_invoice_items`.`unit_price`
`sales_invoice_items`.`cost_price_snapshot`
`sales_invoice_items`.`discount_amount`
`sales_invoice_items`.`tax_amount`
`sales_invoice_items`.`line_total`
`sales_invoice_items`.`sold_at`
`sales_invoice_items`.`created_at`
`sales_invoice_items`.`updated_at`
`sales_invoices`.*
`sales_invoices`.`id`
`sales_invoices`.`invoice_number`
`sales_invoices`.`customer_id`
`sales_invoices`.`customer_name`
`sales_invoices`.`customer_phone`
`sales_invoices`.`customer_address`
`sales_invoices`.`quotation_id`
`sales_invoices`.`status`
`sales_invoices`.`order_source`
`sales_invoices`.`invoice_date`
`sales_invoices`.`warehouse_id`
`sales_invoices`.`vat_enabled`
`sales_invoices`.`vat_rate`
`sales_invoices`.`subtotal`
`sales_invoices`.`discount_amount`
`sales_invoices`.`tax_amount`
`sales_invoices`.`total_amount`
`sales_invoices`.`paid_amount`
`sales_invoices`.`due_amount`
`sales_invoices`.`currency`
`sales_invoices`.`notes`
`sales_invoices`.`template_code`
`sales_invoices`.`created_by`
`sales_invoices`.`approved_by`
`sales_invoices`.`approved_at`
`sales_invoices`.`created_at`
`sales_invoices`.`updated_at`
`sales_invoices`.`payment_method`
`sales_invoices`.`payment_fee_profile`
`sales_invoices`.`gateway_rate`
`sales_invoices`.`gateway_fee`
`sales_invoices`.`checkout_fee`
`sales_invoices`.`payment_fees_vat`
`sales_invoices`.`payment_fees_total`
`sales_invoices`.`payment_gateway_profile`
`sales_invoices`.`customer_shipping_fee`
`sales_invoices`.`merchant_shipping_cost`
`sales_invoices`.`cod_fee`
`sales_invoices`.`cod_fee_vat`
`sales_invoices`.`shipping_profit_loss`
`sales_invoices`.`cogs_total`
`sales_invoices`.`net_payout_before_cogs`
`sales_invoices`.`net_profit`
`sales_invoices`.`gateway_fee_rate`
`sales_invoices`.`gateway_fee_amount`
`sales_invoices`.`checkout_fee_amount`
`sales_invoices`.`fees_vat_amount`
`sales_invoices`.`payment_fee_amount`
`sales_invoices`.`net_amount_before_cost`
`sales_invoices`.`cost_of_goods_amount`
`sales_invoices`.`net_profit_amount`
`sales_invoices`.`sold_at`
`sessions`.*
`sessions`.`id`
`sessions`.`user_id`
`sessions`.`ip_address`
`sessions`.`user_agent`
`sessions`.`payload`
`sessions`.`last_activity`
`settings`.*
`settings`.`id`
`settings`.`group_name`
`settings`.`setting_key`
`settings`.`setting_value`
`settings`.`setting_type`
`settings`.`notes`
`settings`.`created_at`
`settings`.`updated_at`
`stock_alerts`.*
`stock_alerts`.`id`
`stock_alerts`.`part_id`
`stock_alerts`.`warehouse_id`
`stock_alerts`.`alert_type`
`stock_alerts`.`threshold_qty`
`stock_alerts`.`current_qty`
`stock_alerts`.`is_resolved`
`stock_alerts`.`resolved_at`
`stock_alerts`.`created_at`
`stock_alerts`.`updated_at`
`stock_balances`.*
`stock_balances`.`id`
`stock_balances`.`part_id`
`stock_balances`.`warehouse_id`
`stock_balances`.`quantity`
`stock_balances`.`qty_on_hand`
`stock_balances`.`reserved_quantity`
`stock_balances`.`available_quantity`
`stock_balances`.`avg_cost`
`stock_balances`.`created_at`
`stock_balances`.`updated_at`
`stock_movements`.*
`stock_movements`.`id`
`stock_movements`.`part_id`
`stock_movements`.`warehouse_id`
`stock_movements`.`movement_type`
`stock_movements`.`reference_type`
`stock_movements`.`reference_id`
`stock_movements`.`quantity`
`stock_movements`.`unit_cost`
`stock_movements`.`unit_price`
`stock_movements`.`balance_before`
`stock_movements`.`balance_after`
`stock_movements`.`notes`
`stock_movements`.`performed_by`
`stock_movements`.`created_at`
`stock_movements`.`updated_at`
`supplier_part_prices`.*
`supplier_part_prices`.`id`
`supplier_part_prices`.`supplier_id`
`supplier_part_prices`.`part_id`
`supplier_part_prices`.`supplier_part_number`
`supplier_part_prices`.`last_cost`
`supplier_part_prices`.`currency`
`supplier_part_prices`.`lead_time_days`
`supplier_part_prices`.`minimum_order_qty`
`supplier_part_prices`.`is_preferred`
`supplier_part_prices`.`notes`
`supplier_part_prices`.`created_at`
`supplier_part_prices`.`updated_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`contact_name`
`suppliers`.`phone`
`suppliers`.`email`
`suppliers`.`country`
`suppliers`.`city`
`suppliers`.`address`
`suppliers`.`tax_number`
`suppliers`.`commercial_register`
`suppliers`.`currency`
`suppliers`.`notes`
`suppliers`.`is_active`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`users`.*
`users`.`id`
`users`.`full_name`
`users`.`name`
`users`.`email`
`users`.`role_name`
`users`.`phone`
`users`.`password`
`users`.`role_id`
`users`.`avatar`
`users`.`is_active`
`users`.`email_verified_at`
`users`.`remember_token`
`users`.`last_login_at`
`users`.`created_at`
`users`.`updated_at`
`vehicle_brands`.*
`vehicle_brands`.`id`
`vehicle_brands`.`name_ar`
`vehicle_brands`.`name_en`
`vehicle_brands`.`is_active`
`vehicle_brands`.`created_at`
`vehicle_brands`.`updated_at`
`vehicle_engines`.*
`vehicle_engines`.`id`
`vehicle_engines`.`model_id`
`vehicle_engines`.`engine_name`
`vehicle_engines`.`engine_code`
`vehicle_engines`.`fuel_type`
`vehicle_engines`.`notes`
`vehicle_engines`.`is_active`
`vehicle_engines`.`created_at`
`vehicle_engines`.`updated_at`
`vehicle_lines`.*
`vehicle_lines`.`id`
`vehicle_lines`.`brand_id`
`vehicle_lines`.`name_ar`
`vehicle_lines`.`name_en`
`vehicle_lines`.`sort_order`
`vehicle_lines`.`is_active`
`vehicle_lines`.`created_at`
`vehicle_lines`.`updated_at`
`vehicle_models`.*
`vehicle_models`.`id`
`vehicle_models`.`line_id`
`vehicle_models`.`name_ar`
`vehicle_models`.`name_en`
`vehicle_models`.`code`
`vehicle_models`.`is_active`
`vehicle_models`.`created_at`
`vehicle_models`.`updated_at`
`vehicle_years`.*
`vehicle_years`.`id`
`vehicle_years`.`model_id`
`vehicle_years`.`year_from`
`vehicle_years`.`year_to`
`vehicle_years`.`is_active`
`vehicle_years`.`created_at`
`vehicle_years`.`updated_at`
`vehicles`.*
`vehicles`.`id`
`vehicles`.`brand`
`vehicles`.`model`
`vehicles`.`variant_name`
`vehicles`.`year_from`
`vehicles`.`year_to`
`vehicles`.`engine`
`vehicles`.`notes`
`vehicles`.`created_at`
`vehicles`.`updated_at`
`warehouses`.*
`warehouses`.`id`
`warehouses`.`name`
`warehouses`.`name_ar`
`warehouses`.`name_en`
`warehouses`.`code`
`warehouses`.`location_text`
`warehouses`.`notes`
`warehouses`.`location`
`warehouses`.`manager_name`
`warehouses`.`phone`
`warehouses`.`is_active`
`warehouses`.`created_at`
`warehouses`.`updated_at`
`activity_logs`.*
`activity_logs`.`id`
`activity_logs`.`user_id`
`activity_logs`.`module`
`activity_logs`.`action`
`activity_logs`.`subject_type`
`activity_logs`.`subject_id`
`activity_logs`.`description`
`activity_logs`.`old_values`
`activity_logs`.`new_values`
`activity_logs`.`ip_address`
`activity_logs`.`user_agent`
`activity_logs`.`created_at`
`activity_logs`.`updated_at`
`ai_part_lookups`.*
`ai_part_lookups`.`id`
`ai_part_lookups`.`vin`
`ai_part_lookups`.`requested_part_name`
`ai_part_lookups`.`normalized_part_name`
`ai_part_lookups`.`vehicle_family`
`ai_part_lookups`.`vehicle_variant`
`ai_part_lookups`.`matched_part_name`
`ai_part_lookups`.`matched_part_number`
`ai_part_lookups`.`confidence`
`ai_part_lookups`.`source_type`
`ai_part_lookups`.`needs_manual_verification`
`ai_part_lookups`.`was_saved_to_parts`
`ai_part_lookups`.`reason`
`ai_part_lookups`.`raw_json`
`ai_part_lookups`.`created_at`
`ai_part_lookups`.`updated_at`
`categories`.*
`categories`.`id`
`categories`.`parent_id`
`categories`.`name_ar`
`categories`.`name_en`
`categories`.`slug`
`categories`.`icon_path`
`categories`.`sort_order`
`categories`.`is_active`
`categories`.`created_at`
`categories`.`updated_at`
`competitor_prices`.*
`competitor_prices`.`id`
`competitor_prices`.`competitor_id`
`competitor_prices`.`part_id`
`competitor_prices`.`price`
`competitor_prices`.`currency`
`competitor_prices`.`checked_at`
`competitor_prices`.`notes`
`competitor_prices`.`created_by`
`competitor_prices`.`created_at`
`competitor_prices`.`updated_at`
`competitors`.*
`competitors`.`id`
`competitors`.`name`
`competitors`.`phone`
`competitors`.`website`
`competitors`.`city`
`competitors`.`notes`
`competitors`.`is_active`
`competitors`.`created_at`
`competitors`.`updated_at`
`customers`.*
`customers`.`id`
`customers`.`customer_type`
`customers`.`name`
`customers`.`contact_name`
`customers`.`phone`
`customers`.`email`
`customers`.`city`
`customers`.`address`
`customers`.`tax_number`
`customers`.`commercial_register`
`customers`.`notes`
`customers`.`is_active`
`customers`.`created_at`
`customers`.`updated_at`
`invoice_templates`.*
`invoice_templates`.`id`
`invoice_templates`.`name`
`invoice_templates`.`code`
`invoice_templates`.`description_text`
`invoice_templates`.`is_default`
`invoice_templates`.`template_path`
`invoice_templates`.`settings_json`
`invoice_templates`.`is_active`
`invoice_templates`.`created_at`
`invoice_templates`.`updated_at`
`manufacturers`.*
`manufacturers`.`id`
`manufacturers`.`name`
`manufacturers`.`country`
`manufacturers`.`notes`
`manufacturers`.`is_active`
`manufacturers`.`created_at`
`manufacturers`.`updated_at`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`part_competitor_prices`.*
`part_competitor_prices`.`id`
`part_competitor_prices`.`part_id`
`part_competitor_prices`.`competitor_id`
`part_competitor_prices`.`price`
`part_competitor_prices`.`notes`
`part_competitor_prices`.`created_at`
`part_competitor_prices`.`updated_at`
`part_fitments`.*
`part_fitments`.`id`
`part_fitments`.`part_id`
`part_fitments`.`brand_id`
`part_fitments`.`line_id`
`part_fitments`.`model_id`
`part_fitments`.`vehicle_year_id`
`part_fitments`.`engine_id`
`part_fitments`.`notes`
`part_fitments`.`created_at`
`part_fitments`.`updated_at`
`part_sales_stats`.*
`part_sales_stats`.`id`
`part_sales_stats`.`part_id`
`part_sales_stats`.`sold_qty`
`part_sales_stats`.`sold_amount`
`part_sales_stats`.`created_at`
`part_sales_stats`.`updated_at`
`part_vehicle_links`.*
`part_vehicle_links`.`id`
`part_vehicle_links`.`part_id`
`part_vehicle_links`.`vehicle_id`
`part_vehicle_links`.`created_at`
`part_vehicle_links`.`updated_at`
`part_vehicle_verifications`.*
`part_vehicle_verifications`.`id`
`part_vehicle_verifications`.`part_id`
`part_vehicle_verifications`.`vehicle_id`
`part_vehicle_verifications`.`verification_status`
`part_vehicle_verifications`.`source_scope`
`part_vehicle_verifications`.`source_flags`
`part_vehicle_verifications`.`reference_groups`
`part_vehicle_verifications`.`is_live_link`
`part_vehicle_verifications`.`is_family_candidate`
`part_vehicle_verifications`.`review_notes`
`part_vehicle_verifications`.`reviewed_by`
`part_vehicle_verifications`.`verified_at`
`part_vehicle_verifications`.`created_at`
`part_vehicle_verifications`.`updated_at`
`part_verification_reviews`.*
`part_verification_reviews`.`id`
`part_verification_reviews`.`part_id`
`part_verification_reviews`.`verification_status`
`part_verification_reviews`.`review_notes`
`part_verification_reviews`.`reviewed_by`
`part_verification_reviews`.`verified_at`
`part_verification_reviews`.`created_at`
`part_verification_reviews`.`updated_at`
`parts`.*
`parts`.`id`
`parts`.`category_id`
`parts`.`manufacturer_id`
`parts`.`part_name_ar`
`parts`.`part_name_en`
`parts`.`brand_name`
`parts`.`part_type`
`parts`.`vehicle_id`
`parts`.`part_number`
`parts`.`alternate_part_number`
`parts`.`sku`
`parts`.`barcode`
`parts`.`description`
`parts`.`cost_price`
`parts`.`sale_price`
`parts`.`wholesale_price`
`parts`.`min_stock_level`
`parts`.`sold_qty_total`
`parts`.`sales_amount_total`
`parts`.`unit_name`
`parts`.`is_active`
`parts`.`unit`
`parts`.`image_path`
`parts`.`status`
`parts`.`reference_status`
`parts`.`reference_verified_at`
`parts`.`reference_verified_by`
`parts`.`reference_notes`
`parts`.`notes`
`parts`.`created_by`
`parts`.`updated_by`
`parts`.`created_at`
`parts`.`updated_at`
`parts`.`warehouse_id`
`parts`.`total_sold_qty`
`parts`.`total_sales_amount`
`parts`.`total_sales_cost`
`parts`.`total_profit_amount`
`payments`.*
`payments`.`id`
`payments`.`paymentable_type`
`payments`.`paymentable_id`
`payments`.`payment_method`
`payments`.`amount`
`payments`.`reference_number`
`payments`.`payment_date`
`payments`.`notes`
`payments`.`received_by`
`payments`.`created_at`
`payments`.`updated_at`
`permission_role`.*
`permission_role`.`id`
`permission_role`.`role_id`
`permission_role`.`permission_id`
`permission_role`.`created_at`
`permission_role`.`updated_at`
`permissions`.*
`permissions`.`id`
`permissions`.`name`
`permissions`.`code`
`permissions`.`module`
`permissions`.`description`
`permissions`.`is_active`
`permissions`.`created_at`
`permissions`.`updated_at`
`purchase_order_items`.*
`purchase_order_items`.`id`
`purchase_order_items`.`purchase_order_id`
`purchase_order_items`.`part_id`
`purchase_order_items`.`description_text`
`purchase_order_items`.`qty`
`purchase_order_items`.`unit_price`
`purchase_order_items`.`description`
`purchase_order_items`.`qty_ordered`
`purchase_order_items`.`qty_received`
`purchase_order_items`.`unit_cost`
`purchase_order_items`.`discount_amount`
`purchase_order_items`.`tax_amount`
`purchase_order_items`.`line_total`
`purchase_order_items`.`created_at`
`purchase_order_items`.`updated_at`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`order_number`
`purchase_orders`.`po_number`
`purchase_orders`.`supplier_id`
`purchase_orders`.`status`
`purchase_orders`.`warehouse_id`
`purchase_orders`.`order_date`
`purchase_orders`.`expected_date`
`purchase_orders`.`subtotal`
`purchase_orders`.`discount_amount`
`purchase_orders`.`tax_amount`
`purchase_orders`.`total_amount`
`purchase_orders`.`currency`
`purchase_orders`.`notes`
`purchase_orders`.`template_code`
`purchase_orders`.`created_by`
`purchase_orders`.`approved_by`
`purchase_orders`.`approved_at`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_receipt_items`.*
`purchase_receipt_items`.`id`
`purchase_receipt_items`.`purchase_receipt_id`
`purchase_receipt_items`.`part_id`
`purchase_receipt_items`.`qty_received`
`purchase_receipt_items`.`unit_cost`
`purchase_receipt_items`.`created_at`
`purchase_receipt_items`.`updated_at`
`purchase_receipts`.*
`purchase_receipts`.`id`
`purchase_receipts`.`purchase_order_id`
`purchase_receipts`.`receipt_number`
`purchase_receipts`.`warehouse_id`
`purchase_receipts`.`received_date`
`purchase_receipts`.`notes`
`purchase_receipts`.`received_by`
`purchase_receipts`.`created_at`
`purchase_receipts`.`updated_at`
`quotation_items`.*
`quotation_items`.`id`
`quotation_items`.`quotation_id`
`quotation_items`.`part_id`
`quotation_items`.`description_text`
`quotation_items`.`description`
`quotation_items`.`qty`
`quotation_items`.`unit_price`
`quotation_items`.`cost_price_snapshot`
`quotation_items`.`discount_amount`
`quotation_items`.`tax_amount`
`quotation_items`.`line_total`
`quotation_items`.`sort_order`
`quotation_items`.`created_at`
`quotation_items`.`updated_at`
`quotations`.*
`quotations`.`id`
`quotations`.`quotation_number`
`quotations`.`customer_id`
`quotations`.`status`
`quotations`.`quotation_date`
`quotations`.`expiry_date`
`quotations`.`warehouse_id`
`quotations`.`vat_enabled`
`quotations`.`vat_rate`
`quotations`.`subtotal`
`quotations`.`discount_amount`
`quotations`.`tax_amount`
`quotations`.`total_amount`
`quotations`.`currency`
`quotations`.`notes`
`quotations`.`template_code`
`quotations`.`converted_sales_invoice_id`
`quotations`.`created_by`
`quotations`.`approved_by`
`quotations`.`approved_at`
`quotations`.`sent_at`
`quotations`.`created_at`
`quotations`.`updated_at`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`code`
`roles`.`description`
`roles`.`is_active`
`roles`.`created_at`
`roles`.`updated_at`
`sales_invoice_items`.*
`sales_invoice_items`.`id`
`sales_invoice_items`.`sales_invoice_id`
`sales_invoice_items`.`warehouse_id`
`sales_invoice_items`.`part_id`
`sales_invoice_items`.`description_text`
`sales_invoice_items`.`description`
`sales_invoice_items`.`qty`
`sales_invoice_items`.`unit_price`
`sales_invoice_items`.`cost_price_snapshot`
`sales_invoice_items`.`discount_amount`
`sales_invoice_items`.`tax_amount`
`sales_invoice_items`.`line_total`
`sales_invoice_items`.`sold_at`
`sales_invoice_items`.`created_at`
`sales_invoice_items`.`updated_at`
`sales_invoices`.*
`sales_invoices`.`id`
`sales_invoices`.`invoice_number`
`sales_invoices`.`customer_id`
`sales_invoices`.`customer_name`
`sales_invoices`.`customer_phone`
`sales_invoices`.`customer_address`
`sales_invoices`.`quotation_id`
`sales_invoices`.`status`
`sales_invoices`.`order_source`
`sales_invoices`.`invoice_date`
`sales_invoices`.`warehouse_id`
`sales_invoices`.`vat_enabled`
`sales_invoices`.`vat_rate`
`sales_invoices`.`subtotal`
`sales_invoices`.`discount_amount`
`sales_invoices`.`tax_amount`
`sales_invoices`.`total_amount`
`sales_invoices`.`paid_amount`
`sales_invoices`.`due_amount`
`sales_invoices`.`currency`
`sales_invoices`.`notes`
`sales_invoices`.`template_code`
`sales_invoices`.`created_by`
`sales_invoices`.`approved_by`
`sales_invoices`.`approved_at`
`sales_invoices`.`created_at`
`sales_invoices`.`updated_at`
`sales_invoices`.`payment_method`
`sales_invoices`.`payment_fee_profile`
`sales_invoices`.`gateway_rate`
`sales_invoices`.`gateway_fee`
`sales_invoices`.`checkout_fee`
`sales_invoices`.`payment_fees_vat`
`sales_invoices`.`payment_fees_total`
`sales_invoices`.`payment_gateway_profile`
`sales_invoices`.`customer_shipping_fee`
`sales_invoices`.`merchant_shipping_cost`
`sales_invoices`.`cod_fee`
`sales_invoices`.`cod_fee_vat`
`sales_invoices`.`shipping_profit_loss`
`sales_invoices`.`cogs_total`
`sales_invoices`.`net_payout_before_cogs`
`sales_invoices`.`net_profit`
`sales_invoices`.`gateway_fee_rate`
`sales_invoices`.`gateway_fee_amount`
`sales_invoices`.`checkout_fee_amount`
`sales_invoices`.`fees_vat_amount`
`sales_invoices`.`payment_fee_amount`
`sales_invoices`.`net_amount_before_cost`
`sales_invoices`.`cost_of_goods_amount`
`sales_invoices`.`net_profit_amount`
`sales_invoices`.`sold_at`
`sessions`.*
`sessions`.`id`
`sessions`.`user_id`
`sessions`.`ip_address`
`sessions`.`user_agent`
`sessions`.`payload`
`sessions`.`last_activity`
`settings`.*
`settings`.`id`
`settings`.`group_name`
`settings`.`setting_key`
`settings`.`setting_value`
`settings`.`setting_type`
`settings`.`notes`
`settings`.`created_at`
`settings`.`updated_at`
`stock_alerts`.*
`stock_alerts`.`id`
`stock_alerts`.`part_id`
`stock_alerts`.`warehouse_id`
`stock_alerts`.`alert_type`
`stock_alerts`.`threshold_qty`
`stock_alerts`.`current_qty`
`stock_alerts`.`is_resolved`
`stock_alerts`.`resolved_at`
`stock_alerts`.`created_at`
`stock_alerts`.`updated_at`
`stock_balances`.*
`stock_balances`.`id`
`stock_balances`.`part_id`
`stock_balances`.`warehouse_id`
`stock_balances`.`quantity`
`stock_balances`.`qty_on_hand`
`stock_balances`.`reserved_quantity`
`stock_balances`.`available_quantity`
`stock_balances`.`avg_cost`
`stock_balances`.`created_at`
`stock_balances`.`updated_at`
`stock_movements`.*
`stock_movements`.`id`
`stock_movements`.`part_id`
`stock_movements`.`warehouse_id`
`stock_movements`.`movement_type`
`stock_movements`.`reference_type`
`stock_movements`.`reference_id`
`stock_movements`.`quantity`
`stock_movements`.`unit_cost`
`stock_movements`.`unit_price`
`stock_movements`.`balance_before`
`stock_movements`.`balance_after`
`stock_movements`.`notes`
`stock_movements`.`performed_by`
`stock_movements`.`created_at`
`stock_movements`.`updated_at`
`supplier_part_prices`.*
`supplier_part_prices`.`id`
`supplier_part_prices`.`supplier_id`
`supplier_part_prices`.`part_id`
`supplier_part_prices`.`supplier_part_number`
`supplier_part_prices`.`last_cost`
`supplier_part_prices`.`currency`
`supplier_part_prices`.`lead_time_days`
`supplier_part_prices`.`minimum_order_qty`
`supplier_part_prices`.`is_preferred`
`supplier_part_prices`.`notes`
`supplier_part_prices`.`created_at`
`supplier_part_prices`.`updated_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`contact_name`
`suppliers`.`phone`
`suppliers`.`email`
`suppliers`.`country`
`suppliers`.`city`
`suppliers`.`address`
`suppliers`.`tax_number`
`suppliers`.`commercial_register`
`suppliers`.`currency`
`suppliers`.`notes`
`suppliers`.`is_active`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`users`.*
`users`.`id`
`users`.`full_name`
`users`.`name`
`users`.`email`
`users`.`role_name`
`users`.`phone`
`users`.`password`
`users`.`role_id`
`users`.`avatar`
`users`.`is_active`
`users`.`email_verified_at`
`users`.`remember_token`
`users`.`last_login_at`
`users`.`created_at`
`users`.`updated_at`
`vehicle_brands`.*
`vehicle_brands`.`id`
`vehicle_brands`.`name_ar`
`vehicle_brands`.`name_en`
`vehicle_brands`.`is_active`
`vehicle_brands`.`created_at`
`vehicle_brands`.`updated_at`
`vehicle_engines`.*
`vehicle_engines`.`id`
`vehicle_engines`.`model_id`
`vehicle_engines`.`engine_name`
`vehicle_engines`.`engine_code`
`vehicle_engines`.`fuel_type`
`vehicle_engines`.`notes`
`vehicle_engines`.`is_active`
`vehicle_engines`.`created_at`
`vehicle_engines`.`updated_at`
`vehicle_lines`.*
`vehicle_lines`.`id`
`vehicle_lines`.`brand_id`
`vehicle_lines`.`name_ar`
`vehicle_lines`.`name_en`
`vehicle_lines`.`sort_order`
`vehicle_lines`.`is_active`
`vehicle_lines`.`created_at`
`vehicle_lines`.`updated_at`
`vehicle_models`.*
`vehicle_models`.`id`
`vehicle_models`.`line_id`
`vehicle_models`.`name_ar`
`vehicle_models`.`name_en`
`vehicle_models`.`code`
`vehicle_models`.`is_active`
`vehicle_models`.`created_at`
`vehicle_models`.`updated_at`
`vehicle_years`.*
`vehicle_years`.`id`
`vehicle_years`.`model_id`
`vehicle_years`.`year_from`
`vehicle_years`.`year_to`
`vehicle_years`.`is_active`
`vehicle_years`.`created_at`
`vehicle_years`.`updated_at`
`vehicles`.*
`vehicles`.`id`
`vehicles`.`brand`
`vehicles`.`model`
`vehicles`.`variant_name`
`vehicles`.`year_from`
`vehicles`.`year_to`
`vehicles`.`engine`
`vehicles`.`notes`
`vehicles`.`created_at`
`vehicles`.`updated_at`
`warehouses`.*
`warehouses`.`id`
`warehouses`.`name`
`warehouses`.`name_ar`
`warehouses`.`name_en`
`warehouses`.`code`
`warehouses`.`location_text`
`warehouses`.`notes`
`warehouses`.`location`
`warehouses`.`manager_name`
`warehouses`.`phone`
`warehouses`.`is_active`
`warehouses`.`created_at`
`warehouses`.`updated_at`
الاسم المستعار:
عرض :
ترتيب :
تصاعديا
تنازليا
تصاعديا
تنازليا
تصاعديا
تنازليا
امر ترتيب:
1
2
3
1
2
3
1
2
3
المعايير :
إدخال:
و:
حذف:
أو :
تعديل :
أو :
و:
إدخال
حذف
أو :
و:
إدخال
حذف
إدخال
حذف
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
إضافة/حذف أعمدة:
-3
-2
-1
0
1
2
3
Use tables
activity_logs
ai_part_lookups
categories
competitor_prices
competitors
customers
invoice_templates
manufacturers
migrations
part_competitor_prices
part_fitments
part_sales_stats
part_vehicle_links
part_vehicle_verifications
part_verification_reviews
parts
payments
permission_role
permissions
purchase_order_items
purchase_orders
purchase_receipt_items
purchase_receipts
quotation_items
quotations
roles
sales_invoice_items
sales_invoices
sessions
settings
stock_alerts
stock_balances
stock_movements
supplier_part_prices
suppliers
users
vehicle_brands
vehicle_engines
vehicle_lines
vehicle_models
vehicle_years
vehicles
warehouses
إستعلام SQL في قاعدة البيانات
roveix
: