revise DB design sketch and add flatfile resources