>From my architectural design perspective, "id" is a generally accepted and recommended attribute name for uniqueness of an entity, simplified to "xxx_id" for a physical relational model convenience and readability.
"uuid" for an identifier that is system unique is also clear and conveys the purpose of the value. I'm about simplicity, and that includes readability of a data model. From an external consultant that looks at different schemas on a day to day basis, it makes a DBA role easier if you don't need to ask 20 questions. Ronald 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 Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
