Who is this article for?

Database administrators and technical staff who need to understand data deletion behaviour in Galileo.

Database access and administrative permissions.

This article identifies which Galileo database tables use hard delete (permanent removal) versus soft delete (logical deletion with data retention).

1. Understanding deletion types

Galileo uses two methods to remove data from tables:

• Hard delete: Permanently removes records from the database with no recovery option
• Soft delete: Marks records as deleted whilst retaining the data in the database

Note: Tables marked as "NO" for hard delete use soft delete by default, preserving data for audit and recovery purposes.

2. Reviewing tables with hard delete

The following tables permanently remove data when records are deleted:

• Asset
• Attachment
• AuditChecklist
• AuditChecklistItem
• AuditChecklistItemAuditorAction
• AuditChecklistItemStandard
• AuditChecklistSection
• AuditLocation
• AuditResponse
• AuditScopeItem
• Auditee
• Auditor
• Control
• ExternalUser
• FormColumnFieldTrackerNew
• FormSectionTrackerNew
• Hazard
• HazardChecklist
• HazardType
• ReportAdditionalInformationFieldNew
• ReportAuditCheckListLink
• ReportAuditLink
• ReportCategory
• ReportClassification
• ReportClassificationFieldNew
• ReportFieldNew
• ReportInterestedParty
• ReportLink
• RiskAssessment
• RiskAssessmentXPerspective
• RiskAssessmentYPerspective
• RiskEvent
• RiskProjectOrganisationalUnit
• RiskProjectStakeholder
• TimelineEvent
• TimelineEventClassification
• TimelineEventControl
• TimelineEventControlNote
• TimelineEventNote

Important: Deletions from these tables cannot be recovered. Ensure you have appropriate backups before removing data.

3. Reviewing tables with soft delete

The following tables retain data when records are deleted, marking them as inactive rather than removing them:

• AssetType
• Audit
• AuditType
• ChangeRequest
• Consequence
• ControlCore
• ControlEffectiveness
• Customer
• DocumentDistributee
• DocumentRevision
• DocumentType
• Form
• FormColumnTrackerNew
• List
• MasterHazard
• MasterHazardType
• OrgUnitRelationship
• OrganisationalUnit
• Process
• ReportDefault
• ReportFeedback
• ReportLatest
• ReportOrganisationalUnit
• ReportRepeatedSectionColumnTrackerNew
• ReportRepeatedSectionTrackerNew
• RiskEventRiskAssessmentApprovalTask
• RiskProject
• ScopeItem
• Standard
• Supplier
• Task
• Threat
• User
• UserGroup
• UserGroupMembership
• Workflow
• WorkflowStage

Tip: Soft delete tables maintain data integrity and audit trails, allowing you to restore or reference deleted records if needed.