So I have a table setup (I’m not wed to it) that looks like:
Words can have synonyms that all point back to the “root” word, and what I’d like to be able to do is to get the root word for a given word, and second find all synonyms for a given word.
Is there a relation I can setup that allows this?
So far I’ve tried:
‘root’=>array(self::BELONGS_TO, ‘Word’, ‘words(syn_id,word_id)’),
But I’ve had no luck. What setup can/should I be using to accomplish this?