Contract_2_Personnel

Join table that associates a funding source to the personnel who received the funding.

Columns
Name Type Description Foreign Key
contract_grant_id int(11) Foreign key reference to CONTRACT_GRANT table contract_grant.contract_grant_id
personnel_id int(11) Foreign key reference to PERSONNEL table personnel.personnel_id
role_type varchar(12) Role for personnel lk_user_role_type.name
Indexes
Name Column Description
PRIMARY contract_grant_id BTREE
PRIMARY personnel_id BTREE
idx_contract_2_personnel personnel_id BTREE
idx_contract_2_personnel contract_grant_id BTREE
fk_contract_2_personnel_3 role_type BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
Back to top