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 cozsan_personel app_migrations
* migration_key : varchar(120)
* applied_at : timestamp
v cozsan_personel app_settings
* setting_key : varchar(100)
* setting_value : varchar(255)
* updated_at : timestamp
v cozsan_personel audit_logs
* id : bigint(20) unsigned
* user_id : int(10) unsigned
* action : varchar(100)
* entity_type : varchar(100)
* entity_id : int(10) unsigned
* details : longtext
* created_at : timestamp
v cozsan_personel departments
* id : int(10) unsigned
* name : varchar(150)
* is_active : tinyint(1)
v cozsan_personel employees
* id : int(10) unsigned
* legacy_id : int(11)
* employee_no : varchar(50)
* full_name : varchar(190)
* photo_path : varchar(255)
* card_no : varchar(50)
* is_active : tinyint(1)
* insurance : tinyint(1)
* tc_identity_no : varchar(20)
* birth_date : date
* gender : enum('male','female','other','')
* marital_status : varchar(50)
* phone : varchar(50)
* email : varchar(190)
* address : text
* emergency_contact_name : varchar(190)
* emergency_contact_phone : varchar(50)
* department_id : int(10) unsigned
* position_id : int(10) unsigned
* manager_id : int(10) unsigned
* start_date : date
* end_date : date
* exit_reason : text
* employment_type : enum('permanent','temporary','intern','contractor')
* employment_status : enum('active','leave','suspended','inactive')
* workplace : varchar(150)
* shift_name : varchar(100)
* insurance_start_date : date
* sgk_no : varchar(50)
* notes : text
* created_at : timestamp
* updated_at : timestamp
* salary_type : enum('monthly','hourly')
* salary_amount : decimal(12,2)
* hourly_rate : decimal(12,2)
* iban : varchar(50)
* bank_name : varchar(150)
* bank_account_name : varchar(190)
* first_name : varchar(120)
* last_name : varchar(120)
* photo_data : mediumblob
* photo_mime : varchar(50)
* photo_base64 : mediumtext
* daily_transport_meal_cost : decimal(12,2)
v cozsan_personel employee_advances
* id : int(10) unsigned
* employee_id : int(10) unsigned
* advance_date : date
* amount : decimal(12,2)
* note : varchar(255)
* created_by : int(10) unsigned
* created_at : timestamp
v cozsan_personel employee_annual_leaves
* id : int(10) unsigned
* employee_id : int(10) unsigned
* start_date : date
* end_date : date
* leave_type : varchar(30)
* note : varchar(255)
* created_at : timestamp
v cozsan_personel employee_documents
* id : int(10) unsigned
* employee_id : int(10) unsigned
* document_type : varchar(100)
* file_path : varchar(255)
* original_name : varchar(255)
* expires_at : date
* notes : text
* uploaded_at : timestamp
v cozsan_personel employee_movements
* id : bigint(20) unsigned
* employee_id : int(10) unsigned
* employee_name : varchar(190)
* employee_no : varchar(50)
* movement_date : date
* movement_time : time
* source : varchar(100)
* source_row : int(10) unsigned
* created_at : timestamp
v cozsan_personel employee_shift_history
* id : int(10) unsigned
* employee_id : int(10) unsigned
* effective_date : date
* shift_start : time
* shift_end : time
* source : varchar(100)
* sort_order : int(11)
* created_at : timestamp
v cozsan_personel employee_work_periods
* id : int(10) unsigned
* employee_id : int(10) unsigned
* start_date : date
* end_date : date
* sort_order : int(11)
* created_at : timestamp
v cozsan_personel impro_agent_jobs
* id : bigint(20) unsigned
* requested_by : int(10) unsigned
* status : varchar(24)
* date_from : date
* date_to : date
* message : varchar(500)
* result_json : longtext
* created_at : timestamp
* started_at : datetime
* finished_at : datetime
v cozsan_personel impro_agent_state
* id : tinyint(3) unsigned
* last_seen : datetime
* machine_name : varchar(120)
* agent_version : varchar(50)
* last_error : varchar(1000)
* updated_at : timestamp
v cozsan_personel impro_import_jobs
* id : bigint(20) unsigned
* requested_by : int(10) unsigned
* status : enum('pending','running','done','error')
* message : varchar(500)
* stats_json : text
* created_at : timestamp
* started_at : datetime
* finished_at : datetime
v cozsan_personel monthly_report_archives
* id : bigint(20) unsigned
* month_key : char(7)
* period_start : date
* period_end : date
* status : varchar(20)
* employees_count : int(11)
* attendance_days : int(11)
* normal_minutes : int(11)
* overtime_minutes : int(11)
* deficit_minutes : int(11)
* total_minutes : int(11)
* absence_days : int(11)
* late_days : int(11)
* leave_days : int(11)
* snapshot_json : longtext
* created_by : int(10) unsigned
* updated_by : int(10) unsigned
* closed_by : int(10) unsigned
* created_at : timestamp
* updated_at : timestamp
* closed_at : datetime
v cozsan_personel monthly_report_daily_stats
* id : bigint(20) unsigned
* archive_id : bigint(20) unsigned
* report_date : date
* employee_count : int(11)
* present_count : int(11)
* absent_count : int(11)
* late_count : int(11)
* leave_count : int(11)
* missing_punch_count : int(11)
* normal_minutes : int(11)
* overtime_minutes : int(11)
* deficit_minutes : int(11)
* total_minutes : int(11)
* details_json : longtext
v cozsan_personel monthly_report_employee_stats
* id : bigint(20) unsigned
* archive_id : bigint(20) unsigned
* employee_id : int(10) unsigned
* employee_no : varchar(50)
* full_name : varchar(190)
* is_active : tinyint(1)
* attendance_days : int(11)
* punch_days : int(11)
* normal_minutes : int(11)
* overtime_minutes : int(11)
* deficit_minutes : int(11)
* total_minutes : int(11)
* absence_days : int(11)
* leave_days : int(11)
* stats_json : longtext
v cozsan_personel movement_import_guards
* id : bigint(20) unsigned
* employee_id : int(10) unsigned
* employee_name : varchar(190)
* employee_no : varchar(50)
* movement_date : date
* movement_time : time
* guard_type : enum('manual_edit','manual_delete')
* replacement_movement_id : bigint(20) unsigned
* original_source : varchar(100)
* original_source_row : int(10) unsigned
* snapshot_json : longtext
* created_by : int(10) unsigned
* created_at : timestamp
* is_active : tinyint(1)
* restored_at : datetime
* restored_by : int(10) unsigned
v cozsan_personel official_holidays
* id : int(10) unsigned
* holiday_date : date
* name : varchar(190)
* created_at : timestamp
v cozsan_personel positions
* id : int(10) unsigned
* name : varchar(150)
* is_active : tinyint(1)
v cozsan_personel users
* id : int(10) unsigned
* name : varchar(150)
* email : varchar(190)
* password_hash : varchar(255)
* role : enum('admin','hr','manager','employee')
* created_at : timestamp
v cozsan_personel user_access_logs
* id : bigint(20) unsigned
* user_id : int(10) unsigned
* user_name : varchar(150)
* event_type : varchar(40)
* session_token : char(64)
* ip_address : varchar(45)
* user_agent : varchar(500)
* device_label : varchar(190)
* request_path : varchar(255)
* details : longtext
* created_at : datetime
v cozsan_personel user_sessions
* id : bigint(20) unsigned
* session_token : char(64)
* user_id : int(10) unsigned
* user_name : varchar(150)
* ip_address : varchar(45)
* user_agent : varchar(500)
* device_label : varchar(190)
* login_at : datetime
* last_seen_at : datetime
* logout_at : datetime
* logout_reason : varchar(40)
* last_path : varchar(255)
İlişki oluştur
FOREIGN KEY
on delete
on update
İlişkiyi sil