| Package | Description | 
|---|---|
| org.jooq | The  org.jooqpackage contains jOOQ's public API. | 
| org.jooq.impl | The  org.jooq.implpackage contains jOOQ's implementation classes. | 
| Modifier and Type | Method and Description | 
|---|---|
| TableField<R,T> | Identity. getField()The  IDENTITYcolumn. | 
| TableField<R,?>[] | Key. getFieldsArray()The fields that make up the  KEY | 
| TableField<R,? extends Date> | Table. getRecordTimestamp()A "timestamp" field holding record timestamp information used for
 optimistic locking
 
 jOOQ supports optimistic locking in  UpdatableRecord.store()andUpdatableRecord.delete()ifSettings.isExecuteWithOptimisticLocking()is enabled. | 
| TableField<R,? extends Number> | Table. getRecordVersion()A "version" field holding record version information used for optimistic
 locking
 
 jOOQ supports optimistic locking in  UpdatableRecord.store()andUpdatableRecord.delete()ifSettings.isExecuteWithOptimisticLocking()is enabled. | 
| Modifier and Type | Method and Description | 
|---|---|
| List<TableField<R,?>> | Key. getFields()The fields that make up the  KEY | 
| Modifier and Type | Method and Description | 
|---|---|
| void | SelectQuery. addJoinOnKey(TableLike<?> table,
            JoinType type,
            TableField<?,?>... keyFields)Joins the existing table product to a new table using a foreign key. | 
| TableOnConditionStep | TableOnStep. onKey(TableField<?,?>... keyFields)Join the table on a non-ambiguous foreign key relationship between the
 two joined tables. | 
| SelectJoinStep<R> | SelectOnStep. onKey(TableField<?,?>... keyFields)Join the previous table on a non-ambiguous foreign key relationship
 between the two joined tables. | 
| Modifier and Type | Method and Description | 
|---|---|
| protected static <R extends Record,U extends Record> | AbstractKeys. createForeignKey(UniqueKey<U> key,
                Table<R> table,
                TableField<R,?>... fields)Factory method for foreign keys | 
| protected static <R extends Record,T> | AbstractKeys. createIdentity(Table<R> table,
              TableField<R,T> field)Factory method for identities | 
| protected static <R extends Record> | AbstractKeys. createUniqueKey(Table<R> table,
               TableField<R,?>... fields)Factory method for unique keys | 
Copyright © 2015. All Rights Reserved.