updated API db diagram