@PHONTOD

CREATE TABLE "PHCMEF"
(
  "CODEMP"	 VARCHAR(3) NOT NULL,
  "CODCAD"	 VARCHAR(7) NOT NULL,
  "SEQUEN"       VARCHAR(4) NOT NULL, 
  "DATINI"	 VARCHAR(10), 
  "DATFIN"	 VARCHAR(10),
  "CODEVE"	 VARCHAR(4), 
  "QUANTI"	 VARCHAR(5),
  "DESCR1"	 VARCHAR(40),
  "DESCR2"	 VARCHAR(40),
 PRIMARY KEY ("CODEMP", "CODCAD", "SEQUEN")
);

@EXECSQL


CREATE TABLE "PHCTMO" 
(
  "CODEMP"	 VARCHAR(3) NOT NULL,
  "CODCAD"     VARCHAR(7) NOT NULL,
  "SEQUEN"     VARCHAR(4)  NOT NULL, 
  "DATINI"	 VARCHAR(10),
  "DATFIN"	 VARCHAR(10),
  "TIPTUR"	 VARCHAR(1),
  "CODTUR"	 VARCHAR(4),
  "DESCRI"	 VARCHAR(40),
 PRIMARY KEY ("CODEMP", "CODCAD", "SEQUEN")
);
@EXECSQL

CREATE TABLE "PHMMEO" 
(
  "CODEMP"	 VARCHAR(3) NOT NULL,
  "SEQUEN"      VARCHAR(4) NOT NULL, 
  "DATINI"	 VARCHAR(10), 
  "DATFIN"	 VARCHAR(10),
  "CODEVE"	 VARCHAR(4), 
  "QUANTI"	 VARCHAR(5),
  "DESCRI"	 VARCHAR(60),
  "NIVEL1"	 VARCHAR(5),
  "NIVEL2"	 VARCHAR(5),
  "NIVEL3"	 VARCHAR(5),
  "NIVEL4"	 VARCHAR(5),
 PRIMARY KEY ("CODEMP", "SEQUEN")
);

@EXECSQL

CREATE TABLE "PHMMEB" 
(
  "CODEMP"	 VARCHAR(3) NOT NULL,
  "SEQUEN"     VARCHAR(4) NOT NULL, 
  "DATINI"	 VARCHAR(10),
  "DATFIN"	 VARCHAR(10),
  "CODEVE"	 VARCHAR(4), 
  "QUANTI"	 VARCHAR(5),
  "DESCRI"	 VARCHAR(60),
  "NIVEL1"	 VARCHAR(5),
  "NIVEL2"	 VARCHAR(5),
  "NIVEL3"	 VARCHAR(5),
  "NIVEL4"	 VARCHAR(5),
 PRIMARY KEY ("CODEMP", "SEQUEN")
);

@EXECSQL
