Přetáhněte sem soubory

Nahrání SQL ( 0 ) x -

Nastavení stránky Klikněte na pruh pro posunutí stránky nahoru
Stiskněte Ctrl+Enter pro spuštění dotazu Stiskněte Enter pro spuštění dotazu
vzestupně
sestupně
Pořadí:
Ladit SQL
Počet
Pořadí provedení
Čas běhu
Seřadit dle:
Seskupit dotazy
Zrušit seskupení dotazů
Sbalit Rozbalit Zobrazit trasovací informace Skrýt trasovací informace Počet : Čas běhu :
Záložky
Obnovit
Přidat
Žádné záložky
Přidat záložku
Nastavení
Nastavit výchozí





Sbalit Rozbalit Znovu Upravit Vysvětlit Profilování Záložka Dotaz selhal Databáze : Doba běhu :
Bez názvu *
v Zobrazit/Skrýt seznam tabulek Zobrazit na celé obrazovce Přidat tabulky z jiných databází Nová stránka Otevřít stránku Uložit stránku Uložit stránku jako Odstranit stránky Vytvořit tabulku Vytvořit vztah Vyberte sloupec, který se má zobrazit Znovu načíst Nápověda Pravoúhlé spoje / Přímé spoje Zachytávat na mřížku v Vše malé/velké Přepnout malé/velké Přepnout zobrazení vztahů Exportovat schéma > Přesun menu > Připíchnout text
v v
Počet tabulek: 0
v idochazka attendance
* id : int(10) unsigned
* employee_id : int(10) unsigned
* event_type : enum('in','out','break_start','break_end','business_trip')
* event_time : datetime
* method : enum('PIN','QR','GPS','manual')
* note : varchar(255)
* terminal_ip : varchar(45)
* terminal_device : varchar(120)
* created_by : int(10) unsigned
* latitude : decimal(10,7)
* longitude : decimal(10,7)
* accuracy : int(11)
* created_at : datetime
* photo_path : varchar(255)
v idochazka attendance_locks
* id : int(10) unsigned
* company_id : int(10) unsigned
* employee_id : int(10) unsigned
* period_year : int(11)
* period_month : int(11)
* locked_by : int(10) unsigned
* locked_at : datetime
v idochazka attendance_types
* id : int(10) unsigned
* company_id : int(10) unsigned
* type_key : varchar(30)
* label : varchar(60)
* color : varchar(7)
* sort_order : int(11)
v idochazka audit_log
* id : int(10) unsigned
* user_id : int(10) unsigned
* action : varchar(80)
* entity : varchar(40)
* entity_id : int(10) unsigned
* details : text
* ip : varchar(45)
* created_at : datetime
v idochazka bonus_rules
* id : int(10) unsigned
* company_id : int(10) unsigned
* name : varchar(120)
* condition_type : enum('attendance_pct','worked_hours','max_late','no_late','no_errors','no_absence')
* condition_value : decimal(10,2)
* reward_type : enum('money','voucher','other')
* reward_value : decimal(10,2)
* reward_label : varchar(120)
* is_active : tinyint(1)
* sort_order : int(11)
* created_at : datetime
v idochazka candidate_forms
* id : int(10) unsigned
* company_id : int(10) unsigned
* token : char(48)
* status : enum('sent','submitted','converted','cancelled')
* kind : enum('hire','update','contract')
* label : varchar(150)
* email : varchar(150)
* contract_type : enum('DPP','DPC','HPP')
* job_title : varchar(120)
* work_place : varchar(100)
* work_place_loc : varchar(100)
* work_address : varchar(200)
* date_from : date
* date_to : date
* hourly_rate : decimal(10,2)
* hours_week : decimal(5,1)
* hours_year : decimal(6,1)
* payday : tinyint(3) unsigned
* supervisor : varchar(150)
* department_id : int(10) unsigned
* calendar_id : int(10) unsigned
* sign_date : date
* data_json : longtext
* submitted_at : datetime
* submitted_ip : varchar(45)
* expires_at : datetime
* employee_id : int(10) unsigned
* user_id : int(10) unsigned
* created_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v idochazka closures
* id : int(10) unsigned
* company_id : int(10) unsigned
* period_year : int(11)
* period_month : int(11)
* status : enum('open','closed')
* closed_by : int(10) unsigned
* closed_at : datetime
v idochazka companies
* id : int(10) unsigned
* name : varchar(150)
* ico : varchar(20)
* email : varchar(150)
* pn_prefix : varchar(10)
* pn_digits : int(11)
* pn_next : int(11)
* created_at : datetime
* logo_path : varchar(255)
* theme : varchar(20)
* capture_photo : tinyint(1)
* dic : varchar(20)
* street : varchar(150)
* city : varchar(100)
* zip : varchar(10)
* phone : varchar(30)
* cssz_vs : varchar(20)
* cssz_vs_from : date
* cssz_office : varchar(100)
* tax_office : varchar(100)
* tax_office_ws : varchar(100)
* databox : varchar(20)
* bank_account : varchar(30)
* bank_code : varchar(5)
* contact_person : varchar(120)
* contact_email : varchar(150)
* legal_form : varchar(60)
* registry_text : varchar(255)
* representative : varchar(200)
* acting_rule : varchar(255)
* ares_updated_at : datetime
* shift_lock_hours : smallint(5) unsigned
* shift_horizon_days : smallint(5) unsigned
v idochazka contract_templates
* id : int(10) unsigned
* company_id : int(10) unsigned
* name : varchar(120)
* contract_types : varchar(20)
* default_for : varchar(20)
* file_path : varchar(255)
* original_name : varchar(200)
* placeholders_json : text
* created_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v idochazka cssz_registrations
* id : int(10) unsigned
* company_id : int(10) unsigned
* action : tinyint(3) unsigned
* filename : varchar(120)
* xml : mediumtext
* created_by : int(10) unsigned
* created_at : datetime
* submitted_at : datetime
* submitted_by : int(10) unsigned
* note : varchar(255)
v idochazka cssz_registration_items
* id : int(10) unsigned
* registration_id : int(10) unsigned
* employee_id : int(10) unsigned
* start_date : date
* rel : varchar(2)
v idochazka custom_field_defs
* id : int(10) unsigned
* company_id : int(10) unsigned
* label : varchar(100)
* field_type : enum('text','number','date','textarea')
* sort_order : int(11)
* created_at : datetime
v idochazka departments
* id : int(10) unsigned
* company_id : int(10) unsigned
* name : varchar(100)
* code : varchar(20)
* created_at : datetime
v idochazka employees
* id : int(10) unsigned
* user_id : int(10) unsigned
* department_id : int(10) unsigned
* calendar_id : int(10) unsigned
* position : varchar(100)
* contract_type : enum('HPP','DPP','DPC')
* vacation_entitlement : decimal(5,1)
* pin_hash : varchar(255)
* qr_token : varchar(64)
* created_at : datetime
* photo_path : varchar(255)
v idochazka employee_custom_values
* id : int(10) unsigned
* employee_id : int(10) unsigned
* field_id : int(10) unsigned
* value : text
v idochazka gov_reports
* id : int(10) unsigned
* company_id : int(10) unsigned
* report_type : varchar(40)
* period_year : smallint(5) unsigned
* period_month : tinyint(3) unsigned
* reference : varchar(60)
* status : enum('generated','submitted')
* file_name : varchar(160)
* payload : longtext
* summary_json : text
* created_by : int(10) unsigned
* created_at : datetime
* submitted_at : datetime
v idochazka holidays
* id : int(10) unsigned
* holiday_date : date
* name : varchar(100)
v idochazka invitations
* id : int(10) unsigned
* company_id : int(10) unsigned
* email : varchar(150)
* role : enum('admin','accountant','employee')
* token : varchar(64)
* status : enum('pending','accepted','revoked')
* invited_by : int(10) unsigned
* created_at : datetime
* accepted_at : datetime
v idochazka jmhz_reports
* id : int(10) unsigned
* company_id : int(10) unsigned
* period_year : smallint(5) unsigned
* period_month : tinyint(3) unsigned
* kind : char(1)
* guid : char(36)
* filename : varchar(120)
* xml : mediumtext
* summary_json : text
* created_by : int(10) unsigned
* created_at : datetime
* submitted_at : datetime
* submitted_by : int(10) unsigned
* note : varchar(255)
v idochazka leaves
* id : int(10) unsigned
* employee_id : int(10) unsigned
* type : enum('vacation','sick','time_off')
* date_from : date
* date_to : date
* days : decimal(4,1)
* status : enum('pending','approved','rejected')
* reason : varchar(255)
* approved_by : int(10) unsigned
* created_at : datetime
v idochazka medical_exams
* id : int(10) unsigned
* company_id : int(10) unsigned
* employee_id : int(10) unsigned
* exam_type : enum('entry','periodic','extraordinary','exit')
* work_category : varchar(5)
* exam_date : date
* valid_until : date
* result : enum('fit','fit_conditional','unfit','not_done')
* provider : varchar(150)
* note : varchar(255)
* created_at : datetime
v idochazka notifications
* id : int(10) unsigned
* company_id : int(10) unsigned
* user_id : int(10) unsigned
* title : varchar(150)
* body : varchar(255)
* is_read : tinyint(1)
* created_at : datetime
v idochazka oopp_assignments
* id : int(10) unsigned
* company_id : int(10) unsigned
* employee_id : int(10) unsigned
* item_id : int(10) unsigned
* assigned_date : date
* replace_due : date
* size : varchar(30)
* quantity : int(11)
* returned_date : date
* note : varchar(255)
* created_at : datetime
v idochazka oopp_items
* id : int(10) unsigned
* company_id : int(10) unsigned
* name : varchar(120)
* category : varchar(60)
* lifetime_months : int(11)
* note : varchar(255)
* created_at : datetime
v idochazka password_resets
* id : int(10) unsigned
* user_id : int(10) unsigned
* token : varchar(64)
* expires_at : datetime
* used : tinyint(1)
* created_at : datetime
v idochazka payroll_children
* id : int(10) unsigned
* company_id : int(10) unsigned
* employee_id : int(10) unsigned
* name : varchar(120)
* birth_number : varchar(15)
* birth_date : date
* order_no : tinyint(3) unsigned
* ztpp : tinyint(1)
* valid_from : date
* valid_to : date
* is_active : tinyint(1)
v idochazka payroll_employees
* id : int(10) unsigned
* company_id : int(10) unsigned
* employee_id : int(10) unsigned
* wage_type : enum('monthly','hourly')
* base_wage : decimal(12,2)
* personal_bonus : decimal(12,2)
* avg_earning : decimal(12,2)
* meal_allowance : decimal(10,2)
* birth_number : varchar(15)
* birth_date : date
* birth_place : varchar(100)
* birth_surname : varchar(60)
* birth_country : char(2)
* education : char(1)
* cz_isco : char(5)
* is_manager : tinyint(1)
* work_mode : tinyint(3) unsigned
* continuous_op : tinyint(1)
* work_place : varchar(200)
* work_municode : char(6)
* pension_type : char(1)
* pension_from : date
* pension_early : tinyint(1)
* pension_reduced_age : tinyint(1)
* health_restriction : char(1)
* health_restriction_from : date
* citizenship : varchar(3)
* gender : enum('M','F')
* street : varchar(150)
* city : varchar(100)
* zip : varchar(10)
* country : varchar(3)
* health_insurer : varchar(3)
* si_participation : tinyint(1)
* hi_participation : tinyint(1)
* hi_state_insured : tinyint(1)
* tax_declaration : tinyint(1)
* credit_taxpayer : tinyint(1)
* credit_disability : enum('none','level12','level3','ztpp')
* credit_student : tinyint(1)
* contract_start : date
* contract_end : date
* contract_signed : date
* weekly_hours : decimal(5,2)
* payout_method : enum('bank','cash')
* bank_account : varchar(30)
* bank_code : varchar(5)
* note : text
* updated_at : datetime
* ik_mpsv : char(10)
* id_ppv : varchar(22)
v idochazka payroll_periods
* id : int(10) unsigned
* company_id : int(10) unsigned
* period_year : smallint(5) unsigned
* period_month : tinyint(3) unsigned
* status : enum('draft','calculated','approved','closed')
* calculated_at : datetime
* approved_at : datetime
* approved_by : int(10) unsigned
* closed_at : datetime
* note : varchar(255)
* created_at : datetime
v idochazka payroll_rates
* id : int(10) unsigned
* rate_year : smallint(5) unsigned
* rate_key : varchar(40)
* rate_value : decimal(16,4)
* label : varchar(160)
* unit : varchar(16)
* rate_group : varchar(40)
* sort_order : smallint(6)
v idochazka payroll_recurring
* id : int(10) unsigned
* company_id : int(10) unsigned
* employee_id : int(10) unsigned
* kind : enum('earning','deduction')
* label : varchar(120)
* amount : decimal(12,2)
* taxable : tinyint(1)
* insurable : tinyint(1)
* valid_from : date
* valid_to : date
* is_active : tinyint(1)
* note : varchar(255)
v idochazka payslips
* id : int(10) unsigned
* company_id : int(10) unsigned
* period_id : int(10) unsigned
* employee_id : int(10) unsigned
* worked_minutes : int(11)
* planned_minutes : int(11)
* overtime_minutes : int(11)
* night_minutes : int(11)
* weekend_minutes : int(11)
* holiday_minutes : int(11)
* vacation_days : decimal(6,2)
* sick_days : decimal(6,2)
* unpaid_days : decimal(6,2)
* base_amount : decimal(12,2)
* overtime_amount : decimal(12,2)
* night_amount : decimal(12,2)
* weekend_amount : decimal(12,2)
* holiday_amount : decimal(12,2)
* vacation_amount : decimal(12,2)
* sick_amount : decimal(12,2)
* personal_amount : decimal(12,2)
* bonus_amount : decimal(12,2)
* other_earnings : decimal(12,2)
* gross_wage : decimal(12,2)
* si_base : decimal(12,2)
* hi_base : decimal(12,2)
* si_employee : decimal(12,2)
* hi_employee : decimal(12,2)
* hi_surcharge : decimal(12,2)
* si_employer : decimal(12,2)
* hi_employer : decimal(12,2)
* tax_base : decimal(12,2)
* tax_advance : decimal(12,2)
* tax_credits : decimal(12,2)
* tax_after_credit : decimal(12,2)
* child_credit : decimal(12,2)
* tax_final : decimal(12,2)
* tax_bonus : decimal(12,2)
* withholding_tax : decimal(12,2)
* deductions : decimal(12,2)
* meal_amount : decimal(12,2)
* net_wage : decimal(12,2)
* payout : decimal(12,2)
* employer_cost : decimal(12,2)
* detail_json : longtext
* created_at : datetime
* updated_at : datetime
v idochazka payslip_items
* id : int(10) unsigned
* payslip_id : int(10) unsigned
* section : enum('earning','deduction','employer','info')
* label : varchar(140)
* quantity : decimal(12,2)
* unit : varchar(12)
* rate : decimal(12,2)
* amount : decimal(12,2)
* sort_order : smallint(6)
v idochazka positions
* id : int(10) unsigned
* company_id : int(10) unsigned
* name : varchar(100)
* cz_isco : char(5)
* created_at : datetime
v idochazka settings
* id : int(10) unsigned
* setting_key : varchar(64)
* setting_value : varchar(255)
v idochazka shift_types
* id : int(10) unsigned
* company_id : int(10) unsigned
* name : varchar(60)
* start_time : time
* end_time : time
* color : varchar(7)
* slots : smallint(5) unsigned
* weekdays : tinyint(3) unsigned
* department_id : int(10) unsigned
* sort_order : smallint(6)
* is_active : tinyint(1)
* created_at : datetime
v idochazka users
* id : int(10) unsigned
* company_id : int(10) unsigned
* first_name : varchar(60)
* last_name : varchar(60)
* personal_number : varchar(20)
* email : varchar(120)
* password_hash : varchar(255)
* role : enum('admin','accountant','employee')
* is_active : tinyint(1)
* created_at : datetime
* deleted_at : datetime
v idochazka work_calendars
* id : int(10) unsigned
* company_id : int(10) unsigned
* name : varchar(100)
* work_start : time
* work_end : time
* hours_mon : decimal(4,2)
* hours_tue : decimal(4,2)
* hours_wed : decimal(4,2)
* hours_thu : decimal(4,2)
* hours_fri : decimal(4,2)
* hours_sat : decimal(4,2)
* hours_sun : decimal(4,2)
* created_at : datetime
v idochazka work_schedules
* id : int(10) unsigned
* employee_id : int(10) unsigned
* work_date : date
* shift_type_id : int(10) unsigned
* planned_start : time
* planned_end : time
* note : varchar(255)
* created_by : int(10) unsigned
* created_at : datetime
Vytvořit vztah
FOREIGN KEY
on delete
on update
Smazat vztah