Difference between revisions of "Database Table: reluser2"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: This table needs a description.)
m (Robot: Updating page description status.)
Line 5: Line 5:
 
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 [[Database Table: reluser|reluser]].
 
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 [[Database Table: reluser|reluser]].
  
[[Category:Database Tables Needing Description]]
+
 
 
= Definition =
 
= Definition =
  

Revision as of 12:10, 27 January 2010

"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property. 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 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

Outgoing

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