Re: Table "project_member"

[Michelle Caisse]

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