You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-dev@db.apache.org by Michael Watzek <mw...@spree.de> on 2005/07/27 15:17:57 UTC

Table "project_member"

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/
-------------------------------------------------------------------

Re: Table "project_member"

Posted by Michelle Caisse <Mi...@Sun.COM>.
Hi Michael,

I fixed these problems.

Thanks,
Michelle

Michael Watzek wrote:

> 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