Historia clínica

Ejecutar el siguiente script previo al levantamiento del deploy.

drop table F051_ANTECEDENTES cascade constraints;
drop table F051_DATOS_GENERALES cascade constraints;
drop table F051_GESTACION_ACTUAL cascade constraints;

CREATE TABLE F051_ANTECEDENTES (
PNL_ID INTEGER NOT NULL,
CTMD_ID INTEGER NOT NULL,

PNL_FAM_TBC NUMBER(10,2),
  PNL_FAM_DIABETES NUMBER(10,2),
  PNL_FAM_HIPERTENSION NUMBER(10,2),
  PNL_FAM_PRECLAMSIA NUMBER(10,2),
  PNL_FAM_ECLAMPSIA NUMBER(10,2),
  PNL_FAM_MEDICA_GRAVE NUMBER(10,2),
  PNL_FAM_OTRO VARCHAR(255),

PNL_PER_TBC NUMBER(10,2),
  PNL_PER_DIABETESI NUMBER(10,2),
  PNL_PER_DIABETESII NUMBER(10,2),
  PNL_PER_DIABETESG NUMBER(10,2),
  PNL_PER_HIPERTENSION NUMBER(10,2),
  PNL_PER_PRECLAMSIA NUMBER(10,2),
  PNL_PER_ECLAMPSIA NUMBER(10,2),
  PNL_PER_MEDICA_GRAVE NUMBER(10,2),

PNL_PER_CIRUGIA NUMBER(10,2),
  PNL_PER_INFERTILIDAD NUMBER(10,2),
  PNL_PER_CARDIOPATIA NUMBER(10,2),
  PNL_PER_NEFROPATIA NUMBER(10,2),
  PNL_PER_VIOLENCIA NUMBER(10,2),
  PNL_PER_VIH NUMBER(10,2),
  PNL_PER_OTRO VARCHAR(255),

PNL_PARTOS NUMBER(10,2),
  PNL_VAGINAL NUMBER(10,2),
  PNL_VNACIDO_VIVO NUMBER(10,2),
  PNL_VNACIDO_MUERTO NUMBER(10,2),
  PNL_VVIVEN NUMBER(10,2),
  PNL_VMUERTO_ASEM1 NUMBER(10,2),
  PNL_VMUERTO_DSEM1 NUMBER(10,2),

PNL_CESAREA NUMBER(10,2),
  PNL_CNACIDO_VIVO NUMBER(10,2),
  PNL_CNACIDO_MUERTO NUMBER(10,2),
  PNL_CVIVEN NUMBER(10,2),
  PNL_CMUERTO_ASEM1 NUMBER(10,2),
  PNL_CMUERTO_DSEM1 NUMBER(10,2),

PNL_GESTA_PREVIA NUMBER(10,2),
  PNL_ABORTO NUMBER(10,2),
  PNL_EMB_MOLAR NUMBER(10,2),
  PNL_EMB_ECTOPICO NUMBER(10,2),

PNL_PESO_ULTIMO_BEBE NUMBER(10,2),
  PNL_EMBARAZO_MULTIPLE NUMBER(10,2),

PNL_EMBARAZO_ULTIMO TIMESTAMP,
  PNL_PLANIFICADO NUMBER(10,2),
  PNL_FRACASO_ANTICONCEPTIVO NUMBER(10,2)
);

CREATE TABLE F051_DATOS_GENERALES (
PNL_ID number NOT NULL,
CTMD_ID NUMBER NOT NULL,
PNL_UBC_ID NUMBER,
PNL_DOMICILIO VARCHAR,
PNL_TELEFONO VARCHAR,
PNL_EDAD NUMBER,
PNL_RIESGO_EMBARAZO NUMBER,
PNL_ETN_ID NUMBER,
PNL_ANALFABETO NUMBER,
PNL_INSTRUCCION NUMBER,
PNL_ESTADO_CIVIL NUMBER,
PNL_VIVE_SOLA NUMBER,
PNL_CONTROL_PRENATAL VARCHAR,
PNL_LUGAR_PARTO VARCHAR
);

CREATE TABLE F051_GESTACION_ACTUAL (
PNL_ID NUMBER NOT NULL,
CTMD_ID NUMBER NOT NULL,
PNL_PESO_INICIAL NUMBER,
PNL_TALLA NUMBER,
PNL_FUM TIMESTAMP,
PNL_FPP TIMESTAMP,
PNL_EG_FUM NUMBER,
PNL_EG_ECO NUMBER,
PNL_ECOGRAFIA NUMBER,
PNL_FUMA_ACT1 NUMBER,
PNL_FUMA_ACT2 NUMBER,
PNL_FUMA_ACT3 NUMBER,
PNL_FUMA_PAS1 NUMBER,
PNL_FUMA_PAS2 NUMBER,
PNL_FUMA_PAS3 NUMBER,
PNL_DROGAS1 NUMBER,
PNL_DROGAS2 NUMBER,
PNL_DROGAS3 NUMBER,
PNL_ALCOHOL1 NUMBER,
PNL_ALCOHOL2 NUMBER,
PNL_ALCOHOL3 NUMBER,
PNL_VIOLENCIA1 NUMBER,
PNL_VIOLENCIA2 NUMBER,
PNL_VIOLENCIA3 NUMBER,
PNL_ANTIRUBEOLA NUMBER,
PNL_ANTITETANICA NUMBER,
PNL_ANTITETANICA_DOSIS NUMBER,
PNL_ANTITETANICA_FECHA TIMESTAMP,
PNL_XNORMAL_MAMAS NUMBER,
PNL_XNORMAL_ODO NUMBER,
PNL_CERV_VISUAL NUMBER,
PNL_CERV_PAP NUMBER,
PNL_CERV_COLP NUMBER,
PNL_GRUPORHP NUMBER,
PNL_GRUPO_INM NUMBER,
PNL_TOXOPLASMOSIS NUMBER,
PNL_VIH_MENOR NUMBER,
PNL_VIH_MENPRUEBA NUMBER,
PNL_VIH_MENTARVEMB NUMBER,
PNL_VIH_MAYOR NUMBER,
PNL_VIH_MAYPRUEBA NUMBER,
PNL_VIH_MAYTARVEMB NUMBER,
PNL_HB_MENORA20 NUMBER,
PNL_HB_MENORA11 NUMBER,
PNL_HB_MAYORA20 NUMBER,
PNL_HB_MAYORA11 NUMBER,
PNL_FE NUMBER,
PNL_FOLATOS NUMBER,
PNL_CHAGAS_NOHIZO NUMBER,
PNL_CHAGAS_NOAPLICA NUMBER,
PNL_PALUDISMO_NOHIZO NUMBER,
PNL_PALUDISMO_NOAPLICA NUMBER,
PNL_BACTER_MENOR NUMBER,
PNL_BACTER_MAYOREQ NUMBER,
PNL_GLUCEMIA_AYUNAS NUMBER,
PNL_GLUCEMIA_SEMANAS NUMBER,
PNL_PREV_PRECALCIO NUMBER,
PNL_PREV_PREACIDO NUMBER,
PNL_ESTREPTOCOCO NUMBER,
PNL_EDPSESIONES NUMBER,
PNL_EDPPLANPARTO NUMBER,
PNL_CONS_LACTANCIA NUMBER,
PNL_SIFPNOTTREP NUMBER,
PNL_SIFPNOTTREP_SEM NUMBER,
PNL_SIFPTREP NUMBER,
PNL_SIFPTREP_SEM NUMBER,
PNL_SIFTRATAMIENTO NUMBER,
PNL_SIFTRATAMIENTO_SEM NUMBER,
PNL_SIFTRAT_PAREJA NUMBER,
PNL_CTRL_PRENATAL TIMESTAMP,
PNL_CPEDADGESTACION NUMBER,
PNL_CPPESO NUMBER,
PNL_CPPESOGANANCIA NUMBER,
PNL_CPTASISTOLICA NUMBER,
PNL_CPTADIASTOLICA NUMBER,
PNL_CPFC NUMBER,
PNL_CPFR NUMBER,
PNL_CPTEMPERATURA NUMBER,
PNL_CPSATURACION NUMBER,
PNL_CPPROTEINURIA NUMBER,
PNL_CPESTCONC VARCHAR,
PNL_CPALTUTERINA NUMBER,
PNL_CPPRESENTACION varchar(255),
PNL_CPFCF varchar(255),
PNL_CPMOVFETALES varchar(255),
PNL_CPSANGRADO_VAGINAL NUMBER,
PNL_CPEXAMENES NUMBER,
PNL_CPINICIALESTEC varchar(255),
PNL_CPPROXIMACITA TIMESTAMP
);

ALTER TABLE F051_GESTACION_ACTUAL ADD CONSTRAINT PK_F051_GESTACION_ACTUAL PRIMARY KEY (PNL_ID);
ALTER TABLE F051_DATOS_GENERALES ADD CONSTRAINT PK_F051_DATOS_GENERALES PRIMARY KEY (PNL_ID);
ALTER TABLE F051_ANTECEDENTES ADD CONSTRAINT PK_F051_ANTECEDENTES PRIMARY KEY (PNL_ID);

ALTER TABLE F051_ANTECEDENTES ADD CONSTRAINT FK_CTMD_F051ANT FOREIGN KEY (CTMD_ID) REFERENCES CITA_MEDICA (CTMD_ID);
ALTER TABLE F051_DATOS_GENERALES ADD CONSTRAINT FK_CTMD_F051DTGN FOREIGN KEY (CTMD_ID) REFERENCES CITA_MEDICA (CTMD_ID);
ALTER TABLE F051_GESTACION_ACTUAL ADD CONSTRAINT FK_CTMD_F051GSAC FOREIGN KEY (CTMD_ID) REFERENCES CITA_MEDICA (CTMD_ID);

CREATE OR REPLACE TRIGGER TRIG_F051_ANTECEDENTES BEFORE
INSERT ON F051_ANTECEDENTES
FOR EACH ROW
BEGIN
SELECT S_F051_ANTECEDENTES.NEXTVAL INTO :NEW.PNL_ID FROM DUAL;
END;

CREATE OR REPLACE TRIGGER TRIG_F051_DATOS_GENERALES BEFORE
INSERT ON F051_DATOS_GENERALES
FOR EACH ROW
BEGIN
SELECT S_F051_DATOS_GENERALES.NEXTVAL INTO :NEW.PNL_ID FROM DUAL;
END;

CREATE OR REPLACE TRIGGER TRIG_F051_GESTACION_ACTUAL BEFORE
INSERT ON F051_GESTACION_ACTUAL
FOR EACH ROW
BEGIN
SELECT S_F051_GESTACION_ACTUAL.NEXTVAL INTO :NEW.PNL_ID FROM DUAL;
END;