PATRONES

Tables

PATRONES

Description

(There is no description for table PATRONES)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		CODIGO		INTEGER
		NOMBRE		CHAR(80)
		CODDOCUMENTO		CHAR(5)
		CODCUENTA		CHAR(30)
		SIGNO		CHAR(10)
		NOTA		CHAR(80)

Triggers

(There are no triggers for table PATRONES)

Indices

Index	Fields	Order
FK_PATRONES_1	CODDOCUMENTO	ASC
FK_PATRONES_2	CODCUENTA	ASC
PK_PATRONES	CODIGO	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
DOCUMENTOS	FK_PATRONES_1	CODDOCUMENTO	CODIGO	NO ACTION	CASCADE
CUENTAS	FK_PATRONES_2	CODCUENTA	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table PATRONES)

Definition

CREATE TABLE PATRONES (
    CODIGO        INTEGER NOT NULL,
    NOMBRE        CHAR(80) NOT NULL,
    CODDOCUMENTO  CHAR(5) NOT NULL,
    CODCUENTA     CHAR(30) NOT NULL,
    SIGNO         CHAR(10) NOT NULL,
    NOTA          CHAR(80) NOT NULL
);


ALTER TABLE PATRONES ADD CONSTRAINT PK_PATRONES PRIMARY KEY (CODIGO);
ALTER TABLE PATRONES ADD CONSTRAINT FK_PATRONES_1 FOREIGN KEY (CODDOCUMENTO) REFERENCES DOCUMENTOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE PATRONES ADD CONSTRAINT FK_PATRONES_2 FOREIGN KEY (CODCUENTA) REFERENCES CUENTAS (CODIGO) ON UPDATE CASCADE;