related part and job models and more styling on database views