ran machine learning on all extant ptf subs and finished setting up db schema. amazon EB RDS now functional and ports open to all traffic.