Difference between revisions of "Database Table: interests"
From Dreamwidth Notes
m (... lol) |
|||
| Line 1: | Line 1: | ||
| − | {{#set:name= | + | {{#set:name=interests|table type=global}} |
[[Description::This table stores information about interests.]] For associations to users, see [[Database Table: userinterests|userinterests]] | [[Description::This table stores information about interests.]] For associations to users, see [[Database Table: userinterests|userinterests]] | ||
Revision as of 23:47, 4 October 2009
This table stores information about interests. For associations to users, see userinterests
Definition
CREATE TABLE interests ( intid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, interest VARCHAR(255) NOT NULL DEFAULT '', intcount mediumint(8) UNSIGNED DEFAULT NULL, PRIMARY KEY (intid), UNIQUE interest (interest) )
Relationships
Incoming
- Foreign key: intid from comminterests.intid
- Foreign key: intid from userinterests.intid
