There is a user control panel where users may assign colors with names (actually the colors/CLID represent very simple css classes which are already defined elsewhere)
'ColorLookup'
CLID Color
1 | Blue
2 | Green
3 | Yellow
....and so on down to ten values. These are associated with any name the user specifies. Please note that the "assigned name" doesn't necessarily have anything to do with each event further down:
'UserColor' // table in question
UserColorID?| fk_MemID | fk_ CLID | AssignedName
...which is to be used when this occurs:
'Event'
EventID - primary | fk_MemID | fk_CLID | EventDescription
...joining from the main Member table:
Member'
MemID - primary
Some basic questions I've been turning around in my own mind:
a) with these tables only being searched on by only a few or several persons - the 'UserColor' Table represnets a one to many relationship right? // also is UserColorID necessary as a primary?
b) UserColor table column values of fk_CLID and AssignedName should be each updateable.
c) I plan on using an INNER JOIN to bring up the AssignedName with Color per given event. The css will be called on the page by CLID, and AssignedName with it. On a calendar the css will be called directly by the CLID (assuming css can be named with as few of characters as: .detail .1, .detail .2, .detail .3, etc
Any suggestions appreciated.
