For a comprehensive understanding of the relationships within the Geotechnical XML Schema Definition, take a look at the Database Schema Relationships. We are building two example databases to demonstrate different approaches.
This example, donated by Geosetta.org, provides a great starting point for DIGGS compatibility. It includes various tools for importing, exporting, and visualizing DIGGS files. You can explore this simplified structure here: Simple Database Structure.
Our second example offers a more comprehensive structure donated by Nicholas Miller, designed to handle greater complexity while balancing flexibility and simplicity. This results in a larger number of tables but reduces complexity when importing, exporting, and generating data. Explore this robust example here: Robust Database Structure.
Both table structures can help you visualize different data storage methods and serve as a foundation for building your own custom implementations.
Feel free to explore the schema and contribute to further refining these data structures.