Announcement Announcement Module
Collapse
No announcement yet.
BATCH_JOB_PARAMS: primary key Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • BATCH_JOB_PARAMS: primary key

    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?

  • #2
    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.

    Comment

    Working...
    X