Tables

REG_PLANEADO

Description

(There is no description for table REG_PLANEADO)

Fields

Triggers

(There are no triggers for table REG_PLANEADO)

Indices

References

Referenced By

(There are no tables referenced by table REG_PLANEADO)

Definition

CREATE TABLE REG_PLANEADO (
    ITEM         INTEGER NOT NULL,
    FECHA        DATE,
    DESDE        TIMESTAMP,
    HASTA        TIMESTAMP,
    CANTIDAD     NUMERIC(17,4) DEFAULT 0,
    DESCRIPCION  CHAR(500),
    CODPROYECTO  INTEGER,
    CODTAREA     CHAR(20),
    CODLABOR     INTEGER,
    CODUSUARIO   CHAR(10),
    CODCONTACTO  CHAR(10),
    CODMEDIDA    CHAR(5)
);


ALTER TABLE REG_PLANEADO ADD CONSTRAINT PK_REG_PLANEADO PRIMARY KEY (ITEM);
ALTER TABLE REG_PLANEADO ADD CONSTRAINT FK_REG_PLANEADO_1 FOREIGN KEY (CODPROYECTO) REFERENCES PROYECTOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_PLANEADO ADD CONSTRAINT FK_REG_PLANEADO_2 FOREIGN KEY (CODTAREA) REFERENCES TAREAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_PLANEADO ADD CONSTRAINT FK_REG_PLANEADO_3 FOREIGN KEY (CODLABOR) REFERENCES LABORES (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_PLANEADO ADD CONSTRAINT FK_REG_PLANEADO_4 FOREIGN KEY (CODUSUARIO) REFERENCES USUARIOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_PLANEADO ADD CONSTRAINT FK_REG_PLANEADO_5 FOREIGN KEY (CODCONTACTO) REFERENCES CONTACTOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_PLANEADO ADD CONSTRAINT FK_REG_PLANEADO_6 FOREIGN KEY (CODMEDIDA) REFERENCES MEDIDAS (CODIGO) ON UPDATE CASCADE;