TR_RP

Tables

TR_RP

Description

REGISTRO PRESUPUESTAL - DETALLE MOVIMIENTO

Fields

Field	Type	Default
ITEM	INTEGER
CODRP	CHAR(20)
CODP_PPTO	CHAR(30)
CODCENTRO	CHAR(5)
VALOR	NUMERIC(17,4)	0
NOTA	VARCHAR(1000)

Triggers

(There are no triggers for table TR_RP)

Indices

Index	Fields	Order
FK_TR_RP_1	CODRP	ASC
FK_TR_RP_2	CODP_PPTO	ASC
FK_TR_RP_3	CODCENTRO	ASC
PK_TR_RP	ITEM	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
RP	FK_TR_RP_1	CODRP	CODIGO	NO ACTION	CASCADE
P_PPTO	FK_TR_RP_2	CODP_PPTO	CODIGO	NO ACTION	CASCADE
CENTROS	FK_TR_RP_3	CODCENTRO	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table TR_RP)

Definition

CREATE TABLE TR_RP (
    ITEM       INTEGER NOT NULL,
    CODRP      CHAR(20) NOT NULL,
    CODP_PPTO  CHAR(30) NOT NULL,
    CODCENTRO  CHAR(5) NOT NULL,
    VALOR      NUMERIC(17,4) DEFAULT 0,
    NOTA       VARCHAR(1000)
);


ALTER TABLE TR_RP ADD CONSTRAINT PK_TR_RP PRIMARY KEY (ITEM);
ALTER TABLE TR_RP ADD CONSTRAINT FK_TR_RP_1 FOREIGN KEY (CODRP) REFERENCES RP (CODIGO) ON UPDATE CASCADE;
ALTER TABLE TR_RP ADD CONSTRAINT FK_TR_RP_2 FOREIGN KEY (CODP_PPTO) REFERENCES P_PPTO (CODIGO) ON UPDATE CASCADE;
ALTER TABLE TR_RP ADD CONSTRAINT FK_TR_RP_3 FOREIGN KEY (CODCENTRO) REFERENCES CENTROS (CODIGO) ON UPDATE CASCADE;