[Feature] File and Task attachments

[GloireMutaliko21]

We have table ImageAsset for store files. But we can extend that tables and add more columns as per need to be able storing more information as folders, sub-folders, etc.

Features

1. Rename the table name to be fileAsset
2. Make the table more generic so we can attach files to tasks, projects, candidates, etc. We already have an existing way by adding entity and entityId columns to this table
3. Files should be stored / organized in the folders and sub-folders (A sub-folder should have the parentFolderId in this way etc.)
4. We need an optional employeeId column. Employees can upload their own files (private, only visible to them). We could as well set another column isPublic that can define if the file access is provided for whole organization level.
5. Think to implement it as a full plugin(s) that will include file storage, file upload (API/UI), file browsing UI (Folder structure), etc.
6. More important, we need to allow users to share their files :
   • Give access to few people (users or employees) : Like invitations, only allowed people can access the file
   • Or share a file as a public accessible so everyone who has the link can access that file.

More information

About the file storage plugin, we need to make possible that users can choose the way that they need to store their files (i.e in which server). So users can have choice between Amazon S3, Own server, Wasabi, etc...