GSWG

38 rows


Description

General information and configuration for surface wave geophysical test

Columns

Column Type Size Nulls Auto Default Children Parents Comments
GSWG_ID INT UNSIGNED 10 √ null
GSWD.GSWG_ID GSWD_ibfk_1C
SWVG.GSWG_ID SWVG_ibfk_1C

Unique ID (primary key) for entries in the GSWG table
TEST_ID INT UNSIGNED 10 √ null
TEST.TEST_ID GSWG_ibfk_1C
GSWG_TYPE VARCHAR 50 √ null

Test type (e.g., SASW, MASW, Other)
GSWG_CONF VARCHAR 1000 √ null

Test configuration
GSWG_CREW VARCHAR 100 √ null

Name of logger / organization
GSWG_STAR DATETIME 19 √ null

Start date of activity
GSWG_ENDD DATETIME 19 √ null

End date of activity

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc GSWG_ID
TEST_ID Performance Asc TEST_ID

Relationships

Close relationships within degrees of separation