Join table that associates PROGRAM and PERSONNEL.

Name Type Description Foreign Key
program_id int(11) Foreign key to the PROGRAM table program.program_id
personnel_id int(11) Foreign key to the PERSONNEL table personnel.personnel_id
role_type varchar(12) Role for personnel
Name Column Description
PRIMARY program_id BTREE
PRIMARY personnel_id BTREE
idx_program_2_personnel personnel_id BTREE
idx_program_2_personnel program_id BTREE
fk_program_2_personnel_3 role_type BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference