DET_RENGLONES

Tables

DET_RENGLONES

Description

(There is no description for table DET_RENGLONES)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		ITEM		INTEGER
		CODRENGLON		CHAR(10)
		CODCUENTA		CHAR(30)

Triggers

(There are no triggers for table DET_RENGLONES)

Indices

Index	Fields	Order
FK_DET_RENGLONES_1	CODRENGLON	ASC
FK_DET_RENGLONES_2	CODCUENTA	ASC
PK_DET_RENGLONES	ITEM	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
RENGLONES	FK_DET_RENGLONES_1	CODRENGLON	CODIGO	NO ACTION	CASCADE
CUENTAS	FK_DET_RENGLONES_2	CODCUENTA	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table DET_RENGLONES)

Definition

CREATE TABLE DET_RENGLONES (
    ITEM        INTEGER NOT NULL,
    CODRENGLON  CHAR(10) NOT NULL,
    CODCUENTA   CHAR(30)
);


ALTER TABLE DET_RENGLONES ADD CONSTRAINT PK_DET_RENGLONES PRIMARY KEY (ITEM);
ALTER TABLE DET_RENGLONES ADD CONSTRAINT FK_DET_RENGLONES_1 FOREIGN KEY (CODRENGLON) REFERENCES RENGLONES (CODIGO) ON UPDATE CASCADE;
ALTER TABLE DET_RENGLONES ADD CONSTRAINT FK_DET_RENGLONES_2 FOREIGN KEY (CODCUENTA) REFERENCES CUENTAS (CODIGO) ON UPDATE CASCADE;