great more votes for app_* ;-)
there are only 3 tables i would change it to
app_user
app_role
app_user_role
and all problems are gone. no reserved words and only very rarely
problems with existing db's
its clear and simpel
tibi
Nathan Anderson wrote:
This all seems like familiar ground ;)
I like the prefix idea. It's always kinda bugged me that the only
table with a prefix was "app_user". It's like, "one of these things
is not like the others." ;)
In an ideal world I would like to see all the tables have a matching
prefix that is configured somewhere with a default of "app_" or
something similar. But I have no idea how hard that is to do.. :/
Nathan
Matt Raible wrote:
Yeah, but the problem with that is we get into the whole
plural-table-names debate. I chose app_user because of Oracle
originally. I thought "role" was a keyword too, but apparently not.
Matt
On 3/14/07, Sanjiv Jivan <[EMAIL PROTECTED]> wrote:
I prefer "users" as "user" is a reserved word in Oracle.
On 3/14/07, Matt Raible <[EMAIL PROTECTED]> wrote:
> Are you using Hibernate? If so, there's a NamingStrategy feature you
> can use to add your own prefixes.
>
> I'm considering renaming "app_user" to "user" to be more standard.
> Since these names can be changed, it seems to make sense, no?
>
> Matt
>
> On 3/14/07, tibi < [EMAIL PROTECTED]> wrote:
> > hi matt and others,
> >
> > i use appfuse on an existing database structure. appfuse uses 3
tables.
> > i would like to see that the naming off these tables would be
kind of
> > unique (like appfuse_rol, appfuse_user_rol)
> >
> > just an idea...
> >
> > ciao,
> >
> > tibi
> >
> >
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
[EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> --
> http://raibledesigns.com
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
[EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
