> We're moving into a phase of development for a small business
> (optical/optometric) clinic management software package where we need to
> design a critical interface for our product to do Inventory closely tied to
> a second module where we create a 'dispensary' where they clinic staff can
> sell products (frames, lenses, lens addons (tints, coatings, etc.),
> contacts, cleaning supplies, prescription sunglasses, t-shirts, caps. )
>
>
>
> We figured someone out there must already have an ERD for this kind of setup
> and we could save time/effort redesigning the wheel if we asked around if
> anyone knew of a source for such diagrams.
>
>
>
> We know this is a support service, but we haven't been able to find a live
> community forum (not that honestly we've had much time to search it out) If
> this message is too far off topic please let me know and it won't happen
> again.

A collection of data models is available here:
http://www.databaseanswers.org/data_models/index.htm

Don't know if they fit into your situation.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com