Displaying 1 result from an estimated 1 matches for "objtype_id".
2006 Jul 08
1
conditional table association?
...b to log two types of events, link events and tag
events. At first I had two tables, link_events & tag_events, but this
seemed not very DRY because the only column that was different
between them was link_id and tag_id respectively. So I made these
tables:
events:
id int
user_id int
objtype_id int (holds ''1'' or ''2'' depending on if the item is a link
or a tag)
lort_id int ("link or tag id" == "lort" this holds the id of the
item involved in the event)
objtypes: (only has two records {1 => link, 2 => tag})
id int
name i...