SAMP_TEST

8460 rows


Description

Junction table between sample and test tables

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SAMP_TEST_ID INT UNSIGNED 10 √ null

Unique ID (primary key) for entries in the SAMP_TEST table
SAMP_ID INT UNSIGNED 10 √ null
SAMP.SAMP_ID SAMP_TEST_ibfk_1C

Sample table ID
TEST_ID INT UNSIGNED 10 √ null
TEST.TEST_ID SAMP_TEST_ibfk_2C

Test table ID

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc SAMP_TEST_ID
FLDO_ID Performance Asc TEST_ID
USER_ID Performance Asc SAMP_ID

Relationships

Close relationships within degrees of separation