0002875: Relationship data lifecycle

ID	Project	Category	View Status	Date Submitted	Last Update

0002875	CaseTalk Modeler	Generation (SQL, XML, etc)	public	2021-02-25 14:27	2024-03-13 09:37

Reporter	Marco Wobben	Assigned To	Marco Wobben
Priority	normal	Severity	feature	Reproducibility	N/A
Status	assigned	Resolution	open
Target Version	14.x

Summary	0002875: Relationship data lifecycle
Description	Foreign keys in databases can come with update/delete triggers which affect the handling of data in other tables. This can be specified in UML using Composite/Aggregate relationships. It would be desirable to be able to conceptually model or annotate this handling of data.
Tags	No tags attached.

CaseTalk Edition	unknown

Marco Wobben 2021-02-25 14:41 administrator ~0001906	https://www.visual-paradigm.com/guide/uml-unified-modeling-language/uml-aggregation-vs-composition/

Marco Wobben 2021-03-18 13:21 administrator ~0001944	An example through custom attributes for Roles. role-cascades.png (54,638 bytes) role-cascades.png (54,638 bytes)

Marco Wobben 2022-10-25 18:08 administrator ~0004647	Aggregation and Composition can now be set using the OTFT Concept Type. The Composition should now add rules in artifacts to perform cascading updates/deletes.

Date Modified	Username	Field	Change
2021-02-25 14:27	Marco Wobben	New Issue
2021-02-25 14:27	Marco Wobben	Status	new => assigned
2021-02-25 14:27	Marco Wobben	Assigned To	=> Marco Wobben
2021-02-25 14:41	Marco Wobben	Note Added: 0001906
2021-02-25 14:43	Marco Wobben	Relationship added	related to 0002876
2021-03-18 13:21	Marco Wobben	Note Added: 0001944
2021-03-18 13:21	Marco Wobben	File Added: role-cascades.png
2022-10-25 18:08	Marco Wobben	Note Added: 0004647
2022-10-25 18:09	Marco Wobben	Target Version	13.0.1 => 12.6
2022-10-27 13:19	Marco Wobben	Target Version	12.6 => 13.0.1
2023-10-25 11:38	Marco Wobben	Target Version	13.0.1 => 13.3
2024-03-13 09:37	Marco Wobben	Target Version	13.3 => 14.x