Folks,
Does RDBO support defining a "some time" or "maybe" relationship?
Consider the following:
CREATE TABLE locations (
id INT,
...
);
CREATE TABLE companies (
id INT,
location_id INT NOT NULL
REFERENCES locations(id),
...
);
CREATE TABLE exhibitions (
id INT,
location_id INT NOT NULL
REFERENCES locations(id),
...
);
I have no problem creating the relationship from Company and Exhibition
to Location.
What I'd like to create is a "company" relationship in Exhibition that
returns the Company that has the same location_id as itself. It is of
course conceivable that a given exhibition has a location_id not used by
a Company so there would be no Company object to return.
Likewise, I'd like an "exhibitions" relationship in Company that returns
all the exhibitions that have the same location_id as the company.
I'm not sure if RDBO supports this, and if it does, how to formulate the
syntax.
Thank you.
-- Robert
--
Robert James Kaes WormBytes Consulting and Contracting
http://tinyproxy.sourceforge.net/ http://www.wormbytes.ca/
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rose-db-object
