re-standardize db column names for created/updated/deleted

[richjoslin]

There are columns in the database named created_on and last_created_on (and in other places, just created).

[richjoslin]

We've decided on the suffix _on.

These will be the reserved column names that are also required on all db tables:

• id
• sort_order
• created_on
• modified_on
• deleted_on

[jaybill]

We might not want to require them, but just handle them in the abstract model class if you don't expressly set them. There's plenty of cases (lookup tables, for example) where the data doesn't change or that I don't ever care when it was created.

[jaybill]

I'm going to add this to the abstract model class as described above. I'm also going to take the modified_on business out of the crudifier templates.

[jaybill]

So we use "updated_on" in a lot of places, should we just standardize on "modified_on" instead? I'm going to check for both in the model, just in case.

[jaybill]

I've added the checks for modified_on, created_on and for legacy purposes, updated_on. I did not do "deleted_on" because we need to talk about soft deletes. I'm also not sure about sort order. I'll leave this ticket open for to discuss.