151 reputation
4
bio website glatelier.org
location La Serena, Chile
age 28
visits member for 2 years
seen Jul 20 at 3:27

merge keep


Jul
13
comment Help with database design with a strict and structured subset of clinical data
Well, I think I'll consider using a relational database since data itself it's very easy to enter, and most of it are "true/false", or just plain integers. I don't think we are going to be dealing with enormous amounts of data anyway, and consistency it's not a life-death matter. Right now, people here are counting big papers with the data written by hand, which is cumbersome. That's the problem we are trying to solve.
Jul
13
comment Help with database design with a strict and structured subset of clinical data
It has both, but it has more write than read data. I basically want to add different "encounters" to each patient. From time to time (each 2 or 3 months), we need to know how many diabetic patients we have, or how many patients with less than certain value of blood pressure do we have. Is that what you were asking or I misunderstood the question?
Mar
26
comment How to data model more than one 'last name'?
I like your answer. I don't understand though how this can help me to put names. I need to sort them for example, we normally use last name. How putting them on a field/column called "other names" or "display name" could help me with that for example?. Kudos for the burmese name, though. Awesome.
Mar
26
comment How to data model more than one 'last name'?
I like the idea as a concept, but it isn't a bit hard to present it to the user that it's gonna write the actual name? The only thing I can come up it's something like "GMail" contact fields, that let's you "add" parts of the name. Have you thought on how you can actually use that kind of data model?
Mar
26
comment How to data model more than one 'last name'?
@asfallows: because if we print a patient list we need to sort them by the last name. For example, if your name is "José Carlos Fernando Almodóvar Soto", how am I supposed to know in advance that "Almodóvar" it's the first last name?
Mar
26
comment How to data model more than one 'last name'?
My 'first' last name is "Olmos de Aguilera", which is a "compound last name" (apellido compuesto). The problem here is that we use it both. Thanks for the suggestion though.
Mar
26
comment How to data model more than one 'last name'?
No it doesn't matter. It's important though (I added a link giving some insights). Here everyone uses both last names, and we rarely use our middle name (or "second name" [literal translation]). We also don't use terms like "Jr.", therefore just by looking at the names you don't have a chance to differentiate between two "Pedro Pérez". It's also useful, when looking through family members (our primary health care is focused on familiar medicine [I dunno if that concept exists in english]).