Radicore Forum: How To » many to many and field names

Home » RADICORE » How To » many to many and field names

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

many to many and field names [message #521]

Thu, 04 January 2007 11:10

interop
Messages: 45
Registered: October 2006

Member

The convention here is that all primary keys are named 'id' (1 pk per table) and all foreign keys are named <tablename>_id.

Unless I'm missing something this convention looks to create a lot of extra work for me. In particular in the list2 transactions.

e.g. if I have the following tables: group, group_employee,
and employee where group_employee is the link table between group and employee. when I want to do a list2 employees of a particular group I have to modify the where clause in the _cm_pre_getData function and change 'id' to 'group_id'. Then it doesn't look like I can display groups of a particular employee because how do I know to change 'id' to 'employee_id' or 'group_id'?

So, My question: Is this convention going to cause me too many problems or did I miss something?
p.s. Changing the convention is not a problem- so if you recommend that let me know.
thanks

Report message to a moderator

[Message index]

		many to many and field names By: interop on Thu, 04 January 2007 11:10
		Re: many to many and field names By: AJM on Thu, 04 January 2007 13:25

Previous Topic:	displaying many to many relationships
Next Topic:	List with pre-defined search active

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jul 10 21:15:48 EDT 2025

Total time taken to generate the page: 0.08743 seconds