Tables Previous topic Chapter index Next topic

ESQCONTABLE

 

Description

(There is no description for table ESQCONTABLE)

 

Fields

PK

FK

Field

Domain

Type

NN

Default

Description

 

CODIGO

 

CHAR(5)

 

 

 

 

NOMBRE

 

CHAR(80)

 

 

 

Triggers

(There are no triggers for table ESQCONTABLE)

 

Indices

Index

Fields

Active

Unique

Order

PK_ESQCONTABLE

CODIGO

ASC

 

References

(There are no references for table ESQCONTABLE)

 

Referenced By

Table

Foreign Key

Fields

FK Field

Delete Rule

Update Rule

ESQUEMAS

FK_ESQUEMAS_4

CODESQCONTABLE

CODIGO

NO ACTION

CASCADE

GRUPOCONTABLE

FK_GRUPOCONTABLE_8

CODESQCONTABLE

CODIGO

NO ACTION

CASCADE

REFERENCIAS

FK_REFERENCIAS_5

COD_ESQCONTABLE

CODIGO

NO ACTION

CASCADE

REFERENCIAS

FK_REFERENCIAS_6

COD_ESQCONTABLE2

CODIGO

NO ACTION

CASCADE

REG_CARTERA

FK_REG_CARTERA_5

ESQ_CONTABLE

CODIGO

NO ACTION

CASCADE

REG_IMPUESTOS

FK_REG_IMPUESTOS_4

ESQ_CONTABLE

CODIGO

NO ACTION

CASCADE

REG_RETENCIONES

FK_REG_RETENCIONES_4

ESQ_CONTABLE

CODIGO

NO ACTION

CASCADE

TR_TESORERIA

FK_TR_TESORERIA_4

CODESQCONTABLE

CODIGO

NO ACTION

CASCADE

 

Definition

CREATE TABLE ESQCONTABLE (
    CODIGO  CHAR(5) NOT NULL,
    NOMBRE  CHAR(80) NOT NULL
);


ALTER TABLE ESQCONTABLE ADD CONSTRAINT PK_ESQCONTABLE PRIMARY KEY (CODIGO);

 

     Previous topic Chapter index Next topic