Difference between revisions of "Database Table: reluser2"
From Dreamwidth Notes
m |
Dreamnestia (Talk | contribs) |
||
| 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. | 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. | ||
| + | = Definition = | ||
| − | |||
| − | |||
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE reluser ( | CREATE TABLE reluser ( | ||
| Line 14: | Line 13: | ||
</source> | </source> | ||
| − | =Relationships= | + | = Relationships = |
| + | |||
*Foreign key userid to [[Database Table: user|user]].userid | *Foreign key userid to [[Database Table: user|user]].userid | ||
*Foreign key targetid to [[Database Table: user|user]].userid | *Foreign key targetid to [[Database Table: user|user]].userid | ||
| Line 20: | Line 20: | ||
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]]. | ||
| − | =Location= | + | = Location = |
| − | Clustered | + | |
| + | [[Clustered database]] | ||
| + | |||
| + | [[Category: Database Tables|reluser2]] | ||
Revision as of 14:40, 1 April 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.
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
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.
