Debo usar Tabla Recursiva?... con clave foranea?

[ane_aaron]

1. Si
2. No necesariamente, el jefe tendria PF2_ID = 'NULL' no?
3.

Código:

ALTER TABLE `TR` ADD KEY (`PF2_ID`); 
    
ALTER TABLE `TR` ADD FOREIGN KEY `PF2_ID` REFERENCES `TR` (`PF_ID`) ON UPDATE CASCADE ON DELETE CASCADE;

4. NO
5. No,

Código:

ALTER TABLE `TR` ADD KEY (`PF_ID`); 
    
ALTER TABLE `TR` ADD FOREIGN KEY `PF_ID` REFERENCES `PF` (`PF_ID`) ON UPDATE CASCADE ON DELETE CASCADE;

Saludos sudas ya sabes OK