CONSTANTES_PERSONAL

Tables

CONSTANTES_PERSONAL

Description

(There is no description for table CONSTANTES_PERSONAL)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		CODPERSONAL		CHAR(15)
		CODCONSTANTE		CHAR(15)
		ANO		CHAR(4)
		VALOR		NUMERIC(17,4)

Triggers

(There are no triggers for table CONSTANTES_PERSONAL)

Indices

Index	Fields	Order
FK_CONSTANTES_PERSONAL_1	CODPERSONAL	ASC
FK_CONSTANTES_PERSONAL_2	CODCONSTANTE	ASC
PK_CONSTANTES_PERSONAL	CODPERSONAL, CODCONSTANTE, ANO	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
PERSONAL	FK_CONSTANTES_PERSONAL_1	CODPERSONAL	CODIGO	NO ACTION	CASCADE
CONSTANTES	FK_CONSTANTES_PERSONAL_2	CODCONSTANTE	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table CONSTANTES_PERSONAL)

Definition

CREATE TABLE CONSTANTES_PERSONAL (
    CODPERSONAL   CHAR(15) NOT NULL,
    CODCONSTANTE  CHAR(15) NOT NULL,
    ANO           CHAR(4) NOT NULL,
    VALOR         NUMERIC(17,4)
);


ALTER TABLE CONSTANTES_PERSONAL ADD CONSTRAINT PK_CONSTANTES_PERSONAL PRIMARY KEY (CODPERSONAL, CODCONSTANTE, ANO);
ALTER TABLE CONSTANTES_PERSONAL ADD CONSTRAINT FK_CONSTANTES_PERSONAL_1 FOREIGN KEY (CODPERSONAL) REFERENCES PERSONAL (CODIGO) ON UPDATE CASCADE;
ALTER TABLE CONSTANTES_PERSONAL ADD CONSTRAINT FK_CONSTANTES_PERSONAL_2 FOREIGN KEY (CODCONSTANTE) REFERENCES CONSTANTES (CODIGO) ON UPDATE CASCADE;