Slot requirement for modules

From EVEDev

SELECT TRIM(effect.effectName) AS slot
FROM invTypes AS type
     INNER JOIN dgmTypeEffects AS typeEffect
       ON type.typeID = typeEffect.typeID
     INNER JOIN dgmEffects AS effect
       ON typeEffect.effectID = effect.effectID
WHERE effect.effectName IN ('loPower', 'medPower', 'hiPower', 'rigSlot')
  AND type.typeName = <module name>;

Example:

eve_trinity=>
SELECT TRIM(effect.effectName) AS slot
FROM invTypes AS type
     INNER JOIN dgmTypeEffects AS typeEffect
       ON type.typeID = typeEffect.typeID
     INNER JOIN dgmEffects AS effect
       ON typeEffect.effectID = effect.effectID
WHERE effect.effectName IN ('loPower', 'medPower', 'hiPower', 'rigSlot')
  AND type.typeName = 'Warp Disruptor II';

    slot
----------
 medPower
(1 row)