I have been designing a new database and ran into few issues. I would greatly appreciate if somebody can answer the following questions. I am using TDM 5.2.
Consider the following structure of tables for further discussion.
It results in the following SQL code. Circles point to the corresponding question.
I understand this is the name of the constraint. Can it be to set to auto generate to include the table name? For example, ParentKey. If so, how?
The child table inherits the parent tables key column. I renamed the inherited column to be “ParentId” instead of just “Id”. Fine so far. But the child column also inherited the default setting from the parent column. I don’t want that b/c the child record will point to the parent record hence no need to have a default on the child column.
The child column is created as NULL-able. I understand it depends on the type of relationship and whether the “parent is mandatory”. It appears the non-identifying relationship defaults to false for the “parent is mandatory” setting. Can this be changed so that by default, for the non-identifying relationships, the default for “parent is mandatory” is true? If so, how?
Same as #1 above. Can this be auto generated to include the table name? If so, how?
Same as #1 and #4. Can this be auto generated to, let’s say, follow this logic - “Parent table name _ Child table name”. If so, how?