TESF

1455 rows


Description

General information of supplemental files associated with a test

Columns

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

Unique ID (primary key) for entries in the TESF table
TEST_ID INT UNSIGNED 10 √ null
TEST.TEST_ID TESF_ibfk_1C
TESF_DESC VARCHAR 1000 √ null

Detailed description of the associated file (e.g., original data, profile image)
FILE_ID INT UNSIGNED 10 √ null
FILE.FILE_ID TESF_ibfk_2C

Indexes

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

Relationships

Close relationships within degrees of separation