So I'm thinking rather than re-invent the wheel I would see what others have concocted (or are using) that allows their organization to manage Permits.
We have a permitting database but it's not GIS friendly and we are building a LIVE Permit Map... well, I am... and I need to work with our DB guys and develop a schema to use. We will port in the data hourly and TRUNCATE and APPEND in order to go from Oracle to our SQL Server GIS DB.
I'm looking for any preconstructed schemas for permitting so I can see what people are using that work already.
I REALLY wish the LGM had a Permitting section.