I have a logical ERD model with a table (“Capabilities”), which has a one-to-many relationship to itself. If I synchronize the model to a physical ERD, the generated column name for the foreign key is CapabilitiesID. Is there any way to change the name? I would like it to be ParentID or something similar, as the relationship I am modelling is parent-to-children.
You can go to Window > Project Options > Diagramming > ERD & ORM to specify the Foreign Key Pattern as {fk_name}{reference_column_name}. In this case by specify name of the logical level relationship as “Parent”, then synchronize the logical ERD to physical ERD will have the FK column name generate as ParentID.
