list_ssl_cert_files

Column Type
host_identifier BLOB
name BLOB
block_size BLOB
device BLOB
directory BLOB
filename BLOB
gid BLOB
hard_links BLOB
inode BLOB
mode BLOB
path BLOB
size BLOB
type BLOB
uid BLOB
user_name BLOB
query_uri TEXT

SQL DDL

CREATE VIEW list_ssl_cert_files AS
SELECT 
  lp4.host_identifier,
  lp4.name,
  lp4.block_size,
  lp4.device,
  lp4.directory,
  lp4.filename,
  lp4.gid,
  lp4.hard_links,
  lp4.inode,
  lp4.mode,
  lp4.path,
  lp4.size,
  lp4.type,
  lp4.uid,
  user.user_name,
  lp4.query_uri
FROM ur_transform_list_ssl_cert_files lp4
LEFT JOIN ur_transform_list_user user ON user.uid = lp4.uid
;