search

unxs0 / unxsVZ

Hybrid cloud management software with many ISP and SaaS tools
GNU General Public License v2.0
2 stars 0 forks source link

unxsSalud falta campo tLaboratorio #6

Open danielagill opened 7 years ago

danielagill commented 7 years ago

falta TSH T3 T4 Albumina Proteinas totales

unxs0 commented 7 years ago

Please add the fields to this list in the following format

cLabel;cTitle;tFieldType.cLabel;uOrder;[cFKSpec/Varchar size]

uLaboratorio;Primary key;Rad Primary;1;10; cLabel;Short label;Varchar;2;32; uPaciente;Numero de paciente;Select Table Owner;10;"tPaciente","cLabel"; cLaboratorio;Nombre del Laboratorio;Varchar;30;64; cOtro;Notas;Text;51;10; uTemp;Temperatua Corporal Centigrados;Int Unsigned;52;10; uSodio;Sodio en Sangre mEq/l;Int Unsigned;52;10; uLDH;Lactato de Hidrogenasa mg/dl;Int Unsigned;52;10; uUrea;Urea mg/dl;Int Unsigned;53;10; uHemoglobina;Hemoglobina gr/dl;Int Unsigned;54;10; uLeucocitos;Leucocitos K/ul;Int Unsigned;55;10; uGlobulosRojos;Globulos Rojos M/ul;Int Unsigned;56;10; uPlaquetas;Plaquetas K/ul;Int Unsigned;57;10; uCreatinina;Creatinina mg/dl;Int Unsigned;58;10; uHematocrito;Hematocrito %;Int Unsigned;59;10; uGlucemia;Glucemia mg/dl;Int Unsigned;60;10; uPCR;Protiena C Reactiva;Int Unsigned;61;10; uVSG;Velocidad de Eritrosedimentacion;Int Unsigned;62;10; uTGO;Transaminasa Glutamico Oxalacetica ui/L;Int Unsigned;63;10; uTGP;Transaminasa Glutamico Piruvica ui/L;Int Unsigned;64;10; uGammaGT;Gamma Glutamil Transpeptidasa ui/L;Int Unsigned;65;10; uBilT;BilirubinaTotal mg/dl;Int Unsigned;66;10; uBilD;Bilirubina Directa mg/L;Int Unsigned;67;10; uCPK;Creatin Fosfo Quinasa mg/dl;Int Unsigned;68;10; uOwner;Record owner;Foreign Key;1000;"tClient","cLabel",uOwner; uCreatedBy;Record created by;Foreign Key;1001;"tClient","cLabel",uCreatedBy; uCreatedDate;Unix timestamp for creation date;Unixtime Create;1002;10; uModBy;Record modifed by;Foreign Key;1003;"tClient","cLabel",uModBy; uModDate;Unix timestamp for last update;Unixtime Update;1004;10;

unxs0 commented 7 years ago

Example:

uTSH;Hormona Tiroides ui/ml;Int Unsigned;69;10;

danielagill commented 7 years ago

http://www.msdmanuals.com/es-ar/professional/ap%C3%A9ndices/valores-normales-de-laboratorio/pruebas-de-sangre-valores-normales#v8508814_es uSodio;Sodio en Sangre mEq/l;Int Unsigned;52;10; uPotasio;Potasio en Sangre mEq/l;Int Unsigned;69;10; uCloro;Cloro en Sangre mEq/l;IntUnsigned;70;10; uPCR;Proteina C Reactiva mg/dl;Int Unsigned;61;10; uTSH;Hormona Tirotropina uUI/mL;Int Unsigned;71;10; uT4;Tiroxina ug/dL;Int Unsigned;73;10; uT3;Triyodotironina ug/dL;Int Unsigned;72;10; uAlbúmina;Albumina en Sangre g/dL;Int Unsigned;73;10; uFAL;Fosftasa Alcalina U/L;Int Unsigned;74;10; uAmilasa; Amilasa en Sangre U/L

danielagill commented 7 years ago

uAmilasa; Amilasa en Sangre U/L;Int Unsigned;75;10;

unxs0 commented 7 years ago

Thank you! I will add asap.

danielagill commented 7 years ago

http://www.msdmanuals.com/professional/appendixes/normal-laboratory-values/blood-tests-normal-values

danielagill commented 7 years ago

uLaboratorio;Primary key;Rad Primary;1;10; cLabel;Short label;Varchar;2;32; uPaciente;Numero de paciente;Select Table Owner;10;"tPaciente","cLabel"; cLaboratorio;Nombre del Laboratorio;Varchar;30;64; cOtro;Notas;Text;51;10; uTemp;Temperatua Corporal Centigrados;Int Unsigned;52;10; uLDH;Lactato deshidrogenasa U/Ll;Int Unsigned;52;10; uUrea;Urea en Sangre mg/dl;Int Unsigned;53;10; uHb;Hemoglobina gr/dl;Int Unsigned;54;10; uHematocrito;Hematocrito %;Int Unsigned;55;10; uLeucocitos;Leucocitos K/ul;Int Unsigned;56;10; uNeutrofilos;Porcentaje de Neutrófilos Segmentados %;Int Unsigned;57;10; uBasofilos;Porentaje de Basófios %;Int Unsigned;58;10; uEosinófilos;Pordentaje de Eosinófios %;Int Unsigned;59;10; uLinfocitos;Porcentaje de Linfocitos %;Int Unsigned;60;10; uMonocitos;Porcentaje de Monocitos %;Int Unsigned;61;10;; uGlobulosRojos;Globulos Rojos M/ul;Int Unsigned;62;10; uPlaquetas;Plaquetas K/ul;Int Unsigned;63;10; uCreatinina;Creatinina mg/dl;Int Unsigned;64;10; uGlucemia;Glucemia mg/dl;Int Unsigned;65;10; uPCR;Protiena C Reactiva;Int Unsigned;66;10; uVSG;Velocidad de Eritrosedimentacion;Int Unsigned;67;10; uTGO;Transaminasa Glutamico Oxalacetica UI/L;Int Unsigned;68;10; uTGP;Transaminasa Glutamico Piruvica UI/L;Int Unsigned;69;10; uGGT;Gamma Glutamil Transpeptidasa UI/L;Int Unsigned;70;10; uBilT;BilirubinaTotal mg/dl;Int Unsigned;71;10; uBilD;Bilirubina Directa mg/L;Int Unsigned;72;10; uCPK;Creatin Fosfo Quinasa mg/dl;Int Unsigned;73;10; uOwner;Record owner;Foreign Key;1000;"tClient","cLabel",uOwner; uCreatedBy;Record created by;Foreign Key;1001;"tClient","cLabel",uCreatedBy; uCreatedDate;Unix timestamp for creation date;Unixtime Create;1002;10; uModBy;Record modifed by;Foreign Key;1003;"tClient","cLabel",uModBy; uModDate;Unix timestamp for last update;Unixtime Update;1004;10; uSodio;Sodio en Sangre mEq/l;Int Unsigned;74;10; uPotasio;Potasio en Sangre mEq/l;Int Unsigned;75;10; uCloro;Cloro en Sangre mEq/l;IntUnsigned;76;10; uTSH;Hormona Tirotropina uUI/mL;Int Unsigned;77;10; uT4;Tiroxina ug/dL;Int Unsigned;78;10; uT3;Triyodotironina ug/dL;Int Unsigned;79;10; uAlbúmina;Albumina en Sangre g/dL;Int Unsigned;80;10; uFAL;Fosftasa Alcalina U/L;Int Unsigned;81;10; uAmilasa; Amilasa en Sangre U/L;Int Unsigned;82;10 uCD4; Recuento de linfocitos T CD4+ n/uL;Int Unsigned;83;10; uCD8; Recuento de linfocitos T CD8+ n/uL;;Int Unsigned;84;10; uRelación CD4:CD8; Relación linfocitos CD4 CD8; Int Unsigned;85;10;

danielagill commented 7 years ago

arma una tabla con subtabla de laboratorio tSangre (en esta tabla va todo lo cargado en tlaboratorio) tOrina uLeucocitos; leucocitos en orina +;Int Unsigned;01;10; uPiocitos; Piocitos en orina +;Int Unsigned;02;10; uHematies; Hematies en orina +;Int Unsigned;03;10; uCelulas epiteliales; Celulas epitliales en orina +;Int Unsigned;04;10; uGermenes; Germenes en orina +;Int Unsigned;05;10; tLiquido Cefalorraquideo uCelulas; Recuento celular cel/uL;Int Unsigned;06;10; uGlucosa; Glucosa mg/dL;Int Unsigned;07;10; uProteinas; Proteinas mg/dL;Int Usigned;08;10; tSerología uHVAIgM; Hepatitis A anticuerpo IgM positivo negativo;Int Unsigned;09;10; uHVAIgG; Hepatitis A anticuerpo IgG positivo negativo;Int Unsigned;10;10; uHBVsAg; Hepatitis B antigeno de superficie positivo negativo;Int Unsigned;11;10; uHVBanticoreIgM; Hepatitis B antigeno del core anticuerpo IgM positivo negativo;Int Unsigned;12;10; uHVBanticoreIgG; Hepatitis B antigeno del core anticuerpo IgG positivo negativo;Int Unsigned;13;10; HVC; Hepatitis C anticuerpo positivo negativo;Int Unsigned;14;10; CMVIgM; Citomegalovirus anticuerpo IgM positivo negativo;Int Unsigned;15;10; CMVIgG; Citomegalovirus anticuerpo IgG positivo negativo;Int Unsigned;1610; ToxoIgM; Toxoplasmosis anticuerpo IgM positivo negativo;Int Unsigned;17;10; ToxoIgG; Toxoplasmosis anticuerpo IgG positivo negativo;Int Unsigned;18;10; Chagas; Enfermedad de Chagas positivo negativo;Int Unsigned;19;10; HIV; Virus de la inmunodeficiencia humana positivo negativo;Int Unsigned;20;10; CVHIV; Carga Viral HIV copias/mL;Int Unsigned;21;10; CVHVC; Carga viral Hepatitis C copias/mL;Int Unsigned;22;10; CVHVB; Carga viral Hepatits B copias/mL;Int UNsigned;23;10

danielagill commented 7 years ago

uLDH;Lactate dehydrogenase U/L;Int Unsigned;52;10; uUrea;Urea in Blood mg/dl;Int Unsigned;53;10; uHb;Hemoglobin gr/dL;Int Unsigned;54;10; uHematocrit;Hematocrit %;Int Unsigned;55;10; uWBC;White blood cell cell/ul;Int Unsigned;56;10; uNeutrophils;Neutrophils percent%;Int Unsigned;57;10; uBasophils;Basophils percent %;Int Unsigned;58;10; uEosinophils;Eosinophils percent %;Int Unsigned;59;10; uLimphocytes;Limphocytes percent %;Int Unsigned;60;10; uMonocytes;Monocytes percent %;Int Unsigned;61;10;; uRBC;Red blood cell cell/ul;Int Unsigned;62;10; uPlatelet;Platelet count K/ul;Int Unsigned;63;10; uCreatinine;Creatinine mg/dl;Int Unsigned;64;10; uGlucose;Glucose mg/dl;Int Unsigned;65;10; uCRP;C Reactive protein;Int Unsigned;66;10; uESR;Erythrocyte sedimentation rate mm/h;Int Unsigned;67;10; uALT;Aminotransferase, alanine UI/L;Int Unsigned;68;10; uAST;Aminotransferase, aspartate UI/L;Int Unsigned;69;10; uGGT;Gamma-glutamyl transpeptidase UI/L;Int Unsigned;70;10; uBilT;BilirubinTotal mg/dl;Int Unsigned;71;10; uBilD;Bilirubin Direct mg/L;Int Unsigned;72;10; uCPK;Creatin Fosfo Quinasa mg/dl;Int Unsigned;73;10; uOwner;Record owner;Foreign Key;1000;"tClient","cLabel",uOwner; uCreatedBy;Record created by;Foreign Key;1001;"tClient","cLabel",uCreatedBy; uCreatedDate;Unix timestamp for creation date;Unixtime Create;1002;10; uModBy;Record modifed by;Foreign Key;1003;"tClient","cLabel",uModBy; uModDate;Unix timestamp for last update;Unixtime Update;1004;10; uSodium;Sodium in blood mEq/l;Int Unsigned;74;10; uPotassium;Potasssium in blood mEq/l;Int Unsigned;75;10; uChlorine;Chorine in blood mEq/l;IntUnsigned;76;10; uTSH;Thyroid-stimulating hormone ulU/mL;Int Unsigned;77;10; uT4;Thyroxine ng/dL;Int Unsigned;78;10; uT3;Triiodothyronine ng/dL;Int Unsigned;79;10; uAlbúmin;Albumin in Blood g/dL;Int Unsigned;80;10; uALP;Alkaline, phosphatase U/L;Int Unsigned;81;10; uAmylase; Amylase U/L;Int Unsigned;82;10 uCD4; CD4+ T-Cell count n/uL;Int Unsigned;83;10; uCD8; CD8+ T-Cell count n/uL;;Int Unsigned;84;10; uCD4:CD8;CD4 CD8 Ratio; Int Unsigned;85;10; uPT;Prothrombin time sec;Int Unsigned;86;10

unxs0 commented 7 years ago

Agregar nueva table enganchado a tLaboratorio que se llama tMicrobiologia

cComments:Comentario;Text;

Esta tabla contiene subtablas:

tHemocultivo:

cBacteria;Nombre de la bacteria;Varchar; cSensibilidad;Lista de abreviaturas de antibioticos;Text; cResistencia:Lista de abreviaturas de resistencias;Text;

tUrocultivo:

cBacteria;Nombre de la bacteria;Varchar; cSensibilidad;Lista de abreviaturas de antibioticos;Text; cResistencia:Lista de abreviaturas de resistencias;Text;

tCultivoCateter:

cBacteria;Nombre de la bacteria;Varchar; cSensibilidad;Lista de abreviaturas de antibioticos;Text; cResistencia:Lista de abreviaturas de resistencias;Text;

tCultivoHueso:

cBacteria;Nombre de la bacteria;Varchar; cSensibilidad;Lista de abreviaturas de antibioticos;Text; cResistencia:Lista de abreviaturas de resistencias;Text;

tCultivoPB:

cBacteria;Nombre de la bacteria;Varchar; cSensibilidad;Lista de abreviaturas de antibioticos;Text; cResistencia:Lista de abreviaturas de resistencias;Text;

tCultivoEsputo:

cBacteria;Nombre de la bacteria;Varchar; cSensibilidad;Lista de abreviaturas de antibioticos;Text; cResistencia:Lista de abreviaturas de resistencias;Text;

tCultivoLCR:

cBacteria;Nombre de la bacteria;Varchar; cSensibilidad;Lista de abreviaturas de antibioticos;Text; cResistencia:Lista de abreviaturas de resistencias;Text;