LAB_PROGRAM_SAMP

106 rows


Description

Lab program and sample junction table

Columns

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

primary key
LAB_PROGRAM_ID INT UNSIGNED 10 √ null
LAB_PROGRAM.LAB_PROGRAM_ID LAB_PROGRAM_SAMP_ibfk_1C

foreign key to lab program table
SAMP_ID INT UNSIGNED 10 √ null
SAMP.SAMP_ID LAB_PROGRAM_SAMP_ibfk_2C

foreign key to sample table

Indexes

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

Relationships

Close relationships within degrees of separation