CREATE OR REPLACE VIEW public.album_with_share_info_view
AS
SELECT
  album.id as id,
  album.id_user as id_user,
  album.name as name,
  album.type as type,
  album.create_time as create_time,
  album.start_time as start_time,
  share.privacy_type as privacy_type,
  share.enable as enable
FROM
  album LEFT JOIN share
ON album.passphrase_share = share.passphrase;