Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| OTHR_ID | INT UNSIGNED | 10 | √ | null |
|
|
Unique ID (primary key) for entries in the OTHR table |
|||
| SPEC_ID | INT UNSIGNED | 10 | √ | null |
|
|
||||
| OTHR_NAME | VARCHAR | 100 | √ | null |
|
|
Name of the test uploaded |
|||
| OTHR_TYPE | VARCHAR | 50 | √ | null |
|
|
Test type (e.g., Consolidation, Triaxial-UU, Triaxial-CU, Triaxial, Triaxial-cyclic, Simple shear-monotonic, Simple shear-cyclic, Other) |
|||
| OTHR_DESC | VARCHAR | 1000 | √ | null |
|
|
Test description |
|||
| FILE_ID | INT UNSIGNED | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | OTHR_ID |
| FILE_ID | Performance | Asc | FILE_ID |
| SPEC_ID | Performance | Asc | SPEC_ID |
Relationships
Close relationships within degrees of separation
