drop table pladetpasivo;

CREATE TABLE PLADETPASIVO
(
  CIA            CHAR (3) NOT NULL,
  FECHASALIDA    DATE NOT NULL,
  EMPLEADO       VARCHAR2 (15) NOT NULL,
  FECHAINGRESO   DATE NOT NULL,
  MESESLABORADOS NUMBER (7,2) NOT NULL,
  SALARIO        NUMBER (14,2) NOT NULL,
  SALPROMDIA     NUMBER (14,2) NOT NULL,
  SALPROMVAC     NUMBER (14,2) NOT NULL,
  PERSEIS        NUMBER (4) NOT NULL,
  PERAGUINALDO   NUMBER (4) NOT NULL,
  PERSALIDA      NUMBER (4) NOT NULL,
  MONCESANTIA    NUMBER (14,2) NOT NULL,
  MONPREAVISO    NUMBER (14,2) NOT NULL,
  MONAGUINALDO   NUMBER (14,2) NOT NULL,
  MONVACACION    NUMBER (14,2) NOT NULL,
  MONAHOVAC      NUMBER (14,2) NOT NULL,
  MONAPOVAC      NUMBER (14,2) NOT NULL,
  MONAPOASO      NUMBER (14,2) NOT NULL,
  CONSTRAINT PLADETPASIVO_PK
     PRIMARY KEY(CIA, FECHASALIDA, EMPLEADO)
);

