http://timv.livejournal.com/ (
timv.livejournal.com
) wrote
in
jackofallgeeks
2004-03-25 09:13 pm (UTC)
no subject
Like this??
PATIENTS
patient_id
[other fields]
DOCTORS
doctor_id
[other fields]
EXAMS
exam_id
doctor_id
patient_id
[other fields]
Having set them up as such, you allow easy access by doctor, or by patient. Additionally, you avoid replicating patient and doctor data. Makes perfect sense to me...for whatever that is worth. If he marks it wrong, what are you going to do?
(
8 comments
)
Post a comment in response:
From:
Anonymous
This account has disabled anonymous posting.
OpenID
Identity URL:
Log in?
Dreamwidth account
Account name
Password
Log in?
If you don't have an account you can
create one now
.
Subject
HTML doesn't work in the subject.
Formatting type
Casual HTML
Markdown
Raw HTML
Rich Text Editor
Message
[
Home
|
Post Entry
|
Log in
|
Search
|
Browse Options
|
Site Map
]
no subject
PATIENTS
patient_id
[other fields]
DOCTORS
doctor_id
[other fields]
EXAMS
exam_id
doctor_id
patient_id
[other fields]
Having set them up as such, you allow easy access by doctor, or by patient. Additionally, you avoid replicating patient and doctor data. Makes perfect sense to me...for whatever that is worth. If he marks it wrong, what are you going to do?