NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
On a PostgreSQL database (such as an [[IMSMA Staging Area]]), the actual data always resides in the schema called '''public'''. Therefore, the '''public''' schema always has to be selected in this step, no other one. Select '''public''' and click '''OK'''. For other database systems, the schema names might be different though. Please get in touch with your [[Management Consulting Team|GICHD IM focal point]] in case of doubt.
The Domain Designer now opens on its first tab called '''Tables'''. The other tabs sections of the designer are the following.
[[File:MINT_domain_designer_tabs.png|center]]
* '''Tables:'''this part allows selecting all the tables from which should should be integrated into the domain.* '''Derived Tables:'''This sections allows the specification of any query to be run on the database. The result is stored as a so called derived table that is subsequently treated in the same way as any table selected in the '''Tables''' tab.* '''Joins:'''when more than one table or derived table are specified, joins have to be defined between them.* '''Calculated Fields:'''specific fields can be calculated based on other fields. For example, for data on land (hazard), the difference between the estimated and the calculated area could be determined and the value stored as a field.* '''Pre-filters:'''this section allows to specify filters on the data. For example, data on accidents could be restricted based on the date of the accident; activities could be filtered for a certain organisation only, etc.* '''Display:'''this final section allows selecting the data to be displayed, and organising it in meaningful sets. Additionally, each field/attribute can be renamed.
=== Tables ===__NOEDITSECTION__