Can anyone please answer my question on "SQLAlchemy ForeignKey relation via an intermediate table"

Question

No one is helping me. I am desperate. :(

The question is here:

http://stackoverflow.com/questions/2234030/sqlalchemy-foreignkey-relation-via-an-intermediate-table

Here is a copy of it:

Suppose that I have a table Articles, which has fields article_id, content and it contains one article with id 1.

I also have a table Categories, which has fields category_id (primary key), category_name, and it contains one category with id 10.

Now suppose that I have a table ArticleProperties, that adds properties to Articles. This table has fields article_id, property_name, property_value.

Suppose that I want to create a mapping from Categories to Articles via ArticleProperties table.

I do this by inserting the following values in the ArticleProperties table: (article_id=1, property_name="category", property_value=10).

Is there any way in SQLAlchemy to express that rows in table ArticleProperties with property_name "category" are actually FOREIGN KEYS of table Articles to table Categories?

This is a complicated problem and I haven't found an answer myself.

Any help appreciated!

Thanks, Boda Cydo.