Database Table: reluser2

From Dreamwidth Notes
Revision as of 14:02, 20 March 2009 by SlowSculpture (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Stores information about community memberships. This is in the clustered database; reluser stores related information in the global database.

Definition

CREATE TABLE reluser (
:userid     INT UNSIGNED NOT NULL,
:targetid   INT UNSIGNED NOT NULL,
:TYPE       CHAR(1) NOT NULL,
:PRIMARY KEY (userid,TYPE,targetid),
:KEY (targetid,TYPE)
)
)

Relationships

  • Foreign key userid to user.userid
  • Foreign key targetid to user.userid

Possible values of type are defined in get_reluser_id, in ljrelation.pl. Note that this does not take the same values as the char(1) type field in reluser.

Location

Clustered db