RENGLONES

Tables

RENGLONES

Description

(There is no description for table RENGLONES)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		CODIGO		CHAR(10)
		NOMBRE		CHAR(200)
		FORMULA		BLOB SUB_TYPE 1 SEGMENT SIZE 80
		CODDECLARACION		CHAR(10)

Triggers

(There are no triggers for table RENGLONES)

Indices

Index	Fields	Active	Unique	Order
FK_RENGLONES_1	CODDECLARACION			ASC
PK_RENGLONES	CODIGO			ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
DECLARACIONES	FK_RENGLONES_1	CODDECLARACION	CODIGO	NO ACTION	CASCADE

Referenced By

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
DET_RENGLONES	FK_DET_RENGLONES_1	CODRENGLON	CODIGO	NO ACTION	CASCADE

Definition

CREATE TABLE RENGLONES (
    CODIGO          CHAR(10) NOT NULL,
    NOMBRE          CHAR(200),
    FORMULA         BLOB SUB_TYPE 1 SEGMENT SIZE 80,
    CODDECLARACION  CHAR(10) NOT NULL
);


ALTER TABLE RENGLONES ADD CONSTRAINT PK_RENGLONES PRIMARY KEY (CODIGO);
ALTER TABLE RENGLONES ADD CONSTRAINT FK_RENGLONES_1 FOREIGN KEY (CODDECLARACION) REFERENCES DECLARACIONES (CODIGO) ON UPDATE CASCADE;