SALARIOS

Tables

SALARIOS

Description

(There is no description for table SALARIOS)

Fields

Field	Type	Default
CODPERSONAL	CHAR(15)
RENGLON	INTEGER
BASICO	NUMERIC(17,4)	0
DESDE	DATE	CURRENT_DATE
HASTA	DATE
ACTIVO	CHAR(1)	'S'

Triggers

(There are no triggers for table SALARIOS)

Indices

Index	Fields	Active	Unique	Order
FK_SALARIOS_1	CODPERSONAL			ASC
PK_SALARIOS	CODPERSONAL, RENGLON			ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
PERSONAL	FK_SALARIOS_1	CODPERSONAL	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table SALARIOS)

Definition

CREATE TABLE SALARIOS (
    CODPERSONAL  CHAR(15) NOT NULL,
    RENGLON      INTEGER NOT NULL,
    BASICO       NUMERIC(17,4) DEFAULT 0,
    DESDE        DATE DEFAULT CURRENT_DATE NOT NULL,
    HASTA        DATE,
    ACTIVO       CHAR(1) DEFAULT 'S'
);


ALTER TABLE SALARIOS ADD CONSTRAINT PK_SALARIOS PRIMARY KEY (CODPERSONAL, RENGLON);
ALTER TABLE SALARIOS ADD CONSTRAINT FK_SALARIOS_1 FOREIGN KEY (CODPERSONAL) REFERENCES PERSONAL (CODIGO) ON UPDATE CASCADE;