LAB_PROGRAM_USER

12 rows


Description

Lab program and user junction table

Columns

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

Primary key
LAB_PROGRAM_ID INT UNSIGNED 10 √ null
LAB_PROGRAM.LAB_PROGRAM_ID LAB_PROGRAM_USER_ibfk_1R

Foreign key to lab program id
USER_ID INT UNSIGNED 10 √ null
USER.USER_ID LAB_PROGRAM_USER_ibfk_2C

Foreign key to user id

Indexes

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

Relationships

Close relationships within degrees of separation