TR_PPTO

Tables

TR_PPTO

Description

PRESUPUESTO - DETALLE MOVIMIENTO

Fields

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

Triggers

(There are no triggers for table TR_PPTO)

Indices

Index	Fields	Order
FK_TR_PPTO_1	CODPPTO	ASC
FK_TR_PPTO_2	CODP_PPTO	ASC
FK_TR_PPTO_3	CODCENTRO	ASC
PK_TR_PPTO	ITEM	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
PPTO	FK_TR_PPTO_1	CODPPTO	CODIGO	NO ACTION	CASCADE
P_PPTO	FK_TR_PPTO_2	CODP_PPTO	CODIGO	NO ACTION	CASCADE
CENTROS	FK_TR_PPTO_3	CODCENTRO	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table TR_PPTO)

Definition

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


ALTER TABLE TR_PPTO ADD CONSTRAINT PK_TR_PPTO PRIMARY KEY (ITEM);
ALTER TABLE TR_PPTO ADD CONSTRAINT FK_TR_PPTO_1 FOREIGN KEY (CODPPTO) REFERENCES PPTO (CODIGO) ON UPDATE CASCADE;
ALTER TABLE TR_PPTO ADD CONSTRAINT FK_TR_PPTO_2 FOREIGN KEY (CODP_PPTO) REFERENCES P_PPTO (CODIGO) ON UPDATE CASCADE;
ALTER TABLE TR_PPTO ADD CONSTRAINT FK_TR_PPTO_3 FOREIGN KEY (CODCENTRO) REFERENCES CENTROS (CODIGO) ON UPDATE CASCADE;