Database Table: interests

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