Toad Data Modler changes the Child table's Data Type to match to the Parent Table's data types in a foregin key relationship. For example if pat_id is varchar2(12) in a table finsum.patient and a child table has pat_id as varchar2(18), in order for the relationship to be created the child table's column changes to 12 in length. This is great for an ideal situation. But we have tables that are coming from internal/external sources that have different data lengths than the tables that we already have in system. We want to keep the source data types "as is" so they match to source system. But at the same time on our models we would like to have an exception on the relationships. It would be nice if Toad doesn't change the data types in foregin key relationships where data types between Parent and Child don't match. We are hoping this feature to be added on the next release.
We have opened a service Request (SR# 2111152) in this regard.