Difference between revisions of "Database Table: reluser2"

From Dreamwidth Notes
Jump to: navigation, search
m (moved Database Tables: reluser2 to Database Table: reluser2: naming convention)
Line 1: Line 1:
User-space (clustered) relationships table. Only used for 'hide this comm from my profile page'. This is in the clustered database; [[Database Table: reluser|reluser]] stores related information in the global database.
+
{{#set:name=reluser2|table type=clustered}}
 +
[[Description::User-space (clustered) relationships table. Only used for 'hide this comm from my profile page'.]]
 +
This is in the clustered database; [[Database Table: reluser|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 [[Database Table: reluser|reluser]].
  
 
= Definition =
 
= Definition =
Line 13: Line 17:
 
</source>
 
</source>
  
= Relationships =
+
{{Database Table Footer}}
 
+
*Foreign key  userid to [[Database Table: user|user]].userid
+
*Foreign key targetid to [[Database Table: user|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 [[Database Table: reluser|reluser]].
+
 
+
= Location =
+
 
+
[[Clustered database]]
+
 
+
[[Category:Database Tables Needing Conversion|reluser2]]
+

Revision as of 19:07, 2 October 2009

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