- according to the updated M1 schema some attribute are not refered to as foreign key when they are
- foreign key constraints in the tables make it dificult to clear the tables
- in X it asks for a procedure to output a table when a TVfunction would better suit the job