Datenregister
Dies ist das Online-Register nach Art. 26 des Data Act (Verordnung (EU) 2023/2854) für Teplano, einen Dienst der eAccounting 360 DeCy Ltd, Paphos, Zypern (siehe Impressum). Es richtet sich an Kunden, die Daten übertragen oder den Anbieter wechseln möchten. Version und Stand des Datenmodells stehen am Anfang der Datenstrukturen.
Formate und Standards
- CSV, Trennzeichen Semikolon, UTF-8 mit BOM, Zeilenende CRLF, Maskierung nach RFC 4180
- SQL im PostgreSQL-Dialekt (INSERT-Anweisungen)
- Datum und Uhrzeit nach ISO 8601
- Kennungen als UUID
- JSON nach RFC 8259
Aufbau des Vollexports
- schema/: die Migrationen als SQL
- data/NN_tabelle.sql: die Daten je Tabelle
- csv/tabelle.csv: die Daten je Tabelle als CSV
- storage/: die Dateien der Speicherbereiche
- README-IMPORT.md: Hinweise zum Import
Den Vollexport erstellen und laden Sie jederzeit selbst im Verwaltungsbereich.
Kunden erhalten zum Wechsel eine ausführliche Beschreibung aller Felder und des Ablaufs. Fragen an info@teplano.com.
Datenstrukturen
Maschinenlesbar: datenmodell.json.
Datenmodell Version 51, Stand 13.10.2026. Die Version entspricht der höchsten Migrationsnummer des Datenmodells. Insgesamt 28 Tabellen.
absences
Spalten der Tabelle absences
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| employee_id | uuid | employees.id, employee_work_schedules.employee_id |
| type | text | – |
| start_date | date | – |
| end_date | date | – |
| reported_at | timestamp without time zone | – |
| half_day | boolean | – |
| substitute_employee_id | uuid | employees.id |
| work_schedule_valid_from | date | employee_work_schedules.valid_from |
| substitute_employee_ids | uuid[] | – |
| note | text | – |
company_closed_days
Spalten der Tabelle company_closed_days
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| date | date | – |
| label | text | – |
| rule | text | – |
| created_at | timestamp with time zone | – |
company_settings
Spalten der Tabelle company_settings
| Spalte | Typ | Verweist auf |
| id | integer | – |
| monthly_overhead | numeric | – |
| overhead_allocation | text | – |
| margin_green_pct | numeric | – |
| margin_yellow_pct | numeric | – |
| updated_at | timestamp without time zone | – |
| wage_overhead_pct | numeric | – |
| school_holidays | jsonb | – |
| retention_months | jsonb | – |
| last_retention_run | jsonb | – |
| last_backup_at | timestamp with time zone | – |
| privacy_notice | text | – |
| privacy_notice_updated_at | timestamp with time zone | – |
| last_full_export_at | timestamp with time zone | – |
| last_archive_backup_at | timestamp with time zone | – |
| resturlaub_bis | text | – |
daily_car_inventory
Spalten der Tabelle daily_car_inventory
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| employee_id | uuid | employees.id |
| tour_date | date | – |
| items | text[] | – |
| packed_confirmed | boolean | – |
| packed_at | timestamp without time zone | – |
daily_reports
Spalten der Tabelle daily_reports
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| employee_id | uuid | employees.id |
| report_date | date | – |
| area | text | – |
| work_start | time without time zone | – |
| work_end | time without time zone | – |
| interruption | text | – |
| objects_worked | text[] | – |
| works_done | text[] | – |
| incidents | text | – |
| went_well | text | – |
| improvements | text | – |
| missing_material | text | – |
| open_points | text | – |
| completion | text | – |
| created_at | timestamp with time zone | – |
defect_reports
Spalten der Tabelle defect_reports
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| object_id | uuid | objects.id |
| employee_id | uuid | employees.id |
| category | text | – |
| report_type | text | – |
| description | text | – |
| time_spent | text | – |
| fully_done | boolean | – |
| extra_effort | text | – |
| photos | text[] | – |
| status | text | – |
| special_order_id | uuid | special_orders.id |
| emailed_at | timestamp with time zone | – |
| emailed_to | text | – |
| created_at | timestamp with time zone | – |
| ticket_no | integer | – |
employee_day_swaps
Spalten der Tabelle employee_day_swaps
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| employee_id | uuid | employees.id |
| date_off | date | – |
| date_on | date | – |
| note | text | – |
| created_at | timestamp with time zone | – |
employee_work_schedules
Spalten der Tabelle employee_work_schedules
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| employee_id | uuid | employees.id |
| valid_from | date | – |
| availability | jsonb | – |
| hours_per_day | numeric | – |
| created_at | timestamp with time zone | – |
employees
Spalten der Tabelle employees
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| name | text | – |
| phone | text | – |
| role | text | – |
| hours_per_day | numeric | – |
| employment_type | text | – |
| skills | text[] | – |
| push_subscription | jsonb | – |
| created_at | timestamp without time zone | – |
| tour_type | text | – |
| transport_mode | text | – |
| has_drivers_license | boolean | – |
| hourly_wage | numeric | – |
| is_flex_pool | boolean | – |
| availability | jsonb | – |
| has_main_job | boolean | – |
| constraints_note | text | – |
| clusters | text[] | – |
| tour_types | text[] | – |
| app_token | text | – |
| active | boolean | – |
| monthly_salary | numeric | – |
| vacation_days_per_year | numeric | – |
| vacation_carryover | numeric | – |
| exit_date | date | – |
| anonymized_at | timestamp with time zone | – |
| privacy_notice_seen_at | timestamp with time zone | – |
| session_version | integer | – |
| hire_date | date | – |
fixed_costs
Spalten der Tabelle fixed_costs
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| label | text | – |
| monthly_amount | numeric | – |
| active | boolean | – |
| sort_order | integer | – |
| created_at | timestamp with time zone | – |
object_task_completions
Spalten der Tabelle object_task_completions
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| object_task_id | uuid | object_tasks.id |
| performed_by_employee_id | uuid | employees.id |
| entered_by | text | – |
| done_at | date | – |
| created_at | timestamp with time zone | – |
object_tasks
Spalten der Tabelle object_tasks
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| object_id | uuid | objects.id |
| custom_name | text | – |
| duration_min | integer | – |
| sort_order | integer | – |
| frequency | text | – |
| materials | text[] | – |
| notes | text | – |
| last_done_at | timestamp without time zone | – |
| next_due | date | – |
| tour_type | text | tour_types.code |
| tour_template_id | uuid | tour_templates.id |
objects
Spalten der Tabelle objects
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| name | text | – |
| address | text | – |
| lat | numeric | – |
| lng | numeric | – |
| floors | integer | – |
| water_location | text | – |
| water_access_score | integer | – |
| building_type | text | – |
| build_year | integer | – |
| units | integer | – |
| has_basement | boolean | – |
| has_garden | boolean | – |
| has_parking | boolean | – |
| special_probability | text | – |
| special_count_6m | integer | – |
| notes | text | – |
| created_at | timestamp without time zone | – |
| tour_type | text | – |
| cluster | text | – |
| monthly_revenue | numeric | – |
| active_from | date | – |
| hsv | text | – |
| contact_name | text | – |
| contact_email | text | – |
| contact_phone | text | – |
| lv_pdf_path | text | – |
| waste_calendar_url | text | – |
| waste_calendar_pdf_path | text | – |
| archived_at | timestamp with time zone | – |
| active_until | date | – |
sick_reports
Spalten der Tabelle sick_reports
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| employee_id | uuid | employees.id |
| start_date | date | – |
| end_date | date | – |
| note | text | – |
| absence_id | uuid | absences.id |
| seen_at | timestamp with time zone | – |
| created_at | timestamp with time zone | – |
special_orders
Spalten der Tabelle special_orders
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| object_id | uuid | objects.id |
| description | text | – |
| required_equipment | text[] | – |
| estimated_duration_min | integer | – |
| deadline | timestamp without time zone | – |
| assigned_to | uuid | employees.id |
| status | text | – |
| ai_recommendation | jsonb | – |
| created_at | timestamp without time zone | – |
| assigned_employee_id | uuid | employees.id |
| scheduled_date | date | – |
| defect_report_id | uuid | defect_reports.id |
| completed_at | timestamp with time zone | – |
| ticket_no | integer | – |
| end_date | date | – |
| color | text | – |
stop_tasks
Spalten der Tabelle stop_tasks
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| tour_stop_id | uuid | tour_stops.id |
| object_task_id | uuid | object_tasks.id |
| status | text | – |
| completed_at | timestamp without time zone | – |
time_breaks
Spalten der Tabelle time_breaks
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| time_entry_id | uuid | time_entries.id |
| started_at | timestamp with time zone | – |
| ended_at | timestamp with time zone | – |
time_entries
Spalten der Tabelle time_entries
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| employee_id | uuid | employees.id |
| work_date | date | – |
| started_at | timestamp with time zone | – |
| ended_at | timestamp with time zone | – |
| break_minutes | integer | – |
| note | text | – |
| corrected_by | text | – |
| corrected_at | timestamp with time zone | – |
| created_at | timestamp with time zone | – |
| cancelled_at | timestamp with time zone | – |
| cancelled_by | text | – |
time_entry_changes
Spalten der Tabelle time_entry_changes
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| time_entry_id | uuid | time_entries.id |
| kind | text | – |
| actor_role | text | – |
| changed_by_owner | text | – |
| changed_by_employee_id | uuid | employees.id |
| reason_code | text | – |
| reason_text | text | – |
| old_started_at | timestamp with time zone | – |
| new_started_at | timestamp with time zone | – |
| old_ended_at | timestamp with time zone | – |
| new_ended_at | timestamp with time zone | – |
| old_break_minutes | integer | – |
| new_break_minutes | integer | – |
| old_note | text | – |
| new_note | text | – |
| changed_at | timestamp with time zone | – |
tour_stops
Spalten der Tabelle tour_stops
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| tour_id | uuid | tours.id |
| object_id | uuid | objects.id |
| stop_order | integer | – |
| status | text | – |
| estimated_duration_min | integer | – |
| actual_duration_min | integer | – |
| arrived_at | timestamp without time zone | – |
| completed_at | timestamp without time zone | – |
| notes | text | – |
| photo_urls | text[] | – |
| employee_id | uuid | employees.id |
| completed_by | uuid | employees.id |
tour_template_members
Spalten der Tabelle tour_template_members
| Spalte | Typ | Verweist auf |
| tour_template_id | uuid | tour_templates.id |
| employee_id | uuid | employees.id |
tour_templates
Spalten der Tabelle tour_templates
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| name | text | – |
| tour_type | text | tour_types.code |
| rhythm | text | – |
| days | text[] | – |
| start_time | time without time zone | – |
| team_size | integer | – |
| active | boolean | – |
| notes | text | – |
| created_at | timestamp with time zone | – |
| start_ort | text | – |
tour_type_equipment
Spalten der Tabelle tour_type_equipment
| Spalte | Typ | Verweist auf |
| tour_type | text | – |
| items | text[] | – |
tour_types
Spalten der Tabelle tour_types
| Spalte | Typ | Verweist auf |
| code | text | – |
| label | text | – |
| default_team_size | integer | – |
| color | text | – |
| active | boolean | – |
| sort_order | integer | – |
| short_code | text | – |
| planning_mode | text | – |
tours
Spalten der Tabelle tours
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| tour_date | date | – |
| employee_id | uuid | employees.id |
| status | text | – |
| route_order | jsonb | – |
| total_minutes | integer | – |
| created_at | timestamp without time zone | – |
| tour_type | text | – |
| vehicle_id | uuid | vehicles.id |
| tour_template_id | uuid | tour_templates.id |
| confirmed_at | timestamp with time zone | – |
| confirmed_by | text | – |
| tour_group_id | uuid | – |
| modified_after_confirm_at | timestamp with time zone | – |
vacation_requests
Spalten der Tabelle vacation_requests
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| employee_id | uuid | employees.id |
| start_date | date | – |
| end_date | date | – |
| half_day | boolean | – |
| note | text | – |
| status | text | – |
| decided_at | timestamp with time zone | – |
| decision_note | text | – |
| absence_id | uuid | absences.id |
| created_at | timestamp with time zone | – |
| type | text | – |
| cancelled_at | timestamp with time zone | – |
| cancelled_by | text | – |
vacation_years
Spalten der Tabelle vacation_years
| Spalte | Typ | Verweist auf |
| employee_id | uuid | employees.id |
| year | integer | – |
| entitlement | numeric | – |
| carryover | numeric | – |
| closed | boolean | – |
vehicles
Spalten der Tabelle vehicles
| Spalte | Typ | Verweist auf |
| id | uuid | – |
| name | text | – |
| license_plate | text | – |
| tour_type | text | – |
| base_equipment | text[] | – |
| default_employee_id | uuid | employees.id |
| active | boolean | – |
| created_at | timestamp without time zone | – |
| tour_types | text[] | – |
Storage-Buckets (Dateispeicher)
Speicherbereiche für Dateien
| Bucket | Art der Dateien |
| maengel-fotos | Fotos (Bilddateien) |
| objekt-dokumente | PDF-Dokumente |