Difference between revisions of "Database Table: userinterests"
From Dreamwidth Notes
Dreamnestia (Talk | contribs) |
Exor674Bot (Talk | contribs) m (Robot: Changing Category:Database Tables) |
||
| Line 22: | Line 22: | ||
[[Global database]] | [[Global database]] | ||
| − | [[Category: Database Tables|userinterests]] | + | [[Category:Database Tables Needing Conversion|userinterests]] |
Revision as of 14:06, 2 October 2009
This table associated userIDs to interests. See also commInterests
Definition
CREATE TABLE userinterests ( userid INT(10) UNSIGNED NOT NULL DEFAULT '0', intid INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (userid,intid), KEY (intid) )
Relationships
Foreign key userid to user.userid
Foreign key intid to interests.intid
