id = moderation's id. the metamodlog.mmid column points to moderatorlog.id
uid = moderator's uid
val = -1 for downmod, +1 for upmod
ts = timestamp of the moderation
cid = comment id the mod applies to
sid = discussion ID of the comment the mod applies to (redundant information, breaks normalization, oh well)
cuid = uid of the comment poster, look, we break normalization again! we suck!
reason = reason for the moderation (see the modreasons table)
active = 1 if the moderation is active, 0 if not. most mods are active. a mod may be inactive because it was an attempt to up/downmod a comment already at max/minimum, or because the moderator later posted to the same discussion, turning all earlier mods inactive retroactively
m2count = number of metamods on this mod
m2status = 0 if the mod is still being metamodded, 1 if the mod is all done being metamodded but hasn't been reconciled yet, or 2 if the mod is all done being metammodded and has been reconciled ("reconciling" is the process where all the metamods are tallied up and the consequences dealt out to everyone)
demystification (Score:1)
uid = moderator's uid
val = -1 for downmod, +1 for upmod
ts = timestamp of the moderation
cid = comment id the mod applies to
sid = discussion ID of the comment the mod applies to (redundant information, breaks normalization, oh well)
cuid = uid of the comment poster, look, we break normalization again! we suck!
reason = reason for the moderation (see the modreasons table)
active = 1 if the moderation is active, 0 if not. most mods are active. a mod may be inactive because it was an attempt to up/downmod a comment already at max/minimum, or because the moderator later posted to the same discussion, turning all earlier mods inactive retroactively
m2count = number of metamods on this mod
m2status = 0 if the mod is still being metamodded, 1 if the mod is all done being metamodded but hasn't been reconciled yet, or 2 if the mod is all done being metammodded and has been reconciled ("reconciling" is the process where all the metamods are tallied up and the consequences dealt out to everyone)