Kelvin Tan wrote: > > You're probably right. But I was just fooling around with Torque to > familiarize myself with it. > > The thing is, I anticipate some difficulty mapping my inheritance hierachies > to Torque. Say that a particular column in table Foo can actually contain > the primary key of one of two (or more) tables. How would one represent this > in the Torque schema? > > Anyhow, if the feature of having multiple foreign keys is not supported, the > OM generator/parser should probably complain at the build stage.
I do not know how you can have one column that contains foreign keys to two different columns, whether they are in the same table or not. What db supports this and what is the sql syntax? How do you know if a particular entry contains data related to a particular column? You are free to do something like this and write code to figure out the logic, but I do not see how you can describe it in a relational way, so that torque or any other OR-mapping tool could handle it automatically. john mcnally -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
