Does the order I declare foreign key constraints in matter?
The order of FK Definition does not matter. When a transaction on table with FKs completes, it will release the lock on referenced tables simultaneously.