Why are you interested in knowing how attachments are stored as BLOBs?
Would you by any chance have files (e.g. images) stored in BLOB fields in a non-GIS database that you would like to access in GIS without having to save these files again in a GIS database in a BLOB field to eliminate data duplication?