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	BCP Software	Assigned To	BCP Software
Priority	normal	Severity	feature	Reproducibility	N/A
Status	assigned	Resolution	open
Target Version	13.4

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

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

BCP Software 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)

BCP Software 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	BCP Software	New Issue
2021-02-25 14:27	BCP Software	Status	new => assigned
2021-02-25 14:27	BCP Software	Assigned To	=> BCP Software
2021-02-25 14:41	BCP Software	Note Added: 0001906
2021-02-25 14:43	BCP Software	Relationship added	related to 0002876
2021-03-18 13:21	BCP Software	Note Added: 0001944
2021-03-18 13:21	BCP Software	File Added: role-cascades.png
2022-10-25 18:08	BCP Software	Note Added: 0004647
2022-10-25 18:09	BCP Software	Target Version	13.0.1 => 12.6
2022-10-27 13:19	BCP Software	Target Version	12.6 => 13.0.1
2023-10-25 11:38	BCP Software	Target Version	13.0.1 => 13.3
2024-03-13 09:37	BCP Software	Target Version	13.3 => 13.4