NORMAS

Tables

NORMAS

Description

(There is no description for table NORMAS)

Fields

Field	Type	Default
ITEM	INTEGER
SIGNO	CHAR(2)	'<>'
FORMULA	BLOB SUB_TYPE 1 SEGMENT SIZE 80
CODESCENARIO	CHAR(10)
CODPARTIDA	CHAR(30)
CODCONTRA	CHAR(30)
MES	INTEGER	0

Triggers

(There are no triggers for table NORMAS)

Indices

Index	Fields	Order
FK_NORMAS_1	CODESCENARIO	ASC
FK_NORMAS_2	CODPARTIDA	ASC
FK_NORMAS_3	CODCONTRA	ASC
PK_NORMAS	ITEM	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
ESCENARIOS	FK_NORMAS_1	CODESCENARIO	CODIGO	NO ACTION	CASCADE
CUENTAS	FK_NORMAS_2	CODPARTIDA	CODIGO	NO ACTION	CASCADE
CUENTAS	FK_NORMAS_3	CODCONTRA	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table NORMAS)

Definition

CREATE TABLE NORMAS (
    ITEM          INTEGER NOT NULL,
    SIGNO         CHAR(2) DEFAULT '<>',
    FORMULA       BLOB SUB_TYPE 1 SEGMENT SIZE 80,
    CODESCENARIO  CHAR(10) NOT NULL,
    CODPARTIDA    CHAR(30) NOT NULL,
    CODCONTRA     CHAR(30) NOT NULL,
    MES           INTEGER DEFAULT 0
);


ALTER TABLE NORMAS ADD CONSTRAINT PK_NORMAS PRIMARY KEY (ITEM);
ALTER TABLE NORMAS ADD CONSTRAINT FK_NORMAS_1 FOREIGN KEY (CODESCENARIO) REFERENCES ESCENARIOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE NORMAS ADD CONSTRAINT FK_NORMAS_2 FOREIGN KEY (CODPARTIDA) REFERENCES CUENTAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE NORMAS ADD CONSTRAINT FK_NORMAS_3 FOREIGN KEY (CODCONTRA) REFERENCES CUENTAS (CODIGO) ON UPDATE CASCADE;