Tables

IPS_NEONATOS

Description

(There is no description for table IPS_NEONATOS)

Fields

Triggers

(There are no triggers for table IPS_NEONATOS)

Indices

References

Referenced By

(There are no tables referenced by table IPS_NEONATOS)

Definition

CREATE TABLE IPS_NEONATOS (
    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),
    NATALICIO         TIMESTAMP,
    GESTACION         INTEGER,
    CONTROL           CHAR(1),
    SEXO              CHAR(1),
    PESO              INTEGER,
    CODDIAGNOSTICO    CHAR(15),
    CODDIAGNOSTICO_M  CHAR(15),
    MUERTE            TIMESTAMP,
    CONCLUIDA         CHAR(1),
    CREADO            CHAR(10),
    FCREADO           TIMESTAMP
);


ALTER TABLE IPS_NEONATOS ADD CONSTRAINT PK_IPS_NEONATOS PRIMARY KEY (CODCITA, RENGLON);
ALTER TABLE IPS_NEONATOS ADD CONSTRAINT FK_IPS_NEONATOS_1 FOREIGN KEY (CODCITA) REFERENCES CITAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_NEONATOS ADD CONSTRAINT FK_IPS_NEONATOS_2 FOREIGN KEY (CODPROCEDIMIENTO) REFERENCES PROCEDIMIENTOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_NEONATOS ADD CONSTRAINT FK_IPS_NEONATOS_3 FOREIGN KEY (CODPLANTILLA) REFERENCES PLANTILLAS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_NEONATOS ADD CONSTRAINT FK_IPS_NEONATOS_4 FOREIGN KEY (CODPERSONAL) REFERENCES PERSONAL (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_NEONATOS ADD CONSTRAINT FK_IPS_NEONATOS_5 FOREIGN KEY (CODDIAGNOSTICO) REFERENCES DIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_NEONATOS ADD CONSTRAINT FK_IPS_NEONATOS_6 FOREIGN KEY (CODDIAGNOSTICO_M) REFERENCES DIAGNOSTICOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE IPS_NEONATOS ADD CONSTRAINT FK_IPS_NEONATOS_7 FOREIGN KEY (CREADO) REFERENCES USUARIOS (CODIGO) ON UPDATE CASCADE;