CREATE SCHEMA "MYSCHEMA";

CREATE TABLE "MYSCHEMA"."STAFF_TARGET" (
    "STAFFID"    VARCHAR(10)  NOT NULL,
    "LASTCHANGE" DATE,
    "STAFFNAME"  VARCHAR(80),
    "MAIL"       VARCHAR(100)
);

ALTER TABLE "MYSCHEMA"."STAFF_TARGET" ADD CONSTRAINT "STAFF_TARGET_PK" PRIMARY KEY ("STAFFID");