...
The naming conventions follow the type of structure that we are using for this database (star/snowflake schema), so ignore "_dim" in the names, and the "required," "PK or FK" and "FK Referenced Table" columns!
The person, location, source, and physical source tables will occur for every record in the database. Then, the rest of the tables (until activity_fact) are the possible activities a person can be involved with. The activity_fact table connects everything!
Please comment on other attributes that could be included or any description edits, or anything else that should be taken out!
Data dictionary in Word doc format
(This is difficult to look at but if you would like, please leave comments!)
(Please put comments on this Wiki page, while viewing this document!)