LOTES

Tables

LOTES

Description

(There is no description for table LOTES)

Fields

Field	Type	Default
CODIGO	CHAR(20)
NOMBRE	CHAR(80)
LLEGADA	DATE
VENCIMIENTO	DATE
TOLERANCIA	INTEGER	0

Triggers

(There are no triggers for table LOTES)

Indices

Index	Fields	Active	Unique	Order
PK_LOTES	CODIGO			ASC

References

(There are no references for table LOTES)

Referenced By

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
PRODUCCION	FK_PRODUCCION_3	CODLOTE	CODIGO	NO ACTION	CASCADE
REG_PRODUCCION	FK_REG_PRODUCCION_7	CODLOTE	CODIGO	NO ACTION	CASCADE
TR_INVENTARIO	FK_TR_INVENTARIO_6	CODLOTE	CODIGO	NO ACTION	CASCADE
TR_PRODUCCION	FK_TR_PRODUCCION_9	CODLOTE	CODIGO	NO ACTION	CASCADE

Definition

CREATE TABLE LOTES (
    CODIGO       CHAR(20) NOT NULL,
    NOMBRE       CHAR(80) NOT NULL,
    LLEGADA      DATE,
    VENCIMIENTO  DATE,
    TOLERANCIA   INTEGER DEFAULT 0
);


ALTER TABLE LOTES ADD CONSTRAINT PK_LOTES PRIMARY KEY (CODIGO);