interests — Table describing the different interests listed, and the number of users listing each interest.
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| intid | int unsigned auto_increment | Unique id assigned to the interest. | ||
| interest | varchar(255) | The text of the interest. | ||
| intcount | mediumint unsigned | YES | The number of users listing the interest. |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| interest | UNIQUE |