[Chogo]

Estas son la sentencias SQL

Código SQL [-]

CREATE TABLE DETALLE_PLANILLA 
(
  ID_REG                          BIGINT         DEFAULT 0 NOT NULL,
  ID_PLANILLA                    INTEGER         NOT NULL,
  CODEMPLEADO                    INTEGER         DEFAULT 0 NOT NULL,
  IDENTIDAD                      VARCHAR(    20)  COLLATE NONE,
  PROMEDIO_SEMANA                NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  HORAS_NOR                      NUMERIC(  3, 2) DEFAULT 0 NOT NULL,
  TOTAL_VALOR_NOR                NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  HORAS_EXT1                     NUMERIC(  3, 2) DEFAULT 0 NOT NULL,
  HORAS_EXT2                     NUMERIC(  3, 2) DEFAULT 0 NOT NULL,
  HORAS_EXT3                     NUMERIC(  3, 2) DEFAULT 0 NOT NULL,
  VALOR_EXT1                     NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  VALOR_EXT2                     NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  VALOR_EXT3                     NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  TOTAL_VALOR_EXT                NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  FERIADO                        NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  AJUSTE                         NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  BONO                           NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  SABADO                         NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  DOMINGO                        NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  BRUTO                          NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  IHSS                           NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  ISR                            NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  TOTAL_DEDUC                    NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  PAGO_NETO                      NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  PAGO_NETO_REDONDO              NUMERIC( 12, 2) DEFAULT 0 NOT NULL,
  IDLINEA                        INTEGER         NOT NULL,
  IHSS_EMP                       NUMERIC( 12, 2) DEFAULT 0.0 NOT NULL,
 CONSTRAINT PK_DETALLE_PLANILLA PRIMARY KEY (ID_REG)
);

ALTER TABLE DETALLE_PLANILLA ADD CONSTRAINT FK_DETALLE_PLANILLA 
  FOREIGN KEY (ID_PLANILLA) REFERENCES MAESTRO_PLANILLA
  (ID_PLANILLA) 
  ON DELETE NO ACTION
  ON UPDATE CASCADE
;

ALTER TABLE DETALLE_PLANILLA ADD CONSTRAINT FK_DETALLE_PLANILLA1 
  FOREIGN KEY (IDLINEA) REFERENCES LINEA
  (IDLINEA) 
  ON DELETE NO ACTION
  ON UPDATE CASCADE
;

ALTER TABLE DETALLE_PLANILLA ADD CONSTRAINT FK_DETALLE_PLANIL_EMPLEADOS 
  FOREIGN KEY (CODEMPLEADO) REFERENCES EMPLEADOS
  (CODEMPLEADO) 
  ON DELETE NO ACTION
  ON UPDATE CASCADE
;

CREATE ASC INDEX IDX_CODEMPLEADO ON DETALLE_PLANILLA (CODEMPLEADO);

CREATE ASC INDEX IDX_IDENTIDAD ON DETALLE_PLANILLA (IDENTIDAD);