Datenformate und Anbieterwechsel

id (char(36)), created_at (timestamp), action_type (varchar(40)), actor_kind (varchar(20)), actor_staff_id (char(36)), actor_member_id (char(36)), actor_label (varchar(160)), business_id (char(36)), description (varchar(500))

event_id (char(36)), staff_email (varchar(190)), staff_id (char(36))

id (char(36)), created_at (timestamp), updated_at (timestamp), title (varchar(160)), description (varchar(2000)), starts_at (datetime), ends_at (datetime), business_id (char(36)), created_by (varchar(190))

id (char(36)), staff_id (char(36)), business_id (char(36)), started_at (timestamp), expires_at (timestamp), ended_at (timestamp)

id (char(36)), created_at (timestamp), updated_at (timestamp), title (varchar(200)), description (varchar(2000)), status (varchar(16)), assignee_email (varchar(190)), assignee_staff_id (char(36)), due_date (date), business_id (char(36)), ticket_id (char(36)), created_by (varchar(190)), automatik_schluessel (varchar(120))

id (char(36)), pfad (varchar(200)), meldung (varchar(500)), digest (varchar(64)), business_id (char(36)), anzahl (int(11)), zuerst_am (timestamp), zuletzt_am (timestamp), erledigt_am (timestamp)

id (char(36)), business_id (char(36)), created_at (timestamp), user_id (char(36)), art (varchar(16)), status (varchar(16)), alt_tarif (varchar(16)), alt_module (varchar(255)), alt_betrag_cents (int(11)), neu_tarif (varchar(16)), neu_module (varchar(255)), neu_betrag_cents (int(11)), wirksam_ab (date), wirksam_am (datetime), nachzahlung_cents (int(11)), nachzahlung_von (date), nachzahlung_bis (date), nachzahlung_status (varchar(16)), livo_invoice_id (char(36)), bezahlt_am (datetime)

id (char(36)), created_at (timestamp), business_id (char(36)), employee_id (char(36)), kind (varchar(10)), from_date (date), to_date (date), half_start (tinyint(4)), half_end (tinyint(4)), note (varchar(300)), status (varchar(12)), requested_by (char(36)), decided_by (char(36)), decided_at (datetime), decision_note (varchar(300)), gemeldet_app (tinyint(1)), kenntnis_at (datetime), kenntnis_von (char(36)), au_arzt (tinyint(1))

business_id (char(36)), provider (varchar(16)), remote_label (varchar(190)), tax_mode (varchar(24)), verified_at (datetime), verify_error (varchar(500)), created_at (timestamp), updated_at (timestamp)

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), business_id (char(36)), provider (varchar(16)), document_id (char(36)), event (varchar(24)), state (varchar(16)), attempts (int(11)), status_code (smallint(6)), error (varchar(300)), remote_id (varchar(190)), next_try_at (datetime), delivered_at (datetime)

id (char(36)), business_id (char(36)), customer_id (char(36)), belegart (varchar(12)), rechnungsnummer (varchar(100)), rechnungsdatum (date), faellig_am (date), waehrung (char(3)), netto_cents (bigint(20)), steuer_cents (bigint(20)), brutto_cents (bigint(20)), verkaeufer (varchar(200)), kaeufer (varchar(200)), kaeufer_ust_id (varchar(20)), kaeufer_email (varchar(160)), kaeufer_referenz (varchar(100)), format (varchar(4)), profil (varchar(20)), datei_art (varchar(4)), dateiname (varchar(200)), groesse (int(11)), sha256 (char(64)), datei (longblob), positionen_json (mediumtext), import_lauf_id (char(36)), created_by (char(36)), created_at (datetime)

id (char(36)), business_id (char(36)), altforderung_id (char(36)), betrag_cents (bigint(20)), gezahlt_am (date), art (varchar(16)), bank_transaction_id (char(36)), notiz (varchar(240)), created_by (char(36)), created_at (timestamp), storniert_at (datetime), storniert_von (char(36))

id (char(36)), business_id (char(36)), customer_id (char(36)), rechnungsnummer (varchar(60)), rechnungsdatum (date), faellig_am (date), brutto_cents (bigint(20)), offen_cents (bigint(20)), mahnstufe (tinyint(4)), gemahnt_am (date), notiz (varchar(500)), quelle (varchar(20)), erledigt_at (datetime), erledigt_grund (varchar(200)), import_lauf_id (char(36)), created_at (timestamp), updated_at (timestamp(3))

id (char(36)), created_at (timestamp), updated_at (timestamp), business_id (char(36)), name (varchar(80)), hinweis (varchar(500)), position (int(11)), aktiv (tinyint(1)), budget (varchar(8)), zeitraum (varchar(8)), umfang (varchar(8)), fotos (varchar(8)), fotos_max (tinyint(4)), fragen (mediumtext), vorlage (varchar(24))

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), customer_id (char(36)), fragebogen_id (char(36)), fragebogen_name (varchar(80)), kanal (varchar(12)), quelle (varchar(40)), antworten (mediumtext), fotos (int(11)), ampel (varchar(5)), fehlend (varchar(500))

user_id (char(36)), created_at (timestamp), updated_at (timestamp), helligkeit (varchar(10)), dichte (varchar(10)), schrift (varchar(12)), handschuh (varchar(10))

id (char(36)), created_at (timestamp), business_id (char(36)), label (varchar(80)), key_prefix (varchar(16)), scope (varchar(8)), last_used_at (timestamp), revoked (tinyint(4))

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), business_id (char(36)), appointment_id (char(36)), employee_id (char(36))

id (char(36)), created_at (timestamp), updated_at (timestamp), business_id (char(36)), project_id (char(36)), vorlage_project_id (char(36)), auftrag_je_termin (tinyint(1)), employee_id (char(36)), team_ids (varchar(800)), title (varchar(160)), location (varchar(240)), note (varchar(500)), start_tag (date), start_min (smallint(6)), dauer_min (smallint(6)), freq (varchar(12)), intervall (tinyint(4)), wochentage (varchar(20)), monats_nr (tinyint(4)), monats_wochentag (tinyint(4)), bis_tag (date), anzahl (smallint(6)), fortgeschrieben_bis (date), beendet_am (date), created_by (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), series_id (char(36)), tag (date)

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), employee_id (char(36)), title (varchar(160)), starts_at (datetime), ends_at (datetime), location (varchar(240)), note (varchar(500)), status (varchar(12)), app_status (varchar(12)), app_status_at (datetime), app_status_user_id (char(36)), kunde_info (tinyint(1)), kunde_erinnert_start (datetime), kunde_bestaetigt_start (datetime), series_id (char(36)), series_tag (date), series_abweichung (tinyint(1)), import_lauf_id (char(36)), import_ref (varchar(120)), updated_at (timestamp(3)), buchung_status (varchar(12)), buchung_leistung_id (char(36)), buchung_am (datetime), unterwegs_gemeldet_start (datetime), notdienst (tinyint(1))

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), business_id (char(36)), article_no (varchar(40)), barcode (varchar(64)), name (varchar(160)), kind (varchar(10)), unit (varchar(16)), purchase_price_cents (int(11)), sale_price_cents (int(11)), tax_rate (tinyint(4)), supplier (varchar(120)), archived (tinyint(4)), stock_min (decimal(10,2)), stock_location (varchar(60)), description (text), category (varchar(60)), from_catalog (varchar(24)), source (varchar(16)), updated_at (timestamp(3)), import_lauf_id (char(36)), sale_price_auto (tinyint(1)), image_file_id (char(36)), vk_geaendert_am (datetime), ek_geaendert_am (datetime)

business_id (char(36)), gruppe (varchar(60)), markup_bp (int(11)), updated_at (timestamp(3)), updated_by (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), customer_id (char(36)), name (varchar(160)), kind (varchar(12)), manufacturer (varchar(80)), model (varchar(80)), serial_no (varchar(60)), location (varchar(160)), installed_year (smallint(6)), note (varchar(500)), archived (tinyint(4)), import_lauf_id (char(36)), import_ref (varchar(60)), updated_at (timestamp(3))

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), employee_id (char(36)), eingereicht_von (char(36)), client_id (varchar(64)), datum (date), art (varchar(20)), betrag_cents (int(11)), beschreibung (varchar(300)), project_id (char(36)), file_id (char(36)), status (varchar(12)), entschieden_von (char(36)), entschieden_at (datetime), entscheidung_notiz (varchar(300)), lohn_monat (char(7))

id (char(36)), business_id (char(36)), art (varchar(16)), document_id (char(36)), doc_number (varchar(20)), ergebnis (varchar(16)), stufe (tinyint(3) unsigned), grund (varchar(300)), created_at (datetime)

id (char(36)), created_at (timestamp), business_id (char(36)), regel_id (char(36)), objekt_art (varchar(12)), objekt_id (char(36)), einmal_schluessel (varchar(120)), ergebnis (varchar(14)), grund (varchar(40)), hinweis (varchar(300)), erledigt_at (datetime)

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), name (varchar(120)), ereignis (varchar(30)), aktion (varchar(20)), parameter (text), aktiv (tinyint(4)), aktiv_seit (datetime), erstellt_von (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), label (varchar(80)), iban (varchar(34)), bic (varchar(11)), currency (char(3)), active (tinyint(4)), last_balance_cents (bigint(20)), last_balance_date (date), last_statement_no (varchar(20))

id (char(36)), created_at (timestamp), business_id (char(36)), transaction_id (char(36)), document_id (char(36)), payment_id (char(36)), amount_cents (bigint(20)), discount_cents (bigint(20)), kind (varchar(16)), confidence (tinyint(4)), reason (text), state (varchar(12)), confirmed_at (datetime), confirmed_by (char(36)), reverted_at (datetime), reverted_by (char(36)), revert_reason (varchar(240))

id (char(36)), created_at (timestamp), business_id (char(36)), account_id (char(36)), format (varchar(10)), version (varchar(20)), statement_no (varchar(20)), page_no (varchar(10)), opening_cents (bigint(20)), closing_cents (bigint(20)), opening_date (date), closing_date (date), balance_check (varchar(16)), balance_gap_cents (bigint(20)), file_name (varchar(160)), imported_at (datetime), tx_total (int(11)), tx_new (int(11))

id (char(36)), created_at (timestamp), business_id (char(36)), account_id (char(36)), statement_id (char(36)), dedupe_key (varchar(120)), key_source (varchar(16)), bank_ref (varchar(35)), booking_date (date), value_date (date), amount_cents (bigint(20)), direction (varchar(5)), currency (char(3)), reversal (tinyint(4)), purpose (varchar(500)), counterparty (varchar(140)), counterparty_iban (varchar(34)), end_to_end_id (varchar(35)), gvc (varchar(3)), return_reason (varchar(35)), batch_count (int(11)), status (varchar(12)), ignored_category (varchar(24)), ignored_note (varchar(200)), ignored_at (timestamp), ignored_by (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), transaction_id (char(36)), customer_id (char(36)), note (varchar(300)), created_by (char(36)), resolved_at (datetime)

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), employee_id (char(36)), tag (date), minuten (int(11)), ursache (varchar(14)), ausgleich (varchar(10)), project_id (char(36)), wetter (varchar(120)), notiz (varchar(240)), created_by (char(36))

business_id (char(36)), document_id (char(36)), art (varchar(10)), weg (varchar(10)), erst_am (datetime), zuletzt_am (datetime), anzahl (int(11))

id (char(36)), business_id (char(36)), woche_id (char(36)), tag (date), art (varchar(12)), taetigkeiten (text), minuten (int(11))

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), employee_id (char(36)), woche_ab (date), form (varchar(12)), abteilung (varchar(120)), status (varchar(12)), betrieb_text (text), betrieb_minuten (int(11)), unterweisung_text (text), unterweisung_minuten (int(11)), schule_text (text), schule_minuten (int(11)), eingereicht_at (datetime), eingereicht_von (char(36)), abgezeichnet_at (datetime), abgezeichnet_von (char(36)), abgezeichnet_name (varchar(160)), rueckmeldung (varchar(1000))

id (char(36)), created_at (timestamp), updated_at (timestamp), business_id (char(36)), customer_id (char(36)), project_id (char(36)), sterne (tinyint(4)), text (varchar(2000)), name_anzeige (varchar(60)), veroeffentlichen (tinyint(1)), einwilligung_am (datetime), widerrufen_am (datetime), status (varchar(12)), moderiert_am (datetime), moderiert_von (char(36)), antwort (varchar(1000)), antwort_am (datetime), weg (varchar(8))

id (char(36)), business_id (char(36)), name (varchar(120)), beschreibung (varchar(500)), dauer_min (smallint(5) unsigned), festpreis_cents (int(10) unsigned), aktiv (tinyint(1)), sortierung (smallint(6)), created_at (timestamp), updated_at (timestamp(3))

id (char(36)), created_at (timestamp), business_id (char(36)), author_email (varchar(160)), ergebnis (enum('notiz','erreicht','nicht_erreicht','termin','kein_interesse')), body (text)

id (char(36)), created_at (timestamp), user_id (char(36)), name (varchar(120)), owner_name (varchar(120)), trade_type (varchar(24)), street (varchar(160)), zip (varchar(10)), city (varchar(80)), phone (varchar(40)), email (varchar(160)), tax_number (varchar(40)), vat_id (varchar(20)), iban (varchar(40)), bic (varchar(16)), bank_name (varchar(80)), small_business (tinyint(4)), hourly_rate_cents (int(11)), doc_year (smallint(6)), quote_seq (int(11)), invoice_seq (int(11)), sheet_seq (int(11)), sheet_year (smallint(6)), quote_year (smallint(6)), invoice_year (smallint(6)), datev_consultant_no (int(11)), datev_client_no (int(11)), datev_chart (varchar(8)), datev_account_19 (varchar(8)), datev_account_7 (varchar(8)), datev_account_0 (varchar(8)), datev_account_length (tinyint(4)), datev_fiscal_year_start (date), datev_debtor_next (int(11)), order_year (smallint(6)), order_seq (int(11)), labor_cost_cents (int(11)), work_start (smallint(6)), work_end (smallint(6)), service_lead_days (smallint(6)), size (varchar(16)), setup_done_at (datetime), measure_over_qmm (bigint(20)), calc_mgk (int(11)), calc_fgk (int(11)), calc_vvgk (int(11)), calc_profit (int(11)), calc_skonto (int(11)), calc_rabatt (int(11)), calc_hours_year (int(11)), calc_productive (int(11)), cash_opening_cents (int(11)), paid_until (date), plan (varchar(16)), cancelled (tinyint(1)), unlocked_until (date), logo_file_id (char(36)), default_skonto_percent (int(11)), default_skonto_days (int(11)), default_payment_days (smallint(5) unsigned), account_holder (varchar(120)), sepa_creditor_id (varchar(35)), sepa_scharf (tinyint(4)), sepa_vorlauf_tage (tinyint(3) unsigned), rueckbelastung_gebuehr_cents (int(11)), sales_rep_id (char(36)), theme (varchar(16)), customer_number (int(10) unsigned), calc_unusual_over_pct (int(11)), paint_container_sizes_ml (varchar(120)), duplicate_check_mode (varchar(16)), phone_default_country (char(2)), plantafel_slots_shown (int(11)), pdf_logo_position (varchar(10)), pdf_footer_bank (tinyint(1)), pdf_hinweis_position (varchar(10)), berichtsversand_typ (varchar(32)), is_demo (tinyint(1)), start_module (varchar(24)), cockpit_kacheln (text), exported_at (datetime), staff_id (char(36)), form_seq (int(11)), form_year (smallint(6)), stripe_connect_account_id (varchar(255)), stripe_connect_charges_enabled (tinyint(1)), stripe_connect_payouts_enabled (tinyint(1)), stripe_connect_details_submitted (tinyint(1)), stripe_connect_updated_at (datetime), seitenleiste_reihenfolge (text), seitenleiste_ausgeblendet (text), cancelled_at (date), updated_at (timestamp(3)), p35a_ausweisen (tinyint(1)), p35a_sonstig (tinyint(1)), briefpapier_file_id (char(36)), pdf_schriftart (varchar(10)), pdf_akzentfarbe (varchar(7)), pdf_zweisprachig (tinyint(1)), pdf_zwei_designs (tinyint(1)), pdf2_logo_position (varchar(10)), pdf2_hinweis_position (varchar(10)), pdf2_footer_bank (tinyint(1)), pdf2_schriftart (varchar(10)), pdf2_akzentfarbe (varchar(7)), pdf2_zweisprachig (tinyint(1)), lifecycle_mail_test_sent_at (timestamp), lifecycle_mail_nachfrist_sent_at (timestamp), lifecycle_mail_ablauf_sent_at (timestamp), ki_ocr_freigegeben (tinyint(1)), datev_account_expense (varchar(10)), datev_account_cash (varchar(10)), datev_account_creditor (varchar(10)), push_details (varchar(10)), wartung_automatik (varchar(12)), standort_stempel (tinyint(1)), privatkunden_hinweise (tinyint(1)), angebot_gueltig_tage (smallint(5) unsigned), mahn_gebuehr_an (tinyint(1)), mahn_gebuehr_cents (int(11)), mahn_zinsen_an (tinyint(1)), basiszins_hundertstel (int(11)), basiszins_stand (date), standort_frist_monate (tinyint(3) unsigned), push_chat (varchar(10)), angebote_online_annehmen (tinyint(1)), datenschutz_url (varchar(500)), impressum_url (varchar(500)), is_internal_test (tinyint(1)), lifecycle_mail_folgemonat_fuer (date), lifecycle_mail_folgemonat_sent_at (datetime), meldekontakt_name (varchar(120)), meldekontakt_telefon (varchar(40)), meldekontakt_email (varchar(160)), termin_kunde_info (tinyint(1)), loeschung_angekuendigt_am (date), loeschung_angekuendigt_fuer (date), loeschung_basis (date), confirm_year (smallint(6)), confirm_seq (int(11)), credit_year (smallint(6)), credit_seq (int(11)), nachfass_mail_tage (smallint(5) unsigned), mahnlauf_an (tinyint(1)), mahnlauf_bis_stufe (tinyint(3) unsigned), mahnlauf_am (date), datev_eingang_modus (varchar(12)), datev_kreditoren (varchar(12)), datev_creditor_next (int(11)), lodas_berater_no (int(11)), lodas_mandant_no (int(11)), taetigkeiten (varchar(2000)), material_markup_bp (int(11)), praemie_bis (date), ki_angebot_freigegeben (tinyint(1)), ki_bericht_freigegeben (tinyint(1)), buchung_aktiv (tinyint(1)), buchung_kennung (varchar(60)), buchung_direkt (tinyint(1)), buchung_vorlauf_std (smallint(5) unsigned), buchung_puffer_min (smallint(5) unsigned), buchung_horizont_tage (smallint(5) unsigned), buchung_raster_min (smallint(5) unsigned), buchung_plz (varchar(600)), buchung_zeiten (text), buchung_mitarbeiter (text), buchung_hinweis (varchar(500)), buchung_max_offen (smallint(5) unsigned), unterwegs_mail (tinyint(1)), bewertung_aktiv (tinyint(1)), bewertung_link (varchar(500)), bewertung_ausloeser (varchar(12)), ki_langtext_freigegeben (tinyint(1)), ki_fragen_freigegeben (tinyint(1)), ki_lv_freigegeben (tinyint(1)), zwei_faktor_pflicht (varchar(10)), nachtrag_year (smallint(6)), nachtrag_seq (int(11)), wiedervorlage_geoeffnet_tage (tinyint(4)), preis_veraltet_monate (tinyint(4)), anfrage_aktiv (tinyint(1)), anfrage_pausiert (tinyint(1)), anfrage_pause_bis (date), anfrage_pause_text (varchar(500)), anfrage_farbe (char(7)), anfrage_farbe_hintergrund (char(7)), anfrage_hinweis (varchar(1000)), profil_aktiv (tinyint(1)), profil_text (varchar(1000)), bewertung_ziel (varchar(8)), handwerkskarte_datei_id (char(36)), handwerkskarte_am (datetime), handwerkskarte_zeigen (tinyint(1)), geofence_modus (varchar(12)), bau_zweig (varchar(12)), ki_zugang_an (tinyint(4)), morgen_ueberblick_an (tinyint(4))

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), business_id (char(36)), kalender_id (char(36)), appointment_id (char(36)), href (varchar(600)), etag (varchar(200)), geschrieben_am (datetime)

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), business_id (char(36)), entry_date (date), kind (varchar(10)), amount_cents (int(11)), purpose (varchar(200)), receipt_no (varchar(40)), reverses_id (char(36)), sort (int(11)), project_id (char(36))

id (char(36)), business_id (char(36)), changed_at (datetime(6)), changed_by_user_id (char(36)), changed_by_name (varchar(160)), old_cents (bigint(20)), new_cents (bigint(20)), reason (varchar(200))

id (char(36)), created_at (timestamp), business_id (char(36)), transaction_id (char(36)), document_id (char(36)), amount_cents (bigint(20)), fee_cents (int(11)), reason_code (varchar(8)), reason_text (varchar(200)), fee_passed_on (tinyint(4))

id (char(36)), created_at (timestamp), business_id (char(36)), asset_id (char(36)), inspection_id (char(36)), project_id (char(36)), sort (int(11)), number (varchar(20)), label (varchar(160)), ampere (smallint(6)), rcd (tinyint(4))

id (char(36)), created_at (timestamp), business_id (char(36)), customer_id (char(36)), user_id (char(36)), last_seen_at (timestamp)

id (char(36)), created_at (timestamp), business_id (char(36)), customer_id (char(36)), actor_label (varchar(160)), field (varchar(20)), old_value (text), new_value (text)

customer_number (int(10) unsigned), created_at (timestamp), business_id (char(36)), note (varchar(160))

id (char(36)), created_at (timestamp), business_id (char(36)), customer_id (char(36)), article_id (char(36)), price_cents (int(11)), note (varchar(300))

id (char(36)), customer_number (int(10) unsigned), created_at (timestamp), business_id (char(36)), name (varchar(120)), contact (varchar(120)), email (varchar(160)), phone (varchar(40)), street (varchar(160)), zip (varchar(10)), city (varchar(80)), notes (text), archived (tinyint(4)), app_access (tinyint(1)), debtor_no (int(11)), updated_at (timestamp(3)), is_sample (tinyint(1)), discount_percent (decimal(5,2)), anonymized_at (datetime), erechnung_versand (varchar(12)), import_lauf_id (char(36)), ust_id (varchar(20)), leitweg_id (varchar(50)), customer_type (varchar(8)), salutation (varchar(30)), first_name (varchar(80)), last_name (varchar(80)), mobile (varchar(40)), address_extra (varchar(160)), country (char(2)), iban (varchar(34)), auto_mail_widerspruch_am (datetime), register_id (varchar(60)), import_ref (varchar(60)), bewertung_einwilligung_am (datetime), bewertung_einwilligung_quelle (varchar(12)), bewertung_abgemeldet_am (datetime), bewertung_gebeten_am (datetime), rabattgruppe (varchar(60)), werbung_einwilligung_am (datetime), werbung_einwilligung_quelle (varchar(12)), werbung_hinweis_am (datetime), werbung_abgemeldet_am (datetime)

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), business_id (char(36)), supplier_id (char(36)), file_name (varchar(120)), dn_version (varchar(8)), charset (varchar(16)), count_new (int(11)), count_updated (int(11)), count_skipped (int(11))

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), title (varchar(160)), location (varchar(120)), description (text), reported_by (varchar(80)), responsible (varchar(80)), severity (varchar(8)), status (varchar(12)), due_date (date), fixed_at (date), accepted_at (date), responsible_user_id (char(36)), responsible_notified_at (timestamp)

id (char(36)), created_at (timestamp), business_id (char(36)), document_id (char(36)), expires_at (datetime), ended_at (datetime), last_seen_at (datetime)

id (char(36)), created_at (timestamp), business_id (char(36)), item_id (char(36)), sort (int(11)), description (varchar(200)), unit (varchar(16)), qty (decimal(12,3)), unit_price_cents (int(11)), waste_percent (decimal(5,2)), article_id (char(36))

id (char(36)), document_id (char(36)), sort (int(11)), kind (varchar(10)), description (varchar(300)), qty (decimal(12,3)), unit (varchar(16)), unit_price_cents (int(11)), tax_rate (tinyint(4)), gaeb_item_id (varchar(64)), gaeb_oz (varchar(40)), gaeb_qty_tbd (tinyint(4)), gaeb_long_text (mediumtext), purchase_price_cents (int(11)), discount_percent (decimal(5,2)), article_id (char(36)), row_kind (varchar(12)), bezug_item_id (char(36)), beauftragt (tinyint(1)), long_text (mediumtext), image_file_id (char(36)), zielpreis_original_cents (int(11))

id (char(36)), business_id (char(36)), name (varchar(120)), doc_type (varchar(10)), content (mediumtext), item_count (int(11)), source_document_id (char(36)), created_by (char(36)), created_at (datetime)

id (char(36)), business_id (char(36)), document_id (char(36)), label (varchar(160)), sort_order (int(11)), created_at (timestamp), selected_option_id (char(36)), selected_option_label (varchar(160)), selected_price_delta_cents (int(11)), selected_tax_rate (tinyint(4)), selected_kind (varchar(10)), selected_at (datetime)

id (char(36)), business_id (char(36)), group_id (char(36)), label (varchar(160)), price_delta_cents (int(11)), tax_rate (tinyint(4)), kind (varchar(10)), is_default (tinyint(1)), sort_order (int(11)), created_at (timestamp)

id (char(36)), business_id (char(36)), document_id (char(36)), version_no (int(11)), created_at (datetime(6)), actor_user_id (char(36)), actor_name (varchar(160)), anlass (varchar(20)), restored_from (int(11)), summary (varchar(500)), snapshot (mediumtext)

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), customer_id (char(36)), doc_type (varchar(10)), doc_number (varchar(20)), status (varchar(12)), issue_date (date), due_date (date), small_business (tinyint(4)), intro_text (text), outro_text (text), net_cents (int(11)), tax_cents (int(11)), gross_cents (int(11)), source_document_id (char(36)), service_date_from (date), service_date_to (date), buyer_reference (varchar(80)), recipient_name (varchar(120)), recipient_contact (varchar(120)), recipient_street (varchar(160)), recipient_zip (varchar(10)), recipient_city (varchar(80)), recipient_email (varchar(160)), locked_at (datetime), sent_at (datetime), cancels_document_id (char(36)), is_cancellation (tinyint(4)), paid_cents (int(11)), dunning_level (tinyint(4)), dunned_at (datetime), discount_cents (int(11)), portal_decision (varchar(12)), portal_decided_at (datetime), portal_reject_reason (varchar(20)), portal_reject_note (varchar(500)), valid_until (date), skonto_percent (int(11)), skonto_days (int(11)), invoice_kind (varchar(10)), final_for_project_id (char(36)), portal_signature_png (mediumtext), portal_signed_name (varchar(120)), updated_at (timestamp(3)), reverse_charge_13b (tinyint(1)), material_price_clause (tinyint(1)), portal_variant_total_cents (int(11)), is_sample (tinyint(1)), bauvorhaben_titel (varchar(160)), bauvorhaben_adresse (varchar(240)), privatkunden_hinweise (tinyint(1)), absender_stand (longtext), advance_deductions (mediumtext), maintenance_id (char(36)), maintenance_due (date), bauumlage_bp (int(11)), bauumlage_cents (int(11)), einbehalt_bp (int(11)), einbehalt_cents (int(11)), einbehalt_bis (date), einbehalt_frei_am (date), recipient_ust_id (varchar(20)), recipient_extra (varchar(160)), recipient_country (char(2)), recipient_register_id (varchar(60)), rechnungsserie_id (char(36)), is_prepayment (tinyint(1)), nachtrag_zu_document_id (char(36)), paket_gruppe_id (char(36)), paket_name (varchar(40)), paket_verworfen_am (datetime)

business_id (char(36)), art (varchar(30)), titel (varchar(120)), text (mediumtext), updated_at (timestamp(3)), updated_by (char(36))

id (char(36)), created_at (datetime), business_id (char(36)), customer_id (char(36)), kundennummer (int(10) unsigned), art (varchar(20)), ausgeloest_von (char(36)), ausgeloest_label (varchar(160)), ergebnis (text)

id (char(36)), business_id (char(36)), document_id (char(36)), level (tinyint(4)), dunned_on (date), open_cents (int(11)), fee_cents (int(11)), interest_enabled (tinyint(1)), customer_kind (varchar(12)), base_rate_hundredths (int(11)), interest_rate_hundredths (int(11)), interest_from (date), interest_days (int(11)), interest_cents (int(11)), sent_at (datetime), sent_to (varchar(254)), mail_log_id (char(36)), created_at (datetime)

id (char(36)), business_id (char(36)), feld_id (char(36)), customer_id (char(36)), project_id (char(36)), object_id (char(36)), ziel_id (char(36)), wert_text (varchar(2000)), wert_zahl (decimal(18,4)), wert_datum (date), import_lauf_id (char(36)), created_at (timestamp), updated_at (timestamp(3))

id (char(36)), business_id (char(36)), bereich (varchar(10)), schluessel (varchar(40)), bezeichnung (varchar(80)), typ (varchar(8)), optionen (text), pflicht (tinyint(1)), reihenfolge (int(11)), archiviert_at (datetime), import_lauf_id (char(36)), created_at (timestamp), updated_at (timestamp(3))

id (char(36)), business_id (char(36)), received_at (datetime), mailbox_id (char(36)), envelope_from (varchar(320)), mail_from (varchar(320)), subject (varchar(255)), message_id (varchar(255)), size_bytes (int(11)), attachments (int(11)), stored (int(11)), duplicates (int(11)), result (varchar(24)), error (varchar(255))

id (char(36)), business_id (char(36)), created_at (datetime), created_by (char(36)), retired_at (datetime), retired_by (char(36))

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), business_id (char(36)), employee_id (char(36)), cost_cents (int(11)), valid_from (date), valid_to (date), note (varchar(300))

id (char(36)), created_at (timestamp), business_id (char(36)), name (varchar(80)), role (varchar(40)), email (varchar(160)), phone (varchar(40)), billing_rate_cents (int(11)), active (tinyint(4)), weekly_minutes (int(11)), vacation_days (decimal(4,1)), carry_over_days (decimal(4,1)), updated_at (timestamp(3)), sprache (varchar(5)), personalnummer (int(11)), birth_date (date), soll_plan (varchar(60)), ausbildungsberuf (varchar(120)), ausbildung_beginn (date), berichtsheft_form (varchar(12)), bau_gewerblich (tinyint(4))

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), kind (varchar(20)), recipient_name (varchar(160)), note (varchar(300)), created_by (char(36)), expires_on (date), revoked (tinyint(4)), last_seen_at (timestamp), approved_at (datetime(3)), approved_note (varchar(500)), darf_hochladen (tinyint(4)), hochgeladen (int(11))

Dazu 2 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (datetime(3)), business_id (char(36)), fahrt_id (char(36)), feld (varchar(20)), alt (varchar(300)), neu (varchar(300)), grund (varchar(300)), von_user (char(36)), von_name (varchar(160))

id (char(36)), created_at (timestamp), business_id (char(36)), fahrzeug_id (char(36)), lfd_nr (int(11)), fahrer_user (char(36)), fahrer_employee_id (char(36)), fahrer_name (varchar(160)), art (varchar(12)), start_at (datetime), ende_at (datetime), km_start (int(11)), km_ende (int(11)), start_ort (varchar(200)), ziel (varchar(300)), zweck (varchar(300)), geschaeftspartner (varchar(200)), umweg (varchar(300)), customer_id (char(36)), project_id (char(36)), luecke_km (int(11)), luecke_grund (varchar(300)), gps_km (decimal(8,1)), gps_punkte (mediumtext), erfasst_ueber (varchar(6)), abgeschlossen_at (datetime), pruefsumme (char(64))

id (char(36)), created_at (timestamp), business_id (char(36)), fahrzeug_id (char(36)), fahrer_user (char(36)), fahrer_employee_id (char(36)), fahrer_name (varchar(160)), art (varchar(12)), start_at (datetime), km_start (int(11)), start_ort (varchar(200)), luecke_km (int(11)), luecke_grund (varchar(300)), erfasst_ueber (varchar(6))

id (char(36)), created_at (timestamp), business_id (char(36)), kind (varchar(20)), project_id (char(36)), document_id (char(36)), display_name (varchar(160)), mime (varchar(60)), ext (varchar(8)), size_bytes (int(11)), uploaded_by (char(36)), sichtbar_fuer_kunde (tinyint(1)), object_id (char(36)), room (varchar(120)), defect_id (char(36)), site_log_date (date), note (varchar(1000)), version_of (char(36)), version_no (int(11)), markup (mediumtext), asset_id (char(36)), import_lauf_id (char(36)), updated_at (timestamp(3)), extern_quelle (varchar(12)), extern_ref (char(36)), extern_name (varchar(160))

id (char(36)), created_at (timestamp), updated_at (timestamp), business_id (char(36)), template_id (char(36)), project_id (char(36)), customer_id (char(36)), entry_no (varchar(30)), filled_by (char(36)), completed_at (datetime), pdf_file_id (char(36))

id (char(36)), template_id (char(36)), sort (smallint(6)), kind (varchar(20)), label (varchar(160)), required (tinyint(1)), options (text), hint (varchar(300)), pdf_page (smallint(6)), pdf_x (smallint(6)), pdf_y (smallint(6)), pdf_w (smallint(6)), pdf_h (smallint(6)), pdf_acro_name (varchar(200))

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), name (varchar(160)), category (varchar(20)), archived_at (datetime), pdf_file_id (char(36))

id (char(36)), entry_id (char(36)), field_id (char(36)), value (mediumtext)

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), vor_id (char(36)), nach_id (char(36)), versatz_tage (smallint(6))

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), titel (varchar(160)), start_tag (date), dauer_tage (smallint(6)), sort (int(11)), fortschritt (tinyint(4)), appointment_id (char(36)), updated_at (timestamp(3))

id (char(36)), business_id (char(36)), holiday_date (date), name (varchar(80))

id (char(36)), created_at (timestamp), business_id (char(36)), employee_id (char(36)), booking_date (date), minutes (int(11)), kind (varchar(12)), note (varchar(240)), created_by (varchar(160)), storno_von (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), supplier_id (char(36)), user_id (char(36)), order_id (char(36)), status (varchar(12)), aktion (varchar(4)), expires_at (datetime), ausgang (mediumtext), received_at (datetime), zeilen (mediumtext), befunde (text), rueckgabe (varchar(40)), version (varchar(8)), taken_at (datetime), result_order_id (char(36))

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), business_id (char(36)), art (varchar(12)), dateiname (varchar(200)), anzahl (int(11)), angelegt_von (char(36)), created_at (datetime), rueckgaengig_at (datetime), rueckgaengig_von (char(36)), entfernt (int(11))

id (char(36)), created_at (timestamp), business_id (char(36)), invoice_id (char(36)), uploaded_by (char(36)), file_name (varchar(160)), mime (varchar(60)), size_bytes (int(11)), sha256 (char(64)), original (longblob), format (varchar(4)), profile_id (varchar(255)), type_code (varchar(3)), invoice_no (varchar(100)), seller_name (varchar(200)), seller_vat_id (varchar(30)), issue_date (date), gross_cents (bigint(20)), currency (char(3)), payable_cents (bigint(20)), prepaid_cents (bigint(20)), direct_debit (tinyint(1)), done_at (datetime), done_reason (varchar(20)), done_by (char(36)), source (varchar(12)), mail_from (varchar(320)), mail_subject (varchar(255)), mail_envelope_from (varchar(320)), payee_iban (varchar(34))

id (char(36)), created_at (timestamp), business_id (char(36)), supplier (varchar(160)), invoice_no (varchar(60)), invoice_date (date), due_date (date), gross_cents (int(11)), paid_cents (int(11)), project_id (char(36)), note (varchar(500)), is_bauleistung (tinyint(1)), freistellung_bis (date), freistellung_nummer (varchar(40)), source (varchar(12)), seller_vat_id (varchar(30)), net_cents (int(11)), vat_cents (int(11)), einvoice_id (char(36)), netto_19_cents (int(11)), ust_19_cents (int(11)), netto_7_cents (int(11)), ust_7_cents (int(11)), netto_0_cents (int(11)), reverse_charge_13b (tinyint(1)), iban (varchar(34)), bic (varchar(11)), skonto_bp (int(11)), skonto_bis (date), verwendungszweck (varchar(140)), lastschrift (tinyint(1))

id (char(36)), created_at (timestamp), business_id (char(36)), invoice_id (char(36)), paid_on (date), amount_cents (int(11)), art (varchar(12)), zahllauf_id (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), inspection_id (char(36)), sort (int(11)), label (varchar(120)), value (varchar(120)), passed (tinyint(4))

id (char(36)), created_at (timestamp), business_id (char(36)), asset_id (char(36)), project_id (char(36)), device (varchar(160)), tag (varchar(60)), kind (varchar(20)), inspected_on (date), inspector (varchar(120)), step_sicht (tinyint(4)), step_messung (tinyint(4)), step_funktion (tinyint(4)), interval_months (smallint(6)), note (text), closed_at (datetime), updated_at (timestamp(3)), inspector_signature_png (mediumtext), inspector_signed_at (datetime), customer_signature_png (mediumtext), customer_signed_by (varchar(120)), customer_signed_at (datetime), closed_circuits (longtext), inspector_signed_account (varchar(160))

id (char(36)), created_at (timestamp), business_id (char(36)), email (varchar(160)), role (varchar(20)), employee_id (char(36)), expires_on (date), accepted_at (timestamp), accepted_by (char(36)), revoked (tinyint(4)), invited_by (char(36))

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), business_id (char(36)), kalender_id (char(36)), employee_id (char(36)), starts_at (datetime), ends_at (datetime), ganztag (tinyint(1))

id (char(36)), created_at (timestamp), business_id (char(36)), user_id (char(36)), employee_id (char(36)), name (varchar(80)), art (varchar(12)), url_geheim (varbinary(3000)), url_anzeige (varchar(120)), aktiv (tinyint(1)), abgeglichen_am (datetime), versucht_am (datetime), fehler (varchar(40)), bloecke (int(11)), caldav_benutzer (varchar(190)), caldav_schreiben (tinyint(1)), caldav_details (tinyint(1)), geschrieben_am (datetime), schreib_versucht_am (datetime), schreib_fehler (varchar(80)), geschrieben_anzahl (int(11))

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), business_id (char(36)), user_id (char(36)), erstellt_von (char(36)), bezeichnung (varchar(80)), last_used_at (datetime), revoked_at (datetime)

Dazu 2 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), business_id (char(36)), zugang_id (char(36)), user_id (char(36)), methode (varchar(40)), werkzeug (varchar(60)), ergebnis (varchar(12)), grund (varchar(40)), anzahl (int(11))

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), name (varchar(80)), kopplung_bis (datetime), gekoppelt_at (datetime), zuletzt_at (datetime), widerrufen_at (datetime), created_by (char(36)), aktiv_employee_id (char(36)), aktiv_bis (datetime)

id (char(36)), created_at (timestamp), updated_at (timestamp), business_id (char(36)), customer_id (char(36)), project_id (char(36)), art (varchar(12)), richtung (varchar(4)), quelle (varchar(12)), wann (datetime), user_id (char(36)), mitarbeiter_user_id (char(36)), betreff (varchar(200)), text (mediumtext), wiedervorlage_am (date), aufgabe_id (char(36)), postfach_mail_id (char(36)), datei_ids (varchar(1000))

id (char(36)), business_id (char(36)), kreditor_no (int(11)), name (varchar(160)), ust_id (varchar(30)), schluessel (varchar(160)), created_at (datetime)

id (char(36)), business_id (char(36)), document_item_id (char(36)), order_item_id (char(36)), supplier_id (char(36)), supplier_name (varchar(120)), supplier_article_no (varchar(40)), unit_price_cents (int(11)), delivery_days (smallint(6)), valid_until (date), note (varchar(300)), chosen_at (datetime), created_by (char(36)), created_at (timestamp)

id (char(36)), business_id (char(36)), kategorie (varchar(20)), lohnart (int(11)), bs_nr (smallint(6)), updated_at (datetime)

id (char(36)), created_at (timestamp), business_id (char(36)), asset_id (char(36)), anchor_date (date), interval_months (smallint(6)), last_service (date), starts_on (date), ends_on (date), price_cents (int(11)), basis (varchar(160)), active (tinyint(4)), employee_id (char(36)), order_due (date), kunde_erinnern (tinyint(4)), kunde_erinnert_due (date)

id (char(36)), created_at (timestamp), business_id (char(36)), worksheet_id (char(36)), sort (int(11)), name (varchar(120)), kind (varchar(16)), width_mm (int(11)), height_mm (int(11)), qty (int(11)), width_back_mm (int(11)), height_back_mm (int(11))

id (char(36)), created_at (timestamp), business_id (char(36)), worksheet_id (char(36)), sort (int(11)), name (varchar(120)), length_mm (int(11)), width_mm (int(11)), height_mm (int(11)), use_wall (tinyint(4)), use_ceiling (tinyint(4)), use_floor (tinyint(4))

id (char(36)), created_at (timestamp), business_id (char(36)), user_id (char(36)), role (varchar(20)), role_id (char(36)), zugangsart_override (varchar(10)), access_kind (varchar(10)), login (varchar(60)), locked_at (timestamp), status (varchar(20)), employee_id (char(36)), synthetic (tinyint(1)), last_seen_at (timestamp), calendar_revoked_at (datetime), calendar_last_used_at (datetime), standort_einwilligung (tinyint(1)), standort_einwilligung_at (datetime), chat_mitteilungen (tinyint(1)), calendar_umfang (enum('eigene','betrieb')), push_termin (tinyint(1)), push_auftrag (tinyint(1)), push_mangel (tinyint(1)), push_urlaub (tinyint(1)), push_aufgabe (tinyint(1))

Dazu 5 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), business_id (char(36)), project_id (char(36)), author_id (char(36)), author_name (varchar(120)), body (text), sichtbar_fuer_kunde (tinyint(1)), created_at (timestamp), deleted_at (timestamp), datei_id (char(36)), art (varchar(12))

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), employee_id (char(36)), satzart_id (char(36)), verkauf_cents (int(11))

mitteilung_id (char(36)), user_id (char(36)), business_id (char(36)), ausgeblendet_at (datetime)

business_id (char(36)), module (varchar(32)), created_at (timestamp), granted_by (varchar(190))

id (char(36)), created_at (timestamp), business_id (char(36)), module (varchar(24)), enabled (tinyint(4))

id (char(36)), created_at (timestamp), business_id (char(36)), user_id (char(36)), letzter_versand (date)

id (char(36)), business_id (char(36)), worksheet_id (char(36)), client_id (varchar(64)), art (varchar(16)), ergebnis (varchar(16)), stand_vorher (char(32)), stand_nachher (char(32)), parallel (tinyint(1)), was (varchar(240)), erfasst_von (varchar(120)), erfasst_am (datetime), eingegangen_am (datetime), geprueft_am (datetime), geprueft_von (varchar(120))

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), code (char(20)), bezeichnung (varchar(80)), art (varchar(12)), project_id (char(36)), aktiv (tinyint(4)), zuletzt_gelesen_at (datetime), created_by (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), employee_id (char(36)), starts_at (datetime), ends_at (datetime), note (varchar(200))

id (char(36)), created_at (timestamp), business_id (char(36)), label (varchar(120)), category (varchar(20)), surcharge_percent (int(11)), active (tinyint(4))

id (char(36)), created_at (timestamp), updated_at (timestamp), business_id (char(36)), event (varchar(40)), email_enabled (tinyint(1)), push_enabled (tinyint(1))

business_id (char(36)), art (varchar(16)), prefix (varchar(8)), with_year (tinyint(1)), digits (tinyint(3) unsigned), updated_at (timestamp(3)), updated_by (char(36))

asset_id (char(36)), business_id (char(36)), object_id (char(36)), created_at (timestamp), import_lauf_id (char(36))

project_id (char(36)), business_id (char(36)), object_id (char(36)), created_at (timestamp)

id (char(36)), created_at (timestamp), business_id (char(36)), street (varchar(160)), zip (varchar(10)), city (varchar(80)), label (varchar(160)), notes (text), archived (tinyint(4)), import_lauf_id (char(36)), import_ref (varchar(60)), updated_at (timestamp(3)), geo_lat (decimal(10,7)), geo_lng (decimal(10,7)), geo_radius_m (int(11))

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), supplier_id (char(36)), artikel_url (varchar(500)), anmeldeart (varchar(20)), client_id (varchar(190)), benutzer (varchar(190)), kundennummer (varchar(60)), aktiv (tinyint(4)), zuletzt_ok_am (datetime), letzter_fehler (varchar(200))

Dazu 3 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), order_id (char(36)), article_id (char(36)), description (varchar(200)), unit (varchar(16)), qty (decimal(10,2)), unit_price_cents (int(11)), received_qty (decimal(10,2)), supplier_article_id (char(36)), supplier_article_no (varchar(40))

id (char(36)), created_at (timestamp), business_id (char(36)), order_no (varchar(24)), supplier (varchar(120)), status (varchar(12)), ordered_at (date), delivered_at (date), note (varchar(300)), supplier_id (char(36)), project_id (char(36)), document_id (char(36)), sent_at (datetime), sent_to (varchar(190))

id (char(36)), created_at (timestamp), business_id (char(36)), document_id (char(36)), paid_on (date), amount_cents (int(11)), method (varchar(16)), note (varchar(240)), stripe_payment_intent (varchar(255)), reverses_payment_id (char(36)), created_by (char(36))

id (char(36)), created_at (timestamp), updated_at (timestamp), business_id (char(36)), name (varchar(60)), basis_status (varchar(16)), position (int(11)), farbe (varchar(16))

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), expires_on (date), revoked (tinyint(4)), last_seen_at (timestamp)

Dazu 2 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), business_id (char(36)), postfach_id (char(36)), uidvalidity (bigint(20)), uid (bigint(20)), von (varchar(254)), betreff (varchar(255)), datum (datetime), customer_id (char(36)), project_id (char(36)), kontakt_id (char(36)), zuordnung (varchar(12)), anhaenge (int(11)), anhaenge_abgelehnt (int(11))

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), updated_at (timestamp), business_id (char(36)), bezeichnung (varchar(80)), host (varchar(190)), port (int(11)), sicherheit (varchar(8)), benutzer (varchar(190)), ordner (varchar(120)), aktiv (tinyint(1)), intervall_min (int(11)), rueckblick_tage (int(11)), uidvalidity (bigint(20)), letzte_uid (bigint(20)), versucht_am (datetime), abgerufen_am (datetime), fehler (varchar(300)), fehler_seit (datetime), fehler_gemeldet_am (datetime), zugeordnet_gesamt (int(11)), ignoriert_gesamt (int(11)), eingerichtet_von (char(36))

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), business_id (char(36)), created_at (timestamp), user_id (char(36)), user_name (varchar(120)), art (varchar(12)), prozent_bp (int(11)), filter_lieferant (varchar(120)), filter_gruppe (varchar(60)), runden_auf (int(11)), anzahl (int(11)), zeilen (mediumtext), rueckgaengig_am (datetime)

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), article_id (char(36)), description (varchar(200)), unit (varchar(16)), qty_planned (decimal(10,2)), qty_used (decimal(10,2)), unit_price_cents (int(11)), tax_rate (tinyint(4)), billed (tinyint(4)), cost_price_cents (int(11)), billed_item_id (char(36)), worksheet_item_id (char(36))

id (char(36)), business_id (char(36)), project_id (char(36)), title (varchar(160)), advance_percent (int(11)), sort (int(11)), planned_date (date), done_at (datetime(3)), advance_dismissed_at (datetime(3)), created_at (timestamp)

id (char(36)), created_at (timestamp), business_id (char(36)), customer_id (char(36)), title (varchar(160)), description (text), status (varchar(16)), pipeline_stage (varchar(24)), site_address (varchar(240)), starts_on (date), ends_on (date), warranty_kind (varchar(16)), updated_at (timestamp(3)), af_mitteilung_am (date), af_frist_ende_am (date), af_textform_hinweis (tinyint(1)), af_verbraucherbauvertrag (tinyint(1)), af_widerspruch_am (date), af_widerspruch_mangel (text), is_sample (tinyint(1)), maintenance_id (char(36)), maintenance_due (date), series_id (char(36)), pipeline_stufe_id (char(36)), lead_herkunft (varchar(24)), verantwortlich_user_id (char(36)), import_lauf_id (char(36)), import_ref (varchar(60)), asset_id (char(36)), stufe_seit (datetime), stufe_seit_schluessel (varchar(48)), fertig_am (datetime), geo_lat (decimal(10,7)), geo_lng (decimal(10,7)), geo_radius_m (int(11))

id (char(36)), created_at (timestamp), updated_at (timestamp), business_id (char(36)), user_id (char(36)), platform (varchar(10)), endpoint (varchar(1024)), geraet (varchar(120)), last_ok_at (timestamp), last_error (varchar(300)), failures (int(11))

Dazu 4 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), business_id (char(36)), geraet_id (char(36)), platform (varchar(10)), termin_id (char(36)), ereignis (varchar(40)), payload (text), state (varchar(30)), attempts (int(11)), next_try_at (timestamp), reserved_until (timestamp), status_code (smallint(6)), error (varchar(300)), delivered_at (timestamp)

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), employee_id (char(36)), art (varchar(20)), bezeichnung (varchar(120)), gueltig_bis (date), erinnern_tage (int(11)), notiz (varchar(300))

document_id (char(36)), item_id (char(36)), business_id (char(36)), beauftragt (tinyint(1)), changed_at (datetime(6)), changed_by_user_id (char(36)), changed_by_name (varchar(160))

id (char(36)), business_id (char(36)), ziel (varchar(100)), customer_id (char(36)), rabattgruppe (varchar(60)), artikelgruppe (varchar(60)), prozent (decimal(5,2)), created_at (timestamp), updated_at (timestamp(3))

id (char(36)), serie_id (char(36)), business_id (char(36)), faellig_am (date), document_id (char(36)), ergebnis (varchar(16)), grund (varchar(500)), ausgeloest (varchar(12)), created_at (timestamp)

id (char(36)), serie_id (char(36)), business_id (char(36)), sort (int(11)), kind (varchar(12)), description (varchar(300)), long_text (varchar(2000)), qty (decimal(12,3)), unit (varchar(20)), unit_price_cents (bigint(20)), tax_rate (decimal(5,2))

id (char(36)), business_id (char(36)), customer_id (char(36)), project_id (char(36)), maintenance_id (char(36)), titel (varchar(160)), intervall_monate (int(11)), naechstes_datum (date), anker_tag (tinyint(4)), ende_am (date), abrechnung (varchar(14)), modus (varchar(10)), zahlungsziel_tage (int(11)), einleitung (varchar(1000)), aktiv (tinyint(1)), created_at (timestamp), updated_at (timestamp(3)), erstellt_von_label (varchar(190))

id (char(36)), created_at (timestamp), business_id (char(36)), resource_id (char(36)), employee_id (char(36)), project_id (char(36)), ausgegeben_am (datetime), ausgegeben_von (char(36)), ausgegeben_ueber (varchar(6)), zurueck_am (datetime), zurueck_von (char(36)), zurueck_zustand (varchar(16)), notiz (varchar(300)), offen_resource_id (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), resource_id (char(36)), project_id (char(36)), appointment_id (char(36)), starts_at (datetime), ends_at (datetime), note (varchar(300))

id (char(36)), created_at (timestamp), business_id (char(36)), resource_id (char(36)), art (varchar(8)), beschreibung (varchar(500)), gemeldet_von (char(36)), gemeldet_ueber (varchar(6)), zustand_vorher (varchar(14)), erledigt_am (datetime), erledigt_von (char(36)), erledigt_notiz (varchar(300))

id (char(36)), created_at (timestamp), business_id (char(36)), resource_id (char(36)), art (varchar(16)), bezeichnung (varchar(80)), intervall_monate (smallint(6)), naechste_faellig (date), erinnern_tage (smallint(6)), aktiv (tinyint(4))

id (char(36)), created_at (timestamp), business_id (char(36)), resource_id (char(36)), pruefplan_id (char(36)), art (varchar(16)), geprueft_am (date), pruefer (varchar(120)), pruefer_user (char(36)), messgeraet (varchar(160)), schritte (text), messwerte (text), ergebnis (varchar(14)), bemerkung (varchar(1000)), naechste_faellig (date), unterschrift_png (mediumtext)

id (char(36)), created_at (timestamp), business_id (char(36)), kind (varchar(10)), name (varchar(160)), identifier (varchar(40)), state (varchar(14)), assigned_to (char(36)), due_date (date), due_label (varchar(40)), note (varchar(500)), archived (tinyint(4)), updated_at (timestamp(3)), serial_no (varchar(80)), hersteller (varchar(80)), modell (varchar(80)), kategorie (varchar(20)), lagerort (varchar(80)), angeschafft_am (date), qr_kennung (char(12))

id (char(36)), created_at (timestamp), business_id (char(36)), vorlage (varchar(20)), name (varchar(60)), name_en (varchar(60)), erklaerung (text), erklaerung_en (text), bereiche (longtext), geld_sehen (tinyint(1)), gewaehrleistung_sehen (tinyint(1)), standort_sehen (tinyint(1)), zugangsart (varchar(10)), sort_order (smallint(6))

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), name (varchar(40)), verkauf_cents (int(11)), aufschlag_prozent (decimal(6,2)), kosten_prozent (decimal(6,2)), lohnart (int(11)), aktiv (tinyint(4)), sort (int(11))

id (char(36)), created_at (timestamp), business_id (char(36)), customer_id (char(36)), mandate_ref (varchar(35)), account_holder (varchar(120)), iban (varchar(34)), bic (varchar(11)), signed_on (date), revoked_on (date), revoke_reason (varchar(200)), last_used_on (date)

id (char(36)), run_id (char(36)), business_id (char(36)), document_id (char(36)), mandate_id (char(36)), mandate_ref (varchar(35)), sequence_type (enum('FRST','RCUR')), amount_cents (bigint(20)), end_to_end_id (varchar(35))

id (char(36)), created_at (timestamp), business_id (char(36)), msg_id (varchar(35)), collection_date (date), tx_count (int(11)), total_cents (bigint(20))

id (char(36)), business_id (char(36)), serienmail_id (char(36)), customer_id (char(36)), status (varchar(16)), grund (varchar(200)), bearbeitet_am (datetime)

id (char(36)), created_at (timestamp), updated_at (timestamp), business_id (char(36)), titel (varchar(120)), betreff (varchar(200)), text (mediumtext), filter (mediumtext), rechtsgrund (varchar(12)), status (varchar(12)), stapel_id (char(36)), empfaenger (int(11)), gesendet (int(11)), fehlgeschlagen (int(11)), uebersprungen (int(11)), gestartet_am (datetime), fertig_am (datetime), erstellt_von (char(36)), gestartet_von (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), asset_id (char(36)), service_date (date), due_date (date), worker (varchar(80)), work (text), project_id (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), log_date (date), weather (varchar(12)), temp_c (tinyint(4)), crew (varchar(300)), subcontractors (varchar(300)), work (text), obstruction (text), deliveries (varchar(300)), author (varchar(80)), weather_note (varchar(200)), seq (bigint(20) unsigned)

id (char(36)), created_at (timestamp), business_id (char(36)), name (varchar(80)), active (tinyint(4))

id (char(36)), created_at (timestamp(3)), business_id (char(36)), article_id (char(36)), kind (varchar(10)), qty (decimal(10,2)), unit_price_cents (int(11)), project_id (char(36)), order_id (char(36)), project_material_id (char(36)), note (varchar(200)), serial_no (varchar(80)), batch_no (varchar(80)), location_id (char(36)), transfer_ref (char(36))

business_id (char(36)), created_at (timestamp), updated_at (timestamp), stripe_customer_id (varchar(64)), checkout_session_id (varchar(80)), checkout_zweck (varchar(16)), subscription_id (varchar(64)), subscription_item_id (varchar(64)), status (varchar(24)), cancel_at_period_end (tinyint(1)), betrag_cents (int(11)), stand_signatur (varchar(255)), erste_abbuchung_am (date), naechste_abbuchung_am (date), zahlungsart (varchar(24)), zahlungsart_letzte4 (varchar(4)), letzte_zahlung_fehlgeschlagen_am (datetime), sync_fehler (varchar(500)), sync_fehler_am (datetime), stripe_stand_zeit (bigint(20))

event_id (varchar(80)), empfangen_am (timestamp), erledigt_am (datetime), typ (varchar(64)), business_id (char(36)), livemode (tinyint(1)), stripe_invoice_id (varchar(80)), subscription_id (varchar(64)), betrag_cents (int(11)), ergebnis (varchar(24)), meldung (varchar(500)), livo_invoice_id (char(36)), versuche (int(11)), daten (text)

id (char(36)), created_at (timestamp), updated_at (timestamp), business_id (char(36)), stufe_schluessel (varchar(48)), modus (varchar(12)), betreff (varchar(200)), text (text), wv_tage (smallint(5) unsigned), wv_aufgabe (tinyint(1)), wv_mail (tinyint(1)), wv_betreff (varchar(200)), wv_text (text), geaendert_von_user_id (char(36)), wv_ab (datetime), anhaenge (varchar(400)), termin_ics (tinyint(1))

id (char(36)), created_at (datetime), business_id (char(36)), project_id (char(36)), stufe_schluessel (varchar(48)), stufe_name (varchar(60)), art (varchar(16)), zustand (varchar(16)), grund (varchar(24)), einmal_schluessel (varchar(120)), mail_log_id (char(36)), quelle (varchar(12)), ausgeloest_von_user_id (char(36)), gesendet_von_user_id (char(36)), erledigt_at (datetime), beansprucht_at (datetime)

id (char(36)), created_at (timestamp), updated_at (timestamp), business_id (char(36)), supplier_id (char(36)), supplier_article_no (varchar(40)), name (varchar(200)), unit (varchar(16)), purchase_price_cents (int(11)), price_kind (varchar(2)), discount_group (varchar(8)), product_group (varchar(8)), article_id (char(36)), long_text (mediumtext), discontinued_at (datetime), omd_abgerufen_am (datetime), omd_bild_url (varchar(500)), omd_status (smallint(6))

id (char(36)), created_at (timestamp), business_id (char(36)), supplier_id (char(36)), discount_group (varchar(32)), name (varchar(255)), rate_bp (smallint(5) unsigned), valid_from (date), valid_to (date)

id (char(36)), created_at (timestamp), business_id (char(36)), supplier_id (char(36)), group_no (varchar(32)), name (varchar(255)), main_group (varchar(32)), markup_bp (int(11))

id (char(36)), created_at (timestamp), business_id (char(36)), supplier_id (char(36)), supplier_article_id (char(36)), price_cents (int(11)), recorded_at (date)

id (char(36)), created_at (timestamp), business_id (char(36)), supplier_article_id (char(36)), from_qty (decimal(12,3)), price_cents (int(11))

id (char(36)), created_at (timestamp), business_id (char(36)), name (varchar(160)), customer_no (varchar(40)), datanorm_version (varchar(8)), ids_url_muster (varchar(500)), ids_benutzer (varchar(190)), ids_scharf (tinyint(1)), ids_zuletzt_am (datetime), archived (tinyint(4)), updated_at (timestamp(3)), markup_bp (int(11)), email (varchar(190))

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), kind (varchar(12)), client_id (char(64)), target_ref (char(36)), reason (varchar(32)), incoming_payload (longtext), previous_snapshot (longtext), captured_at (datetime), resolved_at (datetime), resolved_by (varchar(80)), resolution (varchar(16))

id (char(36)), created_at (timestamp), business_id (char(36)), client_id (char(64)), kind (varchar(12)), target_ref (char(36)), captured_at (datetime), applied_at (timestamp)

id (char(36)), created_at (timestamp), updated_at (timestamp), business_id (char(36)), document_id (char(36)), status (varchar(16)), due_date (date), automatik_schluessel (varchar(120)), art (varchar(12)), titel (varchar(200)), notiz (text), zustaendig_user_id (char(36)), erstellt_von_user_id (char(36)), project_id (char(36)), customer_id (char(36)), erinnerung_at (datetime), erinnert_at (datetime), erledigt_at (datetime), erledigt_von_user_id (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), document_id (char(36)), name (varchar(200)), phase (varchar(4)), version (varchar(8)), boq_id (varchar(80)), file_name (varchar(255)), source_xml (mediumtext), item_count (int(11))

id (char(36)), created_at (timestamp), business_id (char(36)), category (varchar(20)), title (varchar(120)), body (mediumtext), sort (int(11)), archived (tinyint(4)), gewerk (varchar(20))

id (char(36)), created_at (timestamp), business_id (char(36)), employee_id (char(36)), monat (char(7)), closed_by (varchar(160)), minutes_total (int(11)), pause_total (int(11)), entries_total (int(11))

id (char(36)), created_at (timestamp), business_id (char(36)), time_entry_id (char(36)), employee_id (char(36)), monat (char(7)), aktion (varchar(20)), actor_label (varchar(160)), grund (varchar(240)), vorher (text), nachher (text)

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), worker (varchar(80)), started_at (datetime), ended_at (datetime), minutes (int(11)), note (varchar(240)), lat (decimal(10,7)), lng (decimal(10,7)), end_lat (decimal(10,7)), end_lng (decimal(10,7)), billable (tinyint(4)), employee_id (char(36)), deleted_at (datetime), billed_item_id (char(36)), worksheet_item_id (char(36)), pause_minutes (int(11)), pausen (varchar(1000)), pause_seit (datetime), ohne_uhrzeit (tinyint(4)), taetigkeit (varchar(40)), import_lauf_id (char(36)), updated_at (timestamp(3)), geo_status (varchar(8)), geo_abstand_m (int(11)), geo_begruendung (varchar(240)), stempel_quelle (varchar(8)), satzart_id (char(36))

business_id (char(36)), created_at (timestamp), expires_at (datetime)

id (char(36)), created_at (timestamp), business_id (char(36)), unterweisung_id (char(36)), employee_id (char(36)), bestaetigt_at (datetime), unterschrift_png (mediumtext), name_bei_unterschrift (varchar(160)), weg (varchar(4))

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), gewerk (varchar(40)), art (varchar(12)), titel (varchar(160)), inhalt (text), aktiv (tinyint(4))

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), project_id (char(36)), vorlage (varchar(60)), art (varchar(12)), gewerk (varchar(40)), titel (varchar(160)), inhalt (text), jaehrlich (tinyint(4)), datum (date), unterweisender (varchar(160)), created_by (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), customer_id (char(36)), titel (varchar(160)), gueltig_bis (datetime), max_dateien (int(11)), hochgeladen (int(11)), revoked (tinyint(4)), erstellt_von (char(36)), last_used_at (datetime)

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), business_id (char(36)), created_at (datetime(6)), sprache (varchar(5)), fingerabdruck (char(64)), textstand (varchar(10)), inhalt (mediumtext)

id (char(36)), granter_user_id (char(36)), business_id (char(36)), target_member_id (char(36)), started_at (timestamp), expires_at (timestamp), ended_at (timestamp)

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), name (varchar(120)), beschreibung (varchar(1000)), preis_cent (int(11)), steuersatz (decimal(5,2)), abrechnung_monate (smallint(6)), laufzeit_monate (smallint(6)), verlaengerung (varchar(12)), verlaengerung_monate (smallint(6)), kuendigungsfrist_tage (smallint(6)), kuendigung_danach_tage (smallint(6)), rabatt_bp (smallint(6)), vorrang (tinyint(4)), leistungen (text), aktiv (tinyint(4))

id (char(36)), created_at (timestamp), updated_at (timestamp(3)), business_id (char(36)), plan_id (char(36)), customer_id (char(36)), plan_name (varchar(120)), preis_cent (int(11)), steuersatz (decimal(5,2)), abrechnung_monate (smallint(6)), laufzeit_monate (smallint(6)), verlaengerung (varchar(12)), verlaengerung_monate (smallint(6)), kuendigungsfrist_tage (smallint(6)), kuendigung_danach_tage (smallint(6)), rabatt_bp (smallint(6)), vorrang (tinyint(4)), leistungen (text), verbraucher (tinyint(4)), beginn (date), mindest_ende (date), ende_am (date), gekuendigt_am (date), kuendigung_grund (varchar(300)), rechnungsserie_id (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), webhook_id (char(36)), event (varchar(40)), payload (mediumtext), state (varchar(16)), attempts (int(11)), status_code (smallint(6)), error (varchar(300)), next_try_at (datetime), delivered_at (datetime)

id (char(36)), created_at (timestamp), business_id (char(36)), label (varchar(80)), url (varchar(500)), events (varchar(300)), active (tinyint(4))

Dazu 1 Feld(er) mit Zugangsdaten oder Schlüsseln — im Export enthalten, hier aus Sicherheitsgründen nicht einzeln aufgeführt.

id (char(36)), business_id (char(36)), created_at (timestamp), art (varchar(16)), status (varchar(16)), altanbieter (varchar(32)), notiz (varchar(1000)), user_id (char(36)), inhaber_merkmal (char(64)), entschieden_am (datetime), entschieden_von (varchar(190)), entscheid_grund (varchar(500)), praemie_von (date), praemie_bis (date)

id (char(36)), antrag_id (char(36)), business_id (char(36)), created_at (timestamp), dateiname (varchar(200)), mime (varchar(100)), groesse (int(11)), sha256 (char(64)), inhalt (mediumblob), inhalt_geloescht_am (datetime)

id (char(36)), worksheet_id (char(36)), sort (int(11)), description (varchar(300)), qty (decimal(10,2)), unit (varchar(16)), formula (varchar(120)), billed (tinyint(4)), working (text), billed_item_id (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), project_id (char(36)), sheet_no (varchar(20)), kind (varchar(20)), work_date (date), notes (text), signature_png (mediumtext), signed_by (varchar(120)), signed_at (datetime), title (varchar(160)), customer_id (char(36)), updated_at (timestamp(3)), signature_received_at (datetime), source_document_id (char(36))

id (char(36)), business_id (char(36)), created_at (timestamp), erstellt_von (char(36)), erstellt_von_label (varchar(190)), msg_id (varchar(35)), ausfuehrung_am (date), anzahl (int(11)), summe_cents (bigint(20)), skonto_cents (bigint(20)), auftraggeber_iban (varchar(34)), xml (mediumtext), status (varchar(12)), status_am (datetime), status_von_label (varchar(190))

id (char(36)), zahllauf_id (char(36)), business_id (char(36)), invoice_id (char(36)), lieferant (varchar(160)), rechnungsnummer (varchar(60)), iban (varchar(34)), bic (varchar(11)), betrag_cents (bigint(20)), skonto_cents (bigint(20)), end_to_end_id (varchar(35)), verwendungszweck (varchar(140)), aktiv (tinyint(1))

id (char(36)), created_at (timestamp), user_id (char(36)), business_id (char(36)), doc_key (varchar(40)), doc_version (varchar(200)), method (varchar(20))

id (char(36)), created_at (timestamp), import_id (char(36)), dedupe_key (varchar(120)), account_iban (varchar(34)), booking_date (date), value_date (date), amount_cents (bigint(20)), currency (char(3)), purpose (varchar(500)), counterparty (varchar(140)), counterparty_iban (varchar(34)), end_to_end_id (varchar(35)), bank_ref (varchar(35)), status (varchar(12)), business_id (char(36)), months (int(11)), invoice_id (char(36)), booked_at (datetime), booked_by (char(36)), ignore_reason (varchar(240)), ignored_at (datetime), ignored_by (char(36)), reverted_at (datetime), reverted_by (char(36)), revert_reason (varchar(240)), reverted_invoice_id (char(36))

id (char(36)), created_at (timestamp), business_id (char(36)), invoice_no (varchar(24)), invoice_year (int(11)), invoice_seq (int(11)), invoice_date (date), positions (longtext), total_cents (int(11)), vorgang_ref (varchar(64)), service_period_start (date), service_period_end (date), pdf_snapshot (mediumblob), storno_of (char(36)), storno_note (varchar(255)), paid_until_before (date), paid_until_before_set (tinyint(1)), cancelled_before (tinyint(1)), cancelled_at_before (date), zahlung_zurueck_am (datetime), zahlung_zurueck_grund (varchar(255))

id (char(36)), business_id (char(36)), created_at (timestamp), betrieb_name (varchar(255)), kundennummer (int(11)), inhaber_merkmal (char(64)), nachweise (varchar(400)), altanbieter (varchar(64)), praemie_von (date), praemie_bis (date), erste_zahlung_ab (date), bestaetigt_von (varchar(190)), stripe (varchar(16))

id (char(36)), created_at (timestamp), ticket_id (char(36)), author (varchar(16)), body (text)

id (char(36)), created_at (timestamp), updated_at (timestamp), user_id (char(36)), contact (varchar(120)), email (varchar(190)), phone (varchar(40)), subject (varchar(200)), category (varchar(32)), priority (varchar(16)), status (varchar(24)), callback (tinyint(4)), business_id (char(36))