modified tables, validations, and queries