Program_2_Personnel

Join table that associates PROGRAM and PERSONNEL.

Columns
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 lk_user_role_type.name
Indexes
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
Back to top