search for: objtype_id

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...