github_code_scanning_alerts

Table for storing GitHub Code Scanning alert data.

number number: The code scanning number for the repository.
repository_id Foreign key: ID of the repository associated with the alert.
state string: State of the alert (e.g., open, fixed).
source_url string: URL for more details about the alert.
fixed_at date: Timestamp when the alert was fixed.
rule_id Foreign key: ID of the rule that triggered the alert. May be empty or null when the scanning tool does not provide an ID.
most_recent_instance_ref string: Reference to the most recent instance of the alert.
dismissed_at date: Timestamp when the alert was dismissed.
dismissed_by_login string: GitHub login of the user who dismissed the alert.
dismissed_reason string: Reason the alert was dismissed.
dismissed_comment string: Comment provided when the alert was dismissed.
created_at date: Timestamp when the alert was created.
severity string: Impact level of an issue in GitHub code scanning alerts (Error, Warning, Note, or None). May be null when GitHub does not provide a severity.
security_severity_level string: Shows how risky a code vulnerability is (Critical, High, Medium, or Low).
tool string: The name of a code scanning tool.
deleted_at date: Timestamp when the alert was deleted in GitHub.