Databases allow you to define a structure linked by a set of attributes. In general, not all goods necessarily have the same attributes. For example, a boiler does not have the same characteristics as an engine or even an anomaly.
Once created, databases allow:
- To ensure the consistency of the structure of your data.
- To facilitate search via filters.
- To restrict access to your users via consultation rights.
It is possible to manage sub-databases. The sub-database will inherit the attributes of the mother database.
Be careful not to confuse with the parent/child equipment relationship which allows you to hierarchize your data.
Part 1:
- Go to the Database tab of the platform.
- Create a new database, "Construction Sites".
- In the Attributes tab, create attributes of different types:
- For example :
- Site number (Number)
- Site address (Text)
- MOE (Text)
- Companies present (multiple choice)
In the Data tab of your new database, create a new resource under the name of "test site"
- You can now see that you are asked to fill in the different attributes of your "test site". These attributes will be requested for all the assets present in the construction site database.
Part 2:
- We will now create a sub-database.
- Create a new database, "Engines".
- Create the attributes:
- Engine brand (Text)
- Engine model (Text)
- Oil level (Number)
- Cable condition (choice A / B = good / bad)
- Overall condition (Multiple choice: Good / Average / Bad)
- Create a new resource in this database and name it Engine 1.
- Create a new database, "Asynchronous engines";
- Choose as "Mother database" the "Engines" database.
In the "Structure" tab of our new database, we can see that the attributes of the "Engines" base are already present and we can complete them by adding other attributes.
You can now practice connecting your forms to databases.