Generally, Do Child Tables need Primary Key?
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).
TRANSACTIONS aka JOURNAL
TRANSACTION LINE ITEMS aka LEDGER