nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DD 6.0.2 - Foreign Key question

Adam Stoller

DD 6.0.2

We've got a situation in which some of the tables defined in our DB have sort of a self-referential foreign key - e.g.:

Col1	Col2	...
A-Val-1	A-Val-2	...
A-Val-2		...
A-Val-3	A-Val-1	...

Some entries in Col2 refer to records that have the same value in Col1. Both columns might also act as Primary Keys.

When I go to write the config for this - should I specify that Col2 is a "foreign-key" but have the table reference be the current table? Or should I not mention it as a foreign-key for DD at all (and assume that the use of it as a foreign-key is handled by whatever else utlizes the DB)?

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com

Find more posts tagged with

Comments

Migrateduser

In the database world, can you create an FK for a table, using the same table as a parent?

The foreign key is supposed to refer to a "parent" table, not itself. That's why it a "foreign key". Wouldn't there be all kinds of cascading effects when you try to delete something.

At any rate, DD won't be happy with that in your dbschema.

Mariam

Adam Stoller

I can't speak for the DB world - the person I'm working with seems to believe it's fairly standard (my sample may have been flawed in that there probably are NOT circular dependencies) - they have a constraint that requires 2nd column's data to have been inserted in the 1st column position before you can have a reference to it in the 2nd column.

I'll probably just list them as primary keys and not try to do the self-reference in the config files - and see what happens .... however, my DD config work is still on hold while I'm doing other stuff right now - hopefully tomorrow or Monday I'll get to try all this stuff out.

Thanks.

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com