Table of Contents
- Introduction
- Important Instructions
- Requirements
- Database
- Tables
- change_log
- data_absence
- data_booking
- data_custom_shift
- data_employee
- data_employee_access
- data_employment_period
- data_fixed_shift
- data_group
- data_group_access
- data_holiday
- data_individual_working_time
- data_leave_ban
- data_leave_entitlement
- data_leave_type
- data_membership
- data_modified_shift
- data_note
- data_overtime
- data_shift_cycle
- data_shift_cycle_assignment
- data_shift_cycle_element
- data_shift_cycle_exception
- data_shift_requirement
- data_shift_type
- data_shift_type_restriction
- data_special_period
- data_special_shift_requirement
- data_special_weekday_requirement
- data_surcharge_type
- data_user_setting
- data_user_specification
- data_working_time_model
- data_workplace
- Tables
Table data_shift_type
The data_shift_type table contains the shift types.
Table Description
| Column | Data type | Description |
|---|---|---|
| shift_type_id | int | Primary key (Auto value) Unique record ID |
| name | varchar(100) | Name of the shift type Must not be empty |
| short_name | varchar(100) | Short name of the shift type Must not be empty |
| position | int | Position in the display order Default value: 0 |
| color_text | char(6) | Text color in hex format Default value: 000000 |
| color_bk | char(6) | Background color in hex format Default value: FFFFFF |
| color_bar | char(6) | Bar color in hex format Default value: FF0000 |
| bold_text | tinyint | 1 for bold text, otherwise 0 Default value: 0 |
| monday_part_count | tinyint | Number of work intervals on Monday Mögliche Werte: 0 - 3 Default value: 1 |
| monday_start_at_0 | time | Start time of the 1. work interval on Monday Default value: 00:00 |
| monday_end_at_0 | time | End time of the 1. work interval on Monday Default value: 00:00 |
| monday_start_at_1 | time | Start time of the 2. work interval on Monday Default value: 00:00 |
| monday_end_at_1 | time | End time of the 2. work interval on Monday Default value: 00:00 |
| monday_start_at_2 | time | Start time of the 3. work interval on Monday Default value: 00:00 |
| monday_end_at_2 | time | End time of the 3. work interval on Monday Default value: 00:00 |
| monday_actual_hours | double | Actual hours to be credited for a shift on Monday Default value: 0.0 |
| tuesday_part_count | tinyint | Number of work intervals on Tuesday Mögliche Werte: 0 - 3 Default value: 1 |
| tuesday_start_at_0 | time | Start time of the 1. work interval on Tuesday Default value: 00:00 |
| tuesday_end_at_0 | time | End time of the 1. work interval on Tuesday Default value: 00:00 |
| tuesday_start_at_1 | time | Start time of the 2. work interval on Tuesday Default value: 00:00 |
| tuesday_end_at_1 | time | End time of the 2. work interval on Tuesday Default value: 00:00 |
| tuesday_start_at_2 | time | Start time of the 3. work interval on Tuesday Default value: 00:00 |
| tuesday_end_at_2 | time | End time of the 3. work interval on Tuesday Default value: 00:00 |
| tuesday_actual_hours | double | Actual hours to be credited for a shift on Tuesday Default value: 0.0 |
| wednesday_part_count | tinyint | Number of work intervals on Wednesday Mögliche Werte: 0 - 3 Default value: 1 |
| wednesday_start_at_0 | time | Start time of the 1. work interval on Wednesday Default value: 00:00 |
| wednesday_end_at_0 | time | End time of the 1. work interval on Wednesday Default value: 00:00 |
| wednesday_start_at_1 | time | Start time of the 2. work interval on Wednesday Default value: 00:00 |
| wednesday_end_at_1 | time | End time of the 2. work interval on Wednesday Default value: 00:00 |
| wednesday_start_at_2 | time | Start time of the 3. work interval on Wednesday Default value: 00:00 |
| wednesday_end_at_2 | time | End time of the 3. work interval on Wednesday Default value: 00:00 |
| wednesday_actual_hours | double | Actual hours to be credited for a shift on Wednesday Default value: 0.0 |
| thursday_part_count | tinyint | Number of work intervals on Thursday Mögliche Werte: 0 - 3 Default value: 1 |
| thursday_start_at_0 | time | Start time of the 1. work interval on Thursday Default value: 00:00 |
| thursday_end_at_0 | time | End time of the 1. work interval on Thursday Default value: 00:00 |
| thursday_start_at_1 | time | Start time of the 2. work interval on Thursday Default value: 00:00 |
| thursday_end_at_1 | time | End time of the 2. work interval on Thursday Default value: 00:00 |
| thursday_start_at_2 | time | Start time of the 3. work interval on Thursday Default value: 00:00 |
| thursday_end_at_2 | time | End time of the 3. work interval on Thursday Default value: 00:00 |
| thursday_actual_hours | double | Actual hours to be credited for a shift on Thursday Default value: 0.0 |
| friday_part_count | tinyint | Number of work intervals on Friday Mögliche Werte: 0 - 3 Default value: 1 |
| friday_start_at_0 | time | Start time of the 1. work interval on Friday Default value: 00:00 |
| friday_end_at_0 | time | End time of the 1. work interval on Friday Default value: 00:00 |
| friday_start_at_1 | time | Start time of the 2. work interval on Friday Default value: 00:00 |
| friday_end_at_1 | time | End time of the 2. work interval on Friday Default value: 00:00 |
| friday_start_at_2 | time | Start time of the 3. work interval on Friday Default value: 00:00 |
| friday_end_at_2 | time | End time of the 3. work interval on Friday Default value: 00:00 |
| friday_actual_hours | double | Actual hours to be credited for a shift on Friday Default value: 0.0 |
| saturday_part_count | tinyint | Number of work intervals on Saturday Mögliche Werte: 0 - 3 Default value: 1 |
| saturday_start_at_0 | time | Start time of the 1. work interval on Saturday Default value: 00:00 |
| saturday_end_at_0 | time | End time of the 1. work interval on Saturday Default value: 00:00 |
| saturday_start_at_1 | time | Start time of the 2. work interval on Saturday Default value: 00:00 |
| saturday_end_at_1 | time | End time of the 2. work interval on Saturday Default value: 00:00 |
| saturday_start_at_2 | time | Start time of the 3. work interval on Saturday Default value: 00:00 |
| saturday_end_at_2 | time | End time of the 3. work interval on Saturday Default value: 00:00 |
| saturday_actual_hours | double | Actual hours to be credited for a shift on Saturday Default value: 0.0 |
| sunday_part_count | tinyint | Number of work intervals on Sunday Mögliche Werte: 0 - 3 Default value: 1 |
| sunday_start_at_0 | time | Start time of the 1. work interval on Sunday Default value: 00:00 |
| sunday_end_at_0 | time | End time of the 1. work interval on Sunday Default value: 00:00 |
| sunday_start_at_1 | time | Start time of the 2. work interval on Sunday Default value: 00:00 |
| sunday_end_at_1 | time | End time of the 2. work interval on Sunday Default value: 00:00 |
| sunday_start_at_2 | time | Start time of the 3. work interval on Sunday Default value: 00:00 |
| sunday_end_at_2 | time | End time of the 3. work interval on Sunday Default value: 00:00 |
| sunday_actual_hours | double | Actual hours to be credited for a shift on Sunday Default value: 0.0 |
| holiday_part_count | tinyint | Number of work intervals on a public holiday Mögliche Werte: 0 - 3 Default value: 1 |
| holiday_start_at_0 | time | Start time of the 1. work interval on a public holiday Default value: 00:00 |
| holiday_end_at_0 | time | End time of the 1. work interval on a public holiday Default value: 00:00 |
| holiday_start_at_1 | time | Start time of the 2. work interval on a public holiday Default value: 00:00 |
| holiday_end_at_1 | time | End time of the 2. work interval on a public holiday Default value: 00:00 |
| holiday_start_at_2 | time | Start time of the 3. work interval on a public holiday Default value: 00:00 |
| holiday_end_at_2 | time | End time of the 3. work interval on a public holiday Default value: 00:00 |
| holiday_actual_hours | double | Actual hours to be credited for a shift on a public holiday Default value: 0.0 |
| no_surcharge | tinyint | 1 if no time surchages should be calculated for a related shift, otherwise 0. Default value: 0 |
| category | tinyint | Assigned category (0: no restriction) Possible values: 0 - 20 Default value: 0 |
| hidden | tinyint | 1 if the shift type should be hidden in lists, otherwise 0 Default value: 0 |
| deleted | tinyint | 1 for deleted entry, otherwise 0. Default value: 0 |
| set_null_on_delete | tinyint | Must be set to NULL if the entry is deleted, otherwise to 1. Default value: 1 |
| transaction_id | bigint unsigned | For internal use only |
| created_at | timestamp(6) | Record creation time Default value: current time |
| updated_at | timestamp(6) | Last record update time Default value: current time |
Notes:
- Für mindestens einen Wochentag bzw. für Feiertage muss ein Arbeitszeitintervall angegeben sein.
- Die Arbeitszeitintervalle für einen Wochentag dürfen sich zeitlich nicht überlappen.
- Die Rahmenarbeitszeit für einen Wochentag, d.h. die Zeit zwischen dem Anfang des ersten Arbeitszeitintervalls und dem Ende des letzten Arbeitszeitintervalls, darf nicht größer als 24 Stunden sein.