I’m trying to find a way to add a default set of columns to each enntity for auditing purpose for each entity. I want to automatically generate all the column when the an entity is created.
The set of colums is required for each table in the model below:
Insert_Datm date not null,
Update_Datm date null,
Error_Flag char(1) not null,
Delete_Datm date null,
Source_Key Varchar2 (256) not null
If there’s no way to autogenerate these, is there a way cut/past all colums into the DM at one time?