VARIABLES

Tables

VARIABLES

Description

(There is no description for table VARIABLES)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		CODIGO		CHAR(10)
		NOMBRE		CHAR(80)
		TIPO		CHAR(20)
		CODCUENTA		CHAR(20)
		VALOR		NUMERIC(17,4)

Triggers

(There are no triggers for table VARIABLES)

Indices

Index	Fields	Active	Unique	Order
FK_VARIABLES_1	CODCUENTA			ASC
PK_VARIABLES	CODIGO			ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
CUENTAS	FK_VARIABLES_1	CODCUENTA	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table VARIABLES)

Definition

CREATE TABLE VARIABLES (
    CODIGO     CHAR(10) NOT NULL,
    NOMBRE     CHAR(80),
    TIPO       CHAR(20),
    CODCUENTA  CHAR(20),
    VALOR      NUMERIC(17,4)
);


ALTER TABLE VARIABLES ADD CONSTRAINT PK_VARIABLES PRIMARY KEY (CODIGO);
ALTER TABLE VARIABLES ADD CONSTRAINT FK_VARIABLES_1 FOREIGN KEY (CODCUENTA) REFERENCES CUENTAS (CODIGO) ON UPDATE CASCADE;