refactor(database): reorganize database scripts and examples into docs directory

refactor(database): consolidate shared database base and fix foreign key schema references