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 |
|---|---|---|---|