قم إفلات الملفات هنا

SQL upload ( 0 ) x -

الإعدادات المتعلقة بالصفحة انقر على الشريط للتمرير إلى أعلى الصفحة
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
تحديث
إضافة
لا توجد إشارات مرجعية
إضافة للمفضلة
خيارات
Set default





Collapse Expand Requery تعديل Explain جانبي Bookmark Query failed قاعدة البيانات : Queried time :
بدون عنوان *
v Show/Hide tables list View in fullscreen اضافة جداول من قواعد بيانات اخري New page فتح الصفحة احفظ الصفحة حفظ الصفحة في صيغة Delete pages أنشئ الجدول Create relationship اختر الحقل لإظهاره Reload مساعدة Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > نقل القائمة > Pin text
v v
عدد الجداول: 0
v roveix activity_logs
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* module : varchar(100)
* action : varchar(100)
* subject_type : varchar(150)
* subject_id : bigint(20) unsigned
* description : text
* old_values : longtext
* new_values : longtext
* ip_address : varchar(45)
* user_agent : text
* created_at : timestamp
* updated_at : timestamp
v roveix ai_part_lookups
* id : int(10) unsigned
* vin : varchar(32)
* requested_part_name : varchar(190)
* normalized_part_name : varchar(190)
* vehicle_family : varchar(120)
* vehicle_variant : varchar(190)
* matched_part_name : varchar(190)
* matched_part_number : varchar(120)
* confidence : varchar(20)
* source_type : varchar(20)
* needs_manual_verification : tinyint(1)
* was_saved_to_parts : tinyint(1)
* reason : text
* raw_json : longtext
* created_at : datetime
* updated_at : datetime
v roveix categories
* id : bigint(20) unsigned
* parent_id : bigint(20) unsigned
* name_ar : varchar(150)
* name_en : varchar(150)
* slug : varchar(180)
* icon_path : varchar(255)
* sort_order : int(11)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v roveix competitors
* id : bigint(20) unsigned
* name : varchar(255)
* phone : varchar(30)
* website : varchar(255)
* city : varchar(100)
* notes : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v roveix competitor_prices
* id : bigint(20) unsigned
* competitor_id : bigint(20) unsigned
* part_id : bigint(20) unsigned
* price : decimal(15,2)
* currency : varchar(10)
* checked_at : timestamp
* notes : text
* created_by : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v roveix customers
* id : bigint(20) unsigned
* customer_type : enum('individual','company')
* name : varchar(255)
* contact_name : varchar(255)
* phone : varchar(30)
* email : varchar(255)
* city : varchar(100)
* address : varchar(255)
* tax_number : varchar(100)
* commercial_register : varchar(100)
* notes : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v roveix invoice_templates
* id : bigint(20) unsigned
* name : varchar(150)
* code : varchar(150)
* description_text : varchar(255)
* is_default : tinyint(1)
* template_path : varchar(255)
* settings_json : longtext
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v roveix manufacturers
* id : bigint(20) unsigned
* name : varchar(150)
* country : varchar(100)
* notes : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v roveix migrations
* id : int(10) unsigned
* migration : varchar(255)
* batch : int(11)
v roveix parts
* id : bigint(20) unsigned
* category_id : bigint(20) unsigned
* manufacturer_id : bigint(20) unsigned
* part_name_ar : varchar(255)
* part_name_en : varchar(255)
* brand_name : varchar(120)
* part_type : varchar(120)
* vehicle_id : bigint(20) unsigned
* part_number : varchar(150)
* alternate_part_number : varchar(150)
* sku : varchar(150)
* barcode : varchar(150)
* description : text
* cost_price : decimal(15,2)
* sale_price : decimal(15,2)
* wholesale_price : decimal(15,2)
* min_stock_level : decimal(15,2)
* sold_qty_total : decimal(12,2)
* sales_amount_total : decimal(12,2)
* unit_name : varchar(50)
* is_active : tinyint(1)
* unit : varchar(50)
* image_path : varchar(255)
* status : enum('active','inactive','discontinued')
* reference_status : varchar(32)
* reference_verified_at : datetime
* reference_verified_by : varchar(120)
* reference_notes : text
* notes : text
* created_by : bigint(20) unsigned
* updated_by : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
* warehouse_id : bigint(20) unsigned
* total_sold_qty : decimal(12,2)
* total_sales_amount : decimal(14,2)
* total_sales_cost : decimal(14,2)
* total_profit_amount : decimal(14,2)
v roveix part_competitor_prices
* id : int(10) unsigned
* part_id : int(10) unsigned
* competitor_id : int(10) unsigned
* price : decimal(12,2)
* notes : text
* created_at : datetime
* updated_at : datetime
v roveix part_fitments
* id : bigint(20) unsigned
* part_id : bigint(20) unsigned
* brand_id : bigint(20) unsigned
* line_id : bigint(20) unsigned
* model_id : bigint(20) unsigned
* vehicle_year_id : bigint(20) unsigned
* engine_id : bigint(20) unsigned
* notes : text
* created_at : timestamp
* updated_at : timestamp
v roveix part_sales_stats
* id : int(10) unsigned
* part_id : int(10) unsigned
* sold_qty : decimal(14,2)
* sold_amount : decimal(14,2)
* created_at : datetime
* updated_at : datetime
v roveix part_vehicle_verifications
* id : int(10) unsigned
* part_id : int(10) unsigned
* vehicle_id : int(10) unsigned
* verification_status : varchar(32)
* source_scope : varchar(64)
* source_flags : varchar(255)
* reference_groups : varchar(255)
* is_family_candidate : tinyint(1)
* review_notes : text
* reviewed_by : varchar(190)
* verified_at : datetime
* created_at : datetime
* updated_at : datetime
v roveix part_verification_reviews
* id : int(10) unsigned
* part_id : int(10) unsigned
* verification_status : varchar(32)
* review_notes : text
* reviewed_by : varchar(190)
* verified_at : datetime
* created_at : datetime
* updated_at : datetime
v roveix payments
* id : bigint(20) unsigned
* paymentable_type : varchar(100)
* paymentable_id : bigint(20) unsigned
* payment_method : enum('cash','card','bank_transfer','credit')
* amount : decimal(15,2)
* reference_number : varchar(150)
* payment_date : date
* notes : text
* received_by : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v roveix permissions
* id : bigint(20) unsigned
* name : varchar(150)
* code : varchar(150)
* module : varchar(100)
* description : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v roveix permission_role
* id : bigint(20) unsigned
* role_id : bigint(20) unsigned
* permission_id : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v roveix purchase_orders
* id : bigint(20) unsigned
* order_number : varchar(50)
* po_number : varchar(100)
* supplier_id : bigint(20) unsigned
* status : enum('draft','sent','partially_received','received','cancelled')
* warehouse_id : bigint(20) unsigned
* order_date : date
* expected_date : date
* subtotal : decimal(15,2)
* discount_amount : decimal(15,2)
* tax_amount : decimal(15,2)
* total_amount : decimal(15,2)
* currency : varchar(10)
* notes : text
* template_code : varchar(100)
* created_by : bigint(20) unsigned
* approved_by : bigint(20) unsigned
* approved_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v roveix purchase_order_items
* id : bigint(20) unsigned
* purchase_order_id : bigint(20) unsigned
* part_id : bigint(20) unsigned
* description_text : varchar(255)
* qty : decimal(12,2)
* unit_price : decimal(12,2)
* description : varchar(255)
* qty_ordered : decimal(15,2)
* qty_received : decimal(15,2)
* unit_cost : decimal(15,2)
* discount_amount : decimal(15,2)
* tax_amount : decimal(15,2)
* line_total : decimal(15,2)
* created_at : timestamp
* updated_at : timestamp
v roveix purchase_receipts
* id : bigint(20) unsigned
* purchase_order_id : bigint(20) unsigned
* receipt_number : varchar(100)
* warehouse_id : bigint(20) unsigned
* received_date : date
* notes : text
* received_by : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v roveix purchase_receipt_items
* id : bigint(20) unsigned
* purchase_receipt_id : bigint(20) unsigned
* part_id : bigint(20) unsigned
* qty_received : decimal(15,2)
* unit_cost : decimal(15,2)
* created_at : timestamp
* updated_at : timestamp
v roveix quotations
* id : bigint(20) unsigned
* quotation_number : varchar(100)
* customer_id : bigint(20) unsigned
* status : enum('draft','sent','approved','rejected','converted_to_sale')
* quotation_date : date
* expiry_date : date
* warehouse_id : bigint(20) unsigned
* vat_enabled : tinyint(1)
* vat_rate : decimal(5,2)
* subtotal : decimal(15,2)
* discount_amount : decimal(15,2)
* tax_amount : decimal(15,2)
* total_amount : decimal(15,2)
* currency : varchar(10)
* notes : text
* template_code : varchar(100)
* converted_sales_invoice_id : bigint(20) unsigned
* created_by : bigint(20) unsigned
* approved_by : bigint(20) unsigned
* approved_at : timestamp
* sent_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v roveix quotation_items
* id : bigint(20) unsigned
* quotation_id : bigint(20) unsigned
* part_id : bigint(20) unsigned
* description_text : varchar(255)
* description : varchar(255)
* qty : decimal(15,2)
* unit_price : decimal(15,2)
* cost_price_snapshot : decimal(15,2)
* discount_amount : decimal(15,2)
* tax_amount : decimal(15,2)
* line_total : decimal(15,2)
* sort_order : int(11)
* created_at : timestamp
* updated_at : timestamp
v roveix roles
* id : bigint(20) unsigned
* name : varchar(100)
* code : varchar(100)
* description : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v roveix sales_invoices
* id : bigint(20) unsigned
* invoice_number : varchar(100)
* customer_id : bigint(20) unsigned
* customer_name : varchar(190)
* customer_phone : varchar(60)
* customer_address : varchar(255)
* quotation_id : bigint(20) unsigned
* status : enum('draft','unpaid','partially_paid','paid','cancelled')
* order_source : varchar(40)
* invoice_date : date
* warehouse_id : bigint(20) unsigned
* vat_enabled : tinyint(1)
* vat_rate : decimal(5,2)
* subtotal : decimal(15,2)
* discount_amount : decimal(15,2)
* tax_amount : decimal(15,2)
* total_amount : decimal(15,2)
* paid_amount : decimal(15,2)
* due_amount : decimal(15,2)
* currency : varchar(10)
* notes : text
* template_code : varchar(100)
* created_by : bigint(20) unsigned
* approved_by : bigint(20) unsigned
* approved_at : timestamp
* created_at : timestamp
* updated_at : timestamp
* payment_method : varchar(50)
* payment_fee_profile : varchar(60)
* gateway_rate : decimal(8,4)
* gateway_fee : decimal(12,2)
* checkout_fee : decimal(12,2)
* payment_fees_vat : decimal(12,2)
* payment_fees_total : decimal(12,2)
* payment_gateway_profile : varchar(50)
* customer_shipping_fee : decimal(12,2)
* merchant_shipping_cost : decimal(12,2)
* cod_fee : decimal(12,2)
* cod_fee_vat : decimal(12,2)
* shipping_profit_loss : decimal(12,2)
* cogs_total : decimal(12,2)
* net_payout_before_cogs : decimal(12,2)
* net_profit : decimal(12,2)
* gateway_fee_rate : decimal(8,4)
* gateway_fee_amount : decimal(12,2)
* checkout_fee_amount : decimal(12,2)
* fees_vat_amount : decimal(12,2)
* payment_fee_amount : decimal(12,2)
* net_amount_before_cost : decimal(12,2)
* cost_of_goods_amount : decimal(12,2)
* net_profit_amount : decimal(12,2)
* sold_at : datetime
v roveix sales_invoice_items
* id : bigint(20) unsigned
* sales_invoice_id : bigint(20) unsigned
* warehouse_id : int(11)
* part_id : bigint(20) unsigned
* description_text : varchar(255)
* description : varchar(255)
* qty : decimal(15,2)
* unit_price : decimal(15,2)
* cost_price_snapshot : decimal(15,2)
* discount_amount : decimal(15,2)
* tax_amount : decimal(15,2)
* line_total : decimal(15,2)
* sold_at : datetime
* created_at : timestamp
* updated_at : timestamp
v roveix sessions
* id : varchar(255)
* user_id : bigint(20) unsigned
* ip_address : varchar(45)
* user_agent : text
* payload : longtext
* last_activity : int(11)
v roveix settings
* id : bigint(20) unsigned
* group_name : varchar(100)
* setting_key : varchar(150)
* setting_value : longtext
* setting_type : varchar(50)
* notes : text
* created_at : timestamp
* updated_at : timestamp
v roveix stock_alerts
* id : bigint(20) unsigned
* part_id : bigint(20) unsigned
* warehouse_id : bigint(20) unsigned
* alert_type : enum('low_stock','out_of_stock')
* threshold_qty : decimal(15,2)
* current_qty : decimal(15,2)
* is_resolved : tinyint(1)
* resolved_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v roveix stock_balances
* id : bigint(20) unsigned
* part_id : bigint(20) unsigned
* warehouse_id : bigint(20) unsigned
* quantity : decimal(15,2)
* qty_on_hand : decimal(12,2)
* reserved_quantity : decimal(15,2)
* available_quantity : decimal(15,2)
* avg_cost : decimal(15,2)
* created_at : timestamp
* updated_at : timestamp
v roveix stock_movements
* id : bigint(20) unsigned
* part_id : bigint(20) unsigned
* warehouse_id : bigint(20) unsigned
* movement_type : enum('opening','purchase','sale','adjustment','transfer_in','transfer_out','return_in','return_out')
* reference_type : varchar(100)
* reference_id : bigint(20) unsigned
* quantity : decimal(15,2)
* unit_cost : decimal(15,2)
* unit_price : decimal(15,2)
* balance_before : decimal(15,2)
* balance_after : decimal(15,2)
* notes : text
* performed_by : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v roveix suppliers
* id : bigint(20) unsigned
* name : varchar(255)
* contact_name : varchar(255)
* phone : varchar(30)
* email : varchar(255)
* country : varchar(100)
* city : varchar(100)
* address : varchar(255)
* tax_number : varchar(100)
* commercial_register : varchar(100)
* currency : varchar(10)
* notes : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v roveix supplier_part_prices
* id : bigint(20) unsigned
* supplier_id : bigint(20) unsigned
* part_id : bigint(20) unsigned
* supplier_part_number : varchar(150)
* last_cost : decimal(15,2)
* currency : varchar(10)
* lead_time_days : int(11)
* minimum_order_qty : decimal(15,2)
* is_preferred : tinyint(1)
* notes : text
* created_at : timestamp
* updated_at : timestamp
v roveix users
* id : bigint(20) unsigned
* full_name : varchar(190)
* name : varchar(255)
* email : varchar(255)
* role_name : varchar(100)
* phone : varchar(30)
* password : varchar(255)
* role_id : bigint(20) unsigned
* avatar : varchar(255)
* is_active : tinyint(1)
* email_verified_at : timestamp
* remember_token : varchar(100)
* last_login_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v roveix vehicles
* id : bigint(20) unsigned
* brand : varchar(120)
* model : varchar(150)
* variant_name : varchar(150)
* year_from : smallint(6)
* year_to : smallint(6)
* engine : varchar(120)
* notes : text
* created_at : datetime
* updated_at : datetime
v roveix vehicle_brands
* id : bigint(20) unsigned
* name_ar : varchar(150)
* name_en : varchar(150)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v roveix vehicle_engines
* id : bigint(20) unsigned
* model_id : bigint(20) unsigned
* engine_name : varchar(150)
* engine_code : varchar(100)
* fuel_type : enum('gasoline','diesel','hybrid','electric','other')
* notes : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v roveix vehicle_lines
* id : bigint(20) unsigned
* brand_id : bigint(20) unsigned
* name_ar : varchar(150)
* name_en : varchar(150)
* sort_order : int(11)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v roveix vehicle_models
* id : bigint(20) unsigned
* line_id : bigint(20) unsigned
* name_ar : varchar(150)
* name_en : varchar(150)
* code : varchar(100)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v roveix vehicle_years
* id : bigint(20) unsigned
* model_id : bigint(20) unsigned
* year_from : smallint(5) unsigned
* year_to : smallint(5) unsigned
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v roveix warehouses
* id : bigint(20) unsigned
* name : varchar(190)
* name_ar : varchar(150)
* name_en : varchar(150)
* code : varchar(100)
* location_text : varchar(190)
* notes : text
* location : varchar(255)
* manager_name : varchar(150)
* phone : varchar(30)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship