SEO

#1 (**permalink**) 02-28-2008, 09:47 AM

Can one add some extra data into the link table on a many to many join.

Have a group table and a member table and a link table. Want to add a
'title' column but the only current table it could go in would be the
link table. Ok, or no?

TIA

#2 (**permalink**) 02-28-2008, 09:47 AM

user wrote:
> Can one add some extra data into the link table on a many to many join.

Sure you could do that, if you want.

--

//Aho

#3 (**permalink**) 02-28-2008, 09:47 AM

On Fri, 11 May 2007 06:07:59 +0200, "J.O. Aho" <user@example.net>
wrote:

>user wrote:
>> Can one add some extra data into the link table on a many to many join.
>
>Sure you could do that, if you want.

I would add that from a design point of view, you have very often many
to many tables that have this function (among others) even if they
don't get the name directly. If you want to add some columns in your
M2M table, maybe it's worth considering that it is more than a simple
M2M table, and give it a proper name regarding what it contains.

In your case, you could name it "title", for example. It is then,
conceptually, more than a simple M2M table, but represents a whole
concept within your model.

Sometimes, you need only a M2M, with the 2 primary keys. it's then ok
to call il M2MFooBar. But if it does something more, try to get a name
for it, it might help you tidying your idea of what your DB
represents.

#4 (**permalink**) 02-28-2008, 09:48 AM

Subtenante,

Thanks for the thoughts. I have since determined that a member can have
more than one title so I will be adding an additional table.

Regards

subtenante wrote:

> On Fri, 11 May 2007 06:07:59 +0200, "J.O. Aho" <user@example.net>
> wrote:
>
>
>>user wrote:
>>
>>>Can one add some extra data into the link table on a many to many join.
>>
>>Sure you could do that, if you want.
>
>
> I would add that from a design point of view, you have very often many
> to many tables that have this function (among others) even if they
> don't get the name directly. If you want to add some columns in your
> M2M table, maybe it's worth considering that it is more than a simple
> M2M table, and give it a proper name regarding what it contains.
>
> In your case, you could name it "title", for example. It is then,
> conceptually, more than a simple M2M table, but represents a whole
> concept within your model.
>
> Sometimes, you need only a M2M, with the 2 primary keys. it's then ok
> to call il M2MFooBar. But if it does something more, try to get a name
> for it, it might help you tidying your idea of what your DB
> represents.

#5 (**permalink**) 02-28-2008, 09:48 AM

J.O.

Thanks

J.O. Aho wrote:

> user wrote:
>
>>Can one add some extra data into the link table on a many to many join.
>
>
> Sure you could do that, if you want.
>
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode