Displaying 1 result from an estimated 1 matches for "lort_id".
Did you mean:
port_id
2006 Jul 08
1
conditional table association?
...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 int
links:
id int
url string
tags:
id int
name string
What I can''t figure out is how to tell the Ev...