Joined: Sun Mar 19, 2006 3:13 pm Posts: 123 Location: English Indiana, USA
|
I am noticing something very peculiar in the mysql database for A2billing. It appears there are no naming convention being followed when it comes to adding ID fields from other tables.
in table cc_did = I find iduser instead of id_user or user_id which seems it would be the a normal naming standard.
cc_didgroup we find iduser instead of id_user or user_id
in cc_iax_buddies I find a field called id_cc_card with the ID in front which is normal way it is done in a2b
but in cc_invoice_history I find a field called invoiceid instead or the normal pattern in a2b I would expect, which would be either invoice_id or id_invoice (which is the way its most commonly done in a2b )if there were some naming convention being followed.
In some tables like cc_logpayment there is a field called card_id and in other tables like cc_sip_buddies and cc_speeddial we have it named id_cc_card. In my opinion all these tables that has a field in them that refer to the id field in the cc_card table or other tables for that matter should all have the same name and not be so inconsistent. I know this is just a minor thing and I am not trying to be a whiner. I am really courious as to why it is this way. If there a reason for it? Can someone please explain this to me.
I am making some modification to A2b which are very useful and if others also agree then maybe would be nice if they make their way into a2b. With this in mind I want to make sure when adding features I follow all the rules or methods currently being used in a2billing.
When adding a new table that will contain an Id from another table which is better I put the ID infront or behind the tables names. For instance I am trying to make a2b more reseller friendly so I am putting a user or reseller stamp in almost every table. This will log which user made what record and allow for filtering records so a reseller or user can only access records they created or records like CDRs for card accounts they created.
So what should I name this field id_user or user_id or iduser or userid?
|
|