oos-utils icon indicating copy to clipboard operation
oos-utils copied to clipboard

Document Storage table

Open martindsouza opened this issue 5 years ago • 0 comments

A lot of applications need to store documents somewhere. They all contain the same fields that become redundant to create/manage etc. Create a generic table where applications can use as a file store. Things to consider:

  • Have all insert/update/delete managed by a package so we pre-store things like doc_length etc
  • Soft delete flag / option (i.e. have a flag called delete_yn). This could be configurable and/or optional parameter set in the configuration
  • Had a column to store ref_id or something similar to store where the file is linked to (optional)
  • Things like mime_type etc can all be stored/generated using existing oos_utils apps;

martindsouza avatar Feb 19 '20 16:02 martindsouza