Task

Tabelle: task
Domain: Task · com.reybex.domain.pms
Modul: PRM

Partner-Hinweise

• Daten liegen mandantengetrennt – bei SELECT fast immer tenant_id = :mandant setzen (Spalte ggf. TenantId in älteren Tabellen).
• Schreibende SQL (INSERT/UPDATE/DELETE) nur in abgestimmten Export-/Report-Jobs (Transaktion BAS23) und nie ohne Freigabe durch reybex.
• Für API-Integrationen bevorzugt die API statt direkter DB-Zugriffe.

→ Beispiel-SQLs (BAS23)

Primärschlüssel

• id
• tenant_id

Spalten

Spalte	SQL-Typ	NULL	Default	Beschreibung
project_id	bigint	Nein	—	Fremdschlüssel → project
id	bigint auto_increment	Ja	—	Primärschlüssel (Domain: id)
main_task_id	bigint	Ja	—	Fremdschlüssel → main task
customer_employee_id	bigint	Ja	—	Fremdschlüssel → customer employee
user_id	bigint	Ja	—	Fremdschlüssel → user
title	varchar(200) charset utf8mb4	Nein	—	Domain-Feld title
description	longtext	Ja	—	Beschreibung (Domain: description)
task_type_id	bigint	Nein	—	Fremdschlüssel → task type
task_status_id	bigint	Nein	—	Fremdschlüssel → task status
priority_id	bigint	Nein	—	Fremdschlüssel → priority
budget	double	Ja	0	budget
start_date	datetime	Ja	—	start date
end_date	datetime	Ja	—	end date
finish_date	datetime	Ja	—	Domain-Feld finishDate
assign_date	datetime	Ja	—	assign date
is_milestone	smallint	Ja	0	Boolean: Milestone
need_comment	smallint	Ja	0	need comment
planned_cost_hour	double	Ja	0	planned cost hour
profit	smallint	Ja	0	Domain-Feld profit
progress	smallint	Ja	0	Domain-Feld progress
activity_type_id	bigint	Ja	—	Fremdschlüssel → activity type
report_date	datetime	Ja	—	Domain-Feld reportDate
is_group	smallint	Ja	0	Boolean: Group
ref_task_id	bigint	Ja	—	Fremdschlüssel → ref task
date_created	datetime	Ja	—	Anlagezeitpunkt
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)
support_line_id	bigint	Ja	—	Fremdschlüssel → support line
is_ticket_complete	smallint	Ja	0	Boolean: Ticket Complete
including_ticket_id	bigint	Ja	—	Fremdschlüssel → including ticket
ticket_email	varchar(100) charset utf8mb4	Ja	—	Domain-Feld ticketEmail
task_cost_id	bigint	Ja	—	Fremdschlüssel → task cost
is_delete	smallint	Ja	0	Soft-Delete (0 = aktiv, 1 = gelöscht)
tenant_id	bigint	Nein	—	Mandanten-ID (Multi-Tenant – in Abfragen fast immer filtern) (Domain: tenantId)
is_copy	smallint	Ja	0	Boolean: Copy
task_number	varchar(50) charset utf8mb4	Ja	'1'	Domain-Feld taskNumber
is_for_change_log	smallint	Ja	1	Boolean: For Change Log
unique_name	varchar(20) charset utf8mb4	Ja	—	unique name
is_customer_specific	smallint	Ja	0	Boolean: Customer Specific
customer_id	bigint	Ja	—	Fremdschlüssel → customer
sprint_id	bigint	Ja	—	Fremdschlüssel → sprint
release_notes	varchar(1000) charset utf8mb4	Ja	—	Domain-Feld releaseNotes
is_commited	smallint	Ja	—	Domain-Feld isCommited
release_date	datetime	Ja	—	release date
contact_employee_id	bigint	Ja	—	Fremdschlüssel → contact employee
release_version	varchar(30)	Ja	—	Domain-Feld releaseVersion
sales_item_id	bigint	Ja	—	Fremdschlüssel → sales item
responsible_user_id	bigint	Ja	—	Fremdschlüssel → responsible user
last_seen_date	datetime	Ja	—	Domain-Feld lastSeenDate
sort_order	int	Ja	—	sort order
is_disabled	smallint	Ja	0	Boolean: Disabled
customer_relevant_username	varchar(100)	Ja	—	Domain-Feld customerRelevantUsername
last_customer_seen_date	datetime	Ja	—	Domain-Feld lastCustomerSeenDate
is_template	smallint	Ja	0	Boolean: Template
external_creator_email	varchar(100)	Ja	—	Domain-Feld externalCreatorEmail
changelog_short_description	varchar(100)	Ja	—	Domain-Feld changelogShortDescription
changelog_long_description	text	Ja	—	Domain-Feld changelogLongDescription
first_reaction_time	datetime	Ja	—	Domain-Feld firstReactionTime
target_solve_time	datetime	Ja	—	Domain-Feld targetSolveTime
first_reaction_date	datetime	Ja	—	Domain-Feld firstReactionDate
reminder_count	int	Ja	—	reminder count
deployed_date	datetime	Ja	—	Domain-Feld deployedDate
approved_by_id	bigint	Ja	—	Fremdschlüssel → approved by
approved_date	datetime	Ja	—	Domain-Feld approvedDate
effort_based	smallint	Ja	0	effort based
sprint_calculated_date	datetime	Ja	—	sprint calculated date
risk_assessment_by_developer_id	bigint	Ja	—	Fremdschlüssel → risk assessment by developer
risk_assessment_by_responsible_id	bigint	Ja	—	Fremdschlüssel → risk assessment by responsible
partner_customer_id	bigint	Ja	—	Fremdschlüssel → partner customer
attribute_code	text	Ja	—	attribute code
attribute_json	text	Ja	—	attribute json
attribute_settings	text	Ja	—	attribute settings

Fremdschlüssel

Spalte(n)	Referenz
customer_employee_id	customer_employee (id)
task_status_id	lt_task_status (id)
priority_id	lt_task_priority (id)
task_type_id	ltt_task_type (id)
user_id	user (id)
project_id	project (id)
sprint_id	project (id)
responsible_user_id	user (id)
main_task_id	task (id)
contact_employee_id	customer_employee (id)
sales_item_id	sales_item (id)
tenant_id	company (tenant_id)