Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ISPT_ID | INT UNSIGNED | 10 | √ | null |
|
|
Unique ID (primary key) for entries in the ISPT table |
|||
| SAMP_ID | INT UNSIGNED | 10 | √ | null |
|
|
||||
| ISPT_TOP | FLOAT | 12 | √ | null |
|
|
Depth of the top of main blows in m |
|||
| ISPT_RODL | FLOAT | 12 | √ | null |
|
|
Rod length in m |
|||
| ISPT_TPEN | FLOAT | 12 | √ | null |
|
|
Penetration depth from depth top in cm (main drive only; e.g., 30 cm) |
|||
| ISPT_NVAL | INT | 10 | √ | null |
|
|
Number of blow counts for main drive |
|||
| ISPT_ERAT | FLOAT | 12 | √ | null |
|
|
Hammer drop energy ratio (%) |
|||
| ISPT_EMET | VARCHAR | 1000 | √ | null |
|
|
Method used to define the energy ratio value |
|||
| ISPT_REM | VARCHAR | 1000 | √ | null |
|
|
Remarks |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | ISPT_ID |
| SAMP_ID | Performance | Asc | SAMP_ID |
Relationships
Close relationships within degrees of separation
