@PHOLHAD
CREATE TABLE "PHWPRT1"
(
  "CODEMP"	 VARCHAR(4) NOT NULL,
  "NUMPRT"	 VARCHAR(8) NOT NULL,
  "DATGER"	 VARCHAR(10),
  "HORGER"	 VARCHAR(6),
  "OBSGER"	 VARCHAR(50),
  "DATENT"	 VARCHAR(10),
  "HORENT"	 VARCHAR(6),
  "NOMENT"       VARCHAR(20),
  "OBSENT"	 VARCHAR(50),
 PRIMARY KEY ("CODEMP", "NUMPRT")
);
@EXESQL

@PHOLHAD
CREATE TABLE "PHWPRT2"
(
  "CODEMP"	 VARCHAR(4) NOT NULL,
  "NUMPRT"	 VARCHAR(8) NOT NULL,
  "GRUREL"	 VARCHAR(4) NOT NULL,
  "CODREL"	 VARCHAR(12) NOT NULL,
  "SEQREL"	 VARCHAR(4) NOT NULL,
  "CODCAD"	 VARCHAR(10) NOT NULL,
  "PERREF"	 VARCHAR(8) NOT NULL,
  "GERREG"	 VARCHAR(4),
  "NOMREL"	 VARCHAR(100),
  "DATEMI"	 VARCHAR(10),
  "HOREMI"	 VARCHAR(6),
  "OBSEMI"	 VARCHAR(50),
  "DATENT"	 VARCHAR(10),
  "HORENT"	 VARCHAR(6),
  "OBSENT"	 VARCHAR(50),
  "OBSERV"	 VARCHAR(80),
  "VALDOC"       VARCHAR(15),
 PRIMARY KEY ("CODEMP", "NUMPRT", "GRUREL", "CODREL", "SEQREL", "CODCAD", "PERREF")
);
@EXESQL
