Database Structure

Below you can see the database structure for uploading rutting test results, indirect tensile strength and Marshall test results. The database also includes fields for uploading the component material properties and the mixture recipe.

In the future we will add other tests to the AsphaltMine.

To see the upload form that mimics this structure, go here. If you have feedback about the structure, please contact Martins Zaumanis.

 

 

 

We ask you to fill as many fields as you can, but we know that for a given lab test most of the fields will remain empty.
  1. The fields shown in red are mandatory.
  2. The fields shown in green are mutually exclusive choices; only one of the choices can be selected and filled.
  3. The following fields are semi-mandatory:
    1. For Grain Size Distribution, fill at least one of the size distributions.
    2. For Binder Content, fill at least one of the following: Binder Content in Mixture Recipe or Binder Content of Recovered Binder.
    3. For Penetration, fill at least one of the following: Virgin Binder Penetration or Recovered Binder Penetration.
    4. For Voids, fill at least one of the following: Bulk density with Maximum density or Air voids.

Find full description of the fields and standard numbers in the upload from.

This is still a draft. All suggestions are welcomed.
Full Database Tree Structure