[Lxr-dev] [ lxr-Bugs-482977 ] declarations table not in 1NF

[<no...@so...>]

Bugs item #482977, was opened at 2001-11-17 19:47
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=390117&aid=482977&group_id=27350

Category: Database interface
Group: current cvs
Status: Open
Resolution: None
Priority: 5
Submitted By: Malcolm Box (mbox)
Assigned to: Malcolm Box (mbox)
Summary: declarations table not in 1NF

Initial Comment:
The new declarations table is joined to indexes via
declid and langid.  But currently declid is globally
unique, so the langid field in indexes is redundant,
though it might speed up language based searching.
If declid was made non-unique across languages it would
mean that languages could manage their own namespace
without having to get a declid assigned from the
database.  However, having it unique makes the indexes
lookup faster.

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=390117&aid=482977&group_id=27350