I was wondering if you can give me an advice in creating a table for tooth information?
I have here an image : http://i51.tinypic.com/2yzcvh2.png
The dentist choose the number of the said tooth that needs medication/repair/etc. I'm thinking of it as a checkbox in the layout.
I'm confused on what to do in the tables. So far I have these fields in my mind
tooth_table
- ..patient_id [fk]
..name[fk]
..last_visit[fk]
Can you help me?
One possible approach (syntax: table_name: column1, column2, ...):
patients: id, name, ...
visits: id, partient_id, last_visit, ...
teeth_actions: id, patient_id, tooth_id, count, type, note, ...
teeth: id, name, ...
I'm not a medic so I'm not sure if all the teeth have some latin names or something... But it's good to have the teeth numbered and marked, not only on a picture.
Please specify further your question if something's not clear in this ;)