created preliminary database structure and views