
Set ‘Prefix primary keys with table name’ to yes.

Simple table TEST with NAME field and audit cols.

ID col gets set correctly with table name - TEST_ID.
Check/set for ID in trigger does not have the prefix, only the column name ID.

Not a big deal with one table. I have a model with 20 tables and it's a very big deal to have to fix up the triggers.