On Friday 20 October 2006 15:15, Richard Hosking wrote:

> Here is my humble effort for a DB schema based on the recent discussions
> No doubt there are some ways of improving it - I would be interested in
> comments
> I will put it up on the Wiki also
I have changed the Wiki version to follow the Rails Migrations system, which 
is how the appointments application is written thus far.

I have followed Richard's layout with one exception: I've added a 
table 'accounts', which matches patients to payors, and then links
to invoices. This simplifies things as it saves having 
separate 'medicare_number', 'dva_number', 'workcover_number' columns on the 
patients table, and will simplify the controller code.

Ian

Attachment: 023_billing.rb
Description: application/ruby

Attachment: pgpnKtCfqOu3f.pgp
Description: PGP signature

_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk

Reply via email to