made final adjustments to the sql and table design based on feedback
from Dylan doubled checked it against the ERD and should be near perfect