make API ref and db plans