aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_s3_referenced_paths
Parameters
Name
Type
Mode
Definition
SELECT photo_path FROM guest_document WHERE photo_path IS NOT NULL UNION SELECT image_path FROM guest_document WHERE image_path IS NOT NULL UNION SELECT signature_path FROM guest_document WHERE signature_path IS NOT NULL UNION SELECT signature_path FROM guest_signature WHERE signature_path IS NOT NULL UNION SELECT file_path FROM doc.documents WHERE file_path IS NOT NULL UNION SELECT file_path FROM attachment WHERE file_path IS NOT NULL