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 change_log
The change_log table contains the change log for the database.
It documents all changes to the schedule data.
Table Description
| Column | Data type | Description |
|---|---|---|
| change_log_id | int | Primary key (Auto value) Unique record ID |
| table_name | varchar(200) | Name of the table in which the change took place |
| record_id | int | Record ID of the captured, edited, or deleted record |
| collaborator_id | int | ID of the schedule user who initiated the change |
| operation | CHAR(20) | Type of operation performed. Possible values:
|
| details | varchar(8192) | Information on the change in JSON format |
| created_at | timestamp(6) | Time of logging of the change |
Notes:
To ensure that changes are saved in the table, the change log for the schedule must be enabled.
This is configured in the schedule properties.
The change log only records changes made within the Schichtplaner application.
Direct access to the database does not result in an entry in the change log.