talkleft

talkleft — Clustered. Stores references to where a user has posted comments. Used for comments (user left in other journals) counter on user profile page.

talkleft

Column name Type Null Default Description
userid int unsigned   0  
posttime int unsigned   0  
journalid int unsigned   0  
nodetype char(1)    
nodeid int unsigned   0  
jtalkid int unsigned   0  
publicitem enum('1','0')   1  
Key name Type Column(s)
PRIMARY PRIMARY
journalid INDEX
userid INDEX