> we should not use foreign keys

Not using foreign key constraints is a good idea. Occasionally. Very occasionally.