Me too Voting for "MODIFIED" instead of "UPDATED". something like "LAST_MODIFIED" is good enough.
On Thu, Mar 18, 2010 at 12:28 AM, Roy Lyseng <[email protected]> wrote: > > > 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<https://launchpad.net/%7Edrizzle-discuss> >>>> Post to : [email protected] >>>> Unsubscribe : >>>> https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >> _______________________________________________ >> Mailing list: >> https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> >> Post to : [email protected] >> Unsubscribe : >> https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> >> More help : https://help.launchpad.net/ListHelp >> > > _______________________________________________ > Mailing list: > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-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
