Difference between revisions of "Database Table: interests"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'This table stores information about interests. For associations to users, see userinterests interests =Definition=...')
 
Line 1: Line 1:
 
This table stores information about interests. For associations to users, see [[Database Table: userinterests|userinterests]]
 
This table stores information about interests. For associations to users, see [[Database Table: userinterests|userinterests]]
  
[[Category: Database Table|interests]]
+
= Definition =
=Definition=
+
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE interests (
 
CREATE TABLE interests (
Line 13: Line 13:
 
</source>
 
</source>
  
=Relationships=
+
= Relationships =
 +
 
 +
= Location =
  
=Location=
 
 
[[Global database]]
 
[[Global database]]
 +
 +
[[Category: Database Tables|interests]]

Revision as of 16:22, 31 March 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

Location

Global database