Lightspeed FK pb

/*==============================================================*/
/* Table : PROJECT                                              */
/*==============================================================*/
CREATE TABLE PROJECT (
   PROJECTID            SERIAL               NOT NULL,
   PROJECTNAME          CHAR(256)            NOT NULL,
   ROLEID               INT4                 NOT NULL,
   PROJECTCLIENTNAME    CHAR(256)            NOT NULL,
   PROJECTPLANNEDSTARTDATE DATE                 NOT NULL,
   PROJECTPLANNEDENDDATE DATE                 NOT NULL,
   PROJECTBUDGET        DECIMAL              NOT NULL,
   CONSTRAINT PK_PROJECT PRIMARY KEY (PROJECTID, PROJECTNAME)
);

/*==============================================================*/
/* Index : PROJECT_PK                                           */
/*==============================================================*/
CREATE UNIQUE INDEX PROJECT_PK ON PROJECT (
PROJECTID,
PROJECTNAME
);

/*==============================================================*/
/* Index : MANAGES_FK                                           */
/*==============================================================*/
CREATE  INDEX MANAGES_FK ON PROJECT (
ROLEID
);

/*==============================================================*/
/* Table : PROJECTBATCH                                         */
/*==============================================================*/
CREATE TABLE PROJECTBATCH (
   PROJECBATCHID        SERIAL               NOT NULL,
   ROLEID               INT4                 NOT NULL,
   ACTIVITYID           INT4                 NOT NULL,
   PROJECTID            INT4                 NOT NULL,
   PROJECTNAME          CHAR(256)            NOT NULL,
   PROJECBATCHNUMBER    INT4                 NULL,
   PROJECBATCHNAME      CHAR(256)            NULL,
   PROJECBATCHBEGININGDATE DATE                 NULL,
   PROJECBATCHENDDATE   DATE                 NULL,
   PROJECBATCHLOAD      INT4                 NULL,
   PROJECBATCHBUDGET    INT4                 NULL,
   PROJECBATCHSTATUS    VARCHAR(10)          NULL,
   CONSTRAINT PK_PROJECTBATCH PRIMARY KEY (PROJECBATCHID)
);

/*==============================================================*/
/* Index : PROJECTBATCH_PK                                      */
/*==============================================================*/
CREATE UNIQUE INDEX PROJECTBATCH_PK ON PROJECTBATCH (
PROJECBATCHID
);


/* Further in the script generated By PowerDesigner I have */

ALTER TABLE PROJECT
   ADD CONSTRAINT FK_PROJECT_MANAGES_ROLE FOREIGN KEY (ROLEID)
      REFERENCES ROLE (ROLEID)
      ON DELETE RESTRICT ON UPDATE RESTRICT;

ALTER TABLE PROJECTBATCH
   ADD CONSTRAINT FK_PROJECTB_DECOMPOSE_PROJECT FOREIGN KEY (PROJECTID, PROJECTNAME)
      REFERENCES PROJECT (PROJECTID, PROJECTNAME)
      ON DELETE RESTRICT ON UPDATE RESTRICT;

ALTER TABLE PROJECTBATCH
   ADD CONSTRAINT FK_PROJECTB_INCLUDE_A_MAINACTI FOREIGN KEY (ACTIVITYID)
      REFERENCES MAINACTIVITY (ACTIVITYID)
      ON DELETE RESTRICT ON UPDATE RESTRICT;

ALTER TABLE PROJECTBATCH
   ADD CONSTRAINT FK_PROJECTB_RESPONSIB_ROLE FOREIGN KEY (ROLEID)
      REFERENCES ROLE (ROLEID)
      ON DELETE RESTRICT ON UPDATE RESTRICT;