Database Table: reluser2

From Dreamwidth Notes
Revision as of 15:56, 22 July 2010 by Exor674Bot (Talk | contribs)

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

This is a clustered table. User-space (clustered) relationships table. Only used for 'hide this comm from my profile page'. This is in the clustered database; reluser stores related information in the global database.

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.

Definition

CREATE TABLE reluser2 (
    userid    INT UNSIGNED NOT NULL,
    TYPE      SMALLINT UNSIGNED NOT NULL,
    targetid  INT UNSIGNED NOT NULL,
 
    PRIMARY KEY (userid,TYPE,targetid),
    INDEX (userid,targetid)
)

Relationships

Outgoing

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