PLANILLAS

Tables

PLANILLAS

Description

(There is no description for table PLANILLAS)

Fields

Field	Type	Default
CODNOMINA	CHAR(5)
CODESQNOMINA	CHAR(5)
CODPERSONAL	CHAR(15)
CODCENTRO	CHAR(5)
ORDEN	SMALLINT
CODRUBRO	CHAR(5)
PUBLICAR	CHAR(1)
VALOR	NUMERIC(17,4)	0
ADICION	NUMERIC(17,4)	0
DEDUCCION	NUMERIC(17,4)	0
TIPO	CHAR(10)

Triggers

(There are no triggers for table PLANILLAS)

Indices

Index	Fields	Order
FK_PLANILLAS_1	CODNOMINA	ASC
FK_PLANILLAS_2	CODESQNOMINA	ASC
FK_PLANILLAS_3	CODPERSONAL	ASC
FK_PLANILLAS_4	CODRUBRO	ASC
FK_PLANILLAS_5	CODCENTRO	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
NOMINAS	FK_PLANILLAS_1	CODNOMINA	CODIGO	NO ACTION	CASCADE
ESQNOMINA	FK_PLANILLAS_2	CODESQNOMINA	CODIGO	NO ACTION	CASCADE
PERSONAL	FK_PLANILLAS_3	CODPERSONAL	CODIGO	NO ACTION	CASCADE
RUBROS	FK_PLANILLAS_4	CODRUBRO	CODIGO	NO ACTION	CASCADE
CENTROS	FK_PLANILLAS_5	CODCENTRO	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table PLANILLAS)

Definition

CREATE TABLE PLANILLAS (
    CODNOMINA     CHAR(5) NOT NULL,
    CODESQNOMINA  CHAR(5) NOT NULL,
    CODPERSONAL   CHAR(15) NOT NULL,
    CODCENTRO     CHAR(5),
    ORDEN         SMALLINT NOT NULL,
    CODRUBRO      CHAR(5) NOT NULL,
    PUBLICAR      CHAR(1),
    VALOR         NUMERIC(17,4) DEFAULT 0,
    ADICION       NUMERIC(17,4) DEFAULT 0,
    DEDUCCION     NUMERIC(17,4) DEFAULT 0,
    TIPO          CHAR(10) NOT NULL
);


ALTER TABLE PLANILLAS ADD CONSTRAINT FK_PLANILLAS_1 FOREIGN KEY (CODNOMINA) REFERENCES NOMINAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE PLANILLAS ADD CONSTRAINT FK_PLANILLAS_2 FOREIGN KEY (CODESQNOMINA) REFERENCES ESQNOMINA (CODIGO) ON UPDATE CASCADE;
ALTER TABLE PLANILLAS ADD CONSTRAINT FK_PLANILLAS_3 FOREIGN KEY (CODPERSONAL) REFERENCES PERSONAL (CODIGO) ON UPDATE CASCADE;
ALTER TABLE PLANILLAS ADD CONSTRAINT FK_PLANILLAS_4 FOREIGN KEY (CODRUBRO) REFERENCES RUBROS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE PLANILLAS ADD CONSTRAINT FK_PLANILLAS_5 FOREIGN KEY (CODCENTRO) REFERENCES CENTROS (CODIGO) ON UPDATE CASCADE;