chest tube stopcock

pre: sql add foreign key constraint
next: giving away stuff for free