talkprop2

talkprop2 — Clustered. Stores metadata of comments, from possibilities stored in talkproplist.

talkprop2

Column name Type Null Default Description
journalid int unsigned   0 The userid of the user in which the comment is being posted.
jtalkid int unsigned   0 Unique id of a comment.
tpropid tinyint unsigned   0 Corresponds to unique tpropid in talkproplist of an individual comment property. Example: 10 (which might map to subjecticon in talkproplist.
value varchar(255) YES Value for tpropid (generally set by comment poster). Property can be a boolean (e.g., enabling don't auto-format), partial filename of specific selected subject icon, etc.
Key name Type Column(s)
PRIMARY PRIMARY