You are going to have to either provide the parent tables with the necessary rows so that the constraints can be validated or use the tables with disabled/removed constraints.