Program_2_Personnel
Join table that associates PROGRAM and PERSONNEL.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| program_id | int | Foreign key to the PROGRAM table | program.program_id |
| personnel_id | int | Foreign key to the PERSONNEL table | personnel.personnel_id |
| role_type | varchar(2) | 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 |
|---|---|---|---|