Primary Keys

The primary key used in JADE tables is OID for overwrite tables.

The default primary keys for historical tables are oid, _edition, _operation, and _tranid. You can add _timestamp as a primary key for historical tables, either in addition to or as a substitute for _tranid. The key order is as follows.

[_tranid], [_timestamp], [oid], [_edition], [_operation]

You can specify an alternative primary key for No Delete tables in the Relational Population Service wizard. For details, see "Mapping Classes to Tables" under "Maintaining RPS Column Mappings", in Chapter 15 of the JADE Development Environment User’s Guide.