REG_ORDENES

Tables

REG_ORDENES

Description

(There is no description for table REG_ORDENES)

Fields

Field	Type	Default
ITEM	INTEGER
CODORDEN	INTEGER
FECHA	TIMESTAMP	CURRENT_TIMESTAMP
PRODUCIDAS	INTEGER	0
DEFECTUOSAS	INTEGER	0
CODPERSONAL	CHAR(15)

Triggers

(There are no triggers for table REG_ORDENES)

Indices

Index	Fields	Order
FK_REG_ORDENES_1	CODORDEN	ASC
FK_REG_ORDENES_2	CODPERSONAL	ASC
PK_REG_ORDENES	ITEM	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
ORDENES	FK_REG_ORDENES_1	CODORDEN	CODIGO	CASCADE	NO ACTION
PERSONAL	FK_REG_ORDENES_2	CODPERSONAL	CODIGO	CASCADE	NO ACTION

Referenced By

(There are no tables referenced by table REG_ORDENES)

Definition

CREATE TABLE REG_ORDENES (
    ITEM         INTEGER NOT NULL,
    CODORDEN     INTEGER,
    FECHA        TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRODUCIDAS   INTEGER DEFAULT 0,
    DEFECTUOSAS  INTEGER DEFAULT 0,
    CODPERSONAL  CHAR(15)
);


ALTER TABLE REG_ORDENES ADD CONSTRAINT PK_REG_ORDENES PRIMARY KEY (ITEM);
ALTER TABLE REG_ORDENES ADD CONSTRAINT FK_REG_ORDENES_1 FOREIGN KEY (CODORDEN) REFERENCES ORDENES (CODIGO) ON DELETE CASCADE;
ALTER TABLE REG_ORDENES ADD CONSTRAINT FK_REG_ORDENES_2 FOREIGN KEY (CODPERSONAL) REFERENCES PERSONAL (CODIGO) ON DELETE CASCADE;