Tables

REG_LABORES

Description

(There is no description for table REG_LABORES)

Fields

Triggers

(There are no triggers for table REG_LABORES)

Indices

References

Referenced By

(There are no tables referenced by table REG_LABORES)

Definition

CREATE TABLE REG_LABORES (
    ITEM         INTEGER NOT NULL,
    FECHA        TIMESTAMP,
    DESDE        TIMESTAMP,
    HASTA        TIMESTAMP,
    DESCRIPCION  CHAR(500),
    URL          CHAR(300),
    REALIZADO    INTEGER DEFAULT 0,
    CODPROYECTO  INTEGER,
    CODTAREA     CHAR(20),
    CODLABOR     INTEGER,
    CODUSUARIO   CHAR(10),
    CODCONTACTO  CHAR(10)
);


ALTER TABLE REG_LABORES ADD CONSTRAINT PK_REG_LABORES PRIMARY KEY (ITEM);
ALTER TABLE REG_LABORES ADD CONSTRAINT FK_REG_LABORES_1 FOREIGN KEY (CODPROYECTO) REFERENCES PROYECTOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_LABORES ADD CONSTRAINT FK_REG_LABORES_2 FOREIGN KEY (CODTAREA) REFERENCES TAREAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_LABORES ADD CONSTRAINT FK_REG_LABORES_3 FOREIGN KEY (CODLABOR) REFERENCES LABORES (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_LABORES ADD CONSTRAINT FK_REG_LABORES_4 FOREIGN KEY (CODUSUARIO) REFERENCES USUARIOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_LABORES ADD CONSTRAINT FK_REG_LABORES_5 FOREIGN KEY (CODCONTACTO) REFERENCES CONTACTOS (CODIGO) ON UPDATE CASCADE;