| Package | Description | 
|---|---|
| org.jooq | 
 The  
org.jooq package contains jOOQ's public API. | 
| org.jooq.impl | 
 The  
org.jooq.impl package contains jOOQ's implementation classes. | 
| Modifier and Type | Method and Description | 
|---|---|
List<ForeignKey<?,R>> | 
UniqueKey.getReferences()
A list of all  
ForeignKeys, referencing this
 UniqueKey | 
List<ForeignKey<R,?>> | 
Table.getReferences()
Get the list of  
FOREIGN KEY's of this table | 
<O extends Record> | 
Table.getReferencesFrom(Table<O> other)
Get a list of  
FOREIGN KEY's of a specific table, referencing
 a this table. | 
<O extends Record> | 
Table.getReferencesTo(Table<O> other)
Get a list of  
FOREIGN KEY's of this table, referencing a
 specific table. | 
| Modifier and Type | Method and Description | 
|---|---|
void | 
SelectQuery.addJoinOnKey(TableLike<?> table,
            JoinType type,
            ForeignKey<?,?> key)
Joins the existing table product to a new table using a foreign key. 
 | 
<O extends TableRecord<O>> | 
UpdatableRecord.fetchChild(ForeignKey<O,R> key)
Fetch a child record of this record, given a foreign key. 
 | 
<O extends TableRecord<O>> | 
UpdatableRecord.fetchChildren(ForeignKey<O,R> key)
Fetch child records of this record, given a foreign key. 
 | 
<O extends TableRecord<O>> | 
Result.fetchChildren(ForeignKey<O,R> key)
Fetch child records of this record, given a foreign key. 
 | 
<O extends UpdatableRecord<O>> | 
TableRecord.fetchParent(ForeignKey<R,O> key)
Fetch a parent record of this record, given a foreign key. 
 | 
<O extends UpdatableRecord<O>> | 
Result.fetchParents(ForeignKey<R,O> key)
Fetch parent records of this record, given a foreign key. 
 | 
TableOnConditionStep<R> | 
TableOnStep.onKey(ForeignKey<?,?> key)
Join the table on a non-ambiguous foreign key relationship between the
 two joined tables. 
 | 
SelectJoinStep<R> | 
SelectOnStep.onKey(ForeignKey<?,?> key)
Join the table on a non-ambiguous foreign key relationship between the
 two joined tables. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
static <R extends Record,U extends Record> | 
Internal.createForeignKey(UniqueKey<U> key,
                Table<R> table,
                String name,
                TableField<R,?>... fields)
Factory method for foreign keys. 
 | 
static <R extends Record,U extends Record> | 
AbstractKeys.createForeignKey(UniqueKey<U> key,
                Table<R> table,
                String name,
                TableField<R,?>... fields)
Deprecated. 
 
- [#6875] [#7158] - 3.11.0 - Please re-generate your code 
 | 
static <R extends Record,U extends Record> | 
Internal.createForeignKey(UniqueKey<U> key,
                Table<R> table,
                TableField<R,?>... fields)
Factory method for foreign keys. 
 | 
static <R extends Record,U extends Record> | 
AbstractKeys.createForeignKey(UniqueKey<U> key,
                Table<R> table,
                TableField<R,?>... fields)
Deprecated. 
 
- [#6875] [#7158] - 3.11.0 - Please re-generate your code 
 | 
| Modifier and Type | Method and Description | 
|---|---|
List<ForeignKey<R,?>> | 
CustomTable.getReferences()  | 
| Modifier and Type | Method and Description | 
|---|---|
static Name | 
Internal.createPathAlias(Table<?> child,
               ForeignKey<?,?> path)
Factory method for path aliases. 
 | 
<O extends TableRecord<O>> | 
UpdatableRecordImpl.fetchChild(ForeignKey<O,R> key)  | 
<O extends TableRecord<O>> | 
UpdatableRecordImpl.fetchChildren(ForeignKey<O,R> key)  | 
<O extends UpdatableRecord<O>> | 
TableRecordImpl.fetchParent(ForeignKey<R,O> key)  | 
| Constructor and Description | 
|---|
TableImpl(Name name,
         Schema schema,
         Table<?> child,
         ForeignKey<?,R> path,
         Table<R> aliased,
         Field<?>[] parameters,
         Comment comment)  | 
TableImpl(Table<?> child,
         ForeignKey<?,R> path,
         Table<R> parent)  | 
Copyright © 2019. All rights reserved.