db schema fix
configuration fix
organize views & apis