Adding the user id into its relation tables with using dataAsssist
Thank you for your help.
1. Do I need to add in a user id as a primary key, as a foreign key or just another column?
2. I have already does this using foreign keys but I am fairly new to mysql so I am not sure if this will work.
If a user register's and then logs in they will have a user id unqiue to them.
There it is a question of specially how I use data assist to insert for example a listing record, so that from the users point of view the record is populated with a new unique listing id, and their user id.
Therefore from a dataAssist point of view when a clicks on add a listing how I populate the listing with their user id.
Secondly for example when they click update, or delete listing, I use data assist to create the update/delete page, but ensure is only brings back the record with the user id of the current session??
Is that descriptive enough? Or sufficient from the point of view of interactivity with the user. I suppose you can liken this example to a shopping cart in eCart where users can only create, update, delete and search on their orders.
So I think of tables 3 and 6 to 10 as different order types in different order tables that a customer may enter.
Thank you very much, your time and help is greatly appreciated.