APORTES_PERSONAL

Tables

APORTES_PERSONAL

Description

(There is no description for table APORTES_PERSONAL)

Fields

Field	Type	Default
CODPERSONAL	CHAR(15)
RENGLON	INTEGER
CODTIPOAPORTE	CHAR(15)
DESDE	DATE
HASTA	DATE
ACTIVO	CHAR(1)	'S'

Triggers

(There are no triggers for table APORTES_PERSONAL)

Indices

Index	Fields	Order
FK_APORTES_PERSONAL_1	CODPERSONAL	ASC
FK_APORTES_PERSONAL_2	CODTIPOAPORTE	ASC
PK_APORTES_PERSONAL	CODPERSONAL, RENGLON	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
PERSONAL	FK_APORTES_PERSONAL_1	CODPERSONAL	CODIGO	NO ACTION	CASCADE
TIPOAPORTES	FK_APORTES_PERSONAL_2	CODTIPOAPORTE	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table APORTES_PERSONAL)

Definition

CREATE TABLE APORTES_PERSONAL (
    CODPERSONAL    CHAR(15) NOT NULL,
    RENGLON        INTEGER NOT NULL,
    CODTIPOAPORTE  CHAR(15) NOT NULL,
    DESDE          DATE,
    HASTA          DATE,
    ACTIVO         CHAR(1) DEFAULT 'S'
);


ALTER TABLE APORTES_PERSONAL ADD CONSTRAINT PK_APORTES_PERSONAL PRIMARY KEY (CODPERSONAL, RENGLON);
ALTER TABLE APORTES_PERSONAL ADD CONSTRAINT FK_APORTES_PERSONAL_1 FOREIGN KEY (CODPERSONAL) REFERENCES PERSONAL (CODIGO) ON UPDATE CASCADE;
ALTER TABLE APORTES_PERSONAL ADD CONSTRAINT FK_APORTES_PERSONAL_2 FOREIGN KEY (CODTIPOAPORTE) REFERENCES TIPOAPORTES (CODIGO) ON UPDATE CASCADE;