Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: RobLewin on March 14, 2024, 10:24:25 pm

Title: FK Columns always nullable when generating DDL from LDM
Post by: RobLewin on March 14, 2024, 10:24:25 pm
The 'DDL' transform sets all columns to nullable apart from the Primary Key column. I altered the attributes template so that the mandatory attributes in my LDM get set to NotNull in the DDL. However, I have failed to find a way to make Foreign Key columns mandatory when the corresponding relationship in the LDM says it is mandatory.
In the LDM I am using Classes to represent entities. On the mandatory relationships, I have set Multiplicity to "1".
In the forum, I can see the same issue was discussed circa 2008 to 2010 but cannot see or possibly understand the responses.