RECURSOS

Tables

RECURSOS

Description

(There is no description for table RECURSOS)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		ITEM		INTEGER
		CODLABOR		INTEGER
		CODREFERENCIA		CHAR(20)
		CANTIDAD		NUMERIC(17,4)

Triggers

(There are no triggers for table RECURSOS)

Indices

Index	Fields	Order
FK_RECURSOS_1	CODLABOR	ASC
FK_RECURSOS_2	CODREFERENCIA	ASC
PK_RECURSOS	ITEM	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
LABORES	FK_RECURSOS_1	CODLABOR	CODIGO	NO ACTION	CASCADE
REFERENCIAS	FK_RECURSOS_2	CODREFERENCIA	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table RECURSOS)

Definition

CREATE TABLE RECURSOS (
    ITEM           INTEGER NOT NULL,
    CODLABOR       INTEGER,
    CODREFERENCIA  CHAR(20),
    CANTIDAD       NUMERIC(17,4)
);


ALTER TABLE RECURSOS ADD CONSTRAINT PK_RECURSOS PRIMARY KEY (ITEM);
ALTER TABLE RECURSOS ADD CONSTRAINT FK_RECURSOS_1 FOREIGN KEY (CODLABOR) REFERENCES LABORES (CODIGO) ON UPDATE CASCADE;
ALTER TABLE RECURSOS ADD CONSTRAINT FK_RECURSOS_2 FOREIGN KEY (CODREFERENCIA) REFERENCES REFERENCIAS (CODIGO) ON UPDATE CASCADE;