I used to build stuff this way loooooong time ago.

I would advice the author to look in to ORM products (that many are free) which contain MANY specifications and build everything posted here (and much more) from XML description files.

Just my $0.02

BTW my objections are only two:

- Please do NOT use Hungarian for database objects

- There is nothing wrong with not distinguishing between view and table in fact that is the point of using views.

Other than that I think people enrich their knowledge by observing different approaches to the same problem.