0002612: ER/Studio foreign key definition column issue

ID	Project	Category	View Status	Date Submitted	Last Update

0002612	CaseTalk Modeler	Generation (SQL, XML, etc)	public	2020-07-21 09:42	2022-01-10 20:40

Reporter	Marco Wobben	Assigned To	Marco Wobben
Priority	normal	Severity	minor	Reproducibility	have not tried
Status	closed	Resolution	fixed
Target Version	10.2.2	Fixed in Version	10.2.2

Summary	0002612: ER/Studio foreign key definition column issue
Description	ER/Studio script sometimes contains foreign key definition causing too few columns in the child table. This is due to column names which overlap where they shouldn't.
Tags	No tags attached.

CaseTalk Edition	unknown

Marco Wobben 2020-08-14 16:31 administrator ~0001719	The VB Script is extended to override the rolenames to prevent duplicates by ER/Studio (These duplicates collapse in the diagram, hiding them from view.) For Each pair in FK<..> pair.ChildAttribute.RoleName = pair.ChildAttribute.LogicalRoleName Next

Marco Wobben 2022-01-10 20:40 administrator ~0004154	Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved.

Date Modified	Username	Field	Change
2020-07-21 09:42	Marco Wobben	New Issue
2020-07-21 09:42	Marco Wobben	Status	new => assigned
2020-07-21 09:42	Marco Wobben	Assigned To	=> Marco Wobben
2020-08-14 16:31	Marco Wobben	Status	assigned => resolved
2020-08-14 16:31	Marco Wobben	Resolution	open => fixed
2020-08-14 16:31	Marco Wobben	Fixed in Version	=> 10.2.2
2020-08-14 16:31	Marco Wobben	Note Added: 0001719
2022-01-10 20:40	Marco Wobben	Note Added: 0004154
2022-01-10 20:40	Marco Wobben	Status	resolved => closed