Vault and File Storage

We do not store files directly in the database but the system does have many places where we enable administrators to upload and download files. All files are actually stored in AWS S3 and the normal process of access to this is by having the API deliver short-lived signed URLs to the UI.

All files are referenced by a GUID and stored S3 using only the GUID and no extension as the object reference. The content-type will also be stored against the S3 object.

The Vault table is used as a record of all files that exist and the vault.id will appear in other tables as a foreign key.

Vault - Stores a reference and metadata about files that are stored in S3