updated db schema and system overview