Subject Area : 310 - Auxiliary Tables
Subject Area Name Definition
310 - Auxiliary Tables Internal use tables.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
cfg_file_repository Configuration File Repository false 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.

Physical Name Attribute/Column Name Definition Physical Data Type
cfg_file_related_path Configuration File Related Path File name and extension, although some names have non-standard extentions. varchar(255)
cfg_file_content Configuration File Content The file contents as a binary array. varbinary(max)
extl_sys_certificate External System Certificate false Holds information about external system certificates.
Physical Name Attribute/Column Name Definition Physical Data Type
extl_sys_certificate_id External System Certificate Id The automatically generated primary key of the extl_sys_certificate table. bigint
extl_sys_certificate_name External System Certificate Name The name of the External System Certificate. varchar(255)
certificate Certificate Certificate binary array. varbinary(max)