use parent table PK for foreign fields, field for linktables