Footprints Data Model

Table
Name cfg_file_repository
Comment
Now during publishing, new dynamic HBM files will be stored in DB and fetched
during session restart.

Configuration files are also stored here.

Design Notes:

Identify all configuration files that application (Renoir) need for startup,
and running. - Very important that we identify all the files that application is
using today. This will help us with #5.
a.       Examples; Hibernate Configuration Files, and .Properties files. This
does not include Spring Specific files.
/application/src/main/resources/footprints-email-incoming.properties
/business/src/main/resources/ical4j.properties
/business/src/main/resources/assetcore-searchdevice-one-result-response.xml
/business/src/main/resources/cosmo.version.txt
/business/src/main/resources/jeclicense
/business/src/main/resources/privkeystore
/business/src/main/resources/timezone.alias
/core/src/main/resources/mappings/*.*
/core/src/main/resources/footprints-external-data.properties
/core/src/main/conf/mysql/*.*
/core/src/main/conf/oracle/*.*
/core/src/main/conf/postgres/*.*
/core/src/main/conf/sqlserver/*.*
/infrastructure/src/main/resources/dbschema/*.*
/infrastructure/src/main/conf/*.properties
/web/src/main/conf/footprints-application-key.properties
/build/src/main/deployment/log4j.properties

2.       Where to store the configuration files (file data store) - This is
a.       Database of File Storage
We plan doing this as more general file Repository interface that will allow us
to select any specific implementation. But in our case we decided to use DB.

3.       How to retrieve the files from file data store -
Store them in blob format of DB and on demand transform into
ByteArrayInputStream.

Column
Name Datatype Comment Is PK Is FK
cfg_file_related_path varchar(255) File name and extension, although some names have non-standard extentions. Yes No
cfg_file_content varbinary(max) The file contents as a binary array. No No