Rafal Krzewski wrote:
>
> Stephen Adkins wrote:
> >
> > Hi,
> >
> > >> - some db systems has restrictions on name-length of database-objects, e.g.
> > >> Informix 18 chars (lowercase) on all objects (tables, columns, views, ...)
> > >>
> > >> So here a shorter prefix instead of Turbine would do better.
> >
> > This is a great point worth considering.
> > However, it may still work. (read below)
> >
> > >Ugh. -1 on supporting databases with arbitrary restrictions like this
> > >(i.e. broken).
> >
> > These databases are not broken. They are that way because the SQL spec
> > only calls for 18 characters. Oracle only recognizes the first 18
> > characters, although it allows you to provide additional characters.
>
> We should give up on those databases too easily :)
>
> > In fact, I suggest that you make sure that all table names are unique in
> > the first 14 characters. This is because it is common to have other
> > database objects (indexes, etc.) which need to be unique in the first
> > 18 chars. Thus, a table name like TurbineUserGroupRole would often be
> > accompanied by a set of indexes named
> >
> > TurbineUserGroupRole_PK
> > TurbineUserGroupRole_AK1
> > TurbineUserGroupRole_IE2
> >
> > These will not work in Oracle because they are not unique in the first
> > 18 characters. Rather, an autogenerating tool might truncate the table
> > name to 14 characters in order to have room for the suffix like so.
> >
> > TurbineUserGro_PK
> > TurbineUserGro_AK1
> > TurbineUserGro_IE2
>
> What about even shorter notatoin, something like
>
> TurbineU_PK
> TurbineR_PK
> TurbineG_PK
> TurbineP_PK
> TurbineUGR_FK_U
> TurbineUGR_FK_G
> TurbineUGR_FK_R
> TurbineRP_FK_R
> TurbineRP_FK_P
>
> + namespace safe
> + no ambiguity
> + no truncated names
>
> Thoughts?
Most useable solution so far.
--
Daniel Rall <[EMAIL PROTECTED]>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
