Identifier for associations
Pierre Blarre fa 4 mesos • actualitzat fa 4 mesos • 8
When creating an association between two entities, it is not possible to specify the future primary key of the association.
For an 0..N cardinality, the entities identifiers will be added as foreign keys into the association table, but then the physical model must be edited to add the primary key of the associative table.
This will have to be done every time the the logical model is updated.
An alternative way would be able to update a physical model from an existing logical model.
Customer support service by UserEcho
I am not sure if I understand you correctly, do you mean a logical model which looks like this?
and results with:
Thanks for the quick answer !
What I mean is for this logical model :
I would want to specify the identifier of the association 'details' to generate this physical model directly :
I have dug into the problem and found out that it is possible to make PKs.
To make the identifier for the association you need to set it as a dependent in the "association relationship" view. However, there is a bug which makes it impossible. The checkbox is untickable right now.
We will deploy the fix next week.
That's great thanks !
Also, is it possible to name the future foreign keys ?
Right now it is generating fk names like tablename_tablecolumn, but sometime I might just want the tablecolumn instead.
We are going to add a feature, which allows users to set their patterns for name creation.
I believe It's on our roadmap for this year.
Nice. I'm spreading Vertabelo around and to my students, I hope it will bring you new users, the tool is great !
I guess you can close this ticket, it's all good on my side.
We have fixed the untickable Dependant option. You should be able to set it and have Primary Key generated.
Great thanks !