Fig. 6 presents the schema of the cloud DB that depicts the relationship between tables and their attributes defined for this project.
The main table in the DB is the Spool table, which stores various data on each spool to be produced and installed, including data for design (e.g. specification and drawing) and manufacturing (e.g. material and conditions).
A number of spools are assigned to a job (project) whose start and end dates and related documentations are stored in the Jobs table.