Difference between revisions of "Database Table: interests"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) m (Robot: Changing Category:Database Tables) |
|||
| Line 1: | Line 1: | ||
| − | This table stores information about interests. For associations to users, see [[Database Table: userinterests|userinterests]] | + | {{#set:name=acctcode|table type=global}} |
| + | [[Description::This table stores information about interests.]] For associations to users, see [[Database Table: userinterests|userinterests]] | ||
= Definition = | = Definition = | ||
| Line 12: | Line 13: | ||
) | ) | ||
</source> | </source> | ||
| − | + | {{Database Table Footer}} | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
Revision as of 23:43, 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
