oos-utils
oos-utils copied to clipboard
Document Storage table
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_idor 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;