I have 3 tables. 2 child and 1 parent.
The child tables have foreign keys that reference the parent.
I assume(and tell me if I am wrong) that the foreign keys in the child tables(which also serve as Primary keys in these table) should not be set to auto-increment
since their values will be taken from the parent table.
Am I right?