Make sure we define everything that we're inserting prior to the insert to avoid integrity constraints.