Difference between revisions of "Database Table: userinterests"
From Dreamwidth Notes
(Created page with 'This table associated userIDs to interests. See also commInterests userinterests =Definition= <source lang="sql"> ...') |
|||
| Line 1: | Line 1: | ||
| − | This table associated userIDs to interests. See also [[Database Table: | + | This table associated userIDs to interests. See also [[Database Table: comminterests|commInterests]] |
[[Category: Database Table|userinterests]] | [[Category: Database Table|userinterests]] | ||
Revision as of 18:18, 22 March 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
