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	BCP Software	Assigned To	BCP Software
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

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

BCP Software 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	BCP Software	New Issue
2020-07-21 09:42	BCP Software	Status	new => assigned
2020-07-21 09:42	BCP Software	Assigned To	=> BCP Software
2020-08-14 16:31	BCP Software	Status	assigned => resolved
2020-08-14 16:31	BCP Software	Resolution	open => fixed
2020-08-14 16:31	BCP Software	Fixed in Version	=> 10.2.2
2020-08-14 16:31	BCP Software	Note Added: 0001719
2022-01-10 20:40	BCP Software	Note Added: 0004154
2022-01-10 20:40	BCP Software	Status	resolved => closed