You are here: Foswiki>Service Web>FesaDbUsefullTablesAndViews (21 Jun 2018, VitaliyRapp)Edit Attach

Selection of tables and view of the FESA database, to use for information retrieval

Object Name Object Type Content
CLASSVERSIONS_V View Information about all Class designs currently exported to the FESA database. The Class information is versioned, i.e. each design version has its own entry in the table.
FESA_DEPLOYMENS_V View Information about all Deployment Units currently exported to the FESA database. Deployment Units are versioned
DEVICES_V View Information about particular devices known directly by the FESA-DB. Among other this includes: Server name, fec, class name, version of the class, accelerator zone name and its ID. Devices are not versioned and their names are unique to the table. This view is the main source of information for the Directory Server Database (DIRSERVER)
FEDB_DEVICES_V View List of the Device Access devices. The information is a reference to FEDB
LSA_DEVICES_FESA View List of relevant FESA devices, stored in the FESA-DB. The information is prepared to be exported to LSA DB
LSA_DEVICES_DEVACC View List of relevant FESA devices, stored in the FE-DB. The information is prepared to be exported to LSA DB
LSA_DEVICES View United List of FESA and DevAcc devices. This view used to export device information to LSA
LSA_DEVTYPE_PROPERTIES_FESA View Information about the properties of particular device classes, relevant to LSA. This information is a reference to data stored in the FESA database
LSA_DEVTYPE_PROPERTIES_DEVACC View Information about the properties of DevAcc device classes, relevant to LSA. This information is a reference to data stored in the DEVACC database
LSA_DEVTYPE_PROPERTIES View Information about the properties of FESA relevant devices (unites the according FESA and DevAcc view)
LSA_PROPERTY_FIELDS_FESA View Lists the Fields of the all FESA Class properties listed in the FESA database and relevant for LSA export
LSA_PROPERTY_FIELDS_DEVACC View Lists the Fields of the all known DevAcc Class properties listed in the DEVACC database and relevant for LSA export
LSA_DEVTYPE_PROPERTIES View Lists the Fields of all LSA Relevant Classes for the export (unites the FESA and DevAcc view)
COM_LOGS Table Logs produced by the COMMON libraries. For example those logs may contain additional error information during the FESA Class or IU export
FESA_XML_METAMODELS Table Original XMLs used for export of the FESA Class data (Class files), if the export was successfull
FESA_XML_DEPLOYMENTS Table Same as above, but for DU files
FESA_XML_INSTANTIATIONS Table Same as above, but for IU (instance unit) files
LOV_FRAMEWORK_RELEASES Table List of all FESA Relases known to the FESA Database (Data of unknown releases can't be imported to the database)
Topic revision: r2 - 21 Jun 2018, VitaliyRapp
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Foswiki? Send feedback