db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michelle Caisse <Michelle.Cai...@Sun.COM>
Subject Re: Table "project_member"
Date Wed, 27 Jul 2005 16:29:49 GMT
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



Mime
View raw message