FACTORS

Tables

FACTORS

Description

(There is no description for table FACTORS)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		CODIGO		CHAR(15)
		NOMBRE		CHAR(80)
		CODTERCERO		CHAR(15)
		CTA_1		CHAR(30)
		CTA_2		CHAR(30)
		CTA_3		CHAR(30)
		CTA_4		CHAR(30)
		CTA_5		CHAR(30)
		CTA_6		CHAR(30)
		CTA_7		CHAR(30)
		CTA_8		CHAR(30)
		CTA_9		CHAR(30)

Triggers

(There are no triggers for table FACTORS)

Indices

Index	Fields	Active	Unique	Order
FK_FACTORS_1	CODTERCERO			ASC
PK_FACTORS	CODIGO			ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
TERCEROS	FK_FACTORS_1	CODTERCERO	CODIGO	NO ACTION	CASCADE

Referenced By

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
FACTORING	FK_FACTORING_1	CODFACTOR	CODIGO	NO ACTION	CASCADE

Definition

CREATE TABLE FACTORS (
    CODIGO      CHAR(15) NOT NULL,
    NOMBRE      CHAR(80) NOT NULL,
    CODTERCERO  CHAR(15) NOT NULL,
    CTA_1       CHAR(30),
    CTA_2       CHAR(30),
    CTA_3       CHAR(30),
    CTA_4       CHAR(30),
    CTA_5       CHAR(30),
    CTA_6       CHAR(30),
    CTA_7       CHAR(30),
    CTA_8       CHAR(30),
    CTA_9       CHAR(30)
);


ALTER TABLE FACTORS ADD CONSTRAINT PK_FACTORS PRIMARY KEY (CODIGO);
ALTER TABLE FACTORS ADD CONSTRAINT FK_FACTORS_1 FOREIGN KEY (CODTERCERO) REFERENCES TERCEROS (CODIGO) ON UPDATE CASCADE;