Hi,
I am using version 4.0.3464 (with hotfix applied). I have followed the steps you described and the fields Created by, Last modified and Owner are filled correctly with user name "Mia Lee". There must be problem in your installation somewhere. Could you please send us export site package to our support e-mail? Thank you.
Regarding the relations - the Content tables - these are the coupled data tables. you can see the relations in
Content management internals document.
Regarding the DB reference, the possible problems with it are described
here under the list of documents and also in our
FAQs. I hope it will help.
Best Regards,
Juraj Ondrus