CREATE TABLE TEST.PERSON
(
   ID           INTEGER NOT NULL,
   SECURITYID   INTEGER NOT NULL,
   NAME         VARCHAR (30) NOT NULL,
   SEX          CHAR (1) NOT NULL
);
CREATE TABLE TEST.SECURITY
(
   SECURITYID     INTEGER NOT NULL,
   SECURITYINFO   VARCHAR (200)
);
ALTER TABLE "TEST"."PERSON" ADD PRIMARY KEY("ID");

CREATE UNIQUE INDEX TEST.UK1_PERSON ON TEST.PERSON(SECURITYID);

ALTER TABLE "TEST"."SECURITY" ADD PRIMARY KEY("SECURITYID");

ALTER TABLE "TEST"."PERSON"
  ADD CONSTRAINT "FK_PERSON_SECURITY" FOREIGN KEY
    ("SECURITYID")
  REFERENCES "TEST"."SECURITY"
    ("SECURITYID")
    ON DELETE CASCADE
    ON UPDATE RESTRICT
    ENFORCED
    ENABLE QUERY OPTIMIZATION;