Tables Previous topic Chapter index Next topic

CATEGORIAS

 

Description

(There is no description for table CATEGORIAS)

 

Fields

PK

FK

Field

Domain

Type

NN

Default

Description

 

CODIGO

 

CHAR(15)

 

 

 

 

NOMBRE

 

CHAR(80)

 

 

 

Triggers

(There are no triggers for table CATEGORIAS)

 

Indices

Index

Fields

Active

Unique

Order

PK_CATEGORIAS

CODIGO

ASC

 

References

(There are no references for table CATEGORIAS)

 

Referenced By

Table

Foreign Key

Fields

FK Field

Delete Rule

Update Rule

REG_PONDERADOS

FK_REG_PONDERADOS_5

CODCATEGORIA

CODIGO

NO ACTION

CASCADE

REG_PRODUCCION

FK_REG_PRODUCCION_6

CODCATEGORIA

CODIGO

NO ACTION

CASCADE

TR_INVENTARIO

FK_TR_INVENTARIO_7

CODCATEGORIA

CODIGO

NO ACTION

CASCADE

TR_PRODUCCION

FK_TR_PRODUCCION_8

CODCATEGORIA

CODIGO

NO ACTION

CASCADE

 

Definition

CREATE TABLE CATEGORIAS (
    CODIGO  CHAR(15) NOT NULL,
    NOMBRE  CHAR(80) NOT NULL
);


ALTER TABLE CATEGORIAS ADD CONSTRAINT PK_CATEGORIAS PRIMARY KEY (CODIGO);

 

     Previous topic Chapter index Next topic