TARIFAS_INSUMOS

Tables

TARIFAS_INSUMOS

Description

(There is no description for table TARIFAS_INSUMOS)

Fields

Field	Type	Default
CODTARIFA	CHAR(15)
CODINSUMO	CHAR(15)
VALOR	NUMERIC(17,4)	0
OTROCODIGO	CHAR(15)

Triggers

(There are no triggers for table TARIFAS_INSUMOS)

Indices

Index	Fields	Order
FK_TARIFAS_INSUMOS_1	CODTARIFA	ASC
FK_TARIFAS_INSUMOS_2	CODINSUMO	ASC
PK_TARIFAS_INSUMOS	CODTARIFA, CODINSUMO	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
TARIFAS	FK_TARIFAS_INSUMOS_1	CODTARIFA	CODIGO	NO ACTION	CASCADE
INSUMOS	FK_TARIFAS_INSUMOS_2	CODINSUMO	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table TARIFAS_INSUMOS)

Definition

CREATE TABLE TARIFAS_INSUMOS (
    CODTARIFA   CHAR(15) NOT NULL,
    CODINSUMO   CHAR(15) NOT NULL,
    VALOR       NUMERIC(17,4) DEFAULT 0,
    OTROCODIGO  CHAR(15)
);


ALTER TABLE TARIFAS_INSUMOS ADD CONSTRAINT PK_TARIFAS_INSUMOS PRIMARY KEY (CODTARIFA, CODINSUMO);
ALTER TABLE TARIFAS_INSUMOS ADD CONSTRAINT FK_TARIFAS_INSUMOS_1 FOREIGN KEY (CODTARIFA) REFERENCES TARIFAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE TARIFAS_INSUMOS ADD CONSTRAINT FK_TARIFAS_INSUMOS_2 FOREIGN KEY (CODINSUMO) REFERENCES INSUMOS (CODIGO) ON UPDATE CASCADE;