CREATE TABLE RCPPRNDEV (
    ID        FID /* FID = INTEGER NOT NULL */,
    DEVICEID  FINT NOT NULL /* FINT = INTEGER */
);
/******************************************************************************/
/***                              Primary Keys                              ***/
/******************************************************************************/
ALTER TABLE RCPPRNDEV ADD CONSTRAINT PRI_RCPPRNDEV PRIMARY KEY (ID);

/******************************************************************************/
/***                              Foreign Keys                              ***/
/******************************************************************************/
ALTER TABLE RCPPRNDEV ADD CONSTRAINT FK_RCPPRNDEV_DEVICEID FOREIGN KEY (DEVICEID) REFERENCES DEVICES (ID) ON DELETE CASCADE;