Immutable Type Table - Audit Columns

Sep 1, 2010 at 1:34 AM

In the CreateSchema.sql I noticed that tables that are marked as Immutable Type Tables in the model still get the created_by, modified_by and concurrency timestamp fields created.  Is this by design? 

IMHO I would still like to have Immutable Type tables audited using triggers.  This is because it may possibly give an indication of time and date of illegal changes that are made outside the Application directly on the tables. 

 

Coordinator
Sep 1, 2010 at 3:05 AM

The audit fields are controlled by the meta data in the model. If you do not want audit fields (and in immutable tables they are not much good I agree), then turn them off.