Semantics on Model Properties

Communities ColdBox HMVC
1

This discussion came up at the office and wanted to poll the
community.

Scenario:
You have some built in columns for your DB tables (created_on and
last_modified_on). Basic datetime fields for keeping track of records
for when they were created or last updated.

Question:
Since these 2 fields are updated by the database (getDate() function),
Coldfusion ORM really has no play in dealing with these fields. Do
you include them in your model but set the generated, insert and
update attributes or do you just not include them in your model? Why?

Thanks

Erick

2

Hi Erick,

I suppose I'd say - do you have a business case for putting them in to the model?

Does the application have any need to know the dates the records were created or modified?

If so, then include them, if not, don't.

Robert