SAMF

0 rows


Description

Associated Files for Laboratory Tests

Columns

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

Unique ID (primary key) for entries in the SAMF table
SAMP_ID INT UNSIGNED 10 √ null
SAMP.SAMP_ID SAMF_ibfk_1C
SAMF_DESC VARCHAR 1000 √ null

Detailed description of the associated file (e.g., lab test report, charts, test photos)
FILE_ID INT UNSIGNED 10 √ null
FILE.FILE_ID SAMF_ibfk_2C

Indexes

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

Relationships

Close relationships within degrees of separation