Dosyaları buraya bırakın

SQL gönderme ( 0 ) x -

Sayfa ile ilgili ayarlar Sayfanın en üstüne kaydırmak için çubuğa tklayın
Sorguyu çalıştırmak için Ctrl+Enter tuşlarına basın Sorguyu çalıştırmak için Enter tuşuna basın
küçükten büyüğe
büyükten küçüğe
Sıra:
SQL Hata Ayıklama
Sayı
Çalıştırma sırası
Aldığı süre
Sıralama:
Sorguları grupla
Sorguların grubunu kaldır
Daralt Genişlet İzi göster İzi gizle Sayı : Aldığı süre :
Yer işaretleri
Yenile
Ekle
Yer işaretleri yok
Yer işareti ekle
Seçenekler
Varsayılana ayarla





Daralt Genişlet Yeniden sorgula Düzenle Açıkla Profil çıkart Yer işareti Sorgu başarısız oldu Database : Sorgu süresi :
Başlıksız *
v Tablolar listesini göster/gizle Tam ekran görünümü Diğer veritabanlarında tabloları ekle Yeni sayfa Sayfayı aç Sayfayı kaydet Sayfayı farklı kaydet Sayfaları sil Tablo oluştur İlişki oluştur Göstermek için sütun seçin Yeniden yükle Yardım Yönlendirmeli bağlantılar / Doğrudan bağlantılar Kılavuza uydur v Tümünü Küçült/Büyült Küçüğü/büyüğü değiştir İlişki satırlarını değiştir Şemayı dışa aktar > Menüyü taşı > Metni sabitle
Tablo sayısı: 0
v metal_maliyet app_users
* id : int(11)
* username : varchar(80)
* display_name : varchar(160)
* password_hash : varchar(255)
* is_active : tinyint(1)
* last_login_at : datetime
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet bom_categories
* id : int(11)
* code : varchar(60)
* name : varchar(100)
* tab_name : varchar(100)
* sort_order : int(11)
* is_priced : tinyint(1)
* is_active : tinyint(1)
* note : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet calculation_types
* id : int(11)
* name : varchar(160)
* rate : decimal(14,4)
* unit : varchar(40)
* factor : decimal(14,4)
* excel_date : varchar(40)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet company_settings
* id : int(11)
* company_name : varchar(180)
* email : varchar(180)
* phone : varchar(80)
* address : text
* tax_office : varchar(120)
* tax_number : varchar(80)
* logo_path : varchar(255)
* updated_at : timestamp
v metal_maliyet customers
* id : int(11)
* name : varchar(220)
* email : varchar(180)
* phone : varchar(80)
* address : text
* note : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet cutting_optimization_bars
* id : int(11)
* group_id : int(11)
* bar_index : int(11)
* stock : decimal(12,4)
* used : decimal(12,4)
* waste : decimal(12,4)
* graphic : text
* created_at : timestamp
v metal_maliyet cutting_optimization_bar_pieces
* id : int(11)
* bar_id : int(11)
* piece_label : varchar(80)
* quantity : int(11)
* sort_order : int(11)
v metal_maliyet cutting_optimization_cache
* id : int(11)
* order_item_id : int(11)
* cache_key : char(64)
* algorithm_version : varchar(80)
* result_json : longtext
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet cutting_optimization_groups
* id : int(11)
* run_id : int(11)
* result_type : enum('profile','sheet')
* group_key : text
* name : varchar(255)
* material_name : varchar(255)
* category : varchar(80)
* stock : decimal(12,4)
* width : decimal(12,4)
* length : decimal(12,4)
* thickness : decimal(12,4)
* stock_found : tinyint(1)
* item_count : int(11)
* total_measure : decimal(18,4)
* used_measure : decimal(18,4)
* waste_measure : decimal(18,4)
* fire_percent : decimal(9,2)
* created_at : timestamp
v metal_maliyet cutting_optimization_required_details
* id : int(11)
* group_id : int(11)
* detail_key : varchar(191)
* piece_name : varchar(255)
* length_text : varchar(80)
* width_text : varchar(80)
* quantity : int(11)
* sort_order : int(11)
v metal_maliyet cutting_optimization_runs
* id : int(11)
* order_item_id : int(11)
* cache_key : char(64)
* algorithm_version : varchar(80)
* product_multiplier : int(11)
* profile_bars : int(11)
* profile_fire_percent : decimal(9,2)
* sheet_sheets : int(11)
* sheet_fire_percent : decimal(9,2)
* missing_stock : int(11)
* missing_stock_names : text
* missing_stock_names_1d : text
* missing_stock_names_sheet : text
* kerf : decimal(12,4)
* sheet_margin : decimal(12,4)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet cutting_optimization_sheets
* id : int(11)
* group_id : int(11)
* sheet_index : int(11)
* used_area : decimal(18,4)
* utilization : decimal(9,2)
* cut_method : varchar(80)
* created_at : timestamp
v metal_maliyet cutting_optimization_sheet_pieces
* id : int(11)
* sheet_id : int(11)
* piece_label : varchar(120)
* quantity : int(11)
* sort_order : int(11)
v metal_maliyet cutting_optimization_sheet_placements
* id : int(11)
* sheet_id : int(11)
* placement_index : int(11)
* x : decimal(12,4)
* y : decimal(12,4)
* w : decimal(12,4)
* l : decimal(12,4)
* piece_name : varchar(255)
* rotated : tinyint(1)
* cut_no : int(11)
* type_key : varchar(191)
* strip_no : int(11)
* strip_piece_no : int(11)
* smart_fill : tinyint(1)
v metal_maliyet delivery_methods
* id : int(11)
* name : varchar(180)
* value : varchar(255)
* sort_order : int(11)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet exchange_rates
* id : int(11)
* currency_code : char(3)
* currency_name : varchar(80)
* forex_buying : decimal(14,6)
* forex_selling : decimal(14,6)
* source : varchar(80)
* rate_date : date
* updated_at : timestamp
v metal_maliyet kdv_rates
* id : int(11)
* name : varchar(80)
* value : varchar(40)
* sort_order : int(11)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet manufacturing_item_approvals
* order_item_id : int(11)
* order_id : int(11)
* approved_at : datetime
v metal_maliyet manufacturing_sync_state
* order_id : int(11)
* synced_hash : char(64)
* dismissed_hash : char(64)
* synced_at : datetime
* updated_at : timestamp
v metal_maliyet materials
* id : int(11)
* name : varchar(255)
* material_type : varchar(120)
* unit : varchar(40)
* unit_price : decimal(14,4)
* price_date : date
* currency : char(3)
* calculation_type_id : int(11)
* calculation_method : varchar(120)
* note : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet optimization_runs
* id : int(11)
* order_item_id : int(11)
* run_type : varchar(40)
* status : varchar(40)
* summary_json : mediumtext
* created_at : timestamp
v metal_maliyet orders
* id : int(11)
* order_no : varchar(40)
* customer_id : int(11)
* title : varchar(255)
* order_date : date
* payment_term_id : int(11)
* delivery_method_id : int(11)
* kdv_rate_id : int(11)
* delivery_weeks : int(11)
* delivery_address : text
* note : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet order_items
* id : int(11)
* order_id : int(11)
* product_name : varchar(255)
* quantity : decimal(12,3)
* unit : varchar(50)
* note : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
* product_code : varchar(120)
* material_id : int(11)
* material_description : varchar(255)
* detected_category : varchar(80)
* length_mm : decimal(12,2)
* width_mm : decimal(12,2)
* height_mm : decimal(12,2)
* line_value : decimal(14,4)
* is_unknown_material : tinyint(1)
* qty : decimal(12,3)
* weight_value : decimal(12,3)
* size_text : varchar(255)
* product_image_path : varchar(255)
* product_color : varchar(120)
v metal_maliyet payment_terms
* id : int(11)
* name : varchar(180)
* value : varchar(255)
* sort_order : int(11)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet product_bom_rows
* id : int(11)
* order_item_id : int(11)
* revision_id : int(11)
* item_no : varchar(50)
* raw_description : varchar(255)
* cleaned_name : varchar(255)
* qty : decimal(12,3)
* detected_category : varchar(80)
* material_description : varchar(255)
* length_mm : decimal(12,2)
* width_mm : decimal(12,2)
* height_mm : decimal(12,2)
* angle1 : decimal(12,3)
* angle2 : decimal(12,3)
* sheet_thickness_mm : decimal(12,4)
* bbox_width_mm : decimal(12,3)
* bbox_length_mm : decimal(12,3)
* status : varchar(40)
* note : text
* created_at : timestamp
* updated_at : timestamp
* bends_count : int(11)
* montaj_flag : tinyint(1)
* montaj_sheet_flag : tinyint(1)
* civata_sayisi : decimal(12,3)
v metal_maliyet product_manual_actual_labor
* id : int(11)
* order_item_id : int(11)
* revision_id : int(11)
* label : varchar(190)
* hours : decimal(12,2)
* note : varchar(500)
* created_at : datetime
* updated_at : datetime
v metal_maliyet product_price_custom_rows
* id : int(11)
* order_item_id : int(11)
* revision_id : int(11)
* display_name : varchar(255)
* price_group : varchar(80)
* qty_total : decimal(14,4)
* qty_unit : decimal(14,4)
* special_price_eur : decimal(14,4)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet product_price_overrides
* id : int(11)
* order_item_id : int(11)
* revision_id : int(11)
* item_key : varchar(191)
* special_price_eur : decimal(14,4)
* created_at : timestamp
* updated_at : timestamp
* qty_total_override : decimal(14,4)
* qty_unit_override : decimal(14,4)
* display_name : varchar(255)
* is_deleted : tinyint(1)
* has_display_name_override : tinyint(1)
* has_qty_total_override : tinyint(1)
* has_qty_unit_override : tinyint(1)
* has_special_price_override : tinyint(1)
v metal_maliyet product_price_revisions
* id : int(11)
* order_item_id : int(11)
* revision_no : int(11)
* title : varchar(120)
* snapshot_json : longtext
* is_blank : tinyint(1)
* calculation_cache_key : varchar(191)
* calculation_cache_json : longtext
* calculation_cache_updated_at : datetime
* is_manufacturing_selected : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet product_saved_price_reports
* id : int(11)
* order_item_id : int(11)
* filename : varchar(255)
* report_html : mediumtext
* created_at : datetime
v metal_maliyet project_settings
* id : int(11)
* setting_key : varchar(120)
* setting_value : varchar(255)
* setting_unit : varchar(40)
* note : varchar(255)
* updated_at : timestamp
v metal_maliyet stock_materials
* id : int(11)
* material_name : varchar(255)
* normalized_name : varchar(255)
* material_type : varchar(80)
* stock_length_mm : decimal(12,2)
* stock_width_mm : decimal(12,2)
* quantity : decimal(14,3)
* label : varchar(255)
* price : decimal(14,4)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet unknown_materials
* id : int(11)
* order_id : int(11)
* order_item_id : int(11)
* description : varchar(255)
* qty : decimal(12,3)
* detected_category : varchar(80)
* reason : varchar(255)
* status : varchar(40)
* created_at : timestamp
* updated_at : timestamp
v metal_maliyet user_last_price_revision
* user_id : int(11)
* order_item_id : int(11)
* revision_id : int(11)
* updated_at : timestamp
İlişki oluştur
FOREIGN KEY
on delete
on update
İlişkiyi sil