Roland Bouman wrote:
Hi All,
On Wed, Mar 17, 2010 at 7:58 PM, Roy Lyseng <[email protected]> wrote:
Do as we did once: Use UPDATED for data and MODIFIED for metadata.
why "MODIFIED" and not "ALTERED" ? the other identifiers seem to
follow the SQL verb, except this one....
Actually, the first relational data dictionary (including transactional DDL) we
made predates the SQL standard ;)
Roy
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
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
