perforce_reviews

Details about Perforce Swarm code reviews.

id Primary key: Unique identifier for the row.
repository_id Foreign key: ID of the Perforce repository this review belongs to.
source_id Foreign key: Swarm review ID.
user_id Foreign key: ID of the user who created the review.
title string: Title of the review.
status string: Status of the review (e.g., needsReview, needsRevision, approved, archived, rejected).
merged_by_user_id Foreign key: ID of the user who committed/merged the review.
additions number: Count of lines added in the review.
deletions number: Count of lines deleted in the review.
edits number: Count of lines edited in the review.
draft boolean: Boolean indicating whether the review is a draft.
merged_at date: Timestamp when the review was merged/committed.
closed_at date: Timestamp when the review was closed.
ready_for_review date: Timestamp when the review was marked as ready for review.
open_to_merge number: Time difference in seconds between the review being merged and being created.
open_to_first_review number: Time difference in seconds between the first review activity and the review being created.
open_to_first_approval number: Time difference in seconds between the first approval and the review being created.
merge_commit_sha string: SHA or changelist number of the merge commit.
created_at date: Timestamp when the review was created.
updated_at date: Timestamp when the review was last updated.