Tables

IPS_CONSULTAS

Description

(There is no description for table IPS_CONSULTAS)

Fields

Triggers

(There are no triggers for table IPS_CONSULTAS)

Indices

References

Referenced By

(There are no tables referenced by table IPS_CONSULTAS)

Definition

CREATE TABLE IPS_CONSULTAS (
    CODCITA             INTEGER NOT NULL,
    RENGLON             INTEGER NOT NULL,
    CODPROCEDIMIENTO    CHAR(15) NOT NULL,
    CODPLANTILLA        CHAR(5),
    TRANSCRIPCION       BLOB SUB_TYPE 1 SEGMENT SIZE 80,
    CODPERSONAL         CHAR(15),
    CODCAUSA            CHAR(5),
    CODDIAGNOSTICO      CHAR(15),
    CODDIAGNOSTICOR1    CHAR(15),
    CODDIAGNOSTICOR2    CHAR(15),
    CODDIAGNOSTICOR3    CHAR(15),
    CODTIPODIAGNOSTICO  CHAR(5),
    CONCLUIDA           CHAR(1),
    CREADO              CHAR(10),
    FCREADO             TIMESTAMP,
    CODFIN              CHAR(5)
);


ALTER TABLE IPS_CONSULTAS ADD CONSTRAINT PK_IPS_CONSULTAS PRIMARY KEY (CODCITA, RENGLON);
ALTER TABLE IPS_CONSULTAS ADD CONSTRAINT FK_IPS_CONSULTAS_1 FOREIGN KEY (CODCITA) REFERENCES CITAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_CONSULTAS ADD CONSTRAINT FK_IPS_CONSULTAS_10 FOREIGN KEY (CODDIAGNOSTICOR3) REFERENCES DIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_CONSULTAS ADD CONSTRAINT FK_IPS_CONSULTAS_11 FOREIGN KEY (CODTIPODIAGNOSTICO) REFERENCES TIPODIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_CONSULTAS ADD CONSTRAINT FK_IPS_CONSULTAS_12 FOREIGN KEY (CREADO) REFERENCES USUARIOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_CONSULTAS ADD CONSTRAINT FK_IPS_CONSULTAS_2 FOREIGN KEY (CODPROCEDIMIENTO) REFERENCES PROCEDIMIENTOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_CONSULTAS ADD CONSTRAINT FK_IPS_CONSULTAS_3 FOREIGN KEY (CODPLANTILLA) REFERENCES PLANTILLAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_CONSULTAS ADD CONSTRAINT FK_IPS_CONSULTAS_4 FOREIGN KEY (CODPERSONAL) REFERENCES PERSONAL (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_CONSULTAS ADD CONSTRAINT FK_IPS_CONSULTAS_5 FOREIGN KEY (CODFIN) REFERENCES FINES (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_CONSULTAS ADD CONSTRAINT FK_IPS_CONSULTAS_6 FOREIGN KEY (CODCAUSA) REFERENCES CAUSAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_CONSULTAS ADD CONSTRAINT FK_IPS_CONSULTAS_7 FOREIGN KEY (CODDIAGNOSTICO) REFERENCES DIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_CONSULTAS ADD CONSTRAINT FK_IPS_CONSULTAS_8 FOREIGN KEY (CODDIAGNOSTICOR1) REFERENCES DIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_CONSULTAS ADD CONSTRAINT FK_IPS_CONSULTAS_9 FOREIGN KEY (CODDIAGNOSTICOR2) REFERENCES DIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;