Tables

IPS_URGENCIAS

Description

(There is no description for table IPS_URGENCIAS)

Fields

Triggers

(There are no triggers for table IPS_URGENCIAS)

Indices

References

Referenced By

(There are no tables referenced by table IPS_URGENCIAS)

Definition

CREATE TABLE IPS_URGENCIAS (
    CODCITA           INTEGER NOT NULL,
    RENGLON           INTEGER NOT NULL,
    CODPROCEDIMEINTO  CHAR(15) NOT NULL,
    CODPLANTILLA      CHAR(5),
    TRANSCRIPCION     BLOB SUB_TYPE 1 SEGMENT SIZE 80,
    CODPERSONAL       CHAR(15),
    CODCAUSA          CHAR(5),
    CODDIAGNOSTICO_I  CHAR(15),
    CODDIAGNOSTICO_S  CHAR(15),
    CODDIAGNOSTICOR1  CHAR(15),
    CODDIAGNOSTICOR2  CHAR(15),
    CODDIAGNOSTICOR3  CHAR(15),
    CODDIAGNOSTICO_C  CHAR(15),
    ESTADO_SALIDA     CHAR(1),
    CODDIAGNOSTICO_M  CHAR(15),
    EGRESO            TIMESTAMP,
    CONCLUIDA         CHAR(1),
    CREADO            CHAR(10),
    FCREADO           TIMESTAMP
);


ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT PK_IPS_URGENCIAS PRIMARY KEY (CODCITA, RENGLON);
ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT FK_IPS_URGENCIAS_1 FOREIGN KEY (CODCITA) REFERENCES CITAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT FK_IPS_URGENCIAS_10 FOREIGN KEY (CODDIAGNOSTICOR3) REFERENCES DIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT FK_IPS_URGENCIAS_11 FOREIGN KEY (CODDIAGNOSTICO_C) REFERENCES DIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT FK_IPS_URGENCIAS_12 FOREIGN KEY (CODDIAGNOSTICO_M) REFERENCES DIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT FK_IPS_URGENCIAS_13 FOREIGN KEY (CREADO) REFERENCES USUARIOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT FK_IPS_URGENCIAS_2 FOREIGN KEY (CODPROCEDIMEINTO) REFERENCES PROCEDIMIENTOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT FK_IPS_URGENCIAS_3 FOREIGN KEY (CODPLANTILLA) REFERENCES PLANTILLAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT FK_IPS_URGENCIAS_4 FOREIGN KEY (CODPERSONAL) REFERENCES PERSONAL (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT FK_IPS_URGENCIAS_5 FOREIGN KEY (CODCAUSA) REFERENCES CAUSAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT FK_IPS_URGENCIAS_6 FOREIGN KEY (CODDIAGNOSTICO_I) REFERENCES DIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT FK_IPS_URGENCIAS_7 FOREIGN KEY (CODDIAGNOSTICO_S) REFERENCES DIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT FK_IPS_URGENCIAS_8 FOREIGN KEY (CODDIAGNOSTICOR1) REFERENCES DIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_URGENCIAS ADD CONSTRAINT FK_IPS_URGENCIAS_9 FOREIGN KEY (CODDIAGNOSTICOR2) REFERENCES DIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;