db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Watzek <mwa.t...@spree.de>
Subject Table "project_member"
Date Wed, 27 Jul 2005 13:17:57 GMT
Hi Michelle,

another question concerning the schema: Table 
"applicationidentity0.project_member" does not specify "REFERENCE" 
clauses of its columns but table "datastoreidentity0.project_member" does:

applicationidentity0:

CREATE TABLE project_member (
     PROJID INTEGER NOT NULL,
     MEMBER INTEGER NOT NULL
);


datastoreidentity0:

CREATE TABLE project_member (
     PROJID INTEGER REFERENCES projects NOT NULL,
     MEMBER INTEGER REFERENCES persons NOT NULL
);

I suggest to add "REFERENCE" clauses to table 
applicationidentity0.project_member.

Regards,
Michael
-- 
-------------------------------------------------------------------
Michael Watzek                  Tech@Spree Engineering GmbH
mailto:mwa.tech@spree.de        Buelowstr. 66
Tel.:  ++49/30/235 520 36       10783 Berlin - Germany
Fax.:  ++49/30/217 520 12       http://www.spree.de/
-------------------------------------------------------------------

Mime
View raw message