Quote Originally Posted by lat9 View Post
The issue has absolutely nothing to do with whether a database table uses customer_id or customers_id as its customer-index;
Yes... that's correct, of course... what matters is that an execute command in any PHP needs to reference the exact table and field labels. They could be called anything - even "fried_fish_cakes" will do. As long as it all matches up.

My point is more about field-labelling "consistency". Given that in many instances, in the tables, there needs to be relational cross-referencing, and indeed cross-writing of data - so where this relational functionality is evident, field labels ought to be consistently named (surely?)

I'm just inquisitive about why a common field in the tables (customers_id) is now labelled without the "s" in a particular table? Is there a logical (functional) reason for a slightly different label?

I don't know if there is any relational activity in writing to the products_notifications table for this particular field... perhaps I'm just splitting hairs...