db

type Activity struct {
	ID               uuid.UUID     `json:"id"`
	MeasureID        uuid.NullUUID `json:"measure_id"`
	Title            string        `json:"title"`
	Description      string        `json:"description"`
	ActivityType     string        `json:"activity_type"`
	Recurrence       string        `json:"recurrence"`
	Status           string        `json:"status"`
	Owner            string        `json:"owner"`
	DueDate          sql.NullTime  `json:"due_date"`
	CompletedAt      sql.NullTime  `json:"completed_at"`
	CompletedBy      string        `json:"completed_by"`
	Notes            string        `json:"notes"`
	EvidenceUrl      string        `json:"evidence_url"`
	ParentActivityID uuid.NullUUID `json:"parent_activity_id"`
	CreatedAt        time.Time     `json:"created_at"`
	UpdatedAt        time.Time     `json:"updated_at"`
	AssigneeID       uuid.NullUUID `json:"assignee_id"`
	Priority         string        `json:"priority"`
	Kind             string        `json:"kind"`
	RefNum           sql.NullInt32 `json:"ref_num"`
}

type AddAssessmentParticipantParams struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	UserID       uuid.UUID `json:"user_id"`
}

type AddAssetToAssessmentParams struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	AssetID      uuid.UUID `json:"asset_id"`
}

type AddAvvikAttachmentParams struct {
	AvvikID    uuid.UUID     `json:"avvik_id"`
	Filename   string        `json:"filename"`
	StorageKey string        `json:"storage_key"`
	UploadedBy uuid.NullUUID `json:"uploaded_by"`
}

type AddAvvikEventParams struct {
	AvvikID      uuid.UUID       `json:"avvik_id"`
	ActorID      uuid.NullUUID   `json:"actor_id"`
	ActorLabel   string          `json:"actor_label"`
	EventType    string          `json:"event_type"`
	Payload      json.RawMessage `json:"payload"`
	OccurredAt   time.Time       `json:"occurred_at"`
	ImportSource sql.NullString  `json:"import_source"`
}

type AddAvvikNotificationParams struct {
	AvvikID  uuid.UUID     `json:"avvik_id"`
	Audience string        `json:"audience"`
	SentAt   time.Time     `json:"sent_at"`
	SentBy   uuid.NullUUID `json:"sent_by"`
	Notes    string        `json:"notes"`
}

type AddMeasureLinkParams struct {
	MeasureID uuid.UUID `json:"measure_id"`
	Url       string    `json:"url"`
	Label     string    `json:"label"`
}

type AddParticipantParams struct {
	ResourceType string    `json:"resource_type"`
	ResourceID   uuid.UUID `json:"resource_id"`
	UserID       uuid.UUID `json:"user_id"`
	Role         string    `json:"role"`
}

type AppSetting struct {
	ID                int32 `json:"id"`
	ComplianceEnabled bool  `json:"compliance_enabled"`
	RiskEnabled       bool  `json:"risk_enabled"`
	ActivitiesEnabled bool  `json:"activities_enabled"`
	AssetsEnabled     bool  `json:"assets_enabled"`
	PlaygroundEnabled bool  `json:"playground_enabled"`
	AvvikEnabled      bool  `json:"avvik_enabled"`
}

type Asset struct {
	ID          uuid.UUID `json:"id"`
	Name        string    `json:"name"`
	Description string    `json:"description"`
	AssetType   string    `json:"asset_type"`
	Owner       string    `json:"owner"`
	Status      string    `json:"status"`
	Criticality string    `json:"criticality"`
	CreatedAt   time.Time `json:"created_at"`
	UpdatedAt   time.Time `json:"updated_at"`
}

type AuditLog struct {
	ID        uuid.UUID       `json:"id"`
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserID    uuid.NullUUID   `json:"user_id"`
	SourceIp  string          `json:"source_ip"`
	UserAgent string          `json:"user_agent"`
	RequestID string          `json:"request_id"`
	TraceID   string          `json:"trace_id"`
	Attrs     json.RawMessage `json:"attrs"`
}

type Avvik struct {
	ID                        uuid.UUID      `json:"id"`
	Title                     string         `json:"title"`
	Description               string         `json:"description"`
	DiscoveredAt              time.Time      `json:"discovered_at"`
	ReportedAt                sql.NullTime   `json:"reported_at"`
	ReporterName              string         `json:"reporter_name"`
	ReporterEmail             string         `json:"reporter_email"`
	AssignedTo                uuid.NullUUID  `json:"assigned_to"`
	OrgUnitID                 uuid.NullUUID  `json:"org_unit_id"`
	RiskLevel                 string         `json:"risk_level"`
	Status                    string         `json:"status"`
	PersonalData              bool           `json:"personal_data"`
	Ksi                       bool           `json:"ksi"`
	KsiInformationOwner       string         `json:"ksi_information_owner"`
	MarketSensitive           bool           `json:"market_sensitive"`
	MarketAssessmentNote      string         `json:"market_assessment_note"`
	GdprDeadlineAt            sql.NullTime   `json:"gdpr_deadline_at"`
	RealisedRiskID            uuid.NullUUID  `json:"realised_risk_id"`
	RootCause                 string         `json:"root_cause"`
	LessonsLearned            string         `json:"lessons_learned"`
	LogQaDone                 bool           `json:"log_qa_done"`
	FollowupsDelegated        bool           `json:"followups_delegated"`
	ReporterInformed          bool           `json:"reporter_informed"`
	OrgInformed               bool           `json:"org_informed"`
	MgmtInformed              bool           `json:"mgmt_informed"`
	DecisionsAnchored         bool           `json:"decisions_anchored"`
	ImplementationDeadlineSet bool           `json:"implementation_deadline_set"`
	ClosureSummary            string         `json:"closure_summary"`
	ClosedAt                  sql.NullTime   `json:"closed_at"`
	ExternalReference         string         `json:"external_reference"`
	ImportSource              sql.NullString `json:"import_source"`
	ImportedAt                sql.NullTime   `json:"imported_at"`
	CreatedAt                 time.Time      `json:"created_at"`
	UpdatedAt                 time.Time      `json:"updated_at"`
}

type AvvikActivity struct {
	AvvikID    uuid.UUID `json:"avvik_id"`
	ActivityID uuid.UUID `json:"activity_id"`
	CreatedAt  time.Time `json:"created_at"`
}

type AvvikAttachment struct {
	ID         uuid.UUID     `json:"id"`
	AvvikID    uuid.UUID     `json:"avvik_id"`
	Filename   string        `json:"filename"`
	StorageKey string        `json:"storage_key"`
	UploadedBy uuid.NullUUID `json:"uploaded_by"`
	UploadedAt time.Time     `json:"uploaded_at"`
}

type AvvikEvent struct {
	ID           uuid.UUID       `json:"id"`
	AvvikID      uuid.UUID       `json:"avvik_id"`
	ActorID      uuid.NullUUID   `json:"actor_id"`
	ActorLabel   string          `json:"actor_label"`
	EventType    string          `json:"event_type"`
	Payload      json.RawMessage `json:"payload"`
	OccurredAt   time.Time       `json:"occurred_at"`
	ImportSource sql.NullString  `json:"import_source"`
}

type AvvikMeasure struct {
	AvvikID      uuid.UUID `json:"avvik_id"`
	MeasureID    uuid.UUID `json:"measure_id"`
	Relationship string    `json:"relationship"`
	CreatedAt    time.Time `json:"created_at"`
}

type AvvikNotification struct {
	ID       uuid.UUID     `json:"id"`
	AvvikID  uuid.UUID     `json:"avvik_id"`
	Audience string        `json:"audience"`
	SentAt   time.Time     `json:"sent_at"`
	SentBy   uuid.NullUUID `json:"sent_by"`
	Notes    string        `json:"notes"`
}

type ClaimPendingUserParams struct {
	Email      string `json:"email"`
	Provider   string `json:"provider"`
	ProviderID string `json:"provider_id"`
	Name       string `json:"name"`
}

type CompleteActivityParams struct {
	ID          uuid.UUID `json:"id"`
	CompletedBy string    `json:"completed_by"`
	Notes       string    `json:"notes"`
	EvidenceUrl string    `json:"evidence_url"`
}

type CountRisksForMatrixRow struct {
	LikelihoodCurrent  sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent sql.NullInt32 `json:"consequence_current"`
	Count              int64         `json:"count"`
}

type CreateActivityParams struct {
	MeasureID    uuid.NullUUID `json:"measure_id"`
	Title        string        `json:"title"`
	Description  string        `json:"description"`
	ActivityType string        `json:"activity_type"`
	Recurrence   string        `json:"recurrence"`
	Priority     string        `json:"priority"`
	Kind         string        `json:"kind"`
	Owner        string        `json:"owner"`
	AssigneeID   uuid.NullUUID `json:"assignee_id"`
	DueDate      sql.NullTime  `json:"due_date"`
}

type CreateAssetParams struct {
	Name        string `json:"name"`
	Description string `json:"description"`
	AssetType   string `json:"asset_type"`
	Owner       string `json:"owner"`
	Status      string `json:"status"`
	Criticality string `json:"criticality"`
}

type CreateAvvikParams struct {
	Title                string         `json:"title"`
	Description          string         `json:"description"`
	DiscoveredAt         time.Time      `json:"discovered_at"`
	ReportedAt           sql.NullTime   `json:"reported_at"`
	ReporterName         string         `json:"reporter_name"`
	ReporterEmail        string         `json:"reporter_email"`
	AssignedTo           uuid.NullUUID  `json:"assigned_to"`
	OrgUnitID            uuid.NullUUID  `json:"org_unit_id"`
	RiskLevel            string         `json:"risk_level"`
	Status               string         `json:"status"`
	PersonalData         bool           `json:"personal_data"`
	Ksi                  bool           `json:"ksi"`
	KsiInformationOwner  string         `json:"ksi_information_owner"`
	MarketSensitive      bool           `json:"market_sensitive"`
	MarketAssessmentNote string         `json:"market_assessment_note"`
	GdprDeadlineAt       sql.NullTime   `json:"gdpr_deadline_at"`
	RealisedRiskID       uuid.NullUUID  `json:"realised_risk_id"`
	ImportSource         sql.NullString `json:"import_source"`
	ExternalReference    string         `json:"external_reference"`
	ImportedAt           sql.NullTime   `json:"imported_at"`
}

type CreateFrameworkParams struct {
	Name          string `json:"name"`
	ShortName     string `json:"short_name"`
	Version       string `json:"version"`
	Description   string `json:"description"`
	FrameworkType string `json:"framework_type"`
}

type CreateMeasureParams struct {
	Name        string        `json:"name"`
	Description string        `json:"description"`
	Category    string        `json:"category"`
	Owner       string        `json:"owner"`
	AssigneeID  uuid.NullUUID `json:"assignee_id"`
	Status      string        `json:"status"`
}

type CreateOrganizationParams struct {
	Name     string         `json:"name"`
	ParentID uuid.NullUUID  `json:"parent_id"`
	Key      sql.NullString `json:"key"`
}

type CreateRequirementParams struct {
	FrameworkID uuid.UUID `json:"framework_id"`
	Ref         string    `json:"ref"`
	Title       string    `json:"title"`
	Description string    `json:"description"`
	SortOrder   int32     `json:"sort_order"`
}

type CreateRiskAssessmentParams struct {
	Name                    string        `json:"name"`
	Scope                   string        `json:"scope"`
	AnalysisObject          string        `json:"analysis_object"`
	SecurityObjectives      string        `json:"security_objectives"`
	BusinessObjectives      string        `json:"business_objectives"`
	Type                    string        `json:"type"`
	RiskOwnerID             uuid.NullUUID `json:"risk_owner_id"`
	OrgID                   uuid.NullUUID `json:"org_id"`
	CreatedBy               uuid.NullUUID `json:"created_by"`
	ThreatAssessmentEnabled bool          `json:"threat_assessment_enabled"`
}

type CreateRiskParams struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	Name         string    `json:"name"`
	Description  string    `json:"description"`
}

type CreateRiskReassessmentEventParams struct {
	RiskID        uuid.UUID     `json:"risk_id"`
	MeasureID     uuid.UUID     `json:"measure_id"`
	TriggerStatus string        `json:"trigger_status"`
	TriggeredBy   uuid.NullUUID `json:"triggered_by"`
	Note          string        `json:"note"`
}

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DeclineAssessmentParams struct {
	ID             uuid.UUID `json:"id"`
	AcceptanceNote string    `json:"acceptance_note"`
}

type DeleteMeasureLinkParams struct {
	ID        uuid.UUID `json:"id"`
	MeasureID uuid.UUID `json:"measure_id"`
}

type FilterActivitiesParams struct {
	Status     interface{} `json:"status"`
	Kind       interface{} `json:"kind"`
	Owner      interface{} `json:"owner"`
	Mine       bool        `json:"mine"`
	AssigneeID uuid.UUID   `json:"assignee_id"`
	PageOffset int32       `json:"page_offset"`
	PageSize   int32       `json:"page_size"`
}

type FilterActivitiesRow struct {
	ID               uuid.UUID     `json:"id"`
	MeasureID        uuid.NullUUID `json:"measure_id"`
	Title            string        `json:"title"`
	Description      string        `json:"description"`
	ActivityType     string        `json:"activity_type"`
	Recurrence       string        `json:"recurrence"`
	Status           string        `json:"status"`
	Priority         string        `json:"priority"`
	Kind             string        `json:"kind"`
	Owner            string        `json:"owner"`
	AssigneeID       uuid.NullUUID `json:"assignee_id"`
	DueDate          sql.NullTime  `json:"due_date"`
	CompletedAt      sql.NullTime  `json:"completed_at"`
	CompletedBy      string        `json:"completed_by"`
	Notes            string        `json:"notes"`
	EvidenceUrl      string        `json:"evidence_url"`
	ParentActivityID uuid.NullUUID `json:"parent_activity_id"`
	CreatedAt        time.Time     `json:"created_at"`
	UpdatedAt        time.Time     `json:"updated_at"`
	RefNum           sql.NullInt32 `json:"ref_num"`
	MeasureName      string        `json:"measure_name"`
}

type FilterMeasuresParams struct {
	Status     interface{} `json:"status"`
	Owner      interface{} `json:"owner"`
	Mine       bool        `json:"mine"`
	AssigneeID uuid.UUID   `json:"assignee_id"`
	PageOffset int32       `json:"page_offset"`
	PageSize   int32       `json:"page_size"`
}

type Framework struct {
	ID                uuid.UUID `json:"id"`
	Name              string    `json:"name"`
	ShortName         string    `json:"short_name"`
	Version           string    `json:"version"`
	Description       string    `json:"description"`
	CreatedAt         time.Time `json:"created_at"`
	UpdatedAt         time.Time `json:"updated_at"`
	FrameworkType     string    `json:"framework_type"`
	NotRelevant       bool      `json:"not_relevant"`
	NotRelevantReason string    `json:"not_relevant_reason"`
}

type GetActivityRow struct {
	ID               uuid.UUID     `json:"id"`
	MeasureID        uuid.NullUUID `json:"measure_id"`
	Title            string        `json:"title"`
	Description      string        `json:"description"`
	ActivityType     string        `json:"activity_type"`
	Recurrence       string        `json:"recurrence"`
	Status           string        `json:"status"`
	Priority         string        `json:"priority"`
	Kind             string        `json:"kind"`
	Owner            string        `json:"owner"`
	AssigneeID       uuid.NullUUID `json:"assignee_id"`
	DueDate          sql.NullTime  `json:"due_date"`
	CompletedAt      sql.NullTime  `json:"completed_at"`
	CompletedBy      string        `json:"completed_by"`
	Notes            string        `json:"notes"`
	EvidenceUrl      string        `json:"evidence_url"`
	ParentActivityID uuid.NullUUID `json:"parent_activity_id"`
	CreatedAt        time.Time     `json:"created_at"`
	UpdatedAt        time.Time     `json:"updated_at"`
	RefNum           sql.NullInt32 `json:"ref_num"`
	MeasureName      string        `json:"measure_name"`
}

type GetDashboardStatsRow struct {
	FrameworksCount            int64 `json:"frameworks_count"`
	RequirementsCount          int64 `json:"requirements_count"`
	MeasuresCount              int64 `json:"measures_count"`
	ImplementedCount           int64 `json:"implemented_count"`
	CoveredRequirementsCount   int64 `json:"covered_requirements_count"`
	OverdueActivitiesCount     int64 `json:"overdue_activities_count"`
	ActivitiesDueThisWeekCount int64 `json:"activities_due_this_week_count"`
}

type GetRiskStatsRow struct {
	Total       int64 `json:"total"`
	RedCount    int64 `json:"red_count"`
	YellowCount int64 `json:"yellow_count"`
	GreenCount  int64 `json:"green_count"`
}

type InsertAuditLogParams struct {
	Event     string          `json:"event"`
	UserID    uuid.NullUUID   `json:"user_id"`
	SourceIp  string          `json:"source_ip"`
	UserAgent string          `json:"user_agent"`
	RequestID string          `json:"request_id"`
	TraceID   string          `json:"trace_id"`
	Attrs     json.RawMessage `json:"attrs"`
}

type IsParticipantParams struct {
	ResourceType string    `json:"resource_type"`
	ResourceID   uuid.UUID `json:"resource_id"`
	UserID       uuid.UUID `json:"user_id"`
}

type IsRiskAssessmentAccessibleParams struct {
	ID      uuid.UUID `json:"id"`
	Column2 uuid.UUID `json:"column_2"`
}

type IsRiskAssessmentParticipantParams struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	UserID       uuid.UUID `json:"user_id"`
}

type LinkAvvikActivityParams struct {
	AvvikID    uuid.UUID `json:"avvik_id"`
	ActivityID uuid.UUID `json:"activity_id"`
}

type LinkAvvikMeasureParams struct {
	AvvikID      uuid.UUID `json:"avvik_id"`
	MeasureID    uuid.UUID `json:"measure_id"`
	Relationship string    `json:"relationship"`
}

type LinkMeasureToRequirementParams struct {
	MeasureID     uuid.UUID `json:"measure_id"`
	RequirementID uuid.UUID `json:"requirement_id"`
	Note          string    `json:"note"`
}

type LinkRiskToActivityParams struct {
	RiskID     uuid.UUID `json:"risk_id"`
	ActivityID uuid.UUID `json:"activity_id"`
}

type LinkRiskToAssetParams struct {
	RiskID  uuid.UUID `json:"risk_id"`
	AssetID uuid.UUID `json:"asset_id"`
}

type LinkRiskToMeasureParams struct {
	RiskID    uuid.UUID `json:"risk_id"`
	MeasureID uuid.UUID `json:"measure_id"`
	Note      string    `json:"note"`
}

type ListActiveSessionsByUserRow struct {
	UserID       uuid.UUID `json:"user_id"`
	Name         string    `json:"name"`
	Email        string    `json:"email"`
	Role         string    `json:"role"`
	SessionCount int64     `json:"session_count"`
	ExpiresAt    time.Time `json:"expires_at"`
}

type ListActivitiesForMeasureRow struct {
	ID           uuid.UUID    `json:"id"`
	Title        string       `json:"title"`
	Status       string       `json:"status"`
	Priority     string       `json:"priority"`
	Kind         string       `json:"kind"`
	DueDate      sql.NullTime `json:"due_date"`
	ActivityType string       `json:"activity_type"`
	Recurrence   string       `json:"recurrence"`
}

type ListActivitiesForUserRow struct {
	ID          uuid.UUID    `json:"id"`
	Title       string       `json:"title"`
	Status      string       `json:"status"`
	Priority    string       `json:"priority"`
	Kind        string       `json:"kind"`
	DueDate     sql.NullTime `json:"due_date"`
	UpdatedAt   time.Time    `json:"updated_at"`
	MeasureName string       `json:"measure_name"`
}

type ListActivitiesRow struct {
	ID               uuid.UUID     `json:"id"`
	MeasureID        uuid.NullUUID `json:"measure_id"`
	Title            string        `json:"title"`
	Description      string        `json:"description"`
	ActivityType     string        `json:"activity_type"`
	Recurrence       string        `json:"recurrence"`
	Status           string        `json:"status"`
	Priority         string        `json:"priority"`
	Kind             string        `json:"kind"`
	Owner            string        `json:"owner"`
	AssigneeID       uuid.NullUUID `json:"assignee_id"`
	DueDate          sql.NullTime  `json:"due_date"`
	CompletedAt      sql.NullTime  `json:"completed_at"`
	CompletedBy      string        `json:"completed_by"`
	Notes            string        `json:"notes"`
	EvidenceUrl      string        `json:"evidence_url"`
	ParentActivityID uuid.NullUUID `json:"parent_activity_id"`
	CreatedAt        time.Time     `json:"created_at"`
	UpdatedAt        time.Time     `json:"updated_at"`
	RefNum           sql.NullInt32 `json:"ref_num"`
	MeasureName      string        `json:"measure_name"`
}

type ListAllRequirementsRow struct {
	ID                 uuid.UUID `json:"id"`
	FrameworkID        uuid.UUID `json:"framework_id"`
	Ref                string    `json:"ref"`
	Title              string    `json:"title"`
	Description        string    `json:"description"`
	SortOrder          int32     `json:"sort_order"`
	CreatedAt          time.Time `json:"created_at"`
	UpdatedAt          time.Time `json:"updated_at"`
	FrameworkName      string    `json:"framework_name"`
	FrameworkShortName string    `json:"framework_short_name"`
}

type ListAllRisksForUserRow struct {
	ID                   uuid.UUID     `json:"id"`
	AssessmentID         uuid.UUID     `json:"assessment_id"`
	Name                 string        `json:"name"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodTarget     sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget    sql.NullInt32 `json:"consequence_target"`
	RiskDecision         string        `json:"risk_decision"`
	Status               string        `json:"status"`
	CreatedAt            time.Time     `json:"created_at"`
	UpdatedAt            time.Time     `json:"updated_at"`
	Description          string        `json:"description"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
	OwnerID              uuid.NullUUID `json:"owner_id"`
	DecisionNotes        string        `json:"decision_notes"`
	RefNum               sql.NullInt32 `json:"ref_num"`
	ReviewNeeded         bool          `json:"review_needed"`
	ReviewDue            sql.NullTime  `json:"review_due"`
	AssessedAt           sql.NullTime  `json:"assessed_at"`
	AssessedBy           uuid.NullUUID `json:"assessed_by"`
	AssessmentRationale  string        `json:"assessment_rationale"`
	AssessmentName       string        `json:"assessment_name"`
	AssessmentRefNum     sql.NullInt32 `json:"assessment_ref_num"`
}

type ListAllRisksRow struct {
	ID                   uuid.UUID     `json:"id"`
	AssessmentID         uuid.UUID     `json:"assessment_id"`
	Name                 string        `json:"name"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodTarget     sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget    sql.NullInt32 `json:"consequence_target"`
	RiskDecision         string        `json:"risk_decision"`
	Status               string        `json:"status"`
	CreatedAt            time.Time     `json:"created_at"`
	UpdatedAt            time.Time     `json:"updated_at"`
	Description          string        `json:"description"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
	OwnerID              uuid.NullUUID `json:"owner_id"`
	DecisionNotes        string        `json:"decision_notes"`
	RefNum               sql.NullInt32 `json:"ref_num"`
	ReviewNeeded         bool          `json:"review_needed"`
	ReviewDue            sql.NullTime  `json:"review_due"`
	AssessedAt           sql.NullTime  `json:"assessed_at"`
	AssessedBy           uuid.NullUUID `json:"assessed_by"`
	AssessmentRationale  string        `json:"assessment_rationale"`
	AssessmentName       string        `json:"assessment_name"`
	AssessmentRefNum     sql.NullInt32 `json:"assessment_ref_num"`
}

type ListAssetsParams struct {
	Q          interface{} `json:"q"`
	Status     interface{} `json:"status"`
	PageOffset int32       `json:"page_offset"`
	PageSize   int32       `json:"page_size"`
}

type ListAuditLogAdminRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForActivityRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForAssessmentRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForAssetRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForFrameworkRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForMeasureRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForRequirementRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForRiskRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAvvikParams struct {
	Status          sql.NullString `json:"status"`
	RiskLevel       sql.NullString `json:"risk_level"`
	PersonalData    sql.NullBool   `json:"personal_data"`
	Ksi             sql.NullBool   `json:"ksi"`
	MarketSensitive sql.NullBool   `json:"market_sensitive"`
	OrgUnitID       uuid.NullUUID  `json:"org_unit_id"`
	Mine            bool           `json:"mine"`
	AssigneeID      uuid.UUID      `json:"assignee_id"`
	PageOffset      int32          `json:"page_offset"`
	PageSize        int32          `json:"page_size"`
}

type ListMeasureFrameworkLinksRow struct {
	MeasureID          uuid.UUID `json:"measure_id"`
	FrameworkShortName string    `json:"framework_short_name"`
}

type ListMeasuresForRequirementRow struct {
	ID       uuid.UUID `json:"id"`
	Name     string    `json:"name"`
	Category string    `json:"category"`
	Status   string    `json:"status"`
	Owner    string    `json:"owner"`
}

type ListOwnedActivitiesRow struct {
	ID          uuid.UUID `json:"id"`
	Title       string    `json:"title"`
	Status      string    `json:"status"`
	Priority    string    `json:"priority"`
	Kind        string    `json:"kind"`
	DueDate     string    `json:"due_date"`
	UpdatedAt   string    `json:"updated_at"`
	MeasureName string    `json:"measure_name"`
}

type ListOwnedMeasuresRow struct {
	ID        uuid.UUID `json:"id"`
	Name      string    `json:"name"`
	Status    string    `json:"status"`
	UpdatedAt string    `json:"updated_at"`
}

type ListOwnedRisksRow struct {
	ID                 uuid.UUID `json:"id"`
	AssessmentID       uuid.UUID `json:"assessment_id"`
	Name               string    `json:"name"`
	LikelihoodCurrent  int32     `json:"likelihood_current"`
	ConsequenceCurrent int32     `json:"consequence_current"`
	UpdatedAt          string    `json:"updated_at"`
	AssessmentName     string    `json:"assessment_name"`
	AssessmentRefNum   int32     `json:"assessment_ref_num"`
}

type ListRecentActivitiesRow struct {
	ID          uuid.UUID    `json:"id"`
	Title       string       `json:"title"`
	Status      string       `json:"status"`
	Owner       string       `json:"owner"`
	Priority    string       `json:"priority"`
	CompletedAt sql.NullTime `json:"completed_at"`
	DueDate     sql.NullTime `json:"due_date"`
	UpdatedAt   time.Time    `json:"updated_at"`
	MeasureName string       `json:"measure_name"`
}

type ListRequirementsForMeasureRow struct {
	ID                 uuid.UUID `json:"id"`
	FrameworkID        uuid.UUID `json:"framework_id"`
	Ref                string    `json:"ref"`
	Title              string    `json:"title"`
	Description        string    `json:"description"`
	SortOrder          int32     `json:"sort_order"`
	CreatedAt          time.Time `json:"created_at"`
	UpdatedAt          time.Time `json:"updated_at"`
	FrameworkName      string    `json:"framework_name"`
	FrameworkShortName string    `json:"framework_short_name"`
}

type ListRiskReassessmentEventsParams struct {
	RiskID  uuid.UUID    `json:"risk_id"`
	SinceAt sql.NullTime `json:"since_at"`
}

type ListRiskReassessmentEventsRow struct {
	ID            uuid.UUID     `json:"id"`
	RiskID        uuid.UUID     `json:"risk_id"`
	MeasureID     uuid.UUID     `json:"measure_id"`
	TriggerStatus string        `json:"trigger_status"`
	TriggeredAt   time.Time     `json:"triggered_at"`
	TriggeredBy   uuid.NullUUID `json:"triggered_by"`
	Note          string        `json:"note"`
	MeasureName   string        `json:"measure_name"`
	MeasureRefNum sql.NullInt32 `json:"measure_ref_num"`
}

type ListRiskReviewQueueForUserRow struct {
	ID                   uuid.UUID     `json:"id"`
	AssessmentID         uuid.UUID     `json:"assessment_id"`
	Name                 string        `json:"name"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodTarget     sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget    sql.NullInt32 `json:"consequence_target"`
	RiskDecision         string        `json:"risk_decision"`
	Status               string        `json:"status"`
	CreatedAt            time.Time     `json:"created_at"`
	UpdatedAt            time.Time     `json:"updated_at"`
	Description          string        `json:"description"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
	OwnerID              uuid.NullUUID `json:"owner_id"`
	DecisionNotes        string        `json:"decision_notes"`
	RefNum               sql.NullInt32 `json:"ref_num"`
	ReviewNeeded         bool          `json:"review_needed"`
	ReviewDue            sql.NullTime  `json:"review_due"`
	AssessedAt           sql.NullTime  `json:"assessed_at"`
	AssessedBy           uuid.NullUUID `json:"assessed_by"`
	AssessmentRationale  string        `json:"assessment_rationale"`
	AssessmentName       string        `json:"assessment_name"`
	AssessmentRefNum     sql.NullInt32 `json:"assessment_ref_num"`
}

type ListRiskReviewQueueRow struct {
	ID                   uuid.UUID     `json:"id"`
	AssessmentID         uuid.UUID     `json:"assessment_id"`
	Name                 string        `json:"name"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodTarget     sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget    sql.NullInt32 `json:"consequence_target"`
	RiskDecision         string        `json:"risk_decision"`
	Status               string        `json:"status"`
	CreatedAt            time.Time     `json:"created_at"`
	UpdatedAt            time.Time     `json:"updated_at"`
	Description          string        `json:"description"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
	OwnerID              uuid.NullUUID `json:"owner_id"`
	DecisionNotes        string        `json:"decision_notes"`
	RefNum               sql.NullInt32 `json:"ref_num"`
	ReviewNeeded         bool          `json:"review_needed"`
	ReviewDue            sql.NullTime  `json:"review_due"`
	AssessedAt           sql.NullTime  `json:"assessed_at"`
	AssessedBy           uuid.NullUUID `json:"assessed_by"`
	AssessmentRationale  string        `json:"assessment_rationale"`
	AssessmentName       string        `json:"assessment_name"`
	AssessmentRefNum     sql.NullInt32 `json:"assessment_ref_num"`
}

type ListTopRisksRow struct {
	ID                   uuid.UUID     `json:"id"`
	AssessmentID         uuid.UUID     `json:"assessment_id"`
	Name                 string        `json:"name"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodTarget     sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget    sql.NullInt32 `json:"consequence_target"`
	RiskDecision         string        `json:"risk_decision"`
	Status               string        `json:"status"`
	CreatedAt            time.Time     `json:"created_at"`
	UpdatedAt            time.Time     `json:"updated_at"`
	Description          string        `json:"description"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
	OwnerID              uuid.NullUUID `json:"owner_id"`
	DecisionNotes        string        `json:"decision_notes"`
	RefNum               sql.NullInt32 `json:"ref_num"`
	ReviewNeeded         bool          `json:"review_needed"`
	ReviewDue            sql.NullTime  `json:"review_due"`
	AssessedAt           sql.NullTime  `json:"assessed_at"`
	AssessedBy           uuid.NullUUID `json:"assessed_by"`
	AssessmentRationale  string        `json:"assessment_rationale"`
	AssessmentName       string        `json:"assessment_name"`
}

type Measure struct {
	ID             uuid.UUID     `json:"id"`
	Name           string        `json:"name"`
	Description    string        `json:"description"`
	Category       string        `json:"category"`
	Owner          string        `json:"owner"`
	Status         string        `json:"status"`
	CreatedAt      time.Time     `json:"created_at"`
	UpdatedAt      time.Time     `json:"updated_at"`
	LastVerifiedAt sql.NullTime  `json:"last_verified_at"`
	AssigneeID     uuid.NullUUID `json:"assignee_id"`
	RefNum         sql.NullInt32 `json:"ref_num"`
}

type MeasureLink struct {
	ID        uuid.UUID `json:"id"`
	MeasureID uuid.UUID `json:"measure_id"`
	Url       string    `json:"url"`
	Label     string    `json:"label"`
	CreatedAt time.Time `json:"created_at"`
}

type MeasureRequirement struct {
	MeasureID     uuid.UUID `json:"measure_id"`
	RequirementID uuid.UUID `json:"requirement_id"`
	Note          string    `json:"note"`
	CreatedAt     time.Time `json:"created_at"`
}

type Organization struct {
	ID        uuid.UUID      `json:"id"`
	Name      string         `json:"name"`
	ParentID  uuid.NullUUID  `json:"parent_id"`
	CreatedAt time.Time      `json:"created_at"`
	UpdatedAt time.Time      `json:"updated_at"`
	Key       sql.NullString `json:"key"`
}

type PreCreateUserParams struct {
	ProviderID string `json:"provider_id"`
	Name       string `json:"name"`
	Role       string `json:"role"`
}

type Querier interface {
	AcceptAssessment(ctx context.Context, id uuid.UUID) (RiskAssessment, error)
	AddAssessmentParticipant(ctx context.Context, arg AddAssessmentParticipantParams) error
	AddAssetToAssessment(ctx context.Context, arg AddAssetToAssessmentParams) error
	AddAvvikAttachment(ctx context.Context, arg AddAvvikAttachmentParams) (AvvikAttachment, error)
	AddAvvikEvent(ctx context.Context, arg AddAvvikEventParams) (AvvikEvent, error)
	AddAvvikNotification(ctx context.Context, arg AddAvvikNotificationParams) (AvvikNotification, error)
	AddMeasureLink(ctx context.Context, arg AddMeasureLinkParams) (MeasureLink, error)
	AddParticipant(ctx context.Context, arg AddParticipantParams) error
	ClaimPendingUser(ctx context.Context, arg ClaimPendingUserParams) (User, error)
	ClearAssessmentParticipants(ctx context.Context, assessmentID uuid.UUID) error
	ClearRiskAssets(ctx context.Context, riskID uuid.UUID) error
	CompleteActivity(ctx context.Context, arg CompleteActivityParams) (Activity, error)
	CountCoveredRequirementsByFramework(ctx context.Context, frameworkID uuid.UUID) (int64, error)
	CountRequirementsByFramework(ctx context.Context, frameworkID uuid.UUID) (int64, error)
	CountRisksForMatrix(ctx context.Context) ([]CountRisksForMatrixRow, error)
	CreateActivity(ctx context.Context, arg CreateActivityParams) (Activity, error)
	CreateAsset(ctx context.Context, arg CreateAssetParams) (Asset, error)
	CreateAvvik(ctx context.Context, arg CreateAvvikParams) (Avvik, error)
	CreateFramework(ctx context.Context, arg CreateFrameworkParams) (Framework, error)
	CreateMeasure(ctx context.Context, arg CreateMeasureParams) (Measure, error)
	CreateOrganization(ctx context.Context, arg CreateOrganizationParams) (Organization, error)
	CreateRequirement(ctx context.Context, arg CreateRequirementParams) (Requirement, error)
	CreateRisk(ctx context.Context, arg CreateRiskParams) (Risk, error)
	CreateRiskAssessment(ctx context.Context, arg CreateRiskAssessmentParams) (RiskAssessment, error)
	CreateRiskReassessmentEvent(ctx context.Context, arg CreateRiskReassessmentEventParams) error
	DeclineAssessment(ctx context.Context, arg DeclineAssessmentParams) (RiskAssessment, error)
	DeleteActivity(ctx context.Context, id uuid.UUID) error
	DeleteAsset(ctx context.Context, id uuid.UUID) error
	DeleteFramework(ctx context.Context, id uuid.UUID) error
	DeleteMeasure(ctx context.Context, id uuid.UUID) error
	DeleteMeasureLink(ctx context.Context, arg DeleteMeasureLinkParams) error
	DeleteOrganization(ctx context.Context, id uuid.UUID) error
	DeleteRequirement(ctx context.Context, id uuid.UUID) error
	DeleteRisk(ctx context.Context, id uuid.UUID) error
	DeleteRiskAssessment(ctx context.Context, id uuid.UUID) error
	DeleteSessionsByUserID(ctx context.Context, userID uuid.NullUUID) error
	DeleteUser(ctx context.Context, id uuid.UUID) error
	FilterActivities(ctx context.Context, arg FilterActivitiesParams) ([]FilterActivitiesRow, error)
	FilterMeasures(ctx context.Context, arg FilterMeasuresParams) ([]Measure, error)
	FlagRiskForReview(ctx context.Context, id uuid.UUID) error
	GetActivity(ctx context.Context, id uuid.UUID) (GetActivityRow, error)
	GetAppSettings(ctx context.Context) (AppSetting, error)
	GetAsset(ctx context.Context, id uuid.UUID) (Asset, error)
	GetAvvik(ctx context.Context, id uuid.UUID) (Avvik, error)
	GetDashboardStats(ctx context.Context) (GetDashboardStatsRow, error)
	GetFramework(ctx context.Context, id uuid.UUID) (Framework, error)
	GetMeasure(ctx context.Context, id uuid.UUID) (Measure, error)
	GetOrganization(ctx context.Context, id uuid.UUID) (Organization, error)
	GetRequirement(ctx context.Context, id uuid.UUID) (Requirement, error)
	GetRisk(ctx context.Context, id uuid.UUID) (Risk, error)
	GetRiskAssessment(ctx context.Context, id uuid.UUID) (RiskAssessment, error)
	GetRiskGlobalSettings(ctx context.Context) (RiskGlobalSetting, error)
	GetRiskStats(ctx context.Context) (GetRiskStatsRow, error)
	GetUserByEmail(ctx context.Context, email string) (User, error)
	GetUserByID(ctx context.Context, id uuid.UUID) (User, error)
	InsertAuditLog(ctx context.Context, arg InsertAuditLogParams) error
	IsParticipant(ctx context.Context, arg IsParticipantParams) (bool, error)
	IsRiskAssessmentAccessible(ctx context.Context, arg IsRiskAssessmentAccessibleParams) (bool, error)
	IsRiskAssessmentParticipant(ctx context.Context, arg IsRiskAssessmentParticipantParams) (bool, error)
	LinkAvvikActivity(ctx context.Context, arg LinkAvvikActivityParams) error
	LinkAvvikMeasure(ctx context.Context, arg LinkAvvikMeasureParams) error
	LinkMeasureToRequirement(ctx context.Context, arg LinkMeasureToRequirementParams) error
	LinkRiskToActivity(ctx context.Context, arg LinkRiskToActivityParams) error
	LinkRiskToAsset(ctx context.Context, arg LinkRiskToAssetParams) error
	LinkRiskToMeasure(ctx context.Context, arg LinkRiskToMeasureParams) error
	ListActiveSessionsByUser(ctx context.Context) ([]ListActiveSessionsByUserRow, error)
	ListActivities(ctx context.Context) ([]ListActivitiesRow, error)
	ListActivitiesForMeasure(ctx context.Context, measureID uuid.NullUUID) ([]ListActivitiesForMeasureRow, error)
	ListActivitiesForRisk(ctx context.Context, riskID uuid.UUID) ([]Activity, error)
	ListActivitiesForUser(ctx context.Context, assigneeID uuid.NullUUID) ([]ListActivitiesForUserRow, error)
	ListAllRequirements(ctx context.Context) ([]ListAllRequirementsRow, error)
	ListAllRisks(ctx context.Context) ([]ListAllRisksRow, error)
	ListAllRisksForUser(ctx context.Context, dollar_1 uuid.UUID) ([]ListAllRisksForUserRow, error)
	ListAssets(ctx context.Context, arg ListAssetsParams) ([]Asset, error)
	ListAssetsForAssessment(ctx context.Context, assessmentID uuid.UUID) ([]Asset, error)
	ListAssetsForRisk(ctx context.Context, riskID uuid.UUID) ([]Asset, error)
	ListAuditLogAdmin(ctx context.Context) ([]ListAuditLogAdminRow, error)
	ListAuditLogForActivity(ctx context.Context, dollar_1 string) ([]ListAuditLogForActivityRow, error)
	ListAuditLogForAssessment(ctx context.Context, dollar_1 string) ([]ListAuditLogForAssessmentRow, error)
	ListAuditLogForAsset(ctx context.Context, dollar_1 string) ([]ListAuditLogForAssetRow, error)
	ListAuditLogForFramework(ctx context.Context, dollar_1 string) ([]ListAuditLogForFrameworkRow, error)
	ListAuditLogForMeasure(ctx context.Context, dollar_1 string) ([]ListAuditLogForMeasureRow, error)
	ListAuditLogForRequirement(ctx context.Context, dollar_1 string) ([]ListAuditLogForRequirementRow, error)
	ListAuditLogForRisk(ctx context.Context, dollar_1 string) ([]ListAuditLogForRiskRow, error)
	ListAvvik(ctx context.Context, arg ListAvvikParams) ([]Avvik, error)
	ListAvvikActivities(ctx context.Context, avvikID uuid.UUID) ([]Activity, error)
	ListAvvikAttachments(ctx context.Context, avvikID uuid.UUID) ([]AvvikAttachment, error)
	ListAvvikEvents(ctx context.Context, avvikID uuid.UUID) ([]AvvikEvent, error)
	ListAvvikMeasures(ctx context.Context, avvikID uuid.UUID) ([]Measure, error)
	ListAvvikNotifications(ctx context.Context, avvikID uuid.UUID) ([]AvvikNotification, error)
	ListDevStubUsers(ctx context.Context) ([]User, error)
	ListFrameworks(ctx context.Context) ([]Framework, error)
	// Returns one row per (measure, framework) pair — used to build the framework
	// badge list shown next to each measure in the list view.
	ListMeasureFrameworkLinks(ctx context.Context) ([]ListMeasureFrameworkLinksRow, error)
	ListMeasureLinks(ctx context.Context, measureID uuid.UUID) ([]MeasureLink, error)
	ListMeasureRiskLinkIDs(ctx context.Context) ([]uuid.UUID, error)
	ListMeasures(ctx context.Context) ([]Measure, error)
	ListMeasuresForRequirement(ctx context.Context, requirementID uuid.UUID) ([]ListMeasuresForRequirementRow, error)
	ListMeasuresForRisk(ctx context.Context, riskID uuid.UUID) ([]Measure, error)
	ListMeasuresForUser(ctx context.Context, assigneeID uuid.NullUUID) ([]Measure, error)
	ListOrganizations(ctx context.Context) ([]Organization, error)
	ListOwnedActivities(ctx context.Context, assigneeID uuid.NullUUID) ([]ListOwnedActivitiesRow, error)
	ListOwnedMeasures(ctx context.Context, assigneeID uuid.NullUUID) ([]ListOwnedMeasuresRow, error)
	ListOwnedRisks(ctx context.Context, ownerID uuid.NullUUID) ([]ListOwnedRisksRow, error)
	ListParticipantsForAssessment(ctx context.Context, assessmentID uuid.UUID) ([]User, error)
	ListRecentActivities(ctx context.Context) ([]ListRecentActivitiesRow, error)
	ListRequirementsByFramework(ctx context.Context, frameworkID uuid.UUID) ([]Requirement, error)
	ListRequirementsForMeasure(ctx context.Context, measureID uuid.UUID) ([]ListRequirementsForMeasureRow, error)
	ListRiskAssessments(ctx context.Context) ([]RiskAssessment, error)
	ListRiskAssessmentsForUser(ctx context.Context, riskOwnerID uuid.NullUUID) ([]RiskAssessment, error)
	ListRiskReassessmentEvents(ctx context.Context, arg ListRiskReassessmentEventsParams) ([]ListRiskReassessmentEventsRow, error)
	ListRiskReviewQueue(ctx context.Context) ([]ListRiskReviewQueueRow, error)
	ListRiskReviewQueueForUser(ctx context.Context, dollar_1 uuid.UUID) ([]ListRiskReviewQueueForUserRow, error)
	ListRiskScaleLabels(ctx context.Context) ([]RiskScaleLabel, error)
	ListRisksForActivity(ctx context.Context, activityID uuid.UUID) ([]Risk, error)
	ListRisksForAssessment(ctx context.Context, assessmentID uuid.UUID) ([]Risk, error)
	ListRisksForMeasure(ctx context.Context, measureID uuid.UUID) ([]Risk, error)
	ListTopRisks(ctx context.Context) ([]ListTopRisksRow, error)
	ListUsers(ctx context.Context) ([]User, error)
	MarkActivityInProgress(ctx context.Context, id uuid.UUID) (Activity, error)
	MarkOverdueActivities(ctx context.Context) error
	PreCreateUser(ctx context.Context, arg PreCreateUserParams) (User, error)
	ReassessRiskCurrentScores(ctx context.Context, arg ReassessRiskCurrentScoresParams) (Risk, error)
	RemoveAssessmentParticipant(ctx context.Context, arg RemoveAssessmentParticipantParams) error
	RemoveAssetFromAssessment(ctx context.Context, arg RemoveAssetFromAssessmentParams) error
	ReopenActivity(ctx context.Context, id uuid.UUID) (Activity, error)
	SearchActivities(ctx context.Context, title string) ([]Activity, error)
	SearchAssetsForRisk(ctx context.Context, arg SearchAssetsForRiskParams) ([]Asset, error)
	SearchAssetsToLink(ctx context.Context, arg SearchAssetsToLinkParams) ([]Asset, error)
	SearchMeasures(ctx context.Context, name string) ([]Measure, error)
	SetUserOrg(ctx context.Context, arg SetUserOrgParams) (User, error)
	SetUserRole(ctx context.Context, arg SetUserRoleParams) (User, error)
	ToggleRiskAssessmentPublic(ctx context.Context, id uuid.UUID) (RiskAssessment, error)
	UnlinkAvvikActivity(ctx context.Context, arg UnlinkAvvikActivityParams) error
	UnlinkAvvikMeasure(ctx context.Context, arg UnlinkAvvikMeasureParams) error
	UnlinkMeasureFromRequirement(ctx context.Context, arg UnlinkMeasureFromRequirementParams) error
	UnlinkRiskFromActivity(ctx context.Context, arg UnlinkRiskFromActivityParams) error
	UnlinkRiskFromAsset(ctx context.Context, arg UnlinkRiskFromAssetParams) error
	UnlinkRiskFromMeasure(ctx context.Context, arg UnlinkRiskFromMeasureParams) error
	UpdateActivity(ctx context.Context, arg UpdateActivityParams) (Activity, error)
	UpdateAppSettings(ctx context.Context, arg UpdateAppSettingsParams) error
	UpdateAsset(ctx context.Context, arg UpdateAssetParams) (Asset, error)
	UpdateAvvikClosureFlags(ctx context.Context, arg UpdateAvvikClosureFlagsParams) (Avvik, error)
	UpdateAvvikStatus(ctx context.Context, arg UpdateAvvikStatusParams) (Avvik, error)
	UpdateAvvikTriage(ctx context.Context, arg UpdateAvvikTriageParams) (Avvik, error)
	UpdateFramework(ctx context.Context, arg UpdateFrameworkParams) (Framework, error)
	UpdateMeasure(ctx context.Context, arg UpdateMeasureParams) (Measure, error)
	UpdateMeasureLastVerified(ctx context.Context, id uuid.UUID) error
	UpdateRequirement(ctx context.Context, arg UpdateRequirementParams) (Requirement, error)
	UpdateRiskAssessmentReviewed(ctx context.Context, id uuid.UUID) error
	UpdateRiskAssessmentStep(ctx context.Context, arg UpdateRiskAssessmentStepParams) error
	UpdateRiskAssessmentStep1(ctx context.Context, arg UpdateRiskAssessmentStep1Params) (RiskAssessment, error)
	UpdateRiskAssessmentThreatStep(ctx context.Context, arg UpdateRiskAssessmentThreatStepParams) (RiskAssessment, error)
	UpdateRiskCurrentScores(ctx context.Context, arg UpdateRiskCurrentScoresParams) (Risk, error)
	UpdateRiskDecision(ctx context.Context, arg UpdateRiskDecisionParams) error
	UpdateRiskGlobalSettings(ctx context.Context, arg UpdateRiskGlobalSettingsParams) error
	UpdateRiskIdentification(ctx context.Context, arg UpdateRiskIdentificationParams) (Risk, error)
	UpdateRiskTargetScore(ctx context.Context, arg UpdateRiskTargetScoreParams) error
	UpsertDevStubUser(ctx context.Context, arg UpsertDevStubUserParams) (User, error)
	UpsertRiskScaleLabel(ctx context.Context, arg UpsertRiskScaleLabelParams) error
	UpsertUser(ctx context.Context, arg UpsertUserParams) (User, error)
}

type Queries struct {
	// contains filtered or unexported fields
}

type ReassessRiskCurrentScoresParams struct {
	ID                  uuid.UUID     `json:"id"`
	LikelihoodCurrent   sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent  sql.NullInt32 `json:"consequence_current"`
	AssessmentRationale string        `json:"assessment_rationale"`
	AssessedBy          uuid.NullUUID `json:"assessed_by"`
}

type RemoveAssessmentParticipantParams struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	UserID       uuid.UUID `json:"user_id"`
}

type RemoveAssetFromAssessmentParams struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	AssetID      uuid.UUID `json:"asset_id"`
}

type Requirement struct {
	ID                uuid.UUID `json:"id"`
	FrameworkID       uuid.UUID `json:"framework_id"`
	Ref               string    `json:"ref"`
	Title             string    `json:"title"`
	Description       string    `json:"description"`
	SortOrder         int32     `json:"sort_order"`
	CreatedAt         time.Time `json:"created_at"`
	UpdatedAt         time.Time `json:"updated_at"`
	NotRelevant       bool      `json:"not_relevant"`
	NotRelevantReason string    `json:"not_relevant_reason"`
}

type ResourceParticipant struct {
	ID           uuid.UUID `json:"id"`
	ResourceType string    `json:"resource_type"`
	ResourceID   uuid.UUID `json:"resource_id"`
	UserID       uuid.UUID `json:"user_id"`
	Role         string    `json:"role"`
	CreatedAt    time.Time `json:"created_at"`
}

type Risk struct {
	ID                   uuid.UUID     `json:"id"`
	AssessmentID         uuid.UUID     `json:"assessment_id"`
	Name                 string        `json:"name"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodTarget     sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget    sql.NullInt32 `json:"consequence_target"`
	RiskDecision         string        `json:"risk_decision"`
	Status               string        `json:"status"`
	CreatedAt            time.Time     `json:"created_at"`
	UpdatedAt            time.Time     `json:"updated_at"`
	Description          string        `json:"description"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
	OwnerID              uuid.NullUUID `json:"owner_id"`
	DecisionNotes        string        `json:"decision_notes"`
	RefNum               sql.NullInt32 `json:"ref_num"`
	ReviewNeeded         bool          `json:"review_needed"`
	ReviewDue            sql.NullTime  `json:"review_due"`
	AssessedAt           sql.NullTime  `json:"assessed_at"`
	AssessedBy           uuid.NullUUID `json:"assessed_by"`
	AssessmentRationale  string        `json:"assessment_rationale"`
}

type RiskActivityLink struct {
	RiskID     uuid.UUID `json:"risk_id"`
	ActivityID uuid.UUID `json:"activity_id"`
	Note       string    `json:"note"`
}

type RiskAssessment struct {
	ID                      uuid.UUID     `json:"id"`
	Name                    string        `json:"name"`
	Scope                   string        `json:"scope"`
	AnalysisObject          string        `json:"analysis_object"`
	SecurityObjectives      string        `json:"security_objectives"`
	BusinessObjectives      string        `json:"business_objectives"`
	Type                    string        `json:"type"`
	Status                  string        `json:"status"`
	CurrentStep             int32         `json:"current_step"`
	LastReviewedAt          sql.NullTime  `json:"last_reviewed_at"`
	CreatedBy               uuid.NullUUID `json:"created_by"`
	CreatedAt               time.Time     `json:"created_at"`
	UpdatedAt               time.Time     `json:"updated_at"`
	RiskOwnerID             uuid.NullUUID `json:"risk_owner_id"`
	OrgID                   uuid.NullUUID `json:"org_id"`
	RefNum                  sql.NullInt32 `json:"ref_num"`
	AcceptanceNote          string        `json:"acceptance_note"`
	IsPublic                bool          `json:"is_public"`
	ThreatAssessmentEnabled bool          `json:"threat_assessment_enabled"`
	ThreatAppDescription    string        `json:"threat_app_description"`
	ThreatInformationFlow   string        `json:"threat_information_flow"`
}

type RiskAssessmentAsset struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	AssetID      uuid.UUID `json:"asset_id"`
	CreatedAt    time.Time `json:"created_at"`
}

type RiskAssessmentParticipant struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	UserID       uuid.UUID `json:"user_id"`
}

type RiskAssetLink struct {
	RiskID    uuid.UUID `json:"risk_id"`
	AssetID   uuid.UUID `json:"asset_id"`
	CreatedAt time.Time `json:"created_at"`
}

type RiskGlobalSetting struct {
	ID                 int32  `json:"id"`
	AcceptanceCriteria string `json:"acceptance_criteria"`
	LowMax             int32  `json:"low_max"`
	HighMin            int32  `json:"high_min"`
}

type RiskMeasureLink struct {
	RiskID    uuid.UUID `json:"risk_id"`
	MeasureID uuid.UUID `json:"measure_id"`
	Note      string    `json:"note"`
}

type RiskReassessmentEvent struct {
	ID            uuid.UUID     `json:"id"`
	RiskID        uuid.UUID     `json:"risk_id"`
	MeasureID     uuid.UUID     `json:"measure_id"`
	TriggerStatus string        `json:"trigger_status"`
	TriggeredAt   time.Time     `json:"triggered_at"`
	TriggeredBy   uuid.NullUUID `json:"triggered_by"`
	Note          string        `json:"note"`
}

type RiskScaleLabel struct {
	Scale       string `json:"scale"`
	Level       int32  `json:"level"`
	Label       string `json:"label"`
	Description string `json:"description"`
}

type SearchAssetsForRiskParams struct {
	Q          interface{} `json:"q"`
	RiskID     uuid.UUID   `json:"risk_id"`
	LimitCount int32       `json:"limit_count"`
}

type SearchAssetsToLinkParams struct {
	Q            interface{} `json:"q"`
	AssessmentID uuid.UUID   `json:"assessment_id"`
	LimitCount   int32       `json:"limit_count"`
}

type Session struct {
	Token  string        `json:"token"`
	Data   []byte        `json:"data"`
	Expiry time.Time     `json:"expiry"`
	UserID uuid.NullUUID `json:"user_id"`
}

type SetUserOrgParams struct {
	ID    uuid.UUID     `json:"id"`
	OrgID uuid.NullUUID `json:"org_id"`
}

type SetUserRoleParams struct {
	ID   uuid.UUID `json:"id"`
	Role string    `json:"role"`
}

type UnlinkAvvikActivityParams struct {
	AvvikID    uuid.UUID `json:"avvik_id"`
	ActivityID uuid.UUID `json:"activity_id"`
}

type UnlinkAvvikMeasureParams struct {
	AvvikID   uuid.UUID `json:"avvik_id"`
	MeasureID uuid.UUID `json:"measure_id"`
}

type UnlinkMeasureFromRequirementParams struct {
	MeasureID     uuid.UUID `json:"measure_id"`
	RequirementID uuid.UUID `json:"requirement_id"`
}

type UnlinkRiskFromActivityParams struct {
	RiskID     uuid.UUID `json:"risk_id"`
	ActivityID uuid.UUID `json:"activity_id"`
}

type UnlinkRiskFromAssetParams struct {
	RiskID  uuid.UUID `json:"risk_id"`
	AssetID uuid.UUID `json:"asset_id"`
}

type UnlinkRiskFromMeasureParams struct {
	RiskID    uuid.UUID `json:"risk_id"`
	MeasureID uuid.UUID `json:"measure_id"`
}

type UpdateActivityParams struct {
	ID           uuid.UUID     `json:"id"`
	Title        string        `json:"title"`
	Description  string        `json:"description"`
	ActivityType string        `json:"activity_type"`
	Recurrence   string        `json:"recurrence"`
	Priority     string        `json:"priority"`
	Kind         string        `json:"kind"`
	Owner        string        `json:"owner"`
	AssigneeID   uuid.NullUUID `json:"assignee_id"`
	DueDate      sql.NullTime  `json:"due_date"`
}

type UpdateAppSettingsParams struct {
	ComplianceEnabled bool `json:"compliance_enabled"`
	RiskEnabled       bool `json:"risk_enabled"`
	ActivitiesEnabled bool `json:"activities_enabled"`
	AssetsEnabled     bool `json:"assets_enabled"`
	PlaygroundEnabled bool `json:"playground_enabled"`
	AvvikEnabled      bool `json:"avvik_enabled"`
}

type UpdateAssetParams struct {
	ID          uuid.UUID `json:"id"`
	Name        string    `json:"name"`
	Description string    `json:"description"`
	AssetType   string    `json:"asset_type"`
	Owner       string    `json:"owner"`
	Status      string    `json:"status"`
	Criticality string    `json:"criticality"`
}

type UpdateAvvikClosureFlagsParams struct {
	ID                        uuid.UUID `json:"id"`
	LogQaDone                 bool      `json:"log_qa_done"`
	FollowupsDelegated        bool      `json:"followups_delegated"`
	ReporterInformed          bool      `json:"reporter_informed"`
	OrgInformed               bool      `json:"org_informed"`
	MgmtInformed              bool      `json:"mgmt_informed"`
	DecisionsAnchored         bool      `json:"decisions_anchored"`
	ImplementationDeadlineSet bool      `json:"implementation_deadline_set"`
}

type UpdateAvvikStatusParams struct {
	ID             uuid.UUID    `json:"id"`
	Status         string       `json:"status"`
	ClosedAt       sql.NullTime `json:"closed_at"`
	ClosureSummary string       `json:"closure_summary"`
	RootCause      string       `json:"root_cause"`
	LessonsLearned string       `json:"lessons_learned"`
}

type UpdateAvvikTriageParams struct {
	ID                   uuid.UUID     `json:"id"`
	RiskLevel            string        `json:"risk_level"`
	PersonalData         bool          `json:"personal_data"`
	Ksi                  bool          `json:"ksi"`
	KsiInformationOwner  string        `json:"ksi_information_owner"`
	MarketSensitive      bool          `json:"market_sensitive"`
	MarketAssessmentNote string        `json:"market_assessment_note"`
	GdprDeadlineAt       sql.NullTime  `json:"gdpr_deadline_at"`
	OrgUnitID            uuid.NullUUID `json:"org_unit_id"`
}

type UpdateFrameworkParams struct {
	ID                uuid.UUID `json:"id"`
	Name              string    `json:"name"`
	ShortName         string    `json:"short_name"`
	Version           string    `json:"version"`
	Description       string    `json:"description"`
	FrameworkType     string    `json:"framework_type"`
	NotRelevant       bool      `json:"not_relevant"`
	NotRelevantReason string    `json:"not_relevant_reason"`
}

type UpdateMeasureParams struct {
	ID          uuid.UUID     `json:"id"`
	Name        string        `json:"name"`
	Description string        `json:"description"`
	Category    string        `json:"category"`
	Owner       string        `json:"owner"`
	AssigneeID  uuid.NullUUID `json:"assignee_id"`
	Status      string        `json:"status"`
}

type UpdateRequirementParams struct {
	ID                uuid.UUID `json:"id"`
	Ref               string    `json:"ref"`
	Title             string    `json:"title"`
	Description       string    `json:"description"`
	SortOrder         int32     `json:"sort_order"`
	NotRelevant       bool      `json:"not_relevant"`
	NotRelevantReason string    `json:"not_relevant_reason"`
}

type UpdateRiskAssessmentStep1Params struct {
	ID                      uuid.UUID     `json:"id"`
	Name                    string        `json:"name"`
	Scope                   string        `json:"scope"`
	AnalysisObject          string        `json:"analysis_object"`
	SecurityObjectives      string        `json:"security_objectives"`
	BusinessObjectives      string        `json:"business_objectives"`
	Type                    string        `json:"type"`
	RiskOwnerID             uuid.NullUUID `json:"risk_owner_id"`
	OrgID                   uuid.NullUUID `json:"org_id"`
	ThreatAssessmentEnabled bool          `json:"threat_assessment_enabled"`
}

type UpdateRiskAssessmentStepParams struct {
	ID          uuid.UUID `json:"id"`
	CurrentStep int32     `json:"current_step"`
	Status      string    `json:"status"`
}

type UpdateRiskAssessmentThreatStepParams struct {
	ID                    uuid.UUID `json:"id"`
	ThreatAppDescription  string    `json:"threat_app_description"`
	ThreatInformationFlow string    `json:"threat_information_flow"`
}

type UpdateRiskCurrentScoresParams struct {
	ID                   uuid.UUID     `json:"id"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
}

type UpdateRiskDecisionParams struct {
	ID            uuid.UUID `json:"id"`
	RiskDecision  string    `json:"risk_decision"`
	DecisionNotes string    `json:"decision_notes"`
}

type UpdateRiskGlobalSettingsParams struct {
	AcceptanceCriteria string `json:"acceptance_criteria"`
	LowMax             int32  `json:"low_max"`
	HighMin            int32  `json:"high_min"`
}

type UpdateRiskIdentificationParams struct {
	ID          uuid.UUID `json:"id"`
	Name        string    `json:"name"`
	Description string    `json:"description"`
}

type UpdateRiskTargetScoreParams struct {
	ID                uuid.UUID     `json:"id"`
	LikelihoodTarget  sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget sql.NullInt32 `json:"consequence_target"`
}

type UpsertDevStubUserParams struct {
	ProviderID string `json:"provider_id"`
	Email      string `json:"email"`
	Name       string `json:"name"`
	Role       string `json:"role"`
}

type UpsertRiskScaleLabelParams struct {
	Scale       string `json:"scale"`
	Level       int32  `json:"level"`
	Label       string `json:"label"`
	Description string `json:"description"`
}

type UpsertUserParams struct {
	Provider   string `json:"provider"`
	ProviderID string `json:"provider_id"`
	Email      string `json:"email"`
	Name       string `json:"name"`
}

type User struct {
	ID         uuid.UUID     `json:"id"`
	Provider   string        `json:"provider"`
	ProviderID string        `json:"provider_id"`
	Email      string        `json:"email"`
	Name       string        `json:"name"`
	Role       string        `json:"role"`
	CreatedAt  time.Time     `json:"created_at"`
	UpdatedAt  time.Time     `json:"updated_at"`
	OrgID      uuid.NullUUID `json:"org_id"`
}