Can we make use of Inheritance in Physical Model?
I want to set up a table with auditing fields (creator person, person modifying, create and update timestamps, etc.). Fields that I want nearly every table in my schema to have (but not all). Instead of having to manually add the fields to each table, if I could have each table inherit from the audit table, this would happen automatically and save a huge amount of work both in creating the model and maintaining it.
Postgres (and I believe an increasing number of other databases) support this sort of inheritance. Is it possible to include this in TDM at some point, or is it possible to add it now through some mechanism? … at the time of schema design? … when the DDL is being created? … or will we have to wait until Oracle supports this.