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) |