If you really want to see the structure, the simplest way is to grab a backup of the database and restore it to a new SQL server instance, so you can...
My experience back in more commercial environments was that businesses, sites, and sometimes individual users, often land up using a mixture of date...
