ORDENES

Tables

ORDENES

Description

(There is no description for table ORDENES)

Fields

Field	Type	Default
CODIGO	INTEGER
CODPRODUCCION	INTEGER
CODMAQUINA	CHAR(20)
CODREFERENCIA	CHAR(20)
FACTOR_MOLDE	INTEGER	1
PLANEADO	NUMERIC(17,4)	0
NOTA	CHAR(400)
CODPERSONAL	CHAR(15)

Triggers

(There are no triggers for table ORDENES)

Indices

Index	Fields	Order
FK_ORDENES_1	CODPRODUCCION	ASC
FK_ORDENES_2	CODMAQUINA	ASC
FK_ORDENES_3	CODREFERENCIA	ASC
FK_ORDENES_4	CODPERSONAL	ASC
PK_ORDENES	CODIGO	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
PRODUCCION	FK_ORDENES_1	CODPRODUCCION	CODIGO	NO ACTION	CASCADE
MAQUINAS	FK_ORDENES_2	CODMAQUINA	CODIGO	NO ACTION	CASCADE
REFERENCIAS	FK_ORDENES_3	CODREFERENCIA	CODIGO	NO ACTION	CASCADE
PERSONAL	FK_ORDENES_4	CODPERSONAL	CODIGO	NO ACTION	CASCADE

Referenced By

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
REG_ORDENES	FK_REG_ORDENES_1	CODORDEN	CODIGO	CASCADE	NO ACTION

Definition

CREATE TABLE ORDENES (
    CODIGO         INTEGER NOT NULL,
    CODPRODUCCION  INTEGER NOT NULL,
    CODMAQUINA     CHAR(20) NOT NULL,
    CODREFERENCIA  CHAR(20) NOT NULL,
    FACTOR_MOLDE   INTEGER DEFAULT 1,
    PLANEADO       NUMERIC(17,4) DEFAULT 0,
    NOTA           CHAR(400),
    CODPERSONAL    CHAR(15)
);


ALTER TABLE ORDENES ADD CONSTRAINT PK_ORDENES PRIMARY KEY (CODIGO);
ALTER TABLE ORDENES ADD CONSTRAINT FK_ORDENES_1 FOREIGN KEY (CODPRODUCCION) REFERENCES PRODUCCION (CODIGO) ON UPDATE CASCADE;
ALTER TABLE ORDENES ADD CONSTRAINT FK_ORDENES_2 FOREIGN KEY (CODMAQUINA) REFERENCES MAQUINAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE ORDENES ADD CONSTRAINT FK_ORDENES_3 FOREIGN KEY (CODREFERENCIA) REFERENCES REFERENCIAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE ORDENES ADD CONSTRAINT FK_ORDENES_4 FOREIGN KEY (CODPERSONAL) REFERENCES PERSONAL (CODIGO) ON UPDATE CASCADE;