LAB_PROGRAM

9 rows


Description

Lab program table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
LAB_PROGRAM_ID INT UNSIGNED 10 √ null
LAB_PROGRAM_SAMP.LAB_PROGRAM_ID LAB_PROGRAM_SAMP_ibfk_1C
LAB_PROGRAM_USER.LAB_PROGRAM_ID LAB_PROGRAM_USER_ibfk_1R
LAB_PROGRAMP.LAB_PROGRAM_ID LAB_PROGRAMP_ibfk_1R

Unique ID (primary key) for lab program
LAB_ID INT UNSIGNED 10 √ null
LAB.LAB_ID LAB_PROGRAM_ibfk_1C

Foreign key to lab table
LAB_PROGRAM_DESC VARCHAR 1000 √ null

Description of the lab program

Indexes

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

Relationships

Close relationships within degrees of separation