talk2

talk2 — Clustered. Stores metadata about all comments to journal entries. Indexes are all on this table.

talk2

Column name Type Null Default Description
journalid int unsigned   0 The userid of the user (such as a journal or community) in which the comment was posted.
jtalkid int unsigned   0 Each comment's unique id.
nodetype char(1)   This field defines what type of thing in comment is in reply to. The value can be "L" = log item (journal entry), "T" = todo item.
nodeid int unsigned   0 The thread nodeid for the given nodetype to which this comment applies (probably the jitemid from the log2 row).
parenttalkid int unsigned   0 talkid of parent comment that this comment is in reply to within a comment thread. 0 if it is a top-level comment.
posterid int unsigned   0 The user userid of the person that posted the comment.
datepost datetime   0000-00-00 00:00:00  
state char(1) YES A Comment state identifier: (A)ctive, (D)eleted, (S)creened, (F)rozen, etc.
Key name Type Column(s)
PRIMARY PRIMARY
journalid INDEX
nodetype INDEX
posterid INDEX