Jay Pipes wrote:
Yep, going with Ron's suggestions, you could do:
CREATED
LAST_UPDATED
But, as Jobin mentioned, would LAST_UPDATED be construed as last time
data in the table changed or last time the DDL or the table changed?
Do as we did once: Use UPDATED for data and MODIFIED for metadata.
Just make it consistently throughout.
Likewise, we used INSERTED for data and CREATED for metadata.
Thanks,
Roy
-jay
p.s. UUID or ID is also fine with me...
On Wed, Mar 17, 2010 at 2:01 PM, Brian Aker <[email protected]> wrote:
Hi!
Unless Jay you disagree with Ronald, I am going to go with his suggestion.
BTW one other field I want to add is UUID. Basically I want to have this
around to have an identifier with each object that I can be 100% sure when
doing comparisons that I am dealing with the same thing.
Any thoughts on that?
Cheers,
-Brian
On Mar 17, 2010, at 9:55 AM, Ronald Bradford wrote:
Not sure of the tables in question, but the use of type identifier in
names is kinda old.
Drizzle is about all things new and shiny.
Could I recommend from a architect position, "created" and
"last_updated" are self describing.
Ronald
On Wed, Mar 17, 2010 at 3:32 AM, Jay Pipes <[email protected]> wrote:
Hi, Brian!
I really like what you're doing with the latest DDL things by adding a
create and update timestamp to tables in the data dictionary!
My quick suggestion is to make the fields a little more grammatically
consistent. Currently, you have the fields as creation_timestamp and
update_timestamp. I'd recommend either going with one or the other of
the following:
created_timestamp
updated_timestamp
-or-
create_timestamp
update_timestamp
Just for consistency's sake. :)
Other than that, really jazzed about the new DDL changes... woot.
-jay
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
