REG_ACTAS

Tables

REG_ACTAS

Description

(There is no description for table REG_ACTAS)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		ITEM		INTEGER
		CODACTA		INTEGER
		CODLABOR		INTEGER
		CODMEDIDA		CHAR(5)
		CANTIDAD		NUMERIC(17,4)
		VALOR		NUMERIC(17,4)
		DETALLE		CHAR(200)

Triggers

(There are no triggers for table REG_ACTAS)

Indices

Index	Fields	Order
FK_REG_ACTAS_1	CODACTA	ASC
FK_REG_ACTAS_2	CODLABOR	ASC
FK_REG_ACTAS_3	CODMEDIDA	ASC
PK_REG_ACTAS	ITEM	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
ACTAS	FK_REG_ACTAS_1	CODACTA	CODIGO	NO ACTION	CASCADE
LABORES	FK_REG_ACTAS_2	CODLABOR	CODIGO	NO ACTION	CASCADE
MEDIDAS	FK_REG_ACTAS_3	CODMEDIDA	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table REG_ACTAS)

Definition

CREATE TABLE REG_ACTAS (
    ITEM       INTEGER NOT NULL,
    CODACTA    INTEGER,
    CODLABOR   INTEGER,
    CODMEDIDA  CHAR(5),
    CANTIDAD   NUMERIC(17,4),
    VALOR      NUMERIC(17,4),
    DETALLE    CHAR(200)
);


ALTER TABLE REG_ACTAS ADD CONSTRAINT PK_REG_ACTAS PRIMARY KEY (ITEM);
ALTER TABLE REG_ACTAS ADD CONSTRAINT FK_REG_ACTAS_1 FOREIGN KEY (CODACTA) REFERENCES ACTAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_ACTAS ADD CONSTRAINT FK_REG_ACTAS_2 FOREIGN KEY (CODLABOR) REFERENCES LABORES (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_ACTAS ADD CONSTRAINT FK_REG_ACTAS_3 FOREIGN KEY (CODMEDIDA) REFERENCES MEDIDAS (CODIGO) ON UPDATE CASCADE;