modified erd, dropped list_user table - unnecessary