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 UNION SELECT credential_ref FROM intf_doorlock_logs WHERE credential_type = 'QR' AND status = 'P' AND credential_ref IS NOT NULL UNION SELECT regexp_replace(logo_url, '^https?://[^/]+/', '') FROM public.print_form WHERE logo_url ~* '^https?://[^/]+/.+' UNION SELECT regexp_replace(layout_file, '^https?://[^/]+/', '') FROM public.room_layout WHERE layout_file ~* '^https?://[^/]+/.+'