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

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 parts_internal_erp competitors
* id : int(10) unsigned
* name : varchar(120)
* code : varchar(60)
* color : varchar(20)
* sort_order : int(11)
* is_active : tinyint(1)
* created_at : datetime
v parts_internal_erp custom_fields
* id : int(10) unsigned
* name : varchar(255)
* created_at : datetime
v parts_internal_erp invoice_settings
* id : int(11)
* business_name : varchar(255)
* website : varchar(255)
* cr_number : varchar(255)
* vat_number : varchar(255)
* phone : varchar(255)
* email : varchar(255)
* address : text
* vat_enabled : tinyint(1)
* show_vat_line : tinyint(1)
* show_discount_line : tinyint(1)
* show_terms : tinyint(1)
* show_notes : tinyint(1)
* show_bank_info : tinyint(1)
* show_stamp_place : tinyint(1)
* show_watermark : tinyint(1)
* show_qr : tinyint(1)
* logo_path : varchar(255)
* currency_symbol : varchar(20)
* document_type : varchar(30)
* invoice_title_ar : varchar(255)
* invoice_title_en : varchar(255)
* primary_color : varchar(20)
* secondary_color : varchar(20)
* surface_color : varchar(20)
* text_color : varchar(20)
* muted_text_color : varchar(20)
* border_color : varchar(20)
* accent_color : varchar(20)
* table_header_bg : varchar(20)
* table_header_text : varchar(20)
* table_alt_row_bg : varchar(20)
* footer_bg : varchar(20)
* footer_text_color : varchar(20)
* footer_note : text
* terms_text : text
* notes_text : text
* bank_name : varchar(255)
* iban : varchar(255)
* swift_code : varchar(255)
* watermark_text : varchar(255)
* document_number_label : varchar(255)
* date_label : varchar(255)
* customer_label : varchar(255)
* vehicle_label : varchar(255)
* invoice_template : varchar(50)
* paper_size : varchar(20)
* competitor_label_agency : varchar(255)
* competitor_label_1 : varchar(255)
* competitor_label_2 : varchar(255)
* font_heading : varchar(100)
* font_body : varchar(100)
* font_size_body : smallint(5) unsigned
* font_size_heading : smallint(5) unsigned
* font_size_small : smallint(5) unsigned
* line_height : decimal(4,2)
* row_style : varchar(30)
* radius : smallint(5) unsigned
* shadow_strength : smallint(5) unsigned
* document_width : smallint(5) unsigned
* header_layout : varchar(30)
* totals_layout : varchar(30)
* density : varchar(30)
* show_company_meta : tinyint(1)
* show_customer_block : tinyint(1)
* show_vehicle_block : tinyint(1)
* font_size : tinyint(3) unsigned
* created_at : datetime
* updated_at : datetime
v parts_internal_erp parts
* id : int(10) unsigned
* part_name : varchar(255)
* part_number : varchar(100)
* vehicle_id : int(10) unsigned
* location_label : varchar(255)
* base_cost : decimal(10,2)
* extra_fees : decimal(10,2)
* sale_price : decimal(10,2)
* competitor_agency : decimal(10,2)
* competitor_a : decimal(10,2)
* competitor_b : decimal(10,2)
* internal_note : text
* stock_qty : int(10) unsigned
* min_stock_qty : int(10) unsigned
* availability_status : varchar(30)
* created_at : datetime
* updated_at : datetime
v parts_internal_erp part_competitor_prices
* id : int(10) unsigned
* part_id : int(10) unsigned
* competitor_id : int(10) unsigned
* price : decimal(10,2)
* updated_at : datetime
v parts_internal_erp part_custom_values
* id : int(10) unsigned
* part_id : int(10) unsigned
* field_id : int(10) unsigned
* value : text
* created_at : datetime
* updated_at : datetime
v parts_internal_erp purchase_orders
* id : int(10) unsigned
* supplier_name : varchar(255)
* supplier_code : varchar(255)
* status : varchar(50)
* notes : text
* total_amount : decimal(10,2)
* received_at : datetime
* created_at : datetime
v parts_internal_erp purchase_order_items
* id : int(10) unsigned
* purchase_order_id : int(10) unsigned
* part_id : int(10) unsigned
* description : varchar(255)
* part_number : varchar(100)
* qty : int(11)
* unit_price : decimal(10,2)
* line_total : decimal(10,2)
* created_at : datetime
v parts_internal_erp quotes
* id : int(10) unsigned
* customer_name : varchar(255)
* customer_phone : varchar(50)
* vehicle_id : int(10) unsigned
* vat_enabled : tinyint(1)
* subtotal : decimal(10,2)
* vat_amount : decimal(10,2)
* total : decimal(10,2)
* notes : text
* status : varchar(30)
* converted_sale_id : int(10) unsigned
* created_at : datetime
v parts_internal_erp quote_items
* id : int(10) unsigned
* quote_id : int(10) unsigned
* part_id : int(10) unsigned
* description : varchar(255)
* part_number : varchar(100)
* qty : int(11)
* unit_price : decimal(10,2)
* line_total : decimal(10,2)
* created_at : datetime
v parts_internal_erp sales_orders
* id : int(10) unsigned
* quote_id : int(10) unsigned
* customer_name : varchar(255)
* customer_phone : varchar(50)
* vehicle_id : int(10) unsigned
* subtotal : decimal(10,2)
* vat_amount : decimal(10,2)
* total : decimal(10,2)
* cost_total : decimal(10,2)
* gross_profit : decimal(10,2)
* notes : text
* status : varchar(30)
* created_at : datetime
v parts_internal_erp sales_order_items
* id : int(10) unsigned
* sales_order_id : int(10) unsigned
* quote_item_id : int(10) unsigned
* part_id : int(10) unsigned
* description : varchar(255)
* part_number : varchar(100)
* qty : int(11)
* unit_price : decimal(10,2)
* unit_cost : decimal(10,2)
* line_total : decimal(10,2)
* line_cost : decimal(10,2)
* created_at : datetime
v parts_internal_erp site_settings
* id : tinyint(3) unsigned
* site_name : varchar(255)
* short_name : varchar(120)
* tagline : varchar(255)
* logo_path : varchar(255)
* primary_color : char(7)
* secondary_color : char(7)
* accent_color : char(7)
* page_bg_color : char(7)
* page_surface_color : char(7)
* panel_bg_color : char(7)
* panel_border_color : char(7)
* card_bg_color : char(7)
* icon_bg_color : char(7)
* sidebar_bg_color : char(7)
* topbar_bg_color : char(7)
* footer_bg_color : char(7)
* sidebar_text_color : char(7)
* sidebar_muted_color : char(7)
* page_text_color : char(7)
* page_soft_text_color : char(7)
* heading_text_color : char(7)
* logo_bg_color : char(7)
* logo_text_color : char(7)
* button_text_color : char(7)
* font_heading_site : varchar(80)
* font_body_site : varchar(80)
* font_ui_site : varchar(80)
* font_size_base : smallint(6)
* font_size_small : smallint(6)
* font_size_h1 : smallint(6)
* font_size_h2 : smallint(6)
* font_size_h3 : smallint(6)
* radius_scale : smallint(6)
* default_theme : varchar(20)
* footer_text : varchar(255)
* show_dashboard_stats : tinyint(1)
* show_quick_actions : tinyint(1)
* show_stock_alerts : tinyint(1)
* show_recent_quotes : tinyint(1)
* show_recent_purchases : tinyint(1)
* show_recent_sales : tinyint(1)
* sidebar_collapsed : tinyint(1)
* layout_json : longtext
* created_at : datetime
* updated_at : datetime
v parts_internal_erp stock_movements
* id : int(10) unsigned
* part_id : int(10) unsigned
* movement_type : varchar(50)
* qty_change : int(11)
* qty_before : int(11)
* qty_after : int(11)
* reference_type : varchar(50)
* reference_id : int(10) unsigned
* note : varchar(255)
* created_at : datetime
v parts_internal_erp vehicles
* id : int(10) unsigned
* name : varchar(255)
* model_code : varchar(50)
* year_from : smallint(6)
* year_to : smallint(6)
* notes : text
* created_at : datetime
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship