I’ve done reverse engineering of one of my Postgresql databases, 210 tables, 180 views, 900 functions. RE worked ok, but (it’s not a fault of TDM, is Postgresql that works this way) I wanted to clear the model from some particularities of PG that are not really SQL-standard conform. Default values, for example, with their cast (‘XX’::bpchar), or field constraints (use of ANY ARRAY instead of more classic IN, too many nested parenthesis in other circumstances).
Huge job (by the way, I’ve seen a video about customizing RE operations, that could be a better answer, but frankly actually is too much “advanced” for my knowledge of the tool).
During the process, I planned to prepare some “standard” domains, and associate fields with those domains, so that I can standardize my model, preparing for future enhancements.
But I had to stop, when I discovered that TDM, probably with the idea of protecting the model from my hands does not allow me to change fields referenced in foreign keys. I cannot associate a domain (even if data types correspond). I cannot change default value. I cannot edit constraint. I can do pratically nothing… …
Is there a way to tell TDM “let me touch these fields, at my own risk, please??”