moderation_review

{“what”:“Unique numeric identifier for this review row.”,“why”:“Enables referencing a specific review from other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:33.067684054+00:00”}

{“what”:“Timestamp of the last update to this row, in UTC.”,“why”:“Shows when the review was last modified; needed for audit and ordering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:33.141256409+00:00”}

{“what”:“Timestamp when this review was created, in UTC.”,“why”:“Records when the decision was made; used for time-based queries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:33.173738873+00:00”}

{“what”:“Current moderation status, e.g., ‘pending’, ‘approved’, ‘rejected’.”,“why”:“Determines whether the item is visible or flagged; without it the item’s state is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:33.237891611+00:00”}

{“what”:“Free-form comment from the moderator explaining the decision.”,“why”:“Provides context for the decision; without it the reason for the status is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:33.317091930+00:00”}

{“what”:“ID of the item being moderated, e.g., a post or comment.”,“why”:“Identifies which content this review applies to; without it the review is orphaned.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:33.356684052+00:00”}

{“what”:“Class name of the moderated item, e.g., ‘Post’ or ‘Comment’.”,“why”:“Disambiguates which table the item ID refers to in a polymorphic relation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:33.454420111+00:00”}

{“what”:“ID of the moderator who performed the review.”,“why”:“Attributes the decision to a specific user; needed for accountability and permissions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:33.575470112+00:00”}

{“what”:“True if this is the latest review for the same item and type.”,“why”:“Allows quick lookup of the current status without scanning all reviews; without it the active decision is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:33.687267532+00:00”}