add snapshot db design