| objid | prt_prt_role | objid | Prt_prt_role internal record number | 3 (UNIQUE) |
| role | prt_prt_role | role_name | Role names played by parts to one another | |
| sp_role_objid | sp_role(site_part) | objid | Site_part_role internal record number | |
| sp_player_objid | sp_player(site_part) | objid | Site_part_player internal record number | |
| sp_role_inst_name | sp_role(site_part) | instance_name | Default is the concatenation of part name, part number, and part revision. May be customized | |
| sp_player_inst_name | sp_player(site_part) | instance_name | Default is the concatenation of part name, part number, and part revision. May be customized | |
| sp_role_inst_id | sp_role(site_part) | instance_id | Part unique instance id | |
| sp_player_inst_id | sp_player(site_part) | instance_id | Part player unique instance id | |
| pn_role_part_num | pn_role(part_num) | part_number | Part number | |
| pn_player_part_num | pn_player(part_num) | part_number | Player part number | |
| pn_role_family | pn_role(part_num) | family | Marketing product family the part belongs to. This is a user-defined popup with default name FAMILY and level name lev1 | |
| pn_player_family | pn_player(part_num) | family | Marketing product family the player part belongs to. This is a user-defined popup with default name FAMILY and level name lev1 | |
| pn_role_line | pn_role(part_num) | line | Marketing product line, within family, of the part. This is a user-defined popup with default name FAMILY and level name lev2 | |
| pn_player_line | pn_player(part_num) | line | Marketing product line, within family, of the part. This is a user-defined popup with default name FAMILY and level name lev2 | |