SAMP

11439 rows


Description

General information for sample

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SAMP_ID INT UNSIGNED 10 √ null
ISPT.SAMP_ID ISPT_ibfk_1C
LAB_PROGRAM_SAMP.SAMP_ID LAB_PROGRAM_SAMP_ibfk_2C
SAMF.SAMP_ID SAMF_ibfk_1C
SAMP_TEST.SAMP_ID SAMP_TEST_ibfk_1C
SPEC.SAMP_ID SPEC_ibfk_1C

Unique ID (primary key) for entries in the SAMP table
SAMP_NAME VARCHAR 64 √ null

Sample name
SAMP_TYPE VARCHAR 64 √ null

Sampler type (e.g., Shelby tube, Split-barrel (SPT), Bulk (test pit), CPT sampler)
SAMP_TOP FLOAT 12 √ null

Depth to the top of sample in m
SAMP_BASE FLOAT 12 √ null

Depth to the base of sample in m
SAMP_SDIA FLOAT 12 √ null

Sample diameter in mm
SAMP_DATE DATETIME 19 √ null

Date of sampling
SAMP_REC FLOAT 12 √ null

Sample recovery rate (%)
SAMP_DESC VARCHAR 1000 √ null

Sample soil description (e.g., gray silty clay)
SAMP_REM VARCHAR 1000 √ null

Remarks

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc SAMP_ID

Relationships

Close relationships within degrees of separation