gutiersa wrote on Tuesday, October 28, 2008:
The state New Jersey has recently passed a law requiring scripts to have serial numbers.
I was thinking that I can modify openemr to print the prescriptions_id field onto the prescription, and that could be my serial number. However, I noticed that mysql does not auto index the prescriptions table consecutively, and in time my serial numbers could get to be very long.
I’m not sure how to address this issue.
Is there a way to change the way mysql auto indexes the prescriptions table?
If so, would it interfere with openemr?
Or should I create a new field that would contain the serial number and have it be assigned automatically?
I would appreciate any input.