First of all, I applaud you for sharing your theory (and effort) related to design standardization such that it will permit automated code generation. I am also developing a custom framework because I do not believe the existing models and tools go far enough in some areas and because of some custom requirements in our business model. I guess that means I am re-inventing the wheel on a massive scale but the ROI is there for us.

For object (table, view, proc, etc) naming conventions you might consider using schemas instead of Hungarian notation. I realize not all RDBMSs support schemas equally but we sure take advantage of them in our SQL2008 environment.

I look forward to reading your future posts in this regard.