hello,
I am a surgeon and responsible for our "bonebank". This would sound a little weird for some of you but this is the reuse of femoral heads from our total hip prosthesis patients in other patients.
I am setting up a database for this. I have created it using 3 tables and linked the three relationally. But, is this the right way ?
I need these fields:
Information on the graft: size, prelevation date, serological tests OK, etc.
Info on donor: name, number, birthdate, sex, etc.
Info on acceptor: name, number, birthdate, sex, etc.
Each graft comes from a donor. A donor can only deliver 2 grafts since he's only got 2 hips. A donor can receive a graft from another donor, so a donor can be an acceptor as well. The other way round is also true: an acceptor can be a donor as well.
This means that the same donor will maximum appear two times in my graftlist.
Right now i've made tables: grafts, donors, acceptors and put a donorID and acceptorID field in the grafts table and linked it to the donorID field in the donor table en acceptorID field in the acceptor table.
I think i could make two tables: grafts, patients since i can link the field donorID in grafts to donorID or acceptorID in the patients table.
Is this a good idea or should I just make one table with all the information in ?
What do you think ?
Thank you for your help!
Olivier
I am a surgeon and responsible for our "bonebank". This would sound a little weird for some of you but this is the reuse of femoral heads from our total hip prosthesis patients in other patients.
I am setting up a database for this. I have created it using 3 tables and linked the three relationally. But, is this the right way ?
I need these fields:
Information on the graft: size, prelevation date, serological tests OK, etc.
Info on donor: name, number, birthdate, sex, etc.
Info on acceptor: name, number, birthdate, sex, etc.
Each graft comes from a donor. A donor can only deliver 2 grafts since he's only got 2 hips. A donor can receive a graft from another donor, so a donor can be an acceptor as well. The other way round is also true: an acceptor can be a donor as well.
This means that the same donor will maximum appear two times in my graftlist.
Right now i've made tables: grafts, donors, acceptors and put a donorID and acceptorID field in the grafts table and linked it to the donorID field in the donor table en acceptorID field in the acceptor table.
I think i could make two tables: grafts, patients since i can link the field donorID in grafts to donorID or acceptorID in the patients table.
Is this a good idea or should I just make one table with all the information in ?
What do you think ?
Thank you for your help!
Olivier
Comment