CONSTANTESVALOR

Tables

CONSTANTESVALOR

Description

(There is no description for table CONSTANTESVALOR)

Fields

Field	Type	Default
CODCONSTANTE	CHAR(15)
ANO	CHAR(4)
VALOR	NUMERIC(17,4)	0

Triggers

(There are no triggers for table CONSTANTESVALOR)

Indices

Index	Fields	Active	Unique	Order
FK_CONSTANTESVALOR_1	CODCONSTANTE			ASC
PK_CONSTANTESVALOR	CODCONSTANTE, ANO			ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
CONSTANTES	FK_CONSTANTESVALOR_1	CODCONSTANTE	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table CONSTANTESVALOR)

Definition

CREATE TABLE CONSTANTESVALOR (
    CODCONSTANTE  CHAR(15) NOT NULL,
    ANO           CHAR(4) NOT NULL,
    VALOR         NUMERIC(17,4) DEFAULT 0
);


ALTER TABLE CONSTANTESVALOR ADD CONSTRAINT PK_CONSTANTESVALOR PRIMARY KEY (CODCONSTANTE, ANO);
ALTER TABLE CONSTANTESVALOR ADD CONSTRAINT FK_CONSTANTESVALOR_1 FOREIGN KEY (CODCONSTANTE) REFERENCES CONSTANTES (CODIGO) ON UPDATE CASCADE;