BATCH_JOB_PARAMS: primary key

[Devadasan]

Hi,
I read your philosophy on not having a primary key on this table.
But is it correct?
In our application, transaction tables like this always have a (surrogate) primary key.
Thoughts?

[Dave Syer]

Feel free to add a primary key if you wish. The natural key is (JOB_INSTANCE_ID,KEY_NAME). If you have an auto-incrementing platform you can also use a surrogate key if you wished. We never claim that the DDL samples we provide are perfect, or adequate for all purposes, but they work and are at least a good starting point.