db schema and photos