update schema & seed
preliminary api spec