AnsweredAssumed Answered

Generally, Do Child Tables need Primary Key?

Question asked by eibcga on Jun 26, 2010
Latest reply on Jun 29, 2010 by LaRetta_1

Title

Generally, Do Child Tables need Primary Key?

Post

Do you recommend that a Child table have a primary key field?  I have a child table with a foreign key field that links to the parent key in the Parent Table in a one-to-many relationship.

 

For example, I have a database that tracks financial transactions.  The JOURNAL (a Child Table) has a primary key field added to it (auto-enter serial), but I'm not sure it will be required (since I don't foresee it ever relating to a foreign key in another table in the future).

 

Tables:

NAMES

TRANSACTIONS aka JOURNAL

TRANSACTION LINE ITEMS aka LEDGER

ACCOUNTS

 

thanks

 

 

 

 

Outcomes