Database Properties
Database Type: MySQL - 5.6.41-84.1
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| BORH | 0 | 1 | 11 | 847 | Table | General information for boreholes |
| CITATION | 5 | 0 | 3 | 197 | Table | Citation table |
| CON_STGE | 1 | 1 | 6 | 48 | Table | General information for consolidation test stages |
| COND | 0 | 1 | 4 | 41846 | Table | Consolidation test stage data |
| CONG | 1 | 1 | 9 | 9 | Table | Table for the general metadata of a consolidation test |
| CREO | 0 | 1 | 2 | 821 | Table | Observation creator |
| CRES | 0 | 1 | 2 | 597 | Table | Site creator |
| CRET | 0 | 1 | 2 | 2840 | Table | Test creator |
| DETL | 0 | 1 | 4 | 783 | Table | Within-layer Description |
| DSSD1D | 0 | 1 | 7 | 1138830 | Table | Direct simple shear test data in one dimension |
| DSSD2D | 0 | 1 | 9 | 0 | Table | Direct simple shear test data in one dimension |
| DSSG | 1 | 1 | 7 | 65 | Table | General information for direct simple shear test |
| DSSS | 2 | 1 | 7 | 115 | Table | Direct simple shear test stages |
| EVNT | 3 | 0 | 20 | 608 | Table | General information for earthquake events |
| FILE | 5 | 0 | 6 | 2432 | Table | Table storing supplemental files |
| FILE_EXT | 0 | 1 | 4 | 2 | Table | Large file table (>16MB) |
| FLDD | 0 | 1 | 9 | 2912 | Table | Displacement vectors |
| FLDF | 0 | 2 | 6 | 580 | Table | General information of supplemental files associated with an observation |
| FLDM | 0 | 1 | 12 | 3240 | Table | Liquefaction manifestation |
| FLDO | 8 | 2 | 6 | 527 | Table | General information for field observation |
| FLDP | 0 | 2 | 3 | 1236 | Table | Junction table between citation and observation |
| GIND | 0 | 1 | 5 | 2972 | Table | Invasive Geophysical Investigation - Data |
| GINV | 1 | 1 | 7 | 125 | Table | General information for geophysical investigation |
| GMIM | 0 | 1 | 10 | 1007 | Table | Ground Motion Intensity Measure recorded or estimated at a site |
| GMIM_COMP | 0 | 0 | 2 | 10 | Table | |
| GMIM_TYPE | 0 | 0 | 2 | 118 | Table | |
| GRAG | 1 | 1 | 4 | 4383 | Table | General information for particle size distribution test |
| GRAT | 0 | 1 | 4 | 21231 | Table | Particle Size Distribution - Data |
| GSWD | 0 | 1 | 4 | 11240 | Table | Surface Wave Geophysical Test - Dispersion Curve |
| GSWG | 2 | 1 | 7 | 38 | Table | General information and configuration for surface wave geophysical test |
| IM | 0 | 2 | 125 | 20790 | Table | Recorded Intensity Measure |
| INDX | 0 | 1 | 9 | 4059 | Table | Index Tests |
| ISPT | 0 | 1 | 9 | 7956 | Table | Standard Penetration Test Results |
| LAB | 1 | 1 | 6 | 7 | Table | Lab general information |
| LAB_PROGRAM | 3 | 1 | 3 | 9 | Table | Lab program table |
| LAB_PROGRAM_SAMP | 0 | 2 | 3 | 106 | Table | Lab program and sample junction table |
| LAB_PROGRAM_USER | 0 | 2 | 3 | 12 | Table | Lab program and user junction table |
| LAB_PROGRAMP | 0 | 2 | 3 | 3 | Table | |
| OBSC | 0 | 2 | 5 | 172 | Table | Observation Comment |
| OBSM | 1 | 2 | 3 | 834 | Table | Observation member information |
| OBSR | 0 | 2 | 3 | 439 | Table | Observation Reviewer |
| OTHF | 0 | 1 | 7 | 0 | Table | Other Field Tests |
| OTHR | 0 | 2 | 6 | 31 | Table | Other Laboratory Tests |
| password_resets | 1 | 0 | 4 | 75 | Table | Password Reset |
| PERM | 0 | 1 | 5 | 290 | Table | Permissions |
| phinxlog | 0 | 0 | 5 | 9 | Table | Version log |
| PLAS | 0 | 1 | 6 | 1385 | Table | Atterberg Limits |
| RDEN | 0 | 1 | 6 | 77 | Table | Relative Density |
| SAMF | 0 | 2 | 4 | 0 | Table | Associated Files for Laboratory Tests |
| SAMP | 5 | 0 | 10 | 11439 | Table | General information for sample |